PI30258: MYSQL BROKEN PIPE CAUSES CALENDAR SERVICE TO STOP

IBM UrbanCode Deploy Fix Pack 1 (6.1.1.1) for 6.1.1
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

• When the MySQL database encounters a broken pipe with its
  connection to UrbanCode Deploy, you will notice that the
  calendar service stops working. All deployments on the dashboard
  will show the
  "Scheduled" state and cannot be canceled. You will need to
  restart the server to restore the connection.
  
  You will see this issue only on MySQL and not
  on other database types.
  

Local fix

• Restart the UCD server.
  
  
  This issue can be diagnosed by finding a similar error in the
  server's error log:
  
  2014-11-19 14:26:24,757 WARN ActiveMQ Task-119797
  org.apache.activemq.network.DiscoveryNetworkConnector - Could
  not start network bridge between: vm://server?network=true and:
  ah3://hostname:7918 due to: java.net.ConnectException:
  Connection refused 2014-11-19 14:26:28,437 WARN
  AsynEventService-0 com.mchange.v2.c3p0.impl.NewPooledConnection
  - [c3p0] A PooledConnection that has already signalled a
  Connection error is still in use! 2014-11-19 14:26:28,437 WARN
  AsynEventService-0 com.mchange.v2.c3p0.impl.NewPooledConnection
  - [c3p0] Another error has occurred [
  com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException:
  No operations allowed after connection closed.Connection was
  implicitly closed due to underlying exception/error: ** BEGIN
  NESTED EXCEPTION ** com.mysql.jdbc.CommunicationsException
  MESSAGE: Communications link failure due to underlying
  exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException
  MESSAGE: Broken pipe STACKTRACE: java.net.SocketException:
  Broken pipe at java.net.SocketOutputStream.socketWrite0(Native
  Method) at
  java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:
  124) at
  java.net.SocketOutputStream.write(SocketOutputStream.java:170)
  at
  java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.ja
  va:93) at
  java.io.BufferedOutputStream.flush(BufferedOutputStream.java:151
  ) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * User using MySQL as their UCD database                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * UCD reports errors such as "Communications link failure due  *
  * to underlying exception" caused by "Broken pipe" in the      *
  * server log.                                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Issue is resolved in UCD 6.1.1.1.
  

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

• R611 PSN

     UP

• R611 PSY

     UP