Highlighted

DB2 exclusive Lock issue

Avatar

Guest

28-10-2008

While starting Adobe LiveCycle ES Rights managment v8.2.1, on WebSphere I see in SystemOut.log



00000035 DSCJobStoreTX E org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler manage MisfireHandl

er: Error handling misfires: Failure obtaining db row lock: The current transaction has been rolled back because of a deadlock or ti

meout. Reason code "2".

org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: The current transaction

has been rolled back because of a deadlock or timeout. Reason code "2". [See nested exception: com.ibm.db2.jcc.b.SqlException: The

current transaction has been rolled back because of a deadlock or timeout. Reason code "2".]

at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:112)

at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:112)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3027)

at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3789)

at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3809)

Caused by: com.ibm.db2.jcc.b.SqlException: The current transaction has been rolled back because of a deadlock or timeout. Reason co

de "2".

at com.ibm.db2.jcc.b.eh.b(eh.java:3071)

at com.ibm.db2.jcc.a.eb.h(eb.java:268)

at com.ibm.db2.jcc.a.eb.a(eb.java:229)

at com.ibm.db2.jcc.a.eb.c(eb.java:33)

at com.ibm.db2.jcc.a.u.a(u.java:34)

at com.ibm.db2.jcc.a.j.Lb(j.java:258)

at com.ibm.db2.jcc.b.eh.Q(eh.java:2921)

at com.ibm.db2.jcc.a.d.g(d.java:1444)

at com.ibm.db2.jcc.b.eb.a(eb.java:191)

at com.ibm.db2.jcc.b.eh.c(eh.java:297)

at com.ibm.db2.jcc.b.eh.next(eh.java:242)

at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.java:2468)

at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:93)

... 4 more

----

Also My DBA complaining about exclusive locks on Database, where they cant perform Admin job on Database like online backups.