Hi Team,
We have received sometimes the below docker logs error from the worker when the query is trying to run. Am I think it correctly, that we received this errror when the connection pool is full? Or What is caused this type of error?
Traceback (most recent call last):
File “/app/redash/tasks/queries/execution.py”, line 188, in run
data, error = query_runner.run_query(annotated_query, self.user)
File “/app/redash/query_runner/mysql.py”, line 162, in run_query
connection = self._connection()
File “/app/redash/query_runner/mysql.py”, line 121, in _connection
connection = MySQLdb.connect(**params)
File “/usr/local/lib/python3.7/site-packages/MySQLdb/init.py”, line 85, in Connect
return Connection(*args, **kwargs)
File “/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py”, line 208, in init
super(Connection, self).init(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2006, "Can’t connect to MySQL server on XXXXXXXXXXXXXX