MySQL Forums
Forum List  »  Data Recovery

Re: Importing MYSQL DB Lock?
Posted by: Joyce Taylor
Date: August 08, 2014 05:09AM

Being the SA referenced in this question I wanted to point out a few things:

Before dropping the DB the ibdata files were deleted( we use table per idb ) for that DB
The database was then dropped and recreated
Upon import the first table is ad and it seems to already be locked.
To me this would mean that there is still lock information stored in the InnoDB metadata which is held in the shared ibdata file. Last time I had problems with the InnoDB metadata being out of sync with the individual table ibdata files I blew away everything and re imported. When I tried to restart on that occasion MySQL refused as it couldn't find table ibd files which had been removed, but were still in the metadata.

The persistent problem here is removing the ibd files via command line rather than doing a drop database. pebkac.

writing section

Options: ReplyQuote

Written By
July 07, 2014 12:32PM
July 07, 2014 12:34PM
Re: Importing MYSQL DB Lock?
August 08, 2014 05:09AM
August 30, 2014 05:33AM
September 19, 2014 01:06AM

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.