On 3/13/06, Dave Brown <[EMAIL PROTECTED]> wrote: > Yeah if I put BEGIN IMMEDIATE in thread1 as well, then it works, but as you > say I don't see why I need to do this. Perhaps the implicit transaction > which is created in my 1-line INSERT statement isn't an immediate > transaction?? > > Seems like there should be a flag or pragma or something to force all > transactions to be immediate.
Dave, you need to go read more about deadlocks (and some about how locks are created) to understand this. All of your threads must have the begin immediate or it won't solve the problem. Understanding what's going on is the key to success
