Tuesday, August 26, 2014

EXP 2: org.postgresql.util.PSQLException: ERROR: prepared transaction with identifier

Problem
org.postgresql.util.PSQLException: ERROR: prepared transaction with identifier

Cause
some configs of postgresql incorrect, especially for XA transaction

Solution
in postresql.conf file, set 2 parameter same value, max_prepared_transaction and max_connections

You can consider increase share_buffers larger (ex: 512MB)

Example
max_connections = 100
max_prepared_transaction = 100 

No comments:

Post a Comment