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

InnoDB: Rollback of trx with id 0 completed

Details

    Description

      This bug came up in the MDEV-15132 testing. When InnoDB has completed the rollback of a recovered transaction, it used to display the transaction identifier. Starting with the change bug#16845421 INNODB: CRASH WHILE RECOVERING A TRANSACTION in MySQL 5.7.2 (and the merge of MySQL 5.7.9 to MariaDB 10.2.2) it would always display 0 instead:

      2018-01-31  9:01:32 0 [Note] InnoDB: Rollback of trx with id 0 completed

      The reason is that the trx->id would be reset at transaction commit.

      Attachments

        Issue Links

          relates to

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

          • Major - Major loss of function.
          • Closed

          Activity

            marko Marko Mäkelä added a comment -

            While fixing this, I changed the message format:

            2018-01-31 12:00:14 140691686427776 [Note] InnoDB: Trx id counter is 2304
            		 
            2018-01-31 12:00:14 140691446613760 [Note] InnoDB: Starting in background the rollback of recovered transactions
            		 
            …
            		 
            2018-01-31 12:00:14 140691446613760 [Note] InnoDB: Rolled back recovered transaction 1286

            Yes, we do output transaction identifiers in hexadecimal in some places, but not in the related Trx id counter message above.

            marko Marko Mäkelä added a comment - While fixing this, I changed the message format: 2018-01-31 12:00:14 140691686427776 [Note] InnoDB: Trx id counter is 2304 2018-01-31 12:00:14 140691446613760 [Note] InnoDB: Starting in background the rollback of recovered transactions … 2018-01-31 12:00:14 140691446613760 [Note] InnoDB: Rolled back recovered transaction 1286 Yes, we do output transaction identifiers in hexadecimal in some places, but not in the related Trx id counter message above.

            People

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