MySQL Forums
Forum List  »  InnoDB

mysql crash
Posted by: auqf 2
Date: July 03, 2014 08:06PM

the follows is the mysql error_log,I cannot find why the mysql-server always crash by automatic,any one can help me? thanks!
2014-07-03 23:00:59 20639 [Note] Plugin 'FEDERATED' is disabled.
2014-07-03 23:00:59 20639 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-07-03 23:00:59 20639 [Note] InnoDB: The InnoDB memory heap is disabled
2014-07-03 23:00:59 20639 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-07-03 23:00:59 20639 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-07-03 23:00:59 20639 [Note] InnoDB: Using Linux native AIO
2014-07-03 23:00:59 20639 [Note] InnoDB: Using CPU crc32 instructions
2014-07-03 23:00:59 20639 [Note] InnoDB: Initializing buffer pool, size = 2.0G
2014-07-03 23:00:59 20639 [Note] InnoDB: Completed initialization of buffer pool
2014-07-03 23:00:59 20639 [Note] InnoDB: Highest supported file format is Barracuda.
2014-07-03 23:00:59 20639 [Note] InnoDB: The log sequence numbers 32583775 and 32583775 in ibdata files do not match the log sequence number 33079888 in the ib_logfiles!
2014-07-03 23:00:59 20639 [Note] InnoDB: Database was not shutdown normally!
2014-07-03 23:00:59 20639 [Note] InnoDB: Starting crash recovery.
2014-07-03 23:00:59 20639 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-07-03 23:00:59 20639 [Note] InnoDB: Restoring possible half-written data pages
2014-07-03 23:00:59 20639 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 52618254, file name mysqld-bin.000257
2014-07-03 23:01:00 20639 [Note] InnoDB: 128 rollback segment(s) are active.
2014-07-03 23:01:00 20639 [Note] InnoDB: Waiting for purge to start
2014-07-03 23:01:00 20639 [Note] InnoDB: 5.6.18 started; log sequence number 33079888
2014-07-03 23:01:00 20639 [Note] Recovering after a crash using mysqld-bin
2014-07-03 23:01:01 20639 [Note] Starting crash recovery...
2014-07-03 23:01:01 20639 [Note] Crash recovery finished.
2014-07-03 23:01:04 20639 [Note] RSA private key file not found: /usr/local/mysql/data//private_key.pem. Some authentication plugins will not work.
2014-07-03 23:01:04 20639 [Note] RSA public key file not found: /usr/local/mysql/data//public_key.pem. Some authentication plugins will not work.
2014-07-03 23:01:04 20639 [Note] Server hostname (bind-address): '*'; port: 3306
2014-07-03 23:01:04 20639 [Note] IPv6 is available.
2014-07-03 23:01:04 20639 [Note] - '::' resolves to '::';
2014-07-03 23:01:04 20639 [Note] Server socket created on IP: '::'.
2014-07-03 23:01:04 20639 [Note] Event Scheduler: Loaded 0 events
2014-07-03 23:01:04 20639 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.18-enterprise-commercial-advanced-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (Commercial)
140703 23:49:58 mysqld_safe Number of processes running now: 0
140703 23:49:58 mysqld_safe mysqld restarted
2014-07-03 23:49:59 23013 [Note] Plugin 'FEDERATED' is disabled.
2014-07-03 23:49:59 23013 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-07-03 23:49:59 23013 [Note] InnoDB: The InnoDB memory heap is disabled
2014-07-03 23:49:59 23013 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-07-03 23:49:59 23013 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-07-03 23:49:59 23013 [Note] InnoDB: Using Linux native AIO
2014-07-03 23:49:59 23013 [Note] InnoDB: Using CPU crc32 instructions
2014-07-03 23:49:59 23013 [Note] InnoDB: Initializing buffer pool, size = 2.0G
2014-07-03 23:50:00 23013 [Note] InnoDB: Completed initialization of buffer pool
2014-07-03 23:50:00 23013 [Note] InnoDB: Highest supported file format is Barracuda.
2014-07-03 23:50:00 23013 [Note] InnoDB: The log sequence numbers 32583775 and 32583775 in ibdata files do not match the log sequence number 33084196 in the ib_logfiles!
2014-07-03 23:50:00 23013 [Note] InnoDB: Database was not shutdown normally!
2014-07-03 23:50:00 23013 [Note] InnoDB: Starting crash recovery.
2014-07-03 23:50:00 23013 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-07-03 23:50:00 23013 [Note] InnoDB: Restoring possible half-written data pages
2014-07-03 23:50:00 23013 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 52618254, file name mysqld-bin.000257
2014-07-03 23:50:00 23013 [Note] InnoDB: 128 rollback segment(s) are active.
2014-07-03 23:50:00 23013 [Note] InnoDB: Waiting for purge to start
2014-07-03 23:50:01 23013 [Note] InnoDB: 5.6.18 started; log sequence number 33084196
2014-07-03 23:50:01 23013 [Note] Recovering after a crash using mysqld-bin
2014-07-03 23:50:01 23013 [Note] Starting crash recovery...
2014-07-03 23:50:01 23013 [Note] Crash recovery finished.
2014-07-03 23:50:03 23013 [Note] RSA private key file not found: /usr/local/mysql/data//private_key.pem. Some authentication plugins will not work.
2014-07-03 23:50:03 23013 [Note] RSA public key file not found: /usr/local/mysql/data//public_key.pem. Some authentication plugins will not work.
2014-07-03 23:50:03 23013 [Note] Server hostname (bind-address): '*'; port: 3306
2014-07-03 23:50:03 23013 [Note] IPv6 is available.
2014-07-03 23:50:03 23013 [Note] - '::' resolves to '::';
2014-07-03 23:50:03 23013 [Note] Server socket created on IP: '::'.
2014-07-03 23:50:03 23013 [Note] Event Scheduler: Loaded 0 events
2014-07-03 23:50:03 23013 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.18-enterprise-commercial-advanced-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (Commercial)
140703 23:50:09 mysqld_safe Number of processes running now: 0
140703 23:50:09 mysqld_safe mysqld restarted
2014-07-03 23:50:10 23078 [Note] Plugin 'FEDERATED' is disabled.
2014-07-03 23:50:10 23078 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-07-03 23:50:10 23078 [Note] InnoDB: The InnoDB memory heap is disabled
2014-07-03 23:50:10 23078 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-07-03 23:50:10 23078 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-07-03 23:50:10 23078 [Note] InnoDB: Using Linux native AIO
2014-07-03 23:50:10 23078 [Note] InnoDB: Using CPU crc32 instructions
2014-07-03 23:50:10 23078 [Note] InnoDB: Initializing buffer pool, size = 2.0G
2014-07-03 23:50:10 23078 [Note] InnoDB: Completed initialization of buffer pool
2014-07-03 23:50:10 23078 [Note] InnoDB: Highest supported file format is Barracuda.
2014-07-03 23:50:10 23078 [Note] InnoDB: The log sequence numbers 32583775 and 32583775 in ibdata files do not match the log sequence number 33084206 in the ib_logfiles!
2014-07-03 23:50:10 23078 [Note] InnoDB: Database was not shutdown normally!
2014-07-03 23:50:10 23078 [Note] InnoDB: Starting crash recovery.
2014-07-03 23:50:10 23078 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-07-03 23:50:10 23078 [Note] InnoDB: Restoring possible half-written data pages
2014-07-03 23:50:10 23078 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 52618254, file name mysqld-bin.000257
2014-07-03 23:50:11 23078 [Note] InnoDB: 128 rollback segment(s) are active.
2014-07-03 23:50:11 23078 [Note] InnoDB: Waiting for purge to start
2014-07-03 23:50:11 23078 [Note] InnoDB: 5.6.18 started; log sequence number 33084206
2014-07-03 23:50:11 23078 [Note] Recovering after a crash using mysqld-bin
2014-07-03 23:50:11 23078 [Note] Starting crash recovery...
2014-07-03 23:50:11 23078 [Note] Crash recovery finished.
2014-07-03 23:50:12 23078 [Note] RSA private key file not found: /usr/local/mysql/data//private_key.pem. Some authentication plugins will not work.
2014-07-03 23:50:12 23078 [Note] RSA public key file not found: /usr/local/mysql/data//public_key.pem. Some authentication plugins will not work.
2014-07-03 23:50:12 23078 [Note] Server hostname (bind-address): '*'; port: 3306
2014-07-03 23:50:12 23078 [Note] IPv6 is available.
2014-07-03 23:50:12 23078 [Note] - '::' resolves to '::';
2014-07-03 23:50:12 23078 [Note] Server socket created on IP: '::'.
2014-07-03 23:50:12 23078 [Note] Event Scheduler: Loaded 0 events
2014-07-03 23:50:12 23078 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.18-enterprise-commercial-advanced-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (Commercial)
140703 23:50:13 mysqld_safe Number of processes running now: 0
140703 23:50:13 mysqld_safe mysqld restarted
2014-07-03 23:50:14 23124 [Note] Plugin 'FEDERATED' is disabled.
2014-07-03 23:50:14 23124 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-07-03 23:50:14 23124 [Note] InnoDB: The InnoDB memory heap is disabled
2014-07-03 23:50:14 23124 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-07-03 23:50:14 23124 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-07-03 23:50:14 23124 [Note] InnoDB: Using Linux native AIO
2014-07-03 23:50:14 23124 [Note] InnoDB: Using CPU crc32 instructions
2014-07-03 23:50:14 23124 [Note] InnoDB: Initializing buffer pool, size = 2.0G
2014-07-03 23:50:14 23124 [Note] InnoDB: Completed initialization of buffer pool
2014-07-03 23:50:14 23124 [Note] InnoDB: Highest supported file format is Barracuda.
2014-07-03 23:50:14 23124 [Note] InnoDB: Log scan progressed past the checkpoint lsn 33084206
2014-07-03 23:50:14 23124 [Note] InnoDB: Database was not shutdown normally!
2014-07-03 23:50:14 23124 [Note] InnoDB: Starting crash recovery.
2014-07-03 23:50:14 23124 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-07-03 23:50:14 23124 [Note] InnoDB: Restoring possible half-written data pages
2014-07-03 23:50:14 23124 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 33084216
InnoDB: Last MySQL binlog file position 0 52618254, file name mysqld-bin.000257
2014-07-03 23:50:15 23124 [Note] InnoDB: 128 rollback segment(s) are active.
2014-07-03 23:50:15 23124 [Note] InnoDB: Waiting for purge to start
2014-07-03 23:50:15 23124 [Note] InnoDB: 5.6.18 started; log sequence number 33084216
2014-07-03 23:50:15 23124 [Note] Recovering after a crash using mysqld-bin
2014-07-03 23:50:15 23124 [Note] Starting crash recovery...
2014-07-03 23:50:15 23124 [Note] Crash recovery finished.
2014-07-03 23:50:15 23124 [Note] RSA private key file not found: /usr/local/mysql/data//private_key.pem. Some authentication plugins will not work.
2014-07-03 23:50:15 23124 [Note] RSA public key file not found: /usr/local/mysql/data//public_key.pem. Some authentication plugins will not work.
2014-07-03 23:50:15 23124 [Note] Server hostname (bind-address): '*'; port: 3306
2014-07-03 23:50:15 23124 [Note] IPv6 is available.
2014-07-03 23:50:15 23124 [Note] - '::' resolves to '::';
2014-07-03 23:50:15 23124 [Note] Server socket created on IP: '::'.
2014-07-03 23:50:16 23124 [Note] Event Scheduler: Loaded 0 events
2014-07-03 23:50:16 23124 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.18-enterprise-commercial-advanced-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (Commercial)
140703 23:50:16 mysqld_safe Number of processes running now: 0
140703 23:50:16 mysqld_safe mysqld restarted
2014-07-03 23:50:17 23163 [Note] Plugin 'FEDERATED' is disabled.
2014-07-03 23:50:17 23163 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-07-03 23:50:17 23163 [Note] InnoDB: The InnoDB memory heap is disabled
2014-07-03 23:50:17 23163 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-07-03 23:50:17 23163 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-07-03 23:50:17 23163 [Note] InnoDB: Using Linux native AIO
2014-07-03 23:50:17 23163 [Note] InnoDB: Using CPU crc32 instructions
2014-07-03 23:50:17 23163 [Note] InnoDB: Initializing buffer pool, size = 2.0G
2014-07-03 23:50:17 23163 [Note] InnoDB: Completed initialization of buffer pool
2014-07-03 23:50:18 23163 [Note] InnoDB: Highest supported file format is Barracuda.
2014-07-03 23:50:18 23163 [Note] InnoDB: Log scan progressed past the checkpoint lsn 33084206
2014-07-03 23:50:18 23163 [Note] InnoDB: Database was not shutdown normally!
2014-07-03 23:50:18 23163 [Note] InnoDB: Starting crash recovery.
2014-07-03 23:50:18 23163 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-07-03 23:50:18 23163 [Note] InnoDB: Restoring possible half-written data pages
2014-07-03 23:50:18 23163 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 33084226
InnoDB: Last MySQL binlog file position 0 52618254, file name mysqld-bin.000257
2014-07-03 23:50:18 23163 [Note] InnoDB: 128 rollback segment(s) are active.
2014-07-03 23:50:18 23163 [Note] InnoDB: Waiting for purge to start
2014-07-03 23:50:18 23163 [Note] InnoDB: 5.6.18 started; log sequence number 33084226
2014-07-03 23:50:18 23163 [Note] Recovering after a crash using mysqld-bin
2014-07-03 23:50:18 23163 [Note] Starting crash recovery...
2014-07-03 23:50:18 23163 [Note] Crash recovery finished.
2014-07-03 23:50:18 23163 [Note] RSA private key file not found: /usr/local/mysql/data//private_key.pem. Some authentication plugins will not work.
2014-07-03 23:50:18 23163 [Note] RSA public key file not found: /usr/local/mysql/data//public_key.pem. Some authentication plugins will not work.
2014-07-03 23:50:18 23163 [Note] Server hostname (bind-address): '*'; port: 3306
2014-07-03 23:50:18 23163 [Note] IPv6 is available.
2014-07-03 23:50:18 23163 [Note] - '::' resolves to '::';
2014-07-03 23:50:18 23163 [Note] Server socket created on IP: '::'.
2014-07-03 23:50:19 23163 [Note] Event Scheduler: Loaded 0 events
2014-07-03 23:50:19 23163 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.18-enterprise-commercial-advanced-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (Commercial)
140703 23:50:28 mysqld_safe Number of processes running now: 0
140703 23:50:28 mysqld_safe mysqld restarted
2014-07-03 23:50:29 23225 [Note] Plugin 'FEDERATED' is disabled.
2014-07-03 23:50:29 23225 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-07-03 23:50:29 23225 [Note] InnoDB: The InnoDB memory heap is disabled
2014-07-03 23:50:29 23225 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-07-03 23:50:29 23225 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-07-03 23:50:29 23225 [Note] InnoDB: Using Linux native AIO
2014-07-03 23:50:29 23225 [Note] InnoDB: Using CPU crc32 instructions
2014-07-03 23:50:29 23225 [Note] InnoDB: Initializing buffer pool, size = 2.0G
2014-07-03 23:50:29 23225 [Note] InnoDB: Completed initialization of buffer pool
2014-07-03 23:50:30 23225 [Note] InnoDB: Highest supported file format is Barracuda.
2014-07-03 23:50:30 23225 [Note] InnoDB: The log sequence numbers 32583775 and 32583775 in ibdata files do not match the log sequence number 33084236 in the ib_logfiles!
2014-07-03 23:50:30 23225 [Note] InnoDB: Database was not shutdown normally!
2014-07-03 23:50:30 23225 [Note] InnoDB: Starting crash recovery.
2014-07-03 23:50:30 23225 [Note] InnoDB: Reading tablespace information from the .ibd files...
140703 23:50:30 mysqld_safe mysqld from pid file /usr/local/mysql/data/hmcwebserver.pid ended
140704 08:59:45 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
2014-07-04 08:59:46 14791 [Note] Plugin 'FEDERATED' is disabled.
2014-07-04 08:59:46 14791 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-07-04 08:59:46 14791 [Note] InnoDB: The InnoDB memory heap is disabled
2014-07-04 08:59:46 14791 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-07-04 08:59:46 14791 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-07-04 08:59:46 14791 [Note] InnoDB: Using Linux native AIO
2014-07-04 08:59:46 14791 [Note] InnoDB: Using CPU crc32 instructions
2014-07-04 08:59:46 14791 [Note] InnoDB: Initializing buffer pool, size = 2.0G
2014-07-04 08:59:47 14791 [Note] InnoDB: Completed initialization of buffer pool
2014-07-04 08:59:47 14791 [Note] InnoDB: Highest supported file format is Barracuda.
2014-07-04 08:59:47 14791 [Note] InnoDB: The log sequence numbers 32583775 and 32583775 in ibdata files do not match the log sequence number 33084236 in the ib_logfiles!
2014-07-04 08:59:47 14791 [Note] InnoDB: Database was not shutdown normally!
2014-07-04 08:59:47 14791 [Note] InnoDB: Starting crash recovery.
2014-07-04 08:59:47 14791 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-07-04 08:59:47 14791 [Note] InnoDB: Restoring possible half-written data pages
2014-07-04 08:59:47 14791 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 52618254, file name mysqld-bin.000257
2014-07-04 08:59:47 14791 [Note] InnoDB: 128 rollback segment(s) are active.
2014-07-04 08:59:47 14791 [Note] InnoDB: Waiting for purge to start
2014-07-04 08:59:47 14791 [Note] InnoDB: 5.6.18 started; log sequence number 33084236
2014-07-04 08:59:48 14791 [Note] Recovering after a crash using mysqld-bin
2014-07-04 08:59:48 14791 [Note] Starting crash recovery...
2014-07-04 08:59:48 14791 [Note] Crash recovery finished.
2014-07-04 08:59:51 14791 [Note] RSA private key file not found: /usr/local/mysql/data//private_key.pem. Some authentication plugins will not work.
2014-07-04 08:59:51 14791 [Note] RSA public key file not found: /usr/local/mysql/data//public_key.pem. Some authentication plugins will not work.
2014-07-04 08:59:51 14791 [Note] Server hostname (bind-address): '*'; port: 3306
2014-07-04 08:59:51 14791 [Note] IPv6 is available.
2014-07-04 08:59:51 14791 [Note] - '::' resolves to '::';
2014-07-04 08:59:51 14791 [Note] Server socket created on IP: '::'.
2014-07-04 08:59:51 14791 [Note] Event Scheduler: Loaded 0 events
2014-07-04 08:59:51 14791 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.18-enterprise-commercial-advanced-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (Commercial)

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql crash
1934
July 03, 2014 08:06PM
692
August 14, 2014 05:59AM
699
August 15, 2014 03:53PM
619
August 22, 2014 07:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.