[MDEV-18177] Galera test failure on galera_autoinc_sst_mariabackup Created: 2019-01-09  Updated: 2020-07-29  Resolved: 2020-07-24

Status: Closed
Project: MariaDB Server
Component/s: Galera, Galera SST, Tests
Affects Version/s: 10.4
Fix Version/s: 10.2.33, 10.3.24, 10.4.14, 10.5.5

Type: Bug Priority: Critical
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Attachments: Zip Archive 191023_galera_autoinc_sst_mariabackup.zip    
Issue Links:
Relates
relates to MDEV-17458 Unable to Start Galera Node Closed

 Description   

galera.galera_autoinc_sst_mariabackup 'innodb' w8 [ fail ]
        Test ended at 2019-01-09 09:09:13
 
CURRENT_TEST: galera.galera_autoinc_sst_mariabackup
mysqltest: In included file "./include/galera_wait_ready.inc": 
included from /home/jan/mysql/10.4-galera-2/mysql-test/suite/galera/include/start_mysqld.inc at line 16:
included from /home/jan/mysql/10.4-galera-2/mysql-test/suite/galera/t/galera_autoinc_sst_mariabackup.test at line 50:
At line 28: "Server did not transition to READY state"
 
The result from queries just before the failure was:
< snip >
connection node_1;
connection node_1;
connection node_2;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
CREATE PROCEDURE p1 ()
BEGIN
DECLARE x INT DEFAULT 1;
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
WHILE 1 DO
INSERT INTO t1 VALUES (DEFAULT);
COMMIT;
END WHILE;
END|
CALL p1();;
connection node_2;
CALL p1();;
connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
connection node_2a;
Killing server ...
 
More results from queries before failure can be found in /home/jan/mysql/10.4-galera-2/mysql-test/var/8/log/galera_autoinc_sst_mariabackup.log



 Comments   
Comment by Stepan Patryshev (Inactive) [ 2019-10-23 ]

I found the following [ERROR] in mysqld.2.err:

2019-10-20 12:10:56 0 [ERROR] WSREP: gcs/src/gcs_state_msg.cpp:gcs_state_msg_get_quorum():947: Failed to establish quorum.
2019-10-20 12:10:56 0 [Note] WSREP: Quorum results:
	version    = 6,
	component  = NON-PRIMARY,
	conf_id    = -1,
	members    = 0/1 (joined/total),
	act_id     = -1,
	last_appl. = -1,
	protocols  = -1/-1/-1 (gcs/repl/appl),
	vote policy= 1,
	group UUID = 00000000-0000-0000-0000-000000000000

All logs: 191023_galera_autoinc_sst_mariabackup.zip.

Reproduced on:

MariaDB Version 10.4.9-MariaDB-debug: Repository: MariaDB/server; branch 10.4; Revision 421d52e89627d85794d7e8e4b70216b14f384178; debug built from sources.

Galera 26.4.3(r4535): Repository: MariaDB/galera; branch mariadb-4.x; Revision 752664dc3c7065d8e0c73ac99d0028a5f84eb250; debug built from sources.

Comment by Stepan Patryshev (Inactive) [ 2020-01-02 ]

It failed also on Azure: "MariaDBEnterprise - MTR" pipeline, run: #20191122.3.

Comment by Stepan Patryshev (Inactive) [ 2020-01-08 ]

Increased the priority since it failed on Azure.

Generated at Thu Feb 08 08:42:05 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.