Re: [sqlalchemy] Session and optimistic disconnect handling

2021-06-10 Thread Mike Bayer
i think you need to turn on pool logging, echo_pool='debug'. Also note the "pre-ping" feature in some cases uses a "ping" feature provided by the DBAPI which can transparently reconnect (such as mysqlclient) so nothing would be seen there. On Thu, Jun 10, 2021, at 12:57 PM, 'Matt

Re: [sqlalchemy] Session and optimistic disconnect handling

2021-06-10 Thread 'Matt Zagrabelny' via sqlalchemy
On Tue, Jun 8, 2021 at 11:58 AM Mike Bayer wrote: > > Unknown network failures, I suppose. I have an application that is > throwing an exception right now due to: > > psycopg2.OperationalError: terminating connection due to administrator > command > SSL connection has been closed unexpectedly >

Re: [sqlalchemy] SQLAlchemy 1.4 / 2.0 distribution

2021-06-10 Thread Mike Bayer
On Wed, Jun 9, 2021, at 7:21 PM, Marat Sharafutdinov wrote: > The problem is that currently only the entire codebase can be migrated from > 1.3 to 1.4, even though it can be extremely difficult or too long to do. > > I suggest the following way of pinning dependencies: > sqlalchemy==1.3 >

Re: [sqlalchemy] SQLAlchemy 1.4 / 2.0 distribution

2021-06-10 Thread Federico Caselli
Hi, > The problem is that currently only the entire codebase can be migrated from 1.3 to 1.4, even though it can be extremely difficult or too long to do. I don't agree with this assessment. From my experience the main incompatibility is the url that has become immutable. Other than this most