求助，无法更新 #192
Comments
|
需要提供一下，添加公众号报错请求时服务器中日志 |
好像被打入小黑屋了，怎么办呢5555 ===== Application Startup at 2024-07-02 14:52:56 ===== Prisma schema loaded from prisma/schema.prisma 1 migration found in prisma/migrations No pending migrations to apply. [Nest] 70 - 07/02/2024, 3:03:46 PM LOG [TrpcService] error: [Nest] 70 - 07/02/2024, 3:03:54 PM LOG [TrpcService] error: [Nest] 70 - 07/02/2024, 3:04:01 PM LOG [TrpcService] error: [Nest] 70 - 07/02/2024, 3:04:09 PM LOG [TrpcService] error: |
|
别慌，第二天就自动会放出来 |
|
现在还没放出来，还没有更新。。。。。。 |
|
每天0点，会自动重新开始计数。是不是因为那时更新了一下，然后又进去了。。 |
|
应该没有，不过我再等等等 |
|
可以考虑直接删了重新加，然后观察一下。同时要确认在其他web端没有扫码登录 |
|
以上几种方式我都试过了。一直还在小黑屋了。应该是作者的服务器里的处理逻辑机制发生故障了。@cooderl |
可以换个账号试一下，有些账号可能创建的时候有点问题，一直无法使用。 |
好像确实不行，我的还没放出来 |
|
你上面的日志里看有两个公众号更新了，后面账号就不能用了。你有在其他设备上使用微信读书吗 |
我在安卓平板上下载使用过微信读书（当时也是为了集中订阅公众号文章），但是后来看到这个方案后果断把微信读书app删掉了，再也没使用过，大概一两个月了 是挺奇怪，我当时看到log也是有几个更新了，但是从huggingface空间主页并没有文章更新 |
|
然后我刚重启了一下huggingface spaces，重启后log是这样的 Server is running at http://0.0.0.0:4000 [Nest] 70 - 07/08/2024, 9:49:15 AM LOG [FeedsController] getFeed: [Nest] 70 - 07/08/2024, 9:49:16 AM LOG [FeedsService] handleGenerateFeed articles: 8 |
|
你看下这个公众号有没有更新数据 |
我实际从6月27日开始就无法收到更新了，上面日志提示有更新的2个公众号当时并没有发布新的文章（实际上这两个公众号更新频率不高，日志提示分别更新了10篇文章，这并不合理）； 因为刚才进huggingfaces spaces，看日志又提示更新了很多文章，但主页抓到的最新的文章还是停留在6月27日 ===== Application Startup at 2024-07-08 09:48:23 ===== Prisma schema loaded from prisma/schema.prisma 1 migration found in prisma/migrations No pending migrations to apply. [Nest] 70 - 07/08/2024, 9:49:15 AM LOG [FeedsController] getFeed: [Nest] 70 - 07/08/2024, 9:49:16 AM LOG [FeedsService] handleGenerateFeed articles: 8 [Nest] 70 - 07/08/2024, 9:51:32 AM DEBUG [TrpcService] disabledAccounts: [Nest] 70 - 07/08/2024, 9:51:43 AM DEBUG [TrpcService] disabledAccounts: [Nest] 70 - 07/08/2024, 9:51:52 AM DEBUG [TrpcService] disabledAccounts: [Nest] 70 - 07/08/2024, 9:53:44 AM LOG [FeedsController] getFeed: [Nest] 70 - 07/08/2024, 10:09:26 AM LOG [FeedsController] getFeed: [Nest] 70 - 07/08/2024, 10:44:33 AM LOG [FeedsController] getFeed: [Nest] 70 - 07/08/2024, 11:00:49 AM LOG [TrpcService] error: [Nest] 70 - 07/08/2024, 11:00:56 AM LOG [TrpcService] error: [Nest] 70 - 07/08/2024, 11:01:04 AM LOG [TrpcService] error: [Nest] 70 - 07/08/2024, 11:01:08 AM LOG [FeedsController] getFeed: [Nest] 70 - 07/08/2024, 11:04:32 AM LOG [FeedsService] handleGenerateFeed articles: 30 |
|
方便把访问地址放出来吗，感觉看日志应该有更新文章 |
|
您好，
您可以登录帮我看一下吗？
huggingface的地址：https://huggingface.co/spaces/libra2/wechatrss
***@***.***
***@***.***
auth code: 123456
非常感谢！
Sent from Outlook<http://aka.ms/weboutlook>
…________________________________
From: leozhou ***@***.***>
Sent: Tuesday, July 9, 2024 12:07 AM
To: cooderl/wewe-rss ***@***.***>
Cc: kobolibra ***@***.***>; Author ***@***.***>
Subject: Re: [cooderl/wewe-rss] 求助，无法更新 (Issue #192)
方便把访问地址放出来吗，感觉看日志应该有更新文章
―
Reply to this email directly, view it on GitHub<#192 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BH7I266ZG3D6TPCCCGEIOR3ZLOD3PAVCNFSM6AAAAABKHJ7IMKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMJWG43DCOBQGU>.
You are receiving this because you authored the thread.Message ID: ***@***.***>
|
我给您的qq邮箱发了一封邮件，不知道能不能收到？ |
|
收到了，我打开wewerss网址后，加了自己的微信读书账号，禁用了你的，然后公众号可以同步成功的。
看起来是你账号的问题，尝试删除后重新添加一下。
… 2024年7月9日 15:22，kobolibra ***@***.***> 写道：
方便把访问地址放出来吗，感觉看日志应该有更新文章
我给您的qq邮箱发了一封邮件，不知道能不能收到？
—
Reply to this email directly, view it on GitHub <#192 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABBYOIWIMEC4UMDGW2HWAHLZLOFSDAVCNFSM6AAAAABKHJ7IMKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMJWG44TQMBWGM>.
You are receiving this because you commented.
|
好的，我重新试一下，感谢！ |
|
#187 |
是的，应该是同一个问题 我刚刚把账号删掉然后重新添加，感觉我这个账号被永久禁用了。。。 [Nest] 70 - 07/09/2024, 7:35:57 AM DEBUG [TrpcService] disabledAccounts: |
|
换了一个账号，然后又被封了。。。。。。 [Nest] 70 - 07/09/2024, 10:09:15 AM DEBUG [TrpcService] disabledAccounts: [Nest] 70 - 07/09/2024, 10:09:25 AM LOG [TrpcService] error: [Nest] 70 - 07/09/2024, 10:09:39 AM DEBUG [TrpcService] disabledAccounts: [Nest] 70 - 07/09/2024, 10:09:45 AM LOG [TrpcService] error: [Nest] 70 - 07/09/2024, 10:09:55 AM ERROR [TrpcService] retry(2) getMpArticles error: [Nest] 70 - 07/09/2024, 10:10:05 AM LOG [TrpcService] error: [Nest] 70 - 07/09/2024, 10:10:26 AM LOG [TrpcService] error: |
|
这个错误和之前的不一样，应该不是封禁的问题。有同步成功过公众号吗
… 2024年7月9日 18:11，kobolibra ***@***.***> 写道：
换了一个账号，然后又被封了。。。。。。
[Nest] 70 - 07/09/2024, 10:09:15 AM DEBUG [TrpcService] disabledAccounts:
[Nest] 70 - 07/09/2024, 10:09:15 AM DEBUG [TrpcService] Object:
[]
[Nest] 70 - 07/09/2024, 10:09:25 AM LOG [TrpcService] error:
[Nest] 70 - 07/09/2024, 10:09:25 AM LOG [TrpcService] AxiosError: Request failed with status code 500
[Nest] 70 - 07/09/2024, 10:09:25 AM ERROR [TrpcService] 账号（2208209）处理请求参数出错
[Nest] 70 - 07/09/2024, 10:09:25 AM ERROR [TrpcService] WeReadError400:
id(2208209): WeReadError400
[Nest] 70 - 07/09/2024, 10:09:29 AM LOG [FeedsController] getFeed:
[Nest] 70 - 07/09/2024, 10:09:29 AM LOG [FeedsController] MP_WXS_3880964167
[Nest] 70 - 07/09/2024, 10:09:30 AM LOG [FeedsService] handleGenerateFeed articles: 10
[Nest] 70 - 07/09/2024, 10:09:35 AM ERROR [TrpcService] retry(1) getMpArticles error:
[Nest] 70 - 07/09/2024, 10:09:35 AM ERROR [TrpcService] AxiosError: Request failed with status code 500
[Nest] 70 - 07/09/2024, 10:09:35 AM DEBUG [TrpcService] disabledAccounts:
[Nest] 70 - 07/09/2024, 10:09:35 AM DEBUG [TrpcService] Object:
[]
[Nest] 70 - 07/09/2024, 10:09:39 AM DEBUG [TrpcService] disabledAccounts:
[Nest] 70 - 07/09/2024, 10:09:39 AM DEBUG [TrpcService] Object:
[]
[Nest] 70 - 07/09/2024, 10:09:45 AM LOG [TrpcService] error:
[Nest] 70 - 07/09/2024, 10:09:45 AM LOG [TrpcService] AxiosError: Request failed with status code 500
[Nest] 70 - 07/09/2024, 10:09:45 AM ERROR [TrpcService] 账号（2208209）处理请求参数出错
[Nest] 70 - 07/09/2024, 10:09:45 AM ERROR [TrpcService] WeReadError400:
id(2208209): WeReadError400
[Nest] 70 - 07/09/2024, 10:09:46 AM DEBUG [TrpcService] disabledAccounts:
[Nest] 70 - 07/09/2024, 10:09:46 AM DEBUG [TrpcService] Object:
[]
[Nest] 70 - 07/09/2024, 10:09:55 AM ERROR [TrpcService] retry(2) getMpArticles error:
[Nest] 70 - 07/09/2024, 10:09:55 AM ERROR [TrpcService] AxiosError: Request failed with status code 500
[Nest] 70 - 07/09/2024, 10:09:55 AM DEBUG [TrpcService] disabledAccounts:
[Nest] 70 - 07/09/2024, 10:09:55 AM DEBUG [TrpcService] Object:
[]
[Nest] 70 - 07/09/2024, 10:10:05 AM LOG [TrpcService] error:
[Nest] 70 - 07/09/2024, 10:10:05 AM LOG [TrpcService] AxiosError: Request failed with status code 500
[Nest] 70 - 07/09/2024, 10:10:05 AM ERROR [TrpcService] 账号（2208209）处理请求参数出错
[Nest] 70 - 07/09/2024, 10:10:05 AM ERROR [TrpcService] WeReadError400:
id(2208209): WeReadError400
[Nest] 70 - 07/09/2024, 10:10:15 AM ERROR [TrpcService] retry(3) getMpArticles error:
[Nest] 70 - 07/09/2024, 10:10:15 AM ERROR [TrpcService] AxiosError: Request failed with status code 500
[Nest] 70 - 07/09/2024, 10:10:15 AM DEBUG [TrpcService] disabledAccounts:
[Nest] 70 - 07/09/2024, 10:10:15 AM DEBUG [TrpcService] Object:
[]
[Nest] 70 - 07/09/2024, 10:10:26 AM LOG [TrpcService] error:
[Nest] 70 - 07/09/2024, 10:10:26 AM LOG [TrpcService] AxiosError: Request failed with status code 500
[Nest] 70 - 07/09/2024, 10:10:26 AM ERROR [TrpcService] 账号（2208209）处理请求参数出错
[Nest] 70 - 07/09/2024, 10:10:26 AM ERROR [TrpcService] WeReadError400:
id(2208209): WeReadError400
[Nest] 70 - 07/09/2024, 10:10:36 AM ERROR [TrpcService] retry(4) getMpArticles error:
[Nest] 70 - 07/09/2024, 10:10:36 AM ERROR [TrpcService] AxiosError: Request failed with status code 500
[Nest] 70 - 07/09/2024, 10:10:36 AM ERROR [FeedsService] handleUpdateFeedsCron error
[Nest] 70 - 07/09/2024, 10:10:36 AM ERROR [FeedsService] AxiosError: Request failed with status code 500
—
Reply to this email directly, view it on GitHub <#192 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABBYOIVKPT5RADJL4USULFLZLOZNRAVCNFSM6AAAAABKHJ7IMKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMJXGIZTSNJUGI>.
You are receiving this because you commented.
|
有的，只有一个公众号新增了3篇文章（补足了上次更新到昨天的文章），但是这个公众号其实今天也有文章更新 |
|
我发现其中一个原因是超过了https://sqlpub.com/同时30个连接的限制，这个要怎么解决呢？是不是添加超过30个公众号就会有这个问题呢？ Error in connector: Error querying the database: Server error: `ERROR 42000 (1226): User 'xxxx' has exceeded the 'max_user_connections' resource (current value: 30)' |
|
请问迁移完成后，这个问题也可以解决了吗？一直没有更新。。。。 |
|
我觉得这个同步问题，跟中转那个没啥关系。
|
我从开始就是差不多加了这么多公众号（超过30），但是这个报错只是最近才出现的，我猜测添加超过30个公众号 使用sqlpub应该算比较普遍吧；而且，即使我手动单独更新某一个公众号，似乎也会触发所有公众号去更新，然后因为这个30个限制每次都会报错 |
我请教了sqlpub，然后按照建议在数据库地址后增加了 ?connection_limit=5&socket_timeout=3，现在不在有连接超过30个的报错了，新的报错如下: [Nest] 70 - 07/17/2024, 6:08:40 AM LOG [TrpcService] error: [Nest] 70 - 07/17/2024, 6:08:50 AM ERROR [TrpcService] retry(1) getMpArticles error: [Nest] 70 - 07/17/2024, 6:09:20 AM LOG [TrpcService] error: [Nest] 70 - 07/17/2024, 6:09:40 AM LOG [TrpcService] error: |
|
我之前看sqlpub首页，里面就写着「您将获得最大36000次/小时的请求、同时30个连接和500M存储空间；严禁用于非法用途 （传播暴力、淫秽色情信息等），发现永久禁用」。所以认为30个是sqlpub的限制。
这个新的报错，你尝试一下删除账号后重新登录。
… 2024年7月17日 14:15，kobolibra ***@***.***> 写道：
我觉得这个同步问题，跟中转那个没啥关系。
之前没有同步成功，应该是账号问题（我尝试了我的， 同步了一个公众号的文章
后面这个报错，30个连接的问题，这个是sqlpub的限制导致。可以尝试使用其他的平台或者存储方式
我请教了sqlpub，然后按照建议在数据库地址后增加了 ?connection_limit=5&socket_timeout=3，现在不在有连接超过30个的报错了，新的报错如下:
[Nest] 70 - 07/17/2024, 6:08:40 AM LOG [TrpcService] error:
[Nest] 70 - 07/17/2024, 6:08:40 AM LOG [TrpcService] AxiosError: Request failed with status code 500
[Nest] 70 - 07/17/2024, 6:08:40 AM ERROR [TrpcService] 账号（2208209）处理请求参数出错
[Nest] 70 - 07/17/2024, 6:08:40 AM ERROR [TrpcService] WeReadError400:
id(2208209): WeReadError400
[Nest] 70 - 07/17/2024, 6:08:50 AM DEBUG [TrpcService] disabledAccounts:
[Nest] 70 - 07/17/2024, 6:08:50 AM DEBUG [TrpcService] Object:
[]
[Nest] 70 - 07/17/2024, 6:08:50 AM ERROR [TrpcService] retry(1) getMpArticles error:
[Nest] 70 - 07/17/2024, 6:08:50 AM ERROR [TrpcService] AxiosError: Request failed with status code 500
[Nest] 70 - 07/17/2024, 6:09:00 AM LOG [TrpcService] error:
[Nest] 70 - 07/17/2024, 6:09:00 AM LOG [TrpcService] AxiosError: Request failed with status code 500
[Nest] 70 - 07/17/2024, 6:09:00 AM ERROR [TrpcService] 账号（2208209）处理请求参数出错
[Nest] 70 - 07/17/2024, 6:09:00 AM ERROR [TrpcService] WeReadError400:
id(2208209): WeReadError400
[Nest] 70 - 07/17/2024, 6:09:10 AM ERROR [TrpcService] retry(2) getMpArticles error:
[Nest] 70 - 07/17/2024, 6:09:10 AM ERROR [TrpcService] AxiosError: Request failed with status code 500
[Nest] 70 - 07/17/2024, 6:09:10 AM DEBUG [TrpcService] disabledAccounts:
[Nest] 70 - 07/17/2024, 6:09:10 AM DEBUG [TrpcService] Object:
[]
[Nest] 70 - 07/17/2024, 6:09:20 AM LOG [TrpcService] error:
[Nest] 70 - 07/17/2024, 6:09:20 AM LOG [TrpcService] AxiosError: Request failed with status code 500
[Nest] 70 - 07/17/2024, 6:09:20 AM ERROR [TrpcService] 账号（2208209）处理请求参数出错
[Nest] 70 - 07/17/2024, 6:09:20 AM ERROR [TrpcService] WeReadError400:
id(2208209): WeReadError400
[Nest] 70 - 07/17/2024, 6:09:30 AM ERROR [TrpcService] retry(3) getMpArticles error:
[Nest] 70 - 07/17/2024, 6:09:30 AM ERROR [TrpcService] AxiosError: Request failed with status code 500
[Nest] 70 - 07/17/2024, 6:09:30 AM DEBUG [TrpcService] disabledAccounts:
[Nest] 70 - 07/17/2024, 6:09:30 AM DEBUG [TrpcService] Object:
[]
[Nest] 70 - 07/17/2024, 6:09:40 AM LOG [TrpcService] error:
[Nest] 70 - 07/17/2024, 6:09:40 AM LOG [TrpcService] AxiosError: Request failed with status code 500
[Nest] 70 - 07/17/2024, 6:09:40 AM ERROR [TrpcService] 账号（2208209）处理请求参数出错
[Nest] 70 - 07/17/2024, 6:09:40 AM ERROR [TrpcService] WeReadError400:
id(2208209): WeReadError400
[Nest] 70 - 07/17/2024, 6:09:50 AM ERROR [TrpcService] retry(4) getMpArticles error:
[Nest] 70 - 07/17/2024, 6:09:50 AM ERROR [TrpcService] AxiosError: Request failed with status code 500
—
Reply to this email directly, view it on GitHub <#192 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABBYOIS552IAOEBD3LUN2TLZMYDWJAVCNFSM6AAAAABKHJ7IMKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMZSGUYDSOBXGQ>.
You are receiving this because you commented.
|
确实一直有这个限制，但是奇怪的是我前几个月都没有因为这个报错；今天也按照sqlpub群主的加以在huggingface界面的数据库地址加上了?connection_limit=5&socket_timeout=3，等5点半看看更新情况；目前感觉还是有问题，似乎数据库连接无法合理回收 |
|
重新换了个账号，现在有部分公众号可以更新了，但是每次都无法完全更新所有公众号，即使设置了?connection_limit=5&socket_timeout=30这种，数据库连接仍旧无法合理回收，依然会出现连接数超过30的报错导致不能更新所有公众号 |
|
貌似陆陆续续都更新了，太感谢了，给力 |
|
感谢！ |
问题：自己的账号前几天出问题后就一直无法更新了，手动更新会请求失败（Request failed with status code 500）；但我也知道有人在前几天问题解决后已经能正常更新了
我目前是按照下面链接（https://stupidjoey.net/posts/deploy_wewe_rss/
）的方式进行部署的-使用的是sqlpub.com；另外，用户状态也是启用的没有问题；
尝试：开始以为是sqlpub的问题，但是试了sqlpub可以正常访问；我也尝试用railway代替sqlpub，部署一个新的账号，可以添加微信读书用户；下一步添加微信公众号时虽然也会报错请求失败（Request failed with status code 500）但发现其实还是加上了；但是并没有获取到任何历史文章，手动更新依然请求报错（Request failed with status code 500）
麻烦大神帮忙看一下是什么问题，非常感激
The text was updated successfully, but these errors were encountered: