恢复备份时上传出错

NovaShen555

站点需要迁移，在原站备份后的包上传到新站，显示上传错误

服务器内部错误: 服务器内部发生错误，请稍候再试。

日志显示

 Caused by: com.fasterxml.jackson.core.io.JsonEOFException: Unexpected end-of-input: expected close marker for Array (start marker at [Source: (File); line: 1, column: 1])
halo    |  at [Source: (File); line: 1, column: 433093]
halo    | 	at com.fasterxml.jackson.core.base.ParserMinimalBase._reportInvalidEOF(ParserMinimalBase.java:697) ~[jackson-core-2.15.2.jar:2.15.2]
halo    | 	at com.fasterxml.jackson.core.base.ParserBase._handleEOF(ParserBase.java:512) ~[jackson-core-2.15.2.jar:2.15.2]
halo    | 	at com.fasterxml.jackson.core.base.ParserBase._eofAsNextChar(ParserBase.java:529) ~[jackson-core-2.15.2.jar:2.15.2]
halo    | 	at com.fasterxml.jackson.core.json.UTF8StreamJsonParser._skipWSOrEnd(UTF8StreamJsonParser.java:3103) ~[jackson-core-2.15.2.jar:2.15.2]
halo    | 	at com.fasterxml.jackson.core.json.UTF8StreamJsonParser.nextToken(UTF8StreamJsonParser.java:757) ~[jackson-core-2.15.2.jar:2.15.2]
halo    | 	at com.fasterxml.jackson.databind.MappingIterator.hasNextValue(MappingIterator.java:246) ~[jackson-databind-2.15.2.jar:2.15.2]
halo    | 	at com.fasterxml.jackson.databind.MappingIterator.hasNext(MappingIterator.java:186) ~[jackson-databind-2.15.2.jar:2.15.2]
halo    | 	at run.halo.app.migration.impl.MigrationServiceImpl.lambda$restoreExtensions$6(MigrationServiceImpl.java:182) ~[classes/:2.8.0]
halo    | 	at reactor.core.publisher.FluxCreate.subscribe(FluxCreate.java:95) ~[reactor-core-3.5.8.jar:3.5.8]
halo    | 	at reactor.core.publisher.MonoFromFluxOperator.subscribe(MonoFromFluxOperator.java:81) ~[reactor-core-3.5.8.jar:3.5.8]
halo    | 	at reactor.core.publisher.MonoUsing.subscribe(MonoUsing.java:109) ~[reactor-core-3.5.8.jar:3.5.8]
halo    | 	at reactor.core.publisher.Mono.subscribe(Mono.java:4495) ~[reactor-core-3.5.8.jar:3.5.8]
halo    | 	at reactor.core.publisher.MonoWhen$WhenCoordinator.request(MonoWhen.java:227) ~[reactor-core-3.5.8.jar:3.5.8]
halo    | 	at reactor.core.publisher.FluxDoFinally$DoFinallySubscriber.request(FluxDoFinally.java:140) ~[reactor-core-3.5.8.jar:3.5.8]
halo    | 	at reactor.core.publisher.MonoSubscribeOn$SubscribeOnSubscriber.trySchedule(MonoSubscribeOn.java:189) ~[reactor-core-3.5.8.jar:3.5.8]
halo    | 	at reactor.core.publisher.MonoSubscribeOn$SubscribeOnSubscriber.onSubscribe(MonoSubscribeOn.java:134) ~[reactor-core-3.5.8.jar:3.5.8]
halo    | 	at reactor.core.publisher.FluxDoFinally$DoFinallySubscriber.onSubscribe(FluxDoFinally.java:107) ~[reactor-core-3.5.8.jar:3.5.8]
halo    | 	at reactor.core.publisher.MonoWhen.subscribe(MonoWhen.java:99) ~[reactor-core-3.5.8.jar:3.5.8]
halo    | 	at reactor.core.publisher.Mono.subscribe(Mono.java:4495) ~[reactor-core-3.5.8.jar:3.5.8]
halo    | 	at reactor.core.publisher.MonoSubscribeOn$SubscribeOnSubscriber.run(MonoSubscribeOn.java:126) ~[reactor-core-3.5.8.jar:3.5.8]
halo    | 	at reactor.core.scheduler.WorkerTask.call(WorkerTask.java:84) ~[reactor-core-3.5.8.jar:3.5.8]
halo    | 	at reactor.core.scheduler.WorkerTask.call(WorkerTask.java:37) ~[reactor-core-3.5.8.jar:3.5.8]
halo    | 	at java.base/java.util.concurrent.FutureTask.run(Unknown Source) ~[na:na]
halo    | 	at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) ~[na:na]
halo    | 	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) ~[na:na]
halo    | 	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ~[na:na]
halo    | 	at java.base/java.lang.Thread.run(Unknown Source) ~[na:na]
halo    |

NovaShen555

@Ryan Wang 🚀

NovaShen555

环境信息
版本
2.8.0
构建时间
2023-08-01 10:59
Git Commit
ebe77ad
Java
OpenJDK Runtime Environment / 17.0.8+7
数据库
PostgreSQL / 13.2 (Debian 13.2-1.pgdg100+1)
操作系统
Linux 3.10.0-1160.99.1.el7.x86_64 / amd64

Ryan Wang 🚀

看起来像读取数据文件时候的异常，如果方便的话，可以将备份文件发给我测试下。

i@ryanc.cc

NovaShen555

已经发您邮箱了

发现一个问题是，备份时显示文件大小有9.19mb

下载后只有8.8mb，从服务器直接拉文件下来也是8.8

Ryan Wang 🚀

NovaShen555 看了一下，导出的数据文件尾部似乎缺少了一个 ] 导致整个数据文件无法解析。

图片.png

@johnniang 可能会出现这样的情况吗？

NovaShen555

好了，可以恢复了

恢复效果正在查看

NovaShen555

``
2023-10-29T18:32:57.506+08:00 INFO 7 --- [ task-1] run.halo.app.search.IndicesInitializer : Initialized post indices. Usage: StopWatch 'PostIndicesWatch': running time = 37859062498 ns; [rebuild] took 37859062498 ns = 100%
2023-10-29T18:33:05.982+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [420fce9f-5005-46f0-83bd-df85088e04d0] or base snapshot [1f3b13d5-054f-4c2b-a7c7-dcd8ac3d5ce0] not found.
2023-10-29T18:33:16.483+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [3693e97f-b40c-4ba4-8c10-cfe73c2e4ccb] or base snapshot [ccf411ae-c39d-4490-b7b2-db741b2923a0] not found.
2023-10-29T18:33:28.832+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [cbe9d098-1b8d-44d8-b37b-3638391de29b] or base snapshot [5186d33a-e360-41c4-895d-e5e93dc1fafa] not found.
2023-10-29T18:33:38.663+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [ace4578b-5619-4a9b-9af0-13fc2eba8990] or base snapshot [ace4578b-5619-4a9b-9af0-13fc2eba8990] not found.
2023-10-29T18:34:07.906+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [a58975c2-2683-4e71-9e61-c8ad45a1cbf3] or base snapshot [a58975c2-2683-4e71-9e61-c8ad45a1cbf3] not found.
2023-10-29T18:34:09.903+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [80ac414b-99a1-4a63-9579-a0132f6cf86c] or base snapshot [d5e73eb5-1940-4017-b434-4e31901f6c19] not found.
2023-10-29T18:34:28.449+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [f35b8a20-c0c8-45c5-aac9-12008c005308] or base snapshot [1aee477a-395b-4b88-bb63-e302f88584a7] not found.
2023-10-29T18:35:08.994+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [80ac414b-99a1-4a63-9579-a0132f6cf86c] or base snapshot [d5e73eb5-1940-4017-b434-4e31901f6c19] not found.
2023-10-29T18:36:59.775+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [80ac414b-99a1-4a63-9579-a0132f6cf86c] or base snapshot [d5e73eb5-1940-4017-b434-4e31901f6c19] not found.
2023-10-29T18:37:19.469+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [a58975c2-2683-4e71-9e61-c8ad45a1cbf3] or base snapshot [a58975c2-2683-4e71-9e61-c8ad45a1cbf3] not found.
2023-10-29T18:37:26.383+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [80ac414b-99a1-4a63-9579-a0132f6cf86c] or base snapshot [d5e73eb5-1940-4017-b434-4e31901f6c19] not found.
2023-10-29T18:37:33.224+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [ace4578b-5619-4a9b-9af0-13fc2eba8990] or base snapshot [ace4578b-5619-4a9b-9af0-13fc2eba8990] not found.
2023-10-29T18:37:36.361+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [3693e97f-b40c-4ba4-8c10-cfe73c2e4ccb] or base snapshot [ccf411ae-c39d-4490-b7b2-db741b2923a0] not found.
2023-10-29T18:37:42.093+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [cbe9d098-1b8d-44d8-b37b-3638391de29b] or base snapshot [5186d33a-e360-41c4-895d-e5e93dc1fafa] not found.
2023-10-29T18:37:53.702+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [a58975c2-2683-4e71-9e61-c8ad45a1cbf3] or base snapshot [a58975c2-2683-4e71-9e61-c8ad45a1cbf3] not found.
2023-10-29T18:37:59.905+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [ace4578b-5619-4a9b-9af0-13fc2eba8990] or base snapshot [ace4578b-5619-4a9b-9af0-13fc2eba8990] not found.
2023-10-29T18:38:01.637+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [3693e97f-b40c-4ba4-8c10-cfe73c2e4ccb] or base snapshot [ccf411ae-c39d-4490-b7b2-db741b2923a0] not found.
2023-10-29T18:38:08.888+08:00 ERROR 7 --- [tor-tcp-epoll-1] r.h.app.content.AbstractContentService : The content snapshot [cbe9d098-1b8d-44d8-b37b-3638391de29b] or base snapshot [5186d33a-e360-41c4-895d-e5e93dc1fafa] not found.

NovaShen555

删除文章时报错，未知错误，日志未记录
sss

NovaShen555

清空数据库后重新尝试恢复，加载文章发现只加载到了1018，就是有大量文章没有恢复过来

这是新的
1698580620584

这是旧的
1698580666917

NovaShen555

最后是把整个halo文件夹打包传到了新服务器上，postgresql也同步过去，解决了

这个备份与恢复功能，属实鸡肋

Ryan Wang 🚀

NovaShen555 这个备份与恢复功能，属实鸡肋

已经在帮你排查问题了，功能在某些情况下出现异常本身就需要进行排查和复现。

此外，我日常使用此功能的频率非常高，需要经常将线上数据恢复到本地进行测试，甚至于有些用户出现其他问题不方便复现的时候也是让他发一个备份过来，从来就没遇到过这样的问题，也没收到类似反馈。我们本想针对你的情况进行问题排查，结果就被你下一个这样的结论....

NovaShen555

Ryan Wang 🚀

如果我是特殊情况，那我为我的言论道歉，对不起

谢谢您的排查，需要我将halo目录全部打包给你测试吗

还有想问问您个人邮箱用的是哪个项目实现的

Ryan Wang 🚀

NovaShen555 可以把正在正常运行的整个目录发给我。域名邮箱用的腾讯企业邮。

NovaShen555

Ryan Wang 🚀

已发送

系统信息
LSB Version: :core-4.1-amd64:core-4.1-noarch
Distributor ID: CentOS
Description: CentOS Linux release 7.9.2009 (Core)
Release: 7.9.2009
jdk信息
java version "1.8.0_202"
Java(TM) SE Runtime Environment (build 1.8.0_202-b08)
Java HotSpot(TM) 64-Bit Server VM (build 25.202-b08, mixed mode)

Ryan Wang 🚀

NovaShen555 用 Docker 跑的，和你系统的 JDK 没有关系。

NovaShen555

有点怀疑jdk问题(?)吗

NovaShen555

Ryan Wang 🚀

对哦，忘了。。。。

NovaShen555

@Ryan Wang 🚀 有什么眉目了吗，需要我给你我服务器进行测试吗，还有3天到期

Ryan Wang 🚀

NovaShen555 我能排查到的问题都在邮件说明了，通过 localhost 无法访问到数据库你可以给我服务器看看。

NovaShen555

Ryan Wang 🚀 发你了