Re: What does invalid_transaction_state 25000 mean

Debraj Manna <subharaj.manna@xxxxxxxxx> · Tue, 20 Jun 2023 13:25:13 +0530

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@xxxxxxxxxxxxx> 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