Use the Redash api to create visualizations and got sqlalchemy.exc.TimeoutError

Support
1

We use the Redash API to create visualizations, and then we got the error
sqlalchemy.exc.TimeoutError
sqlalchemy.exc.TimeoutError:QueuePool limit of size 5 overflow 10 reached, connection time out, timeout 30

Anything we need modify in the docker-compose file?

1 Like
2

I have the same problem! Did you solved it ?

3

Thanks for bumping this issue. Does this always happen? Or only after creating many visualisations?

4

This happens from time to time, even when creating queries.

5

yeah, I used the developer version, so what I did was add following two parameters in the yml file:

SQLALCHEMY_POOL_SIZE: 100
SQLALCHEMY_MAX_OVERFLOW: 100

image
image1291×195 12.1 KB

2 Likes
6

Thanks, dtian118! I’ll try it.