000025751 - Errors in catalina.out when starting KMS running on Apache Tomcat

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000025751
Applies ToRSA Key Manager 2.0 (RKM 2.0)
Microsoft Windows 2003 Server SP1
Apache Tomcat 5.5.20
Sun Java Runtime Environment (JRE) 1.5.0
IssueApache Tomcat log contains the following errors:

com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector run
WARNING:
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1f0aecc -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
Nov 29, 2006 10:04:33 AM com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector run
WARNING:
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1f0aecc -- APPARENT DEADLOCK!!! Complete Status:
        Managed Threads: 3
        Active Threads: 3
        Active Tasks:
               
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1cebc9f (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
               
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1c1ac46 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
               
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1557c0 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
        Pending Tasks:
               
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1342a67
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1cbda0a
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@57ea52
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1d8d39f
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2d95b3
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@bf5555
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@17b4703
Pool thread stack traces:
        Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]
                java.lang.Thread.sleep(Native Method)
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1745)
                com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
        Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]
                java.lang.Thread.sleep(Native Method)
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1745)
                com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
        Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]
                java.lang.Thread.sleep(Native Method)
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1745)
                com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
WARN com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0 com.mchange.v2.resourcepool.BasicResourcePool - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1735f84 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
            at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
            at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
...
ResolutionModify C:\Program Files\Apache Software Foundation\Tomcat 5.5\conf\Catalina\localhost\KMS.xml

Add the following line to the "jdbc/keystore" AND "jdbc/datastore" configuration blocks
    automaticTestTable="KMSTestTable_DoNotDelete"

Restart Apache Tomcat

As an example, this would be an RKM Server 2.7 KMS.xml:

<?xml version="1.0" encoding="UTF-8"?>
<Context path="/KMS" docBase="KMS" debug="5" reloadable="true" crossContext="true">
<Resource name="jdbc/rkm" auth="Container"
    type="oracle.jdbc.pool.OracleDataSource"
    driverClassName="oracle.jdbc.OracleDriver"
    factory="oracle.jdbc.pool.OracleDataSourceFactory"
    automaticTestTable="KMSTestTable_DoNotDelete"
    connectionCachingEnabled="true"
    connectionCacheProperties="{InactivityTimeout=200,AbandonedConnectionTimeout=200,PropertyCheckInterval=30}"
    connectionCacheName="KmsConPool"
    url="jdbc:oracle:thin:@rkm_db_host:1521:SMRKM"
    user="local"
    password="-THIS-SHOULD-BE-IGNORED-"
/>
</Context>
NotesautomaticTestTable is a C3P0 configuration parameter. If not provided in KMS.xml, it's default value is 'null'.

If provided, c3p0 will create an empty table of the specified name, and use queries against that table to test the Connection. If automaticTestTable is provided, c3p0 will generate its own test query, therefore any preferredTestQuery set will be ignored. You should not work with the named table after c3p0 creates it; it should be strictly for c3p0's use in testing your Connection.
Legacy Article IDa32814

Attachments

    Outcomes