- InnoDB: Doing recovery: scanned up to log sequence number 224366115328
- InnoDB: Doing recovery: scanned up to log sequence number 224371358208
- InnoDB: Doing recovery: scanned up to log sequence number 224376601088
- InnoDB: Doing recovery: scanned up to log sequence number 224381843968
- InnoDB: Doing recovery: scanned up to log sequence number 224387086848
- InnoDB: Doing recovery: scanned up to log sequence number 224392329728
- InnoDB: Doing recovery: scanned up to log sequence number 224397572608
- InnoDB: Doing recovery: scanned up to log sequence number 224402815488
- InnoDB: Doing recovery: scanned up to log sequence number 224408058368
- InnoDB: Doing recovery: scanned up to log sequence number 224413301248
- InnoDB: Doing recovery: scanned up to log sequence number 224418544128
- InnoDB: Doing recovery: scanned up to log sequence number 224423787008
- InnoDB: Doing recovery: scanned up to log sequence number 224425526540
- InnoDB: 1 transaction(s) which must be rolled back or cleaned up
- InnoDB: in total 262 row operations to undo
- InnoDB: Trx id counter is 416256
- 2019-10-05 23:35:58 7805 [Note] InnoDB: Starting an apply batch of log records to the database...
- InnoDB: Progress in percent: 0 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 6
- 3 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 716953278, file name MySQL-bin.000195
- InnoDB: Starting in background the rollback of uncommitted transactions
- 2019-10-05 23:36:48 7805 [Note] InnoDB: 128 rollback segment(s) are active.
- 2019-10-05 23:36:48 7ff29f6b6700 InnoDB: Rolling back trx with id 415796, 262 rows to undo
- 2019-10-05 23:36:48 7805 [Note] InnoDB: Waiting for purge to start
- 2019-10-05 23:36:48 7805 [Note] InnoDB: 5.6.25 started; log sequence number 224425526540
- 2019-10-05 23:36:48 7805 [Note] Recovering after a crash using /data01/mysql_3324_gdocrimg04/binlog/MySQL-bin
- 2019-10-05 23:36:51 7805 [ERROR] InnoDB: Tried to read 16384 bytes at offset 276480000. Was only able to read 8192.
- 2019-10-05 23:36:52 7805 [ERROR] InnoDB: File (unknown): 'read' returned OS error 0. Cannot continue operation
- 191005 23:36:52 mysqld_safe mysqld from pid file /data01/mysql_3324_gdocrimg04/data/mysqld.pid ended
来源: http://www.bubuko.com/infodetail-3227240.html