Mysql is marked as crashed / mysql restart

S

sorenwp

New member
Joined
Feb 5, 2015
Messages
5
My mysql server keep geting crashed, in my log it says this:

mysql is marked as crashed and should be repaired, and the server shutdown and start crash recovery.


what can it be?
- the server, and my website with the crash tabel has been runing for weeks, with no problem?


 
As marked in the link in Alex his message.

Your best bet is to Dump the table that is corrupted and restore that database from your backup.

This way you don't have to struggle with a long downtime.
 
So if one of the websites on my host get a mysql error, the hole mysql server go down?
- i'll try the back, but don't understand why it faile now, and not days ago -_-
 
well noting work, i have delete the mysql tabel, but the server is still crashing -_-

This is my /var/lib/mysql/web1.123webhost.dk.err log

Code: 
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
150205 19:36:01  InnoDB: Waiting for the background threads to start
150205 19:36:02 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 61031790
150205 19:36:02 [Note] Plugin 'FEEDBACK' is disabled.
150205 19:36:02 [Note] Server socket created on IP: '0.0.0.0'.
150205 19:36:02 [Note] Event Scheduler: Loaded 0 events
150205 19:36:02 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150205 19:40:35 [Warning] IP address '74.86.158.106' has been resolved to the host name '74.86.158.106-static.reverse.softlayer.com', which resembles IPv4-address itself.
150205 19:41:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150205 19:41:01 InnoDB: The InnoDB memory heap is disabled
150205 19:41:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150205 19:41:01 InnoDB: Compressed tables use zlib 1.2.7
150205 19:41:01 InnoDB: Using Linux native AIO
150205 19:41:01 InnoDB: Initializing buffer pool, size = 128.0M
150205 19:41:01 InnoDB: Completed initialization of buffer pool
150205 19:41:01 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 61062558
150205 19:41:01  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 61062790
150205 19:41:01  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
150205 19:41:01  InnoDB: Waiting for the background threads to start
150205 19:41:02 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 61062790
150205 19:41:02 [Note] Plugin 'FEEDBACK' is disabled.
150205 19:41:02 [Note] Server socket created on IP: '0.0.0.0'.
150205 19:41:02 [Note] Event Scheduler: Loaded 0 events
150205 19:41:02 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150205 19:45:35 [Warning] IP address '74.86.158.106' has been resolved to the host name '74.86.158.106-static.reverse.softlayer.com', which resembles IPv4-address itself.
150205 19:46:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150205 19:46:06 InnoDB: The InnoDB memory heap is disabled
150205 19:46:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150205 19:46:06 InnoDB: Compressed tables use zlib 1.2.7
150205 19:46:06 InnoDB: Using Linux native AIO
150205 19:46:06 InnoDB: Initializing buffer pool, size = 128.0M
150205 19:46:06 InnoDB: Completed initialization of buffer pool
150205 19:46:06 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 61123118
150205 19:46: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 61123375
150205 19:46:06  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
150205 19:46:06  InnoDB: Waiting for the background threads to start
150205 19:46:07 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 61123375
150205 19:46:07 [Note] Plugin 'FEEDBACK' is disabled.
150205 19:46:07 [Note] Server socket created on IP: '0.0.0.0'.
150205 19:46:07 [Note] Event Scheduler: Loaded 0 events
150205 19:46:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150205 19:50:35 [Warning] IP address '74.86.158.106' has been resolved to the host name '74.86.158.106-static.reverse.softlayer.com', which resembles IPv4-address itself.
150205 19:52:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150205 19:52:01 InnoDB: The InnoDB memory heap is disabled
150205 19:52:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150205 19:52:01 InnoDB: Compressed tables use zlib 1.2.7
150205 19:52:01 InnoDB: Using Linux native AIO
150205 19:52:01 InnoDB: Initializing buffer pool, size = 128.0M
150205 19:52:01 InnoDB: Completed initialization of buffer pool
150205 19:52:01 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!
150205 19:52:01  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...
150205 19:52:01  InnoDB: Waiting for the background threads to start
150205 19:52:02 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 61123375
150205 19:52:02 [Note] Plugin 'FEEDBACK' is disabled.
150205 19:52:02 [Note] Server socket created on IP: '0.0.0.0'.
150205 19:52:02 [Note] Event Scheduler: Loaded 0 events
150205 19:52:02 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150205 19:55:35 [Warning] IP address '74.86.158.106' has been resolved to the host name '74.86.158.106-static.reverse.softlayer.com', which resembles IPv4-address itself.
150205 19:57:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150205 19:57:01 InnoDB: The InnoDB memory heap is disabled
150205 19:57:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150205 19:57:01 InnoDB: Compressed tables use zlib 1.2.7
150205 19:57:01 InnoDB: Using Linux native AIO
150205 19:57:01 InnoDB: Initializing buffer pool, size = 128.0M
150205 19:57:01 InnoDB: Completed initialization of buffer pool
150205 19:57:01 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!
150205 19:57:01  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...
150205 19:57:01  InnoDB: Waiting for the background threads to start
150205 19:57:02 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 61123375
150205 19:57:02 [Note] Plugin 'FEEDBACK' is disabled.
150205 19:57:02 [Note] Server socket created on IP: '0.0.0.0'.
150205 19:57:02 [Note] Event Scheduler: Loaded 0 events
150205 19:57:02 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150205 20:00:35 [Warning] IP address '74.86.158.106' has been resolved to the host name '74.86.158.106-static.reverse.softlayer.com', which resembles IPv4-address itself.
150205 20:02:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150205 20:02:01 InnoDB: The InnoDB memory heap is disabled
150205 20:02:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150205 20:02:01 InnoDB: Compressed tables use zlib 1.2.7
150205 20:02:01 InnoDB: Using Linux native AIO
150205 20:02:01 InnoDB: Initializing buffer pool, size = 128.0M
150205 20:02:01 InnoDB: Completed initialization of buffer pool
150205 20:02:01 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!
150205 20:02:01  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...
150205 20:02:01  InnoDB: Waiting for the background threads to start
150205 20:02:02 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 61182873
150205 20:02:02 [Note] Plugin 'FEEDBACK' is disabled.
150205 20:02:02 [Note] Server socket created on IP: '0.0.0.0'.
150205 20:02:02 [Note] Event Scheduler: Loaded 0 events
150205 20:02:02 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150205 20:05:36 [Warning] IP address '74.86.158.106' has been resolved to the host name '74.86.158.106-static.reverse.softlayer.com', which resembles IPv4-address itself.
150205 20:07:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150205 20:07:01 InnoDB: The InnoDB memory heap is disabled
150205 20:07:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150205 20:07:01 InnoDB: Compressed tables use zlib 1.2.7
150205 20:07:01 InnoDB: Using Linux native AIO
150205 20:07:01 InnoDB: Initializing buffer pool, size = 128.0M
150205 20:07:01 InnoDB: Completed initialization of buffer pool
150205 20:07:01 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!
150205 20:07:01  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...
150205 20:07:01  InnoDB: Waiting for the background threads to start
150205 20:07:02 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 61190800
150205 20:07:02 [Note] Plugin 'FEEDBACK' is disabled.
150205 20:07:02 [Note] Server socket created on IP: '0.0.0.0'.
150205 20:07:02 [Note] Event Scheduler: Loaded 0 events
150205 20:07:02 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150205 20:10:35 [Warning] IP address '74.86.158.106' has been resolved to the host name '74.86.158.106-static.reverse.softlayer.com', which resembles IPv4-address itself.
150205 20:12:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150205 20:12:01 InnoDB: The InnoDB memory heap is disabled
150205 20:12:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150205 20:12:01 InnoDB: Compressed tables use zlib 1.2.7
150205 20:12:01 InnoDB: Using Linux native AIO
150205 20:12:01 InnoDB: Initializing buffer pool, size = 128.0M
150205 20:12:01 InnoDB: Completed initialization of buffer pool
150205 20:12:01 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!
150205 20:12:01  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...
150205 20:12:01  InnoDB: Waiting for the background threads to start
150205 20:12:02 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 61190800
150205 20:12:02 [Note] Plugin 'FEEDBACK' is disabled.
150205 20:12:02 [Note] Server socket created on IP: '0.0.0.0'.
150205 20:12:02 [Note] Event Scheduler: Loaded 0 events
150205 20:12:02 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150205 20:15:35 [Warning] IP address '74.86.158.106' has been resolved to the host name '74.86.158.106-static.reverse.softlayer.com', which resembles IPv4-address itself.
150205 20:17:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150205 20:17:01 InnoDB: The InnoDB memory heap is disabled
150205 20:17:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150205 20:17:01 InnoDB: Compressed tables use zlib 1.2.7
150205 20:17:01 InnoDB: Using Linux native AIO
150205 20:17:01 InnoDB: Initializing buffer pool, size = 128.0M
150205 20:17:01 InnoDB: Completed initialization of buffer pool
150205 20:17:01 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!
150205 20:17:01  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...
150205 20:17:01  InnoDB: Waiting for the background threads to start
150205 20:17:02 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 61190800
150205 20:17:02 [Note] Plugin 'FEEDBACK' is disabled.
150205 20:17:02 [Note] Server socket created on IP: '0.0.0.0'.
150205 20:17:02 [Note] Event Scheduler: Loaded 0 events
150205 20:17:02 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150205 20:20:37 [Warning] IP address '74.86.158.106' has been resolved to the host name '74.86.158.106-static.reverse.softlayer.com', which resembles IPv4-address itself.
150205 20:22:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150205 20:22:06 InnoDB: The InnoDB memory heap is disabled
150205 20:22:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150205 20:22:06 InnoDB: Compressed tables use zlib 1.2.7
150205 20:22:06 InnoDB: Using Linux native AIO
150205 20:22:06 InnoDB: Initializing buffer pool, size = 128.0M
150205 20:22:06 InnoDB: Completed initialization of buffer pool
150205 20:22:06 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!
150205 20:22: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...
150205 20:22:06  InnoDB: Waiting for the background threads to start
150205 20:22:07 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 61190800
150205 20:22:07 [Note] Plugin 'FEEDBACK' is disabled.
150205 20:22:07 [Note] Server socket created on IP: '0.0.0.0'.
150205 20:22:07 [Note] Event Scheduler: Loaded 0 events
150205 20:22:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150205 20:25:35 [Warning] IP address '74.86.158.106' has been resolved to the host name '74.86.158.106-static.reverse.softlayer.com', which resembles IPv4-address itself.
150205 20:28:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150205 20:28:01 InnoDB: The InnoDB memory heap is disabled
150205 20:28:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150205 20:28:01 InnoDB: Compressed tables use zlib 1.2.7
150205 20:28:01 InnoDB: Using Linux native AIO
150205 20:28:01 InnoDB: Initializing buffer pool, size = 128.0M
150205 20:28:01 InnoDB: Completed initialization of buffer pool
150205 20:28:01 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 61208506
150205 20:28:01  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 61208746
150205 20:28:01  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
150205 20:28:02  InnoDB: Waiting for the background threads to start
150205 20:28:03 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 61208746
150205 20:28:03 [Note] Plugin 'FEEDBACK' is disabled.
150205 20:28:03 [Note] Server socket created on IP: '0.0.0.0'.
150205 20:28:03 [Note] Event Scheduler: Loaded 0 events
150205 20:28:03 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150205 20:30:35 [Warning] IP address '74.86.158.106' has been resolved to the host name '74.86.158.106-static.reverse.softlayer.com', which resembles IPv4-address itself.
150205 20:33:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150205 20:33:01 InnoDB: The InnoDB memory heap is disabled
150205 20:33:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150205 20:33:01 InnoDB: Compressed tables use zlib 1.2.7
150205 20:33:01 InnoDB: Using Linux native AIO
150205 20:33:01 InnoDB: Initializing buffer pool, size = 128.0M
150205 20:33:01 InnoDB: Completed initialization of buffer pool
150205 20:33:01 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 61495338
150205 20:33:01  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 61496149
150205 20:33:01  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
150205 20:33:02  InnoDB: Waiting for the background threads to start
150205 20:33:03 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 61496149
150205 20:33:03 [Note] Plugin 'FEEDBACK' is disabled.
150205 20:33:03 [Note] Server socket created on IP: '0.0.0.0'.
150205 20:33:03 [Note] Event Scheduler: Loaded 0 events
150205 20:33:03 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150205 20:35:36 [Warning] IP address '74.86.158.106' has been resolved to the host name '74.86.158.106-static.reverse.softlayer.com', which resembles IPv4-address itself.
150205 20:38:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150205 20:38:01 InnoDB: The InnoDB memory heap is disabled
150205 20:38:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150205 20:38:01 InnoDB: Compressed tables use zlib 1.2.7
150205 20:38:01 InnoDB: Using Linux native AIO
150205 20:38:01 InnoDB: Initializing buffer pool, size = 128.0M
150205 20:38:01 InnoDB: Completed initialization of buffer pool
150205 20:38:01 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!
150205 20:38:01  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...
150205 20:38:01  InnoDB: Waiting for the background threads to start
150205 20:38:02 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 61496149
150205 20:38:02 [Note] Plugin 'FEEDBACK' is disabled.
150205 20:38:02 [Note] Server socket created on IP: '0.0.0.0'.
150205 20:38:02 [Note] Event Scheduler: Loaded 0 events
150205 20:38:02 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150205 20:40:36 [Warning] IP address '74.86.158.106' has been resolved to the host name '74.86.158.106-static.reverse.softlayer.com', which resembles IPv4-address itself.
150205 20:43:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150205 20:43:02 InnoDB: The InnoDB memory heap is disabled
150205 20:43:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150205 20:43:02 InnoDB: Compressed tables use zlib 1.2.7
150205 20:43:02 InnoDB: Using Linux native AIO
150205 20:43:02 InnoDB: Initializing buffer pool, size = 128.0M
150205 20:43:02 InnoDB: Completed initialization of buffer pool
150205 20:43:02 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!
150205 20:43:02  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...
150205 20:43:02  InnoDB: Waiting for the background threads to start
150205 20:43:03 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 61496149
150205 20:43:03 [Note] Plugin 'FEEDBACK' is disabled.
150205 20:43:03 [Note] Server socket created on IP: '0.0.0.0'.
150205 20:43:03 [Note] Event Scheduler: Loaded 0 events
150205 20:43:03 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150205 20:45:36 [Warning] IP address '74.86.158.106' has been resolved to the host name '74.86.158.106-static.reverse.softlayer.com', which resembles IPv4-address itself.
150205 20:48:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150205 20:48:07 InnoDB: The InnoDB memory heap is disabled
150205 20:48:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150205 20:48:07 InnoDB: Compressed tables use zlib 1.2.7
150205 20:48:07 InnoDB: Using Linux native AIO
150205 20:48:07 InnoDB: Initializing buffer pool, size = 128.0M
150205 20:48:07 InnoDB: Completed initialization of buffer pool
150205 20:48:07 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!
150205 20:48: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...
150205 20:48:07  InnoDB: Waiting for the background threads to start
150205 20:48:08 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 61496149
150205 20:48:08 [Note] Plugin 'FEEDBACK' is disabled.
150205 20:48:08 [Note] Server socket created on IP: '0.0.0.0'.
150205 20:48:08 [Note] Event Scheduler: Loaded 0 events
150205 20:48:08 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150205 20:50:36 [Warning] IP address '74.86.158.106' has been resolved to the host name '74.86.158.106-static.reverse.softlayer.com', which resembles IPv4-address itself.
150205 20:54:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150205 20:54:01 InnoDB: The InnoDB memory heap is disabled
150205 20:54:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150205 20:54:01 InnoDB: Compressed tables use zlib 1.2.7
150205 20:54:01 InnoDB: Using Linux native AIO
150205 20:54:01 InnoDB: Initializing buffer pool, size = 128.0M
150205 20:54:01 InnoDB: Completed initialization of buffer pool
150205 20:54:01 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!
150205 20:54:01  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...
150205 20:54:01  InnoDB: Waiting for the background threads to start
150205 20:54:02 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 61496149
150205 20:54:02 [Note] Plugin 'FEEDBACK' is disabled.
150205 20:54:02 [Note] Server socket created on IP: '0.0.0.0'.
150205 20:54:02 [Note] Event Scheduler: Loaded 0 events
150205 20:54:02 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150205 20:55:36 [Warning] IP address '74.86.158.106' has been resolved to the host name '74.86.158.106-static.reverse.softlayer.com', which resembles IPv4-address itself.
150205 20:59:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150205 20:59:01 InnoDB: The InnoDB memory heap is disabled
150205 20:59:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150205 20:59:01 InnoDB: Compressed tables use zlib 1.2.7
150205 20:59:01 InnoDB: Using Linux native AIO
150205 20:59:01 InnoDB: Initializing buffer pool, size = 128.0M
150205 20:59:01 InnoDB: Completed initialization of buffer pool
150205 20:59:01 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!
150205 20:59:01  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
 
norting wotk, i have delete the tabel as was bug, but the server still keep crashing -_-

My log is full of this.. one like 40 min

Code: 
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
150205 19:19:06  InnoDB: Waiting for the background threads to start
150205 19:19:07 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 60933161
150205 19:19:07 [Note] Plugin 'FEEDBACK' is disabled.
150205 19:19:07 [Note] Server socket created on IP: '0.0.0.0'.
150205 19:19:07 [Note] Event Scheduler: Loaded 0 events
150205 19:19:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150205 19:19:58 [Warning] IP address '74.86.158.106' has been resolved to the host name '74.86.158.106-static.reverse.softlayer.com', which resembles IPv4-address itself.
150205 19:25:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150205 19:25:02 InnoDB: The InnoDB memory heap is disabled
150205 19:25:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150205 19:25:02 InnoDB: Compressed tables use zlib 1.2.7
150205 19:25:02 InnoDB: Using Linux native AIO
150205 19:25:02 InnoDB: Initializing buffer pool, size = 128.0M
150205 19:25:02 InnoDB: Completed initialization of buffer pool
150205 19:25:02 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!
150205 19:25:02  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
 
You must log in or register to reply here.
Back
Top