Bug #73071 mysql is going on maintenance state while restoring backup

• Submitted: 21 Jun 2014 10:45
• Modified: 25 Aug 2014 19:48
• Reporter: rahul mishra
• Status: No Feedback
• Category: MySQL Server: Installing
• Severity: S2 (Serious)
• Version: 5.5.37
• OS: Solaris
• CPU Architecture: Any
• Tags: ib_logfile0, ib_logfile1, mysql restore

[21 Jun 2014 10:45] rahul mishra

Description:
Previously we were using mysql-5.5.20 in our project.
Now we are upgrading mysql-5.5.20 to 5.5.37 .
I took backup from mysql-5.5.20 and trying to restore it.
Sometimes mysql is going on maintenance state.
It is saying ib_logfile0 , ib_logfile1 is corrupted.
If I move these files and restart the mysql then is working.

How to repeat:
install mysql -5.5.20 
create some tables and insert some data.
take the backup of the data.
then uninstall mysql and install 5.5.37 and restore the backup.
Sometimes files are getting corrupted.
Its tough to reproduce the problem.

[25 Jul 2014 19:48] Sveta Smirnova

Thank you for the report.

Which tool did you use when took backup? How did you restore it?

[26 Aug 2014 1:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".