Unable to deploy application

Hi Team,

Unable to deploy Camunda 7.16 embedded spring boot application , there is a initial lock on the table ACT_GE_BYTEARRAY i see below query being executed but result is not getting return and application stands still

select B.*
from ACT_GE_BYTEARRAY B
inner join
(select B.NAME_, MAX(D.DEPLOY_TIME_) DEPLOY_TIME_
from ACT_GE_BYTEARRAY B
inner join ACT_RE_DEPLOYMENT D
on B.DEPLOYMENT_ID_ = D.ID_
where D.NAME_ = ‘workflow1’
and
(D.SOURCE_ is null or
D.SOURCE_ = ‘process application’
)

     and B.NAME_ in 
      (  
   
      , 
       'BOOT-INF/classes/process.bpmn'

      ) 
   group by B.NAME_) LAST_RESOURCE
 on B.NAME_ = LAST_RESOURCE.NAME_
 inner join ACT_RE_DEPLOYMENT D
 on B.DEPLOYMENT_ID_ = D.ID_
 and D.DEPLOY_TIME_ = LAST_RESOURCE.DEPLOY_TIME_ 
 and D.NAME_ = 'workflow1'
 and
   (D.SOURCE_ is null or
   D.SOURCE_ = 'process application'
   )

   and D.TENANT_ID_ is null
 order by B.ID_ asc

Hello \o

Is your database working correctly?

Is there a log you can send us to try to help?

William Robert Alves


there is no error/exception in the logs, application stands still after executing above query, and it remains the same

Hi @gowtham_m,

my rough guess is that you start a cluster of Camunda 7 engines at the same time, and they interfere in deploying BPMN files at the same time.

If that is the case, you should configure them to start with a short delay, one after another.

Hope this helps, Ingo

Hi @Ingo_Richtsmeier ,

thought so for that we added below property, so that there is deployment,lock exception
camunda.bpm[“generic-properties.properties”].deploymentLockUsed: false