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