Expand my Community achievements bar.

Guidelines for the Responsible Use of Generative AI in the Experience Cloud Community.

DB2 exclusive Lock issue

Avatar

Former Community Member
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.
0 Replies