PH56140: KEYROTATE FAILS IF DATABASE CONNECTIONS TIME OUT

APAR status

• Closed as program error.

Error description

• Running the keyrotate for over a week results in failure if
  database lost connection
  
  Error log:
  Rotating keys (dry run -- no rows updated)...
  com.microsoft.sqlserver.jdbc.SQLServerException: Connection
  reset by peer: socket write error
  at
  com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLSe
  rverConnection.java:2924)
  at
  com.microsoft.sqlserver.jdbc.TDSChannel.write(IOBuffer.java:2045
  )
  at
  com.microsoft.sqlserver.jdbc.TDSWriter.flush(IOBuffer.java:4146)
  at
  com.microsoft.sqlserver.jdbc.TDSWriter.writePacket(IOBuffer.java
  :4048)
  at
  com.microsoft.sqlserver.jdbc.TDSWriter.endMessage(IOBuffer.java:
  3185)
  at
  com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.j
  ava:7556)
  at
  com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecut
  ePreparedStatement(SQLServerPreparedStatement.java:592)
  at
  com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmt
  ExecCmd.doExecute(SQLServerPreparedStatement.java:524)
  at
  com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:71
  94)
  at
  com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(
  SQLServerConnection.java:2979)
  at
  com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(S
  QLServerStatement.java:248)
  at
  com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement
  (SQLServerStatement.java:223)
  at
  com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQ
  uery(SQLServerPreparedStatement.java:446)
  at
  com.urbancode.ds.tools.keyrotate.AbstractAuthXRealmPropTableRota
  ter.rotate(AbstractAuthXRealmPropTableRotater.java:43)
  at
  com.urbancode.ds.tools.keyrotate.KeyRotateTool.rotateTableKeys(K
  eyRotateTool.java:172)
  at
  com.urbancode.ds.tools.keyrotate.KeyRotateTool.rotateKeys(KeyRot
  ateTool.java:146)
  at
  com.urbancode.ds.tools.keyrotate.KeyRotateTool.run(KeyRotateTool
  .java:107)
  at
  com.urbancode.ds.tools.keyrotate.KeyRotateTool.main(KeyRotateToo
  l.java:37)
  ...
  Suppressed: com.microsoft.sqlserver.jdbc.SQLServerException: The
  connection is closed.
  at
  com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverEr
  ror(SQLServerException.java:234)
  at
  com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQL
  ServerConnection.java:1090)
  at
  com.microsoft.sqlserver.jdbc.SQLServerConnection.rollback(SQLSer
  verConnection.java:3195)
  at
  com.urbancode.ds.tools.keyrotate.ConnectionWrapper.rollback(Conn
  ectionWrapper.java:44)
  at
  com.urbancode.ds.tools.keyrotate.AbstractAuthXRealmPropTableRota
  ter.rotate(AbstractAuthXRealmPropTabl
  eRotater.java:61)
  ... 11 more
  Caused by: java.net.SocketException: Connection reset by peer:
  socket write error
  at java.base/java.net.SocketOutputStream.socketWrite0(Native
  Method)
  at
  java.base/java.net.SocketOutputStream.socketWrite(SocketOutputSt
  ream.java:110)
  at
  java.base/java.net.SocketOutputStream.write(SocketOutputStream.j
  ava:150)
  at
  com.microsoft.sqlserver.jdbc.TDSChannel.write(IOBuffer.java:2040
  )
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Keyrotation Users                                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Keyrotate fails if database connections time out             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Fix is provided in IBM UrbanCode Deploy 7.2.3.7              *
  ****************************************************************
  

Problem conclusion

• Fix is provided in IBM UrbanCode Deploy 7.2.3.7
  

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