Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-25397

Deadlock SQL Issue Maintenance on Timer Process (event_suppress)

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Fixed
    • Icon: Major Major
    • 6.0.36rc1, 7.0.6rc1, 7.2.0beta1
    • 6.0.34
    • Server (S)
    • None
    • Zabbix 6.0.13
      8.0.mysql_aurora.3.05.2(compatible with MySQL 8.0.32)
    • S24-W44/45
    • 1

      We are encountering deadlocks during maintenance tasks. The deadlock occurs specifically during the insertion into the event_suppress table.

      9605:20241005:000008.436 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [insert into event_suppress (event_suppressid,eventid,maintenanceid,suppress_until) values (6812841,1781,11,1728061200),(6812842,214521,163,1728055800),(6812843,220626,163,1728055800),(6812844,220661,163,1728055800) ......

      Many unclosed problem events and frequent maintenance tasks are contributing to this issue.
      We suspect that having multiple event IDs, each associated with many maintenance tasks, is causing delays and contributing to the deadlock issue.

      Please check if this issue is being investigated and if any fixes are available.

        1. LATEST DETECTED DEADLOCK(1).txt
          14 kB
        2. LATEST DETECTED DEADLOCK(2).txt
          11 kB

            vso Vladislavs Sokurenko
            JKKim Kim Jongkwon
            Team B
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 7h
                7h