[MDEV-6002] mariadb 5.5.36 intermittent crashs on windows (after 10-15 minutes) Created: 2014-04-01  Updated: 2014-07-29  Resolved: 2014-07-29

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.35, 5.5.36
Fix Version/s: 5.5.39

Type: Bug Priority: Major
Reporter: Tato Mezzena Assignee: Jan Lindström (Inactive)
Resolution: Cannot Reproduce Votes: 0
Labels: None
Environment:

Windows 2012 64bits
Tested with MariaDB 5.5.36 e 5.5.35


Issue Links:
Relates
relates to MDEV-5865 mariadb 5.5.36 crash on centos[5,6] c... Closed

 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



 Comments   
Comment by Elena Stepanova [ 2014-04-01 ]

I assume it's related to MDEV-5865.

Comment by Jan Lindström (Inactive) [ 2014-04-15 ]

Hi,

Do you happen to have full stack trace from the first assertion InnoDB: Assertion failure in thread 864 in file os0sync.c line 434 and from the second one (not necessary any way related) Assertion failure in thread 5872 in file buf0lru.c line 2368 InnoDB: Failing assertion: buf_page_get_zip_size(bpage).

R: Jan

Generated at Thu Feb 08 07:08:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.