[ZBX-14598] –Error in query [SELECT g.groupid,g.name FROM groups g... Created: 2018 Jul 12  Updated: 2018 Jul 12  Resolved: 2018 Jul 12

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Incident report Priority: Major
Reporter: Wei Zhang Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

CentOS Linux release 7.4.1708 (Core);
mysql-community-server-8.0.11-1.el7.x86_64;
zabbix_server (Zabbix) 3.4.11 Revision 82160;

Attachments: PNG File zabbix-screen.PNG     PNG File zabbix-server_log.PNG     PNG File zabbix_query.PNG    
Issue Links:
Duplicate
is duplicated by ZBXNEXT-4569 "groups" (8.0.2) and "function" (8.0.... Closed

 Description   

Steps to reproduce:

  1. After installed mysql and Zabbix-server, once start Zabbix-server;
  2. tail -f /var/log/zabbix/zabbix_server.log ==>
  3. ... query failed: [1064] 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 'groups' at line 1 .[+select groupid,name from groups+]..
  4. i've run " mysql -uzabbix -p " to query manually, the same error. The "groups" looks like keyword. i have to use "select groupid,name from zabbix.groups";

Result:
See screenshot...
Expected:

 Comments   
Comment by Alexey Pustovalov [ 2018 Jul 12 ]

What Zabbix version do you use? Zabbix versions prior 4.0 do not support MySQL 8.0 as described in our documentation.

Comment by Alexey Pustovalov [ 2018 Jul 12 ]

Closed as duplicate of ZBXNEXT-4569

Generated at Tue Apr 23 21:40:01 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.