Comments - InnoDB Data Dictionary Troubleshooting
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
How would one go about cleaning up improperly removed partitioned tables?
I have a server where i have multiple partitions being referenced in the InnoDB Data Dictionary, but the table itself has been removed some time in the past, both from mariadb and from disk. This doesnt create any issues except for error messages at startup.
2025-03-26 11:05:07 0 [ERROR] InnoDB: Cannot open datafile for read-only: './foo/bar#P#p20.ibd' OS error: 71 2025-03-26 11:05:07 0 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2025-03-26 11:05:07 0 [ERROR] InnoDB: Error number 2 means 'No such file or directory' 2025-03-26 11:05:07 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/