09/30/2020 05:15:10 PM INFO simhash similarity service started at 2020-09-30 17:15:10 09/30/2020 05:15:10 PM ERROR Traceback (most recent call last): File "E:/script_similarity/main.py", line 42, in create_application with open('simhash_model/doc/pre_remove_words.txt','r',encoding='utf-8') as f: FileNotFoundError: [Errno 2] No such file or directory: 'simhash_model/doc/pre_remove_words.txt' 09/30/2020 05:15:41 PM INFO simhash similarity service started at 2020-09-30 17:15:41 09/30/2020 05:15:41 PM ERROR Traceback (most recent call last): File "E:/script_similarity/main.py", line 42, in create_application with open('doc/pre_remove_words.txt','r',encoding='utf-8') as f: FileNotFoundError: [Errno 2] No such file or directory: 'doc/pre_remove_words.txt' 09/30/2020 05:16:17 PM INFO simhash similarity service started at 2020-09-30 17:16:17 09/30/2020 05:16:17 PM ERROR Traceback (most recent call last): File "E:/script_similarity/main.py", line 42, in create_application with open('./simhash_model/doc/pre_remove_words.txt','r',encoding='utf-8') as f: FileNotFoundError: [Errno 2] No such file or directory: './simhash_model/doc/pre_remove_words.txt' 09/30/2020 05:16:31 PM INFO simhash similarity service started at 2020-09-30 17:16:31 09/30/2020 05:16:31 PM ERROR Traceback (most recent call last): File "E:/script_similarity/main.py", line 42, in create_application with open('/simhash_model/doc/pre_remove_words.txt','r',encoding='utf-8') as f: FileNotFoundError: [Errno 2] No such file or directory: '/simhash_model/doc/pre_remove_words.txt' 09/30/2020 05:17:10 PM INFO simhash similarity service started at 2020-09-30 17:17:10 09/30/2020 05:17:10 PM ERROR Traceback (most recent call last): File "E:/script_similarity/main.py", line 42, in create_application with open('E:/script_similarity/simhash_model/doc/pre_remove_words.txt','r',encoding='utf-8') as f: FileNotFoundError: [Errno 2] No such file or directory: 'E:/script_similarity/simhash_model/doc/pre_remove_words.txt' 09/30/2020 05:17:56 PM INFO simhash similarity service started at 2020-09-30 17:17:56 09/30/2020 05:17:56 PM ERROR Traceback (most recent call last): File "E:/script_similarity/main.py", line 45, in create_application with open('simhash_model/doc/stop_words.txt','r',encoding='utf-8') as f: FileNotFoundError: [Errno 2] No such file or directory: 'simhash_model/doc/stop_words.txt' 09/30/2020 05:18:29 PM INFO simhash similarity service started at 2020-09-30 17:18:29 09/30/2020 05:18:29 PM INFO simhash similarity service loaded successfully at 2020-09-30 17:18:29 09/30/2020 05:19:08 PM INFO simhash similarity service started at 2020-09-30 17:19:08 09/30/2020 05:19:08 PM INFO simhash similarity service started successfully at 2020-09-30 17:19:08 09/30/2020 05:53:47 PM INFO simhash similarity service started at 2020-09-30 17:53:47 09/30/2020 05:53:47 PM INFO simhash similarity service started successfully at 2020-09-30 17:53:47 09/30/2020 05:55:36 PM INFO simhash similarity service started at 2020-09-30 17:55:36 09/30/2020 05:55:36 PM INFO simhash similarity service started successfully at 2020-09-30 17:55:36 09/30/2020 05:55:42 PM INFO ******************************************** NEW REQUEST ******************************************** 09/30/2020 05:56:39 PM INFO simhash similarity service started at 2020-09-30 17:56:39 09/30/2020 05:56:39 PM INFO simhash similarity service started successfully at 2020-09-30 17:56:39 09/30/2020 05:56:45 PM INFO ******************************************** NEW REQUEST ******************************************** 09/30/2020 05:56:59 PM INFO simhash similarity service started at 2020-09-30 17:56:59 09/30/2020 05:56:59 PM INFO simhash similarity service started successfully at 2020-09-30 17:56:59 09/30/2020 05:57:13 PM INFO ******************************************** NEW REQUEST ******************************************** 09/30/2020 05:57:13 PM INFO the md5 of request script is 123 09/30/2020 05:57:13 PM 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)