maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

Am 09.12.22 um 09:00 schrieb Marko Mäkelä:
> Regarding the dbmail/#sql2-704-271.ibd in your other message, in MariaDB 
> 10.5 or later you should be able to drop the table even if a .frm file 
> does not exist, with
> DROP TABLE dbmail.`#mysql50##sql2-704-271`;

currently on 10.3 because i don't agree the json nosense in the system 
table.....

> If you are using an older version, you could try to copy the .frm file 
> of another InnoDB table to that name

i did that 13 years ago to get rid of that error message, a few years 
ago 10.1 or 10.2 decided to crash at startup with that non-mathcing file

> and then remove the file.

i think you mean "remove the table" - no, "table don't" exist but on the 
other hand i wasn't able to guess `#mysql50##sql2-704-271` as name and 
"show tables" don't list anything

hence when you don#t list it in "show tables" just remove it from global 
tablespace or get rid of that useless global tablewspace at all in 
"files-per-table" mode

> DDL operations should be crash-safe and most of them are atomic starting 
> with MariaDB 10.6.

13 years too late :-)