the pessimistic disconnect logic will help you in dealing with connections that are stale, such as if the database was restarted, and you'd like to ensure new connections from the pool are always live.
However, if you are getting these 3135 errors in the middle of inserting a BLOB or something like that, there's nothing on SQLAlchemy's end that can help with that, that is down to what the cx_Oracle driver is doing with the server and you'd need to either decrease the amount of data you're passing in, either directly or by limiting concurrency, and/or looking into those various oracle configuration settings. On Mon, Jul 9, 2018 at 5:11 PM, Jeremy Flowers <[email protected]> wrote: > Thanks Jonathan - I'll take a look > > > On Monday, 9 July 2018 22:09:57 UTC+1, Jonathan Vanasco wrote: >> >> http://docs.sqlalchemy.org/en/latest/core/pooling.html >> >> specifically: >> >> http://docs.sqlalchemy.org/en/latest/core/pooling.html#disconnect-handling-pessimistic >> and >> >> http://docs.sqlalchemy.org/en/latest/core/pooling.html#custom-legacy-pessimistic-ping >> >> There is also: >> >> http://docs.sqlalchemy.org/en/latest/core/pooling.html#disconnect-handling-optimistic > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
