maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

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