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

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11.18
    • None
    • Galera, Server
    • None

    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.