MySQL Forums
Forum List  »  InnoDB

[ERROR] InnoDB: Failed to find tablespace for table...
Posted by: Elias Pereira billy
Date: March 07, 2023 02:00PM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
[ERROR] InnoDB: Failed to find tablespace for table...
409
March 07, 2023 02:00PM


Sorry, only registered users may post in this forum.

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.