大家帮我看看这个异常是数据库哪里出问题了，谢谢

Question

[2014-10-09 10:21:23] WARN  com.mchange.v2.async.ThreadPoolAsynchronousRunner - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@737f3202 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
[2014-10-09 10:21:24] WARN  com.mchange.v2.async.ThreadPoolAsynchronousRunner - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@737f3202 -- APPARENT DEADLOCK!!! Complete Status: 
    Managed Threads: 3
    Active Threads: 3
    Active Tasks: 
        com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@8efbbf9 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
        com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@331ddd04 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
        com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@6d994bd3 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
    Pending Tasks: 
        com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@6b4141db
Pool thread stack traces:
    Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]
        java.net.PlainSocketImpl.socketConnect(Native Method)
        java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)
        java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
        java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)
        java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
        java.net.Socket.connect(Socket.java:529)
        oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:141)
        oracle.net.nt.ConnOption.connect(ConnOption.java:123)
        oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:337)
        oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:422)
        oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:672)
        oracle.net.ns.NSProtocol.connect(NSProtocol.java:237)
        oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
        oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
        oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
        oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
        oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
        com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
        com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
        com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
        com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
        com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
        com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
        com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
        com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
    Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]
        java.net.SocketInputStream.socketRead0(Native Method)
        java.net.SocketInputStream.read(SocketInputStream.java:129)
        oracle.net.ns.Packet.receive(Packet.java:282)
        oracle.net.ns.DataPacket.receive(DataPacket.java:103)
        oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230)
        oracle.net.ns.NetInputStream.read(NetInputStream.java:175)
        oracle.net.ns.NetInputStream.read(NetInputStream.java:100)
        oracle.net.ns.NetInputStream.read(NetInputStream.java:85)
        oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)
        oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)
        oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)
        oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)
        oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)
        oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
        oracle.jdbc.driver.T4C7Ocommoncall.doOLOGOFF(T4C7Ocommoncall.java:61)
        oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:491)
        oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:3754)
        com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:549)
        com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:234)
        com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:470)
        com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:964)
        com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
    Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]
        java.net.SocketInputStream.socketRead0(Native Method)
        java.net.SocketInputStream.read(SocketInputStream.java:129)
        oracle.net.ns.Packet.receive(Packet.java:282)
        oracle.net.ns.DataPacket.receive(DataPacket.java:103)
        oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230)
        oracle.net.ns.NetInputStream.read(NetInputStream.java:175)
        oracle.net.ns.NetInputStream.read(NetInputStream.java:100)
        oracle.net.ns.NetInputStream.read(NetInputStream.java:85)
        oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)
        oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)
        oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)
        oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)
        oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)
        oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
        oracle.jdbc.driver.T4C7Ocommoncall.doOLOGOFF(T4C7Ocommoncall.java:61)
        oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:491)
        oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:3754)
        com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:549)
        com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:234)
        com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:470)
        com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:964)
        com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)


[2014-10-09 10:21:27] INFO  com.mchange.v2.c3p0.impl.NewPooledConnection - [c3p0] Exceptions occurred while trying to close a PooledConnection's resources normally.
[2014-10-09 10:21:27] INFO  com.mchange.v2.c3p0.impl.NewPooledConnection - [c3p0] NewPooledConnection close Exception.
java.sql.SQLRecoverableException: IO 错误: Socket read timed out
    at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:504)
    at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:3754)
    at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:549)
    at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:234)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:470)
    at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:964)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Caused by: oracle.net.ns.NetException: Socket read timed out
    at oracle.net.ns.Packet.receive(Packet.java:320)
    at oracle.net.ns.DataPacket.receive(DataPacket.java:103)
    at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)
    at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)
    at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)
    at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)
    at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    at oracle.jdbc.driver.T4C7Ocommoncall.doOLOGOFF(T4C7Ocommoncall.java:61)
    at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:491)
    ... 6 more
[2014-10-09 10:21:27] WARN  com.mchange.v2.resourcepool.BasicResourcePool - Failed to destroy resource: com.mchange.v2.c3p0.impl.NewPooledConnection@4cd1365
java.sql.SQLException: Some resources failed to close properly while closing com.mchange.v2.c3p0.impl.NewPooledConnection@4cd1365
    at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:571)
    at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:234)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:470)
    at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:964)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
[2014-10-09 10:21:27] INFO  com.mchange.v2.c3p0.impl.NewPooledConnection - [c3p0] Exceptions occurred while trying to close a PooledConnection's resources normally.
[2014-10-09 10:21:27] INFO  com.mchange.v2.c3p0.impl.NewPooledConnection - [c3p0] NewPooledConnection close Exception.
java.sql.SQLRecoverableException: IO 错误: Socket read timed out
    at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:504)
    at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:3754)
    at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:549)
    at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:234)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:470)
    at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:964)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Caused by: oracle.net.ns.NetException: Socket read timed out
    at oracle.net.ns.Packet.receive(Packet.java:320)
    at oracle.net.ns.DataPacket.receive(DataPacket.java:103)
    at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)
    at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)
    at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)
    at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)
    at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    at oracle.jdbc.driver.T4C7Ocommoncall.doOLOGOFF(T4C7Ocommoncall.java:61)
    at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:491)
    ... 6 more
[2014-10-09 10:21:27] WARN  com.mchange.v2.resourcepool.BasicResourcePool - Failed to destroy resource: com.mchange.v2.c3p0.impl.NewPooledConnection@538787fd
java.sql.SQLException: Some resources failed to close properly while closing com.mchange.v2.c3p0.impl.NewPooledConnection@538787fd
    at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:571)
    at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:234)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:470)
    at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:964)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

Answer 1

长时间不进行操作的话就会出现这种异常，貌似跟c3p0有关系？