deadlocks with SQLite 3.x about temboz HOT 1 CLOSED

2006-Jan-14 11:41:42 by majid:

It seems like the update thread (thread 2) loses the lock while it's doing its updates, but it is not clear to whom.

2006-Feb-13 00:36:11 by majid:

These articles may be relevant:
*: http://www.third-bit.com/trac/argon/wiki/Locking
*: http://initd.org/tracker/pysqlite/ticket/126
*: http://permalink.gmane.org/gmane.comp.db.sqlite.general/9489
*: http://thread.gmane.org/gmane.comp.db.sqlite.general/13001

2006-Feb-26 11:31:54 by majid:

The deadlocks are easily reproduced by running the ApacheBench ab command to load the /view page (which also updates the article viewed timestamp, so it is not a read-only transaction). With a concurrency of 1, it works, with a concurrency of 2 or higher, it immediately deadlocks.

from temboz.