Autoreg Host - Lock on event

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Major
    • None
    • Affects Version/s: 2.0.15
    • Component/s: Server (S)
    • None
    • Environment:
      postgres 9.3 , zabbix 2.0.4

      Hello ,

      we are having performance problem on our zabbix server running in 2.0.4

      we have wait on the famous : update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid'

      Actually we have more than 60 000 autoreg events per day ( object=3 in event table) and it potentially lead to locks on the above request.

      We do not use auto-registration, so is there a way to disable logging autoregistration request which are useless.

      I mean, we have no autoregistration action configured, but even throught that we have auto-registration events logged in the database which can lead to useless sharelocks

      and by the way , it would be nice to be able to disable this record from a parameter in the defines.inc ?

      thanks for your response

            Assignee:
            Unassigned
            Reporter:
            thierry regis
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: