Обсуждение: Transaction Rollback errors

Поиск

Список

Период

Сортировка

Transaction Rollback errors

От

Siddharth Jain

Дата:

11 апреля 2023 г., 23:31:25

Hi All,

when my application (Node.js) receives a class 40 error:

Class 40 — Transaction Rollback
`40000`	`transaction_rollback`
`40002`	`transaction_integrity_constraint_violation`
`40001`	`serialization_failure`
`40003`	`statement_completion_unknown`
`40P01`	`deadlock_detected`

then does it mean PG has already rolled back the tx and therefore I should not attempt to roll it back again? Thanks,

Re: Transaction Rollback errors

От

Tom Lane

Дата:

12 апреля 2023 г., 02:23:37

Siddharth Jain <siddhsql@gmail.com> writes:
> when my application (Node.js) receives a class 40 error:

> Class 40 — Transaction Rollback
> 40000 transaction_rollback
> 40002 transaction_integrity_constraint_violation
> 40001 serialization_failure
> 40003 statement_completion_unknown
> 40P01 deadlock_detectedthen does it mean PG has already rolled back the tx
> and therefore I should not attempt to roll it back again? Thanks,

No, treat these the same as any other error.

            regards, tom lane

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: Transaction Rollback errors

Transaction Rollback errors

Re: Transaction Rollback errors