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

DBaaS have Galera flow control is true and hung when run DDL

    XMLWordPrintable

Details

    Description

      When ran below DDL, it caused dbaas cluster hung and need bootstrap resumed

      ALTER TABLE tb1 ADD COLUMN col_tb1 VARCHAR(255);
      

      ------
      1. the environment is : node1+ node2+ witness , the mariadb version is 10.11.18 and galera version is galera-4-26.4.27

      2. there have WSREP BF lock wait long on node1.

      2026-06-23 16:13:17 8 [Note] InnoDB: WSREP: BF lock wait long for trx:0x81d17bb09 error: Success query: ALTER TABLE tb1 ADD COLUMN col_tb1 VARCHAR(255) DEFAULT NULL 
       
      ------- TRX HAS BEEN WAITING 50000229 us FOR THIS LOCK TO BE GRANTED: 
       
      TABLE LOCK table `evcss`.`ev_charger` trx id 34847832841 lock mode X waiting
      

      Attachments

        Activity

          People

            seppo Seppo Jaakola
            johngou johngou
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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