10/09/2020 10:05:35 AM INFO simhash similarity service started at 2020-10-09 10:05:35 10/09/2020 10:05:35 AM INFO simhash similarity service started successfully at 2020-10-09 10:05:35 10/09/2020 10:05:56 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 10:05:56 AM INFO the md5 of request script is 123 10/09/2020 10:05:56 AM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content df = pd.read_sql(sql, engine) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql chunksize=chunksize, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query result = self.execute(*args) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute *args, **kwargs File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute return connection.execute(statement, *multiparams, **params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute return self._execute_text(object_, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text parameters, File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\simhash\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\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'") [SQL: select * from ctop_script_file where id = self.script_md5 ] (Background on this error at: http://sqlalche.me/e/13/2j85) 10/09/2020 10:06:22 AM INFO simhash similarity service started at 2020-10-09 10:06:22 10/09/2020 10:06:22 AM INFO simhash similarity service started successfully at 2020-10-09 10:06:22 10/09/2020 10:06:45 AM INFO simhash similarity service started at 2020-10-09 10:06:45 10/09/2020 10:06:45 AM INFO simhash similarity service started successfully at 2020-10-09 10:06:45 10/09/2020 10:07:04 AM INFO simhash similarity service started at 2020-10-09 10:07:04 10/09/2020 10:07:04 AM INFO simhash similarity service started successfully at 2020-10-09 10:07:04 10/09/2020 10:07:09 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 10:07:09 AM INFO the md5 of request script is 12323 10/09/2020 10:07:09 AM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content df = pd.read_sql(sql, engine) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql chunksize=chunksize, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query result = self.execute(*args) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute *args, **kwargs File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute return connection.execute(statement, *multiparams, **params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute return self._execute_text(object_, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text parameters, File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\simhash\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\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'") [SQL: select * from ctop_script_file where id = self.script_md5 ] (Background on this error at: http://sqlalche.me/e/13/2j85) 10/09/2020 10:08:21 AM INFO simhash similarity service started at 2020-10-09 10:08:21 10/09/2020 10:08:21 AM INFO simhash similarity service started successfully at 2020-10-09 10:08:21 10/09/2020 10:14:06 AM INFO simhash similarity service started at 2020-10-09 10:14:06 10/09/2020 10:14:06 AM INFO simhash similarity service started successfully at 2020-10-09 10:14:06 10/09/2020 10:14:22 AM INFO simhash similarity service started at 2020-10-09 10:14:22 10/09/2020 10:14:22 AM INFO simhash similarity service started successfully at 2020-10-09 10:14:22 10/09/2020 10:15:32 AM INFO simhash similarity service started at 2020-10-09 10:15:32 10/09/2020 10:15:32 AM INFO simhash similarity service started successfully at 2020-10-09 10:15:32 10/09/2020 10:17:48 AM INFO simhash similarity service started at 2020-10-09 10:17:48 10/09/2020 10:17:48 AM INFO simhash similarity service started successfully at 2020-10-09 10:17:48 10/09/2020 10:17:52 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 10:17:52 AM INFO the md5 of request script is 12323 10/09/2020 10:17:52 AM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content df = pd.read_sql(sql, engine) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql chunksize=chunksize, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query result = self.execute(*args) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute *args, **kwargs File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute return connection.execute(statement, *multiparams, **params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute return self._execute_text(object_, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text parameters, File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\simhash\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\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'") [SQL: select * from ctop_script_file where id = self.script_md5 ] (Background on this error at: http://sqlalche.me/e/13/2j85) 10/09/2020 10:18:02 AM INFO simhash similarity service started at 2020-10-09 10:18:02 10/09/2020 10:18:02 AM INFO simhash similarity service started successfully at 2020-10-09 10:18:02 10/09/2020 10:18:03 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 10:18:03 AM INFO the md5 of request script is 12323 10/09/2020 10:18:03 AM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content df = pd.read_sql(sql, engine) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql chunksize=chunksize, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query result = self.execute(*args) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute *args, **kwargs File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute return connection.execute(statement, *multiparams, **params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute return self._execute_text(object_, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text parameters, File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\simhash\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\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'") [SQL: select * from ctop_script_file where id = self.script_md5 ] (Background on this error at: http://sqlalche.me/e/13/2j85) 10/09/2020 10:18:14 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 10:18:14 AM INFO the md5 of request script is 12323a 10/09/2020 10:18:14 AM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content df = pd.read_sql(sql, engine) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql chunksize=chunksize, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query result = self.execute(*args) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute *args, **kwargs File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute return connection.execute(statement, *multiparams, **params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute return self._execute_text(object_, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text parameters, File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\simhash\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\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'") [SQL: select * from ctop_script_file where id = self.script_md5 ] (Background on this error at: http://sqlalche.me/e/13/2j85) 10/09/2020 10:18:19 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 10:18:19 AM INFO the md5 of request script is 12323ab 10/09/2020 10:18:19 AM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content df = pd.read_sql(sql, engine) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql chunksize=chunksize, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query result = self.execute(*args) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute *args, **kwargs File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute return connection.execute(statement, *multiparams, **params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute return self._execute_text(object_, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text parameters, File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\simhash\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\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'") [SQL: select * from ctop_script_file where id = self.script_md5 ] (Background on this error at: http://sqlalche.me/e/13/2j85) 10/09/2020 10:18:23 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 10:18:23 AM INFO the md5 of request script is 12323abccc 10/09/2020 10:18:23 AM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content df = pd.read_sql(sql, engine) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql chunksize=chunksize, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query result = self.execute(*args) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute *args, **kwargs File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute return connection.execute(statement, *multiparams, **params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute return self._execute_text(object_, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text parameters, File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\simhash\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\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'") [SQL: select * from ctop_script_file where id = self.script_md5 ] (Background on this error at: http://sqlalche.me/e/13/2j85) 10/09/2020 10:18:58 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 10:18:58 AM INFO the md5 of request script is 12323abccc 10/09/2020 10:18:58 AM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content df = pd.read_sql(sql, engine) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql chunksize=chunksize, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query result = self.execute(*args) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute *args, **kwargs File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute return connection.execute(statement, *multiparams, **params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute return self._execute_text(object_, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text parameters, File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\simhash\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\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'") [SQL: select * from ctop_script_file where id = self.script_md5 ] (Background on this error at: http://sqlalche.me/e/13/2j85) 10/09/2020 10:19:05 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 10:19:05 AM INFO the md5 of request script is 12323abccc 10/09/2020 10:19:05 AM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content df = pd.read_sql(sql, engine) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql chunksize=chunksize, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query result = self.execute(*args) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute *args, **kwargs File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute return connection.execute(statement, *multiparams, **params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute return self._execute_text(object_, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text parameters, File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\simhash\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\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'") [SQL: select * from ctop_script_file where id = self.script_md5 ] (Background on this error at: http://sqlalche.me/e/13/2j85) 10/09/2020 10:19:09 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 10:19:09 AM INFO the md5 of request script is 12323abccc123 10/09/2020 10:19:09 AM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content df = pd.read_sql(sql, engine) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql chunksize=chunksize, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query result = self.execute(*args) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute *args, **kwargs File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute return connection.execute(statement, *multiparams, **params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute return self._execute_text(object_, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text parameters, File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\simhash\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\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'") [SQL: select * from ctop_script_file where id = self.script_md5 ] (Background on this error at: http://sqlalche.me/e/13/2j85) 10/09/2020 10:19:22 AM INFO simhash similarity service started at 2020-10-09 10:19:22 10/09/2020 10:19:22 AM INFO simhash similarity service started successfully at 2020-10-09 10:19:22 10/09/2020 10:19:30 AM INFO simhash similarity service started at 2020-10-09 10:19:30 10/09/2020 10:19:30 AM INFO simhash similarity service started successfully at 2020-10-09 10:19:30 10/09/2020 10:19:32 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 10:19:32 AM INFO the md5 of request script is 12323abccc123 10/09/2020 10:19:33 AM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content df = pd.read_sql(sql, engine) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql chunksize=chunksize, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query result = self.execute(*args) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute *args, **kwargs File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute return connection.execute(statement, *multiparams, **params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute return self._execute_text(object_, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text parameters, File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\simhash\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\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'") [SQL: select * from ctop_script_file where id = self.script_md5 ] (Background on this error at: http://sqlalche.me/e/13/2j85) 10/09/2020 10:55:14 AM INFO simhash similarity service started at 2020-10-09 10:55:14 10/09/2020 10:55:14 AM INFO simhash similarity service started successfully at 2020-10-09 10:55:14 10/09/2020 10:55:21 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 10:55:21 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 10:55:21 AM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 86, in parse_content df = pd.read_sql(sql, engine) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql chunksize=chunksize, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query result = self.execute(*args) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute *args, **kwargs File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute return connection.execute(statement, *multiparams, **params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute return self._execute_text(object_, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text parameters, File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\simhash\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\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'") [SQL: select * from ctop_script_file where id = self.script_md5 ] (Background on this error at: http://sqlalche.me/e/13/2j85) 10/09/2020 10:57:15 AM INFO simhash similarity service started at 2020-10-09 10:57:15 10/09/2020 10:57:15 AM INFO simhash similarity service started successfully at 2020-10-09 10:57:15 10/09/2020 10:57:20 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 10:57:20 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 10:57:20 AM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1054, "Unknown column '3996ca5cb3957e624c10e996af155837' in 'where clause'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 86, in parse_content df = pd.read_sql(sql, engine) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql chunksize=chunksize, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query result = self.execute(*args) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute *args, **kwargs File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute return connection.execute(statement, *multiparams, **params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute return self._execute_text(object_, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text parameters, File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\simhash\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\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column '3996ca5cb3957e624c10e996af155837' in 'where clause'") [SQL: select * from ctop_script_file where id = 3996ca5cb3957e624c10e996af155837 ] (Background on this error at: http://sqlalche.me/e/13/2j85) 10/09/2020 11:00:23 AM INFO simhash similarity service started at 2020-10-09 11:00:23 10/09/2020 11:00:23 AM INFO simhash similarity service started successfully at 2020-10-09 11:00:23 10/09/2020 11:00:26 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 11:00:26 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 11:00:26 AM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1054, "Unknown column '3996ca5cb3957e624c10e996af155837' in 'where clause'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content df = pd.read_sql(sql, engine) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql chunksize=chunksize, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query result = self.execute(*args) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute *args, **kwargs File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute return connection.execute(statement, *multiparams, **params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute return self._execute_text(object_, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text parameters, File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\simhash\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\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context cursor, statement, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params cursor.execute(statement) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column '3996ca5cb3957e624c10e996af155837' in 'where clause'") [SQL: select * from ctop_script_file where id = 3996ca5cb3957e624c10e996af155837 ] (Background on this error at: http://sqlalche.me/e/13/2j85) 10/09/2020 11:00:48 AM INFO simhash similarity service started at 2020-10-09 11:00:48 10/09/2020 11:00:48 AM INFO simhash similarity service started successfully at 2020-10-09 11:00:48 10/09/2020 11:00:52 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 11:00:52 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 11:00:53 AM ERROR Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 91, in parse_content with open('file_cache/%s' % self.file_name, 'wb') as code: FileNotFoundError: [Errno 2] No such file or directory: 'file_cache/脚本模板-时间+客户+功能点.docx' 10/09/2020 11:01:59 AM INFO simhash similarity service started at 2020-10-09 11:01:59 10/09/2020 11:01:59 AM INFO simhash similarity service started successfully at 2020-10-09 11:01:59 10/09/2020 11:02:02 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 11:02:02 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 11:02:02 AM ERROR Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 90, in parse_content with open('file_cache/%s' % self.file_name, 'wb') as code: FileNotFoundError: [Errno 2] No such file or directory: 'file_cache/脚本模板-时间+客户+功能点.docx' 10/09/2020 11:03:50 AM INFO simhash similarity service started at 2020-10-09 11:03:50 10/09/2020 11:03:50 AM INFO simhash similarity service started successfully at 2020-10-09 11:03:50 10/09/2020 11:03:55 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 11:03:55 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 11:03:55 AM ERROR Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 90, in parse_content with open('file_cache/%s' % self.file_name, 'w') as code: FileNotFoundError: [Errno 2] No such file or directory: 'file_cache/脚本模板-时间+客户+功能点.docx' 10/09/2020 11:04:27 AM INFO simhash similarity service started at 2020-10-09 11:04:27 10/09/2020 11:04:27 AM INFO simhash similarity service started successfully at 2020-10-09 11:04:27 10/09/2020 11:04:30 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 11:04:30 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 11:04:30 AM ERROR Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 91, in parse_content with open('file_cache/%s' % self.file_name, 'w') as code: FileNotFoundError: [Errno 2] No such file or directory: 'file_cache/脚本模板-时间+客户+功能点.docx' 10/09/2020 11:04:55 AM INFO simhash similarity service started at 2020-10-09 11:04:55 10/09/2020 11:04:55 AM INFO simhash similarity service started successfully at 2020-10-09 11:04:55 10/09/2020 11:05:00 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 11:05:00 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 11:05:01 AM ERROR Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 91, in parse_content with open('./file_cache/%s' % self.file_name, 'w') as code: FileNotFoundError: [Errno 2] No such file or directory: './file_cache/脚本模板-时间+客户+功能点.docx' 10/09/2020 11:08:35 AM INFO simhash similarity service started at 2020-10-09 11:08:35 10/09/2020 11:08:35 AM INFO simhash similarity service started successfully at 2020-10-09 11:08:35 10/09/2020 11:08:42 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 11:08:42 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 11:08:43 AM ERROR Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 91, in parse_content with open('.\file_cache\%s' % self.file_name, 'w') as code: OSError: [Errno 22] Invalid argument: '.\x0cile_cache\\脚本模板-时间+客户+功能点.docx' 10/09/2020 11:10:43 AM INFO simhash similarity service started at 2020-10-09 11:10:43 10/09/2020 11:10:43 AM INFO simhash similarity service started successfully at 2020-10-09 11:10:43 10/09/2020 11:10:46 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 11:10:46 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 11:10:46 AM ERROR Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 90, in parse_content with open('./file_cache/%s' % self.file_name, 'wb') as code: FileNotFoundError: [Errno 2] No such file or directory: './file_cache/脚本模板-时间+客户+功能点.docx' 10/09/2020 11:14:00 AM INFO simhash similarity service started at 2020-10-09 11:14:00 10/09/2020 11:14:00 AM INFO simhash similarity service started successfully at 2020-10-09 11:14:00 10/09/2020 11:14:02 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 11:14:02 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 11:14:02 AM ERROR Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 92, in parse_content with open('./file_cache/%s' % self.file_name, 'wb') as code: FileNotFoundError: [Errno 2] No such file or directory: './file_cache/脚本模板-时间+客户+功能点.docx' 10/09/2020 11:16:18 AM INFO simhash similarity service started at 2020-10-09 11:16:18 10/09/2020 11:16:18 AM INFO simhash similarity service started successfully at 2020-10-09 11:16:18 10/09/2020 11:16:20 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 11:16:20 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 11:16:21 AM ERROR Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 38, in post inst.parse_content() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 94, in parse_content doc = docx.Document('file_cache/%s' % self.file_name) File "D:\anaconda3\envs\simhash\lib\site-packages\docx\api.py", line 25, in Document document_part = Package.open(docx).main_document_part File "D:\anaconda3\envs\simhash\lib\site-packages\docx\opc\package.py", line 128, in open pkg_reader = PackageReader.from_file(pkg_file) File "D:\anaconda3\envs\simhash\lib\site-packages\docx\opc\pkgreader.py", line 32, in from_file phys_reader = PhysPkgReader(pkg_file) File "D:\anaconda3\envs\simhash\lib\site-packages\docx\opc\phys_pkg.py", line 31, in __new__ "Package not found at '%s'" % pkg_file docx.opc.exceptions.PackageNotFoundError: Package not found at 'file_cache/脚本模板-时间+客户+功能点.docx' 10/09/2020 11:16:56 AM INFO simhash similarity service started at 2020-10-09 11:16:56 10/09/2020 11:16:56 AM INFO simhash similarity service started successfully at 2020-10-09 11:16:56 10/09/2020 11:17:07 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 11:17:07 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 11:17:08 AM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 11:17:08 AM ERROR Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 42, in post inst.get_simhash() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 99, in get_simhash sim = SimHash(self.content, self.topK) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 121, in __init__ self.sim_hash() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 132, in sim_hash keyword_weight = jieba.analyse.extract_tags("|".join(seg_list), 30, withWeight=True) AttributeError: module 'jieba' has no attribute 'analyse' 10/09/2020 11:41:30 AM INFO simhash similarity service started at 2020-10-09 11:41:30 10/09/2020 11:41:30 AM INFO simhash similarity service started successfully at 2020-10-09 11:41:30 10/09/2020 11:41:33 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 11:41:33 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 11:41:33 AM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 11:41:34 AM INFO the simhash is 1100011010010011110110111101110011010001001100101000100111111000 10/09/2020 11:41:34 AM INFO the keyword and weight is [('看车', 0.5475466031862595), ('3d', 0.5475466031862595), ('懂车帝', 0.3650310687908397), ('车帝', 0.18251553439541984), ('懂车分', 0.18251553439541984), ('录屏', 0.18251553439541984), ('明天', 0.14698989454396946), ('图片', 0.14598088714419846), ('爱车', 0.1453229162946565), ('底价', 0.1410265428680916), ('点击', 0.13483623587419846), ('这里', 0.10247685700419848), ('太帅', 0.10082084329312978), ('手机', 0.09422628745221373), ('音效', 0.09382625755343511), ('选车', 0.09125776719770992), ('选买', 0.09125776719770992), ('连车', 0.09125776719770992), ('我用', 0.09125776719770992), ('懂车', 0.09125776719770992)] 10/09/2020 11:41:34 AM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context cursor, statement, parameters, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute cursor.execute(statement, parameters) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1054, "Unknown column 'file_name' in 'field list'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 48, in post inst.write_db() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 113, in write_db res_df.to_sql(name='ctop_script_fingerprint', con=engine, if_exists='append', index=False) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 2612, in to_sql method=method, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 598, in to_sql method=method, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1406, in to_sql raise err File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1398, in to_sql table.insert(chunksize, method=method) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 830, in insert exec_insert(conn, keys, chunk_iter) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 747, in _execute_insert conn.execute(self.table.insert(), data) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute return meth(self, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement distilled_params, File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\simhash\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\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context cursor, statement, parameters, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute cursor.execute(statement, parameters) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'file_name' in 'field list'") [SQL: INSERT INTO ctop_script_fingerprint (id, file_name, finger_print, create_time) VALUES (%(id)s, %(file_name)s, %(finger_print)s, %(create_time)s)] [parameters: {'id': '3996ca5cb3957e624c10e996af155837', 'file_name': '脚本模板-时间+客户+功能点.docx', 'finger_print': '1100011010010011110110111101110011010001001100101000100111111000', 'create_time': datetime.datetime(2020, 10, 9, 11, 41, 34, 310166)}] (Background on this error at: http://sqlalche.me/e/13/2j85) 10/09/2020 11:44:27 AM INFO simhash similarity service started at 2020-10-09 11:44:27 10/09/2020 11:44:27 AM INFO simhash similarity service started successfully at 2020-10-09 11:44:27 10/09/2020 11:44:32 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 11:44:32 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 11:44:33 AM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 11:44:34 AM INFO the simhash is 1100011010010011110110111101110011010001001100101000100111111000 10/09/2020 11:44:34 AM INFO the keyword and weight is [('看车', 0.5475466031862595), ('3d', 0.5475466031862595), ('懂车帝', 0.3650310687908397), ('车帝', 0.18251553439541984), ('懂车分', 0.18251553439541984), ('录屏', 0.18251553439541984), ('明天', 0.14698989454396946), ('图片', 0.14598088714419846), ('爱车', 0.1453229162946565), ('底价', 0.1410265428680916), ('点击', 0.13483623587419846), ('这里', 0.10247685700419848), ('太帅', 0.10082084329312978), ('手机', 0.09422628745221373), ('音效', 0.09382625755343511), ('选车', 0.09125776719770992), ('选买', 0.09125776719770992), ('连车', 0.09125776719770992), ('我用', 0.09125776719770992), ('懂车', 0.09125776719770992)] 10/09/2020 11:44:34 AM INFO write to database has completed ! 10/09/2020 11:53:43 AM INFO simhash similarity service started at 2020-10-09 11:53:43 10/09/2020 11:53:43 AM INFO simhash similarity service started successfully at 2020-10-09 11:53:43 10/09/2020 11:53:46 AM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 11:53:46 AM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 11:53:47 AM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 11:53:48 AM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001 10/09/2020 11:53:48 AM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)] 10/09/2020 11:53:48 AM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context cursor, statement, parameters, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute cursor.execute(statement, parameters) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.IntegrityError: (1062, "Duplicate entry '3996ca5cb3957e624c10e996af155837' for key 'ctop_script_fingerprint.PRIMARY'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 50, in post inst.write_db() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 115, in write_db res_df.to_sql(name='ctop_script_fingerprint', con=engine, if_exists='append', index=False) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 2612, in to_sql method=method, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 598, in to_sql method=method, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1406, in to_sql raise err File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1398, in to_sql table.insert(chunksize, method=method) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 830, in insert exec_insert(conn, keys, chunk_iter) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 747, in _execute_insert conn.execute(self.table.insert(), data) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute return meth(self, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement distilled_params, File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\simhash\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\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context cursor, statement, parameters, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute cursor.execute(statement, parameters) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.IntegrityError: (pymysql.err.IntegrityError) (1062, "Duplicate entry '3996ca5cb3957e624c10e996af155837' for key 'ctop_script_fingerprint.PRIMARY'") [SQL: INSERT INTO ctop_script_fingerprint (id, file_name, finger_print, create_time) VALUES (%(id)s, %(file_name)s, %(finger_print)s, %(create_time)s)] [parameters: {'id': '3996ca5cb3957e624c10e996af155837', 'file_name': '脚本模板-时间+客户+功能点.docx', 'finger_print': '1101011000010011110110111101110111010001001100101000010111111001', 'create_time': datetime.datetime(2020, 10, 9, 11, 53, 48, 180377)}] (Background on this error at: http://sqlalche.me/e/13/gkpj) 10/09/2020 03:58:45 PM INFO simhash similarity service started at 2020-10-09 15:58:45 10/09/2020 03:58:45 PM INFO simhash similarity service started successfully at 2020-10-09 15:58:45 10/09/2020 03:58:51 PM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 03:58:51 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 03:58:51 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 03:58:52 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001 10/09/2020 03:58:52 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)] 10/09/2020 03:58:52 PM INFO write to database has completed ! 10/09/2020 03:59:12 PM ERROR Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__ self.get_similarity_scripts() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 191, in get_similarity_scripts df['distance'] = df['finger_print'].apply(lambda x: self.hamming_dis(x)) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\series.py", line 4200, in apply mapped = lib.map_infer(values, f, convert=convert_dtype) File "pandas\_libs\lib.pyx", line 2401, in pandas._libs.lib.map_infer File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 191, in df['distance'] = df['finger_print'].apply(lambda x: self.hamming_dis(x)) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 203, in hamming_dis h2 = '0b' + another_finger_print TypeError: can only concatenate str (not "bytes") to str 10/09/2020 05:59:27 PM INFO simhash similarity service started at 2020-10-09 17:59:27 10/09/2020 05:59:27 PM INFO simhash similarity service started successfully at 2020-10-09 17:59:27 10/09/2020 05:59:33 PM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 05:59:33 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 05:59:33 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 05:59:34 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001 10/09/2020 05:59:34 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)] 10/09/2020 05:59:34 PM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context cursor, statement, parameters, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute cursor.execute(statement, parameters) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.IntegrityError: (1062, "Duplicate entry '3996ca5cb3957e624c10e996af155837' for key 'ctop_script_fingerprint.PRIMARY'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 50, in post inst.write_db() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 115, in write_db res_df.to_sql(name='ctop_script_fingerprint', con=engine, if_exists='append', index=False) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 2612, in to_sql method=method, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 598, in to_sql method=method, File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1406, in to_sql raise err File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1398, in to_sql table.insert(chunksize, method=method) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 830, in insert exec_insert(conn, keys, chunk_iter) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 747, in _execute_insert conn.execute(self.table.insert(), data) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute return meth(self, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement distilled_params, File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\simhash\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\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context cursor, statement, parameters, context File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute cursor.execute(statement, parameters) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.IntegrityError: (pymysql.err.IntegrityError) (1062, "Duplicate entry '3996ca5cb3957e624c10e996af155837' for key 'ctop_script_fingerprint.PRIMARY'") [SQL: INSERT INTO ctop_script_fingerprint (id, file_name, finger_print, create_time) VALUES (%(id)s, %(file_name)s, %(finger_print)s, %(create_time)s)] [parameters: {'id': '3996ca5cb3957e624c10e996af155837', 'file_name': '脚本模板-时间+客户+功能点.docx', 'finger_print': '1101011000010011110110111101110111010001001100101000010111111001', 'create_time': datetime.datetime(2020, 10, 9, 17, 59, 34, 153183)}] (Background on this error at: http://sqlalche.me/e/13/gkpj) 10/09/2020 06:02:50 PM INFO simhash similarity service started at 2020-10-09 18:02:50 10/09/2020 06:02:50 PM INFO simhash similarity service started successfully at 2020-10-09 18:02:50 10/09/2020 06:02:54 PM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 06:02:54 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 06:02:55 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 06:02:55 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001 10/09/2020 06:02:55 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)] 10/09/2020 06:02:55 PM INFO write to database has completed ! 10/09/2020 06:03:04 PM ERROR Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__ self.get_similarity_scripts() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 190, in get_similarity_scripts df['distance'] = df['finger_print'].apply(lambda x: self.hamming_dis(x)) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\series.py", line 4200, in apply mapped = lib.map_infer(values, f, convert=convert_dtype) File "pandas\_libs\lib.pyx", line 2401, in pandas._libs.lib.map_infer File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 190, in df['distance'] = df['finger_print'].apply(lambda x: self.hamming_dis(x)) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 205, in hamming_dis h2 = '0b' + another_finger_print TypeError: can only concatenate str (not "NoneType") to str 10/09/2020 06:05:15 PM INFO simhash similarity service started at 2020-10-09 18:05:15 10/09/2020 06:05:15 PM INFO simhash similarity service started successfully at 2020-10-09 18:05:15 10/09/2020 06:07:50 PM INFO simhash similarity service started at 2020-10-09 18:07:50 10/09/2020 06:07:50 PM INFO simhash similarity service started successfully at 2020-10-09 18:07:50 10/09/2020 06:07:55 PM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 06:07:55 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 06:07:56 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 06:07:56 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001 10/09/2020 06:07:56 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)] 10/09/2020 06:07:56 PM INFO write to database has completed ! 10/09/2020 06:08:05 PM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc return self._engine.get_loc(casted_key) File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item KeyError: 0 The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__ self.get_similarity_scripts() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 196, in get_similarity_scripts self.similarity_scripts.append((sim_df.loc[i, 'file_name'], File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__ return self._getitem_tuple(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple return self._getitem_lowerdim(tup) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim section = self._getitem_axis(key, axis=i) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis return self._get_label(key, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label return self.obj.xs(label, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs loc = self.index.get_loc(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc raise KeyError(key) from err KeyError: 0 10/09/2020 06:08:58 PM INFO simhash similarity service started at 2020-10-09 18:08:58 10/09/2020 06:08:58 PM INFO simhash similarity service started successfully at 2020-10-09 18:08:58 10/09/2020 06:09:11 PM INFO simhash similarity service started at 2020-10-09 18:09:11 10/09/2020 06:09:11 PM INFO simhash similarity service started successfully at 2020-10-09 18:09:11 10/09/2020 06:09:14 PM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 06:09:14 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 06:09:15 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 06:09:16 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001 10/09/2020 06:09:16 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)] 10/09/2020 06:09:16 PM INFO write to database has completed ! 10/09/2020 06:09:29 PM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc return self._engine.get_loc(casted_key) File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item KeyError: 0 The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__ self.get_similarity_scripts() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 196, in get_similarity_scripts self.similarity_scripts.append((sim_df.loc[i, 'file_name'], File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__ return self._getitem_tuple(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple return self._getitem_lowerdim(tup) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim section = self._getitem_axis(key, axis=i) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis return self._get_label(key, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label return self.obj.xs(label, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs loc = self.index.get_loc(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc raise KeyError(key) from err KeyError: 0 10/09/2020 06:10:03 PM INFO simhash similarity service started at 2020-10-09 18:10:03 10/09/2020 06:10:03 PM INFO simhash similarity service started successfully at 2020-10-09 18:10:03 10/09/2020 06:25:50 PM INFO simhash similarity service started at 2020-10-09 18:25:50 10/09/2020 06:25:50 PM INFO simhash similarity service started successfully at 2020-10-09 18:25:50 10/09/2020 06:26:15 PM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 06:26:15 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 06:26:15 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 06:26:16 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001 10/09/2020 06:26:16 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)] 10/09/2020 06:26:16 PM INFO write to database has completed ! 10/09/2020 06:27:42 PM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc return self._engine.get_loc(casted_key) File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item KeyError: 0 The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__ self.get_similarity_scripts() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 196, in get_similarity_scripts self.similarity_scripts.append((sim_df.loc[i, 'file_name'], File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__ return self._getitem_tuple(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple return self._getitem_lowerdim(tup) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim section = self._getitem_axis(key, axis=i) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis return self._get_label(key, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label return self.obj.xs(label, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs loc = self.index.get_loc(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc raise KeyError(key) from err KeyError: 0 10/09/2020 06:30:12 PM INFO simhash similarity service started at 2020-10-09 18:30:12 10/09/2020 06:30:12 PM INFO simhash similarity service started successfully at 2020-10-09 18:30:12 10/09/2020 06:30:46 PM INFO simhash similarity service started at 2020-10-09 18:30:46 10/09/2020 06:30:46 PM INFO simhash similarity service started successfully at 2020-10-09 18:30:46 10/09/2020 06:30:48 PM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 06:30:48 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 06:30:49 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 06:30:49 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001 10/09/2020 06:30:49 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)] 10/09/2020 06:30:49 PM INFO write to database has completed ! 10/09/2020 06:30:58 PM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc return self._engine.get_loc(casted_key) File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item KeyError: 0 The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__ self.get_similarity_scripts() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 196, in get_similarity_scripts self.similarity_scripts.append((sim_df.loc[i, 'file_name'], File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__ return self._getitem_tuple(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple return self._getitem_lowerdim(tup) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim section = self._getitem_axis(key, axis=i) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis return self._get_label(key, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label return self.obj.xs(label, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs loc = self.index.get_loc(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc raise KeyError(key) from err KeyError: 0 10/09/2020 06:34:08 PM INFO simhash similarity service started at 2020-10-09 18:34:08 10/09/2020 06:34:08 PM INFO simhash similarity service started successfully at 2020-10-09 18:34:08 10/09/2020 06:34:15 PM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 06:34:15 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 06:34:16 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 06:34:16 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001 10/09/2020 06:34:16 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)] 10/09/2020 06:34:16 PM INFO write to database has completed ! 10/09/2020 06:34:25 PM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc return self._engine.get_loc(casted_key) File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item KeyError: 0 The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__ self.get_similarity_scripts() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 197, in get_similarity_scripts sim_list.append((sim_df.loc[i, 'file_name'], File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__ return self._getitem_tuple(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple return self._getitem_lowerdim(tup) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim section = self._getitem_axis(key, axis=i) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis return self._get_label(key, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label return self.obj.xs(label, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs loc = self.index.get_loc(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc raise KeyError(key) from err KeyError: 0 10/09/2020 06:36:54 PM INFO simhash similarity service started at 2020-10-09 18:36:54 10/09/2020 06:36:54 PM INFO simhash similarity service started successfully at 2020-10-09 18:36:54 10/09/2020 06:37:00 PM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 06:37:00 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 06:37:01 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 06:37:01 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001 10/09/2020 06:37:01 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)] 10/09/2020 06:37:01 PM INFO write to database has completed ! 10/09/2020 06:37:16 PM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc return self._engine.get_loc(casted_key) File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item KeyError: 0 The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__ self.get_similarity_scripts() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 197, in get_similarity_scripts sim_list.append((sim_df.loc[i, 'file_name'], File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__ return self._getitem_tuple(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple return self._getitem_lowerdim(tup) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim section = self._getitem_axis(key, axis=i) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis return self._get_label(key, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label return self.obj.xs(label, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs loc = self.index.get_loc(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc raise KeyError(key) from err KeyError: 0 10/09/2020 06:40:36 PM INFO simhash similarity service started at 2020-10-09 18:40:36 10/09/2020 06:40:36 PM INFO simhash similarity service started successfully at 2020-10-09 18:40:36 10/09/2020 06:40:37 PM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 06:40:37 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 06:40:38 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 06:40:38 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001 10/09/2020 06:40:38 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)] 10/09/2020 06:40:38 PM INFO write to database has completed ! 10/09/2020 06:40:47 PM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc return self._engine.get_loc(casted_key) File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item KeyError: 0 The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 184, in __init__ self.get_similarity_scripts() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 197, in get_similarity_scripts sim_list.append((sim_df.loc[i, 'file_name'], File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__ return self._getitem_tuple(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple return self._getitem_lowerdim(tup) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim section = self._getitem_axis(key, axis=i) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis return self._get_label(key, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label return self.obj.xs(label, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs loc = self.index.get_loc(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc raise KeyError(key) from err KeyError: 0 10/09/2020 06:45:06 PM INFO simhash similarity service started at 2020-10-09 18:45:06 10/09/2020 06:45:06 PM INFO simhash similarity service started successfully at 2020-10-09 18:45:06 10/09/2020 06:45:27 PM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 06:45:27 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 06:45:27 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 06:45:28 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001 10/09/2020 06:45:28 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)] 10/09/2020 06:45:28 PM INFO write to database has completed ! 10/09/2020 06:46:58 PM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc return self._engine.get_loc(casted_key) File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item KeyError: 0 The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__ self.get_similarity_scripts() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts sim_list.append((sim_df.loc[i, 'file_name'], File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__ return self._getitem_tuple(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple return self._getitem_lowerdim(tup) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim section = self._getitem_axis(key, axis=i) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis return self._get_label(key, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label return self.obj.xs(label, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs loc = self.index.get_loc(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc raise KeyError(key) from err KeyError: 0 10/09/2020 06:47:51 PM INFO simhash similarity service started at 2020-10-09 18:47:51 10/09/2020 06:47:51 PM INFO simhash similarity service started successfully at 2020-10-09 18:47:51 10/09/2020 06:47:58 PM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 06:47:58 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 06:47:59 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 06:48:00 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001 10/09/2020 06:48:00 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)] 10/09/2020 06:48:00 PM INFO write to database has completed ! 10/09/2020 06:48:47 PM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc return self._engine.get_loc(casted_key) File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item KeyError: 0 The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__ self.get_similarity_scripts() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts sim_list.append((sim_df.loc[i, 'file_name'], File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__ return self._getitem_tuple(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple return self._getitem_lowerdim(tup) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim section = self._getitem_axis(key, axis=i) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis return self._get_label(key, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label return self.obj.xs(label, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs loc = self.index.get_loc(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc raise KeyError(key) from err KeyError: 0 10/09/2020 06:50:58 PM INFO simhash similarity service started at 2020-10-09 18:50:58 10/09/2020 06:50:58 PM INFO simhash similarity service started successfully at 2020-10-09 18:50:58 10/09/2020 06:50:59 PM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 06:50:59 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 06:51:00 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 06:51:00 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001 10/09/2020 06:51:00 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)] 10/09/2020 06:51:00 PM INFO write to database has completed ! 10/09/2020 06:51:35 PM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc return self._engine.get_loc(casted_key) File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item KeyError: 0 The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__ self.get_similarity_scripts() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts sim_list.append((sim_df.loc[i, 'file_name'], File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__ return self._getitem_tuple(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple return self._getitem_lowerdim(tup) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim section = self._getitem_axis(key, axis=i) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis return self._get_label(key, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label return self.obj.xs(label, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs loc = self.index.get_loc(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc raise KeyError(key) from err KeyError: 0 10/09/2020 06:55:45 PM INFO simhash similarity service started at 2020-10-09 18:55:45 10/09/2020 06:55:45 PM INFO simhash similarity service started successfully at 2020-10-09 18:55:45 10/09/2020 06:55:46 PM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 06:55:46 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 06:55:47 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 06:55:47 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001 10/09/2020 06:55:47 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)] 10/09/2020 06:55:47 PM INFO write to database has completed ! 10/09/2020 06:56:59 PM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc return self._engine.get_loc(casted_key) File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item KeyError: 0 The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__ self.get_similarity_scripts() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts print((sim_df.loc[i, 'file_name'], File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__ return self._getitem_tuple(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple return self._getitem_lowerdim(tup) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim section = self._getitem_axis(key, axis=i) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis return self._get_label(key, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label return self.obj.xs(label, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs loc = self.index.get_loc(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc raise KeyError(key) from err KeyError: 0 10/09/2020 06:58:04 PM INFO simhash similarity service started at 2020-10-09 18:58:04 10/09/2020 06:58:04 PM INFO simhash similarity service started successfully at 2020-10-09 18:58:04 10/09/2020 06:58:04 PM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 06:58:04 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 06:58:05 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 06:58:05 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001 10/09/2020 06:58:05 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)] 10/09/2020 06:58:05 PM INFO write to database has completed ! 10/09/2020 06:59:19 PM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc return self._engine.get_loc(casted_key) File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item KeyError: 0 The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__ self.get_similarity_scripts() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts print((sim_df.loc[i, 'file_name'], File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__ return self._getitem_tuple(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple return self._getitem_lowerdim(tup) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim section = self._getitem_axis(key, axis=i) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis return self._get_label(key, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label return self.obj.xs(label, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs loc = self.index.get_loc(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc raise KeyError(key) from err KeyError: 0 10/09/2020 07:01:20 PM INFO simhash similarity service started at 2020-10-09 19:01:20 10/09/2020 07:01:20 PM INFO simhash similarity service started successfully at 2020-10-09 19:01:20 10/09/2020 07:01:37 PM INFO ******************************************** NEW REQUEST ******************************************** 10/09/2020 07:01:37 PM INFO the md5 of request script is 3996ca5cb3957e624c10e996af155837 10/09/2020 07:01:38 PM INFO the parsed content is 0923-懂车帝脚本1 功能点:3d看车演员:男1女1场景:室内卧室亮点:图片与3d功能的对比差异,切入点尝试录屏+配音(3d看车画面):老公,这奥迪a4l的鎏金橙也太好看了吧!开车门看看,这空间!这天窗!咱们就买这辆!就要这个轮毂的!太帅了吧!男1睡眼惺忪:咋的了媳妇,大半夜犯啥毛病女1盯着手机:终于选好了!我们明天就去定车吧!!!男1绝望崩溃:定啥车啊,赶紧睡觉吧啊,我明天上午我肯定带你出去看车!女1:不用看了!我都用懂车帝看完了男1:对,那你再好好看看图片,多研究研究,最好咱明天去了直接就定(翻身接着睡)女1:啥年代了选车还看图片,我用的是懂车帝的3d看车!连车启动都能看到!(女1递手机给男1,音效“汽车点火声音”)男1迅速转过来,很兴奋:这在哪看的???女1:懂车帝啊!录屏:3d看车+讯底价+懂车分:进入懂车帝,这里有海量车型供你挑选,选择一辆你喜欢的车,点击这里可以3d看车,帮助你由内而外更加了解爱车。懂车帝还可以一键查询爱车全市底价,点击这里还可以查看懂车分,汇集千万懂车人评测,给你合适的选买建议。 10/09/2020 07:01:39 PM INFO the simhash is 1101011000010011110110111101110111010001001100101000010111111001 10/09/2020 07:01:39 PM INFO the keyword and weight is [('看车', 0.6078695340457627), ('3d', 0.6078695340457627), ('懂车帝', 0.40524635603050846), ('车帝', 0.20262317801525423), ('懂车分', 0.20262317801525423), ('明天', 0.16318369648525421), ('图片', 0.16206352725330508), ('爱车', 0.1613330680898305), ('底价', 0.15656336538745763), ('这里', 0.11376668023347458), ('太帅', 0.1119282243338983), ('音效', 0.1041630486398305), ('选车', 0.10131158900762711), ('选买', 0.10131158900762711), ('连车', 0.10131158900762711), ('懂车', 0.10131158900762711), ('就定', 0.10131158900762711), ('定车', 0.10131158900762711), ('a4l', 0.10131158900762711), ('0923', 0.10131158900762711)] 10/09/2020 07:01:39 PM INFO write to database has completed ! 10/09/2020 07:05:18 PM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2889, in get_loc return self._engine.get_loc(casted_key) File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\index.pyx", line 97, in pandas._libs.index.IndexEngine.get_loc File "pandas\_libs\hashtable_class_helper.pxi", line 1032, in pandas._libs.hashtable.Int64HashTable.get_item File "pandas\_libs\hashtable_class_helper.pxi", line 1039, in pandas._libs.hashtable.Int64HashTable.get_item KeyError: 0 The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 53, in post simi_inst = GetSimilarityScripts(inst.file_name, inst.script_md5, inst.finger_print) File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 185, in __init__ self.get_similarity_scripts() File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 198, in get_similarity_scripts print((sim_df.loc[i, 'file_name'])) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 873, in __getitem__ return self._getitem_tuple(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1044, in _getitem_tuple return self._getitem_lowerdim(tup) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 786, in _getitem_lowerdim section = self._getitem_axis(key, axis=i) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1110, in _getitem_axis return self._get_label(key, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexing.py", line 1059, in _get_label return self.obj.xs(label, axis=axis) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\generic.py", line 3482, in xs loc = self.index.get_loc(key) File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\core\indexes\base.py", line 2891, in get_loc raise KeyError(key) from err KeyError: 0