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

Galera cluster crashed with requested state transfer from '*any*', but it is impossible to select State Transfer donor: No donor candidates temporarily available in suitable state

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.6.22
    • None
    • Server
    • None

    Description

      We had 3 nodes galera cluster that (node1+node2+witness) with version is 10.6.22 (node1)+10.6.22(node2)+galera-4-26.4.19 (witness)
      It happened flow control while run ALTER TABLE board MODIFY COLUMN declaration TEXT in node2, then we manual restart node1, but the restart failed, at the same time, the node2 cannot provide read service as well, In other words, it means the cluster crashed

      ------------------------------------------
      the node1 error alert:
      2025-08-29 16:42:35 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
      2025-08-29 16:42:37 0 [Note] /usr/sbin/mariadbd: Shutdown complete
      Warning: Memory not freed: 50300856

      2025-08-29 16:42:51 0 [Note] Starting MariaDB 10.6.22-MariaDB-log source revision 19644f6821d59ecca0f9b1f44fadb3b887061965 server_uid Gu98QFjGMnijDA3kQgssnPW1GVI= as process 2431561
      ......
      2025-08-29 16:42:55 0 [Note] WSREP: Member 0.0 (p1vdbs-csbeopms-peopdb-1-01) requested state transfer from 'any', but it is impossible to select State Transfer donor: No donor candidates temporarily available in suitable state
      2025-08-29 16:42:55 2 [Note] WSREP: Requesting state transfer failed: No donor candidates temporarily available in suitable state. Will keep retrying every 1 second(s)
      2025-08-29 16:42:56 0 [Note] WSREP: Member 0.0 (p1vdbs-csbeopms-peopdb-1-01) requested state transfer from 'any', but it is impossible to select State Transfer donor: No donor candidates temporarily available in suitable state
      .....
      -----------------------------------------
      the node2 error alert:
      2025-08-29 15:56:34 9 [Note] InnoDB: WSREP: BF lock wait long for trx:0x137d8a3 error: Success query: ALTER TABLE board MODIFY COLUMN declaration_of_interest_decision_text_end TEXT
      ------- TRX HAS BEEN WAITING 50000150 us FOR THIS LOCK TO BE GRANTED:
      TABLE LOCK table `eopms`.`writeup_lock` trx id 20437155 lock mode X waiting

      ...........
      2025-08-29 16:42:54 0 [Note] WSREP: Flow-control interval: [707, 707]
      2025-08-29 16:42:55 0 [Note] WSREP: Member 0.0 (p1vdbs-csbeopms-peopdb-1-01) requested state transfer from 'any', but it is impossible to select State Transfer donor: No donor candidates temporarily available in suitable state
      2025-08-29 16:42:56 0 [Note] WSREP: Member 0.0 (p1vdbs-csbeopms-peopdb-1-01) requested state transfer from 'any', but it is impossible to select State Transfer donor: No donor candidates temporarily available in suitable state
      ......

      Attachments

        Activity

          People

            susil.behera Susil Behera
            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.