I have a cronjob set to take hourly snapshots of our database. About once a week maybe I get an error during the mysqldump that looks like this.
Error: Couldn’t read status information for table foo_table ()
mysqldump: Couldn’t execute 'show create table
foo_table': Table ‘foo_dbname.foo_table’ doesn’t exist (1146)
It’s an innodb database, and I am using the --single-transaction flag which I thought locked the db at the state it is in when the command gets executed.
The error looks similar to this http://bugs.mysql.com/bug.php?id=65670 however there is no mysql server vs. client mismatch.
Any ideas what might be going on?