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

Test failure on galera.galera_var_retry_autocommit

    XMLWordPrintable

    Details

      Description

      How to repeat:

      • cmake . -DBUILD_CONFIG=mysql_release
      • mtr --suite=galera --vardir=/dev/shm --force --parallel=4

      galera.galera_var_retry_autocommit 'innodb_plugin' w1 [ fail ]
              Test ended at 2018-04-06 16:14:49
       
      CURRENT_TEST: galera.galera_var_retry_autocommit
      mysqltest: At line 73: query 'INSERT INTO t1 (f1) VALUES (5),(6)' succeeded - should have failed with errno 1213...
       
      The result from queries just before the failure was:
      < snip >
      SET SESSION wsrep_retry_autocommit = 1;
      INSERT INTO t1 (f1) VALUES (3),(4);;
      TRUNCATE TABLE t1;
      SELECT * FROM test.t1;
      f1	f2
      3	0
      4	0
      CREATE PROCEDURE repeated_truncate ()
      BEGIN
      DECLARE i INT;
      DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
      SET i = 0;
      WHILE i <= 1000 DO
      TRUNCATE TABLE t1;
      SET i = i + 1;
      END WHILE;
      END|
      CALL repeated_truncate();
      SET SESSION wsrep_retry_autocommit = 1;
      INSERT INTO t1 (f1) VALUES (5),(6);
       
      More results from queries before failure can be found in /dev/shm/1/log/galera_var_retry_autocommit.log
      
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              jplindst Jan Lindström
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: