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 security@mariadb.org