C3P0PooledConnectionPoolManager - deadlock
We are getting a weird issue since we have migrated some clients into vertica
Looks like there is an issue with the jdbc driver not closing the connection corretly.
Any idea what could have been causing this? is this a known issue in the 7.1 jdbc?
Name: C3P0PooledConnectionPoolManager[identityToken->2tigb8991wajq981fqksme|1721d4a9, dataSourceName->dw-3]-HelperThread-#2
State: BLOCKED on com.vertica.jdbc.jdbc4.S4DatabaseMetaData@5fc6b839 owned by: C3P0PooledConnectionPoolManager[identityToken->2tigb8991wajq981fqksme|1721d4a9, dataSourceName->dw-3]-HelperThread-#0
Total blocked: 316 Total waited: 1,607
Stack trace:
com.vertica.jdbc.common.SDatabaseMetaData.closeMetaData(Unknown Source)
com.vertica.jdbc.common.SConnection.closeChildObjects(Unknown Source)
- locked java.lang.Object@6046e605
com.vertica.jdbc.common.SConnection.close(Unknown Source)
- locked com.vertica.jdbc.VerticaJdbc4ConnectionImpl@7c8c6cbd
com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:629)
com.mchange.v2.c3p0.impl.NewPooledConnection.closeMaybeCheckedOut(NewPooledConnection.java:259)
- locked com.mchange.v2.c3p0.impl.NewPooledConnection@b544679
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:619)
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:1024)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
0