[MDEV-25614] Galera test failure on GCF-354 Created: 2021-05-07  Updated: 2023-10-10

Status: Stalled
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.6
Fix Version/s: 10.6

Type: Bug Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Julius Goryavsky
Resolution: Unresolved Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-bionic-aarch64/builds/5758/steps/mtr-galera/logs/stdio

galera_3nodes.GCF-354 'innodb'           w1 [ fail ]
        Test ended at 2021-05-06 14:22:10
 
CURRENT_TEST: galera_3nodes.GCF-354
mysqltest: At line 39: query 'DROP TABLE test.t1' failed: 1047: WSREP has not yet prepared node for application use
 
The result from queries just before the failure was:
< snip >
connection node_2;
SET SESSION wsrep_on=OFF;
DROP SCHEMA test;
connection node_3;
SET SESSION wsrep_on=OFF;
CREATE TABLE test.t1 (f1 INTEGER NOT NULL PRIMARY KEY) engine=innodb;
connection node_1;
CREATE TABLE test.t1 (f1 INTEGER NOT NULL PRIMARY KEY) engine=innodb;
INSERT INTO test.t1 values (1);
Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status'
Id	User	Host	db	Command	Time	State	Info	Progress
1	system user		NULL	Sleep	43	closing tables	NULL	0.000
2	system user		NULL	Sleep	43	wsrep aborter idle	NULL	0.000
10	root	localhost	test	Sleep	34		NULL	0.000
11	root	localhost:51412	test	Query	0	starting	show full processlist	0.000
SHOW STATUS LIKE 'wsrep_cluster_status';
Variable_name	Value
wsrep_cluster_status	non-Primary
DROP TABLE test.t1;
 
More results from queries before failure can be found in /dev/shm/var/1/log/GCF-354.log
 
 - saving '/dev/shm/var/1/log/galera_3nodes.GCF-354-innodb/' to '/dev/shm/var/log/galera_3nodes.GCF-354-innodb/'
 
Retrying test galera_3nodes.GCF-354, attempt(2/3)...
 
worker[1] > Restart  - not started
worker[1] > Restart  - not started
worker[1] > Restart  - not started
***Warnings generated in error logs during shutdown after running tests: galera_3nodes.GCF-354
 
2021-05-06 14:21:37 2 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on deaeb02a-ae97-11eb-86d7-3a4fb7f19fe0:4
2021-05-06 14:21:37 2 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on deaeb02a-ae97-11eb-86d7-3a4fb7f19fe0:4


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