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
> at
> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:407)
> ~[spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
> at
> org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:127)
> ~[spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
> at
> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:536)
> ~[spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
> at
> org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746)
> ~[spring-tx-5.1.9.RELEASE.jar:5.1.9.RELEASE]
> at
> org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714)
> ~[spring-tx-5.1.9.RELEASE.jar:5.1.9.RELEASE]
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:534)
> ~[spring-tx-5.1.9.RELEASE.jar:5.1.9.RELEASE]
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:305)
> ~[spring-tx-5.1.9.RELEASE.jar:5.1.9.RELEASE]
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
> ~[spring-tx-5.1.9.RELEASE.jar:5.1.9.RELEASE]
> at
> org.apache.syncope.core.persistence.jpa.spring.DomainTransactionInterceptor.invoke(DomainTransactionInterceptor.java:60)
> ~[syncope-core-persistence-jpa-2.1.5.jar:2.1.5]
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
> ~[spring-aop-5.1.9.RELEASE.jar:5.1.9.RELEASE]
> at
> org.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) ~[?:?]
> at
> org.apachensyncope.core.provisioning.java.job.TaskJob.lambda$execute$0(TaskJob.java:87)
> ~[syncope-core-provisioning-java-2.1.5.jar:2.1.5]
> at
> org.apache.syncope.core.spring.security.AuthContextUtils.execWithAuthContext(AuthContextUtils.java:117)
> ~[syncope-core-spring-2.1.5.jar:2.1.5]
> at
> org.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:?]
> at
> org.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.
> at
> org.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]
> { at
> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2116)
> ~[openjpa-kernel-3.1.0.jar:3.1.0]
> at
> org.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]
> at
> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035)
> ~[openjpa-kernel-3.1.0.jar:3.1.0]
> at
> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:669)
> ~[openjpa-persistence-3.1.0.jar:3.1.0]
> at
> org.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]
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5210)
> ~[openjpa-jdbc-3.1.0.jar:3.1.0]
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
> ~[openjpa-jdbc-3.1.0.jar:3.1.0]
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75)
> ~[openjpa-jdbc-3.1.0.jar:3.1.0]
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:146)
> ~[openjpa-jdbc-3.1.0.jar:3.1.0]
> at
> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80)
> ~[openjpa-jdbc-3.1.0.jar:3.1.0]
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102)
> ~[openjpa-jdbc-3.1.0.jar:3.1.0]
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90)
> ~[openjpa-jdbc-3.1.0.jar:3.1.0]
> at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:554)
> ~[openjpa-jdbc-3.1.0.jar:3.1.0]
> at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:110)
> ~[openjpa-jdbc-3.1.0.jar:3.1.0]
> at
> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61)
> ~[openjpa-jdbc-3.1.0.jar:3.1.0]
> at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:108)
> ~[openjpa-jdbc-3.1.0.jar:3.1.0]
> at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81)
> ~[openjpa-jdbc-3.1.0.jar:3.1.0]
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:757)
> ~[openjpa-jdbc-3.1.0.jar:3.1.0]
> at
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146)
> ~[openjpa-kernel-3.1.0.jar:3.1.0]
> at
> org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:679)
> ~[openjpa-kernel-3.1.0.jar:3.1.0]
> at
> org.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]
> at
> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2116)
> ~[openjpa-kernel-3.1.0.jar:3.1.0]
> at
> org.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]
> at
> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035)
> ~[openjpa-kernel-3.1.0.jar:3.1.0]
> at
> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:669)
> ~[openjpa-persistence-3.1.0.jar:3.1.0]
> at
> org.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/
