error.log.2021-10-12 5.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586
  1. 2021-10-11 17:26:18,117 - D:\git_workspace\sanoh\G01_0350\sql.py[line:61] - ERROR: mysql查询异常: (1054, "Unknown column '17700_name' in 'field list'")
  2. Traceback (most recent call last):
  3. File "D:\git_workspace\sanoh\G01_0350\sql.py", line 56, in sql_inquire
  4. cursor.execute(sql)
  5. File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\cursors.py", line 148, in execute
  6. result = self._query(query)
  7. File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\cursors.py", line 310, in _query
  8. conn.query(q)
  9. File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 548, in query
  10. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  11. File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
  12. result.read()
  13. File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 1156, in read
  14. first_packet = self.connection._read_packet()
  15. File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  16. packet.raise_for_error()
  17. File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  18. err.raise_mysql_exception(self._data)
  19. File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  20. raise errorclass(errno, errval)
  21. pymysql.err.OperationalError: (1054, "Unknown column '17700_name' in 'field list'")
  22. Stack (most recent call last):
  23. File "D:\Python\Python36-32\lib\threading.py", line 884, in _bootstrap
  24. self._bootstrap_inner()
  25. File "D:\Python\Python36-32\lib\threading.py", line 916, in _bootstrap_inner
  26. self.run()
  27. File "D:\git_workspace\sanoh\G01_0350\pro.py", line 582, in run
  28. self.product_name_set()
  29. File "D:\git_workspace\sanoh\G01_0350\pro.py", line 501, in product_name_set
  30. paramresult = self.sqlclient.sql_inquire_all(sqlstr)
  31. File "D:\git_workspace\sanoh\G01_0350\sql.py", line 68, in sql_inquire_all
  32. result = self.sql_inquire(sqlstr)
  33. File "D:\git_workspace\sanoh\G01_0350\sql.py", line 61, in sql_inquire
  34. self.log_file.logger.error('mysql查询异常: {0}'.format(e), exc_info=True, stack_info=True)
  35. 2021-10-11 22:56:15,054 - D:\git_workspace\sanoh\G01_0350\sql.py[line:23] - ERROR: mysql连接异常: (1049, "Unknown database 'g01_0350'")
  36. Traceback (most recent call last):
  37. File "D:\git_workspace\sanoh\G01_0350\sql.py", line 20, in connect
  38. database=self.database)
  39. File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 353, in __init__
  40. self.connect()
  41. File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 633, in connect
  42. self._request_authentication()
  43. File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication
  44. auth_packet = _auth.caching_sha2_password_auth(self, auth_packet)
  45. File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\_auth.py", line 239, in caching_sha2_password_auth
  46. pkt = conn._read_packet()
  47. File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  48. packet.raise_for_error()
  49. File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  50. err.raise_mysql_exception(self._data)
  51. File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  52. raise errorclass(errno, errval)
  53. pymysql.err.OperationalError: (1049, "Unknown database 'g01_0350'")
  54. Stack (most recent call last):
  55. File "D:\Python\Python36-32\lib\threading.py", line 884, in _bootstrap
  56. self._bootstrap_inner()
  57. File "D:\Python\Python36-32\lib\threading.py", line 916, in _bootstrap_inner
  58. self.run()
  59. File "D:\git_workspace\sanoh\G01_0350\pro.py", line 584, in run
  60. self.product_name_set()
  61. File "D:\git_workspace\sanoh\G01_0350\pro.py", line 503, in product_name_set
  62. paramresult = self.sqlclient.sql_inquire_all(sqlstr)
  63. File "D:\git_workspace\sanoh\G01_0350\sql.py", line 67, in sql_inquire_all
  64. self.connect()
  65. File "D:\git_workspace\sanoh\G01_0350\sql.py", line 23, in connect
  66. self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True)
  67. 2021-10-12 02:17:32,806 - D:\git_workspace\sanoh\G01_0350\user_openOpc.py[line:107] - ERROR: opc工作异常: Callback: Timeout waiting for data
  68. Traceback (most recent call last):
  69. File "D:\git_workspace\sanoh\G01_0350\user_openOpc.py", line 82, in opc_start
  70. listvalue = self.opcServer.read(self.opcaddrlist, include_error=False, sync=False)
  71. File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\OpenOPC.py", line 625, in read
  72. return list(results)
  73. File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\OpenOPC.py", line 543, in iread
  74. raise TimeoutError('Callback: Timeout waiting for data')
  75. OpenOPC.TimeoutError: Callback: Timeout waiting for data
  76. Stack (most recent call last):
  77. File "D:\Program Files\JetBrains\PyCharm Community Edition 2020.2.2\plugins\python-ce\helpers\pydev\_pydev_bundle\pydev_monkey.py", line 773, in __call__
  78. ret = self.original_func(*self.args, **self.kwargs)
  79. File "D:\Python\Python36-32\lib\threading.py", line 884, in _bootstrap
  80. self._bootstrap_inner()
  81. File "D:\Python\Python36-32\lib\threading.py", line 916, in _bootstrap_inner
  82. self.run()
  83. File "D:\git_workspace\sanoh\G01_0350\user_openOpc.py", line 120, in run
  84. self.opc_start()
  85. File "D:\git_workspace\sanoh\G01_0350\user_openOpc.py", line 107, in opc_start
  86. self.log_file.logger.error('opc工作异常: {0}'.format(e), exc_info=True, stack_info=True)