-
Incident report
-
Resolution: Cannot Reproduce
-
Blocker
-
None
-
2.1.0
-
CentOS release 6.4 (Final)
httpd-2.2.15-28.el6.centos.x86_64
postgresql91-libs-9.1.9-1PGDG.rhel6.x86_64
postgresql91-9.1.9-1PGDG.rhel6.x86_64
postgresql91-odbc-09.00.0310-1PGDG.rhel6.x86_64
postgresql91-devel-9.1.9-1PGDG.rhel6.x86_64
postgresql91-jdbc-9.1.903-1PGDG.rhel6.x86_64
postgresql91-server-9.1.9-1PGDG.rhel6.x86_64
php-cli-5.3.3-22.el6.x86_64
php-gd-5.3.3-22.el6.x86_64
php-bcmath-5.3.3-22.el6.x86_64
php-odbc-5.3.3-22.el6.x86_64
php-pgsql-5.3.3-22.el6.x86_64
php-common-5.3.3-22.el6.x86_64
php-5.3.3-22.el6.x86_64
php-pdo-5.3.3-22.el6.x86_64
php-mbstring-5.3.3-22.el6.x86_64
php-xml-5.3.3-22.el6.x86_64
CentOS release 6.4 (Final) httpd-2.2.15-28.el6.centos.x86_64 postgresql91-libs-9.1.9-1PGDG.rhel6.x86_64 postgresql91-9.1.9-1PGDG.rhel6.x86_64 postgresql91-odbc-09.00.0310-1PGDG.rhel6.x86_64 postgresql91-devel-9.1.9-1PGDG.rhel6.x86_64 postgresql91-jdbc-9.1.903-1PGDG.rhel6.x86_64 postgresql91-server-9.1.9-1PGDG.rhel6.x86_64 php-cli-5.3.3-22.el6.x86_64 php-gd-5.3.3-22.el6.x86_64 php-bcmath-5.3.3-22.el6.x86_64 php-odbc-5.3.3-22.el6.x86_64 php-pgsql-5.3.3-22.el6.x86_64 php-common-5.3.3-22.el6.x86_64 php-5.3.3-22.el6.x86_64 php-pdo-5.3.3-22.el6.x86_64 php-mbstring-5.3.3-22.el6.x86_64 php-xml-5.3.3-22.el6.x86_64
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
