[MDEV-23587] galera_3nodes.galera_var_dirty_reads2 MTR failed: 1047: WSREP has not yet prepared node for application use Created: 2020-08-26  Updated: 2020-10-06  Resolved: 2020-09-11

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.2.34, 10.3.25, 10.4.15, 10.5.6
Fix Version/s: 10.2.35, 10.3.26, 10.4.16, 10.5.7, 10.6.0

Type: Bug Priority: Major
Reporter: Stepan Patryshev (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

kvm-deb-xenial-aarch64


Issue Links:
Relates
relates to MDEV-23591 galera_3nodes.GCF-354 MTR failed: 104... Closed

 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


Generated at Thu Feb 08 09:23:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.