You have create DB table without UTF-8 support
On Wed, Nov 27, 2013 at 9:00 PM, Michael Wuttke <
michael.wut...@beuth-hochschule.de> wrote:
> Hello Maxim,
>
> I tested with the latest OM 2.2 version (build 22) the backup &
> restoring function to delete old and/or unimportant recordings with the
> following steps.
>
> 0. stop service: /etc/init.d/red5 stop
> 1. perform export: /usr/lib/red5/admin.sh -b -file /tmp/backup.zip
> 2. unzip th backup file, remove the recordings, delete the nodes from
> flvrecordings.xml
> 3. zip the files back to /tmp/import.zip
> 4. drop openmeetings_db
> 5. perform import: /usr/lib/red5/admin.sh -i -v -file /tmp/import.zip
> [6. start service: /etc/init.d/red5 start]
>
> The step 5 ends with the following error message:
> ---
> DEBUG 11-27 13:46:52.966 ImportInitvalues.java 26543 962
> org.apache.openmeetings.installation.ImportInitvalues [main] - Lang
> ADDED:
> org.apache.openmeetings.persistence.beans.lang.FieldLanguage@228830;
> seconds passed: 1
> DEBUG 11-27 13:46:52.966 ImportInitvalues.java 26543 897
> org.apache.openmeetings.installation.ImportInitvalues [main] -
> loadInitLanguages lang: {id=4, name=french, rtl=false, code=fr}
> DEBUG 11-27 13:46:52.967 ImportInitvalues.java 26544 903
> org.apache.openmeetings.installation.ImportInitvalues [main] -
> loadInitLanguages rtl from xml: false
> DEBUG 11-27 13:46:54.305 ImportInitvalues.java 27882 962
> org.apache.openmeetings.installation.ImportInitvalues [main] - Lang
> ADDED:
> org.apache.openmeetings.persistence.beans.lang.FieldLanguage@19feb0d;
> seconds passed: 1
> DEBUG 11-27 13:46:54.306 ImportInitvalues.java 27883 897
> org.apache.openmeetings.installation.ImportInitvalues [main] -
> loadInitLanguages lang: {id=5, name=italian, rtl=false, code=it}
> DEBUG 11-27 13:46:54.306 ImportInitvalues.java 27883 903
> org.apache.openmeetings.installation.ImportInitvalues [main] -
> loadInitLanguages rtl from xml: false
> [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.1-r422266:1396819 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.persistence.beans.lang.Fieldlanguagesvalues@1c44743
> at
>
> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:326)
> ~[spring-orm-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
>
> org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:120)
> ~[spring-orm-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
>
> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:516)
> ~[spring-orm-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
>
> org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
> ~[spring-tx-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
>
> org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
> ~[spring-tx-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
>
> org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393)
> ~[spring-tx-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
>
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
> ~[spring-tx-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
>
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
> ~[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
>
> org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
> ~[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
>
> org.apache.openmeetings.data.basic.FieldLanguageDao$$EnhancerByCGLIB$$e4715177.updateLanguage(<generated>)
> ~[com.springsource.net.sf.cglib-2.2.0.jar:na]
> at
>
> org.apache.openmeetings.installation.ImportInitvalues.loadLanguagesFile(ImportInitvalues.java:961)
> ~[openmeetings-2.2.0-SNAPSHOT.jar:na]
> at
>
> org.apache.openmeetings.installation.ImportInitvalues.loadLanguagesFiles(ImportInitvalues.java:973)
> ~[openmeetings-2.2.0-SNAPSHOT.jar:na]
> at
>
> org.apache.openmeetings.installation.ImportInitvalues.loadInitLanguages(ImportInitvalues.java:987)
> ~[openmeetings-2.2.0-SNAPSHOT.jar:na]
> at
>
> org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:1012)
> ~[openmeetings-2.2.0-SNAPSHOT.jar:na]
> at org.apache.openmeetings.cli.Admin.process(Admin.java:268)
> [openmeetings-2.2.0-SNAPSHOT.jar:na]
> at org.apache.openmeetings.cli.Admin.main(Admin.java:630)
> [openmeetings-2.2.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:2339)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2176)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2074)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1992)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1516)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:933)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:570)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:512)
> ~[spring-orm-jar-3.1.1.RELEASE.jar:3.1.1.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 4403870 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:4958)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4918)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:143)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:99)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:87)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:105)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:78)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:735)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:661)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> ... 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 4403870 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.1.jar:2.2.1]
> at
>
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:59)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1134)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:267)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> at
>
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:118)
> ~[openjpa-bundle-2.2.1.jar:2.2.1]
> ... 33 common frames omitted
> --
>
> Do you have any idea whats wrong?
>
> Thank you,
> Michael
>
> Am 26.11.2013 16:45, schrieb Maxim Solodovnik:
> > 5. *perform import*: /usr/lib/red5/admin.sh -r -file /tmp/import.zip
> >
> > after drop DB you should install with restore
> > /usr/lib/red5/admin.sh *-i -v* -file /tmp/import.zip
>
>
--
WBR
Maxim aka solomax
