Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-4680

Add support for table level shared locks

    XMLWordPrintable

    Details

    • Type: New Feature Request
    • Status: Closed
    • Priority: Trivial
    • Resolution: Duplicate
    • Affects Version/s: 4.0.0alpha9
    • Fix Version/s: 4.0.0beta1
    • Component/s: Server (S)
    • Labels:
      None

      Description

      ZBXNEXT-413 added maintenance processing to history syncers (creating event suppress records for problems that matches running maintenances). To avoid foreign key errors (when maintenance is removed by API while still being processed by server) history syncers lock running maintenanances for update in database. This introduces performance bottleneck - when a maintenance period is active history syncers has to process them sequentially.

      To avoid this table based shared locks must be added. When processing maintenances history syncers (and timers) will request shared lock on maintenance table. It will allow parallel maintenance processing by syncers while preventing frontend from maintenance removal.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              wiper Andris Zeila
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: