Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-25505

syntax error at or near "AND" at character 976

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • 7.0.7rc1, 7.2.0rc1 (master)
    • 7.0.5
    • API (A)
    • 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
      

       

       

            agriscenko Andrejs Griščenko
            Tristis Oris Tristis Oris
            Team C
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated: