Logger=context error="Error 1040: Too many connections"

1

Hi ,

We have Grafana setup with MySQL DB and we started receiving these errors and on multiple refreshes, we used to get Grafana connection and Grafana logs are loaded with “Error 1040: Too many connections” errors.

My Question :

Is there any limitations in Grafana with respect to number of connections ?

Regards,
Madhan

2

Are you using mysql for the configuration db or as datasource? What mysql grafana settings do you use?

3

Hi Mefraimsson,

First of all thanks for looking into my query.

We are using Mysql DB as configuration DB for Grafana.

we are using just basic connection with hostname,username and password settings in Grafana configurations.

Please let me know if any more information is required.

Regards,
Madhan

4

Please check this setting and the two following setting here http://docs.grafana.org/installation/configuration/#max-idle-conn. It’s very important that conn_max_lifetime is less than wait_timeout global variable in mysql.