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