Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
5.5.35, 5.5.36
-
None
-
None
-
Windows 2012 64bits
Tested with MariaDB 5.5.36 e 5.5.35
Description
I migrated a production database from Mysql 5.5.8 to MariaDB 5.5.36 but I got several intermittent crashs. I changed a lot of configuration but only one works: change XtraDB to innodb plugin with options ignore-builtin-innodb
and plugin-load=ha_innodb.dll. (thanks to discution MDEV-5865 mariadb 5.5.36 crash on centos[5,6] container)
Log error:
140401 0:09:39 InnoDB: The InnoDB memory heap is disabled
140401 0:09:39 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 0:09:39 InnoDB: Compressed tables use zlib 1.2.3
140401 0:09:39 InnoDB: Initializing buffer pool, size = 1.0G
140401 0:09:39 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file .\ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
140401 0:09:39 [ERROR] Plugin 'InnoDB' init function returned error.
140401 0:09:39 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140401 0:09:39 [Note] Plugin 'FEEDBACK' is disabled.
140401 0:09:39 [ERROR] Unknown/unsupported storage engine: innodb
140401 0:09:39 [ERROR] Aborting
140401 0:09:39 [Note] E:\MariaDB 5.5\bin\mysqld.exe: Shutdown complete
140401 0:10:38 InnoDB: The InnoDB memory heap is disabled
140401 0:10:38 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 0:10:38 InnoDB: Compressed tables use zlib 1.2.3
140401 0:10:38 InnoDB: Initializing buffer pool, size = 1.0G
140401 0:10:38 InnoDB: Completed initialization of buffer pool
140401 0:10:38 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
140401 0:10:41 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
140401 0:10:45 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140401 0:10:45 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...
140401 0:10:45 InnoDB: Waiting for the background threads to start
140401 0:10:46 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 1598476
140401 0:10:46 [Note] Plugin 'FEEDBACK' is disabled.
140401 0:10:46 [Note] Server socket created on IP: '::'.
140401 0:10:46 [Warning] 'user' entry 'root@cpro14077' ignored in --skip-name-resolve mode.
140401 0:10:46 [Warning] 'proxies_priv' entry '@ root@cpro14077' ignored in --skip-name-resolve mode.
140401 0:10:47 [Note] Event Scheduler: Loaded 0 events
140401 0:10:47 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB' socket: '' port: 3307 mariadb.org binary distribution
140401 0:11:23 [Note] E:\MariaDB 5.5\bin\mysqld.exe: Normal shutdown
140401 0:11:23 [Note] Event Scheduler: Purging the queue. 0 events
140401 0:11:23 InnoDB: Starting shutdown...
140401 0:11:23 InnoDB: Shutdown completed; log sequence number 1598476
140401 0:11:23 [Note] E:\MariaDB 5.5\bin\mysqld.exe: Shutdown complete
140401 0:11:28 InnoDB: The InnoDB memory heap is disabled
140401 0:11:28 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 0:11:28 InnoDB: Compressed tables use zlib 1.2.3
140401 0:11:28 InnoDB: Initializing buffer pool, size = 1.0G
140401 0:11:28 InnoDB: Completed initialization of buffer pool
140401 0:11:28 InnoDB: highest supported file format is Barracuda.
140401 0:11:29 InnoDB: Waiting for the background threads to start
140401 0:11:30 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 1598476
140401 0:11:30 [Note] Plugin 'FEEDBACK' is disabled.
140401 0:11:30 [Note] Server socket created on IP: '::'.
140401 0:11:30 [Warning] 'user' entry 'root@cpro14077' ignored in --skip-name-resolve mode.
140401 0:11:30 [Warning] 'proxies_priv' entry '@ root@cpro14077' ignored in --skip-name-resolve mode.
140401 0:11:30 [Note] Event Scheduler: Loaded 0 events
140401 0:11:30 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB' socket: '' port: 3307 mariadb.org binary distribution
140401 0:12:28 [Note] E:\MariaDB 5.5\bin\mysqld.exe: Normal shutdown
140401 0:12:28 [Note] Event Scheduler: Purging the queue. 0 events
140401 0:12:28 InnoDB: Starting shutdown...
140401 0:12:29 InnoDB: Shutdown completed; log sequence number 1598476
140401 0:12:29 [Note] E:\MariaDB 5.5\bin\mysqld.exe: Shutdown complete
140401 0:12:32 InnoDB: The InnoDB memory heap is disabled
140401 0:12:32 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 0:12:32 InnoDB: Compressed tables use zlib 1.2.3
140401 0:12:32 InnoDB: Initializing buffer pool, size = 1.5G
140401 0:12:33 InnoDB: Completed initialization of buffer pool
140401 0:12:33 InnoDB: highest supported file format is Barracuda.
140401 0:12:33 InnoDB: Waiting for the background threads to start
140401 0:12:34 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 1598476
140401 0:12:34 [Note] Plugin 'FEEDBACK' is disabled.
140401 0:12:34 [Note] Server socket created on IP: '::'.
140401 0:12:34 [Warning] 'user' entry 'root@cpro14077' ignored in --skip-name-resolve mode.
140401 0:12:34 [Warning] 'proxies_priv' entry '@ root@cpro14077' ignored in --skip-name-resolve mode.
140401 0:12:34 [Note] Event Scheduler: Loaded 0 events
140401 0:12:34 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB' socket: '' port: 3307 mariadb.org binary distribution
140401 0:13:02 [Note] E:\MariaDB 5.5\bin\mysqld.exe: Normal shutdown
140401 0:13:02 [Note] Event Scheduler: Purging the queue. 0 events
140401 0:13:02 InnoDB: Starting shutdown...
140401 0:13:03 InnoDB: Shutdown completed; log sequence number 1598476
140401 0:13:03 [Note] E:\MariaDB 5.5\bin\mysqld.exe: Shutdown complete
140401 0:13:13 InnoDB: The InnoDB memory heap is disabled
140401 0:13:13 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 0:13:13 InnoDB: Compressed tables use zlib 1.2.3
140401 0:13:13 InnoDB: Initializing buffer pool, size = 1.0G
140401 0:13:13 InnoDB: Completed initialization of buffer pool
140401 0:13:13 InnoDB: highest supported file format is Barracuda.
140401 0:13:14 InnoDB: Waiting for the background threads to start
140401 0:13:15 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 1598476
140401 0:13:15 [Note] Plugin 'FEEDBACK' is disabled.
140401 0:13:15 [Note] Server socket created on IP: '::'.
140401 0:13:15 [Warning] 'user' entry 'root@cpro14077' ignored in --skip-name-resolve mode.
140401 0:13:15 [Warning] 'proxies_priv' entry '@ root@cpro14077' ignored in --skip-name-resolve mode.
140401 0:13:15 [Note] Event Scheduler: Loaded 0 events
140401 0:13:15 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB' socket: '' port: 3307 mariadb.org binary distribution
140401 6:13:21 [Note] E:\MariaDB 5.5\bin\mysqld.exe: Normal shutdown
140401 6:13:21 [Note] Event Scheduler: Purging the queue. 0 events
140401 6:13:21 InnoDB: Starting shutdown...
140401 6:13:22 InnoDB: Shutdown completed; log sequence number 28000228960
140401 6:13:22 [Note] E:\MariaDB 5.5\bin\mysqld.exe: Shutdown complete
140401 6:14:09 InnoDB: The InnoDB memory heap is disabled
140401 6:14:09 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 6:14:09 InnoDB: Compressed tables use zlib 1.2.3
140401 6:14:09 InnoDB: Initializing buffer pool, size = 1.0G
140401 6:14:09 InnoDB: Completed initialization of buffer pool
140401 6:14:09 InnoDB: highest supported file format is Barracuda.
140401 6:14:12 InnoDB: Waiting for the background threads to start
140401 6:14:13 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 28000228960
140401 6:14:13 [Note] Plugin 'FEEDBACK' is disabled.
140401 6:14:13 [Note] Server socket created on IP: '::'.
140401 6:14:13 [Warning] 'user' entry 'root@cpro14077' ignored in --skip-name-resolve mode.
140401 6:14:13 [Warning] 'proxies_priv' entry '@ root@cpro14077' ignored in --skip-name-resolve mode.
140401 6:14:13 [Note] Event Scheduler: Loaded 0 events
140401 6:14:13 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 6:20:46 [Note] E:\MariaDB 5.5\bin\mysqld.exe: Normal shutdown
140401 6:20:46 [Note] Event Scheduler: Purging the queue. 0 events
140401 6:20:46 InnoDB: Starting shutdown...
140401 6:20:46 InnoDB: Shutdown completed; log sequence number 28000228960
140401 6:20:46 [Note] E:\MariaDB 5.5\bin\mysqld.exe: Shutdown complete
140401 6:20:55 InnoDB: The InnoDB memory heap is disabled
140401 6:20:55 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 6:20:55 InnoDB: Compressed tables use zlib 1.2.3
140401 6:20:55 InnoDB: Initializing buffer pool, size = 800.0M
140401 6:20:55 InnoDB: Completed initialization of buffer pool
140401 6:20:55 InnoDB: highest supported file format is Barracuda.
140401 6:20:56 InnoDB: Waiting for the background threads to start
140401 6:20:57 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 28000228960
140401 6:20:57 [Note] Plugin 'FEEDBACK' is disabled.
140401 6:20:57 [Note] Server socket created on IP: '::'.
140401 6:20:57 [Note] Event Scheduler: Loaded 0 events
140401 6:20:57 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 10:12:35 InnoDB: The InnoDB memory heap is disabled
140401 10:12:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 10:12:35 InnoDB: Compressed tables use zlib 1.2.3
140401 10:12:35 InnoDB: Initializing buffer pool, size = 800.0M
140401 10:12:35 InnoDB: Completed initialization of buffer pool
140401 10:12:35 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140401 10:12:35 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...
140401 10:12:44 InnoDB: Waiting for the background threads to start
140401 10:12:45 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 28070004150
140401 10:12:45 [Note] Plugin 'FEEDBACK' is disabled.
140401 10:12:45 [Note] Server socket created on IP: '::'.
140401 10:12:46 [Note] Event Scheduler: Loaded 0 events
140401 10:12:46 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 10:14:54 [ERROR] mysqld.exe: Table '.\mysql\proc' is marked as crashed and should be repaired
140401 10:14:54 [Warning] Checking table: '.\mysql\proc'
140401 10:18:26 InnoDB: Assertion failure in thread 864 in file os0sync.c line 434
InnoDB: Failing assertion: event
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
140401 10:25:54 InnoDB: The InnoDB memory heap is disabled
140401 10:25:54 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 10:25:54 InnoDB: Compressed tables use zlib 1.2.3
140401 10:25:54 InnoDB: Initializing buffer pool, size = 800.0M
140401 10:25:54 InnoDB: Completed initialization of buffer pool
140401 10:25:54 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 28070537123
140401 10:25:54 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...
InnoDB: Doing recovery: scanned up to log sequence number 28070551378
140401 10:26:03 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
140401 10:26:04 InnoDB: Waiting for the background threads to start
140401 10:26:05 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 28070551378
140401 10:26:05 [Note] Plugin 'FEEDBACK' is disabled.
140401 10:26:05 [Note] Server socket created on IP: '::'.
140401 10:26:05 [Note] Event Scheduler: Loaded 0 events
140401 10:26:05 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 10:43:33 InnoDB: Assertion failure in thread 8564 in file os0sync.c line 434
InnoDB: Failing assertion: event
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
140401 10:49:13 InnoDB: The InnoDB memory heap is disabled
140401 10:49:13 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 10:49:13 InnoDB: Compressed tables use zlib 1.2.3
140401 10:49:14 InnoDB: Initializing buffer pool, size = 800.0M
140401 10:49:14 InnoDB: Completed initialization of buffer pool
140401 10:49:14 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 28073799621
140401 10:49:14 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...
InnoDB: Doing recovery: scanned up to log sequence number 28073799745
140401 10:49:16 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
140401 10:49:16 InnoDB: Waiting for the background threads to start
140401 10:49:17 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 28073799745
140401 10:49:17 [Note] Plugin 'FEEDBACK' is disabled.
140401 10:49:17 [Note] Server socket created on IP: '::'.
140401 10:49:17 [Note] Event Scheduler: Loaded 0 events
140401 10:49:17 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 10:53:14 InnoDB: The InnoDB memory heap is disabled
140401 10:53:14 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 10:53:14 InnoDB: Compressed tables use zlib 1.2.3
140401 10:53:14 InnoDB: Initializing buffer pool, size = 800.0M
140401 10:53:14 InnoDB: Completed initialization of buffer pool
140401 10:53:14 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 28074160711
140401 10:53:14 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...
InnoDB: Doing recovery: scanned up to log sequence number 28074199642
140401 10:53:16 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
140401 10:53:17 InnoDB: Waiting for the background threads to start
140401 10:53:18 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 28074199642
140401 10:53:18 [Note] Plugin 'FEEDBACK' is disabled.
140401 10:53:18 [Note] Server socket created on IP: '::'.
140401 10:53:18 [Note] Event Scheduler: Loaded 0 events
140401 10:53:18 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 10:59:59 InnoDB: The InnoDB memory heap is disabled
140401 10:59:59 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 10:59:59 InnoDB: Compressed tables use zlib 1.2.3
140401 10:59:59 InnoDB: Initializing buffer pool, size = 800.0M
140401 10:59:59 InnoDB: Completed initialization of buffer pool
140401 10:59:59 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 28074443395
140401 11:00:00 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...
InnoDB: Doing recovery: scanned up to log sequence number 28074494800
140401 11:00:04 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
140401 11:00:04 InnoDB: Waiting for the background threads to start
140401 11:00:05 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 28074494800
140401 11:00:05 [Note] Plugin 'FEEDBACK' is disabled.
140401 11:00:05 [Note] Server socket created on IP: '::'.
140401 11:00:06 [Note] Event Scheduler: Loaded 0 events
140401 11:00:06 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 11:04:35 InnoDB: The InnoDB memory heap is disabled
140401 11:04:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 11:04:35 InnoDB: Compressed tables use zlib 1.2.3
140401 11:04:35 InnoDB: Initializing buffer pool, size = 800.0M
140401 11:04:35 InnoDB: Completed initialization of buffer pool
140401 11:04:35 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140401 11:04:35 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...
140401 11:04:37 InnoDB: Waiting for the background threads to start
140401 11:04:38 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 28074747996
140401 11:04:38 [Note] Plugin 'FEEDBACK' is disabled.
140401 11:04:38 [Note] Server socket created on IP: '::'.
140401 11:04:38 [Note] Event Scheduler: Loaded 0 events
140401 11:04:38 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 11:10:36 InnoDB: Assertion failure in thread 4792 in file os0sync.c line 434
InnoDB: Failing assertion: event
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
140401 11:11:07 InnoDB: The InnoDB memory heap is disabled
140401 11:11:07 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 11:11:07 InnoDB: Compressed tables use zlib 1.2.3
140401 11:11:07 InnoDB: Initializing buffer pool, size = 800.0M
140401 11:11:07 InnoDB: Completed initialization of buffer pool
140401 11:11:07 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 28075176056
140401 11:11:07 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...
InnoDB: Doing recovery: scanned up to log sequence number 28075291772
140401 11:11:09 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
140401 11:11:09 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 28075291772
140401 11:11:09 [Note] Plugin 'FEEDBACK' is disabled.
140401 11:11:09 [Note] Server socket created on IP: '::'.
140401 11:11:09 [Note] Event Scheduler: Loaded 0 events
140401 11:11:09 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB-log' socket: '' port: 3306 mariadb.org binary distribution
140401 11:21:55 InnoDB: The InnoDB memory heap is disabled
140401 11:21:55 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 11:21:55 InnoDB: Compressed tables use zlib 1.2.3
140401 11:21:55 InnoDB: Initializing buffer pool, size = 800.0M
140401 11:21:55 InnoDB: Completed initialization of buffer pool
140401 11:21:55 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 28076433569
140401 11:21:55 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...
InnoDB: Doing recovery: scanned up to log sequence number 28076605409
140401 11:22:00 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
140401 11:22:01 InnoDB: Waiting for the background threads to start
140401 11:22:02 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 28076605409
140401 11:22:02 [Note] Plugin 'FEEDBACK' is disabled.
140401 11:22:02 [Note] Server socket created on IP: '::'.
140401 11:22:02 [Note] Event Scheduler: Loaded 0 events
140401 11:22:02 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 11:49:08 InnoDB: The InnoDB memory heap is disabled
140401 11:49:08 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 11:49:08 InnoDB: Compressed tables use zlib 1.2.3
140401 11:49:08 InnoDB: Initializing buffer pool, size = 800.0M
140401 11:49:08 InnoDB: Completed initialization of buffer pool
140401 11:49:08 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 28079704980
140401 11:49:08 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...
InnoDB: Doing recovery: scanned up to log sequence number 28079704990
140401 11:49:12 InnoDB: Waiting for the background threads to start
140401 11:49:13 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 28079704990
140401 11:49:13 [Note] Plugin 'FEEDBACK' is disabled.
140401 11:49:13 [Note] Server socket created on IP: '::'.
140401 11:49:13 [Note] Event Scheduler: Loaded 0 events
140401 11:49:13 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 12:02:56 InnoDB: The InnoDB memory heap is disabled
140401 12:02:56 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 12:02:56 InnoDB: Compressed tables use zlib 1.2.3
140401 12:02:56 InnoDB: Initializing buffer pool, size = 800.0M
140401 12:02:56 InnoDB: Completed initialization of buffer pool
140401 12:02:56 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 28080476210
140401 12:02:56 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...
InnoDB: Doing recovery: scanned up to log sequence number 28080483753
140401 12:02:57 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
140401 12:02:58 InnoDB: Waiting for the background threads to start
140401 12:02:59 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 28080483753
140401 12:02:59 [Note] Plugin 'FEEDBACK' is disabled.
140401 12:02:59 [Note] Server socket created on IP: '::'.
140401 12:02:59 [Note] Event Scheduler: Loaded 0 events
140401 12:02:59 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 12:25:05 [Note] E:\MariaDB 5.5\bin\mysqld.exe: Normal shutdown
140401 12:25:16 [Note] Event Scheduler: Purging the queue. 0 events
140401 12:25:16 InnoDB: Starting shutdown...
140401 12:25:16 InnoDB: Waiting for 10 pages to be flushed
140401 12:25:17 InnoDB: Shutdown completed; log sequence number 28086740317
140401 12:25:17 [Note] E:\MariaDB 5.5\bin\mysqld.exe: Shutdown complete
140401 12:25:21 InnoDB: The InnoDB memory heap is disabled
140401 12:25:21 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 12:25:21 InnoDB: Compressed tables use zlib 1.2.3
140401 12:25:21 InnoDB: Initializing buffer pool, size = 512.0M
140401 12:25:21 InnoDB: Completed initialization of buffer pool
140401 12:25:21 InnoDB: highest supported file format is Barracuda.
140401 12:25:21 InnoDB: Waiting for the background threads to start
140401 12:25:22 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 28086740317
140401 12:25:22 [Note] Plugin 'FEEDBACK' is disabled.
140401 12:25:22 [Note] Server socket created on IP: '::'.
140401 12:25:22 [Note] Event Scheduler: Loaded 0 events
140401 12:25:22 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 12:50:17 InnoDB: The InnoDB memory heap is disabled
140401 12:50:17 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 12:50:17 InnoDB: Compressed tables use zlib 1.2.3
140401 12:50:17 InnoDB: Initializing buffer pool, size = 512.0M
140401 12:50:18 InnoDB: Completed initialization of buffer pool
140401 12:50:18 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 28087930519
140401 12:50:18 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...
InnoDB: Doing recovery: scanned up to log sequence number 28087930551
140401 12:50:19 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
140401 12:50:19 InnoDB: Waiting for the background threads to start
140401 12:50:21 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 28087930551
140401 12:50:21 [Note] Plugin 'FEEDBACK' is disabled.
140401 12:50:21 [Note] Server socket created on IP: '::'.
140401 12:50:21 [Note] Event Scheduler: Loaded 0 events
140401 12:50:21 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.36-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 13:05:31 [Note] E:\MariaDB 5.5\bin\mysqld.exe: Normal shutdown
140401 13:05:36 [Note] Event Scheduler: Purging the queue. 0 events
140401 13:05:36 InnoDB: Starting shutdown...
140401 13:05:37 InnoDB: Waiting for 10 pages to be flushed
140401 13:05:37 InnoDB: Shutdown completed; log sequence number 28126965652
140401 13:05:37 [Note] E:\MariaDB 5.5\bin\mysqld.exe: Shutdown complete
140401 13:06:17 InnoDB: The InnoDB memory heap is disabled
140401 13:06:17 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 13:06:17 InnoDB: Compressed tables use zlib 1.2.3
140401 13:06:17 InnoDB: Initializing buffer pool, size = 512.0M
140401 13:06:17 InnoDB: Completed initialization of buffer pool
140401 13:06:17 InnoDB: highest supported file format is Barracuda.
140401 13:06:17 InnoDB: Waiting for the background threads to start
140401 13:06:18 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 28126965652
140401 13:06:18 [Note] Plugin 'FEEDBACK' is disabled.
140401 13:06:18 [Note] Server socket created on IP: '::'.
140401 13:06:18 [Note] Event Scheduler: Loaded 0 events
140401 13:06:18 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.35-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 13:18:06 InnoDB: The InnoDB memory heap is disabled
140401 13:18:06 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 13:18:06 InnoDB: Compressed tables use zlib 1.2.3
140401 13:18:06 InnoDB: Initializing buffer pool, size = 512.0M
140401 13:18:06 InnoDB: Completed initialization of buffer pool
140401 13:18:06 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 28129376559
140401 13:18:06 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...
InnoDB: Doing recovery: scanned up to log sequence number 28129405057
140401 13:18:07 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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 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
140401 13:18:08 InnoDB: Waiting for the background threads to start
140401 13:18:09 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 28129405057
140401 13:18:09 [Note] Plugin 'FEEDBACK' is disabled.
140401 13:18:09 [Note] Server socket created on IP: '::'.
140401 13:18:09 [Note] Event Scheduler: Loaded 0 events
140401 13:18:09 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.35-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 13:42:06 InnoDB: The InnoDB memory heap is disabled
140401 13:42:06 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 13:42:06 InnoDB: Compressed tables use zlib 1.2.3
140401 13:42:06 InnoDB: Initializing buffer pool, size = 512.0M
140401 13:42:06 InnoDB: Completed initialization of buffer pool
140401 13:42:06 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 28135209541
140401 13:42:06 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...
InnoDB: Doing recovery: scanned up to log sequence number 28135209921
140401 13:42:11 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 99
InnoDB: Apply batch completed
140401 13:42:12 InnoDB: Waiting for the background threads to start
140401 13:42:13 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 28135209921
140401 13:42:13 [Note] Plugin 'FEEDBACK' is disabled.
140401 13:42:13 [Note] Server socket created on IP: '::'.
140401 13:42:13 [Note] Event Scheduler: Loaded 0 events
140401 13:42:13 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.35-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 14:02:57 InnoDB: The InnoDB memory heap is disabled
140401 14:02:57 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 14:02:57 InnoDB: Compressed tables use zlib 1.2.3
140401 14:02:57 InnoDB: Initializing buffer pool, size = 512.0M
140401 14:02:57 InnoDB: Completed initialization of buffer pool
140401 14:02:57 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 28139633179
140401 14:02:57 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...
InnoDB: Doing recovery: scanned up to log sequence number 28139918485
140401 14:02:59 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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 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
140401 14:03:00 InnoDB: Waiting for the background threads to start
140401 14:03:01 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 28139918485
140401 14:03:01 [Note] Plugin 'FEEDBACK' is disabled.
140401 14:03:01 [Note] Server socket created on IP: '::'.
140401 14:03:01 [Note] Event Scheduler: Loaded 0 events
140401 14:03:01 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.35-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 14:05:39 InnoDB: The InnoDB memory heap is disabled
140401 14:05:39 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 14:05:39 InnoDB: Compressed tables use zlib 1.2.3
140401 14:05:39 InnoDB: Initializing buffer pool, size = 512.0M
140401 14:05:39 InnoDB: Completed initialization of buffer pool
140401 14:05:39 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140401 14:05:39 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...
140401 14:05:40 InnoDB: Waiting for the background threads to start
140401 14:05:41 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 28140135900
140401 14:05:41 [Note] Plugin 'FEEDBACK' is disabled.
140401 14:05:41 [Note] Server socket created on IP: '::'.
140401 14:05:41 [Note] Event Scheduler: Loaded 0 events
140401 14:05:41 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.35-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 14:10:44 InnoDB: The InnoDB memory heap is disabled
140401 14:10:44 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 14:10:44 InnoDB: Compressed tables use zlib 1.2.3
140401 14:10:44 InnoDB: Initializing buffer pool, size = 512.0M
140401 14:10:44 InnoDB: Completed initialization of buffer pool
140401 14:10:44 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 28140367836
140401 14:10:44 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...
InnoDB: Doing recovery: scanned up to log sequence number 28140446481
140401 14:10:50 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
140401 14:10:51 InnoDB: Waiting for the background threads to start
140401 14:10:52 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 28140446481
140401 14:10:52 [Note] Plugin 'FEEDBACK' is disabled.
140401 14:10:52 [Note] Server socket created on IP: '::'.
140401 14:10:52 [Note] Event Scheduler: Loaded 0 events
140401 14:10:52 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.35-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 14:14:14 InnoDB: The InnoDB memory heap is disabled
140401 14:14:14 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 14:14:14 InnoDB: Compressed tables use zlib 1.2.3
140401 14:14:14 InnoDB: Initializing buffer pool, size = 512.0M
140401 14:14:14 InnoDB: Completed initialization of buffer pool
140401 14:14:14 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 28140492322
140401 14:14:14 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...
InnoDB: Doing recovery: scanned up to log sequence number 28140510229
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 2 row operations to undo
InnoDB: Trx id counter is C5900
140401 14:14:16 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: Starting in background the rollback of uncommitted transactions
140401 14:14:16 InnoDB: Rolling back trx with id C56DD, 2 rows to undo
140401 14:14:16 InnoDB: Waiting for the background threads to start
InnoDB: Rolling back of trx id C56DD completed
140401 14:14:16 InnoDB: Rollback of non-prepared transactions completed
140401 14:14:17 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 28140510229
140401 14:14:17 [Note] Plugin 'FEEDBACK' is disabled.
140401 14:14:17 [Note] Server socket created on IP: '::'.
140401 14:14:17 [Note] Event Scheduler: Loaded 0 events
140401 14:14:17 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.35-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 14:16:27 InnoDB: Assertion failure in thread 5872 in file buf0lru.c line 2368
InnoDB: Failing assertion: buf_page_get_zip_size(bpage)
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
140401 14:16:39 InnoDB: The InnoDB memory heap is disabled
140401 14:16:39 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140401 14:16:39 InnoDB: Compressed tables use zlib 1.2.3
140401 14:16:39 InnoDB: Initializing buffer pool, size = 512.0M
140401 14:16:39 InnoDB: Completed initialization of buffer pool
140401 14:16:39 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 28140590902
140401 14:16:39 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...
InnoDB: Doing recovery: scanned up to log sequence number 28140592351
140401 14:16:43 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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 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
140401 14:16:44 InnoDB: Waiting for the background threads to start
140401 14:16:45 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 28140592351
140401 14:16:45 [Note] Plugin 'FEEDBACK' is disabled.
140401 14:16:45 [Note] Server socket created on IP: '::'.
140401 14:16:45 [Note] Event Scheduler: Loaded 0 events
140401 14:16:45 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.35-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
140401 14:38:57 [Note] Plugin 'FEEDBACK' is disabled.
140401 14:39:08 [Note] Server socket created on IP: '::'.
140401 14:39:08 [Note] Event Scheduler: Loaded 0 events
140401 14:39:08 [Note] E:\MariaDB 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.35-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
Attachments
Issue Links
- relates to
-
MDEV-5865 mariadb 5.5.36 crash on centos[5,6] container
- Closed