Details
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;
|
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Description |
All these fail on timeout like this:
{noformat} 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; {noformat} |
* MariaDB Version 10.2.20-MariaDB-debug
* commit d0bf132a6ace31c29813b4004fab2a8af780deaa All these fail on timeout like this: {noformat} 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; {noformat} |
Assignee | Mario Karuza [ mkaruza ] | Julius Goryavsky [ sysprg ] |
Link |
This issue blocks |
Status | Open [ 1 ] | In Progress [ 3 ] |
Fix Version/s | 10.3 [ 22126 ] |
Fix Version/s | 10.4 [ 22408 ] |
Assignee | Julius Goryavsky [ sysprg ] | Jan Lindström [ jplindst ] |
issue.field.resolutiondate | 2019-08-13 09:53:00.0 | 2019-08-13 09:53:00.125 |
Fix Version/s | 10.2.27 [ 23717 ] | |
Fix Version/s | 10.3.18 [ 23719 ] | |
Fix Version/s | 10.4.8 [ 23721 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Fix Version/s | 10.4 [ 22408 ] | |
Resolution | Fixed [ 1 ] | |
Status | In Progress [ 3 ] | Closed [ 6 ] |
Link |
This issue blocks |
Workflow | MariaDB v3 [ 90912 ] | MariaDB v4 [ 155278 ] |