[MDEV-6160] InnoDB: Failing assertion: page_is_comp(next_page) == page_is_comp(page) Created: 2014-04-24  Updated: 2022-01-05  Resolved: 2014-07-22

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.36
Fix Version/s: 5.5.39

Type: Bug Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Cannot Reproduce Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-17924 Failing assertion: page_is_comp(next_... Open
relates to MDEV-27423 INSERT IGNORE ... SELECT 쿼리 사용 중 got ... Closed

 Description   

On the both reported issues they have mysql crash on select on partitioned tables with error :
InnoDB: Failing assertion: page_is_comp(next_page) == page_is_comp(page)
Something else, they both use Fusion IO drives.

This issues seems to be reported several times here:
https://bugs.launchpad.net/percona-server/+bug/939248
https://bugs.launchpad.net/percona-server/+bug/1255027/comments/3
http://bugs.mysql.com/bug.php?id=61972
http://bugs.mysql.com/bug.php?id=62634

 Comments   
Comment by Jan Lindström (Inactive) [ 2014-04-24 ]

First step is to add some additional information about the both next_page and page to output.

  • What format they are (if they are not COMPACT)
  • space_id, file_name, check checksums
  • Index name, index travelsal mode, locks we have

All this should be done if and only if we would hit above assertion.

Comment by Jan Lindström (Inactive) [ 2014-04-28 ]

revno: 4168
committer: Jan Lindström <jplindst@mariadb.org>
branch nick: 5.5
timestamp: Mon 2014-04-28 08:30:05 +0300
message:
MDEV-6160: InnoDB: Failing assertion: page_is_comp(next_page) == page_is_comp(page)

This is not yet a fix. This is change to print additional information at the point
when this assertion is going to happen. Print as much information about the pages
and index to find out why next page is not a compact format.

Comment by Elena Stepanova [ 2014-12-08 ]

It was reported a couple more times, and now Oracle confirms it as reproducible:
http://bugs.mysql.com/bug.php?id=74596
http://bugs.mysql.com/bug.php?id=75124

Generated at Thu Feb 08 07:09:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.