Lost triggers in Triggers Page never get resolved

[leonardomachado]

I have 2 triggers in my Triggers page that seems to be somenthing that zabbix has no reference about.
It happend somewhere in past, while I was doing some teste and now the triggers never get out of my Triggers view.

Please, how to I remove those triggers from Triggers page?

I have attached images and below you can see the message I get when I right click the trigger and select "Event".

--------------
Undefined index: groups [include/classes/class.cpagefilter.php:245]array_keys() expects parameter 1 to be array, null given [include/classes/class.cpagefilter.php:252]reset() expects parameter 1 to be array, null given [include/classes/class.cpagefilter.php:253]pg_query(): Query failed: ERROR: invalid input syntax for integer: ""
LINE 1: ...h.hostid,h.host FROM hosts h WHERE (h.hostid IN ('')) AND ...
^ [include/db.inc.php:430]Error in query [SELECT h.hostid,h.host FROM hosts h WHERE (h.hostid IN ('')) AND h.hostid BETWEEN 000000000000000 AND 099999999999999 AND h.status IN (0,1,3)] [ERROR: invalid input syntax for integer: ""
LINE 1: ...h.hostid,h.host FROM hosts h WHERE (h.hostid IN ('')) AND ...
^]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 g.groupid,hg.hostid FROM groups g,hosts_groups hg WHERE g.groupid BETWEEN 000000000000000 AND 099999999999999 AND 1=0 AND hg.groupid=g.groupid] [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]

[rutkowsky]

I have the same problem.


Undefined index: groups [include/classes/class.cpagefilter.php:245]
array_keys() [<a href='function.array-keys'>function.array-keys</a>]: The first argument should be an array [include/classes/class.cpagefilter.php:252]
reset() [<a href='function.reset'>function.reset</a>]: Passed variable is not an array or object [include/classes/class.cpagefilter.php:253]

[leoh]

I had to delete the alarm from the database, manually!!

This is quite strange, isn't it?

There should be an option to close a trigger, or reset the event to a normal situation.

My trigger console is getting filled with old lost events. Please Zabbix dev team, allow us to close open triggers or reset their state!


Thanks.

[rutkowsky]

Could you tell me which one table store this this data?