model_service.log.2020-09-30 8.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124
  1. 09/30/2020 05:15:10 PM INFO simhash similarity service started at 2020-09-30 17:15:10
  2. 09/30/2020 05:15:10 PM ERROR Traceback (most recent call last):
  3. File "E:/script_similarity/main.py", line 42, in create_application
  4. with open('simhash_model/doc/pre_remove_words.txt','r',encoding='utf-8') as f:
  5. FileNotFoundError: [Errno 2] No such file or directory: 'simhash_model/doc/pre_remove_words.txt'
  6. 09/30/2020 05:15:41 PM INFO simhash similarity service started at 2020-09-30 17:15:41
  7. 09/30/2020 05:15:41 PM ERROR Traceback (most recent call last):
  8. File "E:/script_similarity/main.py", line 42, in create_application
  9. with open('doc/pre_remove_words.txt','r',encoding='utf-8') as f:
  10. FileNotFoundError: [Errno 2] No such file or directory: 'doc/pre_remove_words.txt'
  11. 09/30/2020 05:16:17 PM INFO simhash similarity service started at 2020-09-30 17:16:17
  12. 09/30/2020 05:16:17 PM ERROR Traceback (most recent call last):
  13. File "E:/script_similarity/main.py", line 42, in create_application
  14. with open('./simhash_model/doc/pre_remove_words.txt','r',encoding='utf-8') as f:
  15. FileNotFoundError: [Errno 2] No such file or directory: './simhash_model/doc/pre_remove_words.txt'
  16. 09/30/2020 05:16:31 PM INFO simhash similarity service started at 2020-09-30 17:16:31
  17. 09/30/2020 05:16:31 PM ERROR Traceback (most recent call last):
  18. File "E:/script_similarity/main.py", line 42, in create_application
  19. with open('/simhash_model/doc/pre_remove_words.txt','r',encoding='utf-8') as f:
  20. FileNotFoundError: [Errno 2] No such file or directory: '/simhash_model/doc/pre_remove_words.txt'
  21. 09/30/2020 05:17:10 PM INFO simhash similarity service started at 2020-09-30 17:17:10
  22. 09/30/2020 05:17:10 PM ERROR Traceback (most recent call last):
  23. File "E:/script_similarity/main.py", line 42, in create_application
  24. with open('E:/script_similarity/simhash_model/doc/pre_remove_words.txt','r',encoding='utf-8') as f:
  25. FileNotFoundError: [Errno 2] No such file or directory: 'E:/script_similarity/simhash_model/doc/pre_remove_words.txt'
  26. 09/30/2020 05:17:56 PM INFO simhash similarity service started at 2020-09-30 17:17:56
  27. 09/30/2020 05:17:56 PM ERROR Traceback (most recent call last):
  28. File "E:/script_similarity/main.py", line 45, in create_application
  29. with open('simhash_model/doc/stop_words.txt','r',encoding='utf-8') as f:
  30. FileNotFoundError: [Errno 2] No such file or directory: 'simhash_model/doc/stop_words.txt'
  31. 09/30/2020 05:18:29 PM INFO simhash similarity service started at 2020-09-30 17:18:29
  32. 09/30/2020 05:18:29 PM INFO simhash similarity service loaded successfully at 2020-09-30 17:18:29
  33. 09/30/2020 05:19:08 PM INFO simhash similarity service started at 2020-09-30 17:19:08
  34. 09/30/2020 05:19:08 PM INFO simhash similarity service started successfully at 2020-09-30 17:19:08
  35. 09/30/2020 05:53:47 PM INFO simhash similarity service started at 2020-09-30 17:53:47
  36. 09/30/2020 05:53:47 PM INFO simhash similarity service started successfully at 2020-09-30 17:53:47
  37. 09/30/2020 05:55:36 PM INFO simhash similarity service started at 2020-09-30 17:55:36
  38. 09/30/2020 05:55:36 PM INFO simhash similarity service started successfully at 2020-09-30 17:55:36
  39. 09/30/2020 05:55:42 PM INFO ******************************************** NEW REQUEST ********************************************
  40. 09/30/2020 05:56:39 PM INFO simhash similarity service started at 2020-09-30 17:56:39
  41. 09/30/2020 05:56:39 PM INFO simhash similarity service started successfully at 2020-09-30 17:56:39
  42. 09/30/2020 05:56:45 PM INFO ******************************************** NEW REQUEST ********************************************
  43. 09/30/2020 05:56:59 PM INFO simhash similarity service started at 2020-09-30 17:56:59
  44. 09/30/2020 05:56:59 PM INFO simhash similarity service started successfully at 2020-09-30 17:56:59
  45. 09/30/2020 05:57:13 PM INFO ******************************************** NEW REQUEST ********************************************
  46. 09/30/2020 05:57:13 PM INFO the md5 of request script is 123
  47. 09/30/2020 05:57:13 PM ERROR Traceback (most recent call last):
  48. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  49. cursor, statement, context
  50. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  51. cursor.execute(statement)
  52. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  53. result = self._query(query)
  54. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  55. conn.query(q)
  56. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  57. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  58. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  59. result.read()
  60. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  61. first_packet = self.connection._read_packet()
  62. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  63. packet.check_error()
  64. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  65. err.raise_mysql_exception(self._data)
  66. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  67. raise errorclass(errno, errval)
  68. pymysql.err.InternalError: (1054, "Unknown column 'self.script_md5' in 'where clause'")
  69. The above exception was the direct cause of the following exception:
  70. Traceback (most recent call last):
  71. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 39, in post
  72. inst.parse_content()
  73. File "E:\script_similarity\simhash_model\simhash_distance_handler.py", line 87, in parse_content
  74. df = pd.read_sql(sql, engine)
  75. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 515, in read_sql
  76. chunksize=chunksize,
  77. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1295, in read_query
  78. result = self.execute(*args)
  79. File "D:\anaconda3\envs\simhash\lib\site-packages\pandas\io\sql.py", line 1162, in execute
  80. *args, **kwargs
  81. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 2237, in execute
  82. return connection.execute(statement, *multiparams, **params)
  83. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
  84. return self._execute_text(object_, multiparams, params)
  85. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1178, in _execute_text
  86. parameters,
  87. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  88. e, statement, parameters, cursor, context
  89. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  90. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  91. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  92. raise exception
  93. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\base.py", line 1267, in _execute_context
  94. cursor, statement, context
  95. File "D:\anaconda3\envs\simhash\lib\site-packages\sqlalchemy\engine\default.py", line 596, in do_execute_no_params
  96. cursor.execute(statement)
  97. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 170, in execute
  98. result = self._query(query)
  99. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\cursors.py", line 328, in _query
  100. conn.query(q)
  101. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 517, in query
  102. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  103. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
  104. result.read()
  105. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 1075, in read
  106. first_packet = self.connection._read_packet()
  107. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
  108. packet.check_error()
  109. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\protocol.py", line 220, in check_error
  110. err.raise_mysql_exception(self._data)
  111. File "D:\anaconda3\envs\simhash\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
  112. raise errorclass(errno, errval)
  113. sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'self.script_md5' in 'where clause'")
  114. [SQL: select * from ctop_script_file where id = self.script_md5 ]
  115. (Background on this error at: http://sqlalche.me/e/13/2j85)