Distributed EOP Install or Upgrade Issues with Azure MySQL Database

  • Updated


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.


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


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


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