-
Problem report
-
Resolution: Unresolved
-
Trivial
-
7.0.5
-
None
-
postgres 16, timescale
-
Sprint candidates
Steps to reproduce:
it happens always, postgres log full of errors. Can't find reason of that.
Result:
@zabbix ERROR: syntax error at or near "AND" at character 976 @zabbix STATEMENT: SELECT DISTINCT i.itemid,i.type,i.snmp_oid,i.hostid,i.name,i.key_,i.delay,i.history,i.trends,i.stat us,i.value_type,i.trapper_hosts,i.units,i.formula,i.logtimefmt,i.templateid,i.valuemapid,i.ipmi_sensor,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i. interfaceid,i.inventory_link,i.lifetime,i.evaltype,i.jmx_endpoint,i.master_itemid,i.timeout,i.url,i.status_codes,i.follow_redirects,i.post_type,i.http_proxy,i.retrieve_mod e,i.request_method,i.output_format,i.ssl_cert_file,i.ssl_key_file,i.ssl_key_password,i.verify_peer,i.verify_host,i.allow_traps,i.discover,i.uuid,i.lifetime_type,i.enabled_ lifetime_type,i.enabled_lifetime,ir.state,COALESCE(ir.error,'') AS error,COALESCE(irn.name_resolved,'') AS name_resolved FROM host_hgset hh,permission p,items i LEFT JOIN item_rtdata ir ON i.itemid=ir.itemid LEFT JOIN item_rtname irn ON i.itemid=irn.itemid WHERE i.type<>9 AND i.flags IN (0,4) AND i.hostid=hh.hostid AND hh.hgsetid=p.hgsetid AND p.ugsetid=1 AND AND EXISTS (SELECT NULL FROM functions ff,triggers t WHERE i.itemid=ff.itemid AND ff.triggerid=t.triggerid AND t.flags IN (0,4)) @zabbix ERROR: syntax error at or near "AND" at character 976 @zabbix STATEMENT: SELECT DISTINCT i.itemid,i.type,i.snmp_oid,i.hostid,i.name,i.key_,i.delay,i.history,i.trends,i.stat us,i.value_type,i.trapper_hosts,i.units,i.formula,i.logtimefmt,i.templateid,i.valuemapid,i.ipmi_sensor,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i. interfaceid,i.inventory_link,i.lifetime,i.evaltype,i.jmx_endpoint,i.master_itemid,i.timeout,i.url,i.status_codes,i.follow_redirects,i.post_type,i.http_proxy,i.retrieve_mod e,i.request_method,i.output_format,i.ssl_cert_file,i.ssl_key_file,i.ssl_key_password,i.verify_peer,i.verify_host,i.allow_traps,i.discover,i.uuid,i.lifetime_type,i.enabled_ lifetime_type,i.enabled_lifetime,ir.state,COALESCE(ir.error,'') AS error,COALESCE(irn.name_resolved,'') AS name_resolved FROM host_hgset hh,permission p,items i LEFT JOIN item_rtdata ir ON i.itemid=ir.itemid LEFT JOIN item_rtname irn ON i.itemid=irn.itemid WHERE i.type<>9 AND i.flags IN (0,4) AND i.hostid=hh.hostid AND hh.hgsetid=p.hgsetid AND p.ugsetid=1 AND AND EXISTS (SELECT NULL FROM functions ff,triggers t WHERE i.itemid=ff.itemid AND ff.triggerid=t.triggerid AND t.flags IN (0,4)) 2024-11-05 10:21:01.183 MSK [981] LOG: checkpoint complete: wrote 21752 buffers (8.6%); 0 WAL file(s) added, 0 removed, 8 recycled; write=269.929 s, sync=0.066 s, total=2 70.023 s; sync files=143, longest=0.009 s, average=0.001 s; distance=128715 kB, estimate=170468 kB; lsn=89/18ECA370, redo lsn=89/1153A140 @zabbix ERROR: syntax error at or near "AND" at character 976 @zabbix STATEMENT: SELECT DISTINCT i.itemid,i.type,i.snmp_oid,i.hostid,i.name,i.key_,i.delay,i.history,i.trends,i.stat us,i.value_type,i.trapper_hosts,i.units,i.formula,i.logtimefmt,i.templateid,i.valuemapid,i.ipmi_sensor,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i. interfaceid,i.inventory_link,i.lifetime,i.evaltype,i.jmx_endpoint,i.master_itemid,i.timeout,i.url,i.status_codes,i.follow_redirects,i.post_type,i.http_proxy,i.retrieve_mod e,i.request_method,i.output_format,i.ssl_cert_file,i.ssl_key_file,i.ssl_key_password,i.verify_peer,i.verify_host,i.allow_traps,i.discover,i.uuid,i.lifetime_type,i.enabled_ lifetime_type,i.enabled_lifetime,ir.state,COALESCE(ir.error,'') AS error,COALESCE(irn.name_resolved,'') AS name_resolved FROM host_hgset hh,permission p,items i LEFT JOIN item_rtdata ir ON i.itemid=ir.itemid LEFT JOIN item_rtname irn ON i.itemid=irn.itemid WHERE i.type<>9 AND i.flags IN (0,4) AND i.hostid=hh.hostid AND hh.hgsetid=p.hgsetid AND p.ugsetid=1 AND AND EXISTS (SELECT NULL FROM functions ff,triggers t WHERE i.itemid=ff.itemid AND ff.triggerid=t.triggerid AND t.flags IN (0,4)) @zabbix ERROR: syntax error at or near "AND" at character 976 @zabbix STATEMENT: SELECT DISTINCT i.itemid,i.type,i.snmp_oid,i.hostid,i.name,i.key_,i.delay,i.history,i.trends,i.stat us,i.value_type,i.trapper_hosts,i.units,i.formula,i.logtimefmt,i.templateid,i.valuemapid,i.ipmi_sensor,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i. interfaceid,i.inventory_link,i.lifetime,i.evaltype,i.jmx_endpoint,i.master_itemid,i.timeout,i.url,i.status_codes,i.follow_redirects,i.post_type,i.http_proxy,i.retrieve_mod e,i.request_method,i.output_format,i.ssl_cert_file,i.ssl_key_file,i.ssl_key_password,i.verify_peer,i.verify_host,i.allow_traps,i.discover,i.uuid,i.lifetime_type,i.enabled_ lifetime_type,i.enabled_lifetime,ir.state,COALESCE(ir.error,'') AS error,COALESCE(irn.name_resolved,'') AS name_resolved FROM host_hgset hh,permission p,items i LEFT JOIN item_rtdata ir ON i.itemid=ir.itemid LEFT JOIN item_rtname irn ON i.itemid=irn.itemid WHERE i.type<>9 AND i.flags IN (0,4) AND i.hostid=hh.hostid AND hh.hgsetid=p.hgsetid AND p.ugsetid=1 AND AND EXISTS (SELECT NULL FROM functions ff,triggers t WHERE i.itemid=ff.itemid AND ff.triggerid=t.triggerid AND t.flags IN (0,4)) 2024-11-05 10:21:31.214 MSK [981] LOG: checkpoint starting: time