Hi,
I will take a look but exactly which resource is the "corresponding Resource"
in this case?
Is it the LDAP resource?
On Wednesday, February 19, 2020, 7:27:46 AM UTC, Francesco Chicchiriccò
<[email protected]> wrote:
Hi, the key error message below is
org.apache.openjpa.persistence.PersistenceException: Data truncation: Data
too long for column 'message' at row 1 {prepstmnt 599588377 INSERT INTO
TaskExec (id, endDate, message, startDate, status, TASK_ID) VALUES (?, ?, ?, ?,
?, ?)} [code=1406, state=22001]
e.g. the column TaskExec#message is too narrow; either change the
corresponding Resource's trace level to SUMMARY / ERROR (I bet is set to ALL at
the moment)
Moreover, in case you are using MySQL as Syncope storage, you might want to
extend that column's size: see
https://cwiki.apache.org/confluence/display/SYNCOPE/FAQ#FAQ-Sync/PullTaskExecutionreportnotgeneratedwhenlargenumberofusers(e.g.1000+)existinMySQL
for more details.
HTH
Regards.
On 18/02/20 18:47, [email protected] wrote:
Hi,
We are starting to test running Syncope with larger sets of users and when we
tested today (with adding 500 users to already existing 500), we are seeing the
following errors:
org.springframework.orm.jpa.JpaSystemException: The transaction has been
rolled back. See the nested exceptions for details on the errors that
occurred.; nested exception is
<openjpa-3.1.0-rafcec21a1d489dff682a3ce7986fac6a1c80e8e0 fatal general error>
org.apache.openjpa.persistence.PersistenceException: The transaction has been
rolled back. See the nested exceptions for details on the errors that occurred.
FailedObject:
org.apache.syncope.core.persistence.jpa.entity.task.JPATaskExec@c2d6f27
atorg.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:407)
~[spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
atorg.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:127)
~[spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
atorg.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:536)
~[spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
atorg.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746)
~[spring-tx-5.1.9.RELEASE.jar:5.1.9.RELEASE]
atorg.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714)
~[spring-tx-5.1.9.RELEASE.jar:5.1.9.RELEASE]
atorg.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:534)
~[spring-tx-5.1.9.RELEASE.jar:5.1.9.RELEASE]
atorg.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:305)
~[spring-tx-5.1.9.RELEASE.jar:5.1.9.RELEASE]
atorg.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
~[spring-tx-5.1.9.RELEASE.jar:5.1.9.RELEASE]
atorg.apache.syncope.core.persistence.jpa.spring.DomainTransactionInterceptor.invoke(DomainTransactionInterceptor.java:60)
~[syncope-core-persistence-jpa-2.1.5.jar:2.1.5]
atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
~[spring-aop-5.1.9.RELEASE.jar:5.1.9.RELEASE]
atorg.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
~[spring-aop-5.1.9.RELEASE.jar:5.1.9.RELEASE]
at com.sun.proxy.$Proxy286.execute(Unknown Source) ~[?:?]
atorg.apachensyncope.core.provisioning.java.job.TaskJob.lambda$execute$0(TaskJob.java:87)
~[syncope-core-provisioning-java-2.1.5.jar:2.1.5]
atorg.apache.syncope.core.spring.security.AuthContextUtils.execWithAuthContext(AuthContextUtils.java:117)
~[syncope-core-spring-2.1.5.jar:2.1.5]
atorg.apache.syncope.core.provisioning.java.job.TaskJob.execute(TaskJob.java:76)
~[syncope-core-provisioning-java-2.1.5.jar:2.1.5]
&n"sp; at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
~[quartz-2.3.1.jar:?]
atorg.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
~[quartz-2.3.1.jar:?]
Caused by: org.apache.openjpa.persistence.PersistenceException: The
transaction has been rolled back. See the nested exceptions for det!ils on the
errors that occurred.
atorg.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2470)
~[openjpa-kernel-3.1.0.jar:3.1.0]
at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308)
~[openjpa-kernel-3.1.0.jar:3.1.0]
at
org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199)
~[openjpa-kernel-3.1.0.jar:3.1.0]
{
atorg.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2116)
~[openjpa-kernel-3.1.0.jar:3.1.0]
atorg.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:84)
~[openjpa-kernel-3.1.0.jar:3.1.0]
at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1600)
~[openjpa-kernel-3.1.0.jar:3.1.0]
atorg.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035)
~[openjpa-kernel-3.1.0.jar:3.1.0]
atorg.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:669)
~[openjpa-persistence-3.1.0.jar:3.1.0]
atorg.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:532)
~[spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
... 14 more
Caused by: org.apache.openjpa.persistence.PersistenceException: Data
truncation: Data too long for column 'message' at row 1 {prepstmnt 599588377
INSERT INTO TaskExec (id, endDate, message, startDate, status, TASK_ID) VALUES
(?, ?, ?, ?, ?, ?)} [code=1406, state=22001]
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5250)
~[openjpa-jdbc-3.1.0.jar:3.1.0]
atorg.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5210)
~[openjpa-jdbc-3.1.0.jar:3.1.0]
atorg.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
~[openjpa-jdbc-3.1.0.jar:3.1.0]
atorg.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75)
~[openjpa-jdbc-3.1.0.jar:3.1.0]
atorg.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:146)
~[openjpa-jdbc-3.1.0.jar:3.1.0]
atorg.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80)
~[openjpa-jdbc-3.1.0.jar:3.1.0]
atorg.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102)
~[openjpa-jdbc-3.1.0.jar:3.1.0]
atorg.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90)
~[openjpa-jdbc-3.1.0.jar:3.1.0]
atorg.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:554)
~[openjpa-jdbc-3.1.0.jar:3.1.0]
atorg.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:110)
~[openjpa-jdbc-3.1.0.jar:3.1.0]
atorg.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61)
~[openjpa-jdbc-3.1.0.jar:3.1.0]
atorg.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:108)
~[openjpa-jdbc-3.1.0.jar:3.1.0]
atorg.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81)
~[openjpa-jdbc-3.1.0.jar:3.1.0]
atorg.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:757)
~[openjpa-jdbc-3.1.0.jar:3.1.0]
atorg.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146)
~[openjpa-kernel-3.1.0.jar:3.1.0]
atorg.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:679)
~[openjpa-kernel-3.1.0.jar:3.1.0]
atorg.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146)
~[openjpa-kernel-3.1.0.jar:3.1.0]
at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308)
~[openjpa-kernel-3.1.0.jar:3.1.0]
at
org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199)
~[openjpa-kernel-3.1.0.jar:3.1.0]
atorg.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2116)
~[openjpa-kernel-3.1.0.jar:3.1.0]
atorg.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:84)
~[openjpa-kernel-3.1.0.jar:3.1.0]
at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1600)
~[openjpa-kernel-3.1.0.jar:3.1.0]
atorg.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035)
~[openjpa-kernel-3.1.0.jar:3.1.0]
atorg.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:669)
~[openjpa-persistence-3.1.0.jar:3.1.0]
atorg.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:532)
~[spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
... 14 more
Has anyone seen this before? We think that it might be a threadpool
size-related problem, but are not sure where or what we need to change in the
configuration?
Also FYI, we hope to eventually test like 50K users once we get past this, so
what else will we run into capacity/configuration-wise?
Thanks, Jim
--
Francesco Chicchiriccò
Tirasa - Open Source Excellence
http://www.tirasa.net/
Member at The Apache Software Foundation
Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail
http://home.apache.org/~ilgrosso/
