zabbix report error: trigger already exist in ""

[RocHuang]

when update template, zabbix show error infomation: trigger already existed in "", error detail show in photo1.

I have checked the database of zabbix, to find which have the same name trigger with template and make the confict, but find nothing. The sql is below, and the sql result show in photo2.

select * from `hosts` where hostid in (select hostid from items where itemid in (select itemid from functions where triggerid in (select triggerid from `triggers` where description like '%agent 在3分钟内无法访问%' and templateid is NULL)));



I don't have any idea to fix this problem now, is anyone can help? Thanks a lot...

[RocHuang]

I found if I update any trigger in this template, the error always occur...

[dimir]

Check the template that you are updating, if it has other linked templates.

[RocHuang]

Yes, this template has two linked templates.

[dimir]

Crazy idea, but perhaps one of the linked templates is already linked to this template?

[RocHuang]

You mean these templates may inherit from each other? But I have checked and this two linked templates do not link to any template...

[dimir]

Did you check all non-templated triggers with that name, perhaps there's data corruption in the database:

select triggerid from `triggers` where description like '%agent 在3分钟内无法访问%' and templateid is NULL;

Did you make any manual changes in the database?