InnoDB: No valid checkpoint found.

09-02-2012, 07:18 PM

Hello, i experience the following error, how to resolve this issue:

xtrabackup: Target instance is assumed as followings.xtrabackup: innodb_data_home_dir = ./xtrabackup: innodb_data_file_path = ibdata1:10M:autoextendxtrabackup: innodb_log_group_home_dir = ./xtrabackup: innodb_log_files_in_group = 2xtrabackup: innodb_log_file_size = 209715200xtrabackup: using O_DIRECTInnoDB: 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 managedInnoDB: to create the InnoDB data files, but log file creation failed.InnoDB: If that is the case, please refer toInnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.htmlinnobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 374.

Comment

I knew it was a problem with innodb, but i saw another forum here, with people with this very same problem. I also checked several possible solutions adviced on "dev.mysql.com". But none of them worked. HOWEVER today i gave it another shot, and now it is clear, that innodb engine had a serious problem. I restored a backup about 1 month ago, and strangely it screwed up everything, that's why innodb was NOT even running. So if people has this issue:
-check if innodb works or not
-check if innodb log files are corrupt or not (backup, and delete them, and restart mysql)
-if innodb log files or OK, then your innodb data files might be corrupt, but that is a complex issue, so google on it