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

InnoDB hang on shutdown

    XMLWordPrintable

Details

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-x86/builds/3235/steps/mtr/logs/stdio

      innodb.innodb_zip_innochecksum3 '16k,innodb' w4 [ fail ]
              Test ended at 2017-11-14 17:37:32
       
      CURRENT_TEST: innodb.innodb_zip_innochecksum3
      Error: Unable to lock file:: /dev/shm/var/4/mysqld.1/data//test/tab1.ibd
      fcntl: Resource temporarily unavailable
      mysqltest: At line 109: exec of '/usr/bin/innochecksum  --write=CRC32 /dev/shm/var/4/mysqld.1/data//test/tab1.ibd' failed, error: 256, status: 1, errno: 32
      Output from before failure:
      [1(b)]: Rewrite into new checksum=crc32 for all *.ibd file and ibdata1
       
       
       
      The result from queries just before the failure was:
      < snip >
      VALUES (@col_1,@col_2,@col_3,@col_4,@cl_5,@col_6,1);
      SELECT * FROM tab2 ORDER BY col_7;
      # stop the server
      [1(a)]: Rewrite into new checksum=InnoDB for all *.ibd file and ibdata1
      : start the server with innodb_checksum_algorithm=strict_innodb
      INSERT INTO tab1 (pk, linestring_key, linestring_nokey)
      VALUES (2, ST_GeomFromText('LINESTRING(10 10,20 20,30 30)'), ST_GeomFromText('LINESTRING(10 10,20 20,30 30)'));
      SET @col_1 = repeat('a', 5);
      SET @col_2 = repeat('b', 20);
      SET @col_3 = repeat('c', 100);
      SET @col_4 = repeat('d', 100);
      SET @col_5 = repeat('e', 100);
      SET @col_6 = repeat('f', 100);
      INSERT INTO tab2(col_1,col_2,col_3,col_4,col_5,col_6,col_7)
      VALUES (@col_1,@col_2,@col_3,@col_4,@cl_5,@col_6,6);
      SELECT pk,ST_AsText(linestring_key),ST_AsText(linestring_nokey)
      FROM tab1 ORDER BY pk;
      SELECT * FROM tab2 ORDER BY col_7;
      # stop the server
      [1(b)]: Rewrite into new checksum=crc32 for all *.ibd file and ibdata1
       
      More results from queries before failure can be found in /dev/shm/var/4/log/innodb_zip_innochecksum3.log
      

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.