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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

DB2 exclusive Lock issue

Avatar

Not applicable
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