Обсуждение: Deadlock Detection

Поиск
Список
Период
Сортировка

Deadlock Detection

От
Moshe Vardi
Дата:
How do I find out in Embedded SQL that a transaction has been aborted
due to a deadlock?

The closes error message in sqlca seems to be:
 -401 (ECPG_TRANS): Error in transaction processing line %d.  PostgreSQL signaled that we cannot start, commit, or
rollbackthe  transaction. 
 

but it does not seem to be informative enough.

Similarly, how do I find if a transaction has been aborted due to
nonserializability?

Thanks,
Moshe