MySQL Forums
Forum List  »  Newbie

Re: MySQL dieing with "Failing assertion: btr_page_get_next(get_block->frame, mtr) == page_get_page_no(page)"
Posted by: Shawn Green
Date: May 14, 2016 02:47PM

That is a message from the InnoDB storage engine telling you that on two of the leaf pages in the doubly-linked-list Btree structure that it uses to store your data, the "next" pointer of one page and the "back" pointer of the other page are not pointing at each other. This is potentially a sign your data has been modified (on disk) by some process outside of the control of mysqld or that your system died before both pages could be updated to point at each other (eg. the writes were interrupted or corrupted by a power failure)

You should restore from your most recent backup as soon as practical. Then apply any Binary Log content created since that backup to bring your data current.
http://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery.html

--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL dieing with "Failing assertion: btr_page_get_next(get_block->frame, mtr) == page_get_page_no(page)"
May 14, 2016 02:47PM


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.