Re: [pylons-discuss] How to handle SQLA autoflush failures during Request commit?

2019-06-21 Thread Theron Luhn
Also using the cookie-cutter SQLAlchemy in front of Gunicorn. 1) I have autoflush disabled. It doesn’t reduce the mental load—as your example shows, you still need to understand when and why to use flush—and premature flushes are a headache to work around. 2) After a query fails (in this case

[pylons-discuss] How to handle SQLA autoflush failures during Request commit?

2019-06-21 Thread Jens Troeger
Hello, I’m using gunicorn in front of a Pyramid server, and I changed the configuration from 1 to 4 workers. Now I occasionally see the following exception: InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush.