MySQL Forums
Forum List  »  InnoDB

MySQL Crash
Posted by: Dimitrios Tsanas
Date: June 15, 2011 02:31AM

My MySQL database crashed and I cannot figure out why. I am pasting a part of the logfile during the time of crash. Does anyone have a clue about what the problem is?
I could not start MySQL manually after the crash so I tried a few solutions I found on the web.

One solution was to restart my server (computer) - This worked
Another solution was to remove the ib_logfile0 and ib_logfile1 files and restart the MySQL daemon - This worked but after a while MySQL crashed again
One more thing I tried was to change the "innodb_log_buffer_size = 500K" to "innodb_log_buffer_size = 1M" - This didn't work

I am using MySQL 5.0.90 and CentOS 5.5.

--------------------------------------------------------------------

Number of processes running now: 0
110611 01:58:21 mysqld restarted
110611 1:58:23 [Warning] option 'innodb_additional_mem_pool_size': signed value 512000 adjusted to 524288
InnoDB: Log scan progressed past the checkpoint lsn 1 1276374882
110611 1:58:23 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 1 1276375632
110611 1:58:31 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
110611 1:58:32 InnoDB: Started; log sequence number 1 1276375632
110611 1:58:32 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.90' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

Number of processes running now: 0
110611 04:56:06 mysqld restarted
110611 4:56:07 [Warning] option 'innodb_additional_mem_pool_size': signed value 512000 adjusted to 524288
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110611 4:56:10 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...
110611 4:56:18 InnoDB: Started; log sequence number 1 1276663755
110611 4:56:19 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.90' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

Number of processes running now: 0
110611 05:00:17 mysqld restarted
110611 5:00:18 [Warning] option 'innodb_additional_mem_pool_size': signed value 512000 adjusted to 524288
InnoDB: Log scan progressed past the checkpoint lsn 1 1282927565
110611 5:00:19 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...

[*** MySQL crashed at this point ***]

110611 5:00:32InnoDB: Warning: difficult to find free blocks from
InnoDB: the buffer pool (31 search iterations)! Consider
InnoDB: increasing the buffer pool size.
InnoDB: It is also possible that in your Unix version
InnoDB: fsync is very slow, or completely frozen inside
InnoDB: the OS kernel. Then upgrading to a newer version
InnoDB: of your operating system may help. Look at the
InnoDB: number of fsyncs in diagnostic info below.
InnoDB: Pending flushes (fsync) log: 0; buffer pool: 0
InnoDB: 129 OS file reads, 0 OS file writes, 0 OS fsyncs
InnoDB: Starting InnoDB Monitor to print further
InnoDB: diagnostics to the standard output.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Crash
17919
June 15, 2011 02:31AM
6669
June 16, 2011 11:19PM
6371
June 17, 2011 12:33AM
5051
June 17, 2011 10:57PM
4834
June 17, 2011 11:31PM
4515
June 18, 2011 12:17AM
3804
June 18, 2011 01:09AM


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.