数据库恢复到MYSQL 5.7 中间有日志报错 麻烦确认是什么问...

woaiyingch

2023-02-10 10:44:03.045 [ForkJoinPool.commonPool-worker-1] ERROR com.x.server.console.action.RestoreData - id:063b10d5-1de2-4817-985e-7f1076c70b64, name:com.x.server.console.action.RestoreData, message:restore:com.x.cms.core.entity.FileInfo error., exception:java.lang.Exception.
java.lang.Exception: restore:com.x.cms.core.entity.FileInfo error.
        at com.x.server.console.action.RestoreData$RunnableImpl.lambda$run$0(RestoreData.java:129) ~[console.jar:?]
        at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[?:?]
        at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1654) ~[?:?]
        at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484) ~[?:?]
        at java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290) ~[?:?]
        at java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:746) ~[?:?]
        at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) ~[?:?]
        at java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020) ~[?:?]
        at java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656) ~[?:?]
        at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594) ~[?:?]
        at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:177) ~[?:?]
Caused by: org.apache.openjpa.persistence.InvalidStateException: This operation cannot be performed while a Transaction is active.
        at org.apache.openjpa.kernel.BrokerImpl.close(BrokerImpl.java:4559) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.DelegatingBroker.close(DelegatingBroker.java:1508) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.persistence.EntityManagerImpl.close(EntityManagerImpl.java:1598) ~[openjpa-3.2.0.jar:3.2.0]
        at com.x.server.console.action.RestoreData$RunnableImpl.restore(RestoreData.java:171) ~[console.jar:?]
        at com.x.server.console.action.RestoreData$RunnableImpl.lambda$run$0(RestoreData.java:126) ~[console.jar:?]

启蒙星

你o2是什么版本，数据库是5.7的有没有安装5的教程修改驱动

woaiyingch

启蒙星 发表于 2023-2-13 09:35
你o2是什么版本，数据库是5.7的有没有安装5的教程修改驱动

数据库是5.7 ，驱动没有修改，一直有这个报错，
我更改为mysql的版本也同样有这个报错。

恢复后数据中心里的视图正常，但是打开里面的附件是异常没有的。

驱动修改是按照下面的图示么

woaiyingch

启蒙星 发表于 2023-2-13 09:35
你o2是什么版本，数据库是5.7的有没有安装5的教程修改驱动

o2 是7.2.7

论坛管理员

参考一下：https://www.o2oa.net/cms/tech/135.html

woaiyingch

不行，有没有手动导出H2 恢复到mysql 的方法啊

论坛里其他人回复的链接 打开语雀都找不到文档了  

woaiyingch

论坛管理员 发表于 2023-2-13 16:18
参考一下：https://www.o2oa.net/cms/tech/135.html

本帖最后由 woaiyingch 于 2023-2-14 11:09 编辑


不行，有没有手动导出H2 恢复到mysql 的方法啊

论坛里其他人回复的链接 打开语雀都找不到文档了  

启蒙星

你h2导出的文件能压缩发出来不，我们试试

woaiyingch

启蒙星 发表于 2023-2-14 17:23
你h2导出的文件能压缩发出来不，我们试试

不好意思，是内部文件不能外发。

woaiyingch

启蒙星 发表于 2023-2-14 17:23
你h2导出的文件能压缩发出来不，我们试试

我发现恢复数据的时候首先会报一个ftp错误，我使用的是系统自带的存储，数据库变更了MYSQL，存储也要变成FTP么


restore 175/778 part of data:com.x.file.core.entity.open.File.
2023-02-15 15:03:29.324 [ForkJoinPool.commonPool-worker-5] ERROR com.x.server.console.action.RestoreData - id:53d171ae-4772-450d-a699-7a4ee83c5a60, name:com.x.server.console.action.RestoreData, message:restore error with file:/root/o2server/local/dump/dumpData_20230215093139/com.x.cms.core.entity.FileInfo/1415.json., exception:java.lang.Exception.
java.lang.Exception: restore error with file:/root/o2server/local/dump/dumpData_20230215093139/com.x.cms.core.entity.FileInfo/1415.json.
        at com.x.server.console.action.RestoreData$RunnableImpl.lambda$restore$1(RestoreData.java:164) ~[console.jar:?]
        at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1654) ~[?:?]
        at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658) ~[?:?]
        at com.x.server.console.action.RestoreData$RunnableImpl.restore(RestoreData.java:159) ~[console.jar:?]
        at com.x.server.console.action.RestoreData$RunnableImpl.lambda$run$0(RestoreData.java:126) ~[console.jar:?]
        at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[?:?]
        at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1654) ~[?:?]
        at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484) ~[?:?]
        at java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290) ~[?:?]
        at java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:746) ~[?:?]
        at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) ~[?:?]
        at java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020) ~[?:?]
        at java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656) ~[?:?]
        at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594) ~[?:?]
        at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:177) ~[?:?]
Caused by: org.apache.commons.vfs2.FileSystemException: Could not connect to FTP server on "127.0.0.1".
        at org.apache.commons.vfs2.provider.ftp.FtpClientFactory$ConnectionFactory.createConnection(FtpClientFactory.java:232) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.ftp.FtpClientFactory.createConnection(FtpClientFactory.java:272) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.ftp.FTPClientWrapper.createClient(FTPClientWrapper.java:106) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.ftp.FTPClientWrapper.createClient(FTPClientWrapper.java:98) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.ftp.FTPClientWrapper.getFtpClient(FTPClientWrapper.java:147) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.ftp.FTPClientWrapper.<init>(FTPClientWrapper.java:53) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.ftp.FtpFileProvider.doCreateFileSystem(FtpFileProvider.java:70) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.getFileSystem(AbstractOriginatingFileProvider.java:92) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:71) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:55) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:788) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:835) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at com.x.base.core.entity.StorageObject.vfsUpdateContent(StorageObject.java:362) ~[x_base_core_project.jar:?]
        at com.x.base.core.entity.StorageObject.updateContent(StorageObject.java:145) ~[x_base_core_project.jar:?]
        at com.x.base.core.entity.StorageObject.saveContent(StorageObject.java:117) ~[x_base_core_project.jar:?]
        at com.x.server.console.action.RestoreData$RunnableImpl.binary(RestoreData.java:248) ~[console.jar:?]
        at com.x.server.console.action.RestoreData$RunnableImpl.restore(RestoreData.java:190) ~[console.jar:?]
        at com.x.server.console.action.RestoreData$RunnableImpl.lambda$restore$1(RestoreData.java:162) ~[console.jar:?]
        ... 14 more
Caused by: org.apache.commons.net.ftp.FTPConnectionClosedException: FTP response 421 received.  Server closed connection.
        at org.apache.commons.net.ftp.FTP.__getReply(FTP.java:388) ~[commons-net-3.6.jar:3.6]
        at org.apache.commons.net.ftp.FTP.__getReply(FTP.java:300) ~[commons-net-3.6.jar:3.6]
        at org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:523) ~[commons-net-3.6.jar:3.6]
        at org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:648) ~[commons-net-3.6.jar:3.6]
        at org.apache.commons.net.ftp.FTP.user(FTP.java:793) ~[commons-net-3.6.jar:3.6]
        at org.apache.commons.net.ftp.FTPClient.login(FTPClient.java:1073) ~[commons-net-3.6.jar:3.6]
        at org.apache.commons.vfs2.provider.ftp.FtpClientFactory$ConnectionFactory.createConnection(FtpClientFactory.java:173) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.ftp.FtpClientFactory.createConnection(FtpClientFactory.java:272) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.ftp.FTPClientWrapper.createClient(FTPClientWrapper.java:106) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.ftp.FTPClientWrapper.createClient(FTPClientWrapper.java:98) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.ftp.FTPClientWrapper.getFtpClient(FTPClientWrapper.java:147) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.ftp.FTPClientWrapper.<init>(FTPClientWrapper.java:53) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.ftp.FtpFileProvider.doCreateFileSystem(FtpFileProvider.java:70) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.getFileSystem(AbstractOriginatingFileProvider.java:92) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:71) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:55) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:788) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:835) ~[commons-vfs2-2.9.0.jar:2.9.0]
        at com.x.base.core.entity.StorageObject.vfsUpdateContent(StorageObject.java:362) ~[x_base_core_project.jar:?]
        at com.x.base.core.entity.StorageObject.updateContent(StorageObject.java:145) ~[x_base_core_project.jar:?]
        at com.x.base.core.entity.StorageObject.saveContent(StorageObject.java:117) ~[x_base_core_project.jar:?]
        at com.x.server.console.action.RestoreData$RunnableImpl.binary(RestoreData.java:248) ~[console.jar:?]
        at com.x.server.console.action.RestoreData$RunnableImpl.restore(RestoreData.java:190) ~[console.jar:?]
        at com.x.server.console.action.RestoreData$RunnableImpl.lambda$restore$1(RestoreData.java:162) ~[console.jar:?]
        ... 14 more
2023-02-15 15:03:29.325 [Thread-34] ERROR com.x.server.console.action.RestoreData - id:7fa700de-b0b9-4e6c-96a5-a46d10a4ab13, name:com.x.server.console.action.RestoreData, message:restore error with file:/root/o2server/local/dump/dumpData_20230215093139/com.x.file.core.entity.open.File/1750.json., exception:java.lang.Exception.
java.lang.Exception: restore error with file:/root/o2server/local/dump/dumpData_20230215093139/com.x.file.core.entity.open.File/1750.json.
        at com.x.server.console.action.RestoreData$RunnableImpl.lambda$restore$1(RestoreData.java:164) ~[console.jar:?]
        at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1654) ~[?:?]
        at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658) ~[?:?]
        at com.x.server.console.action.RestoreData$RunnableImpl.restore(RestoreData.java:159) ~[console.jar:?]
        at com.x.server.console.action.RestoreData$RunnableImpl.lambda$run$0(RestoreData.java:126) ~[console.jar:?]
        at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[?:?]
        at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1654) ~[?:?]
        at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484) ~[?:?]
        at java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290) ~[?:?]
        at java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:746) ~[?:?]
        at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) ~[?:?]
        at java.util.concurrent.ForkJoinTask.doInvoke(ForkJoinTask.java:408) ~[?:?]
        at java.util.concurrent.ForkJoinTask.invoke(ForkJoinTask.java:736) ~[?:?]
        at java.util.stream.ForEachOps$ForEachOp.evaluateParallel(ForEachOps.java:159) ~[?:?]
        at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateParallel(ForEachOps.java:173) ~[?:?]
        at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:233) ~[?:?]
        at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497) ~[?:?]
        at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:661) ~[?:?]
        at com.x.server.console.action.RestoreData$RunnableImpl.run(RestoreData.java:119) ~[console.jar:?]
        at java.lang.Thread.run(Thread.java:834) ~[?:?]
Caused by: org.apache.openjpa.persistence.InvalidStateException: This operation cannot be performed while a Transaction is active.
        at org.apache.openjpa.kernel.BrokerImpl.begin(BrokerImpl.java:1446) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.DelegatingBroker.begin(DelegatingBroker.java:1026) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.persistence.EntityManagerImpl.begin(EntityManagerImpl.java:684) ~[openjpa-3.2.0.jar:3.2.0]
        at com.x.server.console.action.RestoreData$RunnableImpl.restore(RestoreData.java:179) ~[console.jar:?]
        at com.x.server.console.action.RestoreData$RunnableImpl.lambda$restore$1(RestoreData.java:162) ~[console.jar:?]
        ... 19 more