#15 Replication server information is not collected, RS is running out of connections.
Asemon_logger V3.0.4b, not collecting Replication server information, and kept on opening connections to replcations, ultmately Replication server is exceeding # of connections .
Replication server version : Replication Server/15.7.1/EBF 25982 SP304 rs1571sp304/Linux AMD64/Linux 2.6.32.59-0.19-default x86_64/2136/OPT64/Fri May 20 17:38:56 2016
RSSD : ERSSD.
Config file : snippet of RS details
<MonitoredSrv>
<SRV>
<name> TSY666TEST_RS </name>
<user> dbmonitor </user>
<useKerberos> NO </useKerberos>
<charset> </charset>
<packet_size> </packet_size>
<srvDescriptor> RS15 </srvDescriptor>
<purgearchive daysToKeep="90" deleteSleep="100"/>
</SRV>
</MonitoredSrv>
Log information :
2017/03/27 10:40:17.167 TSY666TEST_RS_RSWhoSQM - connectMonitoredRS - connected to : TSY666TEST_RS Version : 1571
2017/03/27 10:40:17.183 TSY666TEST_RS_RSWhoSQM - Time difference (ms) between RS and asemon_logger (positive when RS is in advance) : -2
2017/03/27 10:40:17.333 TSY666TEST_RS_RSWhoSQM - Col : 'Loss Status' does not exists in archive table. Will be ignored.
2017/03/27 10:40:17.365 TSY666TEST_RS_RSMemDet - connectMonitoredRS - connected to : TSY666TEST_RS Version : 1571
2017/03/27 10:40:17.378 TSY666TEST_RS_RSMemDet - Time difference (ms) between RS and asemon_logger (positive when RS is in advance) : -1
2017/03/27 10:40:17.452 TSY666TEST_RS_RSMem - connectMonitoredRS - connected to : TSY666TEST_RS Version : 1571
2017/03/27 10:40:18.046 TSY666TEST_RS_RSMem - Time difference (ms) between RS and asemon_logger (positive when RS is in advance) : -1
2017/03/27 10:40:18.126 TSY666TEST_RS_RSStats - connectMonitoredRS - connected to : TSY666TEST_RS Version : 1571
2017/03/27 10:40:18.139 TSY666TEST_RS_RSStats - Time difference (ms) between RS and asemon_logger (positive when RS is in advance) : -1
2017/03/27 10:40:18.270 TSY666TEST_RS_DISKSPCE - connectMonitoredRS - connected to : TSY666TEST_RS Version : 1571
2017/03/27 10:40:18.285 TSY666TEST_RS_DISKSPCE - Time difference (ms) between RS and asemon_logger (positive when RS is in advance) : -1
2017/03/27 10:41:17.369 TSY666TEST_RS_RSWhoSQM - ERROR connectSRV (1). Srv=TSY666TEST_RS State= JZ00L Err= 0 Msg=JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
2017/03/27 10:41:17.370 TSY666TEST_RS_RSWhoSQM - ERROR connectSRV (2). Srv=TSY666TEST_RS State= 010UP Err= 0 Msg=010UP: Unrecognized connection property ENABLE_BULK_LOAD ignored.
2017/03/27 10:41:17.370 TSY666TEST_RS_RSWhoSQM - Connection to TSY666TEST_RS is closed. Trying to reconnect every 10 s ...
2017/03/27 10:51:12.509 Purge TSY666TEST_RS - Start thread.
2017/03/27 10:51:12.510 Purge TSY666TEST_RS - Try to connect to srv : DSYRFPIMA02
2017/03/27 10:51:12.511 Purge TSY666TEST_RS - Srv found in interfaces or SQL.INI file. Host=dxsrfpimadb003 Port=5000
2017/03/27 10:51:12.511 Purge TSY666TEST_RS - Using password from passwords file for 'DSYRFPIMA02.sa'
2017/03/27 10:51:12.523 Purge TSY666TEST_RS - Connected to archive server : DSYRFPIMA02 Database : ASEMONDB
2017/03/27 11:18:52.403 TSY666TEST_RS_RSWhoSQM - connectMonitoredRS - connected to : TSY666TEST_RS Version : 1571
2017/03/27 11:18:52.416 TSY666TEST_RS_RSWhoSQM - Time difference (ms) between RS and asemon_logger (positive when RS is in advance) : -1
2017/03/27 11:18:52.563 TSY666TEST_RS_RSWhoSQM - Col : 'Loss Status' does not exists in archive table. Will be ignored.
2017/03/27 11:18:52.609 TSY666TEST_RS_DISKSPCE - connectMonitoredRS - connected to : TSY666TEST_RS Version : 1571
2017/03/27 11:18:52.622 TSY666TEST_RS_DISKSPCE - Time difference (ms) between RS and asemon_logger (positive when RS is in advance) : -1
2017/03/27 11:18:52.722 TSY666TEST_RS_RSStats - connectMonitoredRS - connected to : TSY666TEST_RS Version : 1571
2017/03/27 11:18:52.735 TSY666TEST_RS_RSStats - Time difference (ms) between RS and asemon_logger (positive when RS is in advance) : -1
2017/03/27 11:18:52.836 TSY666TEST_RS_RSMem - connectMonitoredRS - connected to : TSY666TEST_RS Version : 1571
2017/03/27 11:18:52.849 TSY666TEST_RS_RSMem - Time difference (ms) between RS and asemon_logger (positive when RS is in advance) : -1
2017/03/27 11:18:52.912 TSY666TEST_RS_RSMemDet - connectMonitoredRS - connected to : TSY666TEST_RS Version : 1571
2017/03/27 11:18:52.927 TSY666TEST_RS_RSMemDet - Time difference (ms) between RS and asemon_logger (positive when RS is in advance) : -1
Discussion
Anonymous
View and moderate all "support-requests Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Support Requests"
Ok, I found the problem : it's a regression in V3.0.4a using new jConnect 16. This new jConnect V16 changed the "isClosed" method and the "is_closed_test='select 1' " no longer work for RS. Revert "is_closed_test" param to"'internal'" in new V3.0.4c version.
This explain the blocking connections and the increasing number of connections on the monitored RS
Jpm