Details
-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
1.3.4.Final
-
None
-
Undefined
Description
My environment:
- Java 11.0.4
- Wildfly 20.0.1.Final
- Jberet 1.3.4.Final
- job persistence on postgres
Today in a test environment a a job does not start up as usual.
After investigation on job_execution table, job status is STARTING, but no start_time i s set, see image:
https://i.stack.imgur.com/xHkvy.png
Looking in wildfly's server.log reveal following error:
2020-12-21 10:36:00,440 ERROR stderr Exception in thread "Batch Thread - 3" javax.batch.operations.BatchRuntimeException: JBERET000626: Failed to run UPDATE JOB_EXECUTION SET LASTUPDATEDTIME=?, STARTTIME=?, BATCHSTATUS=? WHERE JOBEXECUTIONID=?
2020-12-21 10:36:00,440 ERROR stderr at org.jberet.jberet-core@1.3.4.Final//org.jberet.repository.JdbcRepository.updateJobExecution(JdbcRepository.java:497)
2020-12-21 10:36:00,440 ERROR stderr at org.wildfly.extension.batch.jberet@17.0.1.Final//org.wildfly.extension.batch.jberet.job.repository.JobRepositoryService.updateJobExecution(JobRepositoryService.java:134)
2020-12-21 10:36:00,440 ERROR stderr at org.wildfly.extension.batch.jberet@17.0.1.Final//org.wildfly.extension.batch.jberet.job.repository.JdbcJobRepositoryService.updateJobExecution(JdbcJobRepositoryService.java:44)
2020-12-21 10:36:00,440 ERROR stderr at org.jberet.jberet-core@1.3.4.Final//org.jberet.runtime.runner.JobExecutionRunner.run(JobExecutionRunner.java:49)
2020-12-21 10:36:00,440 ERROR stderr at org.wildfly.security.elytron-private@1.9.1.Final//org.wildfly.security.auth.server.SecurityIdentity.runAsConsumer(SecurityIdentity.java:361)
2020-12-21 10:36:00,440 ERROR stderr at org.wildfly.security.elytron-private@1.9.1.Final//org.wildfly.security.auth.server.Scoped.runAsConsumer(Scoped.java:112)
2020-12-21 10:36:00,441 ERROR stderr at org.wildfly.security.elytron-private@1.9.1.Final//org.wildfly.security.auth.server.Scoped.runAs(Scoped.java:60)
2020-12-21 10:36:00,441 ERROR stderr at org.wildfly.extension.batch.jberet@17.0.1.Final//org.wildfly.extension.batch.jberet.deployment.BatchEnvironmentService$WildFlyBatchEnvironment$1.run(BatchEnvironmentService.java:182)
2020-12-21 10:36:00,441 ERROR stderr at org.wildfly.extension.request-controller@9.0.2.Final//org.wildfly.extension.requestcontroller.RequestController$QueuedTask$1.run(RequestController.java:494)
2020-12-21 10:36:00,441 ERROR stderr at org.jberet.jberet-core@1.3.4.Final//org.jberet.spi.JobExecutor$2.run(JobExecutor.java:149)
2020-12-21 10:36:00,441 ERROR stderr at org.jberet.jberet-core@1.3.4.Final//org.jberet.spi.JobExecutor$1.run(JobExecutor.java:99)
2020-12-21 10:36:00,441 ERROR stderr at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
2020-12-21 10:36:00,447 ERROR stderr at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
2020-12-21 10:36:00,449 ERROR stderr at java.base/java.lang.Thread.run(Thread.java:834)
2020-12-21 10:36:00,450 ERROR stderr at org.jboss.threads@2.3.3.Final//org.jboss.threads.JBossThread.run(JBossThread.java:485)
2020-12-21 10:36:00,450 ERROR stderr Caused by: java.sql.SQLException: IJ031070: Transaction cannot proceed: STATUS_ROLLEDBACK
2020-12-21 10:36:00,450 ERROR stderr at org.jboss.ironjacamar.jdbcadapters@1.4.16.Final//org.jboss.jca.adapters.jdbc.WrapperDataSource.checkTransactionActive(WrapperDataSource.java:271)
2020-12-21 10:36:00,450 ERROR stderr at org.jboss.ironjacamar.jdbcadapters@1.4.16.Final//org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransactionActive(WrappedConnection.java:1989)
2020-12-21 10:36:00,450 ERROR stderr at org.jboss.ironjacamar.jdbcadapters@1.4.16.Final//org.jboss.jca.adapters.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:2004)
2020-12-21 10:36:00,450 ERROR stderr at org.jboss.ironjacamar.jdbcadapters@1.4.16.Final//org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1978)
2020-12-21 10:36:00,451 ERROR stderr at org.jboss.ironjacamar.jdbcadapters@1.4.16.Final//org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:469)
2020-12-21 10:36:00,451 ERROR stderr at org.jberet.jberet-core@1.3.4.Final//org.jberet.repository.JdbcRepository.updateJobExecution(JdbcRepository.java:474)
2020-12-21 10:36:00,451 ERROR stderr ... 14 more