A power outage took down a server hard. Unfortunately, trying to restore backup's to 7.x servers are not working for some reason. They restore but not really.
Log files indicated the following: 160906 3:25:56 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 2 of name './thecorkandtap/wp_formmaker_backup.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 2 of name './bigbear2/omeka_csv_import_imported_items.ibd' already exists in the tablespace
InnoDB: memory cache!InnoDB: Error: trying to add tablespace 32250 of name to the tablespace memory cache, but tablespace
We have about 60+ websites on the machine. Ouch. "innodb_force_recovery=" 1 to 3 have not worked Not sure where to go from here.
Comments
Submitted by andreychek on Tue, 09/06/2016 - 09:16 Comment #1
Howdy -- I'm looking into ways to handle that.
As a way to get the service back online, you could always try moving the /var/lib/mysql/thecorkandtap directory elsewhere, and then restarting MySQL.
That might just get it online, minus the one database.
At that point, if you have a backup, you could always try restoring a backup of that particular site.
Submitted by securewebs on Tue, 09/06/2016 - 16:13 Pro Licensee Comment #2
Good grief. I looked in all the wrong places. It was a shortage of space in the var/cache/ directory. I deleted a few log files and everything was back to normal. I should have learned the first time that happened to me. Thanks for the advice as always.
Submitted by andreychek on Tue, 09/06/2016 - 17:12 Comment #3
Oh nuts! Yeah I didn't consider that either. Glad to hear it's working now!