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

innodb_zip.restart fails in buildbot with wrong result

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.5
    • 10.5.7
    • Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-trusty-x86/builds/18469

      bb-10.5-release f35eeb791a130

      		 
      innodb_zip.restart '16k,crc32,innodb'    w1 [ fail ]
      		 
              Test ended at 2020-08-05 18:27:55
      		 
       
      		 
      CURRENT_TEST: innodb_zip.restart
      		 
      --- /usr/local/mariadb-10.5.5-linux-i686/mysql-test/suite/innodb_zip/r/restart.result	2020-08-05 17:15:41.000000000 +0000
      		 
      +++ /usr/local/mariadb-10.5.5-linux-i686/mysql-test/suite/innodb_zip/r/restart.reject	2020-08-05 18:27:55.049795974 +0000
      		 
      @@ -506,6 +506,7 @@
      		 
       t7_restart.frm
      		 
       t7_restart.par
      		 
       ---- MYSQL_TMP_DIR/alt_dir/test
      		 
      +#sql-ib30.ibd
      		 
       t5_restart.ibd
      		 
       t5_restart.ibd.bak
      		 
       t6_restart#p#p0.ibd
      		 
       
      		 
      mysqltest: Result length mismatch

      Attachments

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-16678 Use MDL for innodb background threads instead of dict_operation_lock

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            marko Marko Mäkelä made changes -
            Field Original Value New Value
            marko Marko Mäkelä added a comment -

            I think that these errors started to appear with MDEV-16678, due to a MDL conflict between purge and the InnoDB internal background DROP TABLE queue, which is needed at least until MDEV-21602 and MDEV-21175 have been addressed. I have been adjusting many tests for this failure, but I must have missed this one.

            marko Marko Mäkelä added a comment - I think that these errors started to appear with MDEV-16678 , due to a MDL conflict between purge and the InnoDB internal background DROP TABLE queue, which is needed at least until MDEV-21602 and MDEV-21175 have been addressed. I have been adjusting many tests for this failure, but I must have missed this one.
            marko Marko Mäkelä made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            marko Marko Mäkelä added a comment -

            Basically, all list_files commands that can return .ibd files should be replaced with a construct that allows filtering of the extra files:

            --list_files $MYSQLD_DATADIR/test
            		 
             
            		 
            --list_files $MYSQLTEST_VARDIR/mysql-test-data-dir/test

            must be replaced with the following:

            --let $regexp=/#sql-ib[0-9a-f]+\.ibd\n//
            		 
             
            		 
            --list_files_write_file $MYSQLD_DATADIR.files.txt $MYSQLD_DATADIR/test
            		 
            --replace_regex $regexp
            		 
            --cat_file $MYSQLD_DATADIR.files.txt
            		 
            --remove_file $MYSQLD_DATADIR.files.txt
            		 
             
            		 
            --list_files_write_file $MYSQLTEST_VARDIR/files.txt $MYSQLTEST_VARDIR/mysql-test-data-dir/test
            		 
            --replace_regex $regexp
            		 
            --cat_file $MYSQLTEST_VARDIR/files.txt
            		 
            --remove_file $MYSQLTEST_VARDIR/files.txt

            marko Marko Mäkelä added a comment - Basically, all list_files commands that can return .ibd files should be replaced with a construct that allows filtering of the extra files: --list_files $MYSQLD_DATADIR/test   --list_files $MYSQLTEST_VARDIR/mysql-test-data-dir/test must be replaced with the following: --let $regexp=/#sql-ib[0-9a-f]+\.ibd\n//   --list_files_write_file $MYSQLD_DATADIR.files.txt $MYSQLD_DATADIR/test --replace_regex $regexp --cat_file $MYSQLD_DATADIR.files.txt --remove_file $MYSQLD_DATADIR.files.txt   --list_files_write_file $MYSQLTEST_VARDIR/files.txt $MYSQLTEST_VARDIR/mysql-test-data-dir/test --replace_regex $regexp --cat_file $MYSQLTEST_VARDIR/files.txt --remove_file $MYSQLTEST_VARDIR/files.txt
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2020-08-10 14:10:47.0 2020-08-10 14:10:47.029
            marko Marko Mäkelä made changes -
            Fix Version/s 10.5.6 [ 24508 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.5.7 [ 25019 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.5.6 [ 24508 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 112104 ] MariaDB v4 [ 158214 ]

            People

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