search cancel

[Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.

book

Article ID: 242256

calendar_today

Updated On:

Products

CA Application Performance Management (APM / Wily / Introscope)

Issue/Introduction

The IntroscopeEnterpriseManager.log is flooded with entries 

[Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.

I have configured the following properties as follows.

[[email protected] config]# cat /opt/CAAPM/EM/config/tess-db-cfg.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
      <property name="em.dbtype">Postgres</property>
      <property name="hibernate.connection.username">admin</property>
      <property name="hibernate.connection.password">wily</property>
      <property name="plainTextPasswords">true</property>
      <property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>
      <property name="hibernate.connection.driver_class">org.postgresql.Driver</property>
      <property name="hibernate.connection.url">jdbc:postgresql://127.0.0.1:5432/cemdb</property>
      <property name="hibernate.connection.tcpKeepAlive">true</property>
    </session-factory>
</hibernate-configuration>


[[email protected] config]# grep introscope.enterprisemanager.tess.enabled IntroscopeEnterpriseManager.properties 
introscope.enterprisemanager.tess.enabled=false

[[email protected] config]# grep log4j.logger.Manager.com.timestock.tess.util.DbUtils IntroscopeEnterpriseManager.properties 
log4j.logger.Manager.com.timestock.tess.util.DbUtils=ERROR,logfile

 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [TimerBean] [Manager.ThreadDump DiskPersistance] Checking for Thread dump files to be purged... 
 [WARN] [TimerBean] [Manager.ThreadDump DiskPersistance] Cannot find Thread dump files older than the specified aging limit:7. No Thread dump 
will be deleted
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [ERROR] [pool-18-thread-4] [org.springframework.scheduling.support.TaskUtils$LoggingErrorHandler] Unexpected error occurred in scheduled task
.
java.lang.NullPointerException
        at com.wily.introscope.appmap.em.model.dao.impl.HelperOperationsDaoImpl.pruneOldStatusTables(HelperOperationsDaoImpl.java:660)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
        at com.sun.proxy.$Proxy110.pruneOldStatusTables(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
        at com.sun.proxy.$Proxy111.pruneOldStatusTables(Unknown Source)
        at com.wily.introscope.appmap.em.model.dao.impl.CollectorOperationsDaoImpl.pruneOldData(CollectorOperationsDaoImpl.java:1340)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
        at com.sun.proxy.$Proxy129.pruneOldData(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
        at com.sun.proxy.$Proxy130.pruneOldData(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65)
        at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
 [INFO] [Thread-10] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
--More--

Environment

Release : 10.7.0

Component : Introscope

Resolution

Add the following to the <EM Home>/config/IntroscopeEnterpriseManager.properties file.  This should suppress the INFO and ERROR messages for AppMap attempting to contact the DB.

log4j.logger.Manager.AppMap=FATAL,logfile