Error SQL [Z3005] using PostgreSQL

[ivheror]

Hi all, i got this message error using tail -f /var/log/zabbix/zabbix_server.log

6527:20180913:080653.872 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: syntax error at end of input
LINE 1: ...rid=f.triggerid and f.itemid=i.itemid and i.hostid=10107 and
^
[select t.triggerid,t.templateid from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=10107 and]

Anybody has the same error ??

[Atsushi]

I think it is a bug.
I think that it will be fixed in the next release.

ZBX-14614 : Trigger dependency linked to template instead of host with discovery action

https://support.zabbix.com/browse/ZBX-14614

ZBX-14799 : Fail to link to templates under discovery and registration

https://support.zabbix.com/browse/ZBX-14799

[ivheror]

EDIT: Im using Zabbix 3.0 LTS and 10.2 PostgreSQL

[Atsushi]

As bug fixes are done with minor revisions, I strongly recommend that you present detailed versions, not just major versions such as Zabbix 3.0.

ex. Zabbix 3.0.21

[ivheror]

It is Zabbix 3.0.21 the thing is im trying to correctly installing with auto registration but when i see log i got this:

[select t.triggerid,t.templateid from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=10107 and]
4866:20180914:083336.508 cannot send list of active checks to "192.168.10.7": host [icea-varnish] not found
4865:20180914:083430.817 cannot send list of active checks to "192.168.10.6": host [icea-frontend] not found
4867:20180914:083436.617 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: syntax error at end of input
LINE 1: ...rid=f.triggerid and f.itemid=i.itemid and i.hostid=10107 and
^
[select t.triggerid,t.templateid from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=10107 and]

[Atsushi]

It is a bug if you are using 3.0.21.
For details, refer to the above URL.
It should have been fixed if version upgrading to 3.0.22.

[adriandc]

In version 4.0.3 receding this same error