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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Verified (View Workflow)
    • Critical
    • Resolution: Done
    • 7.4.0.GA
    • 7.4.1.CR1, 7.4.1.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.

    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 the follow up issue JBEAP-22172.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: