mirror of
https://github.com/MariaDB/server.git
synced 2025-04-21 22:55:35 +02:00
5c4c1844bf
This test happens to fail if it runs after test galera_inject_bf_long_wait. And the reason is that galera_bf_lock_wait greps for message "BF lock wait long" in the error log, and expects that grep matches no lines. Whereas galera_inject_bf_long_wait intentionally causes the message to appear in the log. The fix consists in using assert_grep.inc with option assert_only_after, such that galera_bf_lock_wait is limited to grep only those lines that appeared in the log after it started to execute. Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
66 lines
2.2 KiB
Text
66 lines
2.2 KiB
Text
connection node_2;
|
|
connection node_1;
|
|
connection node_2;
|
|
call mtr.add_suppression("WSREP: Trying to continue unpaused monitor");
|
|
connection node_1;
|
|
call mtr.add_suppression("WSREP: Trying to continue unpaused monitor");
|
|
CREATE TABLE t1 ENGINE=InnoDB select 1 as a, 1 as b union select 2, 2;
|
|
ALTER TABLE t1 add primary key(a);
|
|
CREATE PROCEDURE p1(repeat_count INT)
|
|
BEGIN
|
|
DECLARE current_num int;
|
|
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION rollback;
|
|
SET current_num = 0;
|
|
WHILE current_num < repeat_count DO
|
|
start transaction;
|
|
update t1 set b=connection_id() where a=1;
|
|
commit;
|
|
SET current_num = current_num + 1;
|
|
END WHILE;
|
|
END|
|
|
connection node_2;
|
|
connect node_1_p1, 127.0.0.1, root, , test, $NODE_MYPORT_1;
|
|
SET SESSION wsrep_sync_wait=0;
|
|
call p1(1000);
|
|
connect node_1_p2, 127.0.0.1, root, , test, $NODE_MYPORT_1;
|
|
SET SESSION wsrep_sync_wait=0;
|
|
call p1(1000);
|
|
connect node_2_p1, 127.0.0.1, root, , test, $NODE_MYPORT_2;
|
|
SET SESSION wsrep_sync_wait=0;
|
|
call p1(1000);
|
|
connect node_2_p2, 127.0.0.1, root, , test, $NODE_MYPORT_2;
|
|
SET SESSION wsrep_sync_wait=0;
|
|
call p1(1000);
|
|
connection node_1;
|
|
checking error log for 'BF lock wait long' message for 10 times every 10 seconds ...
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
include/assert_grep.inc [BF lock wait long]
|
|
connection node_1_p1;
|
|
connection node_1_p2;
|
|
connection node_2_p1;
|
|
connection node_2_p2;
|
|
connection node_1;
|
|
drop table t1;
|
|
drop procedure p1;
|
|
disconnect node_1_p1;
|
|
disconnect node_1_p2;
|
|
disconnect node_2_p1;
|
|
disconnect node_2_p2;
|