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 :-)
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
