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

Clean - Shrink ibdata1

To shrink ibdata1 once and for all you must do the following: MySQLDump all databases into a...

phpMyAdmin - Error Incorrect format parameter

When importing a database with PHPMyAdmin I receive the error "Error Incorrect format parameter"....

Learn MySQL

If you do not know how to use MySQL there are some great guides at the following websites....

Warning: Unknown(): open_basedir restriction in effect

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

PHP information

To view your current version of PHP you will create a php file, for example info.php, and place...