How to Fix MySQL: Failed to Fetch Info Data (or No Data for 30m) Alert

When managing a Zabbix monitoring environment, encountering errors such as "Failed to fetch info data" or experiencing no data for extended periods can be challenging. This guide walks you through the steps to troubleshoot and resolve these issues, ensuring your monitoring system regains its full operational capabilities.

Preparing for Troubleshooting

Before diving into the troubleshooting steps, ensure you have administrative access to both the Zabbix server and the MySQL server. It's also important to have a basic understanding of navigating the Linux command line, as well as some familiarity with MySQL user permissions.

Troubleshooting Steps

Step 1: Verify the Zabbix MySQL Template File

Check for the MySQL Template

SSH into your server.
Navigate to the directory /etc/zabbix/zabbix_agentd.d.
Check if the MySQL template file (template_db_mysql.conf) is present. If not, it will need to be added.

This step is crucial as the template file contains necessary configurations for monitoring MySQL performance metrics.

Step 2: Ensure Zabbix User Can Log into MySQL

Checking MySQL User Login

Go to /etc/zabbix/ and open .my.cnf to find the MySQL user details used by Zabbix.
Attempt to log into MySQL using the Zabbix user credentials.
If you encounter an access denied error like above, it indicates that the Zabbix user cannot authenticate with MySQL.

This step identifies if there's an authentication issue preventing Zabbix from fetching data from MySQL.

Step 3: Recreate the MySQL User with Proper Permissions

Creating a New MySQL User

Log into MySQL as a root or another user with privilege-creation capabilities.
Create a new user or ensure the existing user has the necessary permissions for Zabbix to function correctly.

Code : CREATE USER 'zbx_new'@'localhost' IDENTIFIED BY 'ZGV%#asd23#';

Granting the correct permissions is essential for Zabbix to access and monitor MySQL databases.

Code : GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD on *.* TO 'zbx_new'@'localhost' WITH GRANT OPTION;

Step 4: Verify User Login and Data Fetching

Testing the New User Credentials

Attempt to log into MySQL again with the newly created or updated user.
If the login is successful, it indicates the permission issues have been resolved.

Successful login with the Zabbix user confirms that the issue preventing data fetching has been addressed.

Step 5: Restart the Zabbix Agent

Finalizing the Configuration

Restart the Zabbix agent to apply the changes and start fresh monitoring sessions.
Monitor Zabbix for successful data fetching from MySQL.

Restarting the Zabbix agent is a crucial step to ensure all configurations are reloaded and applied.

Additional Information

Understanding MySQL Permissions

Understanding and correctly setting MySQL user permissions is vital. Zabbix requires specific permissions to retrieve data, execute queries, and monitor database performance. Ensure the Zabbix user has at least the following permissions: SELECT, SHOW DATABASES, and REPLICATION CLIENT.

Monitoring After Troubleshooting

After completing these steps, monitor the Zabbix dashboard for any errors or alerts related to MySQL monitoring. If the issue persists, double-check each step or consult the Zabbix and MySQL documentation for further troubleshooting tips.

Conclusion

By following these detailed steps, you should be able to resolve the "Failed to fetch info data" or "no data for 30m" alerts in your Zabbix monitoring setup. Regularly checking user permissions, ensuring the correct configuration files are in place, and restarting services when changes are made, are good practices for maintaining a healthy monitoring environment.

MySQL: Failed to fetch info data