#38 CachedSQL" java.lang.OutOfMemoryError

[Anonymous]

ASEmon is not starting for 1 of the Sybase instance and it errors as :

Sybase DB version for collecting data is ASE-16 SP03 PL08 .
And the failed ASE instance version is ASE-15.7 SP64.

Error message from log file:

2021/08/26 10:50:37.321 PLNMUR11_DS_MonSQL - MonSQL BootID = 104
Exception in thread "PLNMUR11_DS_CachedSQL" java.lang.OutOfMemoryError: GC overhead limit exceeded (max heap: 1024 MB)
at java.lang.Integer.valueOf(Integer.java:832)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.setInt(SybPreparedStatement.java:651)
at asemon_logger.CollectorCachedSQL.initialize(CollectorCachedSQL.java:230)
at asemon_logger.Collector.run(Collector.java:369)
Exception in thread "PLNMUR11_DS_CachedPrc" java.lang.OutOfMemoryError: GC overhead limit exceeded (max heap: 1024 MB)
at java.util.Arrays.copyOfRange(Arrays.java:3664)
at java.lang.String.<init>(String.java:207)
at java.lang.String.substring(String.java:2015)
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "PLNMUR11_DS_CachedPrc"</init>

Exception in thread "PLNMUR11_DS_BlockedP" java.lang.OutOfMemoryError: GC overhead limit exceeded (max heap: 1024 MB)
at org.apache.xerces.util.XMLAttributesImpl$Attribute.<init>(Unknown Source)
at org.apache.xerces.util.XMLAttributesImpl.<init>(Unknown Source)
at org.apache.xerces.util.XMLAttributesImpl.<init>(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.<init>(Unknown Source)
at org.apache.xerces.impl.XMLDocumentScannerImpl.<init>(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.<init>(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.<init>(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.<init>(Unknown Source)
at sun.reflect.GeneratedConstructorAccessor10.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at java.lang.Class.newInstance(Class.java:456)
at org.apache.xerces.util.ObjectFactory.newInstance(Unknown Source)
at org.apache.xerces.util.ObjectFactory.findJarServiceProvider(Unknown Source)
at org.apache.xerces.util.ObjectFactory.createObject(Unknown Source)
at org.apache.xerces.util.ObjectFactory.createObject(Unknown Source)</init></init></init></init></init></init></init></init>

[Jean-Paul Martin]

Hi, it seems you already increased the java heap memory to 1024 (default is 512)
Try to increase it again (example : switch "-Xmx2048m" on java start command in the asemon_logger script)

If you still get problem, then, comment the "CachedSQL" descriptor in your config file
Regards
Jp