Re: Transaction newbie question

2003-11-21 Thread Mike Gollub
Thanks Peter. I strongly suspect that I'm getting deadlocks where it's simply a lock contention. Grrr. I chose BDB because my client has it available on his installation. I'll configure InnoDB support if necessary. It looks like a LOT less headache. Thanks. - Mike. ___

Re: Transaction newbie question

2003-11-20 Thread Peter Sap
; Sent: Friday, November 21, 2003 12:38 AM Subject: Re: Transaction newbie question > OK, I don't seem to be getting a response. Let me try to simplify: > > I'm running a PHP application with MySQL. > I'm in a transaction involving only BDB tables. Actually the whol

Re: Transaction newbie question

2003-11-20 Thread Mike Gollub
OK, I don't seem to be getting a response. Let me try to simplify: I'm running a PHP application with MySQL. I'm in a transaction involving only BDB tables. Actually the whole database has nothing but BDB tables. I attempt a query which fails with error number 1213. The full text message is s

Transaction newbie question

2003-11-13 Thread Mike Gollub
Hi - I'm running 4.0.13-Max on Linux via PHP. I don't have BDB shared mode set. I've been experimenting with the BDB transactions and been getting confusing results. My tests are separate threads running a PHP test script. It seems that a transaction can acquire 1 or more locks, then fail on