First off, thank you for taking the time to read this post, and if this is the wrong category, please let me know so that I delete it and repost it in the proper one. I am a first time grafana user and I’ve been following the documentation closely to connect a data source on a dummy server in order to try out grafana. The issue I am facing relates to connecting a MySQL data source, despite quadriple checking that the info on the config matches. The logs are not helpful, hence why I’m here.
- What Grafana version and what operating system are you using?
Grafana v10.2.2 - What are you trying to achieve?
Connect a data source (MySQL) - How are you trying to achieve it?
I installed grafana locally on my server, accessed port 3000 and used the GUI - What happened?
I got a vague error: “query failed - please inspect Grafana server log for details”. I checked the logs, but it wasn’t very helpful. The only thing worth noting from the log is the following:
logger=sqlstore.transactions t=2024-03-14T08:17:46.954116153Z level=info msg="Database locked, sleeping then retrying" error="database is locked" retry=0 code="database is locked"
-
What did you expect to happen?
For the connection to be successfully added since all the fields are filled with the exact information as found in the config. -
Can you copy/paste the configuration(s) that you are having problems with?
If that’s absolutely necessary, I can do that (but the information will be blurred out, so I’m not sure how this will help?) -
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
logger=sqlstore.transactions t=2024-03-14T08:12:46.969088252Z level=info msg=“Database locked, sleeping then retrying” error=“database is locked” retry=0 code=“database is locked”
logger=plugins.update.checker t=2024-03-14T08:12:47.024385111Z level=info msg=“Update check succeeded” duration=29.666222ms
logger=grafana.update.checker t=2024-03-14T08:12:47.063959309Z level=info msg=“Update check succeeded” duration=41.163365ms
logger=sqlstore.transactions t=2024-03-14T08:17:46.954116153Z level=info msg=“Database locked, sleeping then retrying” error=“database is locked” retry=0 code=“database is locked”
logger=cleanup t=2024-03-14T08:22:46.976419529Z level=info msg=“Completed cleanup jobs” duration=18.098583ms
- Did you follow any online instructions? If so, what is the URL?
MySQL data source | Grafana documentation
It is worth mentioning I am running mariaDB, but based on my research it shouldn’t really make a difference. Please let me know if I’m wrong, and once again I appreciate your time and effort.