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

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Cannot Reproduce
        • Affects Version/s: 5.5.36
        • Fix Version/s: 5.5.39
        • Component/s: None
        • Labels:
          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

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                jplindst Jan Lindström 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.

                Show
                jplindst Jan Lindström 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.
                Hide
                Permalink
                jplindst Jan Lindström 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.

                Show
                jplindst Jan Lindström 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.
                Hide
                Permalink
                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

                Show
                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

                  • Assignee:
                    jplindst Jan Lindström
                    Reporter:
                    jplindst Jan Lindström
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Time Tracking

                      Estimated:
                      Original Estimate - Not Specified
                      Not Specified
                      Remaining:
                      Remaining Estimate - 0 minutes
                      0m
                      Logged:
                      Time Spent - 1 day
                      1d