[sqlite] interesting deadlock.

2012-08-24 Thread Jonathan Engle
Ran into this recently, it's happened on one machine running a beta test of our software. This is a multi-threaded application, and I've run into a sequence of steps that deadlocks hard that as far as I can tell from the documentation shouldn't. This is using SQLite 3.7.13 with SEE. The

Re: [sqlite] interesting deadlock.

2012-08-25 Thread Jonathan Engle
r. > > /Patrik > > On 08/24/2012 05:46 PM, Jonathan Engle wrote: >> Ran into this recently, it's happened on one machine running a beta test of >> our software. This is a multi-threaded application, and I've run into a >> sequence of steps that

Re: [sqlite] Pragma Synchronous=OFF is not working

2012-08-28 Thread Jonathan Engle
Try WAL mode. On Aug 28, 2012, at 9:38 AM, kritesh tripathi wrote: > Hi Pavel, > > Thanks for the information . I am using all insert under one transection > hence may be the reson its not effecting much . But do you suggest me the > way to increase more insert speed what i need to do in this

Re: [sqlite] interesting deadlock.

2012-09-27 Thread Jonathan Engle
he source database in the On Aug 25, 2012, at 1:33 PM, Jonathan Engle wrote: > No, the deadlock is deeper than that, it's stuck trying to lock mutexes. My > current theory is that the thread trying to update the page in the backup > destination database is what's causing trouble.

Re: [sqlite] interesting deadlock.

2012-10-04 Thread Jonathan Engle
, at 1:49 AM, Dan Kennedy wrote: > On 09/28/2012 03:32 AM, Jonathan Engle wrote: >> I've been picking away at this for the last few days and have it >> narrowed down fairly well. >> >> It looks like if I turn off shared cache, it works fine (same >> a

Re: [sqlite] interesting deadlock.

2012-10-12 Thread Jonathan Engle
backups restarting? Is there a better way? On Oct 5, 2012, at 11:59 AM, Dan Kennedy wrote: > On 10/05/2012 04:29 AM, Jonathan Engle wrote: >> Ok, so here's a question (trying an experiment to see if this will >> work, but throwing it out here as well). >> >> W