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

galera.galera_toi_truncate: Test failure: mysqltest: query 'reap' succeeded - should have failed with errno 1213

    XMLWordPrintable

Details

    Description

      MariaDB Server: 10.4.3-MariaDB-debug built from sources, branch=10.4, commit: 2a791c53ad93c8bc1441dd227000234bd49c4990.
      Galera4 lib 26.4.0(r4477): debug built from sources, commit: 9bd47835d0fcdcf2f041da39dbe5b98ff738ff10.

      Run:

      ./mtr --suite galera --force --big-test --max-test-fail=0 --parallel=auto
      

      stdout.log:

      galera.galera_toi_truncate 'innodb'      w2 [ fail ]
       
      mysqltest: At line 45: query 'reap' succeeded - should have failed with errno 1213...
       
      The result from queries just before the failure was:
      connection node_2;
      connection node_1;
      connection node_1;
      CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
      INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
      CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
      connection node_2;
      SET SESSION wsrep_retry_autocommit = 0;
      INSERT INTO t1(f1) SELECT 1 FROM ten as a1, ten AS a2;
      set debug_sync='ha_commit_trans_after_prepare WAIT_FOR go';
      INSERT INTO t1 (f1) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5, ten AS a6;;
      connection node_1;
      TRUNCATE TABLE t1;;
      connection node_1;
      connection node_2;
      

      See also attached galera.galera_toi_truncate-innodb.zip.

      Note: This test has failed only on suite running, but on standalone running it has passed.

      Attachments

        1. 190306_galera_stdout_laptop.log
          23 kB
          Stepan Patryshev
        2. 200408_galera_toi_truncate_stdout_10.3e.log
          23 kB
          Stepan Patryshev

        Issue Links

          Activity

            People

              sysprg Julius Goryavsky
              stepan.patryshev Stepan Patryshev (Inactive)
              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.