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
• Status: No Feedback
• Category: MySQL Server: Backup
• Severity: S3 (Non-critical)
• Version: 5.0.67-community
• OS: Linux (CENTOS)
• CPU Architecture: Any
• Tags: Table 'time_zone_name' was not locked with LOCK

[24 Jan 2009 23:34] Bassam Binatta

Description:
Hello,

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:
http://bugs.mysql.com/bug.php?id=21208

[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".