Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21759

galera.galera_parallel_autoinc_manytrx MTR failed: query 'reap' failed: 1305: PROCEDURE test.p1 does not exist

    XMLWordPrintable

    Details

      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

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            stepan.patryshev Stepan Patryshev
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: