近期遇到一个事务没有关闭一直在运行
通过 mysql的processlist列表定位到所在机器 ,存在5个连接
通过netstat 定位到JVM PID
运行时调试 connection id 没有在druid中找到
打印statData信息,显示ActiveCount为1, 获取ActiveConnections数量又等于0
druidDataSource.getActiveConnections().size() ==>0
ActiveCount 1
PoolingCount 4 能够匹配上
PhysicalConnectCount 7
PhysicalCloseCount2
private volatile DruidConnectionHolder[] connections; ===>数量为4
Identity 1049952732
NameDataSource-1049952732
DbTypemysql
DriverClassNamecom.mysql.jdbc.Driver
URLjdbc:mysql://doman.mysql.rds.aliyuncs.com/dbname?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&allowMultiQueries=true
UserNameusrrname
FilterClassNames["com.alibaba.druid.filter.stat.StatFilter"]
WaitThreadCount0
NotEmptyWaitCount2
NotEmptyWaitMillis77
PoolingCount4
PoolingPeak5
PoolingPeakTime1509404090225
ActiveCount1
ActivePeak5
ActivePeakTime1509441465641
InitialSize5
MinIdle5
MaxActive38
QueryTimeout0
TransactionQueryTimeout0
LoginTimeout0
ValidConnectionCheckerClassNamecom.alibaba.druid.pool.vendor.MySqlValidConnectionChecker
ExceptionSorterClassNamecom.alibaba.druid.pool.vendor.MySqlExceptionSorter
TestOnBorrowtrue
TestOnReturnfalse
TestWhileIdletrue
DefaultAutoCommittrue
DefaultReadOnlynull
DefaultTransactionIsolationnull
LogicConnectCount4401
LogicCloseCount4400
LogicConnectErrorCount0
PhysicalConnectCount7
PhysicalCloseCount2
PhysicalConnectErrorCount0
ExecuteCount3475
ErrorCount0
CommitCount1381
RollbackCount0
PSCacheAccessCount3041
PSCacheHitCount2612
PSCacheMissCount429
StartTransactionCount29
TransactionHistogram[0,0,0,2,0,0,0]
ConnectionHoldTimeHistogram[0,2988,23,1377,4,8,0,0]
RemoveAbandonedfalse
ClobOpenCount0
BlobOpenCount0
KeepAliveCheckCount0
KeepAlivefalse
FailFastfalse
MaxWait10000
MaxWaitThreadCount-1
PoolPreparedStatementstrue
MaxPoolPreparedStatementPerConnectionSize20
MinEvictableIdleTimeMillis300000
MaxEvictableIdleTimeMillis25200000
LogDifferentThreadtrue
RecycleErrorCount0
PreparedStatementOpenCount429
PreparedStatementClosedCount349
UseUnfairLocktrue
InitGlobalVariantsfalse
InitVariantsfalse