000035370 - Failing Database Connection, Causing Application Failure in RSA Adaptive Authentication (OnPrem) 7.3

Document created by RSA Customer Support Employee on Aug 10, 2017
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000035370
Applies ToRSA Product Set: Adaptive Authentication (OnPrem)
RSA Product/Service Type: Adaptive Authentication (OnPrem)
RSA Version/Condition: 7.3
O/S Version: Linux
Product Name: AAOP
 
IssueWe're seeing latency with response time and database connection from one of two RSA AA OP servers. This is causing that server to show as down/unavailable and causing issue with connectivity to our internal applications. The issue was reported at 10:03 AM ET. This is the second time in 1 week that we've encounter this issue.
ResolutionTry this in all data sources sin standalone.xml. this should fix the issue.
Change it From:
<blocking-timeout-millis>60000</blocking-timeout-millis>
<idle-timeout-minutes>10</idle-timeout-minutes>

Change it To:
<blocking-timeout-millis>30000</blocking-timeout-millis>
<idle-timeout-minutes>300</idle-timeout-minutes>
* <idle-timeout-minutes> - the number of minutes after which unused connections are closed (default 15 minutes)
* <blocking-timeout-millis> - the length of time to wait for a connection to become available when all the connections are checked out (default 5000 == 5 seconds, from 3.2.4 it is 30000 == 30 seconds)
Notes
For more information, refer to the log output below.
 

22:08:08,212 INFO  [org.jboss.modules] (main) JBoss Modules version 1.3.3.Final-redhat-1
22:08:09,101 INFO  [org.jboss.msc] (main) JBoss MSC version 1.1.5.Final-redhat-1
22:08:09,386 INFO  [org.jboss.as] (MSC service thread 1-6) JBAS015899: JBoss AS 7.4.0.Final-redhat-19 "Janus" starting
22:08:09,417 DEBUG [org.jboss.as.config] (MSC service thread 1-6) Configured system properties:
    [Standalone] = 
    appdynamic.dtd.provider.class = com.singularity.ee.agent.appagent.kernel.boot.JavaAgentBootExtension
    awt.toolkit = sun.awt.X11.XToolkit
    file.encoding = UTF-8
    file.encoding.pkg = sun.io
    file.separator = /
    java.awt.graphicsenv = sun.awt.X11GraphicsEnvironment
    java.awt.headless = true
    java.awt.printerjob = sun.print.PSPrinterJob
    java.class.path = /data/jboss-eap-6.3/jboss-modules.jar:/data/appDynamics/javaagent.jar
    java.class.version = 51.0
    java.endorsed.dirs = /data/jdk1.7.0_55/jre/lib/endorsed
    java.ext.dirs = /data/jdk1.7.0_55/jre/lib/ext:/usr/java/packages/lib/ext
    java.home = /data/jdk1.7.0_55/jre

Attachments

    Outcomes