Uploaded image for project: 'WildFly'
  1. WildFly
  2. WFLY-14275

Large job repository is blocking deployment

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • 23.0.0.Beta1, 23.0.0.Final
    • None
    • 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.      
    • Undefined
    • ---
    • ---

      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.

       

            cfang@redhat.com Cheng Fang
            gvwolf3d Gunther vw (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: