pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWhat does invalid_transaction_state 25000 mean
4+ messages / 3 participants
[nested] [flat]
* What does invalid_transaction_state 25000 mean
@ 2023-06-19 19:35 Debraj Manna <subharaj.manna@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Debraj Manna @ 2023-06-19 19:35 UTC (permalink / raw)
To: pgsql-admin
Hi
Can someone let me know when Postgres throws an invalid_transaction_state,
25000 error ?
Postgres Version 14.2
Thanks
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: What does invalid_transaction_state 25000 mean
@ 2023-06-19 20:01 Joe Conway <mail@joeconway.com>
parent: Debraj Manna <subharaj.manna@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Joe Conway @ 2023-06-19 20:01 UTC (permalink / raw)
To: Debraj Manna <subharaj.manna@gmail.com>; pgsql-admin
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=...
--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: What does invalid_transaction_state 25000 mean
@ 2023-06-20 07:55 Debraj Manna <subharaj.manna@gmail.com>
parent: Joe Conway <mail@joeconway.com>
0 siblings, 1 reply; 4+ messages in thread
From: Debraj Manna @ 2023-06-20 07:55 UTC (permalink / raw)
To: Joe Conway <mail@joeconway.com>; +Cc: 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=...
>
> --
> Joe Conway
> PostgreSQL Contributors Team
> RDS Open Source Databases
> Amazon Web Services: https://aws.amazon.com
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: What does invalid_transaction_state 25000 mean
@ 2023-06-20 10:49 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Debraj Manna <subharaj.manna@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Laurenz Albe @ 2023-06-20 10:49 UTC (permalink / raw)
To: Debraj Manna <subharaj.manna@gmail.com>; Joe Conway <mail@joeconway.com>; +Cc: pgsql-admin
On Tue, 2023-06-20 at 13:25 +0530, Debraj Manna wrote:
> 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
Your application is using the SERIALIZATION idolation level, and
PostgreSQL detected a potential anomaly.
ROLLBACK and retry the transaction.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2023-06-20 10:49 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-06-19 19:35 What does invalid_transaction_state 25000 mean Debraj Manna <subharaj.manna@gmail.com>
2023-06-19 20:01 ` Joe Conway <mail@joeconway.com>
2023-06-20 07:55 ` Debraj Manna <subharaj.manna@gmail.com>
2023-06-20 10:49 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox