Hi, Reindl! On Sep 14, Reindl Harald wrote: > Am 14.09.19 um 14:05 schrieb Sergei Golubchik: > > Hi, Reindl! > > > > 1. Do you actually have <datadir>/dbmail/*271* files ? > > no as you can see "Cannot open datafile for read-only: > './dbmail/#sql2-704-271.ibd'", i deleted the temp files 10 years ago > after one week of not used obviously from anything and didn't imagine > the weird behavior of innodb
Okay. It looks like the only way to get rid of this warning would be to drop this table manually. Like, `create table t1 ... engine=innodb` then copy t1.idb and t1.frm to #sql2-704-271.* and then drop t1 and `#mysql50#sql2-704-271` tables. InnoDB doesn't do it automatically, because #sql2* tables might actually contain important user data in some rare cases. Regards, Sergei VP of MariaDB Server Engineering and secur...@mariadb.org _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
