InnoDB: Error: Attempted to open a previously opened tablespace. Previous tablespace

When receiving the error

    "InnoDB: Error: Attempted to open a previously opened tablespace. Previous tablespace"

when running a systemctl status mariadb.service it can often indicate a failed tablespace file. 

Performing the following may rectify the issue:

  1. Open my.cnf
  2. Look for [mysqld]
  3. Just below [mysqld] insert innodb_force_recovery = 1
  4. Start MySQL Service
  5. Stop MySQL Service
  6. Remove the line from my.cnf (or my.ini for Windows) (innodb_force_recovery = 1)
  7. Start MySQL Service
  8. Run a "tail -f /var/log/mysql/`servername`.log" and watch for further errors. If the tablespace issue reoccurs backup the database, remove the database, remove the files associated it @ /var/log/mysql/username_database* and reimporting it will often correct the .id file(s)
  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

What is the Path to ImageMagick?

The path to ImageMagick is /usr/bin/

Increase PHP Memory

Fatal error: Allowed memory size of xxxxxxxxx bytes exhausted (tried to allocate 1064256 bytes)....

What is the proper MariaDB - MySQL import and export format?

The easiest way to import and export a database is via the backup section of our hosting control...

Warning: Unknown(): open_basedir restriction in effect.

Basedir restriction is set for security. This most often occurs when you are calling an app...

When trying to connect to MariaDB or MySQL you receive error 2003 Cannot connect to MySQL on x.x.x.x on port 3306 (10060)

Please ensure you have added the remote IP to the allow list in your hosting control panel...