JBPM4.4 并发死锁
feng198526
2012-11-26
请教一个问题啊,jbpm只要2个并发就会发现死锁的情况,有人遇到过这种问题吗?应该怎么解决?
Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: select reportjbpm0_.SID as SID62_, reportjbpm0_.dataCopy as dataCopy62_, reportjbpm0_.dataStatus as dataStatus62_, reportjbpm0_.disabled as disabled62_, reportjbpm0_.execUserIDs as execUser5_62_, reportjbpm0_.execedUserIDs as execedUs6_62_, reportjbpm0_.jbpmTaskID as jbpmTaskID62_, reportjbpm0_.KEY_ as KEY8_62_, reportjbpm0_.outComes as outComes62_, reportjbpm0_.prevDate as prevDate62_, reportjbpm0_.processID as processID62_, reportjbpm0_.reportJBPMRelationID as reportJ12_62_, reportjbpm0_.selectCells as selectC13_62_, reportjbpm0_.STATUS_ as STATUS14_62_, reportjbpm0_.subProcess as subProcess62_, reportjbpm0_.subTask as subTask62_, reportjbpm0_.taskDate as taskDate62_, reportjbpm0_.thisBbq as thisBbq62_, reportjbpm0_.thisDate as thisDate62_, reportjbpm0_.thisDimString as thisDim20_62_, reportjbpm0_.thisNodeName as thisNod21_62_, reportjbpm0_.thisReportUnitID as thisRep22_62_, reportjbpm0_.thisTaskCode as thisTas23_62_, reportjbpm0_.transition as transition62_ from JER_REPORTJBPMRELATION reportjbpm0_ where reportjbpm0_.KEY_='402881ed3b175c18013b1776615c001b~201211--~多流程测试~' and reportjbpm0_.thisReportUnitID='402881ed3b175c18013b1776615c001b' and reportjbpm0_.thisBbq='201211--' and reportjbpm0_.thisNodeName='流程准备' and reportjbpm0_.thisTaskCode='多流程测试' and reportjbpm0_.disabled=0 Hibernate: update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=? Hibernate: update JER_REPORTJBPMRELATION set dataCopy=?, dataStatus=?, disabled=?, execUserIDs=?, execedUserIDs=?, jbpmTaskID=?, KEY_=?, outComes=?, prevDate=?, processID=?, reportJBPMRelationID=?, selectCells=?, STATUS_=?, subProcess=?, subTask=?, taskDate=?, thisBbq=?, thisDate=?, thisDimString=?, thisNodeName=?, thisReportUnitID=?, thisTaskCode=?, transition=? where SID=? Hibernate: update JBPM4_HIST_TASK set DBVERSION_=?, EXECUTION_=?, OUTCOME_=?, ASSIGNEE_=?, PRIORITY_=?, STATE_=?, CREATE_=?, END_=?, DURATION_=?, NEXTIDX_=? where DBID_=? and DBVERSION_=? Hibernate: update JBPM4_HIST_ACTINST set DBVERSION_=?, HPROCI_=?, TYPE_=?, EXECUTION_=?, ACTIVITY_NAME_=?, START_=?, END_=?, DURATION_=?, TRANSITION_=?, NEXTIDX_=?, HTASK_=? where DBID_=? and DBVERSION_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: select stringvari_.DBID_, stringvari_.DBVERSION_ as DBVERSION3_1_, stringvari_.KEY_ as KEY4_1_, stringvari_.CONVERTER_ as CONVERTER5_1_, stringvari_.HIST_ as HIST6_1_, stringvari_.EXECUTION_ as EXECUTION7_1_, stringvari_.TASK_ as TASK8_1_, stringvari_.STRING_VALUE_ as STRING14_1_ from JBPM4_VARIABLE stringvari_ where stringvari_.DBID_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: select stringvari_.DBID_, stringvari_.DBVERSION_ as DBVERSION3_1_, stringvari_.KEY_ as KEY4_1_, stringvari_.CONVERTER_ as CONVERTER5_1_, stringvari_.HIST_ as HIST6_1_, stringvari_.EXECUTION_ as EXECUTION7_1_, stringvari_.TASK_ as TASK8_1_, stringvari_.STRING_VALUE_ as STRING14_1_ from JBPM4_VARIABLE stringvari_ where stringvari_.DBID_=? Hibernate: delete from JBPM4_TASK where DBID_=? and DBVERSION_=? Hibernate: select stringvari_.DBID_, stringvari_.DBVERSION_ as DBVERSION3_1_, stringvari_.KEY_ as KEY4_1_, stringvari_.CONVERTER_ as CONVERTER5_1_, stringvari_.HIST_ as HIST6_1_, stringvari_.EXECUTION_ as EXECUTION7_1_, stringvari_.TASK_ as TASK8_1_, stringvari_.STRING_VALUE_ as STRING14_1_ from JBPM4_VARIABLE stringvari_ where stringvari_.DBID_=? Hibernate: select stringvari_.DBID_, stringvari_.DBVERSION_ as DBVERSION3_1_, stringvari_.KEY_ as KEY4_1_, stringvari_.CONVERTER_ as CONVERTER5_1_, stringvari_.HIST_ as HIST6_1_, stringvari_.EXECUTION_ as EXECUTION7_1_, stringvari_.TASK_ as TASK8_1_, stringvari_.STRING_VALUE_ as STRING14_1_ from JBPM4_VARIABLE stringvari_ where stringvari_.DBID_=? Hibernate: select stringvari_.DBID_, stringvari_.DBVERSION_ as DBVERSION3_1_, stringvari_.KEY_ as KEY4_1_, stringvari_.CONVERTER_ as CONVERTER5_1_, stringvari_.HIST_ as HIST6_1_, stringvari_.EXECUTION_ as EXECUTION7_1_, stringvari_.TASK_ as TASK8_1_, stringvari_.STRING_VALUE_ as STRING14_1_ from JBPM4_VARIABLE stringvari_ where stringvari_.DBID_=? Hibernate: select stringvari_.DBID_, stringvari_.DBVERSION_ as DBVERSION3_1_, stringvari_.KEY_ as KEY4_1_, stringvari_.CONVERTER_ as CONVERTER5_1_, stringvari_.HIST_ as HIST6_1_, stringvari_.EXECUTION_ as EXECUTION7_1_, stringvari_.TASK_ as TASK8_1_, stringvari_.STRING_VALUE_ as STRING14_1_ from JBPM4_VARIABLE stringvari_ where stringvari_.DBID_=? Hibernate: select stringvari_.DBID_, stringvari_.DBVERSION_ as DBVERSION3_1_, stringvari_.KEY_ as KEY4_1_, stringvari_.CONVERTER_ as CONVERTER5_1_, stringvari_.HIST_ as HIST6_1_, stringvari_.EXECUTION_ as EXECUTION7_1_, stringvari_.TASK_ as TASK8_1_, stringvari_.STRING_VALUE_ as STRING14_1_ from JBPM4_VARIABLE stringvari_ where stringvari_.DBID_=? Hibernate: select stringvari_.DBID_, stringvari_.DBVERSION_ as DBVERSION3_1_, stringvari_.KEY_ as KEY4_1_, stringvari_.CONVERTER_ as CONVERTER5_1_, stringvari_.HIST_ as HIST6_1_, stringvari_.EXECUTION_ as EXECUTION7_1_, stringvari_.TASK_ as TASK8_1_, stringvari_.STRING_VALUE_ as STRING14_1_ from JBPM4_VARIABLE stringvari_ where stringvari_.DBID_=? Hibernate: select stringvari_.DBID_, stringvari_.DBVERSION_ as DBVERSION3_1_, stringvari_.KEY_ as KEY4_1_, stringvari_.CONVERTER_ as CONVERTER5_1_, stringvari_.HIST_ as HIST6_1_, stringvari_.EXECUTION_ as EXECUTION7_1_, stringvari_.TASK_ as TASK8_1_, stringvari_.STRING_VALUE_ as STRING14_1_ from JBPM4_VARIABLE stringvari_ where stringvari_.DBID_=? Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: insert into JBPM4_VARIABLE (DBVERSION_, KEY_, CONVERTER_, HIST_, EXECUTION_, TASK_, STRING_VALUE_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, 'string', ?) Hibernate: update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=? Hibernate: update JER_REPORTJBPMRELATION set dataCopy=?, dataStatus=?, disabled=?, execUserIDs=?, execedUserIDs=?, jbpmTaskID=?, KEY_=?, outComes=?, prevDate=?, processID=?, reportJBPMRelationID=?, selectCells=?, STATUS_=?, subProcess=?, subTask=?, taskDate=?, thisBbq=?, thisDate=?, thisDimString=?, thisNodeName=?, thisReportUnitID=?, thisTaskCode=?, transition=? where SID=? Hibernate: update JBPM4_HIST_TASK set DBVERSION_=?, EXECUTION_=?, OUTCOME_=?, ASSIGNEE_=?, PRIORITY_=?, STATE_=?, CREATE_=?, END_=?, DURATION_=?, NEXTIDX_=? where DBID_=? and DBVERSION_=? Hibernate: update JBPM4_HIST_ACTINST set DBVERSION_=?, HPROCI_=?, TYPE_=?, EXECUTION_=?, ACTIVITY_NAME_=?, START_=?, END_=?, DURATION_=?, TRANSITION_=?, NEXTIDX_=?, HTASK_=? where DBID_=? and DBVERSION_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: update JBPM4_VARIABLE set EXECUTION_=?, KEY_=? where DBID_=? Hibernate: delete from JBPM4_TASK where DBID_=? and DBVERSION_=? Hibernate: select this_.SID as SID63_13_, this_.approveID as approveID63_13_, this_.bbq as bbq63_13_, this_.dimensionStrs as dimensio4_63_13_, this_.execDay as execDay63_13_, this_.execHour as execHour63_13_, this_.execMinute as execMinute63_13_, this_.execMonth as execMonth63_13_, this_.execSecond as execSecond63_13_, this_.execWeek as execWeek63_13_, this_.execYear as execYear63_13_, this_.extCol1 as extCol12_63_13_, this_.extCol2 as extCol13_63_13_, this_.extCol3 as extCol14_63_13_, this_.extCol4 as extCol15_63_13_, this_.extCol5 as extCol16_63_13_, this_.FUNCTION_ as FUNCTION17_63_13_, this_.isValid as isValid63_13_, this_.joinTime as joinTime63_13_, this_.num as num63_13_, this_.reportUnitID as reportU21_63_13_, this_.TASK_ID as TASK22_63_13_, task2_.SID as SID122_0_, task2_.IndicatorDecimalDefautValue as Indicato2_122_0_, task2_.IndicatorLengthDefautValue as Indicato3_122_0_, task2_.addDelRowColFromulaAdjust as addDelRo4_122_0_, task2_.adjustLevel as adjustLe5_122_0_, task2_.adjustUnitTitleWord as adjustUn6_122_0_, task2_."ALIAS_" as ALIAS7_122_0_, task2_.allowAuditSumUnitData as allowAud8_122_0_, task2_.allowBasicToClientPublish as allowBas9_122_0_, task2_.allowBasicToClientView as allowBa10_122_0_, task2_.allowCopyFromHistory as allowCo11_122_0_, task2_.allowDelRowCol as allowDe12_122_0_, task2_.allowFetchData as allowFe13_122_0_, task2_.allowHistoryLookHistoryData as allowHi14_122_0_, task2_.allowIgnoreDescFormula as allowIg15_122_0_, task2_.allowModifyCode as allowMo16_122_0_, task2_.allowModifyLower as allowMo17_122_0_, task2_.allowOffLineWrite as allowOf18_122_0_, task2_.allowOnLineWrite as allowOn19_122_0_, task2_.allowSubmitOtherUnit as allowSu20_122_0_, task2_.allowSumToClientPublish as allowSu21_122_0_, task2_.allowSumToClientView as allowSu22_122_0_, task2_.allowWriteOther as allowWr23_122_0_, task2_.auditType as auditType122_0_, task2_.autoAddUnit as autoAdd25_122_0_, task2_.autoInheritAuditFlow as autoInh26_122_0_, task2_.autoLockSubmited as autoLoc27_122_0_, task2_.banDelete as banDelete122_0_, task2_.basicUnitCondtion as basicUn29_122_0_, task2_.bestFrequency as bestFre30_122_0_, task2_.bestFrequencyScript as bestFre31_122_0_, task2_.checked as checked122_0_, task2_."CODE_" as CODE33_122_0_, task2_.decimalDigit as decimal34_122_0_, task2_.downloadCondition as downloa35_122_0_, task2_.emergency as emergency122_0_, task2_.endData as endData122_0_, task2_.excel2007Task as excel38_122_0_, task2_.excelContent as excelCo39_122_0_, task2_.fileName as fileName122_0_, task2_.freeSum as freeSum122_0_, task2_.frequency as frequency122_0_, task2_.frequencyScript as frequen43_122_0_, task2_.gradeView as gradeView122_0_, task2_.higherLevelVerifyCondition as higherL45_122_0_, task2_.higherLevelWriteDesc as higherL46_122_0_, task2_.isdel as isdel122_0_, task2_.moreMonth as moreMonth122_0_, task2_."NAME_" as NAME49_122_0_, task2_.noDisplayBest as noDispl50_122_0_, task2_."ORDER_" as ORDER51_122_0_, task2_."PASSWORD" as PASSWORD52_122_0_, task2_.publishDate as publish53_122_0_, task2_.publishReportUnits as publish54_122_0_, task2_.publisher as publisher122_0_, task2_."RELEASE" as RELEASE56_122_0_, task2_.reportCellEditCondtion_ID as reportC79_122_0_, task2_.reportCellVisiableCondtion_ID as reportC75_122_0_, task2_.reportColHiddenCondtion_ID as reportC77_122_0_, task2_.reportCondition as reportC57_122_0_, task2_.reportRowHiddenCondtion_ID as reportR76_122_0_, task2_.reportUnitTitle as reportU58_122_0_, task2_.requireWriteDesc as require59_122_0_, task2_.setNoActive as setNoAc60_122_0_, task2_.startData as startData122_0_, task2_.sumControl as sumControl122_0_, task2_.systemspecific as systems63_122_0_, task2_.TASKGROP_ID as TASKGROP78_122_0_, task2_.taskStatus as taskStatus122_0_, task2_.text as text122_0_, task2_."TYPE_" as TYPE66_122_0_, task2_.useless as useless122_0_, task2_.userCodeVerifyCondition as userCod68_122_0_, task2_.userCodeWriteDesc as userCod69_122_0_, task2_.VERSION_ID as VERSION80_122_0_, task2_.viewOption as viewOption122_0_, task2_.visable as visable122_0_, task2_.writeInstruction as writeIn72_122_0_, task2_.xmlContent as xmlContent122_0_, task2_.xxbTable as xxbTable122_0_, formula3_.sid as sid107_1_, formula3_.alias as alias107_1_, formula3_.BODY_ID as BODY12_107_1_, formula3_.cell as cell107_1_, formula3_."CODE" as CODE4_107_1_, formula3_.compellentCall as compelle5_107_1_, formula3_.excelResolve as excelRes6_107_1_, formula3_.name as name107_1_, formula3_.opration as opration107_1_, formula3_.tip as tip107_1_, formula3_.type as type107_1_, formula3_.version as version107_1_, body4_.SID as SID94_2_, body4_.ColumnNumber as ColumnNu2_94_2_, body4_.ColumnWidth as ColumnWi3_94_2_, body4_.RowHeight as RowHeight94_2_, body4_.RowNumber as RowNumber94_2_, body4_.layout as layout94_2_, body4_.round as round94_2_, body4_.sum as sum94_2_, body4_.version as version94_2_, formula5_.sid as sid107_3_, formula5_.alias as alias107_3_, formula5_.BODY_ID as BODY12_107_3_, formula5_.cell as cell107_3_, formula5_."CODE" as CODE4_107_3_, formula5_.compellentCall as compelle5_107_3_, formula5_.excelResolve as excelRes6_107_3_, formula5_.name as name107_3_, formula5_.opration as opration107_3_, formula5_.tip as tip107_3_, formula5_.type as type107_3_, formula5_.version as version107_3_, formula6_.sid as sid107_4_, formula6_.alias as alias107_4_, formula6_.BODY_ID as BODY12_107_4_, formula6_.cell as cell107_4_, formula6_."CODE" as CODE4_107_4_, formula6_.compellentCall as compelle5_107_4_, formula6_.excelResolve as excelRes6_107_4_, formula6_.name as name107_4_, formula6_.opration as opration107_4_, formula6_.tip as tip107_4_, formula6_.type as type107_4_, formula6_.version as version107_4_, formula7_.sid as sid107_5_, formula7_.alias as alias107_5_, formula7_.BODY_ID as BODY12_107_5_, formula7_.cell as cell107_5_, formula7_."CODE" as CODE4_107_5_, formula7_.compellentCall as compelle5_107_5_, formula7_.excelResolve as excelRes6_107_5_, formula7_.name as name107_5_, formula7_.opration as opration107_5_, formula7_.tip as tip107_5_, formula7_.type as type107_5_, formula7_.version as version107_5_, taskgroup8_.SID as SID125_6_, taskgroup8_.alias as alias125_6_, taskgroup8_.allowNewUnit as allowNew3_125_6_, taskgroup8_.allowReportUnitLogin as allowRep4_125_6_, taskgroup8_.cls as cls125_6_, taskgroup8_."CODE" as CODE6_125_6_, taskgroup8_.COLLECTION_ID as COLLECTION24_125_6_, taskgroup8_.createInstitution as createIn7_125_6_, taskgroup8_.creater as creater125_6_, taskgroup8_.endData as endData125_6_, taskgroup8_.icon as icon125_6_, taskgroup8_.leaf as leaf125_6_, taskgroup8_."NAME" as NAME12_125_6_, taskgroup8_."ORDER" as ORDER13_125_6_, taskgroup8_."RELEASE" as RELEASE14_125_6_, taskgroup8_.REPORTUNITSYSTEM_ID as REPORTU23_125_6_, taskgroup8_.securitySettings as securit15_125_6_, taskgroup8_.startData as startData125_6_, taskgroup8_.taskPublish as taskPub17_125_6_, taskgroup8_.text as text125_6_, taskgroup8_.type as type125_6_, taskgroup8_.url as url125_6_, taskgroup8_.useless as useless125_6_, taskgroup8_.visable as visable125_6_, taskgroupc9_.SID as SID126_7_, taskgroupc9_.cls as cls126_7_, taskgroupc9_."CODE" as CODE3_126_7_, taskgroupc9_."DESC" as DESC4_126_7_, taskgroupc9_.icon as icon126_7_, taskgroupc9_.leaf as leaf126_7_, taskgroupc9_.name as name126_7_, taskgroupc9_.PARENT_ID as PARENT10_126_7_, taskgroupc9_.text as text126_7_, taskgroupc9_.TREEMENU_ID as TREEMENU11_126_7_, taskgroupc9_.url as url126_7_, taskgroupc10_.SID as SID126_8_, taskgroupc10_.cls as cls126_8_, taskgroupc10_."CODE" as CODE3_126_8_, taskgroupc10_."DESC" as DESC4_126_8_, taskgroupc10_.icon as icon126_8_, taskgroupc10_.leaf as leaf126_8_, taskgroupc10_.name as name126_8_, taskgroupc10_.PARENT_ID as PARENT10_126_8_, taskgroupc10_.text as text126_8_, taskgroupc10_.TREEMENU_ID as TREEMENU11_126_8_, taskgroupc10_.url as url126_8_, treemenu11_.sid as sid133_9_, treemenu11_.cls as cls133_9_, treemenu11_."CODE" as CODE3_133_9_, treemenu11_.icon as icon133_9_, treemenu11_.leaf as leaf133_9_, treemenu11_.name as name133_9_, treemenu11_.PARENT_ID as PARENT12_133_9_, treemenu11_."RELEASE" as RELEASE7_133_9_, treemenu11_.text as text133_9_, treemenu11_.type as type133_9_, treemenu11_.url as url133_9_, treemenu11_.visiable as visiable133_9_, children12_.PARENT_ID as PARENT12_15_, children12_.sid as sid15_, children12_.sid as sid133_10_, children12_.cls as cls133_10_, children12_."CODE" as CODE3_133_10_, children12_.icon as icon133_10_, children12_.leaf as leaf133_10_, children12_.name as name133_10_, children12_.PARENT_ID as PARENT12_133_10_, children12_."RELEASE" as RELEASE7_133_10_, children12_.text as text133_10_, children12_.type as type133_10_, children12_.url as url133_10_, children12_.visiable as visiable133_10_, reportunit13_.SID as SID118_11_, reportunit13_."CODE" as CODE2_118_11_, reportunit13_.createInstitution as createIn3_118_11_, reportunit13_.creater as creater118_11_, reportunit13_.description as descript5_118_11_, reportunit13_."NAME" as NAME6_118_11_, reportunit13_.text as text118_11_, version14_.SID as SID129_12_, version14_.majorVersion as majorVer2_129_12_, version14_.minorVersion as minorVer3_129_12_, version14_.strVersion as strVersion129_12_ from JER_TASKAPPROVE this_, JER_TASK task2_, JER_FORMULA formula3_, JER_BODY body4_, JER_FORMULA formula5_, JER_FORMULA formula6_, JER_FORMULA formula7_, JER_TASKGROUP taskgroup8_, JER_TASKGROUPCOLLECTION taskgroupc9_, JER_TASKGROUPCOLLECTION taskgroupc10_, JER_TREEMENU treemenu11_, JER_TREEMENU children12_, JER_REPORTUNITSYSTEM reportunit13_, JER_VERSION version14_ where this_.TASK_ID=task2_.SID(+) and task2_.reportCellEditCondtion_ID=formula3_.sid(+) and formula3_.BODY_ID=body4_.SID(+) and task2_.reportCellVisiableCondtion_ID=formula5_.sid(+) and task2_.reportColHiddenCondtion_ID=formula6_.sid(+) and task2_.reportRowHiddenCondtion_ID=formula7_.sid(+) and task2_.TASKGROP_ID=taskgroup8_.SID(+) and taskgroup8_.COLLECTION_ID=taskgroupc9_.SID(+) and taskgroupc9_.PARENT_ID=taskgroupc10_.SID(+) and taskgroupc10_.TREEMENU_ID=treemenu11_.sid(+) and treemenu11_.sid=children12_.PARENT_ID(+) and taskgroup8_.REPORTUNITSYSTEM_ID=reportunit13_.SID(+) and task2_.VERSION_ID=version14_.SID(+) WARN 26-11 09:13:05,385 - SQL Error: 60, SQLState: 61000 ERROR 26-11 09:13:05,385 - ORA-00060: 等待资源时检测到死锁 ERROR 26-11 09:13:05,395 - Could not synchronize database state with session org.hibernate.exception.LockAcquisitionException: could not delete: [org.jbpm.pvm.internal.task.TaskImpl#80010] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:87) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2546) at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2702) at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:77) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41) at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1562) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305) at org.jbpm.pvm.internal.hibernate.DbSessionImpl.findTaskByExecution(DbSessionImpl.java:311) at org.jbpm.jpdl.internal.activity.TaskActivity.signal(TaskActivity.java:130) at org.jbpm.jpdl.internal.activity.TaskActivity.signal(TaskActivity.java:116) at org.jbpm.pvm.internal.model.op.Signal.perform(Signal.java:70) at org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperationSync(ExecutionImpl.java:673) at org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperation(ExecutionImpl.java:635) at org.jbpm.pvm.internal.model.ExecutionImpl.signal(ExecutionImpl.java:429) at org.jbpm.pvm.internal.model.ExecutionImpl.signal(ExecutionImpl.java:409) at org.jbpm.pvm.internal.task.TaskImpl.complete(TaskImpl.java:237) at org.jbpm.pvm.internal.cmd.CompleteTaskCmd.execute(CompleteTaskCmd.java:65) at org.jbpm.pvm.internal.cmd.CompleteTaskCmd.execute(CompleteTaskCmd.java:32) at org.jbpm.pvm.internal.cmd.CompositeCmd.execute(CompositeCmd.java:42) at org.jbpm.pvm.internal.cmd.CompositeCmd.execute(CompositeCmd.java:34) at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42) at org.jbpm.pvm.internal.tx.SpringCommandCallback.doInTransaction(SpringCommandCallback.java:45) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at org.jbpm.pvm.internal.tx.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:49) at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53) at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40) at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56) at org.jbpm.pvm.internal.svc.TaskServiceImpl.completeTask(TaskServiceImpl.java:105) at com.dtsz.model.service.jbpm.JBPMManager.startProcessInstance(JBPMManager.java:1108) at com.dtsz.model.service.jbpm.JBPMManager$$FastClassByCGLIB$$2bee8ea7.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635) at com.dtsz.model.service.jbpm.JBPMManager$$EnhancerByCGLIB$$fe6a3bac.startProcessInstance(<generated>) at com.dtsz.model.service.jbpm.TaskApproveService.beginTaskApprove(TaskApproveService.java:163) at com.dtsz.model.service.jbpm.TaskApproveService.runTaskApprove(TaskApproveService.java:137) at com.dtsz.model.service.jbpm.TaskApproveService.run(TaskApproveService.java:93) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: java.sql.SQLException: ORA-00060: 等待资源时检测到死锁 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:212) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:951) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1159) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3367) at sun.reflect.GeneratedMethodAccessor77.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at oracle.jdbc.internal.OraclePreparedStatement$$EnhancerByProxool$$7ef814f4.executeUpdate(<generated>) at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2528) ... 53 more INFO 26-11 09:13:05,395 - exception while executing command org.jbpm.pvm.internal.cmd.CompositeCmd@125209a org.hibernate.exception.LockAcquisitionException: could not delete: [org.jbpm.pvm.internal.task.TaskImpl#80010] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:87) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2546) at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2702) at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:77) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41) at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1562) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305) at org.jbpm.pvm.internal.hibernate.DbSessionImpl.findTaskByExecution(DbSessionImpl.java:311) at org.jbpm.jpdl.internal.activity.TaskActivity.signal(TaskActivity.java:130) at org.jbpm.jpdl.internal.activity.TaskActivity.signal(TaskActivity.java:116) at org.jbpm.pvm.internal.model.op.Signal.perform(Signal.java:70) at org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperationSync(ExecutionImpl.java:673) at org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperation(ExecutionImpl.java:635) at org.jbpm.pvm.internal.model.ExecutionImpl.signal(ExecutionImpl.java:429) at org.jbpm.pvm.internal.model.ExecutionImpl.signal(ExecutionImpl.java:409) at org.jbpm.pvm.internal.task.TaskImpl.complete(TaskImpl.java:237) at org.jbpm.pvm.internal.cmd.CompleteTaskCmd.execute(CompleteTaskCmd.java:65) at org.jbpm.pvm.internal.cmd.CompleteTaskCmd.execute(CompleteTaskCmd.java:32) at org.jbpm.pvm.internal.cmd.CompositeCmd.execute(CompositeCmd.java:42) at org.jbpm.pvm.internal.cmd.CompositeCmd.execute(CompositeCmd.java:34) at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42) at org.jbpm.pvm.internal.tx.SpringCommandCallback.doInTransaction(SpringCommandCallback.java:45) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at org.jbpm.pvm.internal.tx.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:49) at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53) at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40) at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56) at org.jbpm.pvm.internal.svc.TaskServiceImpl.completeTask(TaskServiceImpl.java:105) at com.dtsz.model.service.jbpm.JBPMManager.startProcessInstance(JBPMManager.java:1108) at com.dtsz.model.service.jbpm.JBPMManager$$FastClassByCGLIB$$2bee8ea7.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635) at com.dtsz.model.service.jbpm.JBPMManager$$EnhancerByCGLIB$$fe6a3bac.startProcessInstance(<generated>) at com.dtsz.model.service.jbpm.TaskApproveService.beginTaskApprove(TaskApproveService.java:163) at com.dtsz.model.service.jbpm.TaskApproveService.runTaskApprove(TaskApproveService.java:137) at com.dtsz.model.service.jbpm.TaskApproveService.run(TaskApproveService.java:93) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: java.sql.SQLException: ORA-00060: 等待资源时检测到死锁 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:212) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:951) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1159) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3367) at sun.reflect.GeneratedMethodAccessor77.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at oracle.jdbc.internal.OraclePreparedStatement$$EnhancerByProxool$$7ef814f4.executeUpdate(<generated>) at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2528) ... 53 more Hibernate: select this_.DBID_ as DBID1_15_0_, this_.DBVERSION_ as DBVERSION3_15_0_, this_.NAME_ as NAME4_15_0_, this_.DESCR_ as DESCR5_15_0_, this_.STATE_ as STATE6_15_0_, this_.SUSPHISTSTATE_ as SUSPHIST7_15_0_, this_.ASSIGNEE_ as ASSIGNEE8_15_0_, this_.ASSIGNEETYPE_ as ASSIGNEE9_15_0_, this_.EXECREPORTUNIT_ as EXECREP10_15_0_, this_.REPORTTASKCODE_ as REPORTT11_15_0_, this_.TASKDIMENSION_ as TASKDIM12_15_0_, this_.TASKEXECREPORTUNIT_ as TASKEXE13_15_0_, this_.EXECCONDITION_ as EXECCON14_15_0_, this_.ACTIONDESC_ as ACTIONDESC15_15_0_, this_.EXTCOL1_ as EXTCOL16_15_0_, this_.EXTCOL2_ as EXTCOL17_15_0_, this_.EXTCOL3_ as EXTCOL18_15_0_, this_.EXTCOL4_ as EXTCOL19_15_0_, this_.EXTCOL5_ as EXTCOL20_15_0_, this_.FORM_ as FORM21_15_0_, this_.PRIORITY_ as PRIORITY22_15_0_, this_.CREATE_ as CREATE23_15_0_, this_.DUEDATE_ as DUEDATE24_15_0_, this_.PROGRESS_ as PROGRESS25_15_0_, this_.SIGNALLING_ as SIGNALLING26_15_0_, this_.EXECUTION_ID_ as EXECUTION27_15_0_, this_.ACTIVITY_NAME_ as ACTIVITY28_15_0_, this_.HASVARS_ as HASVARS29_15_0_, this_.SUPERTASK_ as SUPERTASK30_15_0_, this_.EXECUTION_ as EXECUTION31_15_0_, this_.PROCINST_ as PROCINST32_15_0_, this_.SWIMLANE_ as SWIMLANE33_15_0_, this_.TASKDEFNAME_ as TASKDEF34_15_0_ from JBPM4_TASK this_ where this_.EXECUTION_=? org.hibernate.exception.LockAcquisitionException: could not delete: [org.jbpm.pvm.internal.task.TaskImpl#80010] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:87) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2546) at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2702) at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:77) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41) at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1562) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305) at org.jbpm.pvm.internal.hibernate.DbSessionImpl.findTaskByExecution(DbSessionImpl.java:311) at org.jbpm.jpdl.internal.activity.TaskActivity.signal(TaskActivity.java:130) at org.jbpm.jpdl.internal.activity.TaskActivity.signal(TaskActivity.java:116) at org.jbpm.pvm.internal.model.op.Signal.perform(Signal.java:70) at org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperationSync(ExecutionImpl.java:673) at org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperation(ExecutionImpl.java:635) at org.jbpm.pvm.internal.model.ExecutionImpl.signal(ExecutionImpl.java:429) at org.jbpm.pvm.internal.model.ExecutionImpl.signal(ExecutionImpl.java:409) at org.jbpm.pvm.internal.task.TaskImpl.complete(TaskImpl.java:237) at org.jbpm.pvm.internal.cmd.CompleteTaskCmd.execute(CompleteTaskCmd.java:65) at org.jbpm.pvm.internal.cmd.CompleteTaskCmd.execute(CompleteTaskCmd.java:32) at org.jbpm.pvm.internal.cmd.CompositeCmd.execute(CompositeCmd.java:42) at org.jbpm.pvm.internal.cmd.CompositeCmd.execute(CompositeCmd.java:34) at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42) at org.jbpm.pvm.internal.tx.SpringCommandCallback.doInTransaction(SpringCommandCallback.java:45) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at org.jbpm.pvm.internal.tx.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:49) at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53) at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40) at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56) at org.jbpm.pvm.internal.svc.TaskServiceImpl.completeTask(TaskServiceImpl.java:105) at com.dtsz.model.service.jbpm.JBPMManager.startProcessInstance(JBPMManager.java:1108) at com.dtsz.model.service.jbpm.JBPMManager$$FastClassByCGLIB$$2bee8ea7.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635) at com.dtsz.model.service.jbpm.JBPMManager$$EnhancerByCGLIB$$fe6a3bac.startProcessInstance(<generated>) at com.dtsz.model.service.jbpm.TaskApproveService.beginTaskApprove(TaskApproveService.java:163) at com.dtsz.model.service.jbpm.TaskApproveService.runTaskApprove(TaskApproveService.java:137) at com.dtsz.model.service.jbpm.TaskApproveService.run(TaskApproveService.java:93) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: java.sql.SQLException: ORA-00060: 等待资源时检测到死锁 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:212) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:951) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1159) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3367) at sun.reflect.GeneratedMethodAccessor77.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at oracle.jdbc.internal.OraclePreparedStatement$$EnhancerByProxool$$7ef814f4.executeUpdate(<generated>) at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2528) ... 53 more |
|
feng198526
2012-11-26
代码有点多了 看样子感觉像是在删除 task的时候出现的问题 ,我在网上找的有人说加上一个索引就好了,但是没有具体说是在什么表的哪个字段加索引,我自己在jbpm中结束了第一个task节点,然后在里面记录了很多东西,然后作为默认结束节点了,是不是因为这个问题引起的?
|
|
cy218115
2012-12-09
是什么原因引起并发?同时对一条流程实例操作么
|