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

galera_3nodes.galera_var_dirty_reads2 MTR failed: 1047: WSREP has not yet prepared node for application use

    XMLWordPrintable

    Details

      Description

      galera_3nodes.galera_var_dirty_reads2 failed on BB 10.2, BB 10.3: "query 'DROP TABLE t1' failed: 1047: WSREP has not yet prepared node for application use".

      stdio.log:

      10.2.34 21a96581fd1dd11c5605dd89e3adbaabdf6de5eb

      galera_3nodes.galera_var_dirty_reads2 'innodb' w1 [ fail ]
              Test ended at 2020-08-26 00:30:29
       
      CURRENT_TEST: galera_3nodes.galera_var_dirty_reads2
      mysqltest: At line 123: query 'DROP TABLE t1' failed: 1047: WSREP has not yet prepared node for application use
       
      The result from queries just before the failure was:
      < snip >
      DELETE FROM t1;
      ERROR 08S01: WSREP has not yet prepared node for application use
      UPDATE t1 SET f1 = f1 + 1;
      ERROR 08S01: WSREP has not yet prepared node for application use
      DROP TABLE t1;
      ERROR 08S01: WSREP has not yet prepared node for application use
      EXECUTE stmt_update;
      ERROR 08S01: WSREP has not yet prepared node for application use
      SET SESSION wsrep_dirty_reads = 0;
      SELECT * FROM t1;
      ERROR 08S01: WSREP has not yet prepared node for application use
      EXECUTE stmt_select;
      ERROR 08S01: WSREP has not yet prepared node for application use
      SELECT COUNT(*) > 0 FROM INFORMATION_SCHEMA.PROCESSLIST;
      COUNT(*) > 0
      1
      SET GLOBAL wsrep_provider_options='gmcast.isolate=0';
      connection node_1;
      connection node_2;
      DROP TABLE t1;
      

      But on on BB 10.4 and BB 10.5 it failed with another output: "Result length mismatch".

      stdio.log:

      10.4.15 2000d05c2ed85563e35c4548d9518249ddf403df

      galera_3nodes.galera_var_dirty_reads2 'innodb' w2 [ fail ]
              Test ended at 2020-08-25 01:50:22
       
      CURRENT_TEST: galera_3nodes.galera_var_dirty_reads2
      --- /usr/share/mysql/mysql-test/suite/galera_3nodes/r/galera_var_dirty_reads2.result	2020-08-24 23:06:12.000000000 -0400
      +++ /dev/shm/var/2/log/galera_var_dirty_reads2.reject	2020-08-25 01:50:22.206412755 -0400
      @@ -14,7 +14,6 @@
       SET SESSION wsrep_dirty_reads = 1;
       SELECT f1 FROM t1;
       f1
      -1
       USE test;
       SHOW CREATE TABLE t1;
       Table	Create Table
      @@ -28,7 +27,6 @@
       PREPARE stmt_select FROM 'SELECT f1 FROM t1';
       EXECUTE stmt_select;
       f1
      -1
       PREPARE stmt_update FROM 'UPDATE t1 SET f1 = f1 + f1';
       SET GLOBAL wsrep_dirty_reads = 1;
       SET GLOBAL wsrep_sync_wait = 0;
       
      mysqltest: Result length mismatch
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration