#28 ASEMON - Causing RepServer is out of connections

[Hardeep]

Hi JPM,
ASEMON is working perfectly with SSL feature but seems like it doesn't use existing connection to capture RepServer stats and always establish a new connection to capture RS stats and becuase of this this RS runs out of connections. However, I didn't notice this bahviour on ASE server.

I am using ASEMON logger verison -2.7.21 and ASEMON reporter is 3.0.

Would you please advise , do i need to change any ASEMON configuraitons to its XML file.

Thanks,
Hardeep

[Jean-Paul Martin]

Hi Hardeep
I am not aware of this problem with SSL on RS.
Any error message in asemon output ?
Any error in RS errorlog ? (which version of RS ?)
Do you know the frequency of new connections creation and why asemon has to reconnect to the RS ?

Recent Asemon_logger's versions use a recent version of jConnect (V16SP03PL07 fo asmeon V3.1.2) Can you try a new asemon version on a test RS ?
May be it could solve your problem
Cheers
Jpm

[Hardeep]

Hi JPM
Please find attached ASEMON .XML and LOG file.

RS Verion is 16.0/EBF 28346 SP03 PL06

Thanks,
Hardeep

[Jean-Paul Martin]

Hi Hardeep
I reviewed your files and don't see any mistake
I configured and tested asemon V3.1.2 (latest version) aginst a RS V16SP03PL06 with ssl. No abnormal reconnections

In the past I fixed a important bug for the RSStat collector. It is fixed in 2.7.24 (last 2.7 version before V3) I don't remember the sides effect of this bug (may leave connection open and unusable)
Try with this version if you don't want to upgrade to V3.1.2

By the way asemon V2.7 was not compiled with java 1.8 but 1.6. I see you are running with 1.8.

You can also try to stat a dedicated asemon_logger with the debug flag (-D on the command line) See if you get more info and see what was the lastest collector used before reopening a connection.

I have no more idea and cannot reproduce
Cheers
Jpm

[Hardeep]

Hi JPM,
I have installed a latest verison of ASEMON_loger and now its complaining about some JAVA IOException. I am sure passwords and truststore for SSL are all good.

Now, I have started ASEMON (2.7.21) process in debug mode and share some more detials in a while

Error on ASEMON V3.1

======================
+ /dba/sybase/asemon/asemon_logger/asemon_logger.sh -D -c /dba/sybase/asemon/config/ASEMGLPRDEDD6.xml
2019/09/26 10:26:46.220 main - DEBUG mode
2019/09/26 10:26:46.249 main - Start Asemon_logger V3.1.2
2019/09/26 10:26:46.249 main - Current directory is : /dba/sybase/asemon/3.1.1
2019/09/26 10:26:46.249 main - Java version : 1.8.0_201
2019/09/26 10:26:46.251 main - Classpath is : /dba/sybase/asemon/asemon_logger/dist/Asemon_logger_V3.jar:/dba/sybase/asemon/asemon_logger/lib/jdom.jar:/dba/sybase/asemon/asemon_logger/lib/xerces.jar:/dba/sybase/asemon/asemon_logger/lib/java-getopt-1.0.9.jar:/dba/sybase/ase/16.0.0.0.28334/jConnect-16_0/classes/jconn4.jar:/dba/sybase/ase/16.0.0.0.28334/jConnect-16_0/classes/jTDS3.jar
2019/09/26 10:26:46.251 main - Config file used : /dba/sybase/asemon/config/ASEMGLPRDEDD6.xml
2019/09/26 10:26:46.448 main - Packet_size asked by asemon_logger for server 'REPMGLPRDEDD6': 4096
2019/09/26 10:26:46.454 main - DEBUG - Get archive conn 0
2019/09/26 10:26:46.454 main - DEBUG - get archnx : asemon_logger.CnxMgr$ArchCnx@e73f9ac Time wait :0ms
2019/09/26 10:26:46.455 main - Try to connect to srv : ASEMGLPRDEDD6
2019/09/26 10:26:46.455 main - DEBUG - Sybdirectory OS=Linux
2019/09/26 10:26:46.456 main - DEBUG - Sybdirectory interfaceFile=/dba/sybase/ase/16.0.0.0.28334/interfaces
2019/09/26 10:26:46.715 main - Srv found in interfaces or SQL.INI file. Host=usyddbp25018 Port=20002
2019/09/26 10:26:46.715 main - Using password from passwords file for 'ASEMGLPRDEDD6.perfmon_dba'
2019/09/26 10:26:46.724 main - SSL is activated
2019/09/26 10:26:46.876 main - ERROR connectSRV (1). Srv=ASEMGLPRDEDD6 : java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0T3 use getCause() to see the error chain
2019/09/26 10:26:46.876 main - ERROR connectSRV (2). Srv=ASEMGLPRDEDD6 : java.sql.SQLException: JZ0T3: Read operation timed out.
2019/09/26 10:26:46.876 main - ERROR connectSRV (2). Srv=ASEMGLPRDEDD6 : java.sql.SQLException: JZ0TO: Read operation timed out.

=====================
Cheers,
Hardeep

[Jean-Paul Martin]

Hi Hardeep,
try using a recent jConnect. I use jConnect (TM) for JDBC(TM)/16.0 SP03 PL07 (Build 27438)/P/EBF28836/JDK 1.6.0/jdbcdev/OPT/Thu Apr 25 00:34:46 PDT 2019

Note that for new ASE V16SP03 you must generate keys with keytool rather than with openssl

But It worked before in your case, so I don't understand also

Cheers
Jpm