ai_callback_add_group.log 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126
  1. 01/14/2021 05:55:56 PM INFO ai callback add group logger service started at 2021-01-14 17:55:56
  2. 01/14/2021 06:04:52 PM INFO ai callback add group logger service started at 2021-01-14 18:04:52
  3. 01/14/2021 06:06:06 PM INFO ai callback add group logger service started at 2021-01-14 18:06:06
  4. 01/14/2021 06:06:44 PM INFO ai callback add group logger service started at 2021-01-14 18:06:44
  5. 01/14/2021 06:08:20 PM INFO ai callback add group logger service started at 2021-01-14 18:08:20
  6. 01/14/2021 06:09:15 PM INFO ai callback add group logger service started at 2021-01-14 18:09:15
  7. 01/14/2021 06:09:19 PM INFO *************************************** NEW REQUEST ***************************************
  8. 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': '广告组名称重复'}]}
  9. 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': '创建成功'}
  10. 01/14/2021 06:09:19 PM ERROR Traceback (most recent call last):
  11. File "E:\ai_ads\ai_callback_add_group_handler.py", line 32, in post
  12. inst.update_table_info()
  13. File "E:\ai_ads\ai_callback_add_group_handler.py", line 66, in update_table_info
  14. cursor.execute(sql)
  15. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
  16. result = self._query(query)
  17. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
  18. conn.query(q)
  19. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
  20. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  21. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
  22. result.read()
  23. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
  24. first_packet = self.connection._read_packet()
  25. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  26. packet.raise_for_error()
  27. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  28. err.raise_mysql_exception(self._data)
  29. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  30. raise errorclass(errno, errval)
  31. pymysql.err.OperationalError: (1054, "Unknown column 'ab' in 'where clause'")
  32. 01/14/2021 06:13:03 PM INFO ai callback add group logger service started at 2021-01-14 18:13:03
  33. 01/14/2021 06:13:07 PM INFO *************************************** NEW REQUEST ***************************************
  34. 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': '广告组名称重复'}]}
  35. 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': '创建成功'}
  36. 01/14/2021 06:13:07 PM ERROR Traceback (most recent call last):
  37. File "E:\ai_ads\ai_callback_add_group_handler.py", line 32, in post
  38. inst.update_table_info()
  39. File "E:\ai_ads\ai_callback_add_group_handler.py", line 65, in update_table_info
  40. WHERE group_uuid = %s""", (unit_id, unit_create_time, group_uuid))
  41. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 146, in execute
  42. query = self.mogrify(query, args)
  43. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 125, in mogrify
  44. query = query % self._escape_args(args, conn)
  45. TypeError: %d format: a number is required, not str
  46. 01/14/2021 06:13:50 PM INFO ai callback add group logger service started at 2021-01-14 18:13:50
  47. 01/14/2021 06:13:55 PM INFO *************************************** NEW REQUEST ***************************************
  48. 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': '广告组名称重复'}]}
  49. 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': '创建成功'}
  50. 01/14/2021 06:13:55 PM ERROR Traceback (most recent call last):
  51. File "E:\ai_ads\ai_callback_add_group_handler.py", line 32, in post
  52. inst.update_table_info()
  53. File "E:\ai_ads\ai_callback_add_group_handler.py", line 68, in update_table_info
  54. WHERE group_uuid = %s""", (unit_id, unit_create_time, group_uuid))
  55. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 146, in execute
  56. query = self.mogrify(query, args)
  57. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 125, in mogrify
  58. query = query % self._escape_args(args, conn)
  59. TypeError: %d format: a number is required, not str
  60. 01/14/2021 06:14:47 PM INFO ai callback add group logger service started at 2021-01-14 18:14:47
  61. 01/14/2021 06:14:51 PM INFO *************************************** NEW REQUEST ***************************************
  62. 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': '广告组名称重复'}]}
  63. 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': '创建成功'}
  64. 01/14/2021 06:14:51 PM ERROR Traceback (most recent call last):
  65. File "E:\ai_ads\ai_callback_add_group_handler.py", line 32, in post
  66. inst.update_table_info()
  67. File "E:\ai_ads\ai_callback_add_group_handler.py", line 68, in update_table_info
  68. WHERE group_uuid = %s""", (unit_id, unit_create_time, group_uuid))
  69. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 146, in execute
  70. query = self.mogrify(query, args)
  71. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 125, in mogrify
  72. query = query % self._escape_args(args, conn)
  73. TypeError: %d format: a number is required, not str
  74. 01/14/2021 06:17:37 PM INFO ai callback add group logger service started at 2021-01-14 18:17:37
  75. 01/14/2021 06:17:41 PM INFO *************************************** NEW REQUEST ***************************************
  76. 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': '广告组名称重复'}]}
  77. 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': '创建成功'}
  78. 01/14/2021 06:17:41 PM ERROR Traceback (most recent call last):
  79. File "E:\ai_ads\ai_callback_add_group_handler.py", line 32, in post
  80. inst.update_table_info()
  81. File "E:\ai_ads\ai_callback_add_group_handler.py", line 68, in update_table_info
  82. WHERE group_uuid = %s""", (unit_id, unit_create_time, group_uuid))
  83. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
  84. result = self._query(query)
  85. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
  86. conn.query(q)
  87. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
  88. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  89. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
  90. result.read()
  91. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
  92. first_packet = self.connection._read_packet()
  93. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  94. packet.raise_for_error()
  95. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  96. err.raise_mysql_exception(self._data)
  97. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  98. raise errorclass(errno, errval)
  99. 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")
  100. 01/14/2021 06:18:21 PM INFO *************************************** NEW REQUEST ***************************************
  101. 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': '广告组名称重复'}]}
  102. 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': '创建成功'}
  103. 01/14/2021 06:18:21 PM ERROR on single update callback info: {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}
  104. 01/14/2021 06:19:16 PM INFO ai callback add group logger service started at 2021-01-14 18:19:16
  105. 01/14/2021 06:19:19 PM INFO *************************************** NEW REQUEST ***************************************
  106. 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': '广告组名称重复'}]}
  107. 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': '创建成功'}
  108. 01/14/2021 06:19:20 PM ERROR on single update callback info: {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}
  109. 01/14/2021 06:33:05 PM INFO *************************************** NEW REQUEST ***************************************
  110. 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': '广告组名称重复'}]}
  111. 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': '创建成功'}
  112. 01/14/2021 06:33:06 PM ERROR on single update callback info: {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}
  113. 01/14/2021 06:33:44 PM INFO *************************************** NEW REQUEST ***************************************
  114. 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': '广告组名称重复'}]}
  115. 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': '创建成功'}
  116. 01/14/2021 06:33:44 PM ERROR on single update callback info: {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}
  117. 01/14/2021 06:39:23 PM INFO ai callback add group logger service started at 2021-01-14 18:39:23
  118. 01/14/2021 06:39:27 PM INFO *************************************** NEW REQUEST ***************************************
  119. 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': '广告组名称重复'}]}
  120. 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': '创建成功'}
  121. 01/14/2021 06:39:27 PM ERROR on single update callback info: {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}