Guest

Preview Tool

Cisco Bug: CSCul44318 - TMSPE will accept commas for port delimiter for sql connection.

Last Modified

Jul 18, 2014

Products (1)

  • Cisco TelePresence Management Server

Known Affected Releases

14.3.1

Description (partial)

Symptom:
TMSPE logs will throw the error:

Caused by: java.net.UnknownHostException:  <sql server removed>,3180  
               at java.net.AbstractPlainSocketImpl.connect(Unknown Source) ~[na:1.7.0_17]
               at java.net.PlainSocketImpl.connect(Unknown Source) ~[na:1.7.0_17]
               at java.net.SocksSocketImpl.connect(Unknown Source) ~[na:1.7.0_17]
               at java.net.Socket.connect(Unknown Source) ~[na:1.7.0_17]
               at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source) ~[na:na]
               at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.7.0_17]
               at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.7.0_17]
               at net.sourceforge.jtds.jdbc .SharedSocket.createSocketForJDBC3 (SharedSocket.java:297) ~[jtds-1.2.7.jar:1.2.7]
               at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:247) ~[jtds-1.2.7.jar:1.2.7]
               at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:322) ~[jtds-1.2.7.jar:1.2.7]
               ... 10 common frames omitted
2013-11-15 16:55:59,002 [dg] [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] WARN  U: c.m.v.resourcepool.BasicResourcePool - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@488480d5 -- 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 (5). Last acquisition attempt exception:
java.sql.SQLException: Unknown server host name '  <sql server removed>,3180' ; ;.
               at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:412) ~[jtds-1.2.7.jar:1.2.7]
               at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50) ~[jtds-1.2.7.jar:1.2.7]
               at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:185) ~[jtds-1.2.7.jar:1.2.7]
               at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134) ~[c3p0-0.9.1.2.jar:0.9.1.2]
               at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182) ~[c3p0-0.9.1.2.jar:0.9.1.2]
               at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171) ~[c3p0-0.9.1.2.jar:0.9.1.2]
               at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) ~[c3p0-0.9.1.2.jar:0.9.1.2]
               at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) ~[c3p0-0.9.1.2.jar:0.9.1.2]
               at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) ~[c3p0-0.9.1.2.jar:0.9.1.2]
               at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) ~[c3p0-0.9.1.2.jar:0.9.1.2]
               at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547) [c3p0-0.9.1.2.jar:0.9.1.2]

Conditions:
A comma is used as the delimiter between the sql server address and the port number.
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.