2022-08-01 17:16:36,600 - D:\git_workspace\sanoh\G01_0345\sql.py[line:24] - ERROR: mysql连接异常: (1049, "Unknown database 'g01_0345'") Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\sql.py", line 21, in connect database=self.database) File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 353, in __init__ self.connect() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 633, in connect self._request_authentication() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication auth_packet = _auth.caching_sha2_password_auth(self, auth_packet) File "D:\Python\Python37-32\lib\site-packages\pymysql\_auth.py", line 239, in caching_sha2_password_auth pkt = conn._read_packet() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "D:\Python\Python37-32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "D:\Python\Python37-32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1049, "Unknown database 'g01_0345'") Stack (most recent call last): File "D:\Python\Python37-32\lib\threading.py", line 890, in _bootstrap self._bootstrap_inner() File "D:\Python\Python37-32\lib\threading.py", line 926, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 597, in run self.product_name_set() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 508, in product_name_set paramresult = self.sqlclient.sql_inquire_all(sqlstr) File "D:\git_workspace\sanoh\G01_0345\sql.py", line 68, in sql_inquire_all self.connect() File "D:\git_workspace\sanoh\G01_0345\sql.py", line 24, in connect self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True) 2022-08-01 17:16:36,604 - D:\git_workspace\sanoh\G01_0345\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\ezcad.py", line 21, in run win32api.ShellExecute(0, 'open', self.exename, self.filename, self.exepath, 1) pywintypes.error: (2, 'ShellExecute', '系统找不到指定的文件。') Stack (most recent call last): File "D:\Python\Python37-32\lib\threading.py", line 890, in _bootstrap self._bootstrap_inner() File "D:\Python\Python37-32\lib\threading.py", line 926, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0345\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2022-08-01 17:17:07,047 - D:\git_workspace\sanoh\G01_0345\sql.py[line:24] - ERROR: mysql连接异常: (1049, "Unknown database 'g01_0345'") Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\sql.py", line 21, in connect database=self.database) File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 353, in __init__ self.connect() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 633, in connect self._request_authentication() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication auth_packet = _auth.caching_sha2_password_auth(self, auth_packet) File "D:\Python\Python37-32\lib\site-packages\pymysql\_auth.py", line 239, in caching_sha2_password_auth pkt = conn._read_packet() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "D:\Python\Python37-32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "D:\Python\Python37-32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1049, "Unknown database 'g01_0345'") Stack (most recent call last): File "D:\Python\Python37-32\lib\threading.py", line 890, in _bootstrap self._bootstrap_inner() File "D:\Python\Python37-32\lib\threading.py", line 926, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 597, in run self.product_name_set() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 508, in product_name_set paramresult = self.sqlclient.sql_inquire_all(sqlstr) File "D:\git_workspace\sanoh\G01_0345\sql.py", line 68, in sql_inquire_all self.connect() File "D:\git_workspace\sanoh\G01_0345\sql.py", line 24, in connect self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True) 2022-08-01 17:17:07,073 - D:\git_workspace\sanoh\G01_0345\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\ezcad.py", line 21, in run win32api.ShellExecute(0, 'open', self.exename, self.filename, self.exepath, 1) pywintypes.error: (2, 'ShellExecute', '系统找不到指定的文件。') Stack (most recent call last): File "D:\Python\Python37-32\lib\threading.py", line 890, in _bootstrap self._bootstrap_inner() File "D:\Python\Python37-32\lib\threading.py", line 926, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0345\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2022-08-01 17:17:32,846 - D:\git_workspace\sanoh\G01_0345\sql.py[line:24] - ERROR: mysql连接异常: (1049, "Unknown database 'g01_0345'") Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\sql.py", line 21, in connect database=self.database) File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 353, in __init__ self.connect() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 633, in connect self._request_authentication() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication auth_packet = _auth.caching_sha2_password_auth(self, auth_packet) File "D:\Python\Python37-32\lib\site-packages\pymysql\_auth.py", line 239, in caching_sha2_password_auth pkt = conn._read_packet() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "D:\Python\Python37-32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "D:\Python\Python37-32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1049, "Unknown database 'g01_0345'") Stack (most recent call last): File "D:\Python\Python37-32\lib\threading.py", line 890, in _bootstrap self._bootstrap_inner() File "D:\Python\Python37-32\lib\threading.py", line 926, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 597, in run self.product_name_set() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 508, in product_name_set paramresult = self.sqlclient.sql_inquire_all(sqlstr) File "D:\git_workspace\sanoh\G01_0345\sql.py", line 68, in sql_inquire_all self.connect() File "D:\git_workspace\sanoh\G01_0345\sql.py", line 24, in connect self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True) 2022-08-01 17:17:32,887 - D:\git_workspace\sanoh\G01_0345\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\ezcad.py", line 21, in run win32api.ShellExecute(0, 'open', self.exename, self.filename, self.exepath, 1) pywintypes.error: (2, 'ShellExecute', '系统找不到指定的文件。') Stack (most recent call last): File "D:\Python\Python37-32\lib\threading.py", line 890, in _bootstrap self._bootstrap_inner() File "D:\Python\Python37-32\lib\threading.py", line 926, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0345\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2022-08-01 17:18:06,089 - D:\git_workspace\sanoh\G01_0345\sql.py[line:24] - ERROR: mysql连接异常: (1049, "Unknown database 'g01_0345'") Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\sql.py", line 21, in connect database=self.database) File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 353, in __init__ self.connect() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 633, in connect self._request_authentication() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication auth_packet = _auth.caching_sha2_password_auth(self, auth_packet) File "D:\Python\Python37-32\lib\site-packages\pymysql\_auth.py", line 239, in caching_sha2_password_auth pkt = conn._read_packet() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "D:\Python\Python37-32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "D:\Python\Python37-32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1049, "Unknown database 'g01_0345'") Stack (most recent call last): File "D:\Python\Python37-32\lib\threading.py", line 890, in _bootstrap self._bootstrap_inner() File "D:\Python\Python37-32\lib\threading.py", line 926, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 597, in run self.product_name_set() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 508, in product_name_set paramresult = self.sqlclient.sql_inquire_all(sqlstr) File "D:\git_workspace\sanoh\G01_0345\sql.py", line 68, in sql_inquire_all self.connect() File "D:\git_workspace\sanoh\G01_0345\sql.py", line 24, in connect self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True) 2022-08-01 17:18:06,120 - D:\git_workspace\sanoh\G01_0345\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\ezcad.py", line 21, in run win32api.ShellExecute(0, 'open', self.exename, self.filename, self.exepath, 1) pywintypes.error: (2, 'ShellExecute', '系统找不到指定的文件。') Stack (most recent call last): File "D:\Python\Python37-32\lib\threading.py", line 890, in _bootstrap self._bootstrap_inner() File "D:\Python\Python37-32\lib\threading.py", line 926, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0345\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2022-08-01 17:18:48,524 - D:\git_workspace\sanoh\G01_0345\sql.py[line:24] - ERROR: mysql连接异常: (1049, "Unknown database 'g01_0345'") Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\sql.py", line 21, in connect database=self.database) File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 353, in __init__ self.connect() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 633, in connect self._request_authentication() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication auth_packet = _auth.caching_sha2_password_auth(self, auth_packet) File "D:\Python\Python37-32\lib\site-packages\pymysql\_auth.py", line 239, in caching_sha2_password_auth pkt = conn._read_packet() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "D:\Python\Python37-32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "D:\Python\Python37-32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1049, "Unknown database 'g01_0345'") Stack (most recent call last): File "D:\Python\Python37-32\lib\threading.py", line 890, in _bootstrap self._bootstrap_inner() File "D:\Python\Python37-32\lib\threading.py", line 926, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 597, in run self.product_name_set() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 508, in product_name_set paramresult = self.sqlclient.sql_inquire_all(sqlstr) File "D:\git_workspace\sanoh\G01_0345\sql.py", line 68, in sql_inquire_all self.connect() File "D:\git_workspace\sanoh\G01_0345\sql.py", line 24, in connect self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True) 2022-08-01 17:18:48,551 - D:\git_workspace\sanoh\G01_0345\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\ezcad.py", line 21, in run win32api.ShellExecute(0, 'open', self.exename, self.filename, self.exepath, 1) pywintypes.error: (2, 'ShellExecute', '系统找不到指定的文件。') Stack (most recent call last): File "D:\Python\Python37-32\lib\threading.py", line 890, in _bootstrap self._bootstrap_inner() File "D:\Python\Python37-32\lib\threading.py", line 926, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0345\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2022-08-01 17:19:11,299 - D:\git_workspace\sanoh\G01_0345\sql.py[line:24] - ERROR: mysql连接异常: (1049, "Unknown database 'g01_0345'") Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\sql.py", line 21, in connect database=self.database) File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 353, in __init__ self.connect() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 633, in connect self._request_authentication() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication auth_packet = _auth.caching_sha2_password_auth(self, auth_packet) File "D:\Python\Python37-32\lib\site-packages\pymysql\_auth.py", line 239, in caching_sha2_password_auth pkt = conn._read_packet() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "D:\Python\Python37-32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "D:\Python\Python37-32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1049, "Unknown database 'g01_0345'") Stack (most recent call last): File "D:\Python\Python37-32\lib\threading.py", line 890, in _bootstrap self._bootstrap_inner() File "D:\Python\Python37-32\lib\threading.py", line 926, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 597, in run self.product_name_set() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 508, in product_name_set paramresult = self.sqlclient.sql_inquire_all(sqlstr) File "D:\git_workspace\sanoh\G01_0345\sql.py", line 68, in sql_inquire_all self.connect() File "D:\git_workspace\sanoh\G01_0345\sql.py", line 24, in connect self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True) 2022-08-01 17:19:11,327 - D:\git_workspace\sanoh\G01_0345\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\ezcad.py", line 21, in run win32api.ShellExecute(0, 'open', self.exename, self.filename, self.exepath, 1) pywintypes.error: (2, 'ShellExecute', '系统找不到指定的文件。') Stack (most recent call last): File "D:\Python\Python37-32\lib\threading.py", line 890, in _bootstrap self._bootstrap_inner() File "D:\Python\Python37-32\lib\threading.py", line 926, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0345\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2022-08-01 17:19:30,602 - D:\git_workspace\sanoh\G01_0345\sql.py[line:24] - ERROR: mysql连接异常: (1049, "Unknown database 'g01_0345'") Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\sql.py", line 21, in connect database=self.database) File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 353, in __init__ self.connect() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 633, in connect self._request_authentication() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication auth_packet = _auth.caching_sha2_password_auth(self, auth_packet) File "D:\Python\Python37-32\lib\site-packages\pymysql\_auth.py", line 239, in caching_sha2_password_auth pkt = conn._read_packet() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "D:\Python\Python37-32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "D:\Python\Python37-32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1049, "Unknown database 'g01_0345'") Stack (most recent call last): File "D:\Python\Python37-32\lib\threading.py", line 890, in _bootstrap self._bootstrap_inner() File "D:\Python\Python37-32\lib\threading.py", line 926, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 597, in run self.product_name_set() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 508, in product_name_set paramresult = self.sqlclient.sql_inquire_all(sqlstr) File "D:\git_workspace\sanoh\G01_0345\sql.py", line 68, in sql_inquire_all self.connect() File "D:\git_workspace\sanoh\G01_0345\sql.py", line 24, in connect self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True) 2022-08-01 17:19:30,631 - D:\git_workspace\sanoh\G01_0345\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\ezcad.py", line 21, in run win32api.ShellExecute(0, 'open', self.exename, self.filename, self.exepath, 1) pywintypes.error: (2, 'ShellExecute', '系统找不到指定的文件。') Stack (most recent call last): File "D:\Python\Python37-32\lib\threading.py", line 890, in _bootstrap self._bootstrap_inner() File "D:\Python\Python37-32\lib\threading.py", line 926, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0345\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2022-08-01 18:32:12,916 - D:\git_workspace\sanoh\G01_0345\sql.py[line:24] - ERROR: mysql连接异常: (1049, "Unknown database 'g01_0345'") Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\sql.py", line 21, in connect database=self.database) File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 353, in __init__ self.connect() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 633, in connect self._request_authentication() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication auth_packet = _auth.caching_sha2_password_auth(self, auth_packet) File "D:\Python\Python37-32\lib\site-packages\pymysql\_auth.py", line 239, in caching_sha2_password_auth pkt = conn._read_packet() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "D:\Python\Python37-32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "D:\Python\Python37-32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1049, "Unknown database 'g01_0345'") Stack (most recent call last): File "D:\Python\Python37-32\lib\threading.py", line 890, in _bootstrap self._bootstrap_inner() File "D:\Python\Python37-32\lib\threading.py", line 926, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 605, in run self.product_name_set() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 516, in product_name_set paramresult = self.sqlclient.sql_inquire_all(sqlstr) File "D:\git_workspace\sanoh\G01_0345\sql.py", line 68, in sql_inquire_all self.connect() File "D:\git_workspace\sanoh\G01_0345\sql.py", line 24, in connect self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True) 2022-08-01 18:32:12,948 - D:\git_workspace\sanoh\G01_0345\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\ezcad.py", line 21, in run win32api.ShellExecute(0, 'open', self.exename, self.filename, self.exepath, 1) pywintypes.error: (2, 'ShellExecute', '系统找不到指定的文件。') Stack (most recent call last): File "D:\Python\Python37-32\lib\threading.py", line 890, in _bootstrap self._bootstrap_inner() File "D:\Python\Python37-32\lib\threading.py", line 926, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0345\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2022-08-01 23:48:12,066 - D:\git_workspace\sanoh\G01_0345\sql.py[line:47] - ERROR: mysql执行异常: (1366, "Incorrect integer value: 'NULL' for column 'end_time' at row 1") Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\sql.py", line 42, in sql_action cursor.execute(sql) File "D:\Python\Python36-32\lib\site-packages\pymysql\cursors.py", line 148, in execute result = self._query(query) File "D:\Python\Python36-32\lib\site-packages\pymysql\cursors.py", line 310, in _query conn.query(q) File "D:\Python\Python36-32\lib\site-packages\pymysql\connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\Python\Python36-32\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result result.read() File "D:\Python\Python36-32\lib\site-packages\pymysql\connections.py", line 1156, in read first_packet = self.connection._read_packet() File "D:\Python\Python36-32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "D:\Python\Python36-32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "D:\Python\Python36-32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.DataError: (1366, "Incorrect integer value: 'NULL' for column 'end_time' at row 1") 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_0345\pro.py", line 641, in run self.batch_tbl_check() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 338, in batch_tbl_check self.insert_batch_tbl() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 325, in insert_batch_tbl self.sqlclient.sql_action_all(sqlstr) File "D:\git_workspace\sanoh\G01_0345\sql.py", line 77, in sql_action_all result = self.sql_action(sqlstr) File "D:\git_workspace\sanoh\G01_0345\sql.py", line 47, in sql_action self.log_file.logger.error('mysql执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2022-08-01 23:48:56,014 - D:\git_workspace\sanoh\G01_0345\sql.py[line:47] - ERROR: mysql执行异常: (1366, "Incorrect integer value: 'NULL' for column 'end_time' at row 1") Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0345\sql.py", line 42, in sql_action cursor.execute(sql) File "D:\Python\Python36-32\lib\site-packages\pymysql\cursors.py", line 148, in execute result = self._query(query) File "D:\Python\Python36-32\lib\site-packages\pymysql\cursors.py", line 310, in _query conn.query(q) File "D:\Python\Python36-32\lib\site-packages\pymysql\connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\Python\Python36-32\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result result.read() File "D:\Python\Python36-32\lib\site-packages\pymysql\connections.py", line 1156, in read first_packet = self.connection._read_packet() File "D:\Python\Python36-32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "D:\Python\Python36-32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "D:\Python\Python36-32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.DataError: (1366, "Incorrect integer value: 'NULL' for column 'end_time' at row 1") 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_0345\pro.py", line 641, in run self.batch_tbl_check() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 338, in batch_tbl_check self.insert_batch_tbl() File "D:\git_workspace\sanoh\G01_0345\pro.py", line 325, in insert_batch_tbl self.sqlclient.sql_action_all(sqlstr) File "D:\git_workspace\sanoh\G01_0345\sql.py", line 77, in sql_action_all result = self.sql_action(sqlstr) File "D:\git_workspace\sanoh\G01_0345\sql.py", line 47, in sql_action self.log_file.logger.error('mysql执行异常: {0}'.format(e), exc_info=True, stack_info=True)