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

mariabackup.innodb_redo_overwrite failed in buidbot with result length mismatch

Details

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/5071/steps/mtr_centos_mix/logs/stdio

       
      		 
      mariabackup.innodb_redo_overwrite 'innodb' w3 [ fail ]
      		 
              Test ended at 2020-10-23 14:01:18
      		 
       
      		 
      CURRENT_TEST: mariabackup.innodb_redo_overwrite
      		 
      --- /usr/share/mysql-test/suite/mariabackup/innodb_redo_overwrite.result	2020-10-23 09:25:11.000000000 +0000
      		 
      +++ /dev/shm/var/3/log/innodb_redo_overwrite.reject	2020-10-23 14:01:18.382601733 +0000
      		 
      @@ -22,7 +22,7 @@
      		 
       INSERT INTO t SELECT * FROM t;
      		 
       INSERT INTO t SELECT * FROM t;
      		 
       # xtrabackup backup
      		 
      -FOUND 1 /failed: redo log block is overwritten/ in backup.log
      		 
      +NOT FOUND /failed: redo log block is overwritten/ in backup.log
      		 
       FOUND 1 /failed: redo log block checksum does not match/ in backup.log
      		 
       FOUND 1 /failed: unknown reason/ in backup.log
      		 
       DROP TABLE t;
      		 
       
      		 
      mysqltest: Result length mismatch

      https://buildbot.askmonty.org/buildbot/builders/winx64-debug/builds/22147/steps/test/logs/stdio

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-14425 Change the InnoDB redo log format to reduce write amplification

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

          Activity

            Ascending order - Click to sort in descending order
            alice Alice Sherepa created issue -
            alice Alice Sherepa made changes -
            Field Original Value New Value
            Assignee Vladislav Lesin [ vlad.lesin ]
            alice Alice Sherepa made changes -
            Description http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/5071/steps/mtr_centos_mix/logs/stdio
            {noformat}

            mariabackup.innodb_redo_overwrite 'innodb' w3 [ fail ]
                    Test ended at 2020-10-23 14:01:18

            CURRENT_TEST: mariabackup.innodb_redo_overwrite
            --- /usr/share/mysql-test/suite/mariabackup/innodb_redo_overwrite.result 2020-10-23 09:25:11.000000000 +0000
            +++ /dev/shm/var/3/log/innodb_redo_overwrite.reject 2020-10-23 14:01:18.382601733 +0000
            @@ -22,7 +22,7 @@
             INSERT INTO t SELECT * FROM t;
             INSERT INTO t SELECT * FROM t;
             # xtrabackup backup
            -FOUND 1 /failed: redo log block is overwritten/ in backup.log
            +NOT FOUND /failed: redo log block is overwritten/ in backup.log
             FOUND 1 /failed: redo log block checksum does not match/ in backup.log
             FOUND 1 /failed: unknown reason/ in backup.log
             DROP TABLE t;

            mysqltest: Result length mismatch
            {noformat}
            		http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/5071/steps/mtr_centos_mix/logs/stdio
            {noformat}

            mariabackup.innodb_redo_overwrite 'innodb' w3 [ fail ]
                    Test ended at 2020-10-23 14:01:18

            CURRENT_TEST: mariabackup.innodb_redo_overwrite
            --- /usr/share/mysql-test/suite/mariabackup/innodb_redo_overwrite.result 2020-10-23 09:25:11.000000000 +0000
            +++ /dev/shm/var/3/log/innodb_redo_overwrite.reject 2020-10-23 14:01:18.382601733 +0000
            @@ -22,7 +22,7 @@
             INSERT INTO t SELECT * FROM t;
             INSERT INTO t SELECT * FROM t;
             # xtrabackup backup
            -FOUND 1 /failed: redo log block is overwritten/ in backup.log
            +NOT FOUND /failed: redo log block is overwritten/ in backup.log
             FOUND 1 /failed: redo log block checksum does not match/ in backup.log
             FOUND 1 /failed: unknown reason/ in backup.log
             DROP TABLE t;

            mysqltest: Result length mismatch
            {noformat}
            https://buildbot.askmonty.org/buildbot/builders/winx64-debug/builds/22147/steps/test/logs/stdio
            julien.fritsch Julien Fritsch made changes -
            Component/s mariabackup [ 14500 ]
            julien.fritsch Julien Fritsch made changes -
            Assignee Vladislav Lesin [ vlad.lesin ] Marko Mäkelä [ marko ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 114926 ] MariaDB v4 [ 142341 ]
            marko Marko Mäkelä added a comment -

            In MDEV-14425 (MariaDB Server 10.8), this part of the test was rewritten, because the redo log block format was changed.

            marko Marko Mäkelä added a comment - In MDEV-14425 (MariaDB Server 10.8), this part of the test was rewritten, because the redo log block format was changed.
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä added a comment -

            Does this fail with newer server versions? The cross-reference does not work currently, so I cannot check it right now.

            marko Marko Mäkelä added a comment - Does this fail with newer server versions? The cross-reference does not work currently, so I cannot check it right now.
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Alice Sherepa [ alice ]
            Status Open [ 1 ] Needs Feedback [ 10501 ]
            elenst Elena Stepanova added a comment -

            Cross-reference works now.
            It does fail on other versions, although it appears to be a rare failure.

            elenst Elena Stepanova added a comment - Cross-reference works now. It does fail on other versions, although it appears to be a rare failure.
            elenst Elena Stepanova made changes -
            Assignee Alice Sherepa [ alice ] Marko Mäkelä [ marko ]
            Status Needs Feedback [ 10501 ] Open [ 1 ]
            marko Marko Mäkelä added a comment -

            Right, this does still fail, but not in 10.8 or later in this fashion, as expected. Here is the latest 10.6 failure:

            10.6 72928e640e62559f4d4b82e9ff1102bb72bd5828

            		 
            mariabackup.innodb_redo_overwrite 'innodb' w5 [ fail ]
            		 
                    Test ended at 2023-08-01 12:48:54
            		 
             
            		 
            CURRENT_TEST: mariabackup.innodb_redo_overwrite
            		 
            --- /home/buildbot/ppc64le-ubuntu-2004-debug/build/mysql-test/suite/mariabackup/innodb_redo_overwrite.result	2023-08-01 12:23:46.000000000 +0000
            		 
            +++ /home/buildbot/ppc64le-ubuntu-2004-debug/build/mysql-test/suite/mariabackup/innodb_redo_overwrite.reject	2023-08-01 12:48:52.860307955 +0000
            		 
            @@ -22,6 +22,6 @@
            		 
             INSERT INTO t SELECT * FROM t;
            		 
             INSERT INTO t SELECT * FROM t;
            		 
             # xtrabackup backup
            		 
            -FOUND 1 /failed: redo log block is overwritten/ in backup.log
            		 
            +NOT FOUND /failed: redo log block is overwritten/ in backup.log
            		 
             FOUND 1 /failed: redo log block checksum does not match/ in backup.log
            		 
             DROP TABLE t;
            		 
             
            		 
            mysqltest: Result length mismatch

            Because of the extreme rarity, it may be impossible to fix this.

            marko Marko Mäkelä added a comment - Right, this does still fail, but not in 10.8 or later in this fashion, as expected. Here is the latest 10.6 failure: 10.6 72928e640e62559f4d4b82e9ff1102bb72bd5828 mariabackup.innodb_redo_overwrite 'innodb' w5 [ fail ] Test ended at 2023-08-01 12:48:54   CURRENT_TEST: mariabackup.innodb_redo_overwrite --- /home/buildbot/ppc64le-ubuntu-2004-debug/build/mysql-test/suite/mariabackup/innodb_redo_overwrite.result 2023-08-01 12:23:46.000000000 +0000 +++ /home/buildbot/ppc64le-ubuntu-2004-debug/build/mysql-test/suite/mariabackup/innodb_redo_overwrite.reject 2023-08-01 12:48:52.860307955 +0000 @@ -22,6 +22,6 @@ INSERT INTO t SELECT * FROM t; INSERT INTO t SELECT * FROM t; # xtrabackup backup -FOUND 1 /failed: redo log block is overwritten/ in backup.log +NOT FOUND /failed: redo log block is overwritten/ in backup.log FOUND 1 /failed: redo log block checksum does not match/ in backup.log DROP TABLE t;   mysqltest: Result length mismatch Because of the extreme rarity, it may be impossible to fix this.
            marko Marko Mäkelä made changes -
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.3 [ 22126 ]
            Affects Version/s 10.4 [ 22408 ]
            Affects Version/s 10.5 [ 23123 ]
            Affects Version/s 10.6 [ 24028 ]
            Affects Version/s 10.7 [ 24805 ]
            Labels not-10.8
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.4 [ 22408 ]

            People

              marko Marko Mäkelä
              alice Alice Sherepa
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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