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

    • Type: Problem report
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 4.0.17
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      Server/Frontend 4.0.X
      PgSQL 9.6
    • Team:
      Team A
    • Sprint:
      Sprint 61 (Feb 2020), Sprint 62 (Mar 2020)
    • Story Points:
      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

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

              Dates

              Created:
              Updated:
              Resolved: