[ZBX-18039] zabbix-agent2 mysql status monitoring Created: 2020 Jul 09 Updated: 2024 Apr 10 Resolved: 2022 Nov 21 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Agent (G) |
Affects Version/s: | 5.0.1 |
Fix Version/s: | None |
Type: | Problem report | Priority: | Trivial |
Reporter: | Mohammad Awis Rusli | Assignee: | Eriks Sneiders |
Resolution: | Cannot Reproduce | Votes: | 4 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified | ||
Environment: |
Centos 8, MariaDB |
Attachments: |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
||||||||||||
Issue Links: |
|
||||||||||||
Team: |
Description |
Steps to reproduce:
Result: Real status of MariaDB service on the monitored host: The log below showing the zabbix-agent2 activity 2020/07/09 16:32:35.945539 failed to execute direct exporter task for key 'mysql.get_status_variables["tcp://localhost:3306","<username>","<password>"]' error: 'sql: database is closed' When running the command shown in logs, able to get value of the service running [root@clusternode1-db ~]# zabbix_agent2 -t mysql.ping["tcp://localhost:3306","<username>","<password>"]
Testing from zabbix server template gave different results Expected: |
Comments |
Comment by Renats Valiahmetovs (Inactive) [ 2020 Jul 10 ] |
Hello Mohammad, Thank you for reaching Zabbix public tracker! To clarify, you're having an issue with the template trigger not resolving itself when status of MariaDB is back to normal, correct? If that is the case, is it possible for you to perform another check, by stopping MariaDB again, but this time also send me a screenshot of the item values, just to see what is going on with the collected data before shutting MariaDB down, during and after it's started again. As of now, I am unable to reproduce the issue, unfortunately.
Best Regards, Renats |
Comment by Mohammad Awis Rusli [ 2020 Jul 13 ] |
Hi,
Yes, that's what we are facing right now. Below are the screenshots Before stopping MariaDB services
MariaDB service stopped
MariaDB service started back; Zabbix still showing down |
Comment by Renats Valiahmetovs (Inactive) [ 2020 Jul 13 ] |
Good morning Mohammad, I will also need a screenshot of this item configuration. Please do not forget to omit sensitive information regarding your environment. And provide your zabbix_agentd.log file located on your DB host machine. Best Regards, Renats |
Comment by Mohammad Awis Rusli [ 2020 Jul 13 ] |
Hi,
Attached are the configuration and log files for. We are using Zabbix Agent 2 for this setup. |
Comment by Renats Valiahmetovs (Inactive) [ 2020 Jul 14 ] |
Dear Mohammad, I have successfully replicated the issue and it will be passed to our development team.
Best Regards, |
Comment by John Wayne [ 2020 Sep 11 ] |
@rvaliahmetovs I can confirm this as well and it seems to be still a problem on `5.0.3`. Do you have any ETA when a fix will be available? Is still a problem on the agent2 or the MySQL agent2 template? |
Comment by Christoph Fischer [ 2021 Jan 25 ] |
I can also confirm this issue under Zabbix 5.0.x with newest template version. Thank you for your investigation. |
Comment by Stev Leibelt [ 2021 Apr 21 ] |
Glad to read that I am not alone.
I just did some checks. I can log in as zabbix user on the machine. I can log in as the zabbix user from a different machine (my.cnf bind-address = 0.0.0.0). But the "MySQL: Service is down" stays the same. |
Comment by Juri Malinovski [ 2021 Jul 06 ] |
@Vadim Ipatov any news from you? Jule 06 2021 |
Comment by dimir [ 2021 Jul 06 ] |
He's not working for Zabbix any more, but I'll try to get this one some attention. |