ai_auto_create.log 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228
  1. 01/30/2021 05:13:27 PM INFO ai_time_task_creative_server started!
  2. 01/30/2021 05:13:57 PM INFO ai_time_task_creative_server started!
  3. 01/30/2021 05:14:11 PM INFO *************************************** NEW REQUEST ***************************************
  4. 01/30/2021 05:14:11 PM INFO raw data from request is {'account_id': 9743727}
  5. 01/30/2021 05:14:11 PM ERROR Traceback (most recent call last):
  6. File "E:\ai_ads\ai_time_task_creative_handler.py", line 369, in post
  7. related_creative_max_cnt=related_creative_max_cnt)
  8. TypeError: get_history_video_info() got an unexpected keyword argument 'num'
  9. 01/30/2021 05:14:53 PM INFO *************************************** NEW REQUEST ***************************************
  10. 01/30/2021 05:14:53 PM INFO raw data from request is {'account_id': 9743727}
  11. 01/30/2021 05:14:53 PM ERROR Traceback (most recent call last):
  12. File "E:\ai_ads\ai_time_task_creative_handler.py", line 369, in post
  13. related_creative_max_cnt=related_creative_max_cnt)
  14. TypeError: get_history_video_info() got an unexpected keyword argument 'num'
  15. 01/30/2021 05:15:20 PM INFO ai_time_task_creative_server started!
  16. 01/30/2021 05:15:27 PM INFO *************************************** NEW REQUEST ***************************************
  17. 01/30/2021 05:15:27 PM INFO raw data from request is {'account_id': 9743727}
  18. 01/30/2021 05:15:27 PM ERROR Traceback (most recent call last):
  19. File "E:\ai_ads\ai_time_task_creative_handler.py", line 369, in post
  20. related_creative_max_cnt=related_creative_max_cnt)
  21. TypeError: get_history_video_info() got an unexpected keyword argument 'related_creative_max_cnt'
  22. 01/30/2021 05:15:57 PM INFO ai_time_task_creative_server started!
  23. 01/30/2021 05:16:01 PM INFO *************************************** NEW REQUEST ***************************************
  24. 01/30/2021 05:16:01 PM INFO raw data from request is {'account_id': 9743727}
  25. 01/30/2021 05:17:46 PM ERROR Traceback (most recent call last):
  26. File "E:\ai_ads\ai_time_task_creative_handler.py", line 390, in post
  27. request = ai_strategy_request_parse(request_data)
  28. File "E:\ai_ads\ai_strategy_request_func.py", line 47, in ai_strategy_request_parse
  29. inst.assemble_group_and_programme_creative_params()
  30. File "E:\ai_ads\ai_strategy_request_func.py", line 463, in assemble_group_and_programme_creative_params
  31. if self.video[j]['material_type'] == 1:
  32. KeyError: 0
  33. 01/30/2021 05:21:41 PM INFO ai_time_task_creative_server started!
  34. 01/30/2021 05:21:50 PM INFO *************************************** NEW REQUEST ***************************************
  35. 01/30/2021 05:21:50 PM INFO raw data from request is {'account_id': 9743727}
  36. 01/30/2021 05:26:00 PM INFO ai_time_task_creative_server started!
  37. 01/30/2021 05:26:06 PM INFO ai_time_task_creative_server started!
  38. 01/30/2021 05:26:10 PM INFO *************************************** NEW REQUEST ***************************************
  39. 01/30/2021 05:26:10 PM INFO raw data from request is {'account_id': 9743727}
  40. 01/30/2021 05:27:15 PM INFO ai_time_task_creative_server started!
  41. 01/30/2021 05:27:18 PM INFO *************************************** NEW REQUEST ***************************************
  42. 01/30/2021 05:27:18 PM INFO raw data from request is {'account_id': 9743727}
  43. 01/30/2021 05:33:21 PM ERROR Traceback (most recent call last):
  44. File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\connection.py", line 170, in _new_conn
  45. (self._dns_host, self.port), self.timeout, **extra_kw
  46. File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\util\connection.py", line 96, in create_connection
  47. raise err
  48. File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\util\connection.py", line 86, in create_connection
  49. sock.connect(sa)
  50. ConnectionRefusedError: [WinError 10061] 由于目标计算机积极拒绝,无法连接。
  51. During handling of the above exception, another exception occurred:
  52. Traceback (most recent call last):
  53. File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\connectionpool.py", line 706, in urlopen
  54. chunked=chunked,
  55. File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\connectionpool.py", line 394, in _make_request
  56. conn.request(method, url, **httplib_request_kw)
  57. File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\connection.py", line 234, in request
  58. super(HTTPConnection, self).request(method, url, body=body, headers=headers)
  59. File "D:\anaconda3\envs\ai_ads\lib\http\client.py", line 1277, in request
  60. self._send_request(method, url, body, headers, encode_chunked)
  61. File "D:\anaconda3\envs\ai_ads\lib\http\client.py", line 1323, in _send_request
  62. self.endheaders(body, encode_chunked=encode_chunked)
  63. File "D:\anaconda3\envs\ai_ads\lib\http\client.py", line 1272, in endheaders
  64. self._send_output(message_body, encode_chunked=encode_chunked)
  65. File "D:\anaconda3\envs\ai_ads\lib\http\client.py", line 1032, in _send_output
  66. self.send(msg)
  67. File "D:\anaconda3\envs\ai_ads\lib\http\client.py", line 972, in send
  68. self.connect()
  69. File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\connection.py", line 200, in connect
  70. conn = self._new_conn()
  71. File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\connection.py", line 182, in _new_conn
  72. self, "Failed to establish a new connection: %s" % e
  73. urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPConnection object at 0x000001D0EA971A88>: Failed to establish a new connection: [WinError 10061] 由于目标计算机积极拒绝,无法连接。
  74. During handling of the above exception, another exception occurred:
  75. Traceback (most recent call last):
  76. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\adapters.py", line 449, in send
  77. timeout=timeout
  78. File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\connectionpool.py", line 756, in urlopen
  79. method, url, error=e, _pool=self, _stacktrace=sys.exc_info()[2]
  80. File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\util\retry.py", line 573, in increment
  81. raise MaxRetryError(_pool, url, error or ResponseError(cause))
  82. urllib3.exceptions.MaxRetryError: HTTPConnectionPool(host='192.168.1.8', port=8080): Max retries exceeded with url: /jeecg-boot/kuaishou/create/createUnitAndCreative (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001D0EA971A88>: Failed to establish a new connection: [WinError 10061] 由于目标计算机积极拒绝,无法连接。'))
  83. During handling of the above exception, another exception occurred:
  84. Traceback (most recent call last):
  85. File "E:\ai_ads\ai_time_task_creative_handler.py", line 390, in post
  86. request = ai_strategy_request_parse(request_data)
  87. File "E:\ai_ads\ai_strategy_request_func.py", line 55, in ai_strategy_request_parse
  88. data=json.JSONEncoder().encode(inst.res_data))
  89. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\api.py", line 119, in post
  90. return request('post', url, data=data, json=json, **kwargs)
  91. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\api.py", line 61, in request
  92. return session.request(method=method, url=url, **kwargs)
  93. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\sessions.py", line 542, in request
  94. resp = self.send(prep, **send_kwargs)
  95. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\sessions.py", line 655, in send
  96. r = adapter.send(request, **kwargs)
  97. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\adapters.py", line 516, in send
  98. raise ConnectionError(e, request=request)
  99. requests.exceptions.ConnectionError: HTTPConnectionPool(host='192.168.1.8', port=8080): Max retries exceeded with url: /jeecg-boot/kuaishou/create/createUnitAndCreative (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001D0EA971A88>: Failed to establish a new connection: [WinError 10061] 由于目标计算机积极拒绝,无法连接。'))
  100. 01/30/2021 05:37:13 PM INFO ai_time_task_creative_server started!
  101. 01/30/2021 05:37:18 PM INFO *************************************** NEW REQUEST ***************************************
  102. 01/30/2021 05:37:18 PM INFO raw data from request is {'account_id': 9743727}
  103. 01/30/2021 05:39:37 PM INFO ai_time_task_creative_server started!
  104. 01/30/2021 05:39:43 PM INFO *************************************** NEW REQUEST ***************************************
  105. 01/30/2021 05:39:43 PM INFO raw data from request is {'account_id': 9743727}
  106. 01/30/2021 05:40:06 PM ERROR Traceback (most recent call last):
  107. File "E:\ai_ads\ai_time_task_creative_handler.py", line 390, in post
  108. request = ai_strategy_request_parse(request_data)
  109. File "E:\ai_ads\ai_strategy_request_func.py", line 59, in ai_strategy_request_parse
  110. inst.update_intelligence_strategy_table(message=response_data)
  111. File "E:\ai_ads\ai_strategy_request_func.py", line 142, in update_intelligence_strategy_table
  112. WHERE ai_strategy_uuid = %s""", (str(message), self.ai_strategy_uuid))
  113. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
  114. result = self._query(query)
  115. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
  116. conn.query(q)
  117. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
  118. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  119. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
  120. result.read()
  121. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
  122. first_packet = self.connection._read_packet()
  123. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  124. packet.raise_for_error()
  125. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  126. err.raise_mysql_exception(self._data)
  127. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  128. raise errorclass(errno, errval)
  129. pymysql.err.OperationalError: (1054, "Unknown column 'message' in 'field list'")
  130. 01/30/2021 05:56:46 PM INFO ai_time_task_creative_server started!
  131. 01/30/2021 05:56:53 PM INFO *************************************** NEW REQUEST ***************************************
  132. 01/30/2021 05:56:53 PM INFO raw data from request is {'account_id': 9743727}
  133. 01/30/2021 06:02:26 PM INFO ai_time_task_creative_server started!
  134. 01/30/2021 06:02:31 PM INFO *************************************** NEW REQUEST ***************************************
  135. 01/30/2021 06:02:31 PM INFO raw data from request is {'account_id': 9743727}
  136. 01/30/2021 06:02:42 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}}
  137. 01/30/2021 06:09:42 PM INFO *************************************** NEW REQUEST ***************************************
  138. 01/30/2021 06:09:42 PM INFO raw data from request is {'account_id': 9743727}
  139. 01/30/2021 06:10:25 PM INFO ai_time_task_creative_server started!
  140. 01/30/2021 06:10:34 PM INFO *************************************** NEW REQUEST ***************************************
  141. 01/30/2021 06:10:34 PM INFO raw data from request is {'account_id': 9743727}
  142. 01/30/2021 06:10:40 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}}
  143. 01/30/2021 06:18:15 PM INFO ai_time_task_creative_server started!
  144. 01/30/2021 06:19:36 PM INFO *************************************** NEW REQUEST ***************************************
  145. 01/30/2021 06:19:36 PM INFO raw data from request is {'account_id': 9743727}
  146. 01/30/2021 06:19:40 PM ERROR Traceback (most recent call last):
  147. File "E:\ai_ads\ai_time_task_creative_handler.py", line 390, in post
  148. request = ai_strategy_request_parse(request_data)
  149. File "E:\ai_ads\ai_strategy_request_func.py", line 47, in ai_strategy_request_parse
  150. inst.assemble_group_and_programme_creative_params()
  151. File "E:\ai_ads\ai_strategy_request_func.py", line 399, in assemble_group_and_programme_creative_params
  152. creative_params_to_request, creative_params_to_db = self.get_programme_creative_params()
  153. File "E:\ai_ads\ai_strategy_request_func.py", line 302, in get_programme_creative_params
  154. creative_params['captions'] = '[' + (creative_params.pop('description')) + ']'
  155. KeyError: 'description'
  156. 01/30/2021 06:20:08 PM INFO ai_time_task_creative_server started!
  157. 01/30/2021 06:20:12 PM INFO *************************************** NEW REQUEST ***************************************
  158. 01/30/2021 06:20:12 PM INFO raw data from request is {'account_id': 9743727}
  159. 01/30/2021 06:20:17 PM ERROR Traceback (most recent call last):
  160. File "E:\ai_ads\ai_time_task_creative_handler.py", line 390, in post
  161. request = ai_strategy_request_parse(request_data)
  162. File "E:\ai_ads\ai_strategy_request_func.py", line 47, in ai_strategy_request_parse
  163. inst.assemble_group_and_programme_creative_params()
  164. File "E:\ai_ads\ai_strategy_request_func.py", line 398, in assemble_group_and_programme_creative_params
  165. creative_params_to_request, creative_params_to_db = self.get_programme_creative_params()
  166. File "E:\ai_ads\ai_strategy_request_func.py", line 310, in get_programme_creative_params
  167. if creative_params_to_request[col] is not None else None
  168. File "<string>", line 1
  169. [不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!]
  170. ^
  171. SyntaxError: invalid character in identifier
  172. 01/30/2021 06:21:18 PM INFO ai_time_task_creative_server started!
  173. 01/30/2021 06:21:23 PM INFO *************************************** NEW REQUEST ***************************************
  174. 01/30/2021 06:21:23 PM INFO raw data from request is {'account_id': 9743727}
  175. 01/30/2021 06:21:57 PM ERROR Traceback (most recent call last):
  176. File "E:\ai_ads\ai_time_task_creative_handler.py", line 390, in post
  177. request = ai_strategy_request_parse(request_data)
  178. File "E:\ai_ads\ai_strategy_request_func.py", line 47, in ai_strategy_request_parse
  179. inst.assemble_group_and_programme_creative_params()
  180. File "E:\ai_ads\ai_strategy_request_func.py", line 398, in assemble_group_and_programme_creative_params
  181. creative_params_to_request, creative_params_to_db = self.get_programme_creative_params()
  182. File "E:\ai_ads\ai_strategy_request_func.py", line 310, in get_programme_creative_params
  183. if creative_params_to_request[col] is not None else None
  184. File "<string>", line 1
  185. [不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!]
  186. ^
  187. SyntaxError: invalid character in identifier
  188. 01/30/2021 06:28:24 PM INFO ai_time_task_creative_server started!
  189. 01/30/2021 06:28:29 PM INFO *************************************** NEW REQUEST ***************************************
  190. 01/30/2021 06:28:29 PM INFO raw data from request is {'account_id': 9743727}
  191. 01/30/2021 06:28:36 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}}
  192. 01/30/2021 06:29:03 PM INFO ai_time_task_creative_server started!
  193. 01/30/2021 06:34:09 PM INFO ai_time_task_creative_server started!
  194. 01/30/2021 06:34:12 PM INFO *************************************** NEW REQUEST ***************************************
  195. 01/30/2021 06:34:12 PM INFO raw data from request is {'account_id': 9743727}
  196. 01/30/2021 06:34:18 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}}
  197. 01/30/2021 06:34:57 PM INFO ai_time_task_creative_server started!
  198. 01/30/2021 06:35:17 PM INFO *************************************** NEW REQUEST ***************************************
  199. 01/30/2021 06:35:17 PM INFO raw data from request is {'account_id': 9743727}
  200. 01/30/2021 06:35:22 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}}
  201. 01/30/2021 06:37:24 PM INFO *************************************** NEW REQUEST ***************************************
  202. 01/30/2021 06:37:24 PM INFO raw data from request is {'account_id': 9743727}
  203. 01/30/2021 06:37:29 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}}
  204. 01/30/2021 06:51:02 PM INFO *************************************** NEW REQUEST ***************************************
  205. 01/30/2021 06:51:02 PM INFO raw data from request is {'account_id': 9743727}
  206. 01/30/2021 06:51:15 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}}
  207. 01/30/2021 07:01:37 PM INFO *************************************** NEW REQUEST ***************************************
  208. 01/30/2021 07:01:37 PM INFO raw data from request is {'account_id': 9743727}
  209. 01/30/2021 07:01:43 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}}
  210. 01/30/2021 07:02:05 PM INFO *************************************** NEW REQUEST ***************************************
  211. 01/30/2021 07:02:05 PM INFO raw data from request is {'account_id': 9743727}
  212. 01/30/2021 07:02:09 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}}
  213. 01/30/2021 09:22:56 PM INFO ai_time_task_creative_server started!