Solved

MySQL: Attempted to open a previously opened tablespace

Posted on 2013-11-19
3
3,837 Views
Last Modified: 2013-11-21
Hi Experts,

I'm having issues starting the MySql service under XAMPP 1.8.3:

MySql log error:

2013-11-19 09:10:54 5224 InnoDB: Attempted to open a previously opened tablespace. Previous tablespace db_binder_htl/tbladdress uses space ID: 1 at filepath: .\db_binder_htl\tbladdress.ibd. Cannot open tablespace mysql/innodb_table_stats which uses space ID: 1 at filepath: .\mysql\innodb_table_stats.ibd
InnoDB: Error: could not open single-table tablespace file .\mysql\innodb_table_stats.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.

I had this issue before and solved it by moving the files within xampp\mysql\data folder and letting MySQL rebuild them, but now it is back.

I need a permanent solution. Any suggestions?

Thanks
0
Comment
Question by:rmartes
3 Comments
 
LVL 77

Expert Comment

by:arnold
ID: 39661587
Did your system crash, or cold powered off (loss of power)?

What your storage is like

Depending on what led to this issue and whether you are ok with a possible data loss, adding an innodb_force_recovery=1 in /etc/my.cnf will let mysql do its thing and start working (with possible data loss)

Storage type/configuration might be what under certain circumstances is susceptible to this issue.
Filesystem type.
0
 
LVL 1

Accepted Solution

by:
DNK_Helpdesk earned 500 total points
ID: 39662200
I had the same problem and after downgrading from XAMPP 1.8.3 to XAMPP 1.8.2 everything works as normal.
0
 

Author Closing Comment

by:rmartes
ID: 39666031
I reverted to xampp 1.8.2. This is not the only issue I had with xampp 1.8.3. Even though it is a test environment, I need it working at all times and don't have the time to spend hours troubleshooting.

Thank you so much.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Does PHPMyAdmin pose a security risk? 2 88
SQL Update Query 23 93
Insert with SET how to handle join 6 56
MySQL left join performance 4 30
Creating and Managing Databases with phpMyAdmin in cPanel.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now