[错误报告]: 订阅列表无法加载

[yuan488]

确认

• 我的版本是最新版本，我的版本号与 version 相同。
• 我已经 issue 中搜索过，确认我的问题没有被提出过。
• 我已经 Telegram频道 中搜索过，确认我的问题没有被提出过。
• 我已经修改标题，将标题中的 描述 替换为我遇到的问题。

当前程序版本

v2.0.2

运行环境

Docker

问题类型

主程序运行问题

问题描述

订阅列表无法加载，但日志无报错

发生问题时系统日志和配置文件

2024/11/11 22:08:57  �[32mINFO�[0m:     192.168.31.178:0 - "�[1mGET /api/v1/system/message HTTP/1.1�[0m" �[32m200 OK�[0m

[yuan488]

2024-11-12T14:50:31.961732115Z �[32mINFO�[0m:     192.168.31.178:0 - "�[1mGET /api/v1/system/global HTTP/1.1�[0m" �[32m200 OK�[0m
2024-11-12T14:50:32.043592785Z �[32mINFO�[0m:     192.168.31.178:0 - "�[1mGET /api/v1/system/setting/UserCustomCSS HTTP/1.1�[0m" �[32m200 OK�[0m
2024-11-12T14:50:32.045590432Z �[32mINFO�[0m:     192.168.31.178:0 - "�[1mGET /api/v1/subscribe/ HTTP/1.1�[0m" �[91m500 Internal Server Error�[0m
2024-11-12T14:50:32.046923356Z �[31mERROR�[0m:    Exception in ASGI application
2024-11-12T14:50:32.046943228Z Traceback (most recent call last):
2024-11-12T14:50:32.046948658Z   File "/usr/local/lib/python3.11/site-packages/uvicorn/protocols/http/h11_impl.py", line 428, in run_asgi
2024-11-12T14:50:32.046952825Z     result = await app(  # type: ignore[func-returns-value]
2024-11-12T14:50:32.046956790Z              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-11-12T14:50:32.046960207Z   File "/usr/local/lib/python3.11/site-packages/uvicorn/middleware/proxy_headers.py", line 78, in __call__
2024-11-12T14:50:32.046963726Z     return await self.app(scope, receive, send)
2024-11-12T14:50:32.046966849Z            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-11-12T14:50:32.046969915Z   File "/usr/local/lib/python3.11/site-packages/fastapi/applications.py", line 276, in __call__
2024-11-12T14:50:32.046973210Z     await super().__call__(scope, receive, send)
2024-11-12T14:50:32.046976398Z   File "/usr/local/lib/python3.11/site-packages/starlette/applications.py", line 122, in __call__
2024-11-12T14:50:32.046998892Z     await self.middleware_stack(scope, receive, send)
2024-11-12T14:50:32.047003597Z   File "/usr/local/lib/python3.11/site-packages/starlette/middleware/errors.py", line 184, in __call__
2024-11-12T14:50:32.047007508Z     raise exc
2024-11-12T14:50:32.047010952Z   File "/usr/local/lib/python3.11/site-packages/starlette/middleware/errors.py", line 162, in __call__
2024-11-12T14:50:32.047014249Z     await self.app(scope, receive, _send)
2024-11-12T14:50:32.047017407Z   File "/usr/local/lib/python3.11/site-packages/starlette/middleware/cors.py", line 83, in __call__
2024-11-12T14:50:32.047020607Z     await self.app(scope, receive, send)
2024-11-12T14:50:32.047023800Z   File "/usr/local/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 79, in __call__
2024-11-12T14:50:32.047027097Z     raise exc
2024-11-12T14:50:32.047030359Z   File "/usr/local/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 68, in __call__
2024-11-12T14:50:32.047033652Z     await self.app(scope, receive, sender)
2024-11-12T14:50:32.047036810Z   File "/usr/local/lib/python3.11/site-packages/fastapi/middleware/asyncexitstack.py", line 21, in __call__
2024-11-12T14:50:32.047040055Z     raise e
2024-11-12T14:50:32.047045329Z   File "/usr/local/lib/python3.11/site-packages/fastapi/middleware/asyncexitstack.py", line 18, in __call__
2024-11-12T14:50:32.047048565Z     await self.app(scope, receive, send)
2024-11-12T14:50:32.047051711Z   File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 718, in __call__
2024-11-12T14:50:32.047054927Z     await route.handle(scope, receive, send)
2024-11-12T14:50:32.047058054Z   File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 276, in handle
2024-11-12T14:50:32.047062020Z     await self.app(scope, receive, send)
2024-11-12T14:50:32.047065210Z   File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 66, in app
2024-11-12T14:50:32.047087296Z     response = await func(request)
2024-11-12T14:50:32.047091760Z                ^^^^^^^^^^^^^^^^^^^
2024-11-12T14:50:32.047094972Z   File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 255, in app
2024-11-12T14:50:32.047098291Z     content = await serialize_response(
2024-11-12T14:50:32.047101311Z               ^^^^^^^^^^^^^^^^^^^^^^^^^
2024-11-12T14:50:32.047104489Z   File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 141, in serialize_response
2024-11-12T14:50:32.047107719Z     raise ValidationError(errors, field.type_)
2024-11-12T14:50:32.047110797Z pydantic.error_wrappers.ValidationError: 2 validation errors for Subscribe
2024-11-12T14:50:32.047113966Z response -> 1 -> sites
2024-11-12T14:50:32.047117148Z   value is not a valid list (type=type_error.list)
2024-11-12T14:50:32.047126528Z response -> 2 -> sites
2024-11-12T14:50:32.047130611Z   value is not a valid list (type=type_error.list)
2024-11-12T14:50:35.014226974Z �[32mINFO�[0m:     192.168.31.178:0 - "�[1mGET /api/v1/system/message HTTP/1.1�[0m" �[32m200 OK�[0m
2024-11-12T14:50:42.612967267Z �[32mINFO�[0m:     192.168.31.178:0 - "�[1mGET /api/v1/system/logging HTTP/1.1�[0m" �[32m200 OK�[0m

补充报错日志，更新2.0.3也有同样问题

[yuan488]

重置数据库，再次订阅后，还会报错

[jxxghp]

是用V1的数据库升级过来的？

[f4cker]

是用V1的数据库升级过来的？

新装 v2.0.7 也遇到这个问题，过程中有多次重新部署

[zhouchiyan82]

我直接用的V2，一样，也发生了这个bug

[thsrite]

临时解决方案

安装Sql执行器插件执行以下sql，缺点是订阅设置的订阅站点会被清空

update subscribe set sites = [];

[kktal]

我也有这类问题