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

Jberet transaction problem

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.3.4.Final
    • Fix Version/s: None
    • Component/s: jberet-core
    • Labels:
      None
    • [QE] How to address?:
      ---
    • [QE] Why QE missed?:
      ---

      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

            Assignee:
            cfang Cheng Fang
            Reporter:
            vokail MArk Mark (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: