Jean-Paul Calderone wrote:

On Mon, 22 Jun 2009 11:06:24 +0200, Gabriel Rossetti <gabriel.rossetti@arimaz.com> wrote:

...

Hello everyone,

I am using twisted.enterprise.adbapi with sqlite3 database adapter and "runInteraction()". I keep on getting "sqlite3.OperationalError : database is locked" errors. I understand the problem, multiple threads try to access the DB and it being already locked by a thread it raises this exception. My question is what is the standard/correct Twisted way of dealing with this?

You can set your connection pool to a maximum of 1 connection. Or you can try raising the timeout on your database.

Jean-Paul A

Thank you Jean-Paul, I thought of that just before I saw your msg (limiting the connection pool to 1 connection), it works great! Gabriel

Jean-Paul Calderone wrote:

On Mon, 22 Jun 2009 11:06:24 +0200, Gabriel Rossetti <gabriel.rossetti@arimaz.com> wrote:

...

Hello everyone,

I am using twisted.enterprise.adbapi with sqlite3 database adapter and "runInteraction()". I keep on getting "sqlite3.OperationalError : database is locked" errors. I understand the problem, multiple threads try to access the DB and it being already locked by a thread it raises this exception. My question is what is the standard/correct Twisted way of dealing with this?

You can set your connection pool to a maximum of 1 connection. Or you can try raising the timeout on your database.

Jean-Paul A

Thank you Jean-Paul, I thought of that just before I saw your msg (limiting the connection pool to 1 connection), it works great! Gabriel