2023-05-11 13:58:27,572 - D:\git_workspace\sanoh\G01_0350\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\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_0350\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2023-05-11 14:22:45,405 - D:\git_workspace\sanoh\G01_0350\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\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_0350\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2023-05-11 14:40:55,457 - D:\git_workspace\sanoh\G01_0350\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\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_0350\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2023-05-11 14:53:58,355 - D:\git_workspace\sanoh\G01_0350\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\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_0350\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2023-05-11 14:55:10,004 - D:\git_workspace\sanoh\G01_0350\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\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_0350\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2023-05-11 15:03:31,908 - D:\git_workspace\sanoh\G01_0350\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\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_0350\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2023-05-11 15:03:47,816 - D:\git_workspace\sanoh\G01_0350\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\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_0350\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2023-05-11 15:05:15,608 - D:\git_workspace\sanoh\G01_0350\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\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_0350\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2023-05-11 15:31:24,396 - D:\git_workspace\sanoh\G01_0350\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\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_0350\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2023-05-11 15:32:27,096 - D:\git_workspace\sanoh\G01_0350\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\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_0350\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2023-05-11 15:33:24,135 - D:\git_workspace\sanoh\G01_0350\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\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_0350\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2023-05-11 15:35:11,282 - D:\git_workspace\sanoh\G01_0350\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\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_0350\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2023-05-11 15:39:17,354 - D:\git_workspace\sanoh\G01_0350\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\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_0350\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2023-05-11 15:41:02,588 - D:\git_workspace\sanoh\G01_0350\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\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_0350\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2023-05-11 15:42:05,531 - D:\git_workspace\sanoh\G01_0350\sql.py[line:47] - ERROR: mysql执行异常: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM product_data_tbl WHERE end_time >= 1682870400 and end_time <= 1683820799' at line 1") Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\sql.py", line 42, in sql_action cursor.execute(sql) File "D:\Python\Python37-32\lib\site-packages\pymysql\cursors.py", line 148, in execute result = self._query(query) File "D:\Python\Python37-32\lib\site-packages\pymysql\cursors.py", line 310, in _query conn.query(q) File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result result.read() File "D:\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 1156, in read first_packet = self.connection._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.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM product_data_tbl WHERE end_time >= 1682870400 and end_time <= 1683820799' at line 1") 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_0350\output_file.py", line 233, in run self.delete_database_data() File "D:\git_workspace\sanoh\G01_0350\output_file.py", line 226, in delete_database_data self.sqlclient.sql_action_all(sqlstr) File "D:\git_workspace\sanoh\G01_0350\sql.py", line 77, in sql_action_all result = self.sql_action(sqlstr) File "D:\git_workspace\sanoh\G01_0350\sql.py", line 47, in sql_action self.log_file.logger.error('mysql执行异常: {0}'.format(e), exc_info=True, stack_info=True) 2023-05-11 15:44:15,815 - D:\git_workspace\sanoh\G01_0350\ezcad.py[line:27] - ERROR: 打标机软件执行异常: (2, 'ShellExecute', '系统找不到指定的文件。') Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\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_0350\ezcad.py", line 27, in run self.log_file.logger.error('打标机软件执行异常: {0}'.format(e), exc_info=True, stack_info=True)