old databases, after crash
Hi,
Recently our server went out of space and services started to fail. The hosting company deleted some local backups in order to free up some space but when we started looking at the sites the databases were ~2 old.
From my discussions INNODB was corrupted and unless there was an automatic restore to an older backup I am not sure what happened. Server admins said they did not do a restore.
Also want to say that some cache files on server had the correct information but the databases had old data(we use some file based caching for some resources so we don't query the databases)
Here is what I got from them.
160503 3:16:32 [Note] /usr/libexec/mysqld: Shutdown complete"
160503 03:16:32 mysqld_safe WSREP: Failed to recover position: "160503 3:16:30 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160503 03:16:29 mysqld_safe WSREP: Running position recovery with "log_error="/var/lib/mysql/wsrep_recovery.hcpSre" "pid-file="/var/lib/mysql/server.xxxx.com-recover.pid"
160503 03:16:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160503 3:16:24 [Note] /usr/libexec/mysqld: Shutdown complete"
160503 03:16:24 mysqld_safe WSREP: Failed to recover position: "160503 3:16:22 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160503 03:16:21 mysqld_safe WSREP: Running position recovery with "log_error="/var/lib/mysql/wsrep_recovery.lzqewX" "pid-file="/var/lib/mysql/server.xxxx.com-recover.pid"
160503 03:16:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160503 3:16:16 [Note] /usr/libexec/mysqld: Shutdown complete"
Can anyone help me figure out what happened?
Thank you
-
Hello, The output does suggest InnoDB corruption. We have a repair guide for InnoDB on the following thread: InnoDB Corruption Repair Guide Thank you. 0
Please sign in to leave a comment.
Comments
1 comment