[ZBX-16462] Services IT : Error in query Created: 2019 Aug 05 Updated: 2024 Apr 10 Resolved: 2019 Aug 16 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Frontend (F) |
| Affects Version/s: | 4.0.11, 4.2.5 |
| Fix Version/s: | 4.0.12rc1, 4.2.6rc1, 4.4.0alpha2, 4.4 (plan) |
| Type: | Problem report | Priority: | Trivial |
| Reporter: | Romain SICAUD | Assignee: | Andrejs Griščenko |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | frontend | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Ubuntu 14.04.6 LTS with Zabbix Appliance 4.2.5 - MySql 5.7.26 |
||
| Attachments: |
Capture.PNG
SSH1.jpg
SSH2.jpg
SSH3.jpg
SSH4.jpg
SSH5.jpg
|
| Team: | Team D |
| Team: |  Team D |
| Sprint: | Sprint 55 (Aug 2019) |
| Story Points: | 0.125 |
| Description |
|
Hi, on the zabbix webUI interface, when I go to IT services and click on a HostTrigger, I get errors for all services: Error in query [SELECT sa.serviceid,sa.value FROM (SELECT sa2.serviceid,MAX(sa2.servicealarmid) AS servicealarmid FROM service_alarms sa2 WHERE sa2.clock<'1546210800' AND sa2.serviceid=570GROUP BY sa2.serviceid) ss2 JOIN service_alarms sa ON sa.servicealarmid = ss2.servicealarmid] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY sa2.serviceid) ss2 JOIN service_alarms sa ON sa.servicealarmid = ss2.service' at line 1] Thank you in advance. |
| Comments |
| Comment by DaneT [ 2019 Aug 05 ] |
|
Issue is also present on Zabbix 4.0.11 running on Centos 7.6-1810 with MariaDB 10.4.7 Issue NOT present on Zabbix 4.0.10 running on Centos 7.6-1810 with MariaDB 10.4.7 |
| Comment by Andrejs Griščenko [ 2019 Aug 06 ] |
|
Resolved in development branch feature/ZBX-16462-4.0 |
| Comment by Andrejs Griščenko [ 2019 Aug 09 ] |
|
Fixed in: |
| Comment by Byron [ 2019 Aug 14 ] |
|
When is the next final release with this bug is solved. How can i fix it.
|
| Comment by Andrejs Griščenko [ 2019 Aug 14 ] |
|
rediumbv, the release of RC versions is scheduled for next week. If you can't wait, you can easily fix it yourself. See the changes here. |
| Comment by Byron [ 2019 Aug 14 ] |
|
Thank you. The issue is solved.
|