Uploaded image for project: 'JBeret'
  1. JBeret
  2. JBERET-504

Jberet transaction problem

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • None
    • 1.3.4.Final
    • jberet-core
    • 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

       

      Attachments

        Activity

          People

            weli@redhat.com Weinan Li
            a_pakla@yahoo.it MArk Mark (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: