100605 17:46:23 [Note] Event Scheduler: Purging the queue. 0 events 100605 17:46:23 InnoDB: Starting shutdown... 100605 17:46:26 InnoDB: Shutdown completed; log sequence number 98 869591802 100605 17:46:26 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 100605 17:46:26 mysqld_safe mysqld from pid file /usr/local/mysql/data/stageserver.pid ended 100823 21:34:50 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 100823 21:34:50 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead. 100823 21:34:50 [Note] Plugin 'FEDERATED' is disabled. 100823 21:34:51 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. InnoDB: If you are installing InnoDB, remember that you must create InnoDB: directories yourself, InnoDB does not create them. 100823 21:34:51 InnoDB: Error: trying to open a table, but could not InnoDB: open the tablespace file './tmp/#sql2b8b_13_0.ibd'! InnoDB: Have you moved InnoDB .ibd files around without using the InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE? InnoDB: It is also possible that this is a temporary table #sql..., InnoDB: and MySQL removed the .ibd file for this. InnoDB: Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting-datadict.html InnoDB: for how to resolve the issue. 100823 21:34:51 InnoDB: Started; log sequence number 109 1012720164 100823 21:34:51 [Note] Event Scheduler: Loaded 0 events 100823 21:34:51 [Note] /opt/mysql-advanced-gpl-5.1.45-linux-i686-glibc23/bin/mysqld: ready for connections. Version: '5.1.45-enterprise-gpl-advanced-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (GPL) 100824 2:05:35 [Note] /opt/mysql-advanced-gpl-5.1.45-linux-i686-glibc23/bin/mysqld: Normal shutdown 100824 2:05:35 [Note] Event Scheduler: Purging the queue. 0 events 100824 2:05:35 InnoDB: Starting shutdown... 100824 2:05:38 InnoDB: Shutdown completed; log sequence number 109 1012720174 100824 2:05:38 [Note] /opt/mysql-advanced-gpl-5.1.45-linux-i686-glibc23/bin/mysqld: Shutdown complete 100824 02:05:38 mysqld_safe mysqld from pid file /usr/local/mysql/data/stageserver.pid ended 100824 02:07:38 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 100824 2:07:38 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead. 100824 2:07:38 [Note] Plugin 'FEDERATED' is disabled. 100824 2:07:39 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. InnoDB: If you are installing InnoDB, remember that you must create InnoDB: directories yourself, InnoDB does not create them. 100824 2:07:39 InnoDB: Error: trying to open a table, but could not InnoDB: open the tablespace file './tmp/#sql2b8b_13_0.ibd'! InnoDB: Have you moved InnoDB .ibd files around without using the InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE? InnoDB: It is also possible that this is a temporary table #sql..., InnoDB: and MySQL removed the .ibd file for this. InnoDB: Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting-datadict.html InnoDB: for how to resolve the issue. 100824 2:07:39 InnoDB: Started; log sequence number 109 1012720174 100824 2:07:39 [Note] Event Scheduler: Loaded 0 events 100824 2:07:39 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.1.45-enterprise-gpl-advanced-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (GPL) 100824 4:27:30 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:27:30 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:27:30 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:27:30 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:27:40 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:27:40 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:27:54 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:27:54 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:27:54 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:27:54 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:27:54 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:27:54 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:27:54 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:27:54 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:27:54 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:27:54 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:28:32 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:28:32 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:31:41 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:31:41 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:31:49 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:31:49 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:31:49 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:31:49 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:32:20 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:32:20 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:32:20 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:32:20 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:32:20 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:32:20 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:32:20 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:32:20 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:32:20 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:32:20 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:32:20 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:32:20 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:32:20 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:32:20 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:32:40 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:32:40 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:33:32 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:33:32 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:33:32 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:33:32 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:33:51 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:33:51 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:33:51 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:33:51 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:34:41 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:34:41 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:34:51 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:34:51 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:34:51 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:34:51 InnoDB: Error: unlock row could not find a 4 mode lock on the record 100824 4:40:48 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 100824 4:40:48 [Note] Event Scheduler: Purging the queue. 0 events 100824 4:40:50 InnoDB: Starting shutdown... 100824 04:42:49 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 100824 4:42:49 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead. 100824 4:42:49 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 100824 4:42:49 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 100824 4:42:56 InnoDB: Error: table 'tmp/#sql2b8b_13_0' InnoDB: in InnoDB data dictionary has tablespace id 335, InnoDB: but tablespace with that id or name does not exist. Have InnoDB: you deleted or moved .ibd files? InnoDB: This may also be a table created with CREATE TEMPORARY TABLE InnoDB: whose .ibd and .frm files MySQL automatically removed, but the InnoDB: table still exists in the InnoDB internal data dictionary. InnoDB: Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting-datadict.html InnoDB: for how to resolve the issue. InnoDB: Last MySQL binlog file position 0 144795066, file name /usr/local/mysql/logfiles/MIFO_Incr.000002 100824 4:42:56 InnoDB: Started; log sequence number 111 832753112 100824 4:42:56 [Note] Event Scheduler: Loaded 0 events 100824 4:42:56 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.1.45-enterprise-gpl-advanced-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (GPL) 100824 6:24:22 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 100824 6:24:22 [Note] Event Scheduler: Purging the queue. 0 events 100824 6:24:22 InnoDB: Starting shutdown... 100824 6:24:26 InnoDB: Shutdown completed; log sequence number 111 832753112 100824 6:24:26 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete