Re: [sqlalchemy] Database locker error with sqlite in multi-process environment

2013-12-19 Thread Michael Bayer
SQLite doesn’t work great for concurrent access. Or is the database file just stuck in a locked state? try copying it to a different file. On Dec 19, 2013, at 12:51 AM, AM ams@gmail.com wrote: PS: The only thing I can think of that is not quite usual is that I have a save method

Re: [sqlalchemy] Database locker error with sqlite in multi-process environment

2013-12-19 Thread AM
On 12/19/2013 01:39 PM, Michael Bayer wrote: SQLite doesn’t work great for concurrent access. Or is the database file just stuck in a locked state? try copying it to a different file. On Dec 19, 2013, at 12:51 AM, AM ams@gmail.com wrote: PS: The only thing I can think of that is not

[sqlalchemy] Database locker error with sqlite in multi-process environment

2013-12-18 Thread AM
Hi All. I have a pyramid app, that uses sqlite via sqlalchemy when run in development. The configuration used: sqlalchemy.url = sqlite:///%(here)s/pyp.sqlite?pool_size=1 sqlalchemy.isolation_level = SERIALIZABLE The application initializes the engine using: settings =