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

Possible lock itservices processing

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.3
    • Fix Version/s: 2.0.12rc3, 2.2.4rc1, 2.3.0
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      Oracle

      Description

      May 6 22:55:15 zabbix_server[8887]: In DBupdate_itservices()
      May 6 22:55:15 zabbix_server[8887]: In its_flush_updates()
      May 6 22:55:15 zabbix_server[8887]: In its_load_services_by_triggerids()
      May 6 22:55:15 zabbix_server[8887]: query [txnlev:1] [select serviceid,triggerid,status,algorithm from services where triggerid in (19407,1237656,1237662,1237959,1238091,1238207,1238264,1238409,1238434,1238679,1238705,1238733,1690422,1705162)]
      May 6 22:55:15 zabbix_server[8887]: In its_itservices_load_parents()
      May 6 22:55:15 zabbix_server[8887]: query [txnlev:1] [select s.serviceid,s.status,s.algorithm,sl.servicedownid from services s,services_links sl where s.serviceid=sl.serviceupid and sl.servicedownid in (28,29,30,32)]
      May 6 22:55:15 zabbix_server[8887]: In its_itservices_load_parents()
      May 6 22:55:15 zabbix_server[8887]: query [txnlev:1] [select s.serviceid,s.status,s.algorithm,sl.servicedownid from services s,services_links sl where s.serviceid=sl.serviceupid and sl.servicedownid in (13,14,15,31)]
      May 6 22:55:15 zabbix_server[8887]: In its_itservices_load_parents()
      May 6 22:55:15 zabbix_server[8887]: query [txnlev:1] [select s.serviceid,s.status,s.algorithm,sl.servicedownid from services s,services_links sl where s.serviceid=sl.serviceupid and sl.servicedownid=12]
      May 6 22:55:15 zabbix_server[8887]: End of its_itservices_load_parents()
      May 6 22:55:15 zabbix_server[8887]: End of its_itservices_load_parents()
      May 6 22:55:15 zabbix_server[8887]: End of its_itservices_load_parents()
      May 6 22:55:15 zabbix_server[8887]: In its_itservices_load_children()
      May 6 22:55:15 zabbix_server[8887]: query [txnlev:1] [select s.serviceid,s.status,s.algorithm,sl.serviceupid from services s,services_links sl where s.serviceid=sl.servicedownid and sl.serviceupid in (12,13,14,15,31)]
      May 6 22:55:15 zabbix_server[8887]: End of its_itservices_load_children()
      May 6 22:55:15 zabbix_server[8887]: End of its_load_services_by_triggerids()

      and nothing more for a few hours, till server restart

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            dotneft Alexey Pustovalov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: