thank you kindly, mike! On Friday, September 1, 2017 at 10:51:16 AM UTC-4, Mike Bayer wrote: > > for simulating connection problems I use mock heavily. If you look > at test/engine/test_reconnect.py you can see there's a whole MockDBAPI > that can be instructed to "expode" in a specific way. > > On Thu, Aug 31, 2017 at 9:30 PM, Jonathan Vanasco <jona...@findmeon.com > <javascript:>> wrote: > > I discovered an edge-case in one of our apps today. A form got pummeled > by > > a botnet which was going through a list of compromised account data for > hits > > (e.g. credentials that match haveibeenpwned.com). That triggered a lot > of > > internal metrics logging, which eventually a dedicated logging > postgresql > > server out of disk space for a bit. > > > > the same logging server also handles our "exception" logging, which is > done > > via a separate dedicated session. something in our stack somehow didn't > > close the connection/reset the session when it should have, and the > > session/connections stayed active. that led to the connection pool > > constantly checking out bad sessions for several hours. > > > > free space was quickly recovered, and every other SqlAlchemy system in > the > > same app was immediately working fine. the only thing that broke, and > > stayed broken, was our "python exception" logger. > > > > does anyone know if there is a way for me to somehow break/wedge a given > > engine's connection? I'm trying to recreate this edge-case, and failing > > miserably. > > > > > > the error was `sqlalchemy.exc.InvalidRequestError ` with the message: > > > > InvalidRequestError: This Session's transaction has been rolled back > due > > to a previous exception during flush. To begin a new transaction with > this > > Session, first issue Session.rollback(). Original exception was: > > (psycopg2.OperationalError) could not extend file "base/16410/23816": No > > space left on device > > > > > > > > > > -- > > 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 sqlalchemy+...@googlegroups.com <javascript:>. > > To post to this group, send email to sqlal...@googlegroups.com > <javascript:>. > > 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
