[ZBX-18888] Zabbix Server Crashed when using database monitor Created: 2021 Jan 15  Updated: 2021 Jan 19  Resolved: 2021 Jan 18

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 5.0.7
Fix Version/s: None

Type: Incident report Priority: Trivial
Reporter: 张浩水 Assignee: Zabbix Support Team
Resolution: Won't fix Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File Screen Shot 2021-01-15 at 10.51.11 PM.png     PNG File Screen Shot 2021-01-15 at 10.52.04 PM.png     PNG File Screen Shot 2021-01-15 at 10.52.09 PM.png     PNG File Screen Shot 2021-01-15 at 10.53.04 PM.png     Text File bktrace.txt    
Issue Links:
Duplicate
duplicates ZBX-7665 Zabbix 2.2.1 ODBC monitor crash - in ... Closed

 Description   

Steps to reproduce:

  1. CentOS 7.9 MySQL 8.0.22 Zabbix 5.0.7 mysql-connector-odbc 5.3.9
  2. check using isql is OK
  3. add database monitor item
  4. Click test, then get vaule
  5. Zabbix Server Crash

Result:

Zabbix Server Crash

See screenshot

 Comments   
Comment by Edgar Akhmetshin [ 2021 Jan 18 ]

Hello,

MySQL 8.0 version requires new mysql-connector-odbc 8.0 library provided by upstream:
https://dev.mysql.com/downloads/connector/odbc/

Otherwise this is related to ZBX-7665 and the following upstream problems:
https://bugs.mysql.com/bug.php?id=73709
https://mariadb.atlassian.net/browse/MDEV-9414
https://jira.mariadb.org/browse/MDEV-9380

Closing as a duplicate for ZBX-7665.

Regards,
Edgar

Comment by 张浩水 [ 2021 Jan 19 ]

I changed the mysql-connector-odbc version to 8.0.23. The server still crashed. So as a conclusion, mysql-connector-odbc version 5.2.7 may be the lastest compatible driver.

i think  for mysql 8.0 , unixodbc may not be the recommended mysql monitor method, userdefined or zabbix-agent2 method is recommended.

Generated at Tue Apr 01 06:33:04 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.