MySQL Forums
Forum List  »  InnoDB

Whether to kill "InnoDB: Starting shutdown"
Posted by: Stephen Martyak
Date: July 10, 2008 07:22AM

I had been loading multiple dump files when one of the files seemed to be hung so I killed the load process and the transaction began a rollback of the Innodb table load. I proceeded to load the other dump files while the rollback continued. I ended up killing the mysqd process and brought the server up under innodb_force_recovery = 3 in order to stop the rollback. Then, I deleted the table that had been marked rolling back. I went to bounce the server to remove the innodb_force_recovery = 3 from the my.cnf when I got into the state I am currently in: “InnoDB: Starting Shutdown”.

Is it sage to kill the mysqld process and let MySQL recover upon booting or should I wait for this InnoDB shutdown to complete. It's already been running in this state for 14+ hours.

running 4.1.4, innodb file per table

Options: ReplyQuote


Subject
Views
Written By
Posted
Whether to kill "InnoDB: Starting shutdown"
3235
July 10, 2008 07:22AM


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.