jbpm中deploy的时候出现死锁问题。
发现数据库中以下三个表被锁定
JBPM4_LOB
JBPM4_DEPLOYMENT
JBPM4_DEPLOYPROP
然后控制台不断重复打印下面的sql语句,像死循环一样,求解。
网上说加上索引就好了,不知道具体在哪张表哪个字段上加索引呢?求解
Hibernate:
select
deployment0_.dbid_ as dbid1_43_0_,
deployment0_.name_ as name2_43_0_,
deployment0_.timestamp_ as timestamp3_43_0_,
deployment0_.state_ as state4_43_0_
from
jbpm4_deployment deployment0_
where
deployment0_.dbid_=?
Hibernate:
select
resources0_.deployment_ as deployment4_43_1_,
resources0_.dbid_ as dbid1_1_,
resources0_.name_ as name5_1_,
resources0_.dbid_ as dbid1_33_0_,
resources0_.dbversion_ as dbversion2_33_0_,
resources0_.blob_value_ as blob3_33_0_
from
jbpm4_lob resources0_
where
resources0_.deployment_=?
Hibernate:
select
objectprop0_.deployment_ as deployment2_43_1_,
objectprop0_.dbid_ as dbid1_1_,
objectprop0_.dbid_ as dbid1_44_0_,
objectprop0_.deployment_ as deployment2_44_0_,
objectprop0_.objname_ as objname3_44_0_,
objectprop0_.key_ as key4_44_0_,
objectprop0_.stringval_ as stringval5_44_0_,
objectprop0_.longval_ as longval6_44_0_
from
jbpm4_deployprop objectprop0_
where
objectprop0_.deployment_=?