@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