db.log.2021-05-25
7.15 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
[2021-05-25 20:05:32] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log;
[2021-05-25 20:05:32] ERROR [db_logger.insertIntoApiCallLog:110]:: Traceback (most recent call last):
File "/Users/nhn/Desktop/capstone/testMonitoring/common/testDB.py", line 98, in insertIntoApiCallLog
% (url, calcIPValue(src_ipaddr_str), src_ipaddr_str, method, result.get('code'), result.get('message'), response_time))
NameError: global name 'calcIPValue' is not defined
[2021-05-25 20:07:41] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log;
[2021-05-25 20:07:41] ERROR [db_logger.insertIntoApiCallLog:110]:: Traceback (most recent call last):
File "/Users/nhn/Desktop/capstone/testMonitoring/common/testDB.py", line 98, in insertIntoApiCallLog
% (url, ip, method, result.get('code'), result.get('message'), response_time))
TypeError: not enough arguments for format string
[2021-05-25 20:09:18] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log;
[2021-05-25 20:09:18] INFO [db_logger.executeQuery:55]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/getTest/', 127.0.0.1, 'GET', '200', 'OK', '21');
[2021-05-25 20:09:18] ERROR [db_logger.executeQuery:59]:: Traceback (most recent call last):
File "/Users/nhn/Desktop/capstone/testMonitoring/common/testDB.py", line 56, in executeQuery
row = cursor.execute(query)
File "/Users/nhn/.pyenv/versions/testVirenv/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/Users/nhn/.pyenv/versions/testVirenv/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.0.1, 'GET', '200', 'OK', '21')' at line 1")
[2021-05-25 20:09:18] ERROR [db_logger.executeQuery:60]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/getTest/', 127.0.0.1, 'GET', '200', 'OK', '21');
[2021-05-25 20:09:18] ERROR [db_logger.insertIntoApiCallLog:110]:: Traceback (most recent call last):
File "/Users/nhn/Desktop/capstone/testMonitoring/common/testDB.py", line 99, in insertIntoApiCallLog
row = self.executeQuery(cursor, query)
File "/Users/nhn/Desktop/capstone/testMonitoring/common/testDB.py", line 61, in executeQuery
raise TestDBException(-1, "TestDBException: cannot execute query(%s)" %(query))
TypeError: __init__() takes exactly 2 arguments (3 given)
[2021-05-25 20:09:43] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log;
[2021-05-25 20:09:43] INFO [db_logger.executeQuery:55]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/getTest/', '127.0.0.1', 'GET', '200', 'OK', '27');
[2021-05-25 20:14:43] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log;
[2021-05-25 20:14:43] INFO [db_logger.executeQuery:55]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/getTest/', '127.0.0.1', 'GET', '200', 'OK', '28');
[2021-05-25 20:14:45] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log;
[2021-05-25 20:14:45] INFO [db_logger.executeQuery:55]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/getTest/', '127.0.0.1', 'GET', '200', 'OK', '8');
[2021-05-25 20:14:45] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log;
[2021-05-25 20:14:45] INFO [db_logger.executeQuery:55]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/getTest/', '127.0.0.1', 'GET', '200', 'OK', '3');
[2021-05-25 20:15:57] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log;
[2021-05-25 20:15:57] INFO [db_logger.executeQuery:55]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/tests/monitoringGetTest', '127.0.0.1', 'GET', '200', 'OK', '22');
[2021-05-25 20:17:16] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log;
[2021-05-25 20:17:16] INFO [db_logger.executeQuery:55]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/tests/monitoringGetTest', '127.0.0.1', 'GET', '200', 'OK', '14');
[2021-05-25 20:17:16] INFO [db_logger.executeQuery:55]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/tests/monitoringGetTest', '127.0.0.1', 'GET', '500', 'Internal Server Error', '36');
[2021-05-25 20:23:03] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log;
[2021-05-25 20:23:03] INFO [db_logger.executeQuery:55]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/tests/monitoringGetTest', '127.0.0.1', 'GET', '200', 'OK', '27');
[2021-05-25 20:37:29] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log;
[2021-05-25 20:37:29] INFO [db_logger.executeQuery:55]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/tests/monitoringPostTest', '127.0.0.1', 'POST', '200', 'OK', '17');
[2021-05-25 20:37:38] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log;
[2021-05-25 20:37:38] INFO [db_logger.executeQuery:55]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/tests/monitoringDeleteTest', '127.0.0.1', 'DELETE', '200', 'OK', '10');
[2021-05-25 20:37:45] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log;
[2021-05-25 20:37:45] INFO [db_logger.executeQuery:55]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/tests/monitoringPutTest', '127.0.0.1', 'PUT', '200', 'OK', '3');
[2021-05-25 20:38:32] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log LIMIT 10;
[2021-05-25 20:38:32] INFO [db_logger.executeQuery:55]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/tests/monitoringGetTest', '127.0.0.1', 'GET', '200', 'OK', '17');
[2021-05-25 20:38:59] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log LIMIT 10;
[2021-05-25 20:38:59] INFO [db_logger.executeQuery:55]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/tests/monitoringGetTest', '127.0.0.1', 'GET', '200', 'OK', '20');
[2021-05-25 20:40:35] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log LIMIT 10;
[2021-05-25 20:40:35] INFO [db_logger.executeQuery:55]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/tests/monitoringGetTest', '192.168.0.49', 'GET', '200', 'OK', '21');
[2021-05-25 20:41:54] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log LIMIT 10;
[2021-05-25 20:41:54] INFO [db_logger.executeQuery:55]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/tests/monitoringGetTest', '192.168.0.50', 'GET', '200', 'OK', '2');
[2021-05-25 20:42:11] INFO [db_logger.executeQuery:55]:: SELECT * FROM api_call_log LIMIT 10;
[2021-05-25 20:42:11] INFO [db_logger.executeQuery:55]:: INSERT INTO api_call_log (url, ip, method, ret_code, ret_message, response_time) VALUES ('/tests/monitoringGetTest', '192.168.0.50', 'GET', '200', 'OK', '1');