Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6160

InnoDB: Failing assertion: page_is_comp(next_page) == page_is_comp(page)

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 5.5.36
    • 5.5.39
    • None
    • None

    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

      Attachments

        Issue Links

          Activity

            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.

            jplindst Jan Lindström (Inactive) added a comment - 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.

            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.

            jplindst Jan Lindström (Inactive) added a comment - 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.
            elenst Elena Stepanova added a comment - - edited

            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

            elenst Elena Stepanova added a comment - - edited 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

            People

              jplindst Jan Lindström (Inactive)
              jplindst Jan Lindström (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.