01/14/2021 05:55:56 PM INFO ai callback add group logger service started at 2021-01-14 17:55:56 01/14/2021 06:04:52 PM INFO ai callback add group logger service started at 2021-01-14 18:04:52 01/14/2021 06:06:06 PM INFO ai callback add group logger service started at 2021-01-14 18:06:06 01/14/2021 06:06:44 PM INFO ai callback add group logger service started at 2021-01-14 18:06:44 01/14/2021 06:08:20 PM INFO ai callback add group logger service started at 2021-01-14 18:08:20 01/14/2021 06:09:15 PM INFO ai callback add group logger service started at 2021-01-14 18:09:15 01/14/2021 06:09:19 PM INFO *************************************** NEW REQUEST *************************************** 01/14/2021 06:09:19 PM INFO raw data from request is {'callbackdata': [{'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '9999-99-99', 'code': 0, 'message': '创建成功'}, {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}]} 01/14/2021 06:09:19 PM INFO on single update callback info: {'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '9999-99-99', 'code': 0, 'message': '创建成功'} 01/14/2021 06:09:19 PM ERROR Traceback (most recent call last): File "E:\ai_ads\ai_callback_add_group_handler.py", line 32, in post inst.update_table_info() File "E:\ai_ads\ai_callback_add_group_handler.py", line 66, in update_table_info cursor.execute(sql) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute result = self._query(query) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query conn.query(q) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result result.read() File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1054, "Unknown column 'ab' in 'where clause'") 01/14/2021 06:13:03 PM INFO ai callback add group logger service started at 2021-01-14 18:13:03 01/14/2021 06:13:07 PM INFO *************************************** NEW REQUEST *************************************** 01/14/2021 06:13:07 PM INFO raw data from request is {'callbackdata': [{'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '9999-99-99', 'code': 0, 'message': '创建成功'}, {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}]} 01/14/2021 06:13:07 PM INFO on single update callback info: {'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '9999-99-99', 'code': 0, 'message': '创建成功'} 01/14/2021 06:13:07 PM ERROR Traceback (most recent call last): File "E:\ai_ads\ai_callback_add_group_handler.py", line 32, in post inst.update_table_info() File "E:\ai_ads\ai_callback_add_group_handler.py", line 65, in update_table_info WHERE group_uuid = %s""", (unit_id, unit_create_time, group_uuid)) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 146, in execute query = self.mogrify(query, args) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 125, in mogrify query = query % self._escape_args(args, conn) TypeError: %d format: a number is required, not str 01/14/2021 06:13:50 PM INFO ai callback add group logger service started at 2021-01-14 18:13:50 01/14/2021 06:13:55 PM INFO *************************************** NEW REQUEST *************************************** 01/14/2021 06:13:55 PM INFO raw data from request is {'callbackdata': [{'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '9999-99-99', 'code': 0, 'message': '创建成功'}, {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}]} 01/14/2021 06:13:55 PM INFO on single update callback info: {'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '9999-99-99', 'code': 0, 'message': '创建成功'} 01/14/2021 06:13:55 PM ERROR Traceback (most recent call last): File "E:\ai_ads\ai_callback_add_group_handler.py", line 32, in post inst.update_table_info() File "E:\ai_ads\ai_callback_add_group_handler.py", line 68, in update_table_info WHERE group_uuid = %s""", (unit_id, unit_create_time, group_uuid)) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 146, in execute query = self.mogrify(query, args) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 125, in mogrify query = query % self._escape_args(args, conn) TypeError: %d format: a number is required, not str 01/14/2021 06:14:47 PM INFO ai callback add group logger service started at 2021-01-14 18:14:47 01/14/2021 06:14:51 PM INFO *************************************** NEW REQUEST *************************************** 01/14/2021 06:14:51 PM INFO raw data from request is {'callbackdata': [{'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '9999-99-99', 'code': 0, 'message': '创建成功'}, {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}]} 01/14/2021 06:14:51 PM INFO on single update callback info: {'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '9999-99-99', 'code': 0, 'message': '创建成功'} 01/14/2021 06:14:51 PM ERROR Traceback (most recent call last): File "E:\ai_ads\ai_callback_add_group_handler.py", line 32, in post inst.update_table_info() File "E:\ai_ads\ai_callback_add_group_handler.py", line 68, in update_table_info WHERE group_uuid = %s""", (unit_id, unit_create_time, group_uuid)) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 146, in execute query = self.mogrify(query, args) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 125, in mogrify query = query % self._escape_args(args, conn) TypeError: %d format: a number is required, not str 01/14/2021 06:17:37 PM INFO ai callback add group logger service started at 2021-01-14 18:17:37 01/14/2021 06:17:41 PM INFO *************************************** NEW REQUEST *************************************** 01/14/2021 06:17:41 PM INFO raw data from request is {'callbackdata': [{'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '9999-99-99', 'code': 0, 'message': '创建成功'}, {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}]} 01/14/2021 06:17:41 PM INFO on single update callback info: {'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '9999-99-99', 'code': 0, 'message': '创建成功'} 01/14/2021 06:17:41 PM ERROR Traceback (most recent call last): File "E:\ai_ads\ai_callback_add_group_handler.py", line 32, in post inst.update_table_info() File "E:\ai_ads\ai_callback_add_group_handler.py", line 68, in update_table_info WHERE group_uuid = %s""", (unit_id, unit_create_time, group_uuid)) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute result = self._query(query) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query conn.query(q) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result result.read() File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1292, "Incorrect datetime value: '9999-99-99' for column `jeecg-boot`.`ctop_ai_kuaishou_unit_level_operation_record`.`unit_create_time` at row 1") 01/14/2021 06:18:21 PM INFO *************************************** NEW REQUEST *************************************** 01/14/2021 06:18:21 PM INFO raw data from request is {'callbackdata': [{'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '2021-01-14 18:01:04', 'code': 0, 'message': '创建成功'}, {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}]} 01/14/2021 06:18:21 PM INFO on single update callback info: {'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '2021-01-14 18:01:04', 'code': 0, 'message': '创建成功'} 01/14/2021 06:18:21 PM ERROR on single update callback info: {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'} 01/14/2021 06:19:16 PM INFO ai callback add group logger service started at 2021-01-14 18:19:16 01/14/2021 06:19:19 PM INFO *************************************** NEW REQUEST *************************************** 01/14/2021 06:19:19 PM INFO raw data from request is {'callbackdata': [{'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '2021-01-14 18:01:04', 'code': 0, 'message': '创建成功'}, {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}]} 01/14/2021 06:19:19 PM INFO on single update callback info: {'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '2021-01-14 18:01:04', 'code': 0, 'message': '创建成功'} 01/14/2021 06:19:20 PM ERROR on single update callback info: {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'} 01/14/2021 06:33:05 PM INFO *************************************** NEW REQUEST *************************************** 01/14/2021 06:33:05 PM INFO raw data from request is {'callbackdata': [{'group_uuid': '12-ab', 'unit_id': '7777', 'unit_create_time': '2021-01-14 18:01:04', 'code': 0, 'message': '创建成功'}, {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}]} 01/14/2021 06:33:06 PM INFO on single update callback info: {'group_uuid': '12-ab', 'unit_id': '7777', 'unit_create_time': '2021-01-14 18:01:04', 'code': 0, 'message': '创建成功'} 01/14/2021 06:33:06 PM ERROR on single update callback info: {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'} 01/14/2021 06:33:44 PM INFO *************************************** NEW REQUEST *************************************** 01/14/2021 06:33:44 PM INFO raw data from request is {'callbackdata': [{'group_uuid': '12-ab', 'unit_id': '7777', 'unit_create_time': '2021-01-14 18:01:04', 'code': 0, 'message': '创建成功'}, {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}]} 01/14/2021 06:33:44 PM INFO on single update callback info: {'group_uuid': '12-ab', 'unit_id': '7777', 'unit_create_time': '2021-01-14 18:01:04', 'code': 0, 'message': '创建成功'} 01/14/2021 06:33:44 PM ERROR on single update callback info: {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'} 01/14/2021 06:39:23 PM INFO ai callback add group logger service started at 2021-01-14 18:39:23 01/14/2021 06:39:27 PM INFO *************************************** NEW REQUEST *************************************** 01/14/2021 06:39:27 PM INFO raw data from request is {'callbackdata': [{'group_uuid': '12-ab', 'unit_id': '7777', 'unit_create_time': '2021-01-14 18:01:04', 'code': 0, 'message': '创建成功'}, {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}]} 01/14/2021 06:39:27 PM INFO on single update callback info: {'group_uuid': '12-ab', 'unit_id': '7777', 'unit_create_time': '2021-01-14 18:01:04', 'code': 0, 'message': '创建成功'} 01/14/2021 06:39:27 PM ERROR on single update callback info: {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}