Distributed EOP Install or Upgrade Issues with Azure MySQL Database

  • Updated

Issue

When using an Azure MySQL database, installation or upgrade of an EOP install appears to make some progress but then fails despite frequent restarts of the Contrast Service service with errors in the contrast.log such as:

110919 09.45.19,507 {} {} {} WARN (ProxyConnection.java:161) springHikariCP - Connection com.mysql.jdbc.JDBC4Connection@73c01236 marked as broken because of SQLSTATE(08003), ErrorCode(0)
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.

Cause

The default Azure database idle timeout value of 180 seconds may be too short when a full ("CACHE" included) install is being performed.

Resolution

In the Azure management portal, look for wait_timeout in the database Server Parameters.  Increase the value (360 seconds is likely sufficient).

References

Configuring a distributed EOP Installation using an Azure MySQL database instance

 

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request