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

Could not connect to the MariaDB - MySQL database

You will want to verify you are using the correct database name, username and password.All...

Changing Maximum Upload Size

Firts check your control panel for the "PHP Options" icon. If available you can change the PHP...

Disable MySQL strict mode on cPanel server

To disable mysql strict mode on a cPanel server, add the following to the end of the /etc/my.cnf...

phpMyAdmin - Error Incorrect format parameter

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

Warning: system() has been disabled for security reasons

system is a feature of php which is disabled by default. To change this if needed for a...