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: Unresolved
    • Icon: Major Major
    • 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

      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.

            zabbix.dev Zabbix Development Team
            JKKim Kim Jongkwon
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: