Unable to recover MySQL 5.6 (InnoDB) database
1
vote
0
answers
303
views
I've tried multiple different suggestions from other questions on here, with no luck...
This is a MySQL database running version 5.6.41, using the InnoDB engine, and the instance is running out of a Docker image. (https://hub.docker.com/_/mysql?tab=tags&page=1&name=5.6.41) The image has my main database files (ibd and frm files) symlinked outside of the instance.
Here's the error:
InnoDB: Error: trying to access page number 0 in space 842,
InnoDB: space name /,
InnoDB: which is outside the tablespace bounds.
InnoDB: Byte offset 0, len 16384, i/o type 10.
InnoDB: If you get this error at mysqld startup, please check that
InnoDB: your my.cnf matches the ibdata files that you have in the
InnoDB: MySQL server.
2019-09-12 14:59:26 7f2fe639e700 InnoDB: Assertion failure in thread 139843702744832 in file fil0fil.cc line 5666`
I attempted to use the innodb_force_recovery
flag at all values (including 5-6). The error above happens when I use the mysql command line tool, and enter DROP TABLE .
. The main problem is I cannot access the database to even attempt any of these recovery options any more.
This likely started happening following a host (MacOS 10.13.6) system crash which caused an unexpected shutdown of my Docker container during file write.
I believe either my ibdata
or ib_logfiles
are corrupt, but I can't figure out how to recover the database without wiping everything clean and recovering from a mysqldump
(which may not even work).
I don't care about the data in this table, I can recover data from a development/testing MySQL server. I'd just like to not go through the hassle of starting everything from scratch.
Here are a few other stackex q's I've looked at: https://dba.stackexchange.com/questions/183200/mysql-cant-delete-table
https://dba.stackexchange.com/questions/183862/trying-to-solve-outside-tablespace-bounds-mysql-error-but-recovering-table-wi
Any suggestions?
(If you need more info, like my variable settings/my.cnf
files, or database structure info, please ask)
Asked by Kyle Permuy
(11 rep)
Sep 12, 2019, 03:24 PM
Last activity: Sep 12, 2019, 09:55 PM
Last activity: Sep 12, 2019, 09:55 PM