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

encryption.create_or_replace fails in buildbot on P8 builders

Details

    Description

      According to buildbot results, it appears to fail reliably – all 4 combinations, on all 4 P8 builders, since commit 7567b9fa10985a57339e8f0dbaf6e654.

      http://buildbot.askmonty.org/buildbot/builders/p8-rhel71-bintar/builds/420/steps/test/logs/stdio

      encryption.create_or_replace 'ctr,xtradb' w4 [ fail ]  timeout after 900 seconds
              Test ended at 2015-07-16 23:21:15
       
      Test case timeout after 900 seconds
       
      == /home/buildbot/maria-slave/power8-vlp06-bintar/build/mysql-test/var/4/log/create_or_replace.log == 
      SET default_storage_engine = InnoDB;
      CREATE TABLE t1 (pk INT PRIMARY KEY, c VARCHAR(256));
      CREATE TABLE t2 AS SELECT * FROM t1;
      drop table t1,t2;
      SET GLOBAL innodb_encryption_threads = 0;
      SET GLOBAL innodb_encryption_threads = 4;
      CREATE TABLE `table10_int_autoinc` (`col_int_key` int, pk int auto_increment, `col_int` int, key (`col_int_key` ),primary key (pk)) engine=innodb;
      INSERT /*! IGNORE */ INTO table10_int_autoinc VALUES  (NULL, NULL, -474021888) ,  (1, NULL, NULL) ,  (1141047296, NULL, NULL) ,  (NULL, NULL, NULL) ,  (NULL, NULL, 1) ,  (NULL, NULL, 9) ,  (0, NULL, 1225785344) ,  (NULL, NULL, 1574174720) ,  (2, NULL, NULL) ,  (6, NULL, 3);
      CREATE TABLE `table1_int_autoinc` (`col_int_key` int, pk int auto_increment, `col_int` int,key (`col_int_key` ), primary key (pk)) engine=innodb;
      CREATE TABLE `table0_int_autoinc` (`col_int_key` int, pk int auto_increment, `col_int` int, key (`col_int_key` ),primary key (pk)) engine=innodb;
      INSERT /*! IGNORE */ INTO table1_int_autoinc VALUES  (4, NULL, NULL);
      INSERT IGNORE INTO `table0_int_autoinc` ( `col_int_key` ) VALUES ( 1 ), ( 3 ), ( 4 ), ( 1 );
      INSERT IGNORE INTO `table1_int_autoinc` ( `col_int` ) VALUES ( 1 ), ( 0 ), ( 7 ), ( 9 );
      INSERT IGNORE INTO `table10_int_autoinc` ( `col_int` ) VALUES ( 6 ), ( 2 ), ( 3 ), ( 6 );
       
       == /home/buildbot/maria-slave/power8-vlp06-bintar/build/mysql-test/var/4/tmp/analyze-timeout-mysqld.1.err ==
      mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/home/buildbot/maria-slave/power8-vlp06-bintar/build/mysql-test/var/tmp/4/mysqld.1.sock' (111 "Connection refused")

      Attachments

        Issue Links

          Activity

            commit 62b5a561910f8001c288bcc75c11516a4d061cd3
            Author: Jan Lindström <jan.lindstrom@mariadb.com>
            Date: Tue Jul 21 12:51:14 2015 +0300

            MDEV-8501: encryption.create_or_replace fails in buildbot on P8 builders

            Analysis: There is race between drop table and encryption threads that
            could cause encryption thread to enter mutex that has been already
            released.

            Fix: When destroying crypt_data first enter the mutex and set crypt data
            unavailable, then release the memory and clean up the data. This should
            make the race more unprobable. Additionally, added big_test for
            create_or_replace as it could fail testcase timeout
            if you have slow I/O (tested that testcase passes with --mem).

            jplindst Jan Lindström (Inactive) added a comment - commit 62b5a561910f8001c288bcc75c11516a4d061cd3 Author: Jan Lindström <jan.lindstrom@mariadb.com> Date: Tue Jul 21 12:51:14 2015 +0300 MDEV-8501 : encryption.create_or_replace fails in buildbot on P8 builders Analysis: There is race between drop table and encryption threads that could cause encryption thread to enter mutex that has been already released. Fix: When destroying crypt_data first enter the mutex and set crypt data unavailable, then release the memory and clean up the data. This should make the race more unprobable. Additionally, added big_test for create_or_replace as it could fail testcase timeout if you have slow I/O (tested that testcase passes with --mem).

            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.