[zabbix 1.6] deleting hosts fails with postgres-backend

[tekknokrat]

when trying to delete a host i get this message:

ERROR: Cannot delete host

When looking in postgresql logfile is see this:

http://pastebin.com/m7ad590a9

I can also run this to get the error message.

SELECT DISTINCT actionid FROM conditions  WHERE conditiontype=2 AND  (value IN (13000,13001,13003,13004,13005,13006,13009,13010,13011,13012,13013,13014,13015,13016,13018,13019,13020,13021,13022,13023,13024,13025,13026,13027,13028,13029,13030,13031,13032,13033,13034,13035,13036,13037,13038,13039,13040,13041,13042,13043,13002,13007,13008,13017));

ERROR: IN types character varying and integer cannot be matched

Using recent hardy with postgresql-8.3

[Alexei]

Thanks for reporting this. It is registered as ZBX-474.

[stalker]

same problem. delete function not functional with postgresql database. Mysql not tested:

    * pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: IN типы character varying и integer не совпадают[/usr/share/zabbix/include/db.inc.php:390]
    * Error in query [SELECT DISTINCT actionid FROM conditions WHERE conditiontype=2 AND (value IN (13027,13028,13029,13030,13031,13032,13033,13034,13035,13036,13037,13038,13039,13040,13041,13042,13043,13044,13045,13046,13047,13048,13049,13050,13051,13052)) ] [ERROR: IN типы character varying и integer не совпадают]
    * pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/share/zabbix/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[/usr/share/zabbix/include/db.inc.php:463]
    * Error in query [DELETE FROM conditions WHERE conditiontype=2 AND (value IN (13027,13028,13029,13030,13031,13032,13033,13034,13035,13036,13037,13038,13039,13040,13041,13042,13043,13044,13045,13046,13047,13048,13049,13050,13051,13052)) ] [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[/usr/share/zabbix/include/db.inc.php:390]
    * Error in query [SELECT triggerid, description FROM triggers WHERE (triggerid IN (13027,13028,13029,13030,13031,13032,13033,13034,13035,13036,13037,13038,13039,13040,13041,13042,13043,13044,13045,13046,13047,13048,13049,13050,13051,13052)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
    * pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/share/zabbix/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[/usr/share/zabbix/include/db.inc.php:463]
    * Error in query [DELETE FROM triggers WHERE (triggerid IN (13027,13028,13029,13030,13031,13032,13033,13034,13035,13036,13037,13038,13039,13040,13041,13042,13043,13044,13045,13046,13047,13048,13049,13050,13051,13052)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]

[Aly]

Fixed in the latest code from SVN.

[stalker]

The problem with removal of triggers is solved, but items it is impossible to delete. Error messages are not present.

[Aly]

Deleting items fixed too. Thank you.

[stalker]

It works!
Thank you.

[tekknokrat]

works, thanks for fast fixing