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

Invalid psql query crashes Zabbix SQL server

    Details

    • Team:
      Team A
    • Sprint:
      Sprint 44
    • Story Points:
      0.25

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                wiper Andris Zeila
                Reporter:
                shadik Shadi KENAN
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: