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

Galera cluster hangs on Freeing items

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Stalled (View Workflow)
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 10.4.18
    • Fix Version/s: 10.4
    • Component/s: Galera
    • Labels:
      None

      Description

      Hi All, I have a mariadb 10.4.18 galera cluster with 5 node. Randomly on one node hangs a request with "Freeing items" state and "Busy" command. It stops all the write queries on all nodes forever. I have to kill mariadb on the hanging node, because I can't stop it normal way. After kill, other nodes start working correctly. After restart full SST required. Error log is empty. Query cache is off. my.cnf attached.

      Process list:
      ----------------------------------------------------------
      ID: 19717900
      USER: xxx
      HOST: xxx:44464
      DB:
      COMMAND: Busy
      TIME: 28
      STATE: Freeing items
      INFO:
      TIME_MS: 28497.852
      STAGE: 0
      MAX_STAGE: 0
      PROGRESS: 0.000
      MEMORY_USED: 82232
      MAX_MEMORY_USED: 178320
      EXAMINED_ROWS: 1
      QUERY_ID: 1328408265
      INFO_BINARY:
      TID: 36964
      ----------------------------------------------------------
      ID: 23
      USER: system user
      HOST:
      DB:
      COMMAND: Busy
      TIME: 28
      STATE: committing
      INFO:
      TIME_MS: 28496.583
      STAGE: 0
      MAX_STAGE: 0
      PROGRESS: 0.000
      MEMORY_USED: 65136
      MAX_MEMORY_USED: 81584
      EXAMINED_ROWS: 0
      QUERY_ID: 1328408270
      INFO_BINARY:
      TID: 12877
      ----------------------------------------------------------

      Please help.

        Attachments

        1. Command counters 10.5.9 vs 10.5.6.png
          Command counters 10.5.9 vs 10.5.6.png
          171 kB
        2. gdb2.log
          2.19 MB
        3. my.cnf
          2 kB

          Issue Links

            Activity

              People

              Assignee:
              seppo Seppo Jaakola
              Reporter:
              koczanakos Kóczán Ákos
              Votes:
              16 Vote for this issue
              Watchers:
              24 Start watching this issue

                Dates

                Created:
                Updated: