01/30/2021 05:13:27 PM INFO ai_time_task_creative_server started! 01/30/2021 05:13:57 PM INFO ai_time_task_creative_server started! 01/30/2021 05:14:11 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 05:14:11 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 05:14:11 PM ERROR Traceback (most recent call last): File "E:\ai_ads\ai_time_task_creative_handler.py", line 369, in post related_creative_max_cnt=related_creative_max_cnt) TypeError: get_history_video_info() got an unexpected keyword argument 'num' 01/30/2021 05:14:53 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 05:14:53 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 05:14:53 PM ERROR Traceback (most recent call last): File "E:\ai_ads\ai_time_task_creative_handler.py", line 369, in post related_creative_max_cnt=related_creative_max_cnt) TypeError: get_history_video_info() got an unexpected keyword argument 'num' 01/30/2021 05:15:20 PM INFO ai_time_task_creative_server started! 01/30/2021 05:15:27 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 05:15:27 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 05:15:27 PM ERROR Traceback (most recent call last): File "E:\ai_ads\ai_time_task_creative_handler.py", line 369, in post related_creative_max_cnt=related_creative_max_cnt) TypeError: get_history_video_info() got an unexpected keyword argument 'related_creative_max_cnt' 01/30/2021 05:15:57 PM INFO ai_time_task_creative_server started! 01/30/2021 05:16:01 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 05:16:01 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 05:17:46 PM ERROR Traceback (most recent call last): File "E:\ai_ads\ai_time_task_creative_handler.py", line 390, in post request = ai_strategy_request_parse(request_data) File "E:\ai_ads\ai_strategy_request_func.py", line 47, in ai_strategy_request_parse inst.assemble_group_and_programme_creative_params() File "E:\ai_ads\ai_strategy_request_func.py", line 463, in assemble_group_and_programme_creative_params if self.video[j]['material_type'] == 1: KeyError: 0 01/30/2021 05:21:41 PM INFO ai_time_task_creative_server started! 01/30/2021 05:21:50 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 05:21:50 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 05:26:00 PM INFO ai_time_task_creative_server started! 01/30/2021 05:26:06 PM INFO ai_time_task_creative_server started! 01/30/2021 05:26:10 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 05:26:10 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 05:27:15 PM INFO ai_time_task_creative_server started! 01/30/2021 05:27:18 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 05:27:18 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 05:33:21 PM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\connection.py", line 170, in _new_conn (self._dns_host, self.port), self.timeout, **extra_kw File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\util\connection.py", line 96, in create_connection raise err File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\util\connection.py", line 86, in create_connection sock.connect(sa) ConnectionRefusedError: [WinError 10061] 由于目标计算机积极拒绝,无法连接。 During handling of the above exception, another exception occurred: Traceback (most recent call last): File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\connectionpool.py", line 706, in urlopen chunked=chunked, File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\connectionpool.py", line 394, in _make_request conn.request(method, url, **httplib_request_kw) File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\connection.py", line 234, in request super(HTTPConnection, self).request(method, url, body=body, headers=headers) File "D:\anaconda3\envs\ai_ads\lib\http\client.py", line 1277, in request self._send_request(method, url, body, headers, encode_chunked) File "D:\anaconda3\envs\ai_ads\lib\http\client.py", line 1323, in _send_request self.endheaders(body, encode_chunked=encode_chunked) File "D:\anaconda3\envs\ai_ads\lib\http\client.py", line 1272, in endheaders self._send_output(message_body, encode_chunked=encode_chunked) File "D:\anaconda3\envs\ai_ads\lib\http\client.py", line 1032, in _send_output self.send(msg) File "D:\anaconda3\envs\ai_ads\lib\http\client.py", line 972, in send self.connect() File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\connection.py", line 200, in connect conn = self._new_conn() File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\connection.py", line 182, in _new_conn self, "Failed to establish a new connection: %s" % e urllib3.exceptions.NewConnectionError: : Failed to establish a new connection: [WinError 10061] 由于目标计算机积极拒绝,无法连接。 During handling of the above exception, another exception occurred: Traceback (most recent call last): File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\adapters.py", line 449, in send timeout=timeout File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\connectionpool.py", line 756, in urlopen method, url, error=e, _pool=self, _stacktrace=sys.exc_info()[2] File "D:\anaconda3\envs\ai_ads\lib\site-packages\urllib3\util\retry.py", line 573, in increment raise MaxRetryError(_pool, url, error or ResponseError(cause)) urllib3.exceptions.MaxRetryError: HTTPConnectionPool(host='192.168.1.8', port=8080): Max retries exceeded with url: /jeecg-boot/kuaishou/create/createUnitAndCreative (Caused by NewConnectionError(': Failed to establish a new connection: [WinError 10061] 由于目标计算机积极拒绝,无法连接。')) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "E:\ai_ads\ai_time_task_creative_handler.py", line 390, in post request = ai_strategy_request_parse(request_data) File "E:\ai_ads\ai_strategy_request_func.py", line 55, in ai_strategy_request_parse data=json.JSONEncoder().encode(inst.res_data)) File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\api.py", line 119, in post return request('post', url, data=data, json=json, **kwargs) File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\api.py", line 61, in request return session.request(method=method, url=url, **kwargs) File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\sessions.py", line 542, in request resp = self.send(prep, **send_kwargs) File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\sessions.py", line 655, in send r = adapter.send(request, **kwargs) File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\adapters.py", line 516, in send raise ConnectionError(e, request=request) requests.exceptions.ConnectionError: HTTPConnectionPool(host='192.168.1.8', port=8080): Max retries exceeded with url: /jeecg-boot/kuaishou/create/createUnitAndCreative (Caused by NewConnectionError(': Failed to establish a new connection: [WinError 10061] 由于目标计算机积极拒绝,无法连接。')) 01/30/2021 05:37:13 PM INFO ai_time_task_creative_server started! 01/30/2021 05:37:18 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 05:37:18 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 05:39:37 PM INFO ai_time_task_creative_server started! 01/30/2021 05:39:43 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 05:39:43 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 05:40:06 PM ERROR Traceback (most recent call last): File "E:\ai_ads\ai_time_task_creative_handler.py", line 390, in post request = ai_strategy_request_parse(request_data) File "E:\ai_ads\ai_strategy_request_func.py", line 59, in ai_strategy_request_parse inst.update_intelligence_strategy_table(message=response_data) File "E:\ai_ads\ai_strategy_request_func.py", line 142, in update_intelligence_strategy_table WHERE ai_strategy_uuid = %s""", (str(message), self.ai_strategy_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: (1054, "Unknown column 'message' in 'field list'") 01/30/2021 05:56:46 PM INFO ai_time_task_creative_server started! 01/30/2021 05:56:53 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 05:56:53 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 06:02:26 PM INFO ai_time_task_creative_server started! 01/30/2021 06:02:31 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 06:02:31 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 06:02:42 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}} 01/30/2021 06:09:42 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 06:09:42 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 06:10:25 PM INFO ai_time_task_creative_server started! 01/30/2021 06:10:34 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 06:10:34 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 06:10:40 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}} 01/30/2021 06:18:15 PM INFO ai_time_task_creative_server started! 01/30/2021 06:19:36 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 06:19:36 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 06:19:40 PM ERROR Traceback (most recent call last): File "E:\ai_ads\ai_time_task_creative_handler.py", line 390, in post request = ai_strategy_request_parse(request_data) File "E:\ai_ads\ai_strategy_request_func.py", line 47, in ai_strategy_request_parse inst.assemble_group_and_programme_creative_params() File "E:\ai_ads\ai_strategy_request_func.py", line 399, in assemble_group_and_programme_creative_params creative_params_to_request, creative_params_to_db = self.get_programme_creative_params() File "E:\ai_ads\ai_strategy_request_func.py", line 302, in get_programme_creative_params creative_params['captions'] = '[' + (creative_params.pop('description')) + ']' KeyError: 'description' 01/30/2021 06:20:08 PM INFO ai_time_task_creative_server started! 01/30/2021 06:20:12 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 06:20:12 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 06:20:17 PM ERROR Traceback (most recent call last): File "E:\ai_ads\ai_time_task_creative_handler.py", line 390, in post request = ai_strategy_request_parse(request_data) File "E:\ai_ads\ai_strategy_request_func.py", line 47, in ai_strategy_request_parse inst.assemble_group_and_programme_creative_params() File "E:\ai_ads\ai_strategy_request_func.py", line 398, in assemble_group_and_programme_creative_params creative_params_to_request, creative_params_to_db = self.get_programme_creative_params() File "E:\ai_ads\ai_strategy_request_func.py", line 310, in get_programme_creative_params if creative_params_to_request[col] is not None else None File "", line 1 [不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!] ^ SyntaxError: invalid character in identifier 01/30/2021 06:21:18 PM INFO ai_time_task_creative_server started! 01/30/2021 06:21:23 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 06:21:23 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 06:21:57 PM ERROR Traceback (most recent call last): File "E:\ai_ads\ai_time_task_creative_handler.py", line 390, in post request = ai_strategy_request_parse(request_data) File "E:\ai_ads\ai_strategy_request_func.py", line 47, in ai_strategy_request_parse inst.assemble_group_and_programme_creative_params() File "E:\ai_ads\ai_strategy_request_func.py", line 398, in assemble_group_and_programme_creative_params creative_params_to_request, creative_params_to_db = self.get_programme_creative_params() File "E:\ai_ads\ai_strategy_request_func.py", line 310, in get_programme_creative_params if creative_params_to_request[col] is not None else None File "", line 1 [不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!] ^ SyntaxError: invalid character in identifier 01/30/2021 06:28:24 PM INFO ai_time_task_creative_server started! 01/30/2021 06:28:29 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 06:28:29 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 06:28:36 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}} 01/30/2021 06:29:03 PM INFO ai_time_task_creative_server started! 01/30/2021 06:34:09 PM INFO ai_time_task_creative_server started! 01/30/2021 06:34:12 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 06:34:12 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 06:34:18 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}} 01/30/2021 06:34:57 PM INFO ai_time_task_creative_server started! 01/30/2021 06:35:17 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 06:35:17 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 06:35:22 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}} 01/30/2021 06:37:24 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 06:37:24 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 06:37:29 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}} 01/30/2021 06:51:02 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 06:51:02 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 06:51:15 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}} 01/30/2021 07:01:37 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 07:01:37 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 07:01:43 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}} 01/30/2021 07:02:05 PM INFO *************************************** NEW REQUEST *************************************** 01/30/2021 07:02:05 PM INFO raw data from request is {'account_id': 9743727} 01/30/2021 07:02:09 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}} 01/30/2021 09:22:56 PM INFO ai_time_task_creative_server started!