Hi !
I have installed Camunda on Tomcat working on Postgresql. There aren’t any deployed processed. When started, the Tomcat server sends a lots of queries (about 300 per sec) such:
2019-10-30 10:54:14.020 MSK,"camunda","postgres",12120,"127.0.0.1:58180",5db93fb1.2f58,354687,"",2019-10-30 10:45:53 MSK,14/118221,0,СООБЩЕНИЕ,00000,"выполнение S_2: BEGIN",,,,,,,,,"PostgreSQL JDBC Driver"
2019-10-30 10:54:14.020 MSK,"camunda","postgres",12120,"127.0.0.1:58180",5db93fb1.2f58,354688,"",2019-10-30 10:45:53 MSK,14/118221,0,СООБЩЕНИЕ,00000,"выполнение S_3: select RES.ID_,
RES.REV_,
RES.DUEDATE_,
RES.PROCESS_INSTANCE_ID_,
RES.EXCLUSIVE_
from ACT_RU_JOB RES
where (RES.RETRIES_ > 0)
and (
RES.DUEDATE_ is null or
RES.DUEDATE_ <= $1
)
and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ < $2)
and RES.SUSPENSION_STATE_ = 1
and (
(
RES.EXCLUSIVE_ = true
and not exists(
select J2.ID_ from ACT_RU_JOB J2
where J2.PROCESS_INSTANCE_ID_ = RES.PROCESS_INSTANCE_ID_ -- from the same proc. inst.
and (J2.EXCLUSIVE_ = true) -- also exclusive
and (J2.LOCK_OWNER_ is not null and J2.LOCK_EXP_TIME_ >= $3) -- in progress
)
)
or
RES.EXCLUSIVE_ = false
)
LIMIT $4 OFFSET $5","параметры: $1 = '2019-10-30 10:54:14.02', $2 = '2019-10-30 10:54:14.02', $3 = '2019-10-30 10:54:14.02', $4 = '3', $5 = '0'",,,,,,,,"PostgreSQL JDBC Driver"
2019-10-30 10:54:14.021 MSK,"camunda","postgres",12120,"127.0.0.1:58180",5db93fb1.2f58,354689,"",2019-10-30 10:45:53 MSK,14/118221,0,СООБЩЕНИЕ,00000,"выполнение S_1: COMMIT",,,,,,,,,"PostgreSQL JDBC Driver"
In that case the server is overloaded.
Only bpm-platform were changed from distributive (attach)
bpm-platform.xml (3.7 KB)