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
add comment

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.