Re: What does invalid_transaction_state 25000 mean

Поиск
Список
Период
Сортировка
От Debraj Manna
Тема Re: What does invalid_transaction_state 25000 mean
Дата
Msg-id CAF6DVKNk8NJmhGi=bMk0NmWy1_nqV9hVbpJZC9y4DCBO5cY4mQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: What does invalid_transaction_state 25000 mean  (Joe Conway <mail@joeconway.com>)
Ответы Re: What does invalid_transaction_state 25000 mean  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin
Дерево обсуждения
Thanks for replying.

I am seeing the below error message Postgres JDBC driver

Caused by: org.postgresql.util.PSQLException: ERROR: could not serialize access due to read/write dependencies among transactions  Detail: Reason code: Canceled on identification as a pivot, during conflict in checking.  Hint: The transaction might succeed if retried.  at org.postgresql.core.v3.QueryExecutorImpl.receiv

On Tue, Jun 20, 2023 at 1:31 AM Joe Conway <mail@joeconway.com> wrote:
On 6/19/23 15:35, Debraj Manna wrote:
> Can someone let me know when Postgres throws an
> invalid_transaction_state, 25000 error ?

Multiple reasons. What error message do you get?

Maybe this will help you figure out which case is applicable:

https://github.com/search?q=repo%3Apostgres%2Fpostgres%20ERRCODE_INVALID_TRANSACTION_STATE&type=code

--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com

В списке pgsql-admin по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: What does invalid_transaction_state 25000 mean
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: IS JSON STRICT - In oracle => postgres ??