Unable to start mysql: Cannot open tablespace table_name which uses space ID

Created:

2017-04-11 15:53:43 UTC

Modified:

2017-08-08 13:28:03 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to start mysql: Cannot open tablespace table_name which uses space ID

Symptoms

Unable to start Mysql56, following error can be found in mysql log(C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\data\computer_name):

2017-04-11 16:31:25 3832 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace some_table uses space ID: 232 at filepath: some_table.ibd. 
InnoDB: Error: could not open single-table tablespace file some_table.ibd.

Resolution

  1.  Add "innodb_force_recovery = 1" to C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\my.ini file.
  2. Start mysql56.
  3. Remove "innodb_force_recovery = 1" from C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\my.ini
  4. Restart mysql56.
Have more questions? Submit a request
Please sign in to leave a comment.