[MDEV-20875] Galera test failure on galera.galera_sst_mariabackup Created: 2019-10-23  Updated: 2019-11-14  Resolved: 2019-11-14

Status: Closed
Project: MariaDB Server
Component/s: Galera SST
Affects Version/s: 10.4
Fix Version/s: 10.2.30, 10.3.21, 10.4.11

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

Attachments: File logs.tgz     File mariabackup.backup.log.2019.10.19-10.24.19.001297820.gz     File mariabackup.move.log.2019.10.19-10.24.18.592524769.gz     File mariabackup.prepare.log.2019.10.19-10.24.18.592524769.gz    

 Description   

galera.galera_autoinc_sst_mariabackup 'innodb' [ fail ]
        Test ended at 2019-10-19 10:32:58
 
CURRENT_TEST: galera.galera_autoinc_sst_mariabackup
mysqltest: In included file "./include/galera_wait_ready.inc": 
included from /home/jan/mysql/10.4/mysql-test/suite/galera/include/start_mysqld.inc at line 16:
included from /home/jan/mysql/10.4/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/mysql-test/var/log/galera_autoinc_sst_mariabackup.log
 
 - saving '/home/jan/mysql/10.4/mysql-test/var/log/galera.galera_autoinc_sst_mariabackup-innodb/' to '/home/jan/mysql/10.4/mysql-test/var/log/galera.galera_autoinc_sst_mariabackup-innodb/'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 548 seconds executing testcases
 
Failure: Failed 1/1 tests, 0.00% were successful.
 
Failing test(s): galera.galera_autoinc_sst_mariabackup



 Comments   
Comment by Jan Lindström (Inactive) [ 2019-10-23 ]

Very repeatable on my laptop using:

  • latest 10.4 with release build
  • latest galera library with release build
  • ./mtr galera.galera_autoinc_sst_mariabackup --repeat=40
  • Most of time first repeat already fails
Comment by Jan Lindström (Inactive) [ 2019-11-06 ]

Question: Does your fix apply to galera-3 ? If yes apply fix to galera-3 also. Ok to push.

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