Am 16.09.19 um 15:58 schrieb Sergei Golubchik:
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.
tried that years ago i even gone that far to find out which tables that originally was and copied the real ones to the expected temp-table filenames to silence that startup errors for some years with 10.1 or 10.2 i had to delete both files because MariaDB crashed at startup because they don't really matched what the global tablespace expected it's a shame that you simply can't get rid of garbage from the global tablespace