[midPoint] Midpoint Task Manager Performance

IDM proyectos_idm at corenetworks.es
Thu Oct 26 17:18:59 CEST 2017 

Hello.

We have midpoint in 2 Tomcat instances over Oracle DB.      We are getting
errors with the DB.     The DB is closing he sockets without notifing
Midpoint so at the next operation,  Midpoint fails using this socket due to
this.

There is some configuration, or parameter in the config.xml  we can use to
solve it ?



*1.The error is :*

2017-10-18 14:34:26,108 [] [midPointScheduler_QuartzSchedulerThread] WARN
(com.mchange.v2.c3p0.impl.NewPooledConnection): [c3p0] A PooledConnection
that has already signalled a Connection error is still in use!
2017-10-18 14:34:26,109 [] [midPointScheduler_QuartzSchedulerThread] WARN
(com.mchange.v2.c3p0.impl.NewPooledConnection): [c3p0] Another error has
occurred [ java.sql.SQLRecoverableException: Closed Connection ] which will
not be reported to listeners!
java.sql.SQLRecoverableException: Closed Connection
        at oracle.jdbc.driver.PhysicalConnection.getAutoCommit(PhysicalConnection.java:4337)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:4507)
~[na:12.1.0.1.0]
        at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:860)
~[c3p0-0.9.2.1.jar:0.9.2.1]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_101]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_101]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_101]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_101]
        at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInv
ocationHandler.invoke(AttributeRestoringConnectionInvocationHandler.java:73)
[quartz-2.2.3.jar:na]
        at com.sun.proxy.$Proxy106.rollback(Unknown Source) [na:na]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.rollbackConnection(JobStoreSupport.java:3666)
[quartz-2.2.3.jar:na]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonMan
agedTXLock(JobStoreSupport.java:3825) [quartz-2.2.3.jar:na]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrig
gers(JobStoreSupport.java:2756) [quartz-2.2.3.jar:na]
        at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:272)
[quartz-2.2.3.jar:na]
2017-10-18 14:34:26,109 [] [midPointScheduler_QuartzSchedulerThread] ERROR
(org.quartz.impl.jdbcjobstore.JobStoreTX): Couldn't rollback jdbc
connection. Closed Connection
java.sql.SQLRecoverableException: Closed Connection
        at oracle.jdbc.driver.PhysicalConnection.getAutoCommit(PhysicalConnection.java:4337)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:4507)
~[na:12.1.0.1.0]
        at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:860)
~[c3p0-0.9.2.1.jar:0.9.2.1]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_101]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_101]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_101]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_101]
        at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInv
ocationHandler.invoke(AttributeRestoringConnectionInvocationHandler.java:73)
~[quartz-2.2.3.jar:na]
        at com.sun.proxy.$Proxy106.rollback(Unknown Source) ~[na:na]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.rollbackConnection(JobStoreSupport.java:3666)
[quartz-2.2.3.jar:na]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonMan
agedTXLock(JobStoreSupport.java:3825) [quartz-2.2.3.jar:na]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrig
gers(JobStoreSupport.java:2756) [quartz-2.2.3.jar:na]
        at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:272)
[quartz-2.2.3.jar:na]
2017-10-18 14:34:26,111 [] [midPointScheduler_QuartzSchedulerThread] WARN
(com.mchange.v2.c3p0.impl.NewPooledConnection): [c3p0] A PooledConnection
that has already signalled a Connection error is still in use!
2017-10-18 14:34:26,111 [] [midPointScheduler_QuartzSchedulerThread] WARN
(com.mchange.v2.c3p0.impl.NewPooledConnection): [c3p0] Another error has
occurred [ java.sql.SQLRecoverableException: Closed Connection ] which will
not be reported to listeners!
java.sql.SQLRecoverableException: Closed Connection
        at oracle.jdbc.driver.PhysicalConnection.setAutoCommit(PhysicalConnection.java:4315)
~[na:12.1.0.1.0]
        at com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyConnection.java:912)
~[c3p0-0.9.2.1.jar:0.9.2.1]
        at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInv
ocationHandler.restoreOriginalAtributes(AttributeRestoringCo
nnectionInvocationHandler.java:141) [quartz-2.2.3.jar:na]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanupConnection(JobStoreSupport.java:3616)
[quartz-2.2.3.jar:na]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonMan
agedTXLock(JobStoreSupport.java:3835) [quartz-2.2.3.jar:na]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrig
gers(JobStoreSupport.java:2756) [quartz-2.2.3.jar:na]
        at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:272)
[quartz-2.2.3.jar:na]
2017-10-18 14:34:26,111 [] [midPointScheduler_QuartzSchedulerThread] WARN
(org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler):
Failed restore connection's original auto commit setting.
java.sql.SQLRecoverableException: Closed Connection
        at oracle.jdbc.driver.PhysicalConnection.setAutoCommit(PhysicalConnection.java:4315)
~[na:12.1.0.1.0]
        at com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyConnection.java:912)
~[c3p0-0.9.2.1.jar:0.9.2.1]
        at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInv
ocationHandler.restoreOriginalAtributes(AttributeRestoringCo
nnectionInvocationHandler.java:141) ~[quartz-2.2.3.jar:na]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanupConnection(JobStoreSupport.java:3616)
[quartz-2.2.3.jar:na]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonMan
agedTXLock(JobStoreSupport.java:3835) [quartz-2.2.3.jar:na]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrig
gers(JobStoreSupport.java:2756) [quartz-2.2.3.jar:na]
        at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:272)
[quartz-2.2.3.jar:na]
2017-10-18 14:34:26,115 [] [C3P0PooledConnectionPoolManag
er[identityToken->1bqrhnx9rd697zdr1tks2|7417a2b7]-HelperThread-#2] WARN
(com.mchange.v1.db.sql.StatementUtils): Statement close FAILED.
java.sql.SQLRecoverableException: Closed Connection
        at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:6295)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1364)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1343)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:100)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.close(Orac
lePreparedStatementWrapper.java:82) ~[na:12.1.0.1.0]
        at com.mchange.v1.db.sql.StatementUtils.attemptClose(StatementUtils.java:53)
~[mchange-commons-java-0.2.3.4.jar:na]
        at com.mchange.v2.c3p0.stmt.GooGooStatementCache$StatementDestr
uctionManager.synchronousDestroyStatement(GooGooStatementCache.java:947)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.closeAll(GooGooStatementCache.java:387)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.closeAllCachedS
tatements(NewPooledConnection.java:768) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:609)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.closeMaybeCheck
edOut(NewPooledConnection.java:259) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledCon
nectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:619)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResour
ceTask.run(BasicResourcePool.java:1024) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread
.run(ThreadPoolAsynchronousRunner.java:648) [mchange-commons-java-0.2.3.4.
jar:na]
2017-10-18 14:34:26,116 [] [C3P0PooledConnectionPoolManag
er[identityToken->1bqrhnx9rd697zdr1tks2|7417a2b7]-HelperThread-#2] WARN
(com.mchange.v1.db.sql.StatementUtils): Statement close FAILED.
java.sql.SQLRecoverableException: Closed Connection
        at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:6295)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1364)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1343)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:100)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.close(Orac
lePreparedStatementWrapper.java:82) ~[na:12.1.0.1.0]
        at com.mchange.v1.db.sql.StatementUtils.attemptClose(StatementUtils.java:53)
~[mchange-commons-java-0.2.3.4.jar:na]
        at com.mchange.v2.c3p0.stmt.GooGooStatementCache$StatementDestr
uctionManager.synchronousDestroyStatement(GooGooStatementCache.java:947)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.closeAll(GooGooStatementCache.java:387)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.closeAllCachedS
tatements(NewPooledConnection.java:768) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:609)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.closeMaybeCheck
edOut(NewPooledConnection.java:259) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledCon
nectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:619)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResour
ceTask.run(BasicResourcePool.java:1024) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread
.run(ThreadPoolAsynchronousRunner.java:648) [mchange-commons-java-0.2.3.4.
jar:na]
2017-10-18 14:34:26,116 [] [C3P0PooledConnectionPoolManag
er[identityToken->1bqrhnx9rd697zdr1tks2|7417a2b7]-HelperThread-#2] WARN
(com.mchange.v1.db.sql.StatementUtils): Statement close FAILED.
java.sql.SQLRecoverableException: Closed Connection
        at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:6295)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1364)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1343)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:100)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.close(Orac
lePreparedStatementWrapper.java:82) ~[na:12.1.0.1.0]
        at com.mchange.v1.db.sql.StatementUtils.attemptClose(StatementUtils.java:53)
~[mchange-commons-java-0.2.3.4.jar:na]
        at com.mchange.v2.c3p0.stmt.GooGooStatementCache$StatementDestr
uctionManager.synchronousDestroyStatement(GooGooStatementCache.java:947)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.closeAll(GooGooStatementCache.java:387)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.closeAllCachedS
tatements(NewPooledConnection.java:768) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:609)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.closeMaybeCheck
edOut(NewPooledConnection.java:259) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledCon
nectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:619)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResour
ceTask.run(BasicResourcePool.java:1024) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread
.run(ThreadPoolAsynchronousRunner.java:648) [mchange-commons-java-0.2.3.4.
jar:na]
2017-10-18 14:34:26,116 [] [midPointScheduler_QuartzSchedulerThread] ERROR
(org.quartz.core.ErrorLogger): An error occurred while scanning for the
next triggers to fire.
org.quartz.JobPersistenceException: Couldn't acquire next trigger: IO
Error: Connection timed out
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2864)
~[quartz-2.2.3.jar:na]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2759)
~[quartz-2.2.3.jar:na]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2757)
~[quartz-2.2.3.jar:na]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonMan
agedTXLock(JobStoreSupport.java:3803) ~[quartz-2.2.3.jar:na]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrig
gers(JobStoreSupport.java:2756) ~[quartz-2.2.3.jar:na]
        at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:272)
~[quartz-2.2.3.jar:na]
Caused by: java.sql.SQLRecoverableException: IO Error: Connection timed out
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:967)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:929)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(O
raclePreparedStatement.java:3820) ~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.
executeQuery(OraclePreparedStatementWrapper.java:1502) ~[na:12.1.0.1.0]
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQu
ery(NewProxyPreparedStatement.java:116) ~[c3p0-0.9.2.1.jar:0.9.2.1]
        at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTriggerTo
Acquire(StdJDBCDelegate.java:2613) ~[quartz-2.2.3.jar:na]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2798)
~[quartz-2.2.3.jar:na]
        ... 5 common frames omitted
Caused by: java.net.SocketException: Connection timed out
        at java.net.SocketInputStream.socketRead0(Native Method)
~[na:1.8.0_101]
        at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
~[na:1.8.0_101]
        at java.net.SocketInputStream.read(SocketInputStream.java:170)
~[na:1.8.0_101]
        at java.net.SocketInputStream.read(SocketInputStream.java:141)
~[na:1.8.0_101]
        at oracle.net.ns.Packet.receive(Packet.java:311) ~[na:12.1.0.1.0]
        at oracle.net.ns.DataPacket.receive(DataPacket.java:105)
~[na:12.1.0.1.0]
        at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:305)
~[na:12.1.0.1.0]
        at oracle.net.ns.NetInputStream.read(NetInputStream.java:249)
~[na:12.1.0.1.0]
        at oracle.net.ns.NetInputStream.read(NetInputStream.java:171)
~[na:12.1.0.1.0]
        at oracle.net.ns.NetInputStream.read(NetInputStream.java:89)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacke
t(T4CSocketInputStreamWrapper.java:123) ~[na:12.1.0.1.0]
        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:426)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:390)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
~[na:12.1.0.1.0]
        ... 13 common frames omitted
2017-10-18 14:34:26,117 [] [C3P0PooledConnectionPoolManag
er[identityToken->1bqrhnx9rd697zdr1tks2|7417a2b7]-HelperThread-#2] WARN
(com.mchange.v1.db.sql.StatementUtils): Statement close FAILED.
java.sql.SQLRecoverableException: Closed Connection
        at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:6295)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1364)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1343)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:100)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.close(Orac
lePreparedStatementWrapper.java:82) ~[na:12.1.0.1.0]
        at com.mchange.v1.db.sql.StatementUtils.attemptClose(StatementUtils.java:53)
~[mchange-commons-java-0.2.3.4.jar:na]
        at com.mchange.v2.c3p0.stmt.GooGooStatementCache$StatementDestr
uctionManager.synchronousDestroyStatement(GooGooStatementCache.java:947)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.closeAll(GooGooStatementCache.java:387)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.closeAllCachedS
tatements(NewPooledConnection.java:768) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:609)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.closeMaybeCheck
edOut(NewPooledConnection.java:259) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledCon
nectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:619)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResour
ceTask.run(BasicResourcePool.java:1024) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread
.run(ThreadPoolAsynchronousRunner.java:648) [mchange-commons-java-0.2.3.4.
jar:na]
2017-10-18 14:34:26,117 [] [C3P0PooledConnectionPoolManag
er[identityToken->1bqrhnx9rd697zdr1tks2|7417a2b7]-HelperThread-#2] WARN
(com.mchange.v1.db.sql.StatementUtils): Statement close FAILED.
java.sql.SQLRecoverableException: Closed Connection
        at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:6295)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1364)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1343)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:100)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.close(Orac
lePreparedStatementWrapper.java:82) ~[na:12.1.0.1.0]
        at com.mchange.v1.db.sql.StatementUtils.attemptClose(StatementUtils.java:53)
~[mchange-commons-java-0.2.3.4.jar:na]
        at com.mchange.v2.c3p0.stmt.GooGooStatementCache$StatementDestr
uctionManager.synchronousDestroyStatement(GooGooStatementCache.java:947)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.closeAll(GooGooStatementCache.java:387)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.closeAllCachedS
tatements(NewPooledConnection.java:768) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:609)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.closeMaybeCheck
edOut(NewPooledConnection.java:259) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledCon
nectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:619)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResour
ceTask.run(BasicResourcePool.java:1024) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread
.run(ThreadPoolAsynchronousRunner.java:648) [mchange-commons-java-0.2.3.4.
jar:na]
2017-10-18 14:34:26,117 [] [C3P0PooledConnectionPoolManag
er[identityToken->1bqrhnx9rd697zdr1tks2|7417a2b7]-HelperThread-#2] WARN
(com.mchange.v1.db.sql.StatementUtils): Statement close FAILED.
java.sql.SQLRecoverableException: Closed Connection
        at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:6295)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1364)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1343)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:100)
~[na:12.1.0.1.0]
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.close(Orac
lePreparedStatementWrapper.java:82) ~[na:12.1.0.1.0]
        at com.mchange.v1.db.sql.StatementUtils.attemptClose(StatementUtils.java:53)
~[mchange-commons-java-0.2.3.4.jar:na]
        at com.mchange.v2.c3p0.stmt.GooGooStatementCache$StatementDestr
uctionManager.synchronousDestroyStatement(GooGooStatementCache.java:947)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.closeAll(GooGooStatementCache.java:387)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.closeAllCachedS
tatements(NewPooledConnection.java:768) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:609)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.NewPooledConnection.closeMaybeCheck
edOut(NewPooledConnection.java:259) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledCon
nectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:619)
[c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResour
ceTask.run(BasicResourcePool.java:1024) [c3p0-0.9.2.1.jar:0.9.2.1]
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread
.run(ThreadPoolAsynchronousRunner.java:648) [mchange-commons-java-0.2.3.4.
jar:na]



*2. OurOur config.xml is: *

[...]
<midpoint>
        <webApplication>
            <importFolder>${midpoint.home}/import</importFolder>
        </webApplication>
        <repository>
          <repositoryServiceFactoryClass>com.evolveum.midpoint.repo.
sql.SqlRepositoryFactory</repositoryServiceFactoryClass>
          <database>oracle</database>
          <jdbcUsername>MP_USER</jdbcUsername>
          <jdbcPassword>MP_USERPASS</jdbcPassword>
          <jdbcUrl>jdbc:oracle:thin:@hostDB1:1521/path1</jdbcUrl>
        </repository>
        <taskManager>
          <threads>15</threads>
          <clustered>true</clustered>
          <jdbcUser>MP_USER</jdbcUser>
          <jdbcPassword>MP_USERPASS</jdbcPassword>
          <jdbcUrl>jdbc:oracle:thin:@hostDB1:1521/path1</jdbcUrl>
          <jmxUsername>user</jmxUsername>
          <jmxPassword>password</jmxPassword>

          <jdbcJobStore>true</jdbcJobStore>
          <useThreadInterrupt>whenNecessary</useThreadInterrupt>

          <jmxConnectTimeout>5</jmxConnectTimeout>
          <nodeTimeout>30</nodeTimeout>
          <quartzNodeRegistrationInterval>10</quartzNodeRegistrationInterval
>
          <nodeRegistrationInterval>10</nodeRegistrationInterval>
          <stalledTasksCheckInterval>600</stalledTasksCheckInterval>
          <stalledTasksThreshold>600</stalledTasksThreshold>
          <stalledTasksRepeatedNotificationInterval>3600</
stalledTasksRepeatedNotificationInterval>
          <runNowKeepsOriginalSchedule>false</runNowKeepsOriginalSchedule>

        </taskManager>
[...]

-- 
 

Segun el Articulo 5 de la L.O.P.D, le informamos que sus datos constan en 
un fichero titularidad de CORE NETWORKS, S.L., cuya finalidad es la gestion 
administrativa. Podra ejercer su derecho de acceso, rectificacion, 
cancelacion y oposicion mediante correo postal a C/ Serrano Galvache, 56, 
Edificio Olmo, 1 Planta - C.P. 28033 (MADRID), o enviando un correo 
electrónico a info at corenetworks.es.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20171026/be072f13/attachment.htm>

More information about the midPoint mailing list