[MDEV-17847] Galera test failure on MW-328[A|B|C] Created: 2018-11-27  Updated: 2019-12-18  Resolved: 2019-08-13

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.2
Fix Version/s: 10.2.27, 10.3.18, 10.4.8

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


 Description   
  • MariaDB Version 10.2.20-MariaDB-debug
  • commit d0bf132a6ace31c29813b4004fab2a8af780deaa

All these fail on timeout like this:

galera.MW-328C 'innodb'                  w3 [ fail ]  timeout after 900 seconds
        Test ended at 2018-11-27 10:15:29
 
Test case timeout after 900 seconds
 
== /home/jan/mysql/10.2-sst/mysql-test/var/3/log/MW-328C.log == 
CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 CHAR(20) DEFAULT 'abc') ENGINE=InnoDB;
INSERT INTO t1 (f1) VALUES (1);
CREATE TABLE t2 (f1 CHAR(20)) ENGINE=InnoDB;
CREATE PROCEDURE proc_update ()
BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
SET SESSION wsrep_sync_wait = 0;
WHILE 1 DO
UPDATE t1 SET f2 = LEFT(MD5(RAND()), 4);
END WHILE;
END|
connect node_1X, 127.0.0.1, root, , test, $NODE_MYPORT_1;
connection node_1X;
CALL proc_update();;
connection node_2;
SET SESSION wsrep_retry_autocommit = 10000;


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