[ERROR] InnoDB: Failed to find tablespace for table...
hi,
We have a bacula server that uses mysql as its database.
Today we found that mysql was not starting. I tried a few fixes, but to no success.
[ERROR] InnoDB: Failed to find tablespace for table `mysql`.`server_cost` in the cache. Attempting to load the tablespace with space id 19
Mar 7 16:43:42 bacula mysqld[2813]: 2023-03-07T19:43:42.655755Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`engine_cost` in the cache. Attempting to load the tablespace with space id 20
Mar 7 16:43:42 bacula mysqld[2813]: 2023-03-07T19:43:42.656794Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_leap_second` in the cache. Attempting to load the tablespace with space id 12
Mar 7 16:43:42 bacula mysqld[2813]: 2023-03-07T19:43:42.656981Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_name` in the cache. Attempting to load the tablespace with space id 8
Mar 7 16:43:42 bacula mysqld[2813]: 2023-03-07T19:43:42.657169Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone` in the cache. Attempting to load the tablespace with space id 9
Mar 7 16:43:42 bacula mysqld[2813]: 2023-03-07T19:43:42.657373Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_transition_type` in the cache. Attempting to load the tablespace with space id 11
Mar 7 16:43:42 bacula mysqld[2813]: 2023-03-07T19:43:42.657548Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_transition` in the cache. Attempting to load the tablespace with space id 10
Mar 7 16:43:42 bacula mysqld[2813]: 2023-03-07T19:43:42.658366Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`servers` in the cache. Attempting to load the tablespace with space id 3
I tried innodb_force_recovery = 1, but it only started with 6.
What are the other alternatives?
Subject
Views
Written By
Posted
[ERROR] InnoDB: Failed to find tablespace for table...
855
March 07, 2023 02:00PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.