Foglight repository connection timing out when using Always On Listener
说明
The following error is observed when using SQL server Always on Listener:
com.quest.nitro.service.monitor.AbstractMonitor - An error has occurred during processing of monitor com.quest.nitro.monitor:type=DatabaseLatency java.lang.RuntimeException: java.sql.SQLException: Unable to acquire a new connection from the pool ... ... Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host <hostname>, named instance <instance_name> failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.
解决办法
Please verify the following: - Confirm there is no firewall blocking - Confirm that port no.1433 (default) is open - Verify memory reservation and utilization. Increase memory reservation if usage is high. Resolution: 1. In $FMS_HOME/config/server.config: --> Set the 'server.database.port' parameter to the actual port no of the listener instead of the instance name.
