Bug #42324 ERROR 1100 (HY000) at line 342: Table 'time_zone_name' was not locked with LOCK

• Submitted: 25 Jan 0:34
• Modified: 25 Feb 18:04
• Reporter: Bassam Binatta
• Status: No Feedback
• Category: Server: Backup
• Severity: S3 (Non-critical)
• Version: 5.0.67-community
• OS: Linux (CENTOS)
• Tags: Table 'time_zone_name' was not locked with LOCK

[25 Jan 0: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 16:25] Valeriy Kravchuk

Thank you for the problem report. What old bugs are you talkig about? Give bug numbers,
please.

[25 Jan 17:11] Bassam Binatta

check this:
http://bugs.mysql.com/bug.php?id=21208

[25 Jan 18: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 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".