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

Sporadic failure in innodb.innodb_corrupt_bit on P8

Details

    Description

      The problem MDEV-7139 is happening again, observed 4 times over the last 2 months on p8-rhel71-bintar-debug and p8-rhel7-bintar-debug, 5.5 and 10.0.
      Latest occasion: http://buildbot.askmonty.org/buildbot/builders/p8-rhel71-bintar-debug/builds/699/steps/test/logs/stdio

      innodb.innodb_corrupt_bit 'xtradb'       w2 [ fail ]
              Test ended at 2016-01-15 04:07:57
       
      CURRENT_TEST: innodb.innodb_corrupt_bit
      mysqltest: At line 79: query 'INSERT INTO corrupt_bit_test_ā VALUES(13000,'x',1,1)' failed: 1062: Duplicate entry '1-x' for key 'idxā'
       
      The result from queries just before the failure was:
      < snip >
      @@unique_checks
      0
      select @@innodb_change_buffering_debug;
      @@innodb_change_buffering_debug
      1
      INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+1,z+1 FROM corrupt_bit_test_ā;
      INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+10,z+10 FROM corrupt_bit_test_ā;
      INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+20,z+20 FROM corrupt_bit_test_ā;
      INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+50,z+50 FROM corrupt_bit_test_ā;
      INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+100,z+100 FROM corrupt_bit_test_ā;
      INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+200,z+200 FROM corrupt_bit_test_ā;
      INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+400,z+400 FROM corrupt_bit_test_ā;
      INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+800,z+800 FROM corrupt_bit_test_ā;
      INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+1600,z+1600 FROM corrupt_bit_test_ā;
      INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+4000,z+4000 FROM corrupt_bit_test_ā;
      select count(*) from corrupt_bit_test_ā;
      count(*)
      1024
      CREATE INDEX idx3 ON corrupt_bit_test_ā(b, c);
      INSERT INTO corrupt_bit_test_ā VALUES(13000,'x',1,1);

      Attachments

        Issue Links

          Activity

            Duplicate of MDEV-7139.

            commit 0f252702b15dfb5d90446fd49c9e28aa93424eb1
            Author: Jan Lindström <jan.lindstrom@mariadb.com>
            Date: Wed Jun 8 08:40:10 2016 +0300

            MDEV-7139: Sporadic failure in innodb.innodb_corrupt_bit on P8

            Use direct persistent index corruption set on InnoDB dictionary
            for this test. Do not allow creating new indexes if one of the
            existing indexes is already marked as corrupted.

            jplindst Jan Lindström (Inactive) added a comment - Duplicate of MDEV-7139 . commit 0f252702b15dfb5d90446fd49c9e28aa93424eb1 Author: Jan Lindström <jan.lindstrom@mariadb.com> Date: Wed Jun 8 08:40:10 2016 +0300 MDEV-7139 : Sporadic failure in innodb.innodb_corrupt_bit on P8 Use direct persistent index corruption set on InnoDB dictionary for this test. Do not allow creating new indexes if one of the existing indexes is already marked as corrupted.

            People

              jplindst Jan Lindström (Inactive)
              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.