Re: [sqlalchemy] how do I update a relationship that goes through mulitple tables?

2020-06-03 Thread Mike Bayer
On Wed, Jun 3, 2020, at 3:42 PM, Abbey Reisle wrote: > sqlalchemy version: 1.2.16 > database: mysql 5.7 > > so I currently have a relationship between 2 tables (that has a join table) > that works well for querying, but I need to be able to update as well > > I've tried a few different things

Re: [sqlalchemy] Ocassional Gevent BlockingSwitchOutError crashes when using pool_recycle

2020-06-03 Thread Mike Bayer
Correction, _finalze_fairy() will be doing the rollback() for normal close() as well. anyway you need to make sure those closes are inline with your greenlets and not happening in other greenlets or threads due to GC. On Wed, Jun 3, 2020, at 8:58 AM, Mike Bayer wrote: > Are those errors

Re: [sqlalchemy] Ocassional Gevent BlockingSwitchOutError crashes when using pool_recycle

2020-06-03 Thread Mike Bayer
Are those errors appearing in the logs only but not blocking requests? those are cleanouts of pooled connections where the rollback() method must be called. if these pooled connections aren't gracefully closed in your greenlets they will be subject to the garbage collector thread where the