It looks like that large binary data is all zeros, approx. 925728 bytes?
Here's hexdump -C: at the beginning:
00000000 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
*
000e2020 31 36 3a 33 32 3a 33 35 2e 31 39 39 20 45 52 52 |16:32:35.199 ERR|
000e2030 4f 52 20 6f 72 67 2e 61 70 61 63 68 65 2e 73 79 |OR org.apache.sy|
000e2040 6e 63 6f 70 65 2e 63 6f 72 65 2e 70 72 6f 76 69 |ncope.core.provi|
Jim
On Tuesday, February 18, 2020, 5:55:26 PM UTC, [email protected]
<[email protected]> wrote:
Hi,
I forgot to mention that just before that first message below, there is a very
large line with what appears to be all binary data.
Jim
On Tuesday, February 18, 2020, 5:48:06 PM UTC, [email protected]
<[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.apache.syncope.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]
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 details 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
