| From: | Debraj Manna <subharaj(dot)manna(at)gmail(dot)com> |
|---|---|
| To: | Joe Conway <mail(at)joeconway(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: What does invalid_transaction_state 25000 mean |
| Date: | 2023-06-20 07:55:13 |
| Message-ID: | CAF6DVKNk8NJmhGi=bMk0NmWy1_nqV9hVbpJZC9y4DCBO5cY4mQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)joeconway(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2023-06-20 08:07:05 | Re: IS JSON STRICT - In oracle => postgres ?? |
| Previous Message | Joe Conway | 2023-06-19 20:01:51 | Re: What does invalid_transaction_state 25000 mean |