02/02/2021 11:59:34 AM INFO ai_time_task_creative_server started! 02/02/2021 11:59:38 AM INFO *************************************** NEW REQUEST *************************************** 02/02/2021 11:59:38 AM INFO 账户信息=9845260, 当前进程=8360, 当前进程的主进程=9536, raw data from request is {'account_id': 9845260} 02/02/2021 12:00:14 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}} 02/02/2021 01:55:25 PM INFO ai_time_task_creative_server started! 02/02/2021 01:55:31 PM INFO *************************************** NEW REQUEST *************************************** 02/02/2021 01:55:31 PM INFO 账户信息=9845260, 当前进程=7068, 当前进程的主进程=9536, raw data from request is {'account_id': 9845260} 02/02/2021 01:55:41 PM ERROR Traceback (most recent call last): File "E:\ai_ads\ai_time_task_creative_handler.py", line 338, in post request = ai_strategy_request_parse(request_data) File "E:\ai_ads\ai_strategy_request_func.py", line 49, in ai_strategy_request_parse inst.assemble_group_and_programme_creative_params() File "E:\ai_ads\ai_strategy_request_func.py", line 462, in assemble_group_and_programme_creative_params del single_creative_params_to_request['image_md5s'] KeyError: 'image_md5s' 02/02/2021 01:56:36 PM INFO ai_time_task_creative_server started! 02/02/2021 01:56:41 PM INFO *************************************** NEW REQUEST *************************************** 02/02/2021 01:56:41 PM INFO 账户信息=9845260, 当前进程=18716, 当前进程的主进程=9536, raw data from request is {'account_id': 9845260} 02/02/2021 01:56:47 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}} 02/02/2021 02:04:39 PM INFO *************************************** NEW REQUEST *************************************** 02/02/2021 02:04:39 PM INFO 账户信息=9845260, 当前进程=18716, 当前进程的主进程=9536, raw data from request is {'account_id': 9845260} 02/02/2021 02:04:41 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/material/getHistoryTopVideoList (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 317, in post str(datetime.date.today()), get_high_quality_video_url) File "E:\ai_ads\utils\CommonFunction.py", line 98, in get_top_video_info request = requests.post(url, headers=headers, data=json.JSONEncoder().encode(request_data)).text 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/material/getHistoryTopVideoList (Caused by NewConnectionError(': Failed to establish a new connection: [WinError 10061] 由于目标计算机积极拒绝,无法连接。')) 02/02/2021 02:05:50 PM INFO *************************************** NEW REQUEST *************************************** 02/02/2021 02:05:50 PM INFO 账户信息=9845260, 当前进程=18716, 当前进程的主进程=9536, raw data from request is {'account_id': 9845260} 02/02/2021 02:05:52 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/material/getHistoryTopVideoList (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 317, in post str(datetime.date.today()), get_high_quality_video_url) File "E:\ai_ads\utils\CommonFunction.py", line 98, in get_top_video_info request = requests.post(url, headers=headers, data=json.JSONEncoder().encode(request_data)).text 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/material/getHistoryTopVideoList (Caused by NewConnectionError(': Failed to establish a new connection: [WinError 10061] 由于目标计算机积极拒绝,无法连接。')) 02/02/2021 02:07:37 PM INFO *************************************** NEW REQUEST *************************************** 02/02/2021 02:07:37 PM INFO 账户信息=9845260, 当前进程=18716, 当前进程的主进程=9536, raw data from request is {'account_id': 9845260} 02/02/2021 02:07:48 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}} 02/02/2021 02:23:17 PM INFO ai_time_task_creative_server started! 02/02/2021 02:23:26 PM INFO *************************************** NEW REQUEST *************************************** 02/02/2021 02:23:26 PM INFO 账户信息=9845260, 当前进程=8116, 当前进程的主进程=9536, raw data from request is {'account_id': 9845260} 02/02/2021 02:23:38 PM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context cursor, statement, parameters, context File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute cursor.execute(statement, parameters) 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 'smart_cover' in 'field list'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\ai_ads\ai_time_task_creative_handler.py", line 338, in post request = ai_strategy_request_parse(request_data) File "E:\ai_ads\ai_strategy_request_func.py", line 49, in ai_strategy_request_parse inst.assemble_group_and_programme_creative_params() File "E:\ai_ads\ai_strategy_request_func.py", line 454, in assemble_group_and_programme_creative_params index=False) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\core\generic.py", line 2786, in to_sql method=method, File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 599, in to_sql method=method, File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1405, in to_sql raise err File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1397, in to_sql table.insert(chunksize, method=method) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 831, in insert exec_insert(conn, keys, chunk_iter) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 748, in _execute_insert conn.execute(self.table.insert(), data) File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute return meth(self, multiparams, params) File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement distilled_params, File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception sqlalchemy_exception, with_traceback=exc_info[2], from_=e File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context cursor, statement, parameters, context File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute cursor.execute(statement, parameters) 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) sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1054, "Unknown column 'smart_cover' in 'field list'") [SQL: INSERT INTO ctop_ai_kuaishou_program_creative_level_operation_record (site_id, actionbar_click_url, creative_category, creative_tag, smart_cover, asset_mining, is_sticky, package_name, action_bar, captions, click_url, ai_strategy_uuid, account_id, campaign_id, operation_type, `status`, message, creative_uuid, horizontal_photo_ids, vertical_photo_ids, cover_image_tokens, create_time) VALUES (%(site_id)s, %(actionbar_click_url)s, %(creative_category)s, %(creative_tag)s, %(smart_cover)s, %(asset_mining)s, %(is_sticky)s, %(package_name)s, %(action_bar)s, %(captions)s, %(click_url)s, %(ai_strategy_uuid)s, %(account_id)s, %(campaign_id)s, %(operation_type)s, %(status)s, %(message)s, %(creative_uuid)s, %(horizontal_photo_ids)s, %(vertical_photo_ids)s, %(cover_image_tokens)s, %(create_time)s)] [parameters: {'site_id': None, 'actionbar_click_url': None, 'creative_category': None, 'creative_tag': None, 'smart_cover': 1, 'asset_mining': 1, 'is_sticky': 0, 'package_name': '创意_1', 'action_bar': '免费下载', 'captions': "['上易车app,查发票成交价,买车不吃亏']", 'click_url': 'https://lnk0.com/FFx9ok?chn=451&idfa_md5=__IDFA2__&adcampaign=__DNAME__&adcreative=__CID__&adgroup=__AID__&did=__DID__&accountid=__ACCOUNTID__&platform=__OS__&clicktime=__TS__&ip=__IP__&useragent=__UA__&channelapp=__CSITE__&callback_url=__CALLBACK__&action=none&td_subid=ks324', 'ai_strategy_uuid': 'cdb34066-f8ab-4f37-94b8-24dd342184fd', 'account_id': 9845260, 'campaign_id': 33327870, 'operation_type': 1, 'status': 1, 'message': None, 'creative_uuid': '2ec1cb7d-9995-46b8-908f-25cb8f0f68cd', 'horizontal_photo_ids': '[]', 'vertical_photo_ids': "['5256263759751558239', '5208694488494638558', '5237967884960313633', '5227834786064344460', '5205879740581657518']", 'cover_image_tokens': None, 'create_time': datetime.datetime(2021, 2, 2, 14, 23, 38, 447084)}] (Background on this error at: http://sqlalche.me/e/13/e3q8) 02/02/2021 02:24:59 PM INFO ai_time_task_creative_server started! 02/02/2021 02:25:03 PM INFO *************************************** NEW REQUEST *************************************** 02/02/2021 02:25:03 PM INFO 账户信息=9845260, 当前进程=17940, 当前进程的主进程=9536, raw data from request is {'account_id': 9845260} 02/02/2021 02:25:11 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}} 02/02/2021 02:27:53 PM INFO *************************************** NEW REQUEST *************************************** 02/02/2021 02:27:53 PM INFO 账户信息=9845260, 当前进程=17940, 当前进程的主进程=9536, raw data from request is {'account_id': 9845260} 02/02/2021 02:28:05 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}} 02/02/2021 02:42:42 PM INFO ai_time_task_creative_server started! 02/02/2021 02:42:57 PM INFO *************************************** NEW REQUEST *************************************** 02/02/2021 02:42:57 PM INFO 账户信息=9845260, 当前进程=13992, 当前进程的主进程=9536, raw data from request is {'account_id': 9845260} 02/02/2021 02:43:04 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}} 02/02/2021 02:46:32 PM INFO *************************************** NEW REQUEST *************************************** 02/02/2021 02:46:32 PM INFO 账户信息=9845260, 当前进程=13992, 当前进程的主进程=9536, raw data from request is {'account_id': 9845260} 02/02/2021 02:46:41 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}} 02/02/2021 02:50:11 PM INFO *************************************** NEW REQUEST *************************************** 02/02/2021 02:50:11 PM INFO 账户信息=9845260, 当前进程=13992, 当前进程的主进程=9536, raw data from request is {'account_id': 9845260} 02/02/2021 02:50:16 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}} 02/02/2021 02:51:02 PM INFO *************************************** NEW REQUEST *************************************** 02/02/2021 02:51:02 PM INFO 账户信息=9845260, 当前进程=13992, 当前进程的主进程=9536, raw data from request is {'account_id': 9845260} 02/02/2021 02:51:08 PM INFO ai策略的返回信息:{'code': 0, 'message': {'code': 0, 'message': '异步执行中,等待回调...'}}