stuck trigger on dashboard with no host parent

[cvee.it]

Since upgrading to Zabbix 3.0.1 from 2.4.x at a client site I have a trigger stuck on the dashboard.

There is no host associated with the trigger.

Is there a method to go into the db and remove it manually ?


Current Zabbix version is 3.2.3 mysqld Centos 6.

[batchenr]

Since upgrading to Zabbix 3.0.1 from 2.4.x at a client site I have a trigger stuck on the dashboard.

There is no host associated with the trigger.

Is there a method to go into the db and remove it manually ?


Current Zabbix version is 3.2.3 mysqld Centos 6.

try to go to the item itself and do "clear history and trends"
or try to disable this triiger and enable it
you can check at the DB if you have a blenk host like this :

mysql -D zabbixdb -N -s -e "select * from interface"

[cvee.it]

stuck trigger on dashboard with no host parent

Unfortunately no luck. All interfaces populated.

There is no specific host to attempt trigger disable.

I found the source template of the trigger, one I likely un-linked and cleared, however there is no host associated at all with this template now ( as it should be). Its some SNMP_v2 template from a predecessor.

And on this template I found all triggers are in a disabled state.

I still lack a host to manipulate on this orphaned dashboard trigger.

[batchenr]

Unfortunately no luck. All interfaces populated.

There is no specific host to attempt trigger disable.

I found the source template of the trigger, one I likely un-linked and cleared, however there is no host associated at all with this template now ( as it should be). Its some SNMP_v2 template from a predecessor.

And on this template I found all triggers are in a disabled state.

I still lack a host to manipulate on this orphaned dashboard trigger.

can you try to delete this template ? (export it asaid so you can return it.)

try maybe run a mysql repair :
mysqlcheck --auto-repair --all-databases -o

[cvee.it]

Deletion did nothing, as expected.

DB check in progress.

[batchenr]

Deletion did nothing, as expected.

DB check in progress.

update us