mysqldump: Got error: 1146: Table 'wikidb.archive' doesn't exist when using LOCK TABLES

Anyone ever seen this sort of error from MySQL?

We got a whole stack of them from our automated backup process over Easter, eventually bringing the whole box down. A little concerning, though it doesn’t seem to have reoccurred so far.

[Update - Looks like it was being caused by a script which was supposed to sync the database to a live backup server. Due to a mis-reconfiguration, it ended up boiling down to mysqldump -uYYY -pXXX wikidb | mysql -uYYY -pXXX wikidb; which would probably be expected to cause locking problems.]

Technorati Tags: , , , ,