← Back to team overview

maria-discuss team mailing list archive

Re: Maria-db refuses to start


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 :-)