Error after installing BDM on budle Tomcat + Postgres platform

1
0
-1

Hi! Please help!

Community Studio 7.10.3

Community Bundle Tomcat Platform 7.10.4

Postgre 9.3

After importing the Studio BDM from Studio, the tables are created in Postgres. When restarting the platform, errors occur and the platform does not start.

Before import the BDM the platform is working, created users, etc... but restart the bundle:

...

020-06-02 14:24:36.770 -0300 WARN (Periodic Recovery) com.arjuna.ats.arjuna Transaction 0:ffffc0a801a4:c1ce:5ed689fc:502 has 1 heuristic participant(s)!
2020-06-02 14:24:37.083 -0300 WARN (Periodic Recovery) com.arjuna.ats.jta ARJUNA016037: Could not find new XAResource to use for recovering non-serializable XAResource XAResourceRecord < resource:null, txid:< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a801a4:c1ce:5ed689fc:502, node_name=1, branch_uid=0:ffffc0a801a4:c1ce:5ed689fc:507, subordinatenodename=null, eis_name=0 >, heuristic: TwoPhaseOutcome.HEURISTIC_HAZARD com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord@300b4d0a >
2020-06-02 14:24:37.083 -0300 WARN (Periodic Recovery) com.arjuna.ats.jta XAResourceRecord restored heuristic instance: XAResourceRecord < resource:null, txid:< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a801a4:c1ce:5ed689fc:502, node_name=1, branch_uid=0:ffffc0a801a4:c1ce:5ed689fc:507, subordinatenodename=null, eis_name=0 >, heuristic: TwoPhaseOutcome.HEURISTIC_HAZARD com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord@300b4d0a >
2020-06-02 14:24:37.083 -0300 WARN (Periodic Recovery) com.arjuna.ats.arjuna Transaction 0:ffffc0a801a4:c1ce:5ed689fc:502 restored heuristic participant XAResourceRecord < resource:null, txid:< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a801a4:c1ce:5ed689fc:502, node_name=1, branch_uid=0:ffffc0a801a4:c1ce:5ed689fc:507, subordinatenodename=null, eis_name=0 >, heuristic: TwoPhaseOutcome.HEURISTIC_HAZARD com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord@300b4d0a >
2020-06-02 14:24:54.927 -0300 ADVERTÊNCIA (localhost-startStop-1) org.bonitasoft.engine.platform.impl.PlatformServiceImpl THREAD_ID=23 | HOSTNAME=Win7-PC | Can't cache the platform, maybe the platform cache service is not started yet: The cache is not started, call start() on the cache service
2020-06-02 14:24:54.942 -0300 INFORMAÇÕES (localhost-startStop-1) org.bonitasoft.engine.EngineInitializer Platform is already initialized.
2020-06-02 14:24:54.942 -0300 INFORMAÇÕES (localhost-startStop-1) org.bonitasoft.engine.EngineInitializer Starting node...
2020-06-02 14:24:54.942 -0300 ADVERTÊNCIA (localhost-startStop-1) org.bonitasoft.engine.platform.impl.PlatformServiceImpl THREAD_ID=23 | HOSTNAME=Win7-PC | Can't cache the platform, maybe the platform cache service is not started yet: The cache is not started, call start() on the cache service
2020-06-02 14:24:55.036 -0300 INFORMAÇÕES (localhost-startStop-1) org.quartz.core.SchedulerSignalerImpl Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
2020-06-02 14:24:55.036 -0300 INFORMAÇÕES (localhost-startStop-1) org.quartz.core.QuartzScheduler Quartz Scheduler v.2.2.1 created.
2020-06-02 14:24:55.036 -0300 INFORMAÇÕES (localhost-startStop-1) org.quartz.plugins.management.ShutdownHookPlugin Registering Quartz shutdown hook.
2020-06-02 14:24:55.036 -0300 INFORMAÇÕES (localhost-startStop-1) org.quartz.core.QuartzScheduler Scheduler meta-data: Quartz Scheduler (v2.2.1) 'QuartzScheduler' with instanceId 'NON_CLUSTERED'
Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
NOT STARTED.
Currently in standby mode.
Number of jobs executed: 0
Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 5 threads.
Using job-store 'org.bonitasoft.engine.scheduler.impl.BonitaJobStoreCMT' - which supports persistence. and is not clustered.

2020-06-02 14:24:55.036 -0300 INFORMAÇÕES (localhost-startStop-1) org.quartz.core.QuartzScheduler JobFactory set to: org.bonitasoft.engine.scheduler.impl.TransactionalSimpleJobFactory@65163f56
2020-06-02 14:24:55.067 -0300 INFORMAÇÕES (localhost-startStop-1) org.quartz.core.QuartzScheduler Scheduler QuartzScheduler_$_NON_CLUSTERED started.
2020-06-02 14:25:03.643 -0300 WARN (localhost-startStop-1) org.hibernate.ejb.HibernatePersistence HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead.
2020-06-02 14:25:03.643 -0300 WARN (localhost-startStop-1) org.hibernate.ejb.HibernatePersistence HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead.
2020-06-02 14:25:03.644 -0300 WARN (localhost-startStop-1) org.hibernate.ejb.HibernatePersistence HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead.
2020-06-02 14:25:04.920 -0300 WARN (localhost-startStop-1) com.arjuna.ats.jta ARJUNA016041: prepare on < formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a801a4:c277:5ed68b4a:45, node_name=1, branch_uid=0:ffffc0a801a4:c277:5ed68b4a:53, subordinatenodename=null, eis_name=0 > (org.postgresql.xa.PGXAConnection@25674d7) failed with exception XAException.XAER_RMFAIL
org.postgresql.xa.PGXAException: Erro ao preparar transação. prepare xid=< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a801a4:c277:5ed68b4a:45, node_name=1, branch_uid=0:ffffc0a801a4:c277:5ed68b4a:53, subordinatenodename=null, eis_name=0 >
at org.postgresql.xa.PGXAConnection.prepare(PGXAConnection.java:360)
at com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord.topLevelPrepare(XAResourceRecord.java:214)
at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2664)
at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2614)
at com.arjuna.ats.arjuna.coordinator.BasicAction.prepare(BasicAction.java:2157)
at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1503)
at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:96)
at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1288)
at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:126)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.complete(JTATransactionServiceImpl.java:186)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:296)
at org.bonitasoft.engine.tenant.TenantServicesManager.changeServiceState(TenantServicesManager.java:120)
at org.bonitasoft.engine.tenant.TenantServicesManager.lambda$doStart$0(TenantServicesManager.java:99)
at org.bonitasoft.engine.tenant.TenantServicesManager.inTenantSession(TenantServicesManager.java:137)
at org.bonitasoft.engine.tenant.TenantServicesManager.doStart(TenantServicesManager.java:97)
at org.bonitasoft.engine.tenant.TenantServicesManager.start(TenantServicesManager.java:74)
at org.bonitasoft.engine.tenant.TenantStateManager.start(TenantStateManager.java:101)
at org.bonitasoft.engine.platform.PlatformManager.start(PlatformManager.java:110)
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startNode(PlatformAPIImpl.java:143)
at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:75)
at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:32)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4699)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:614)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1823)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERRO: transações preparadas estão desabilitadas
Dica: Defina max_prepared_transactions para um valor diferente de zero.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:244)
at org.postgresql.xa.PGXAConnection.prepare(PGXAConnection.java:352)
... 34 more

2020-06-02 14:25:04.923 -0300 WARN (localhost-startStop-1) com.arjuna.ats.arjuna ARJUNA012073: BasicAction.End() - prepare phase of action-id 0:ffffc0a801a4:c277:5ed68b4a:45 failed.
2020-06-02 14:25:04.924 -0300 WARN (localhost-startStop-1) com.arjuna.ats.arjuna ARJUNA012075: Action Aborting
2020-06-02 14:25:04.929 -0300 WARN (localhost-startStop-1) com.arjuna.ats.jta ARJUNA016045: attempted rollback of < formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a801a4:c277:5ed68b4a:45, node_name=1, branch_uid=0:ffffc0a801a4:c277:5ed68b4a:53, subordinatenodename=null, eis_name=0 > (org.postgresql.xa.PGXAConnection@25674d7) failed with exception code XAException.XAER_RMERR
org.postgresql.xa.PGXAException: Error rolling back prepared transaction. rollback xid=< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a801a4:c277:5ed68b4a:45, node_name=1, branch_uid=0:ffffc0a801a4:c277:5ed68b4a:53, subordinatenodename=null, eis_name=0 >, preparedXid=< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a801a4:c277:5ed68b4a:45, node_name=1, branch_uid=0:ffffc0a801a4:c277:5ed68b4a:53, subordinatenodename=null, eis_name=0 >, currentXid={2}
at org.postgresql.xa.PGXAConnection.rollback(PGXAConnection.java:480)
at com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord.topLevelAbort(XAResourceRecord.java:362)
at com.arjuna.ats.arjuna.coordinator.BasicAction.doAbort(BasicAction.java:3023)
at com.arjuna.ats.arjuna.coordinator.BasicAction.doAbort(BasicAction.java:3002)
at com.arjuna.ats.arjuna.coordinator.BasicAction.phase2Abort(BasicAction.java:1981)
at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1519)
at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:96)
at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1288)
at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:126)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.complete(JTATransactionServiceImpl.java:186)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:296)
at org.bonitasoft.engine.tenant.TenantServicesManager.changeServiceState(TenantServicesManager.java:120)
at org.bonitasoft.engine.tenant.TenantServicesManager.lambda$doStart$0(TenantServicesManager.java:99)
at org.bonitasoft.engine.tenant.TenantServicesManager.inTenantSession(TenantServicesManager.java:137)
at org.bonitasoft.engine.tenant.TenantServicesManager.doStart(TenantServicesManager.java:97)
at org.bonitasoft.engine.tenant.TenantServicesManager.start(TenantServicesManager.java:74)
at org.bonitasoft.engine.tenant.TenantStateManager.start(TenantStateManager.java:101)
at org.bonitasoft.engine.platform.PlatformManager.start(PlatformManager.java:110)
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startNode(PlatformAPIImpl.java:143)
at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:75)
at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:32)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4699)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:614)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1823)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERRO: transação preparada com identificador "131077_AAAAAAAAAAAAAP//wKgBpAAAwnde1otKAAAARTE=_AAAAAAAAAAAAAP//wKgBpAAAwnde1otKAAAAUwAAAAAAAAAA" não existe
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:244)
at org.postgresql.xa.PGXAConnection.rollback(PGXAConnection.java:457)
... 34 more

2020-06-02 14:25:04.932 -0300 WARN (localhost-startStop-1) com.arjuna.ats.arjuna ARJUNA012089: Top-level abort of action 0:ffffc0a801a4:c277:5ed68b4a:45 received heuristic decision: TwoPhaseOutcome.HEURISTIC_HAZARD
2020-06-02 14:25:04.948 -0300 GRAVE (localhost-startStop-1) org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita] Exception sending context initialized event to listener instance of class [org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener]
java.lang.RuntimeException: Error while initializing the Engine
at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:34)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4699)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:614)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1823)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.bonitasoft.engine.platform.StartNodeException: Platform starting failed.
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startNode(PlatformAPIImpl.java:145)
at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:75)
at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:32)
... 13 more
Caused by: org.bonitasoft.engine.transaction.STransactionCommitException: javax.transaction.HeuristicMixedException
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.complete(JTATransactionServiceImpl.java:190)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:296)
at org.bonitasoft.engine.tenant.TenantServicesManager.changeServiceState(TenantServicesManager.java:120)
at org.bonitasoft.engine.tenant.TenantServicesManager.lambda$doStart$0(TenantServicesManager.java:99)
at org.bonitasoft.engine.tenant.TenantServicesManager.inTenantSession(TenantServicesManager.java:137)
at org.bonitasoft.engine.tenant.TenantServicesManager.doStart(TenantServicesManager.java:97)
at org.bonitasoft.engine.tenant.TenantServicesManager.start(TenantServicesManager.java:74)
at org.bonitasoft.engine.tenant.TenantStateManager.start(TenantStateManager.java:101)
at org.bonitasoft.engine.platform.PlatformManager.start(PlatformManager.java:110)
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startNode(PlatformAPIImpl.java:143)
... 15 more
Caused by: javax.transaction.HeuristicMixedException
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1296)
at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:126)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.complete(JTATransactionServiceImpl.java:186)
... 24 more
Suppressed: org.postgresql.xa.PGXAException: Erro ao preparar transação. prepare xid=< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a801a4:c277:5ed68b4a:45, node_name=1, branch_uid=0:ffffc0a801a4:c277:5ed68b4a:53, subordinatenodename=null, eis_name=0 >
at org.postgresql.xa.PGXAConnection.prepare(PGXAConnection.java:360)
at com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord.topLevelPrepare(XAResourceRecord.java:214)
at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2664)
at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2614)
at com.arjuna.ats.arjuna.coordinator.BasicAction.prepare(BasicAction.java:2157)
at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1503)
at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:96)
at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1288)
... 26 more
Caused by: org.postgresql.util.PSQLException: ERRO: transações preparadas estão desabilitadas
Dica: Defina max_prepared_transactions para um valor diferente de zero.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:244)
at org.postgresql.xa.PGXAConnection.prepare(PGXAConnection.java:352)
... 34 more
[CIRCULAR REFERENCE:org.postgresql.xa.PGXAException: Erro ao preparar transação. prepare xid=< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a801a4:c277:5ed68b4a:45, node_name=1, branch_uid=0:ffffc0a801a4:c277:5ed68b4a:53, subordinatenodename=null, eis_name=0 >]
Suppressed: org.postgresql.xa.PGXAException: Error rolling back prepared transaction. rollback xid=< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a801a4:c277:5ed68b4a:45, node_name=1, branch_uid=0:ffffc0a801a4:c277:5ed68b4a:53, subordinatenodename=null, eis_name=0 >, preparedXid=< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a801a4:c277:5ed68b4a:45, node_name=1, branch_uid=0:ffffc0a801a4:c277:5ed68b4a:53, subordinatenodename=null, eis_name=0 >, currentXid={2}
at org.postgresql.xa.PGXAConnection.rollback(PGXAConnection.java:480)
at com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord.topLevelAbort(XAResourceRecord.java:362)
at com.arjuna.ats.arjuna.coordinator.BasicAction.doAbort(BasicAction.java:3023)
at com.arjuna.ats.arjuna.coordinator.BasicAction.doAbort(BasicAction.java:3002)
at com.arjuna.ats.arjuna.coordinator.BasicAction.phase2Abort(BasicAction.java:1981)
at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1519)
at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:96)
at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1288)
... 26 more
Caused by: org.postgresql.util.PSQLException: ERRO: transação preparada com identificador "131077_AAAAAAAAAAAAAP//wKgBpAAAwnde1otKAAAARTE=_AAAAAAAAAAAAAP//wKgBpAAAwnde1otKAAAAUwAAAAAAAAAA" não existe
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:244)
at org.postgresql.xa.PGXAConnection.rollback(PGXAConnection.java:457)
... 34 more

... thanks Júlio

1 answer

1
+1
-1

Hello,

Looking the error message in more details, the solution is given in the stack trace: "Defina max_prepared_transactions para um valor diferente de zero".

See the documentation https://documentation.bonitasoft.com/bonita/7.10/database-configuration and in particular the paragraph about Postgres: you need to set your PostgreSQL server 'max_prepared_transactions' parameter.

Hope this helps

Emmanuel

Comments

Submitted by julio.valenti_1... on Thu, 06/04/2020 - 16:33
Hello! Thank you ...
That's right! Lack of attention from me, I had not removed "#" from the line.

#max_prepared_transactions = 100

Notifications