[ZBX-14954] Invalid psql query crashes Zabbix SQL server Created: 2018 Oct 04 Updated: 2024 Apr 10 Resolved: 2018 Oct 08 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Server (S) |
| Affects Version/s: | 4.0.0 |
| Fix Version/s: | 4.0.1rc1, 4.2.0alpha1, 4.2 (plan) |
| Type: | Problem report | Priority: | Blocker |
| Reporter: | Shadi KENAN | Assignee: | Andris Zeila |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | actions, database, usability | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||||||
| Team: |  Team A |
||||||||||||||||||||
| Sprint: | Sprint 44 | ||||||||||||||||||||
| Story Points: | 0.25 | ||||||||||||||||||||
| Description |
|
Steps to reproduce:
Result:
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: |
| Comments |
| Comment by Alexey Pustovalov [ 2018 Oct 04 ] |
|
Hello! What PostgreSQL version do you use? |
| Comment by Shadi KENAN [ 2018 Oct 05 ] |
|
Hello,
Thank you for you prompt response, and your help actually, I forgot the database version, I've upgraded to 9.4 and now everything seems fine. My bad, you can go ahead and close the ticket.
Much appreciated |
| Comment by Andris Zeila [ 2018 Oct 05 ] |
|
It still does not work with Oracle (haven't been tested on DB2). So it's going to be fixed anyway. |
| Comment by Andris Zeila [ 2018 Oct 08 ] |
|
Released in:
|
| Comment by Alireza Zabihi [ 2018 Oct 29 ] |
|
Hi dears, How can i donwload zabbix 4.0.1 source ? Thanks in advance |
| Comment by Vladislavs Sokurenko [ 2018 Oct 29 ] |
|
You can download 4.0.1rc2 here 4.0.1 is on it's way. |