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

Deadlock on 1 trigger/item update for 30000 hosts

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 4.0.17
    • 4.0.19rc1, 4.4.7rc1, 5.0.0alpha3, 5.0 (plan)
    • Server (S)
    • None
    • Server/Frontend 4.0.X
      PgSQL 9.6
    • Team A
    • Sprint 61 (Feb 2020), Sprint 62 (Mar 2020)
    • 0.125

    Description

      Steps to reproduce:

      1. Install Zabbix 4.0 with >20k NVPS on PgSQL database
      2. Update 1 item/trigger in template assigned to >30000 hosts with Zabbix Server stopped or not stopped;

      Result:
      Deadlock.

      Expected:
      Frontend/Server able to handlee update using segment update, tmp tables, etc.

      Attachments

        Activity

          People

            vso Vladislavs Sokurenko
            edgar.akhmetshin Edgar Akhmetshin
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: