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'") Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\sql.py", line 56, in sql_inquire cursor.execute(sql) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\cursors.py", line 148, in execute result = self._query(query) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\cursors.py", line 310, in _query conn.query(q) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result result.read() File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 1156, in read first_packet = self.connection._read_packet() File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1054, "Unknown column '17700_name' in 'field list'") Stack (most recent call last): File "D:\Python\Python36-32\lib\threading.py", line 884, in _bootstrap self._bootstrap_inner() File "D:\Python\Python36-32\lib\threading.py", line 916, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0350\pro.py", line 582, in run self.product_name_set() File "D:\git_workspace\sanoh\G01_0350\pro.py", line 501, in product_name_set paramresult = self.sqlclient.sql_inquire_all(sqlstr) File "D:\git_workspace\sanoh\G01_0350\sql.py", line 68, in sql_inquire_all result = self.sql_inquire(sqlstr) File "D:\git_workspace\sanoh\G01_0350\sql.py", line 61, in sql_inquire self.log_file.logger.error('mysql查询异常: {0}'.format(e), exc_info=True, stack_info=True) 2021-10-11 22:56:15,054 - D:\git_workspace\sanoh\G01_0350\sql.py[line:23] - ERROR: mysql连接异常: (1049, "Unknown database 'g01_0350'") Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\sql.py", line 20, in connect database=self.database) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 353, in __init__ self.connect() File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 633, in connect self._request_authentication() File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication auth_packet = _auth.caching_sha2_password_auth(self, auth_packet) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\_auth.py", line 239, in caching_sha2_password_auth pkt = conn._read_packet() File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1049, "Unknown database 'g01_0350'") Stack (most recent call last): File "D:\Python\Python36-32\lib\threading.py", line 884, in _bootstrap self._bootstrap_inner() File "D:\Python\Python36-32\lib\threading.py", line 916, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0350\pro.py", line 584, in run self.product_name_set() File "D:\git_workspace\sanoh\G01_0350\pro.py", line 503, in product_name_set paramresult = self.sqlclient.sql_inquire_all(sqlstr) File "D:\git_workspace\sanoh\G01_0350\sql.py", line 67, in sql_inquire_all self.connect() File "D:\git_workspace\sanoh\G01_0350\sql.py", line 23, in connect self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True) 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 Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\user_openOpc.py", line 82, in opc_start listvalue = self.opcServer.read(self.opcaddrlist, include_error=False, sync=False) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\OpenOPC.py", line 625, in read return list(results) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\OpenOPC.py", line 543, in iread raise TimeoutError('Callback: Timeout waiting for data') OpenOPC.TimeoutError: Callback: Timeout waiting for data Stack (most recent call last): 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__ ret = self.original_func(*self.args, **self.kwargs) File "D:\Python\Python36-32\lib\threading.py", line 884, in _bootstrap self._bootstrap_inner() File "D:\Python\Python36-32\lib\threading.py", line 916, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0350\user_openOpc.py", line 120, in run self.opc_start() File "D:\git_workspace\sanoh\G01_0350\user_openOpc.py", line 107, in opc_start self.log_file.logger.error('opc工作异常: {0}'.format(e), exc_info=True, stack_info=True)