Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

DB2 exclusive Lock issue

Avatar

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.