PI04719: DEADLOCK IN UPDATING LRS.JOBSTATUS TABLE.

8.5.5.2: WebSphere Application Server V8.5.5 Fix Pack 2
8.0.0.4: WebSphere Extended Deployment Compute Grid V8.0 Fix Pack 4
8.5.5.3: WebSphere Application Server V8.5.5 Fix Pack 3
8.5.5.4: WebSphere Application Server V8.5.5 Fix Pack 4
8.5.5.5: WebSphere Application Server V8.5.5 Fix Pack 5
8.5.5.6: WebSphere Application Server V8.5.5 Fix Pack 6
8.5.5.7: WebSphere Application Server V8.5.5 Fix Pack 7
8.5.5.8: WebSphere Application Server V8.5.5 Fix Pack 8
8.5.5.9: WebSphere Application Server V8.5.5 Fix Pack 9
8.5.5.10: WebSphere Application Server V8.5.5 Fix Pack 10
8.0.0.5: WebSphere Extended Deployment Compute Grid V8.0 Fix Pack 5
8.5.5.11: WebSphere Application Server V8.5.5 Fix Pack 11
8.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12
8.5.5.13: WebSphere Application Server V8.5.5 Fix Pack 13
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14
8.5.5.15: WebSphere Application Server V8.5.5 Fix Pack 15
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14

APAR status

• Closed as program error.

Error description

• Deadlock in updating LRS.JOBSTATUS table.  The scheduler logs
  shows the following error:
  
  [10/15/13 7:05:36:605 CDT] 0000006c SchedulerSing E
  CWLRB3020E: [Long Running Job Scheduler
  cell_cgpilot01b/pfgdsmbatchq701/batch0LRS_q701] failed:
  com.ibm.db2.jcc.am.SqlTransactionRollbackException: DB2 SQL
  Error: SQLCODE=-911, SQLSTATE=40001, SQLERRMC=68, DRIVER=3.61.75
   at com.ibm.db2.jcc.am.ed.a(ed.java:663)
   at com.ibm.db2.jcc.am.ed.a(ed.java:60)
   at com.ibm.db2.jcc.am.ed.a(ed.java:127)
   at com.ibm.db2.jcc.am.gn.c(gn.java:2554)
   at com.ibm.db2.jcc.t4.cb.s(cb.java:967)
   at com.ibm.db2.jcc.t4.cb.k(cb.java:404)
   at com.ibm.db2.jcc.t4.cb.a(cb.java:61)
   at com.ibm.db2.jcc.t4.q.a(q.java:50)
   at com.ibm.db2.jcc.t4.sb.b(sb.java:228)
   at com.ibm.db2.jcc.am.hn.mc(hn.java:2924)
   at com.ibm.db2.jcc.am.hn.b(hn.java:3873)
   at com.ibm.db2.jcc.am.hn.ec(hn.java:720)
   at com.ibm.db2.jcc.am.hn.executeUpdate(hn.java:703)
   at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement
  .pmiExecuteUpda te(WSJdbcPreparedStatement.java:1152)
   at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement
  .executeUpdate( WSJdbcPreparedStatement.java:793)
   at com.ibm.ws.batch.JobStatusStoreImpl.update
  (JobStatusStoreImpl.ja va:194)
   at com.ibm.ws.batch.SchedulerSingleton.updateJobStatus
  (SchedulerSin gleton.java:5376)
   at
  com.ibm.ws.batch.PGCJobStatusProcessor._updateJobStatusInDB
  (PGCJ obStatusProcessor.java:229)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  WebSphere Compute Grid V8 and WebSphere     *
  *                  Application Server V855 users of the batch  *
  *                  function.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Job Scheduler JobStatus table could     *
  *                      not be updated due to a deadlock        *
  *                      condition.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When attempting to update the Job Scheduler JobStatus table,
  the update fails and the following error is shown in the logs:
  [10/15/13 7:05:36:605 CDT] 0000006c SchedulerSing E
  CWLRB3020E: [Long Running Job Scheduler
  cell_cgpilot01b/pfgdsmbatchq701/batch0LRS_q701] failed:
  com.ibm.db2.jcc.am.SqlTransactionRollbackException: DB2 SQL
  Error: SQLCODE=-911, SQLSTATE=40001, SQLERRMC=68,
  DRIVER=3.61.75
  

Problem conclusion

• During a cancel or stop request, if an exception was received
  in sending the request to the endpoint, the connection to the
  JobStatus table was not being committed causing a lock to be
  held open on that table and preventing further updates.
  
  The fix for this APAR is currently targeted for inclusion in
  WebSphere Compute Grid fixpack 8.0.0.4 and WebSphere
  Application Server fixpack 8.5.5.2. Please refer to the
  Recommended Updates page for delivery information:
  http://www.ibm.com/support/docview.wss?uid=swg27022998 or
  http://www.ibm.com/support/docview.wss?uid=swg27036319
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WXD COMPUTE GRI

• Fixed component ID

  5725C9301

Applicable component levels

• R800 PSY

     UP