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

galera applier threads not respect innodb_lock_wait_timeout

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11.14
    • 10.11
    • Galera
    • None
    • Q4/2026 Replic. Maintenance

    Description

      Even with low innodb_lock_wait_timeout values, the lock waiting time is still 50 seconds.

      If in rare corner cases a deadlock happened on replica nodes , which not happened on the write node, master node got "InnoDB: WSREP: BF lock wait long for trx"

      after 50 seconds,

      ------- TRX HAS BEEN WAITING 50000703 us FOR THIS LOCK TO BE GRANTED:
      

      even if innodb_lock_wait_timeout is lower.

      This is counter intuitive and the wait lock time for applier threads should be somehow configurable.

      I created as a bug report, but it might be converted into a feature request , if needed.

      Attachments

        Issue Links

          Activity

            People

              seppo Seppo Jaakola
              Richard Richard Stracke
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 1d 5h 58m
                  1d 5h 58m
                  Remaining:
                  Time Spent - 1h Remaining Estimate - 1d 4h 58m
                  1d 4h 58m
                  Logged:
                  Time Spent - 1h Remaining Estimate - 1d 4h 58m
                  1h

                  Git Integration

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