Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

My Innodb Engine is getting crashed frequently. I could not find the reason behind this.

This is the error log:

140129 9:22:49 [Note] Plugin 'FEDERATED' is disabled. 
140129 9:22:49 InnoDB: The InnoDB memory heap is disabled 
140129 9:22:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins 
140129 9:22:49 InnoDB: Compressed tables use zlib 1.2.3.4 
140129 9:22:50 InnoDB: Initializing buffer pool, size = 128.0M 
140129 9:22:50 InnoDB: Completed initialization of buffer pool 
140129 9:22:50 InnoDB: highest supported file format is Barracuda. 
               InnoDB: Log scan progressed past the checkpoint lsn 275341002 
140129 9:22:50 InnoDB: Database was not shut down normally! 
               InnoDB: Starting crash recovery. 
               InnoDB: Reading tablespace information from the .ibd files... 
               InnoDB: Restoring possible half-written data pages from the doublewrite 
               InnoDB: buffer... 
               InnoDB: Doing recovery: scanned up to log sequence number 275341421 
               InnoDB: 3 transaction(s) which must be rolled back or cleaned up 
               InnoDB: in total 15 row operations to undo 
               InnoDB: Trx id counter is 294A00 
140129 9:22:51 InnoDB: Starting an apply batch of log records to the database... 
               InnoDB: Progress in percents: 19 20 21 22 23 24 25 26 27 28 29 30 31 32     
               InnoDB: Apply batch completed 
               InnoDB: Starting in background the rollback of uncommitted transactions 
140129 9:22:51 InnoDB: Rolling back trx with id 2948FA, 6 rows to undo 
140129 9:22:51 InnoDB: Waiting for the background threads to start 
               InnoDB: Rolling back of trx id 2948FA completed 
140129 9:22:51 InnoDB: Rolling back trx with id 2948F9, 5 rows to undo 
               InnoDB: Rolling back of trx id 2948F9 completed 
140129 9:22:51 InnoDB: Rolling back trx with id 2948D6, 4 rows to undo 
               InnoDB: Rolling back of trx id 2948D6 completed 
140129 9:22:51 InnoDB: Rollback of non-prepared transactions completed 
140129 9:22:52 InnoDB: 1.1.8 started; log sequence number 275341421 
140129 9:22:52 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 
140129 9:22:52 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 
140129 9:22:52 [Note] Server socket created on IP: '0.0.0.0'. 
140129 9:22:52 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and 
should be repaired 
140129 9:22:52 [Warning] Checking table: './mysql/user' 
140129 9:22:52 [ERROR] 1 client is using or hasn't closed the table properly 
140129 9:22:52 [Note] Event Scheduler: Loaded 0 events 
140129 9:22:52 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.29-
0ubuntu0.12.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 
140129 9:22:56 [ERROR] /usr/sbin/mysqld: Table './sarojini/wp_options' is marked as crashed 
and should be repaired 
140129 9:22:56 [Warning] Checking table: './sarojini/wp_options' 
140129 9:22:57 [ERROR] /usr/sbin/mysqld: Table './sysvine/wp_sysvinewpoptions' is marked as 
crashed and should be repaired 
140129 9:22:57 [Warning] Checking table: './sysvine/wp_sysvinewpoptions' 
140129 13:00:37 [Note] /usr/sbin/mysqld: Normal shutdown 
140129 13:00:37 [Note] Event Scheduler: Purging the queue. 0 events' 
140129 13:00:39 InnoDB: Starting shutdown... 
140129 13:00:40 InnoDB: Waiting for 20 pages to be flushed 
140129 13:00:41 [Note] /usr/sbin/mysqld: Shutdown complete 
140129 13:01:52 [Note] Plugin 'FEDERATED' is disabled. 
140129 13:01:52 InnoDB: The InnoDB memory heap is disabled 
140129 13:01:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins 
140129 13:01:52 InnoDB: Compressed tables use zlib 1.2.3.4 
140129 13:01:52 InnoDB: Initializing buffer pool, size = 128.0M 
140129 13:01:53 InnoDB: Completed initialization of buffer pool 
140129 13:01:53 InnoDB: highest supported file format is Barracuda. 
140129 13:01:53 InnoDB: Waiting for the background threads to start 
140129 13:01:54 InnoDB: 1.1.8 started; log sequence number 277454104 
140129 13:01:54 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 
140129 13:01:54 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 
140129 13:01:54 [Note] Server socket created on IP: '0.0.0.0'. 
140129 13:01:55 [Note] Event Scheduler: Loaded 0 events 
140129 13:01:55 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.29-
0ubuntu0.12.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 
140129 13:19:51 [Note] /usr/sbin/mysqld: Normal shutdown 
140129 13:19:51 [Note] Event Scheduler: Purging the queue. 0 events 
140129 13:19:53 [Warning] /usr/sbin/mysqld: Forcing close of thread 105 user: 'redmine' 
140129 13:19:53 InnoDB: Starting shutdown... 
140129 13:19:54 InnoDB: Shutdown completed; log sequence number 277619754 
140129 13:19:54 [Note] /usr/sbin/mysqld: Shutdown complete

Can anybody help me to stop this unwanted Innodb crash. Thanks in Advance...

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.