Oracle 9.2.0.5 on a Sun Fire V440 8 Gb RAM, 4 CPU, Solaris 9 What could be the potential problem? Please let us know how we can avoid this error in the future? We are currently using Activiti v5.11, Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production and Red Hat 4.1.We run stress tests on our platform and after 2 hours, we meet deadlocks on 2 tables.Į1 8.94 L1 on a Sun Fire V440 4 Gb RAM, 2 CPU, Solaris 9 ![]() Cause: : ORA-00060: deadlock detected while waiting for resource # The error may involve .-Inline # The error occurred while setting parameters # SQL: update ACT_GE_BYTEARRAY set REV_ = ?, BYTES_ = ? where ID_ = ? and REV_ = ? # Cause: : ORA-00060: deadlock detected while waiting for resource at .ExceptionFactory.wrapException(ExceptionFactory.java:23) at .(DefaultSqlSession.java:147) at .db.DbSqlSession.flushUpdates(DbSqlSession.java:650) at .db.DbSqlSession.flush(DbSqlSession.java:460) at .(CommandContext.java:167) at .(CommandContext.java:114) at .(CommandContextInterceptor.java:69) at $1.doInTransaction(SpringTransactionInterceptor.java:42) at .TransactionTemplate.execute(TransactionTemplate.java:130) at .execute(SpringTransactionInterceptor.java:40) at .(LogInterceptor.java:32) at .RuntimeServiceImpl.signal(RuntimeServiceImpl.java:170) at SEVERE: Error while closing command context .PersistenceException: # Error updating database. SQL: update ACT_GE_BYTEARRAY set REV_ = ?, BYTES_ = ? where ID_ = ? and REV_= ?Ĭause: : ORA-00060: deadlock detected while waiting for resource The error occurred while setting parameters ![]() Cause: : ORA-00060: deadlock detected while waiting for resource
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |