UnixServerAdmin

Server Administration & Management

InnoDB: No valid checkpoint found

You may find this error while restarting the mysql service on the server. Error is as follows:-

# /etc/init.d/mysql restart
Shutting down MySQL…                           [  OK  ]
Starting MySQL.                                         [  OK  ]

# tail -f /var/log/mysqld.log
100825 08:25:02  mysqld started
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.

To fix this goahead with the steps given below;-

# cd /var/lib/mysql/

# rm -rvf  ib_logfile0

# rm -rvf  ib_logfile1

# rm -rvf  ibdata1

# /etc/init.d/mysql restart
Shutting down MySQL…..                         [  OK  ]
Starting MySQL……                                 [  OK  ]

Check the InnoDB engine status now. It should be enabled now.

mysql> show engines;
+————+———+—————————————————————-+
| Engine     | Support | Comment                                                        |
+————+———+—————————————————————-+
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      |
| InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys     |
| BerkeleyDB | NO      | Supports transactions and page-level locking                   |
| BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it disappears) |
| EXAMPLE    | YES     | Example storage engine                                         |
| ARCHIVE    | YES     | Archive storage engine                                         |
| CSV        | YES     | CSV storage engine                                             |
| ndbcluster | NO      | Clustered, fault-tolerant, memory-based tables                 |
| FEDERATED  | YES     | Federated MySQL storage engine                                 |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                          |
| ISAM       | NO      | Obsolete storage engine                                        |
+————+———+—————————————————————-+

Advertisements

August 26, 2011 - Posted by | MySQL |

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: