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

Invalid psql query crashes Zabbix SQL server

XMLWordPrintable

    • Sprint 44
    • 0.25

      Steps to reproduce:

      1. Create a problem
      2. acknowledge problem

      Result:
      Crash with

       

      32375:20181004:171640.828 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  column "e.source" must appear in the GROUP BY clause or be used in an aggregate function
      LINE 1: select e.eventid,e.source,e.object,e.objectid,e.clock,e.valu...
                               ^
       [select e.eventid,e.source,e.object,e.objectid,e.clock,e.value,e.acknowledged,e.ns,e.name,e.severity,max(es.suppress_until) from events e left join event_suppress es on e.eventid=es.eventid where e.eventid
      =27 group by e.eventid order by e.eventid]
       32375:20181004:171640.828 Got signal [signal:11(SIGSEGV),reason:1,refaddr:(nil)]. Crashing ... 
      

      Expected:
       Problem marked acknowledged and an action is triggered

            wiper Andris Zeila
            shadik Shadi KENAN
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: