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

Galera cluster blocks concurrent commits and leads to server hang

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Incomplete
    • 10.6
    • N/A
    • Galera
    • None

    Description

      Testcase

      Start 3 node cluster
      -- Node1
      CREATE TABLE test.tbl (
      id int NOT NULL AUTO_INCREMENT, 
      t_id varchar(10) NOT NULL, 
      dt timestamp DEFAULT current_timestamp(), 
      a_id int DEFAULT 0, 
      PRIMARY KEY (id), 
      INDEX ix_dt (dt)
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 DEFAULT COLLATE=latin1_swedish_ci;
       
      -- Node3
      Run mysqlslap test on node3
      sudo mysqlslap -uroot -i 50000 -c 5 --create-schema=test --no-drop --delimiter=";" --query="insert into test.tbl (t_id, a_id) values('100100',1);insert into test.tbl (t_id) values('200200');" &
       
      Node3 goes into hang mode with a commit state of "Waiting for prior transaction to commit".
       
      |  48 | root        | localhost | NULL    | Sleep   |   19 |                                         | NULL                                                                       |    0.000 |
      | 844 | root        | localhost | test | Query   |   18 | Commit                                  | insert into test.tbl (t_id, a_id) values('100100',1) |    0.000 |
      | 845 | root        | localhost | test | Query   |   18 | Commit                                  | insert into test.tbl (t_id) values('200200')               |    0.000 |
      | 846 | root        | localhost | test | Query   |   18 | Commit                                  | insert into test.tbl (t_id, a_id) values('100100',1) |    0.000 |
      | 847 | root        | localhost | test | Query   |   18 | Waiting for prior transaction to commit | insert into test.tbl (t_id, a_id) values('100100',1) |    0.000 |
      | 848 | root        | localhost | test | Query   |   18 | Commit                                  | insert into test.tbl (t_id, a_id) values('100100',1) |    0.000 |
      | 849 | root        | localhost | NULL    | Query   |    0 | starting                                | show processlist                                                           |    0.000 |
      +-----+-------------+-----------+---------+---------+------+-----------------------------------------+----------------------------------------------------------------------------+----------+
      48 rows in set (0.001 sec)
      
      

      Attachments

        1. node3.cnf
          1 kB
        2. node2.cnf
          1 kB
        3. node1.cnf
          1 kB
        4. full_bt.log
          81 kB
        5. full_bt_new.log
          78 kB

        Activity

          People

            denis.protivensky Denis Protivensky
            ramesh Ramesh Sivaraman
            Votes:
            1 Vote for this issue
            Watchers:
            6 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.