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

galera.MW-258 fails with a deadlock

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.2
    • N/A
    • Galera, Tests
    • libgalera 25.3.14

    Description

      10.2 e99c7c8334f842a debug build

      galera.MW-258 'innodb'                   w2 [ fail ]
              Test ended at 2017-10-26 03:58:36
       
      CURRENT_TEST: galera.MW-258
      mysqltest: At line 33: query 'reap' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
       
      The result from queries just before the failure was:
      < snip >
      connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
      connection node_1a;
      SET SESSION wsrep_sync_wait = 0;
      SET SESSION wsrep_osu_method = RSU;
      ALTER TABLE t1 ADD COLUMN f2 INTEGER;;
      connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1;
      connection node_1b;
      SET SESSION wsrep_sync_wait = 0;
      SET SESSION wsrep_osu_method = RSU;
      ALTER TABLE t1 ADD COLUMN f3 INTEGER;;
      connection node_1;
      value during RSU:
      SHOW STATUS LIKE 'wsrep_desync_count';
      Variable_name   Value
      SHOW VARIABLES LIKE 'wsrep_desync';
      Variable_name   Value
      wsrep_desync    OFF
      UNLOCK TABLES;
      connection node_1a;
      connection node_1b;
      

      Attachments

        Activity

          People

            stepan.patryshev Stepan Patryshev (Inactive)
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.