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

innodb_fatal_semaphore_wait_threshold was

    XMLWordPrintable

Details

    • Bug
    • Status: Needs Feedback (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 11.4.9
    • None
    • None
    • Ubuntu 22.04.5 LTS

    Description

      When inserting a mariadb dump, we get this error

      {{Feb 27 04:29:22 my_app mariadbd[4199]: 2026-02-27 4:29:22 0 [ERROR] [FATAL] InnoDB: innodb_fatal_semaphore_wait_threshold was exceeded for dict_sys.latch. Please refer to https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/

      Feb 27 04:29:22 my_app mariadbd[4199]: -------------------
      Feb 27 04:29:22 my_app mariadbd[4199]: Pending Write: 5
      Feb 27 04:29:22 my_app mariadbd[4199]: Pending Read : 0
      Feb 27 04:29:22 my_app mariadbd[4199]: -------------------
      Feb 27 04:29:22 my_app mariadbd[4199]: 2026-02-27 4:29:22 0 [Note] InnoDB: Pending IO count
      Feb 27 04:29:22 my_app mariadbd[4199]: -------------------
      Feb 27 04:29:22 my_app mariadbd[4199]: Capacity : 90585908
      Feb 27 04:29:22 my_app mariadbd[4199]: Max Age(Sync) : 80819529
      Feb 27 04:29:22 my_app mariadbd[4199]: Max Age(Async): 70717088
      Feb 27 04:29:22 my_app mariadbd[4199]: Current Age : 80824159 : 100%
      Feb 27 04:29:22 my_app mariadbd[4199]: -------------------
      Feb 27 04:29:22 my_app mariadbd[4199]: 2026-02-27 4:29:22 0 [Note] InnoDB: LSN age parameters
      Feb 27 04:29:22 my_app mariadbd[4199]: -------------------
      Feb 27 04:29:22 my_app mariadbd[4199]: Flush Sync LSN: 990535340327
      Feb 27 04:29:22 my_app mariadbd[4199]: Flush ASync LSN: 990535333878
      Feb 27 04:29:22 my_app mariadbd[4199]: Checkpoint LSN: 990525233255
      Feb 27 04:29:22 my_app mariadbd[4199]: System LSN : 990606057414
      Feb 27 04:29:22 my_app mariadbd[4199]: -------------------
      Feb 27 04:29:22 my_app mariadbd[4199]: 2026-02-27 4:29:22 0 [Note] InnoDB: LSN flush parameters
      Feb 27 04:29:22 my_app mariadbd[4199]: -------------------
      Feb 27 04:29:22 my_app mariadbd[4199]: Dirty Pages: 6703 : 1%
      Feb 27 04:29:22 my_app mariadbd[4199]: Free Pages : 1139
      Feb 27 04:29:22 my_app mariadbd[4199]: LRU Pages : 388237
      Feb 27 04:29:22 my_app mariadbd[4199]: -------------------
      Feb 27 04:29:22 my_app mariadbd[4199]: 2026-02-27 4:29:22 0 [Note] InnoDB: Buffer Pool pages
      Feb 27 04:26:52 my_app mariadbd[4199]: 2026-02-27 4:26:52 0 [Warning] InnoDB: Long wait (450 seconds) for dict_sys.latch
      Feb 27 04:24:22 my_app mariadbd[4199]: 2026-02-27 4:24:22 0 [Warning] InnoDB: Long wait (300 seconds) for dict_sys.latch
      Feb 27 04:21:52 my_app mariadbd[4199]: 2026-02-27 4:21:52 0 [Warning] InnoDB: Long wait (150 seconds) for dict_sys.latch
      }}

      Attachments

        Activity

          People

            Unassigned Unassigned
            si@biblibre.com biblibre si
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.