"maximum number of prepared transactions reached" when working with timers
Issue
- We are using RHPAM with EJB based timers, backed by PostgreSQL database. When we attempt to deploy process which includes Timer Start node, the deployment fails with:
Caused by: org.postgresql.util.PSQLException: ERROR: maximum number of prepared transactions reached
Hint: Increase max_prepared_transactions (currently 0).
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:321)
at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:297)
at org.postgresql.xa.PGXAConnection.prepare(PGXAConnection.java:326)
Environment
- Red Hat Process Automation Manager
- 7
- EJB Timers backed by PostgreSQL database
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
