Hello Boys!
I try upgrading main OM 3.0 (latest apply from jenkins 571 build.) to
newest 653.
Problems:
The upgrade in command line not working, (admin.sh -i -v -f
from.backup.zip), conflict db parsing functions/commands.
Web install not working (mozilla, chrome in ubuntu), always internal error.
The db connection is ok, I rewrite persistence.xml from latest running
config.
I try full original install in CLI and this error occured:
Live logs hier available: http://195.56.44.167:8080/openmeetings/log/
[ERROR] [main] org.apache.openmeetings.cli.Admin - Install failed
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-2.2.2-r422266:1468616 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.openmeetings.db.entity.label.Fieldlanguagesvalues@617df4d3
at
org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:321)
~[spring-orm-jar-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at
org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:120)
~[spring-orm-jar-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:516)
~[spring-orm-jar-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
~[spring-tx-jar-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
~[spring-tx-jar-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:387)
~[spring-tx-jar-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
~[spring-tx-jar-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
~[spring-aop-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
~[spring-aop-3.1.4.RELEASE.jar:3.1.4.RELEASE]
at
org.apache.openmeetings.db.dao.label.FieldLanguageDao$$EnhancerByCGLIB$$79dfd0bf.updateLanguage(<generated>)
~[cglib-nodep-2.2.2.jar:na]
at
org.apache.openmeetings.installation.ImportInitvalues.loadLanguagesFile(ImportInitvalues.java:848)
~[openmeetings-cli-3.0.0-SNAPSHOT.jar:na]
at
org.apache.openmeetings.installation.ImportInitvalues.loadLanguagesFiles(ImportInitvalues.java:875)
~[openmeetings-cli-3.0.0-SNAPSHOT.jar:na]
at
org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:966)
~[openmeetings-cli-3.0.0-SNAPSHOT.jar:na]
at
org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:994)
~[openmeetings-cli-3.0.0-SNAPSHOT.jar:na]
at org.apache.openmeetings.cli.Admin.process(Admin.java:278)
[openmeetings-cli-3.0.0-SNAPSHOT.jar:na]
at org.apache.openmeetings.cli.Admin.main(Admin.java:632)
[openmeetings-cli-3.0.0-SNAPSHOT.jar:na]
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:2347)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2184)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2082)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2000)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1524)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:933)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:570)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:512)
~[spring-orm-jar-3.1.4.RELEASE.jar:3.1.4.RELEASE]
... 13 common frames omitted
Caused by: org.apache.openjpa.persistence.PersistenceException:
Incorrect string value: '\xE2\x88\x9A\xE2\x80\xA0...' for column 'value'
at row 1 {prepstmnt 1879383989 INSERT INTO fieldlanguagesvalues
(deleted, fieldvalues_id, language_id, starttime, updatetime, value)
VALUES (?, ?, ?, ?, ?, ?)} [code=1366, state=HY000]
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4962)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4922)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78) ~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:144)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:105)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:78)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:732)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:661)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
~[openjpa-bundle-2.2.2.jar:2.2.2]
... 21 common frames omitted
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Incorrect
string value: '\xE2\x88\x9A\xE2\x80\xA0...' for column 'value' at row 1
{prepstmnt 1879383989 INSERT INTO fieldlanguagesvalues (deleted,
fieldvalues_id, language_id, starttime, updatetime, value) VALUES (?, ?,
?, ?, ?, ?)} [code=1366, state=HY000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:59)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1134)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:275)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:275)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:268)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:119)
~[openjpa-bundle-2.2.2.jar:2.2.2]
... 33 common frames omitted
Balazs Varga
