maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

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@xxxxxxxxxxx