mysqldump trying to lock lock table before starting a database dump but not able to lock and throwing this error.
After analyzing table names carefully i found few tables duplicate table exist with names in Uppercase and lowercase when lower_case_table_names=1
mysql> show tables;
+-----------------------------------+
| Tables_in_power |
+-----------------------------------+
| Message_seq |
| User_seq |
| message_seq |
| user_seq |
+-----------------------------------+
Resolved by removing duplicate table message_seq and user_seq.
This issue of duplicate tables occurs when application issue a CREATE TABLE command with table name in upper case or lower case other than the existing tables with same name and lower_case_table_names=1.
For permanent resolution change lower_case_table_names=0 if application don't have any dependency on it.
No comments:
Post a Comment