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

galera.mysql-wsrep#198 MTR failed: query 'reap' failed: 2000: Unknown MySQL error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.3.28, 10.4.18
    • Fix Version/s: 10.3, 10.4
    • Component/s: Galera, Tests
    • Labels:
      None
    • Environment:
      kvm-deb-stretch-x86

      Description

      galera.mysql-wsrep#198 failed on BB 10.4 CS: "query 'reap' failed: 2000: Unknown MySQL error".
      It seems to be a sporadic issue.

      stdio.log:

      10.4.18, a50cb4867a7f63bfc03b33bfb5be8d47d15ba64d, kvm-deb-stretch-x86

      galera.mysql-wsrep#198 'innodb'          w1 [ fail ]
              Test ended at 2020-12-03 06:01:23
       
      CURRENT_TEST: galera.mysql-wsrep#198
      mysqltest: At line 34: query 'reap' failed: 2000: Unknown MySQL error
       
      The result from queries just before the failure was:
      < snip >
      connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
      connection node_2a;
      OPTIMIZE TABLE t1,t2;;
      connect node_2b, 127.0.0.1, root, , test, $NODE_MYPORT_2;
      connection node_2b;
      REPAIR TABLE t1,t2;;
      connection node_2;
      SET SESSION wsrep_sync_wait = 0;
      connection node_1;
      INSERT INTO t2 VALUES (1);
      connection node_2;
      UNLOCK TABLES;
      connection node_2a;
       
      More results from queries before failure can be found in /dev/shm/var/1/log/mysql-wsrep#198.log
       
       - saving '/dev/shm/var/1/log/galera.mysql-wsrep#198-innodb/' to '/dev/shm/var/log/galera.mysql-wsrep#198-innodb/'
       
      Retrying test galera.mysql-wsrep#198, attempt(2/3)...
       
      worker[1] > Restart  - not started
      worker[1] > Restart  - not started
      galera.mysql-wsrep#198 'innodb'          w1 [ retry-pass ]   2128
       
      Retrying test galera.mysql-wsrep#198, attempt(3/3)...
       
      worker[1] > Restart  - not started
      worker[1] > Restart  - not started
      

      Server logs.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated: