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

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.4.12, 10.5
Fix Version/s: 10.2.33, 10.3.24, 10.4.14, 10.5.5
Component/s: Galera, Tests
Labels:
None
Environment:
TestTarball_2 debian-8

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

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

200413_stdout_10.5e.log
31 kB
2020-04-14 19:01
200413_galera_parallel_autoinc_manytrx_10.5e.zip
53 kB
2020-04-14 19:01
200524_10.4e_galera_parallel_autoinc_manytrx.zip
101 kB
2020-05-29 15:15

Activity

Ascending order - Click to sort in descending order

Stepan Patryshev (Inactive) created issue - 2020-02-18 09:22

Stepan Patryshev (Inactive) made changes - 2020-02-18 09:22

Field	Original Value	New Value
Link		This issue blocks MENT-565 [ MENT-565 ]

Stepan Patryshev (Inactive) made changes - 2020-02-18 09:22

Link

This issue blocks MDEV-17728 [ MDEV-17728 ]

Stepan Patryshev (Inactive) made changes - 2020-02-18 09:24

Assignee

Stepan Patryshev [ stepan.patryshev ]

Jan Lindström [ jplindst ]

Stepan Patryshev (Inactive) added a comment - 2020-03-24 11:09

Closing since it does not fail on CI.

Stepan Patryshev (Inactive) added a comment - 2020-03-24 11:09 Closing since it does not fail on CI.

Stepan Patryshev (Inactive) made changes - 2020-03-24 11:10

Fix Version/s		N/A [ 14700 ]
Fix Version/s	10.4 [ 22408 ]
Resolution		Cannot Reproduce [ 5 ]
Status	Open [ 1 ]	Closed [ 6 ]

Stepan Patryshev (Inactive) made changes - 2020-03-24 11:26

Link

This issue blocks MDEV-17728 [ MDEV-17728 ]

Stepan Patryshev (Inactive) made changes - 2020-03-24 11:26

Link

This issue blocks MENT-565 [ MENT-565 ]

Stepan Patryshev (Inactive) added a comment - 2020-04-14 10:14 - edited

Reopened it since it failed on CI, 10.5 ES.

stdio.log:

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;

Server logs.

Stepan Patryshev (Inactive) added a comment - 2020-04-14 10:14 - edited Reopened it since it failed on CI, 10.5 ES. stdio.log : 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; Server logs .

Stepan Patryshev (Inactive) made changes - 2020-04-14 10:14

Resolution	Cannot Reproduce [ 5 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Stepan Patryshev (Inactive) made changes - 2020-04-14 10:14

Affects Version/s

10.5 [ 23123 ]

Stepan Patryshev (Inactive) made changes - 2020-04-14 10:14

Fix Version/s		10.5 [ 23123 ]
Fix Version/s	N/A [ 14700 ]

Stepan Patryshev (Inactive) made changes - 2020-04-14 10:14

Link

This issue blocks MDEV-22122 [ MDEV-22122 ]

Stepan Patryshev (Inactive) made changes - 2020-04-14 18:49

Description

galera.galera_parallel_autoinc_manytrx failed on [Azure|https://dev.azure.com/mariadbe/MariaDB%20Enterprise/_build/results?buildId=4611&view=logs&j=14a9a36b-ac1b-572f-6fe9-a19e26ccd30a&t=55ad7609-3f7a-570d-99ad-0a947e8a25e7] : "query 'reap' failed: 1305: PROCEDURE test.p1 does not exist".

*[stdio.log|https://dev.azure.com/mariadbe/550599d3-6165-4abd-8c86-e3f7e53a1847/_apis/build/builds/4611/logs/457]*:
{code:title=10.4.12-6 cbfa2cfc48da12a13957d06c59e6a7651b77aa6a}
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;
{code}

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

*stdio.log*:
{code:title=10.4.12-6 cbfa2cfc48da12a13957d06c59e6a7651b77aa6a}
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;
{code}

Stepan Patryshev (Inactive) made changes - 2020-04-14 18:49

Description

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

*stdio.log*:
{code:title=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;
{code}

Stepan Patryshev (Inactive) made changes - 2020-04-14 19:01

Attachment		200413_galera_parallel_autoinc_manytrx_10.5e.zip [ 51224 ]
Attachment		200413_stdout_10.5e.log [ 51225 ]

Stepan Patryshev (Inactive) made changes - 2020-05-29 15:04

Fix Version/s

10.4 [ 22408 ]

Stepan Patryshev (Inactive) made changes - 2020-05-29 15:15

Attachment

200524_10.4e_galera_parallel_autoinc_manytrx.zip [ 52010 ]

Seppo Jaakola made changes - 2020-06-15 08:10

Assignee

Jan Lindström [ jplindst ]

Seppo Jaakola [ seppo ]

Jan Lindström (Inactive) made changes - 2020-06-16 08:43

Assignee

Seppo Jaakola [ seppo ]

Jan Lindström [ jplindst ]

Jan Lindström (Inactive) made changes - 2020-06-16 09:09

issue.field.resolutiondate

2020-06-16 09:09:53.0

2020-06-16 09:09:53.712

Jan Lindström (Inactive) made changes - 2020-06-16 09:09

Fix Version/s		10.5.4 [ 24264 ]
Fix Version/s		10.4.14 [ 24305 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Stepan Patryshev (Inactive) made changes - 2020-06-16 12:46

Link

This issue blocks MDEV-22122 [ MDEV-22122 ]

Jan Lindström (Inactive) made changes - 2020-06-22 09:41

Fix Version/s		10.2.33 [ 24307 ]
Fix Version/s		10.3.24 [ 24306 ]

Sergei Golubchik made changes - 2020-07-02 11:20

Fix Version/s

10.5.5 [ 24423 ]

Sergei Golubchik made changes - 2020-07-02 11:21

Fix Version/s

10.5.4 [ 24264 ]

Sergei Golubchik made changes - 2021-12-06 21:51

Workflow

MariaDB v3 [ 104034 ]

MariaDB v4 [ 157343 ]

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Stepan Patryshev (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2020-02-18 09:22

Updated:: 2020-07-02 11:21

Resolved:: 2020-06-16 09:09

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Attachments

Activity

People

Dates

Git Integration