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

Add Host or modify with Templates Zabbix Server or Agent

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Blocker
    • Resolution: Cannot Reproduce
    • 2.1.0
    • None
    • Frontend (F)

    Description

      I'm using Postgresql 9.1, the data.sql, images.sql and schema.sql from pre-zabbix-2.1.0-36549.tar.gz

      Try to change hostname, ip addr , DNS name on "Zabbix server" host, or link one host with template zabbix server or agent Show this message:

      pg_query(): Query failed: ERROR: column "i.flags" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT i.key_,i.flags FROM items i WHERE i.hostid IN ('10047... ^ [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBselect() ? pg_query() in /var/www/html/zabbix/include/db.inc.php:441]
      Error in query [SELECT i.key_,i.flags FROM items i WHERE i.hostid IN ('10047','10001','10001','10047') GROUP BY i.key_ HAVING COUNT(i.itemid)>1] [ERROR: column "i.flags" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT i.key_,i.flags FROM items i WHERE i.hostid IN ('10047... ^]
      pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBfetch() ? pg_fetch_assoc() in /var/www/html/zabbix/include/db.inc.php:578]
      pg_free_result() expects parameter 1 to be resource, boolean given [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBfetch() ? pg_free_result() in /var/www/html/zabbix/include/db.inc.php:579]
      pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBselect() ? pg_query() in /var/www/html/zabbix/include/db.inc.php:441]
      Error in query [SELECT * FROM hosts_templates WHERE hostid='10084'] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
      pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBfetch() ? pg_fetch_assoc() in /var/www/html/zabbix/include/db.inc.php:578]
      pg_free_result() expects parameter 1 to be resource, boolean given [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBfetch() ? pg_free_result() in /var/www/html/zabbix/include/db.inc.php:579]
      pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? get_triggers_by_hostid() ? DBselect() ? pg_query() in /var/www/html/zabbix/include/db.inc.php:441]
      Error in query [SELECT DISTINCT t.* FROM triggers t,functions f,items i WHERE i.hostid=10047 AND f.itemid=i.itemid AND f.triggerid=t.triggerid] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
      pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBfetch() ? pg_fetch_assoc() in /var/www/html/zabbix/include/db.inc.php:578]
      pg_free_result() expects parameter 1 to be resource, boolean given [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBfetch() ? pg_free_result() in /var/www/html/zabbix/include/db.inc.php:579]
      pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBselect() ? pg_query() in /var/www/html/zabbix/include/db.inc.php:441]
      Error in query [SELECT DISTINCT h.host FROM trigger_depends td,functions f,items i,hosts h WHERE (1=0 AND f.triggerid=td.triggerid_up ) AND i.itemid=f.itemid AND h.hostid=i.hostid AND h.hostid NOT IN ('10047','10001') AND h.status=3] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
      pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBfetch() ? pg_fetch_assoc() in /var/www/html/zabbix/include/db.inc.php:578]
      pg_free_result() expects parameter 1 to be resource, boolean given [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBfetch() ? pg_free_result() in /var/www/html/zabbix/include/db.inc.php:579]
      pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? get_triggers_by_hostid() ? DBselect() ? pg_query() in /var/www/html/zabbix/include/db.inc.php:441]
      Error in query [SELECT DISTINCT t.* FROM triggers t,functions f,items i WHERE i.hostid=10001 AND f.itemid=i.itemid AND f.triggerid=t.triggerid] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
      pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBfetch() ? pg_fetch_assoc() in /var/www/html/zabbix/include/db.inc.php:578]
      pg_free_result() expects parameter 1 to be resource, boolean given [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBfetch() ? pg_free_result() in /var/www/html/zabbix/include/db.inc.php:579]
      pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBselect() ? pg_query() in /var/www/html/zabbix/include/db.inc.php:441]
      Error in query [SELECT DISTINCT h.host FROM trigger_depends td,functions f,items i,hosts h WHERE (1=0 AND f.triggerid=td.triggerid_up ) AND i.itemid=f.itemid AND h.hostid=i.hostid AND h.hostid NOT IN ('10047','10001') AND h.status=3] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
      pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBfetch() ? pg_fetch_assoc() in /var/www/html/zabbix/include/db.inc.php:578]
      pg_free_result() expects parameter 1 to be resource, boolean given [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBfetch() ? pg_free_result() in /var/www/html/zabbix/include/db.inc.php:579]
      pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBselect() ? pg_query() in /var/www/html/zabbix/include/db.inc.php:441]
      Error in query [SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10084' AND ht.templateid IN ('10047','10001')] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
      pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBfetch() ? pg_fetch_assoc() in /var/www/html/zabbix/include/db.inc.php:578]
      pg_free_result() expects parameter 1 to be resource, boolean given [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DBfetch() ? pg_free_result() in /var/www/html/zabbix/include/db.inc.php:579]
      pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DB::insert() ? DB::reserveIds() ? DBselect() ? pg_query() in /var/www/html/zabbix/include/db.inc.php:441]
      Error in query [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='hosts_templates' AND field_name='hosttemplateid' FOR UPDATE] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
      pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DB::insert() ? DB::reserveIds() ? DBfetch() ? pg_fetch_assoc() in /var/www/html/zabbix/include/db.inc.php:578]
      pg_free_result() expects parameter 1 to be resource, boolean given [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DB::insert() ? DB::reserveIds() ? DBfetch() ? pg_free_result() in /var/www/html/zabbix/include/db.inc.php:579]
      pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:473 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? DB::insert() ? DB::reserveIds() ? DB::refreshIds() ? DBexecute() ? pg_query() in /var/www/html/zabbix/include/db.inc.php:512]
      Error in query [DELETE FROM ids WHERE nodeid=0 AND table_name='hosts_templates' AND field_name='hosttemplateid'] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
      DBEXECUTE_ERROR

      Attachments

        1. zabbix-2.1.png
          114 kB
          ORX LNK
        2. zabbix-2.1-1.png
          106 kB
          ORX LNK
        3. zabbix-2.1-2.png
          105 kB
          ORX LNK

        Activity

          People

            Unassigned Unassigned
            orxlnk ORX LNK
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: