You have DB without UTF-8 support
On Tue, Nov 19, 2013 at 2:35 PM, Varga Balázs <[email protected]> wrote: > 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.commitTransactionAfterReturnin > g(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.BatchingPreparedStatementManag > erImpl.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.BatchingConstraintUpdateManage > r.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 > > > -- WBR Maxim aka solomax
