My Looper job iterations are staying in QUEUE state after first 10 iterations are completed

I have 180 iterations returned by Looper and I have setup the parallel limit as 10 in looper start. After starting the looper the first 10 iterations completed successfully and after that all the jobs are staying in QUEUE change.

My Looper job iterations are staying in QUEUE state after first 10 iterations are completed

Iterations in QUEUE:

My Looper job iterations are staying in QUEUE state after first 10 iterations are completed

Beginner Asked on August 4, 2020 in Diyotta Studio.
Add Comment
1 Answer(s)

Hi Karthik,

Below are the recommended configurations at the controller and Admin level to overcome this IN QUEUE issue when jobs are running in parallel.

  1. In the postgresql.conf  file present at location [diyotta/controller-repo/direpdata/] Change the max_connections value to 1000 (max_connections =1000).
  2. In the diserver.config file present at location [diyotta/controller/conf/]  change the hibernate.c3p0.max_size value to 850 (hibernate.c3p0.max_size = 850)
  3. In the admin module move to the property [Admin à Configurations à Diyotta Constants Settings ] change the ops.OPS_NO_OF_THREADS value to 800 (ops.OPS_NO_OF_THREADS = 800).
  4. When we are trying to run the parallel instances using Looper make sure we are running 10 parallel instances at once.

 

Note: After making the above changes, restart the controller and then run the jobs.

Ideally consider this max_connections > hibernate.c3p0.max_size  >  OPS_NO_OF_THREADS

OPS_NO_OF_THREADS should be less then hibernate.c3p0.max_size. If you are making max_connection to 1000 then change max_size to 850 or 900.. keep the difference of at least 150-100 connections

 

Expert Answered on August 10, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.