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

problem creating and managing IT services

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 2.0.0
    • Frontend (F)
    • ubuntu 12.04
      postgresql 9.1.4
      php5 5.3.10

      Initially trying to create new it services result in a blank page .

      After looking for error on application server found out

      2012-07-17 16:43:05: (mod_fastcgi.c.2701) FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in /var/www/include/db.inc.php on line 565
      so I raise memory_limit = 256M in php.ini

      on second run got
      2012-07-17 17:08:39: (mod_fastcgi.c.2701) FastCGI-stderr: PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes) in /var/www/api/classes/CTrigger.php on line 666

      raise againg memory to unsane value of 512M seems to solve the problem .

      So I create a service.

      After the creation of services I got a red box containing

      pg_query(): Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
      LINE 1: ...9999999 AND sl.servicedownid=s.serviceid ORDER BY s.sortorde...
      ^ [include/db.inc.php:430]
      Error in query [SELECT DISTINCT sl.linkid,sl.servicedownid,sl.soft,sl.serviceupid FROM services_links sl,services s WHERE ( (sl.serviceupid IN ('1')) ) AND sl.linkid BETWEEN 000000000000000 AND 099999999999999 AND sl.servicedownid=s.serviceid ORDER BY s.sortorder, s.serviceid] [ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
      LINE 1: ...9999999 AND sl.servicedownid=s.serviceid ORDER BY s.sortorde...
      ^]
      pg_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:565]
      pg_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:566]
      pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [include/db.inc.php:430]
      Error in query [SELECT DISTINCT s.* FROM services s,services_links slc WHERE s.serviceid=slc.serviceupid AND slc.soft=0 AND (slc.servicedownid IN ('1')) AND s.serviceid BETWEEN 000000000000000 AND 099999999999999] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
      pg_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:565]
      pg_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:566]
      pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [include/db.inc.php:430]
      Error in query [SELECT t.triggerid,t.description FROM triggers t WHERE (t.triggerid IN ('27989')) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
      pg_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:565]
      pg_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:566]
      Undefined index: 27989 [api/classes/CService.php:1553]

      every time I go to it services (from configuration or monitorig) see attached screenshot

            Unassigned Unassigned
            renato.ramonda Renato Ramonda
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: