Bug #42324 ERROR 1100 (HY000) at line 342: Table 'time_zone_name' was not locked with LOCK
Submitted: 24 Jan 2009 23:34 Modified: 25 Feb 2009 17:04
Reporter: Bassam Binatta Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version:5.0.67-community OS:Linux (CENTOS)
Assigned to: CPU Architecture:Any
Tags: Table 'time_zone_name' was not locked with LOCK

[24 Jan 2009 23:34] Bassam Binatta

I have trying today to restore a backup from server to server and I have shocked when I saw this error after restoring such DB:
ERROR 1100 (HY000) at line 342: Table 'time_zone_name' was not locked with LOCK

This database has more than 150 tables inside it and the tables that restored was 9 because of this error and I do not know how can I solve it.

Nice regards,
Bassam A.

How to repeat:
I have reviewed some old bugs and I saw similar issue to this and you was comment a patch for this issue. In this issue with the current version, I do not know if there is a patch or you do not know if there is such bug like this in this version.
[25 Jan 2009 15:25] Valeriy Kravchuk
Thank you for the problem report. What old bugs are you talkig about? Give bug numbers, please.
[25 Jan 2009 16:11] Bassam Binatta
check this:
[25 Jan 2009 17:04] Valeriy Kravchuk
I think that bug (reported by me and closed long time ago) has nothing to do with your problem. Can you send a problematic dump to check?
[26 Feb 2009 0: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".