Re-try connect in case of (specific?) errors with new connection? about django-db-connection-pool HOT 4 CLOSED

This traceback shows error happens when django are acquiring database connection while database connection pool was empty. this means this is the first time to try connecting to your database,

I don't think it is a good idea to retry connecting by django-db-connection-pool or SQLAlchemy while pool is still empty, you should catch OperationalErrors in your code.

PS:
Assume after invoking creator (dj_db_conn_pool.core.mixins.PooledDatabaseWrapperMixin._get_new_connection), SQLAlchemy receives dbapi connection successfully, If django requires database connection again, SQLAlchemy will try to get a DBAPI connection from the pool, if this connection was abnormal, SQLAlchemy will make three attempts to re-connect to database.

from django-db-connection-pool.

I don't think it is a good idea to retry connecting by django-db-connection-pool or SQLAlchemy while pool is still empty, you should catch OperationalErrors in your code.

Ok. While there still might be a transitional error in this case (so that it might help to retry), it is not that much an issue then.

Thanks for the additional explanation!

from django-db-connection-pool.

Well, after all it happens with every new connection, not just the first one / if the pool is empty, doesn't it?

from django-db-connection-pool.

Well, after all it happens with every new connection, not just the first one / if the pool is empty, doesn't it?

"pool is empty" has two states:

1. no connections has been checked-out from pool, in this case, the pool has just been created, it's empty
2. all connections in the pool has been checked-out, the pool is also empty

while "pool is empty", If the limit of pool is not exceeded, SQLAlchemy will make a new connection.

• SQLAlchemy doesn't retry if new connection fails: code
• SQLAlchemy checks connection got from pool, if connection is abnormal, three reconnection attempts will be made at maximum: code

from django-db-connection-pool.