woaiyingch 发表于 2023-2-10 10:51:54

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

2023-02-10 10:44:03.045 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) ~
      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) ~
      at org.apache.openjpa.kernel.DelegatingBroker.close(DelegatingBroker.java:1508) ~
      at org.apache.openjpa.persistence.EntityManagerImpl.close(EntityManagerImpl.java:1598) ~
      at com.x.server.console.action.RestoreData$RunnableImpl.restore(RestoreData.java:171) ~
      at com.x.server.console.action.RestoreData$RunnableImpl.lambda$run$0(RestoreData.java:126) ~

启蒙星 发表于 2023-2-13 09:35:38

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

woaiyingch 发表于 2023-2-13 09:41:48

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

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

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

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



woaiyingch 发表于 2023-2-13 09:44:14

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

o2 是7.2.7

论坛管理员 发表于 2023-2-13 16:18:26

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

woaiyingch 发表于 2023-2-14 11:06:07

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

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

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

woaiyingch 发表于 2023-2-14 11:10:09

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


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


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

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

启蒙星 发表于 2023-2-14 17:23:34

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

woaiyingch 发表于 2023-2-15 09:32:25

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

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

woaiyingch 发表于 2023-2-15 15:17:52

启蒙星 发表于 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 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) ~
      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) ~
      at com.x.server.console.action.RestoreData$RunnableImpl.lambda$run$0(RestoreData.java:126) ~
      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) ~
      at org.apache.commons.vfs2.provider.ftp.FtpClientFactory.createConnection(FtpClientFactory.java:272) ~
      at org.apache.commons.vfs2.provider.ftp.FTPClientWrapper.createClient(FTPClientWrapper.java:106) ~
      at org.apache.commons.vfs2.provider.ftp.FTPClientWrapper.createClient(FTPClientWrapper.java:98) ~
      at org.apache.commons.vfs2.provider.ftp.FTPClientWrapper.getFtpClient(FTPClientWrapper.java:147) ~
      at org.apache.commons.vfs2.provider.ftp.FTPClientWrapper.<init>(FTPClientWrapper.java:53) ~
      at org.apache.commons.vfs2.provider.ftp.FtpFileProvider.doCreateFileSystem(FtpFileProvider.java:70) ~
      at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.getFileSystem(AbstractOriginatingFileProvider.java:92) ~
      at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:71) ~
      at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:55) ~
      at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:788) ~
      at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:835) ~
      at com.x.base.core.entity.StorageObject.vfsUpdateContent(StorageObject.java:362) ~
      at com.x.base.core.entity.StorageObject.updateContent(StorageObject.java:145) ~
      at com.x.base.core.entity.StorageObject.saveContent(StorageObject.java:117) ~
      at com.x.server.console.action.RestoreData$RunnableImpl.binary(RestoreData.java:248) ~
      at com.x.server.console.action.RestoreData$RunnableImpl.restore(RestoreData.java:190) ~
      at com.x.server.console.action.RestoreData$RunnableImpl.lambda$restore$1(RestoreData.java:162) ~
      ... 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) ~
      at org.apache.commons.net.ftp.FTP.__getReply(FTP.java:300) ~
      at org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:523) ~
      at org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:648) ~
      at org.apache.commons.net.ftp.FTP.user(FTP.java:793) ~
      at org.apache.commons.net.ftp.FTPClient.login(FTPClient.java:1073) ~
      at org.apache.commons.vfs2.provider.ftp.FtpClientFactory$ConnectionFactory.createConnection(FtpClientFactory.java:173) ~
      at org.apache.commons.vfs2.provider.ftp.FtpClientFactory.createConnection(FtpClientFactory.java:272) ~
      at org.apache.commons.vfs2.provider.ftp.FTPClientWrapper.createClient(FTPClientWrapper.java:106) ~
      at org.apache.commons.vfs2.provider.ftp.FTPClientWrapper.createClient(FTPClientWrapper.java:98) ~
      at org.apache.commons.vfs2.provider.ftp.FTPClientWrapper.getFtpClient(FTPClientWrapper.java:147) ~
      at org.apache.commons.vfs2.provider.ftp.FTPClientWrapper.<init>(FTPClientWrapper.java:53) ~
      at org.apache.commons.vfs2.provider.ftp.FtpFileProvider.doCreateFileSystem(FtpFileProvider.java:70) ~
      at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.getFileSystem(AbstractOriginatingFileProvider.java:92) ~
      at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:71) ~
      at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:55) ~
      at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:788) ~
      at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:835) ~
      at com.x.base.core.entity.StorageObject.vfsUpdateContent(StorageObject.java:362) ~
      at com.x.base.core.entity.StorageObject.updateContent(StorageObject.java:145) ~
      at com.x.base.core.entity.StorageObject.saveContent(StorageObject.java:117) ~
      at com.x.server.console.action.RestoreData$RunnableImpl.binary(RestoreData.java:248) ~
      at com.x.server.console.action.RestoreData$RunnableImpl.restore(RestoreData.java:190) ~
      at com.x.server.console.action.RestoreData$RunnableImpl.lambda$restore$1(RestoreData.java:162) ~
      ... 14 more
2023-02-15 15:03:29.325 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) ~
      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) ~
      at com.x.server.console.action.RestoreData$RunnableImpl.lambda$run$0(RestoreData.java:126) ~
      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) ~
      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) ~
      at org.apache.openjpa.kernel.DelegatingBroker.begin(DelegatingBroker.java:1026) ~
      at org.apache.openjpa.persistence.EntityManagerImpl.begin(EntityManagerImpl.java:684) ~
      at com.x.server.console.action.RestoreData$RunnableImpl.restore(RestoreData.java:179) ~
      at com.x.server.console.action.RestoreData$RunnableImpl.lambda$restore$1(RestoreData.java:162) ~
      ... 19 more
页: [1] 2
查看完整版本: 数据库恢复到MYSQL 5.7 中间有日志报错 麻烦确认是什么问...