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

galera_sr.galera-features#56 MTR failed: query 'reap' failed: 1213: Deadlock found when trying to get lock

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 10.4.18
    • Fix Version/s: N/A
    • Component/s: Galera, Tests
    • Environment:
      kvm-zyp-opensuse150-amd64

      Description

      galera_sr.galera-features#56 failed on BB 10.4 CS: "query 'reap' failed: 1213: Deadlock found when trying to get lock".
      It seems to be a sporadic issue.

      stdio.log:

      10.4.18, 542d769ea1a22a7a6a87c9fe76ff911a162ade44, kvm-zyp-opensuse150-amd64

      galera_sr.galera-features#56 'innodb'    w2 [ fail ]
              Test ended at 2021-01-28 08:45:33
       
      CURRENT_TEST: galera_sr.galera-features#56
      mysqltest: At line 50: query 'reap' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
       
      The result from queries just before the failure was:
      < snip >
      connection node_2;
      set session wsrep_sync_wait=15;
      SELECT COUNT(*) from ten;
      COUNT(*)
      10
      SELECT COUNT(*) from t1;
      COUNT(*)
      0
      set session wsrep_sync_wait=0;
      SET GLOBAL wsrep_slave_threads = 4;
      SET SESSION wsrep_trx_fragment_size = 1;
      connection node_1;
      INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2;;
      connection node_1a;
      INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2;;
      connection node_2;
      INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2;;
      connection node_1;
      connection node_1a;
      connection node_2;
       
      More results from queries before failure can be found in /dev/shm/var/2/log/galera-features#56.log
       
       - saving '/dev/shm/var/2/log/galera_sr.galera-features#56-innodb/' to '/dev/shm/var/log/galera_sr.galera-features#56-innodb/'
       
      Retrying test galera_sr.galera-features#56, attempt(2/3)...
       
      worker[2] > Restart  - not started
      worker[2] > Restart  - not started
      ***Warnings generated in error logs during shutdown after running tests: galera_sr.GCF-900 galera_sr.GCF-561 galera_sr.GCF-1051 galera_sr.GCF-585 galera_sr.GCF-1008 galera_sr.GCF-627 galera_sr.MDEV-23623 galera_sr.GCF-1018 galera_sr.MDEV-22616 galera_sr.GCF-597 galera_sr.GCF-845 galera_sr.GCF-851 galera_sr.GCF-571 galera_sr.GCF-623 galera_sr.GCF-867 galera_sr.GCF-889 galera_sr.GCF-620 galera_sr.GCF-580 galera_sr.GCF-572 galera_sr.galera-features#56
       
      2021-01-28  8:45:31 189 [Warning] WSREP: Could not find streaming applier for 0c336610-6145-11eb-b755-c63927cc0979:1476
      2021-01-28  8:45:31 2 [ERROR] WSREP: Failed to apply write set: gtid: 0bf48c4d-6145-11eb-8658-435dcb31e7f0:562 server_id: 0c336610-6145-11eb-b755-c63927cc0979 client_id: 18446744073709551615 trx_id: 1476 flags: 20 (rollback | pa_unsafe)
      

      Server logs.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

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