every time MySQL is restarted, MySQL log shows errors of some temporary tables. I don’t know if is a big issue.
Extract of mysqld.log
090616 11:26:02 InnoDB: Error: trying to open a table, but could notInnoDB: open the tablespace file ‘./tmp/#sql2f89_6ee13_0.ibd’!InnoDB: Have you moved InnoDB .ibd files around without using theInnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE?InnoDB: It is also possible that this is a temporary table #sql…,InnoDB: and MySQL removed the .ibd file for this.
I have the same error for another two files:
It’s clear that is related with temporary tables of InnoDB. It’s a bit annoying because every time I restart BD, the log is filled with same errors again.
I ran mysqlcheck to test all tables of all databases and it seems to be ok. But the error is in log yet.