[midPoint] Midpoint Task Manager Performance
Pavol Mederly
mederly at evolveum.com
Thu Oct 26 17:26:57 CEST 2017
Hello,
there could be probably some C3P0 parameter dealing with this, but the
first question I would ask is:
Why is Oracle DB closing the connections?
Pavol Mederly
Software developer
evolveum.com
On 26.10.2017 17:18, IDM wrote:
> 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.AttributeRestoringConnectionInvocationHandler.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.executeInNonManagedTXLock(JobStoreSupport.java:3825)
> [quartz-2.2.3.jar:na]
> at
> org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(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.AttributeRestoringConnectionInvocationHandler.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.executeInNonManagedTXLock(JobStoreSupport.java:3825)
> [quartz-2.2.3.jar:na]
> at
> org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(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.AttributeRestoringConnectionInvocationHandler.restoreOriginalAtributes(AttributeRestoringConnectionInvocationHandler.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.executeInNonManagedTXLock(JobStoreSupport.java:3835)
> [quartz-2.2.3.jar:na]
> at
> org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(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.AttributeRestoringConnectionInvocationHandler.restoreOriginalAtributes(AttributeRestoringConnectionInvocationHandler.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.executeInNonManagedTXLock(JobStoreSupport.java:3835)
> [quartz-2.2.3.jar:na]
> at
> org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(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 []
> [C3P0PooledConnectionPoolManager[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(OraclePreparedStatementWrapper.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$StatementDestructionManager.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.closeAllCachedStatements(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.closeMaybeCheckedOut(NewPooledConnection.java:259)
> [c3p0-0.9.2.1.jar:0.9.2.1]
> at
> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:619)
> [c3p0-0.9.2.1.jar:0.9.2.1]
> at com.mchange.v2.resourcepool.Ba
> <http://com.mchange.v2.resourcepool.Ba>sicResourcePool$1DestroyResourceTask.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 []
> [C3P0PooledConnectionPoolManager[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(OraclePreparedStatementWrapper.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$StatementDestructionManager.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.closeAllCachedStatements(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.closeMaybeCheckedOut(NewPooledConnection.java:259)
> [c3p0-0.9.2.1.jar:0.9.2.1]
> at
> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:619)
> [c3p0-0.9.2.1.jar:0.9.2.1]
> at com.mchange.v2.resourcepool.Ba
> <http://com.mchange.v2.resourcepool.Ba>sicResourcePool$1DestroyResourceTask.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 []
> [C3P0PooledConnectionPoolManager[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(OraclePreparedStatementWrapper.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$StatementDestructionManager.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.closeAllCachedStatements(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.closeMaybeCheckedOut(NewPooledConnection.java:259)
> [c3p0-0.9.2.1.jar:0.9.2.1]
> at
> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:619)
> [c3p0-0.9.2.1.jar:0.9.2.1]
> at com.mchange.v2.resourcepool.Ba
> <http://com.mchange.v2.resourcepool.Ba>sicResourcePool$1DestroyResourceTask.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.executeInNonManagedTXLock(JobStoreSupport.java:3803)
> ~[quartz-2.2.3.jar:na]
> at
> org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(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(OraclePreparedStatement.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.executeQuery(NewProxyPreparedStatement.java:116)
> ~[c3p0-0.9.2.1.jar:0.9.2.1]
> at
> org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTriggerToAcquire(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.readNextPacket(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.do
> <http://oracle.jdbc.driver.T4C8Oall.do>OALL(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 []
> [C3P0PooledConnectionPoolManager[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(OraclePreparedStatementWrapper.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$StatementDestructionManager.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.closeAllCachedStatements(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.closeMaybeCheckedOut(NewPooledConnection.java:259)
> [c3p0-0.9.2.1.jar:0.9.2.1]
> at
> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:619)
> [c3p0-0.9.2.1.jar:0.9.2.1]
> at com.mchange.v2.resourcepool.Ba
> <http://com.mchange.v2.resourcepool.Ba>sicResourcePool$1DestroyResourceTask.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 []
> [C3P0PooledConnectionPoolManager[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(OraclePreparedStatementWrapper.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$StatementDestructionManager.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.closeAllCachedStatements(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.closeMaybeCheckedOut(NewPooledConnection.java:259)
> [c3p0-0.9.2.1.jar:0.9.2.1]
> at
> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:619)
> [c3p0-0.9.2.1.jar:0.9.2.1]
> at com.mchange.v2.resourcepool.Ba
> <http://com.mchange.v2.resourcepool.Ba>sicResourcePool$1DestroyResourceTask.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 []
> [C3P0PooledConnectionPoolManager[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(OraclePreparedStatementWrapper.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$StatementDestructionManager.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.closeAllCachedStatements(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.closeMaybeCheckedOut(NewPooledConnection.java:259)
> [c3p0-0.9.2.1.jar:0.9.2.1]
> at
> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:619)
> [c3p0-0.9.2.1.jar:0.9.2.1]
> at com.mchange.v2.resourcepool.Ba
> <http://com.mchange.v2.resourcepool.Ba>sicResourcePool$1DestroyResourceTask.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
> <mailto:info at corenetworks.es>.
>
>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20171026/df88bf79/attachment.htm>
More information about the midPoint
mailing list