[GitHub] [incubator-superset] etr2460 commented on issue #8207: sqlalchemy.exc.TimeoutError: QueuePool limit of size 10 overflow 10 reached, connection timed out, timeout 30

[GitBox <gi...@apache.org>]

etr2460 commented on issue #8207: sqlalchemy.exc.TimeoutError: QueuePool limit of size 10 overflow 10 reached, connection timed out, timeout 30
URL: https://github.com/apache/incubator-superset/issues/8207#issuecomment-530056051
 
 
   We've seen a similar issue before, but after some sqlalchemy config tweaks and some db optimizations in flask appbuilder, it went away. Maybe try adding the following to your superset config to fix the issue:
   ```
   SQLALCHEMY_ENGINE_OPTIONS = {
       "max_overflow": 15,
       "pool_pre_ping": True,
       "pool_recycle": 60 * 60,
       "pool_size": 30,
   }
   ```

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org