On 19 Jan 2019, at 4:43pm, <andrew.g...@l3t.com> <andrew.g...@l3t.com> wrote:
> I'm thinking one possible sequence might be: It's the right suggestion, but you're still in diagnostic stage, so this is a faster test: 1) Make sure your code still sets timeouts on every connection. 5000 ms should be fine. 2) Replace every BEGIN with BEGIN IMMEDIATE Test your program. If it still doesn't work, you need more diagnostics. But if it does work 3) Replace every BEGIN IMMEDIATE with BEGIN EXCLUSIVE Test your program. BEGIN EXCLUSIVE is better, because it allows other connections access to the database for longer before it locks up the database. But there are circumstances where it can allow a deadlock which IMMEDIATE could avoid. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
