MySQL Keeps Crashing
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:
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.-
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. 0 -
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. 0 -
]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.
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
[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=900000 -
]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[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 guys0 -
Hello Please check and ensure that correct entries for loaclhost resolution is present in /etc/hosts file 0 -
The following thread should help you to address some of the InnoDB errors you referenced: InnoDB Repair Guide Thank you. 0
Please sign in to leave a comment.
Comments
6 comments