Deadlock=if transaction 1 uses A then B and transaction 2 uses B then A,
then it is possible that 1 is waiting for 2 to release B and 2 is
waiting for 1 to release A at the same time. Nothing will happen since
they're waiting for each other, and you have what is called a deadlock.
There are many different kinds of solutions to this problem. In your
case you could try always using the accounts in the same order, i.e. if
account A has primary key "1234" and B has pk "5678" then you should
always use "1234" before "5678" since the pk is "smaller". This will
ensure a natural order in the way they are used and will thus avoid
deadlock.
You should also try to use transactions as seldom as possible since they
will increase the possibility for deadlocks.
/Rickard
Thanks for all, I got it now. :)
It's just a problem with a bad mix of random access to accounts and
transactions....
Sometimes, I feel really tired. ;)
But, give me 3 or 6 months, and I'll try to ask more difficult
questions.
sigh:: hope so.
Perhaps will I need a little more time, 3 or 6 years .... ;)
Olivier
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
