search

halo-dev / plugin-comment-widget

通用的 Halo 2.0 评论组件插件
https://halo.run/store/apps/app-YXyaD
GNU General Public License v3.0
22 stars 23 forks source link

评论回复无法显示 #114

Closed HowieHz closed 6 months ago

HowieHz commented 6 months ago

https://howiehz.top/archives/Be-sure-to-reply-to-the-anonymous-comment-under-your-blog-post image 7条回复 image

实际仅能显示五条，加载更多加载不出来，ctrl+f5刷新无效 image image

点击加载更多之后，可以看到到Soulizer回复我的第二条就截断了 Soulizer回复我的第三条和我后面回复他的一条加载不出来 image

插件信息 image image

系统信息：

ruibaby commented 6 months ago

感谢反馈此问题，这个问题看起来应该是接口的数据返回有问题呢，比如有一条评论的回复数确实是 7 条，但其实查询出来只有五条。

数据库: mariadb.org binary distribution / 5.5.5-10.11.7-MariaDB-1:10.11.7+maria~ubu2204

注意到你使用了 MariaDB，不太确定是否和 https://github.com/halo-dev/halo/issues/5534 有关，我建议按照 https://github.com/halo-dev/halo/issues/5534#issuecomment-2011499798 提到的做法改为使用 mysql 驱动。

HowieHz commented 6 months ago

感谢反馈此问题，这个问题看起来应该是接口的数据返回有问题呢，比如有一条评论的回复数确实是 7 条，但其实查询出来只有五条。

数据库: mariadb.org binary distribution / 5.5.5-10.11.7-MariaDB-1:10.11.7+maria~ubu2204

注意到你使用了 MariaDB，不太确定是否和 halo-dev/halo#5534 有关，我建议按照 halo-dev/halo#5534 (comment) 提到的做法改为使用 mysql 驱动。

image 应该是这样的吧，哈哈，我记得您之前就让我使用 mysql 驱动了，现在依然是这个驱动

https://github.com/halo-dev/halo/issues/5643#issuecomment-2042640480 🌝

ruibaby commented 6 months ago

应该是这样的吧，哈哈，我记得您之前就让我使用 mysql 驱动了，现在依然是这个驱动

那这就有点奇怪了， @guqing 有时间帮忙看看呢。

HowieHz commented 6 months ago

目前最新的日志，在评论区加载更多评论时未出现新报错

出现的 /archives/[%E8%AF%A5%E6%8F%92%E4%BB%B6%E9%A1%B9%E7%9B%AEREADME] 不知道是啥，plugin-umami 未启用且我没有名为 [%E8%AF%A5%E6%8F%92%E4%BB%B6%E9%A1%B9%E7%9B%AEREADME] 的文章

2024-04-23T12:01:09.618+08:00  WARN 7 --- [yReconciler-t-1] r.h.a.e.controller.DefaultController     : Optimistic locking failure when reconciling request: run.halo.app.core.extension.reconciler.ReplyReconciler-worker-1/Request[name=e950faee-b346-453f-b586-e90489c39dec]
2024-04-23T12:03:04.484+08:00  WARN 7 --- [yReconciler-t-1] r.h.a.e.controller.DefaultController     : Optimistic locking failure when reconciling request: run.halo.app.core.extension.reconciler.ReplyReconciler-worker-1/Request[name=0e58d6cd-a5de-4902-bb1a-8314b9c042b2]
2024-04-23T12:19:17.134+08:00  WARN 7 --- [yReconciler-t-1] r.h.a.e.controller.DefaultController     : Optimistic locking failure when reconciling request: run.halo.app.core.extension.reconciler.ReplyReconciler-worker-1/Request[name=1e91ec2d-13fd-40c9-9c10-2b582365c1e4]
2024-04-23T18:09:09.269+08:00  WARN 7 --- [tReconciler-t-1] r.h.a.e.controller.DefaultController     : Optimistic locking failure when reconciling request: run.halo.app.metrics.ReplyEventReconciler-worker-1/CommentName[name=8ef34f87-4418-49ff-96ae-e91b42421c2d]
2024-04-23T18:15:24.423+08:00  WARN 7 --- [yReconciler-t-1] r.h.a.e.controller.DefaultController     : Optimistic locking failure when reconciling request: run.halo.app.core.extension.reconciler.ReplyReconciler-worker-1/Request[name=6a508646-3b43-4d5c-bf1f-a980ffa50355]
2024-04-23T18:15:30.589+08:00  WARN 7 --- [tReconciler-t-1] r.h.a.e.controller.DefaultController     : Optimistic locking failure when reconciling request: run.halo.app.core.extension.reconciler.CommentReconciler-worker-1/Request[name=c5d10b9d-a325-4e54-ad37-fd4bff3a21e4]
2024-04-23T18:26:21.378+08:00  WARN 7 --- [yReconciler-t-1] r.h.a.e.controller.DefaultController     : Optimistic locking failure when reconciling request: run.halo.app.core.extension.reconciler.ReplyReconciler-worker-1/Request[name=ffcfb5cc-6602-48ae-9ada-0c82d2359ac6]
2024-04-23T18:28:00.211+08:00  WARN 7 --- [yReconciler-t-1] r.h.a.e.controller.DefaultController     : Optimistic locking failure when reconciling request: run.halo.app.core.extension.reconciler.ReplyReconciler-worker-1/Request[name=1c5f0a5f-c700-4378-9c09-7e125ee9131c]
2024-04-23T18:45:45.329+08:00  WARN 7 --- [tReconciler-t-1] r.h.a.e.controller.DefaultController     : Optimistic locking failure when reconciling request: run.halo.app.metrics.ReplyEventReconciler-worker-1/CommentName[name=8e8cfb58-188e-4e92-b93c-8be1957dc993]
2024-04-23T18:46:01.548+08:00  WARN 7 --- [yReconciler-t-1] r.h.a.e.controller.DefaultController     : Optimistic locking failure when reconciling request: run.halo.app.core.extension.reconciler.ReplyReconciler-worker-1/Request[name=bde7f67e-239f-46de-9740-76c3cca74f4e]
2024-04-23T18:46:03.369+08:00  WARN 7 --- [tReconciler-t-1] r.h.a.e.controller.DefaultController     : Optimistic locking failure when reconciling request: run.halo.app.metrics.ReplyEventReconciler-worker-1/CommentName[name=8ef34f87-4418-49ff-96ae-e91b42421c2d]
2024-04-23T18:46:04.152+08:00  WARN 7 --- [tReconciler-t-1] r.h.a.e.controller.DefaultController     : Optimistic locking failure when reconciling request: run.halo.app.metrics.ReplyEventReconciler-worker-1/CommentName[name=1ee1bd9d-0575-447a-b3ee-70a9b3c5cc6e]
2024-04-23T18:49:34.699+08:00  WARN 7 --- [yReconciler-t-1] r.h.a.e.controller.DefaultController     : Optimistic locking failure when reconciling request: run.halo.app.core.extension.reconciler.ReplyReconciler-worker-1/Request[name=5e88bc40-e7f9-452c-a68d-b67d3877fe0b]
2024-04-23T21:47:35.013+08:00  WARN 7 --- [tReconciler-t-1] r.h.a.e.controller.DefaultController     : Optimistic locking failure when reconciling request: run.halo.app.core.extension.reconciler.CommentReconciler-worker-1/Request[name=fe4ed40c-8578-4956-8d6e-7a42fdd0ff45]
2024-04-23T21:50:02.965+08:00  INFO 7 --- [   scheduling-1] r.h.a.s.a.login.impl.RsaKeyService       : Generating RSA keys...
2024-04-23T21:50:04.359+08:00  INFO 7 --- [   scheduling-1] r.h.a.s.a.login.impl.RsaKeyService       : Generated RSA keys. Usage: 1393 ms.
2024-04-23T22:18:25.167+08:00  WARN 7 --- [tReconciler-t-1] r.h.a.e.controller.DefaultController     : Optimistic locking failure when reconciling request: run.halo.app.core.extension.reconciler.PostReconciler-worker-1/Request[name=46251a14-e943-45eb-82bc-48fd03d90b11]
2024-04-23T22:18:25.273+08:00  WARN 7 --- [tReconciler-t-1] r.h.a.e.controller.DefaultController     : Optimistic locking failure when reconciling request: run.halo.app.core.extension.reconciler.PostReconciler-worker-1/Request[name=46251a14-e943-45eb-82bc-48fd03d90b11]
2024-04-24T08:01:10.621+08:00  WARN 7 --- [or-http-epoll-2] r.n.http.server.HttpServerOperations     : [6a91a81d, L:/172.18.0.2:8090 - R:/192.168.10.105:42704] Decoding failed: REQUEST(decodeResult: failure(java.net.URISyntaxException: Illegal character in path at index 31: http://localhost:8080/archives/[%E8%AF%A5%E6%8F%92%E4%BB%B6%E9%A1%B9%E7%9B%AEREADME](https://github.com/halo-sigs/plugin-umami)), version: HTTP/1.1)
GET /archives/[%E8%AF%A5%E6%8F%92%E4%BB%B6%E9%A1%B9%E7%9B%AEREADME](https://github.com/halo-sigs/plugin-umami) HTTP/1.1
Host: <filtered>
X-Real-IP: <filtered>
X-Forwarded-For: <filtered>
REMOTE-HOST: <filtered>
Connection: <filtered>
X-Forwarded-Proto: <filtered>
cdn-loop: <filtered>
cf-ipcountry: <filtered>
accept-encoding: <filtered>
cf-ray: <filtered>
cf-visitor: <filtered>
accept: <filtered>
user-agent: <filtered>
accept-language: <filtered>
cf-connecting-ip: <filtered>
2024-04-24T18:10:11.204+08:00  WARN 7 --- [tor-tcp-epoll-1] i.a.r.mysql.client.ReactorNettyClient    : Connection unexpectedly closed
HowieHz commented 6 months ago

重启容器后依然无法加载更多评论回复，log 也未出现报错

guqing commented 6 months ago

howiehz.top/archives/Be-sure-to-reply-to-the-anonymous-comment-under-your-blog-post

通过 API 看是返回了 7 条的，数据没有问题 reply 7 API

image

评论传递默认返回的是带5条回复replySize: 5, 但是点击加载更多时的分页参数是 page: 2,size: 10这样确实无法查询更多数据，应该是参数问题

@ruibaby

HowieHz commented 6 months ago

好的，目前把同时加载回复的条数 *设定为 500 来暂时解决这个问题 image

ruibaby commented 6 months ago

明白这个问题导致的原因了，可能需要在开启 同时加载评论的回复 选项时，分页条数参数要使用 同时加载回复的条数，而不是 默认加载回复条数。

ruibaby commented 6 months ago

/king bug