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.
___
;
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
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
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