Advertisement
mugs

deadlock detected while waiting for resource

Jan 17th, 2018
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 5.85 KB | None | 0 0
  1. 2018-01-17 13:02:15,669 [scheduler_Worker-2] u:/d: ERROR org.apache.ojb.broker.accesslayer.JdbcAccessImpl ::
  2. * SQLException during execution of sql-statement:
  3. * sql statement was 'INSERT INTO FS_OPTION_T (UNIV_FISCAL_YR,ACT_FIN_BAL_TYP_CD,BDGT_CHK_BALTYP_CD,BDGT_CHK_OPTN_CD,UNIV_FSCYR_STRT_YR,UNIV_FSCYR_STRT_MO,FOBJTP_INC_CSH_CD,FOBJTP_XPND_EXP_CD,FOBJTP_XPNDNEXP_CD,FOBJTP_EXPNXPND_CD,FOBJ_TYP_ASSET_CD,FOBJ_TYP_LBLTY_CD,FOBJ_TYP_FNDBAL_CD,EXT_ENC_FBALTYP_CD,INT_ENC_FBALTYP_CD,PRE_ENC_FBALTYP_CD,ELIM_FINBAL_TYP_CD,FOBJTP_INC_NCSH_CD,FOBJTP_CSH_NINC_CD,UNIV_FIN_COA_CD,UNIV_FISCAL_YR_NM,FIN_BEGBALLOAD_IND,CSTSHR_ENCUM_FIN_BAL_TYP_CD,BASE_BDGT_FIN_BAL_TYP_CD,MO_BDGT_FIN_BAL_TYP_CD,FIN_OBJECT_TYP_TRNFR_INC_CD,FIN_OBJECT_TYP_TRNFR_EXP_CD,NMNL_FIN_BAL_TYP_CD,OBJ_ID,VER_NBR) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) '
  4. * Exception message is [ORA-00060: deadlock detected while waiting for resource
  5. ]
  6. * Vendor error code [60]
  7. * SQL state code [61000]
  8. * Target class is 'org.kuali.kfs.sys.businessobject.SystemOptions'
  9. * PK of the target object is [universityFiscalYear=2019]
  10. * Source object: org.kuali.kfs.sys.businessobject.SystemOptions@136b703d[universityFiscalYear=2019,actualFinancialBalanceTypeCd=AC,budgetCheckingBalanceTypeCd=CB,budgetCheckingOptionsCode=true,universityFiscalYearStartYr=2019,universityFiscalYearStartMo=01,finObjectTypeIncomecashCode=IN,finObjTypeExpenditureexpCd=EX,finObjTypeExpendNotExpCode=EE,finObjTypeExpNotExpendCode=ES,financialObjectTypeAssetsCd=AS,finObjectTypeLiabilitiesCode=LI,finObjectTypeFundBalanceCd=FB,extrnlEncumFinBalanceTypCd=EX,intrnlEncumFinBalanceTypCd=IE,preencumbranceFinBalTypeCd=PE,eliminationsFinBalanceTypeCd=TR,finObjTypeIncomeNotCashCd=IC,finObjTypeCshNotIncomeCd=CH,universityFiscalYearName=2019,financialBeginBalanceLoadInd=false,universityFinChartOfAcctCd=<null>,costShareEncumbranceBalanceTypeCd=CE,baseBudgetFinancialBalanceTypeCd=BB,monthlyBudgetFinancialBalanceTypeCd=MB,financialObjectTypeTransferIncomeCd=TI,financialObjectTypeTransferExpenseCd=TE,nominalFinancialBalanceTypeCd=NB,versionNumber=2,objectId=a9f29966-7859-41d7-8f0f-749ff56fd1c1,newCollectionRecord=false]
  11. * The root stack trace is -->
  12. * java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
  13.  
  14.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
  15.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  16.     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
  17.     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
  18.     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
  19.     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
  20.     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
  21.     at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
  22.     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
  23.     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
  24.     at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
  25.     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
  26.     at org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedStatement.java:102)
  27.     at sun.reflect.GeneratedMethodAccessor209.invoke(Unknown Source)
  28.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  29.     at java.lang.reflect.Method.invoke(Method.java:606)
  30.     at net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:393)
  31.     at net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:175)
  32.     at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:277)
  33.     at com.sun.proxy.$Proxy69.executeUpdate(Unknown Source)
  34.     at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source)
  35.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source)
  36.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
  37.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
  38.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
  39.     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source)
  40.     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source)
  41.     at org.kuali.kfs.sys.batch.dataaccess.impl.FiscalYearMakersDaoOjb.createNewYearRows(FiscalYearMakersDaoOjb.java:144)
  42.     at org.kuali.kfs.sys.batch.service.impl.FiscalYearMakerServiceImpl.runProcess(FiscalYearMakerServiceImpl.java:103)
  43.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  44.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  45.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  46.     at java.lang.reflect.Method.invoke(Method.java:606)
  47.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  48.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  49.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  50.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  51.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  52.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  53.     at com.sun.proxy.$Proxy226.runProcess(Unknown Source)
  54.     at org.kuali.kfs.sys.batch.FiscalYearMakerStep.execute(FiscalYearMakerStep.java:32)
  55.     at org.kuali.kfs.sys.batch.Job.runStep(Job.java:175)
  56.     at org.kuali.kfs.sys.batch.Job.execute(Job.java:121)
  57.     at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
  58.     at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement