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

    • Type: Bug
    • Status: In Progress (View Workflow)
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 10.2, 10.3, 10.4.3
    • Fix Version/s: 10.2
    • Component/s: Galera, Tests
    • Labels:
    • Environment:
      OS: CentOS Linux release 7.6.1810 (Core).

      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: (attached [^])

      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

          Issue Links

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              stepan.patryshev Stepan Patryshev
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: