Re: mysqldump crash after VS update
Posted by:
Tim Rath
Date: August 06, 2018 02:55PM
OK, got something from the log:
2018-07-30 13:31:12 1620 InnoDB: Error: space id and page n:o stored in the page
InnoDB: read in are 1869967971:657205070, should be 140:300079!
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 300079.
InnoDB: You may have to recover from a backup.
2018-07-30 13:31:12 1620 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex (hex info here)
InnoDB: End of page dump
A bit more context: The user successfully got a dump of his db on Friday, July 27 but deleted it because it didn't have new entries since the previous one. We believe new entries were written over the weekend, but he got the error above during a dump on Monday, July 30 (and all subsequent attempts). I restored a snapshot of the vm that was taken on the night of July 29 to see if we could retrieve anything from it, but we got the same error on the same table. So, whatever the problem was happened over the weekend. The error log did not have any entries between the last successful dump and the error above (ie, no error at whatever time the corruption happened).
Thanks.
Subject
Views
Written By
Posted
1896
August 02, 2018 01:36PM
540
August 02, 2018 02:14PM
583
August 03, 2018 09:00AM
629
August 03, 2018 11:19AM
510
August 03, 2018 01:17PM
563
August 03, 2018 02:23PM
563
August 06, 2018 09:16PM
Re: mysqldump crash after VS update
655
August 06, 2018 02:55PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.