I recently installed Zabbix 1.6. I set it up to use a postgres database. It is working for the various things that I setup to monitor. The problem I'm having is that I can't seem to delete anything that I have created. The following is an error message for an attempt to delete a host. I have similar problem trying to delete a graph, items, etc. I have yet to be able to determine if this is a zabbix issue or a postgres configuration issue. Any thoughts or suggestions would be appreciated.
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: IN types character varying and integer cannot be matched[/exports/home/zabbix/public_html/include/db.inc.php:390]
Error in query [SELECT DISTINCT actionid FROM conditions WHERE conditiontype=2 AND (value IN (13104,13105,13106,13107,13108,13109,13110,13111,1 3112,13113,13114,13115,13116)) ] [ERROR: IN types character varying and integer cannot be matched]
pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/exports/home/zabbix/public_html/include/db.inc.php:520]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:463]
Error in query [DELETE FROM conditions WHERE conditiontype=2 AND (value IN (13104,13105,13106,13107,13108,13109,13110,13111,1 3112,13113,13114,13115,13116)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:390]
Error in query [SELECT triggerid, description FROM triggers WHERE (triggerid IN (13104,13105,13106,13107,13108,13109,13110,13111,1 3112,13113,13114,13115,13116)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/exports/home/zabbix/public_html/include/db.inc.php:520]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:463]
Error in query [DELETE FROM triggers WHERE (triggerid IN (13104,13105,13106,13107,13108,13109,13110,13111,1 3112,13113,13114,13115,13116)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:390]
Error in query [SELECT selementid FROM sysmaps_elements WHERE (elementid IN (10055)) AND elementtype=0] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/exports/home/zabbix/public_html/include/db.inc.php:520]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:463]
Error in query [DELETE FROM hosts_groups WHERE (hostid IN (10055)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:463]
Error in query [DELETE FROM hosts_templates WHERE (hostid IN (10055)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:390]
Error in query [SELECT DISTINCT actionid FROM conditions WHERE conditiontype=1 AND (value IN (10055)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/exports/home/zabbix/public_html/include/db.inc.php:520]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:463]
Error in query [DELETE FROM conditions WHERE conditiontype=1 AND (value IN (10055)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:463]
Error in query [DELETE FROM hosts_profiles WHERE (hostid IN (10055)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:463]
Error in query [DELETE FROM hosts_profiles_ext WHERE (hostid IN (10055)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:390]
Error in query [SELECT DISTINCT ht.* FROM httptest ht, applications ap WHERE (ap.hostid IN (10055)) AND ht.applicationid=ap.applicationid] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/exports/home/zabbix/public_html/include/db.inc.php:520]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:463]
Error in query [DELETE FROM hosts WHERE (hostid IN (10055)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: IN types character varying and integer cannot be matched[/exports/home/zabbix/public_html/include/db.inc.php:390]
Error in query [SELECT DISTINCT actionid FROM conditions WHERE conditiontype=2 AND (value IN (13104,13105,13106,13107,13108,13109,13110,13111,1 3112,13113,13114,13115,13116)) ] [ERROR: IN types character varying and integer cannot be matched]
pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/exports/home/zabbix/public_html/include/db.inc.php:520]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:463]
Error in query [DELETE FROM conditions WHERE conditiontype=2 AND (value IN (13104,13105,13106,13107,13108,13109,13110,13111,1 3112,13113,13114,13115,13116)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:390]
Error in query [SELECT triggerid, description FROM triggers WHERE (triggerid IN (13104,13105,13106,13107,13108,13109,13110,13111,1 3112,13113,13114,13115,13116)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/exports/home/zabbix/public_html/include/db.inc.php:520]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:463]
Error in query [DELETE FROM triggers WHERE (triggerid IN (13104,13105,13106,13107,13108,13109,13110,13111,1 3112,13113,13114,13115,13116)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:390]
Error in query [SELECT selementid FROM sysmaps_elements WHERE (elementid IN (10055)) AND elementtype=0] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/exports/home/zabbix/public_html/include/db.inc.php:520]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:463]
Error in query [DELETE FROM hosts_groups WHERE (hostid IN (10055)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:463]
Error in query [DELETE FROM hosts_templates WHERE (hostid IN (10055)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:390]
Error in query [SELECT DISTINCT actionid FROM conditions WHERE conditiontype=1 AND (value IN (10055)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/exports/home/zabbix/public_html/include/db.inc.php:520]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:463]
Error in query [DELETE FROM conditions WHERE conditiontype=1 AND (value IN (10055)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:463]
Error in query [DELETE FROM hosts_profiles WHERE (hostid IN (10055)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:463]
Error in query [DELETE FROM hosts_profiles_ext WHERE (hostid IN (10055)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:390]
Error in query [SELECT DISTINCT ht.* FROM httptest ht, applications ap WHERE (ap.hostid IN (10055)) AND ht.applicationid=ap.applicationid] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/exports/home/zabbix/public_html/include/db.inc.php:520]
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/exports/home/zabbix/public_html/include/db.inc.php:463]
Error in query [DELETE FROM hosts WHERE (hostid IN (10055)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
Comment