mysql 集群 重启_MYSQL自动重启(集群环境)

080728 10:56:47  InnoDB: Starting an apply batch of log records to the database...

InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99

InnoDB: Apply batch completed

InnoDB: Last MySQL binlog file position 0 24949, file name D:永能科技MySQLMySQL Server 5.0mysqllogmysqllog.000007

InnoDB: Starting in background the rollback of uncommitted transactions

080728 10:56:48  InnoDB: Rolling back trx with id 0 3790172, 1 rows to undo

080728 10:56:48  InnoDB: Started; log sequence number 0 1780607390

080728 10:56:48 [Note] Recovering after a crash using D:/永能科技/MySQL/MySQL Server 5.0/mysqllog/mysqllog

080728 10:56:48 [Note] Starting crash recovery...

080728 10:56:48  InnoDB: Starting recovery for XA transactions...

080728 10:56:48  InnoDB: Transaction 0 3790163 in prepared state after recovery

080728 10:56:48  InnoDB: Transaction contains changes to 1 rows

080728 10:56:48  InnoDB: 1 transactions in prepared state after recovery

080728 10:56:48 [Note] Found 1 prepared transaction(s) in InnoDB

080728 10:56:48 [ERROR] MySQL50: Got signal 11. Aborting!

080728 10:56:48 [ERROR] Aborting

080728 10:56:48  InnoDB: Starting shutdown...

080728 10:59:38  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...

080728 10:59:38  InnoDB: Starting log scan based on checkpoint at

InnoDB: log sequence number 0 1780509820.

InnoDB: Doing recovery: scanned up to log sequence number 0 1780607390

InnoDB: Transaction 0 3790163 was in the XA prepared state.

InnoDB: 3 transaction(s) which must be rolled back or cleaned up

InnoDB: in total 2 row operations to undo

InnoDB: Trx id counter is 0 3790592

080728 10:59:39  InnoDB: Starting an apply batch of log records to the database...

InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99

InnoDB: Apply batch completed

InnoDB: Last MySQL binlog file position 0 24949, file name D:永能科技MySQLMySQL Server 5.0mysqllogmysqllog.000007

InnoDB: Starting in background the rollback of uncommitted transactions

080728 10:59:40  InnoDB: Rolling back trx with id 0 3790172, 1 rows to undo

080728 10:59:40  InnoDB: Started; log sequence number 0 1780607390

080728 10:59:40 [Note] Recovering after a crash using D:/永能科技/MySQL/MySQL Server 5.0/mysqllog/mysqllog

080728 10:59:40 [Note] Starting crash recovery...

080728 10:59:40  InnoDB: Starting recovery for XA transactions...

080728 10:59:40  InnoDB: Transaction 0 3790163 in prepared state after recovery

080728 10:59:40  InnoDB: Transaction contains changes to 1 rows

080728 10:59:40  InnoDB: 1 transactions in prepared state after recovery

080728 10:59:40 [Note] Found 1 prepared transaction(s) in InnoDB

080728 10:59:40 [ERROR] D:永能科技MySQLMySQL Server 5.0inmysqld-nt.exe: Got signal 11. Aborting!

080728 10:59:40 [ERROR] Aborting

080728 10:59:40  InnoDB: Starting shutdown...

080728 11:00:35  InnoDB: Operating system error number 32 in a file operation.

InnoDB: Some operating system error numbers are described at

InnoDB: http://dev.mysql.com/doc/refman/ ... em-error-codes.html

InnoDB: File name .ibdata1

InnoDB: File operation call: 'open'.

InnoDB: Cannot continue operation.

InnoDB: Warning: a long semaphore wait:

--Thread 2168 has waited at .locklock0lock.c line 3093 for 242.00 seconds the semaphore:

Mutex at 02FE0180 created file .srvsrv0srv.c line 872, lock var 1

waiters flag 1

InnoDB: Warning: a long semaphore wait:

--Thread 2164 has waited at .loglog0log.c line 3062 for 242.00 seconds the semaphore:

Mutex at 02FE0180 created file .srvsrv0srv.c line 872, lock var 1

waiters flag 1