Using Ignition 8.1.26, using SQL Server driver mssql-jbdc-9.4.0.jre8.jar.
The IT team at the customer we setup Ignition for has a SQL Server availability group. They setup a listener IP address so that Ignition only has to connect to a single IP/host but in reality they have two nodes they can failover between.
This morning the Sys admin/dba (or someone) manually triggered a failover and for some reason some of the db connections do not restore. We get an error like cannot get a connection, pool error timeout waiting for idle object. At first we contacted the dba to try to fix the issue but he said he didn't see anything saying that the login we used to connect ( an AD account with integratedSecurity=true) was having any issues connection, at least from what he could see. I suggested we restart the gateway. That did resolve the issue. This issue also occurred last week as well and our solution was the same.
The problem is that they failover somewhat regularly during patching and we don't want Ignition to have to restart every time they do that.
Has anyone run into this and has any figured out how to resolve it? I suspect maybe I need a different SQL Server driver jar file but I do not know. Hopefully someone has run into this problem.