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

Database errors and very low frontend performance with big amount of IT Services

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Critical
    • Resolution: Duplicate
    • 1.8.9
    • None
    • Frontend (F)
    • Debian-based Linux, 2.6.34 kernel, PostgreSQL 8.4.
      Database and Zabbix are installed on two dedicated servers each having 8-core Intel Xeon E5530 and 16Gb RAM.

    Description

      I have created a tree of more than 3800 IT services. Leaf services have triggers linked to them, parent services don't have triggers.
      Maximum depth is 3, i.e. root->parent->child->child. All IT services are set to calculate SLA. No time intervals are set.
      There are two problems.
      1. There are database errors, see the attached postgresql-service.log.gz log file.
      2. It takes 15-25 minutes to generate and load "IT Services" page in "Monitoring" menu.

      Aside of fixing database errors, can "IT Services" page be redesigned to show limited number of IT Services per page?

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              sire Sergey Syreskin
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: