PI33915: AUTH TOKEN CLEANUP FAILS WITH "SQLEXCEPTION: LOCK WAIT TIMEOUT EXCEEDED; TRY RESTARTING TRANSACTION"

IBM UrbanCode Deploy Fix Pack 2 (6.1.1.2) for 6.1.1
IBM UrbanCode Deploy Fix Pack 3 (6.1.1.3) for 6.1.1
IBM UrbanCode Deploy Fix Pack 4 (6.1.1.4) for 6.1.1
IBM UrbanCode Deploy Fix Pack 5 (6.1.1.5) for 6.1.1
IBM UrbanCode Deploy Fix Pack 6 (6.1.1.6) for 6.1.1
IBM UrbanCode Deploy Fix Pack 7 (6.1.1.7) for 6.1.1
IBM UrbanCode Deploy Fix Pack 8 (6.1.1.8) for 6.1.1
IBM UrbanCode Deploy iFix 1 for 6.1.1.7
IBM UrbanCode Deploy iFix 2 for 6.1.1.8

APAR status

• Closed as program error.

Error description

• Your auth token cleanup will fail occasionally and output the
  following
  error into the server logs:
  
  2015-01-26 15:23:55,873 ERROR DeleteExpiredAuthTokens
  com.urbancode.security.token.AuthTokenCleanupTask - Error
  deleting expired auth tokens
  org.hibernate.exception.GenericJDBCException: could not execute
  update query
  at
  org.hibernate.exception.SQLStateConverter.handledNonSpecificExce
  ption(SQLStateConverter.java:140)
  at
  org.hibernate.exception.SQLStateConverter.convert(SQLStateConver
  ter.java:128)
  at
  org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptio
  nHelper.java:66)
  at
  org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.j
  ava:110)
  at
  org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTra
  nslatorImpl.java:421)
  at
  org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQL
  QueryPlan.java:283)
  at
  org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:12
  88)
  at
  org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:117)
  at
  com.urbancode.security.persistence.hibernate.HibernateAuthTokenF
  actory.deleteExpiredAuthTokens(HibernateAuthTokenFactory.java:60
  )
  at
  com.urbancode.security.token.AuthTokenCleanupTask.run(AuthTokenC
  leanupTask.java:57)
  at java.util.TimerThread.mainLoop(Timer.java:566)
  at java.util.TimerThread.run(Timer.java:516)
  Caused by: java.sql.SQLException: Lock wait timeout exceeded;
  try restarting transaction
  at
  com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
  at
  com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  at
  com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  at
  com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
  at
  com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStateme
  nt.java:1332)
  at
  com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement
  .java:1604)
  at
  com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement
  .java:1519)
  at
  com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement
  .java:1504)
  at
  com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate
  (NewProxyPreparedStatement.java:105)
  at
  org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.j
  ava:101)
  ... 8 more
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All end users                                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The automated auth token cleanup fails with SQL errors. SQL  *
  * errors generally indicate an error around acquiring database *
  * locks and/or deadlocks.                                      *
  *                                                              *
  * This was due to suboptimal database transaction handling.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM UrbanCode Deploy 6.1.1.2                      *
  ****************************************************************
  

Problem conclusion

• Fixed in UrbanCode Deploy 6.1.1.2.
  

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

  UC DEPLOY

• Fixed component ID

  5725M5400

Applicable component levels

• R600 PSN

     UP

• R600 PSY

     UP

• R601 PSN

     UP

• R601 PSY

     UP

• R610 PSN

     UP

• R610 PSY

     UP

• R611 PSN

     UP

• R611 PSY

     UP