Re: [sqlalchemy] celery and race conditions

2014-04-15 Thread Wichert Akkerman
On 15 Apr 2014, at 01:12, Jonathan Vanasco jonat...@findmeon.com wrote: i've got that now as a stopgap; i was hoping someone has better ideas. i don't like the idea of a post-commit hook, because i fear requesting the celery task request will create an error. I really don't want to build

Re: [sqlalchemy] celery and race conditions

2014-04-15 Thread Jonathan Vanasco
if i have any time after shipping , i'll probably build in transaction support for celery and pyramid. I keep away from tossing ORM objects around the system. GETS are pretty cheap. my task arguments are generally: int = primary key of ORM object dict = instructions payload of what

[sqlalchemy] celery and race conditions

2014-04-14 Thread Jonathan Vanasco
I just ran into an issue where it looks like I could have race conditions using SqlAlchemy and Celery. Wondering if anyone here has some ideas. Here's the scenario: A1 Process A - Pyramid - Creates SQLalchemy session. A2 Process A - Pyramid - Creates data A3 Process A - Pyramid - flushes data

Re: [sqlalchemy] celery and race conditions

2014-04-14 Thread Michael Bayer
it looks like I could have race conditions using SqlAlchemy and Celery. Wondering if anyone here has some ideas. Here's the scenario: A1 Process A - Pyramid - Creates SQLalchemy session. A2 Process A - Pyramid - Creates data A3 Process A - Pyramid - flushes data A4 Process A - Pyramid

Re: [sqlalchemy] celery and race conditions

2014-04-14 Thread Jonathan Vanasco
i've got that now as a stopgap; i was hoping someone has better ideas. i don't like the idea of a post-commit hook, because i fear requesting the celery task request will create an error. I really don't want to build `transaction` support for celery, but i might need to. -- You received