Subject Re: [firebird-support] Transaction deadlock
Author Ann W. Harrison
daniele.barzotti wrote:
> So my question are:
> 1. Why there is an open transaction? I do not open one explicitly

All statements are done in the context of a transaction.

> 2. How can I detect if a particular table/query belong to a pending transaction?

Tables don't belong to transactions. Queries do as do record

> 3. Or..How can avoid deadlock?

By choosing a more reasonable set of transaction options. For example,
if you are using read-committed transactions, use the "record version"

What transaction options are you using - other than wait or no wait?

Best regards,