Hi,
I seem to be answering my own questions all the time...:) I found out that
the problem was indeed the jdbc resource settings.
I had some pretty standard settings according to the documentation, but I
increased the pool size and increased the maxWait a bit and everything went
through.
Regards,
Mikael
From: Mikael Ekblom [mailto:mikael.ekb...@arcada.fi]
Sent: tiistai 10. lokakuuta 2017 9.51
To: user@syncope.apache.org
Subject: Exception during provision on resource AD-connector
Hi,
Has anyone else seen a similar message as the one above regarding the
AD-connector version 1.4.2? We did some stress testing and for about 300
accounts we got five messages as below.
The message caused such behavior on the AD side, that the account was set as
inactive with the change password tab checked.
Another observation was, that this was observed only during a scheduled run of
the pull-task. Not during a manual run. Is quartz running out of resources?
Anyhow it cuts the connection and the password propagation seems to fail for
some without apparent reason.
Exception during provision on resource ArcadaAdNewSync
org.apache.openjpa.persistence.PersistenceException: This statement has been
closed.
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5003)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4963)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:133)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:115)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:687)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.DelegatingStoreManager.load(DelegatingStoreManager.java:117)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.datacache.DataCacheStoreManager.load(DataCacheStoreManager.java:462)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.DelegatingStoreManager.load(DelegatingStoreManager.java:117)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.ROPStoreManager.load(ROPStoreManager.java:78)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.StateManagerImpl.loadFields(StateManagerImpl.java:3145)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.StateManagerImpl.loadField(StateManagerImpl.java:3225)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.StateManagerImpl.beforeAccessField(StateManagerImpl.java:1690)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.StateManagerImpl.accessingField(StateManagerImpl.java:1624)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.syncope.core.persistence.jpa.entity.resource.JPAExternalResource.pcGetorgUnit(JPAExternalResource.java)
~[syncope-core-persistence-jpa-2.0.5.jar:2.0.5]
at
org.apache.syncope.core.persistence.jpa.entity.resource.JPAExternalResource.getOrgUnit(JPAExternalResource.java:239)
~[syncope-core-persistence-jpa-2.0.5.jar:2.0.5]
at
org.apache.syncope.core.provisioning.java.propagation.AbstractPropagationTaskExecutor.execute(AbstractPropagationTaskExecutor.java:381)
~[syncope-core-provisioning-java-2.0.5.jar:2.0.5]
at
org.apache.syncope.core.provisioning.java.propagation.PropagationTaskCallableImpl.call(PropagationTaskCallableImpl.java:89)
~[syncope-core-provisioning-java-2.0.5.jar:2.0.5]
at
org.apache.syncope.core.provisioning.java.propagation.PropagationTaskCallableImpl.call(PropagationTaskCallableImpl.java:38)
~[syncope-core-provisioning-java-2.0.5.jar:2.0.5]
at sun.reflect.GeneratedMethodAccessor957.invoke(Unknown Source)
~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source) ~[?:1.8.0_121]
at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_121]
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
~[spring-tx-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
~[spring-tx-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
~[spring-tx-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.apache.syncope.core.persistence.jpa.spring.DomainTransactionInterceptor.invoke(DomainTransactionInterceptor.java:64)
~[syncope-core-persistence-jpa-2.0.5.jar:2.0.5]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at com.sun.proxy.$Proxy295.call(Unknown Source) ~[?:?]
at java.util.concurrent.FutureTask.run(Unknown Source)
~[?:1.8.0_121]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
Source) ~[?:1.8.0_121]
at java.util.concurrent.FutureTask.run(Unknown Source)
~[?:1.8.0_121]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
Source) ~[?:1.8.0_121]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source) ~[?:1.8.0_121]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_121]
Caused by: org.postgresql.util.PSQLException: This statement has been closed.
at
org.postgresql.jdbc.PgStatement.checkClosed(PgStatement.java:647)
~[postgresql-42.0.0.jar:42.0.0]
at
org.postgresql.jdbc.PgStatement.getResultSet(PgStatement.java:580)
~[postgresql-42.0.0.jar:42.0.0]
at
com.zaxxer.hikari.pool.ProxyStatement.getResultSet(ProxyStatement.java:174)
~[HikariCP-java7-2.4.12.jar:?]
at
com.zaxxer.hikari.pool.HikariProxyPreparedStatement.getResultSet(HikariProxyPreparedStatement.java)
~[HikariCP-java7-2.4.12.jar:?]
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.getResultSet(DelegatingPreparedStatement.java:205)
~[openjpa-lib-2.4.2.jar:2.4.2]
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.getResultSet(DelegatingPreparedStatement.java:203)
~[openjpa-lib-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.sql.PostgresDictionary$PostgresPreparedStatement.executeQuery(PostgresDictionary.java:1018)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268)
~[openjpa-lib-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1800)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:258)
~[openjpa-lib-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:500)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:425)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:392)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:427)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:230)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:220)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.meta.strats.RelationFieldStrategy.load(RelationFieldStrategy.java:835)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.meta.FieldMapping.load(FieldMapping.java:936)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:680)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
... 32 more
Regards,
Mikael
Mikael Ekblom
Systemutvecklare/System developer
Arcada, IT
Jan-Magnus Janssons plats 1,
FIN-00560 Helsingfors,
Finland
TFn: +358 207 699 467
Mobil: +358 207 699 467
