Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-21992

[GSS](7.3.z) WFLY-14275 - Large job repository is blocking deployment

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • 7.3.8.CR1, 7.3.8.GA
    • 7.3.7.GA
    • Batch
    • None
    • False
    • False
    • +
    • Undefined
    • Hide
      • perpare your job repository to have a lot of jobinstances of "job1"
        for an oracle database you can execute:

      begin
      for v in 1 .. 100000
      {{ loop}}
      insert into job_instance (jobinstanceid, jobname)
      {{ values (JOB_INSTANCE_SEQ.nextval, 'job1');}}
      {{ end loop;}}
      {{ commit;}}
      end;
      /

      • deploy the sample application, containg a simple job named 'job1' using java 11+
        mvn wildfly:deploy

      You will see a long delay (2 mins) while deploying:

      10:19:29,832 MEZ INFO [org.wildfly.extension.undertow] (ServerService Thread Pool – 358) WFLYUT0021: Registered web context: '/jberet-deploy' for server 'default-server'
      10:21:18,964 MEZ INFO [org.jboss.as.server] (management-handler-thread - 2) WFLYSRV0010: Deployed "jberet-deploy.war" (runtime-name : "jberet-deploy.war")

      Having more different jobs with a lot of job repository entries you will not be able to deploy this little app. This works fine in WildFLy 13.

      Show
      perpare your job repository to have a lot of jobinstances of "job1" for an oracle database you can execute: begin for v in 1 .. 100000 {{ loop}} insert into job_instance (jobinstanceid, jobname) {{ values (JOB_INSTANCE_SEQ.nextval, 'job1');}} {{ end loop;}} {{ commit;}} end; / deploy the sample application, containg a simple job named 'job1' using java 11+ mvn wildfly:deploy You will see a long delay (2 mins) while deploying: 10:19:29,832 MEZ INFO [org.wildfly.extension.undertow] (ServerService Thread Pool – 358) WFLYUT0021: Registered web context: '/jberet-deploy' for server 'default-server' 10:21:18,964 MEZ INFO [org.jboss.as.server] (management-handler-thread - 2) WFLYSRV0010: Deployed "jberet-deploy.war" (runtime-name : "jberet-deploy.war") Having more different jobs with a lot of job repository entries you will not be able to deploy this little app. This works fine in WildFLy 13.

      We are updating from WildFly 13 (jberet 1.2.4) to WildFly 21.0.2 (jberet 1.3.7).

      In our production environment we are running about 50 jobs, some of them in a frequency of 2 or 4 minutes. For documentation reasons we only can delete job information older than 3 months. So we have 20000 and more jobinstances per job in our job repository - an oracle database job repo.

      Deploying of our Job-Module to WildFly 21 is never finished - sometimes a out of memory exception is thrown.

      Note: this issue only provides partial solution - it avoids excessive refreshing of job executoins as described in this comment. Another fix is to be brought by a follow up issue.

            thofman Tomas Hofman
            rhn-support-aogburn Aaron Ogburn
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: