Details
Critical Description
galera.galera_parallel_autoinc_manytrx failed on CI: "query 'reap' failed: 1305: PROCEDURE test.p1 does not exist".
stdio.log:
|
10.4.12-6 cbfa2cfc48da12a13957d06c59e6a7651b77aa6a, debian-8 |
2020-02-17T05:38:38.2373688Z galera.galera_parallel_autoinc_manytrx 'innodb' w1 [ fail ]
|
2020-02-17T05:38:38.2375495Z Test ended at 2020-02-17 05:38:38
|
2020-02-17T05:38:38.2376116Z
|
2020-02-17T05:38:38.2451505Z CURRENT_TEST: galera.galera_parallel_autoinc_manytrx
|
2020-02-17T05:38:38.2452582Z mysqltest: At line 75: query 'reap' failed: 1305: PROCEDURE test.p1 does not exist
|
2020-02-17T05:38:38.2452952Z
|
2020-02-17T05:38:38.2453235Z The result from queries just before the failure was:
|
2020-02-17T05:38:38.2453513Z < snip >
|
2020-02-17T05:38:38.2453803Z CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 INTEGER) Engine=InnoDB;
|
2020-02-17T05:38:38.2453969Z connection node_2;
|
2020-02-17T05:38:38.2454185Z set session wsrep_sync_wait=15;
|
2020-02-17T05:38:38.2454353Z SET GLOBAL wsrep_slave_threads = 4;
|
2020-02-17T05:38:38.2454558Z connection node_1;
|
2020-02-17T05:38:38.2454769Z CREATE PROCEDURE p1 (repeat_count int)
|
2020-02-17T05:38:38.2454909Z BEGIN
|
2020-02-17T05:38:38.2455103Z DECLARE current_num int;
|
2020-02-17T05:38:38.2455312Z SET current_num = 0;
|
2020-02-17T05:38:38.2455456Z WHILE current_num < repeat_count do
|
2020-02-17T05:38:38.2455649Z INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1;
|
2020-02-17T05:38:38.2455871Z COMMIT;
|
2020-02-17T05:38:38.2456013Z SET current_num = current_num + 1;
|
2020-02-17T05:38:38.2456211Z END WHILE;
|
2020-02-17T05:38:38.2456390Z END|
|
2020-02-17T05:38:38.2456865Z connection node_1a;
|
2020-02-17T05:38:38.2457068Z connection node_1b;
|
2020-02-17T05:38:38.2457260Z connection node_2;
|
Attachments
Activity
Reopened it since it failed on CI, 10.5 ES.
|
10.5.2-0 022c86e4b886e4d87cfcbfc5c5c0cdcb7e4eb3fa, Build Debug, rhel-7 |
galera.galera_parallel_autoinc_manytrx 'innodb' w4 [ fail ]
|
Test ended at 2020-04-13 12:29:50
|
|
|
CURRENT_TEST: galera.galera_parallel_autoinc_manytrx
|
mysqltest: At line 75: query 'reap' failed: 1305: PROCEDURE test.p1 does not exist
|
|
|
The result from queries just before the failure was:
|
< snip >
|
CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 INTEGER) Engine=InnoDB;
|
connection node_2;
|
set session wsrep_sync_wait=15;
|
SET GLOBAL wsrep_slave_threads = 4;
|
connection node_1;
|
CREATE PROCEDURE p1 (repeat_count int)
|
BEGIN
|
DECLARE current_num int;
|
SET current_num = 0;
|
WHILE current_num < repeat_count do
|
INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1;
|
COMMIT;
|
SET current_num = current_num + 1;
|
END WHILE;
|
END|
|
connection node_1a;
|
connection node_1b;
|
connection node_2;
|
Closing since it does not fail on CI.