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

Details

    • Bug
    • Status: Verified (View Workflow)
    • Critical
    • Resolution: Done
    • 7.3.7.GA
    • 7.3.8.CR1, 7.3.8.GA
    • Batch
    • None
    • 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.
    • +

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: