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

upgrade from MariaDB 10.2 to 10.5.13 results in [ERROR] InnoDB: corrupted TRX_NO

Details

    Description

      upgrade from Mariadb 10.5.10 to 10.5.13 results in [ERROR] InnoDB: corrupted TRX_NO

      innodb_change_buffering=none

      does not help to resolve corruption in undo. It does not happen all the times, but sporadically. But it's reproducible on the customer sites.
      Not sure whether directly related but there is a reference to same error due os bug https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=257728

      Attachments

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-15132 Avoid accessing the TRX_SYS page

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15912 InnoDB: Failing assertion: purge_sys.tail.commit <= purge_sys.rseg->last_commit upon upgrade from 10.0 or 10.1 to 10.3

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29111 locking occurring when upgrading to 10.5 from 10.1

          • Major - Major loss of function.
          • Closed
          mentioned in

          Page Loading...

          Page Loading...

          Activity

            Ascending order - Click to sort in descending order
            YK Yakov Kushnirsky created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Fix Version/s 10.5 [ 23123 ]
            Assignee Marko Mäkelä [ marko ]
            YK Yakov Kushnirsky made changes -
            Attachment CS0373333-att1.txt [ 62219 ]
            marko Marko Mäkelä made changes -
            Status Open [ 1 ] Needs Feedback [ 10501 ]
            YK Yakov Kushnirsky made changes -
            Comment [ A comment with security level 'Developers' was removed. ]
            YK Yakov Kushnirsky made changes -
            Status Needs Feedback [ 10501 ] Open [ 1 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2022-02-28 10:47:10.0 2022-02-28 10:47:10.41
            marko Marko Mäkelä made changes -
            Fix Version/s 10.3.35 [ 27512 ]
            Fix Version/s 10.4.25 [ 27510 ]
            Fix Version/s 10.5.16 [ 27508 ]
            Fix Version/s 10.6.8 [ 27506 ]
            Fix Version/s 10.7.4 [ 27504 ]
            Fix Version/s 10.8.3 [ 27502 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            Summary upgrade from MariaDB10.5.10 to 10.5.13 results in [ERROR] InnoDB: corrupted TRX_NO upgrade from MariaDB 10.2 to 10.5.13 results in [ERROR] InnoDB: corrupted TRX_NO
            marko Marko Mäkelä made changes -
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 200817 150524

            People

              marko Marko Mäkelä
              YK Yakov Kushnirsky
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.