Subject Re: [ib-support] wait transactions and rollback
Author Ann Harrison
At 09:36 AM 6/25/2002 -0500, Woody wrote:
>If you switch to no-wait transactions, the error will be returned right away
>and you can handle it in a loop that keeps trying until it succeeds. In most
>cases, this will be a very short time period if it happens at all. You could
>even put a counter in the loop that let's the user know the counter is
>locked by another user after 10 tries (or something like that) and asks if
>they want to continue trying or give up and try again later.

That's a formula for "live lock" - a CPU spending 100% of it's time
retrying transactions.