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

The MySQL server is currently offline. admin bin Cpanel/cpmysql/DBCACHE: exit 11

# This error shows in all user control panels via the "MySQL Databases" icon...   The MySQL...

Error 500 - Internal Server Error - PHP

This can be due to several factors. The first thing to check is that the permissions on the file...

Running a PHP file with a cron job

To run a PHP file from cron, use the "cron jobs" section of your control panel. Use the following...

PHP information

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

Internal Server Error with PHPList

PHPList produces internal server error. Checking error logs results in: Invalid command...