sonar123

Registered
Jan 21, 2015
3
0
1
cPanel Access Level
Root Administrator
For some reason my MySQL server keeps crashing and it won't come back up unless I manually start the mySQL service.
Here are the logs:
Code:
150121 08:10:03 mysqld_safe Number of processes running now: 0
150121 08:10:03 mysqld_safe mysqld restarted
2015-01-21 08:10:04 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-01-21 08:10:04 27595 [Note] Plugin 'FEDERATED' is disabled.
2015-01-21 08:10:04 27595 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-21 08:10:04 27595 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-21 08:10:04 27595 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-21 08:10:04 27595 [Note] InnoDB: Memory barrier is not used
2015-01-21 08:10:04 27595 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-21 08:10:04 27595 [Note] InnoDB: Using CPU crc32 instructions
2015-01-21 08:10:04 27595 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-21 08:10:04 27595 [Note] InnoDB: Completed initialization of buffer pool
2015-01-21 08:10:04 27595 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-21 08:10:04 27595 [Note] InnoDB: The log sequence numbers 656234369 and 656234369 in ibdata files do not match the log sequence number 679681695 in the ib_logfiles!
2015-01-21 08:10:04 27595 [Note] InnoDB: Database was not shutdown normally!
2015-01-21 08:10:04 27595 [Note] InnoDB: Starting crash recovery.
2015-01-21 08:10:04 27595 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-01-21 08:10:06 27595 [Note] InnoDB: Restoring possible half-written data pages 
2015-01-21 08:10:06 27595 [Note] InnoDB: from the doublewrite buffer...
2015-01-21 08:10:06 27595 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-21 08:10:06 27595 [Note] InnoDB: Waiting for purge to start
2015-01-21 08:10:06 27595 [Note] InnoDB: 5.6.22 started; log sequence number 679681695
2015-01-21 08:10:06 27595 [Note] Server hostname (bind-address): '*'; port: 3306
2015-01-21 08:10:06 27595 [Note] IPv6 is available.
2015-01-21 08:10:06 27595 [Note]   - '::' resolves to '::';
2015-01-21 08:10:06 27595 [Note] Server socket created on IP: '::'.
2015-01-21 08:10:06 27595 [Note] Event Scheduler: Loaded 0 events
2015-01-21 08:10:06 27595 [Note] /usr/sbin/mysqld: ready for connections.
 

24x7server

Well-Known Member
Apr 17, 2013
1,913
99
78
India
cPanel Access Level
Root Administrator
Twitter
Re: MySQL Keeps Crashing - help

Hello,

Can you please forward the full logs of your MySQL services as I did not found any issues in the provided logs. Please monitor it and try to find out what error are getting in logs when MySQL services getting stop.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,250
463
Hello :)

Is there any output just before the MySQL restart that indicates why it failed? Do you have any custom modifications in your /etc/my.cnf file?

Thank you.
 

sonar123

Registered
Jan 21, 2015
3
0
1
cPanel Access Level
Root Administrator
Hello :)

Is there any output just before the MySQL restart that indicates why it failed? Do you have any custom modifications in your /etc/my.cnf file?

Thank you.
Hello,

Can you please forward the full logs of your MySQL services as I did not found any issues in the provided logs. Please monitor it and try to find out what error are getting in logs when MySQL services getting stop.
Code:
Version: '5.6.22'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
150121 08:10:03 mysqld_safe Number of processes running now: 0
150121 08:10:03 mysqld_safe mysqld restarted
2015-01-21 08:10:04 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-01-21 08:10:04 27595 [Note] Plugin 'FEDERATED' is disabled.
2015-01-21 08:10:04 27595 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-21 08:10:04 27595 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-21 08:10:04 27595 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-21 08:10:04 27595 [Note] InnoDB: Memory barrier is not used
2015-01-21 08:10:04 27595 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-21 08:10:04 27595 [Note] InnoDB: Using CPU crc32 instructions
2015-01-21 08:10:04 27595 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-21 08:10:04 27595 [Note] InnoDB: Completed initialization of buffer pool
2015-01-21 08:10:04 27595 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-21 08:10:04 27595 [Note] InnoDB: The log sequence numbers 656234369 and 656234369 in ibdata files do not match the log sequence number 679681695 in the ib_logfiles!
2015-01-21 08:10:04 27595 [Note] InnoDB: Database was not shutdown normally!
2015-01-21 08:10:04 27595 [Note] InnoDB: Starting crash recovery.
2015-01-21 08:10:04 27595 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-01-21 08:10:06 27595 [Note] InnoDB: Restoring possible half-written data pages 
2015-01-21 08:10:06 27595 [Note] InnoDB: from the doublewrite buffer...
2015-01-21 08:10:06 27595 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-21 08:10:06 27595 [Note] InnoDB: Waiting for purge to start
2015-01-21 08:10:06 27595 [Note] InnoDB: 5.6.22 started; log sequence number 679681695
2015-01-21 08:10:06 27595 [Note] Server hostname (bind-address): '*'; port: 3306
2015-01-21 08:10:06 27595 [Note] IPv6 is available.
2015-01-21 08:10:06 27595 [Note]   - '::' resolves to '::';
2015-01-21 08:10:06 27595 [Note] Server socket created on IP: '::'.
2015-01-21 08:10:06 27595 [Note] Event Scheduler: Loaded 0 events
2015-01-21 08:10:06 27595 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.22'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
150121 09:39:03 mysqld_safe Number of processes running now: 0
150121 09:39:03 mysqld_safe mysqld restarted
150121 09:39:04 mysqld_safe mysqld from pid file /var/lib/mysql/webhost.hostodo.com.pid ended
150121 20:14:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-01-21 20:14:41 28166 [Note] Plugin 'FEDERATED' is disabled.
2015-01-21 20:14:41 28166 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-21 20:14:41 28166 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-21 20:14:41 28166 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-21 20:14:41 28166 [Note] InnoDB: Memory barrier is not used
2015-01-21 20:14:41 28166 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-21 20:14:41 28166 [Note] InnoDB: Using CPU crc32 instructions
2015-01-21 20:14:41 28166 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-21 20:14:41 28166 [Note] InnoDB: Completed initialization of buffer pool
2015-01-21 20:14:41 28166 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-21 20:14:41 28166 [Note] InnoDB: The log sequence numbers 656234369 and 656234369 in ibdata files do not match the log sequence number 679866178 in the ib_logfiles!
2015-01-21 20:14:41 28166 [Note] InnoDB: Database was not shutdown normally!
2015-01-21 20:14:41 28166 [Note] InnoDB: Starting crash recovery.
2015-01-21 20:14:41 28166 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-01-21 20:14:43 28166 [Note] InnoDB: Restoring possible half-written data pages 
2015-01-21 20:14:43 28166 [Note] InnoDB: from the doublewrite buffer...
2015-01-21 20:14:43 28166 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-21 20:14:43 28166 [Note] InnoDB: Waiting for purge to start
2015-01-21 20:14:43 28166 [Note] InnoDB: 5.6.22 started; log sequence number 679866178
2015-01-21 20:14:43 28166 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
2015-01-21 20:14:44 28166 [Note] Server hostname (bind-address): '*'; port: 3306
2015-01-21 20:14:44 28166 [Note] IPv6 is available.
2015-01-21 20:14:44 28166 [Note]   - '::' resolves to '::';
2015-01-21 20:14:44 28166 [Note] Server socket created on IP: '::'.
2015-01-21 20:14:44 28166 [Note] Event Scheduler: Loaded 0 events
2015-01-21 20:14:44 28166 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.22'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
150121 20:16:07 mysqld_safe A mysqld process already exists
150121 20:16:09 mysqld_safe A mysqld process already exists
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
150121 20:20:04 mysqld_safe Number of processes running now: 0
150121 20:20:04 mysqld_safe mysqld restarted
2015-01-21 20:20:05 30205 [Note] Plugin 'FEDERATED' is disabled.
2015-01-21 20:20:05 30205 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-21 20:20:05 30205 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-21 20:20:05 30205 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-21 20:20:05 30205 [Note] InnoDB: Memory barrier is not used
2015-01-21 20:20:05 30205 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-21 20:20:05 30205 [Note] InnoDB: Using CPU crc32 instructions
2015-01-21 20:20:05 30205 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-21 20:20:05 30205 [Note] InnoDB: Completed initialization of buffer pool
2015-01-21 20:20:05 30205 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-21 20:20:05 30205 [Note] InnoDB: Log scan progressed past the checkpoint lsn 679866350
2015-01-21 20:20:05 30205 [Note] InnoDB: Database was not shutdown normally!
2015-01-21 20:20:05 30205 [Note] InnoDB: Starting crash recovery.
2015-01-21 20:20:05 30205 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-01-21 20:20:05 30205 [Note] InnoDB: Restoring possible half-written data pages 
2015-01-21 20:20:05 30205 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 679866360
2015-01-21 20:20:05 30205 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-21 20:20:05 30205 [Note] InnoDB: Waiting for purge to start
2015-01-21 20:20:05 30205 [Note] InnoDB: 5.6.22 started; log sequence number 679866360
2015-01-21 20:20:05 30205 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
2015-01-21 20:20:05 30205 [Note] Server hostname (bind-address): '*'; port: 3306
2015-01-21 20:20:05 30205 [Note] IPv6 is available.
2015-01-21 20:20:05 30205 [Note]   - '::' resolves to '::';
2015-01-21 20:20:05 30205 [Note] Server socket created on IP: '::'.
2015-01-21 20:20:05 30205 [Note] Event Scheduler: Loaded 0 events
2015-01-21 20:20:05 30205 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.22'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
150121 20:20:06 mysqld_safe Number of processes running now: 0
150121 20:20:06 mysqld_safe mysqld restarted
2015-01-21 20:20:06 30362 [Note] Plugin 'FEDERATED' is disabled.
2015-01-21 20:20:06 30362 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-21 20:20:06 30362 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-21 20:20:06 30362 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-21 20:20:06 30362 [Note] InnoDB: Memory barrier is not used
2015-01-21 20:20:06 30362 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-21 20:20:06 30362 [Note] InnoDB: Using CPU crc32 instructions
2015-01-21 20:20:06 30362 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-21 20:20:06 30362 [Note] InnoDB: Completed initialization of buffer pool
2015-01-21 20:20:06 30362 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-21 20:20:06 30362 [Note] InnoDB: Log scan progressed past the checkpoint lsn 679866350
2015-01-21 20:20:06 30362 [Note] InnoDB: Database was not shutdown normally!
2015-01-21 20:20:06 30362 [Note] InnoDB: Starting crash recovery.
2015-01-21 20:20:06 30362 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-01-21 20:20:06 30362 [Note] InnoDB: Restoring possible half-written data pages 
2015-01-21 20:20:06 30362 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 679866360
2015-01-21 20:20:07 30362 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-21 20:20:07 30362 [Note] InnoDB: Waiting for purge to start
2015-01-21 20:20:07 30362 [Note] InnoDB: 5.6.22 started; log sequence number 679866360
2015-01-21 20:20:07 30362 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
2015-01-21 20:20:07 30362 [Note] Server hostname (bind-address): '*'; port: 3306
2015-01-21 20:20:07 30362 [Note] IPv6 is available.
2015-01-21 20:20:07 30362 [Note]   - '::' resolves to '::';
2015-01-21 20:20:07 30362 [Note] Server socket created on IP: '::'.
2015-01-21 20:20:07 30362 [Note] Event Scheduler: Loaded 0 events
2015-01-21 20:20:07 30362 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.22'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
150121 20:29:51 mysqld_safe Number of processes running now: 0
150121 20:29:51 mysqld_safe mysqld restarted
2015-01-21 20:29:52 31875 [Note] Plugin 'FEDERATED' is disabled.
2015-01-21 20:29:52 31875 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-21 20:29:52 31875 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-21 20:29:52 31875 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-21 20:29:52 31875 [Note] InnoDB: Memory barrier is not used
2015-01-21 20:29:52 31875 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-21 20:29:52 31875 [Note] InnoDB: Using CPU crc32 instructions
2015-01-21 20:29:52 31875 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-21 20:29:52 31875 [Note] InnoDB: Completed initialization of buffer pool
2015-01-21 20:29:52 31875 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-21 20:29:52 31875 [Note] InnoDB: The log sequence numbers 656234369 and 656234369 in ibdata files do not match the log sequence number 679866476 in the ib_logfiles!
2015-01-21 20:29:52 31875 [Note] InnoDB: Database was not shutdown normally!
2015-01-21 20:29:52 31875 [Note] InnoDB: Starting crash recovery.
2015-01-21 20:29:52 31875 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-01-21 20:29:53 31875 [Note] InnoDB: Restoring possible half-written data pages 
2015-01-21 20:29:53 31875 [Note] InnoDB: from the doublewrite buffer...
2015-01-21 20:29:53 31875 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-21 20:29:53 31875 [Note] InnoDB: Waiting for purge to start
2015-01-21 20:29:53 31875 [Note] InnoDB: 5.6.22 started; log sequence number 679866476
2015-01-21 20:29:53 31875 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
2015-01-21 20:29:53 31875 [Note] Server hostname (bind-address): '*'; port: 3306
2015-01-21 20:29:53 31875 [Note] IPv6 is available.
2015-01-21 20:29:53 31875 [Note]   - '::' resolves to '::';
2015-01-21 20:29:53 31875 [Note] Server socket created on IP: '::'.
2015-01-21 20:29:53 31875 [Note] Event Scheduler: Loaded 0 events
2015-01-21 20:29:53 31875 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.22'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
150121 20:38:01 mysqld_safe Number of processes running now: 0
150121 20:38:01 mysqld_safe mysqld restarted
2015-01-21 20:38:01 1374 [Note] Plugin 'FEDERATED' is disabled.
2015-01-21 20:38:01 1374 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-21 20:38:01 1374 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-21 20:38:01 1374 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-21 20:38:01 1374 [Note] InnoDB: Memory barrier is not used
2015-01-21 20:38:01 1374 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-21 20:38:01 1374 [Note] InnoDB: Using CPU crc32 instructions
2015-01-21 20:38:01 1374 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-21 20:38:01 1374 [Note] InnoDB: Completed initialization of buffer pool
150121 20:38:01 mysqld_safe mysqld from pid file /var/lib/mysql/webhost.hostodo.com.pid ended
150121 21:22:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-01-21 21:22:47 10692 [Note] Plugin 'FEDERATED' is disabled.
2015-01-21 21:22:47 10692 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-21 21:22:47 10692 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-21 21:22:47 10692 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-21 21:22:47 10692 [Note] InnoDB: Memory barrier is not used
2015-01-21 21:22:47 10692 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-21 21:22:47 10692 [Note] InnoDB: Using CPU crc32 instructions
2015-01-21 21:22:47 10692 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-21 21:22:47 10692 [Note] InnoDB: Completed initialization of buffer pool
2015-01-21 21:22:47 10692 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-21 21:22:47 10692 [Note] InnoDB: The log sequence numbers 656234369 and 656234369 in ibdata files do not match the log sequence number 679866576 in the ib_logfiles!
2015-01-21 21:22:47 10692 [Note] InnoDB: Database was not shutdown normally!
2015-01-21 21:22:47 10692 [Note] InnoDB: Starting crash recovery.
2015-01-21 21:22:47 10692 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-01-21 21:22:48 10692 [Note] InnoDB: Restoring possible half-written data pages 
2015-01-21 21:22:48 10692 [Note] InnoDB: from the doublewrite buffer...
2015-01-21 21:22:49 10692 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-21 21:22:49 10692 [Note] InnoDB: Waiting for purge to start
2015-01-21 21:22:49 10692 [Note] InnoDB: 5.6.22 started; log sequence number 679866576
2015-01-21 21:22:49 10692 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
2015-01-21 21:22:49 10692 [Note] Server hostname (bind-address): '*'; port: 3306
2015-01-21 21:22:49 10692 [Note] IPv6 is available.
2015-01-21 21:22:49 10692 [Note]   - '::' resolves to '::';
2015-01-21 21:22:49 10692 [Note] Server socket created on IP: '::'.
2015-01-21 21:22:49 10692 [Note] Event Scheduler: Loaded 0 events
2015-01-21 21:22:49 10692 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.22'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
2015-01-21 21:24:40 10692 [Note] /usr/sbin/mysqld: Normal shutdown

2015-01-21 21:24:40 10692 [Note] Giving 0 client threads a chance to die gracefully
2015-01-21 21:24:40 10692 [Note] Event Scheduler: Purging the queue. 0 events
2015-01-21 21:24:40 10692 [Note] Shutting down slave threads
2015-01-21 21:24:40 10692 [Note] Forcefully disconnecting 0 remaining clients
2015-01-21 21:24:40 10692 [Note] Binlog end
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'partition'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'ARCHIVE'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_METRICS'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_CMP'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'INNODB_TRX'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'InnoDB'
2015-01-21 21:24:40 10692 [Note] InnoDB: FTS optimize thread exiting.
2015-01-21 21:24:40 10692 [Note] InnoDB: Starting shutdown...
2015-01-21 21:24:40 10692 [Note] InnoDB: Shutdown completed; log sequence number 679866586
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'BLACKHOLE'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'MRG_MYISAM'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'CSV'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'MEMORY'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'MyISAM'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'sha256_password'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'mysql_old_password'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'mysql_native_password'
2015-01-21 21:24:40 10692 [Note] Shutting down plugin 'binlog'
2015-01-21 21:24:40 10692 [Note] /usr/sbin/mysqld: Shutdown complete

150121 21:24:40 mysqld_safe mysqld from pid file /var/lib/mysql/webhost.hostodo.com.pid ended
150121 21:24:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-01-21 21:24:41 10995 [Note] Plugin 'FEDERATED' is disabled.
2015-01-21 21:24:41 10995 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-21 21:24:41 10995 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-21 21:24:41 10995 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-21 21:24:41 10995 [Note] InnoDB: Memory barrier is not used
2015-01-21 21:24:41 10995 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-21 21:24:41 10995 [Note] InnoDB: Using CPU crc32 instructions
2015-01-21 21:24:41 10995 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-21 21:24:41 10995 [Note] InnoDB: Completed initialization of buffer pool
2015-01-21 21:24:41 10995 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-21 21:24:41 10995 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-21 21:24:41 10995 [Note] InnoDB: Waiting for purge to start
2015-01-21 21:24:41 10995 [Note] InnoDB: 5.6.22 started; log sequence number 679866586
2015-01-21 21:24:41 10995 [Note] Server hostname (bind-address): '*'; port: 3306
2015-01-21 21:24:41 10995 [Note] IPv6 is available.
2015-01-21 21:24:41 10995 [Note]   - '::' resolves to '::';
2015-01-21 21:24:41 10995 [Note] Server socket created on IP: '::'.
2015-01-21 21:24:41 10995 [Note] Event Scheduler: Loaded 0 events
2015-01-21 21:24:41 10995 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.22'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
150121 21:33:12 mysqld_safe Number of processes running now: 0
150121 21:33:12 mysqld_safe mysqld restarted
2015-01-21 21:33:12 12372 [Note] Plugin 'FEDERATED' is disabled.
2015-01-21 21:33:12 12372 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-21 21:33:12 12372 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-21 21:33:12 12372 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-21 21:33:12 12372 [Note] InnoDB: Memory barrier is not used
2015-01-21 21:33:12 12372 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-21 21:33:12 12372 [Note] InnoDB: Using CPU crc32 instructions
2015-01-21 21:33:12 12372 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-21 21:33:12 12372 [Note] InnoDB: Completed initialization of buffer pool
150121 21:33:12 mysqld_safe mysqld from pid file /var/lib/mysql/webhost.hostodo.com.pid ended
150122 17:36:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-01-22 17:36:11 15500 [Note] Plugin 'FEDERATED' is disabled.
2015-01-22 17:36:11 15500 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-22 17:36:11 15500 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-22 17:36:11 15500 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-22 17:36:11 15500 [Note] InnoDB: Memory barrier is not used
2015-01-22 17:36:11 15500 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-22 17:36:11 15500 [Note] InnoDB: Using CPU crc32 instructions
2015-01-22 17:36:11 15500 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-22 17:36:11 15500 [Note] InnoDB: Completed initialization of buffer pool
2015-01-22 17:36:11 15500 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-22 17:36:11 15500 [Note] InnoDB: Log scan progressed past the checkpoint lsn 680049940
2015-01-22 17:36:11 15500 [Note] InnoDB: Database was not shutdown normally!
2015-01-22 17:36:11 15500 [Note] InnoDB: Starting crash recovery.
2015-01-22 17:36:11 15500 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-01-22 17:36:15 15500 [Note] InnoDB: Restoring possible half-written data pages 
2015-01-22 17:36:15 15500 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 680056480
2015-01-22 17:36:15 15500 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 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
2015-01-22 17:36:15 15500 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-22 17:36:15 15500 [Note] InnoDB: Waiting for purge to start
2015-01-22 17:36:15 15500 [Note] InnoDB: 5.6.22 started; log sequence number 680056480
2015-01-22 17:36:16 15500 [Note] Server hostname (bind-address): '*'; port: 3306
2015-01-22 17:36:16 15500 [Note] IPv6 is available.
2015-01-22 17:36:16 15500 [Note]   - '::' resolves to '::';
2015-01-22 17:36:16 15500 [Note] Server socket created on IP: '::'.
2015-01-22 17:36:16 15500 [Note] Event Scheduler: Loaded 0 events
2015-01-22 17:36:16 15500 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.22'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
150122 17:36:52 mysqld_safe Number of processes running now: 0
150122 17:36:52 mysqld_safe mysqld restarted
150122 17:36:53 mysqld_safe mysqld from pid file /var/lib/mysql/webhost.hostodo.com.pid ended
Code:
[mysqld]
default-storage-engine=MyISAM
explicit_defaults_for_timestamp = 1
innodb_file_per_table=1
max_allowed_packet=268435456
innodb_use_native_aio = 0
open_files_limit=90000
 

sonar123

Registered
Jan 21, 2015
3
0
1
cPanel Access Level
Root Administrator
Hello :)

Is there any output just before the MySQL restart that indicates why it failed? Do you have any custom modifications in your /etc/my.cnf file?

Thank you.
Hello,

Can you please forward the full logs of your MySQL services as I did not found any issues in the provided logs. Please monitor it and try to find out what error are getting in logs when MySQL services getting stop.
More logs:
/pastebin.com/t1hxpWDu


Code:
[mysqld]
default-storage-engine=MyISAM
explicit_defaults_for_timestamp = 1
innodb_file_per_table=1
max_allowed_packet=268435456
innodb_use_native_aio = 0
open_files_limit=90000
Thanks for the help guys
 

SS-Maddy

Well-Known Member
Mar 28, 2009
130
18
68
cPanel Access Level
Root Administrator
Hello

Please check and ensure that correct entries for loaclhost resolution is present in /etc/hosts file
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,250
463
The following thread should help you to address some of the InnoDB errors you referenced:

InnoDB Repair Guide

Thank you.