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

Async rollback prepared transactions during binlog crash recovery

Details

    Description

      When doing server recovery, the active transactions will be rolled
      back by InnoDB background rollback thread automatically. The
      prepared transactions will be committed or rolled back accordingly
      by binlog recovery. Binlog recovery is done in main thread before
      the server can provide service to users. If there is a big
      transaction to rollback, the server will not available for a long
      time.

      It is better to make the prepared transactions to be rolled back by the background rollback thread.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35265 wsrep.wsrep-recover, wsrep.wsrep-recover-v25 fail on assertion !wsrep_is_wsrep_xid(&trx->xid)

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34909 DDL during SET GLOBAL innodb_log_file_size may hang when using PMEM

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            libing Libing Song created issue -
            Elkin Andrei Elkin made changes -
            Field Original Value New Value
            Assignee Andrei Elkin [ elkin ]
            Elkin Andrei Elkin made changes -
            Fix Version/s 11.6 [ 29515 ]
            Elkin Andrei Elkin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            Elkin Andrei Elkin made changes -
            Status In Progress [ 3 ] In Review [ 10002 ]
            Elkin Andrei Elkin made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            Elkin Andrei Elkin made changes -
            Assignee Andrei Elkin [ elkin ] Daniel Black [ danblack ]
            Elkin Andrei Elkin made changes -
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 11.6 [ 29515 ]
            Elkin Andrei Elkin made changes -
            Issue Type New Feature [ 2 ] Bug [ 1 ]
            Elkin Andrei Elkin made changes -
            Component/s Server [ 13907 ]
            Elkin Andrei Elkin made changes -
            Component/s Storage Engine - InnoDB [ 10129 ]
            Elkin Andrei Elkin made changes -
            Assignee Daniel Black [ danblack ] Andrei Elkin [ elkin ]
            knielsen Kristian Nielsen made changes -
            Fix Version/s 11.6 [ 29515 ]
            Fix Version/s 10.6 [ 24028 ]
            marko Marko Mäkelä made changes -
            Assignee Andrei Elkin [ elkin ] Marko Mäkelä [ marko ]
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Kristian Nielsen [ knielsen ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            knielsen Kristian Nielsen made changes -
            Status In Review [ 10002 ] In Testing [ 10301 ]
            knielsen Kristian Nielsen made changes -
            Assignee Kristian Nielsen [ knielsen ]
            marko Marko Mäkelä made changes -
            Assignee Matthias Leich [ mleich ]
            mleich Matthias Leich made changes -
            Assignee Matthias Leich [ mleich ] Marko Mäkelä [ marko ]
            mleich Matthias Leich made changes -
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            marko Marko Mäkelä made changes -
            Status Stalled [ 10000 ] In Testing [ 10301 ]
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Matthias Leich [ mleich ]
            Roel Roel Van de Paar made changes -
            Roel Roel Van de Paar made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 11.7 [ 29815 ]
            Fix Version/s 11.6 [ 29515 ]
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            axel Axel Schwenke made changes -
            Attachment MDEV-33853.pdf [ 74004 ]
            axel Axel Schwenke made changes -
            Attachment MDEV-33853C.pdf [ 74007 ]
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2024-09-05 18:20:32.0 2024-09-05 18:20:31.66
            marko Marko Mäkelä made changes -
            Fix Version/s 11.7.0 [ 29912 ]
            Fix Version/s 11.7 [ 29815 ]
            Assignee Matthias Leich [ mleich ] Marko Mäkelä [ marko ]
            Resolution Fixed [ 1 ]
            Status In Testing [ 10301 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Issue Type Bug [ 1 ] New Feature [ 2 ]
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -

            People

              marko Marko Mäkelä
              libing Libing Song
              Votes:
              0 Vote for this issue
              Watchers:
              12 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.