[#MDEV-21759] galera.galera_parallel_autoinc_manytrx MTR failed: query 'reap' failed: 1305: PROCEDURE test.p1 does not exist

galera.galera_parallel_autoinc_manytrx failed on CI: "query 'reap' failed: 1305: PROCEDURE test.p1 does not exist".

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;

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;

[MDEV-21759] galera.galera_parallel_autoinc_manytrx MTR failed: query 'reap' failed: 1305: PROCEDURE test.p1 does not exist Created: 2020-02-18 Updated: 2020-07-02 Resolved: 2020-06-16
Status:	Closed
Project:	MariaDB Server
Component/s:	Galera, Tests
Affects Version/s:	10.4.12, 10.5
Fix Version/s:	10.2.33, 10.3.24, 10.4.14, 10.5.5

[MDEV-21759] galera.galera_parallel_autoinc_manytrx MTR failed: query 'reap' failed: 1305: PROCEDURE test.p1 does not exist Created: 2020-02-18 Updated: 2020-07-02 Resolved: 2020-06-16