Skip to content

[Bug] SQLite 写入队列每 ~10 分钟触发一次,153 个账号按 ID 顺序逐一写用量快照。当队列堆积到一定程度(本波第 9 秒),连 SELECT COUNT(*) FROM api_keys 这种最简单的查询都超时 3 秒 → 返回 503 → 客户端看到 "Unable to connect to API (ECONNRESET)"。 #185

@luck-hao

Description

@luck-hao

提交前我已确认

  • 我搜过 已有 issues,没找到一样的问题
  • 我已经把日志/配置里的 Token、API Key、密码等敏感信息打码

我遇到的问题在哪块?

网关 API(/v1/chat/completions、/responses、/messages、Images)

严重程度

阻塞 — 功能完全无法使用

我遇到了什么状况?

2026/05/28 15:31:40 main.go:404: GET /api/admin/settings 200 84.552623ms
2026/05/28 15:31:46 main.go:404: GET /api/admin/keys 200 911.225µs
2026/05/28 15:31:55 main.go:404: GET /api/admin/bootstrap-status 200 22.338µs
2026/05/28 15:31:55 main.go:404: GET /api/admin/keys 200 939.805µs
2026/05/28 15:32:02 main.go:402: POST /v1/messages 200 26.927794839s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:32:19 main.go:404: GET /api/admin/bootstrap-status 200 22.543µs
2026/05/28 15:32:19 main.go:404: GET /api/admin/bootstrap-status 200 30.738µs
2026/05/28 15:32:19 main.go:402: POST /v1/messages 200 16.601517802s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:32:19 main.go:404: GET /api/admin/keys 200 402.942779ms
2026/05/28 15:32:19 main.go:404: GET /api/admin/settings 200 398.941706ms
2026/05/28 15:32:19 main.go:404: GET /api/admin/keys 200 399.396287ms
2026/05/28 15:32:20 main.go:404: GET /api/admin/usage/stats 200 972.22948ms
2026/05/28 15:32:25 main.go:402: POST /v1/messages 200 5.223413563s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:32:30 main.go:404: GET /api/admin/bootstrap-status 200 17.492µs
2026/05/28 15:32:30 main.go:404: GET /api/admin/keys 200 1.319341ms
2026/05/28 15:32:31 main.go:404: GET /api/admin/bootstrap-status 200 24.205µs
2026/05/28 15:32:31 main.go:404: GET /api/admin/keys 200 1.064277ms
2026/05/28 15:32:31 main.go:404: GET /api/admin/keys 200 985.957µs
2026/05/28 15:32:31 main.go:404: GET /api/admin/bootstrap-status 200 30.435µs
2026/05/28 15:32:31 main.go:404: GET /api/admin/keys 200 1.145008ms
2026/05/28 15:32:31 main.go:404: GET /api/admin/bootstrap-status 200 32.065µs
2026/05/28 15:32:31 main.go:404: GET /api/admin/ops/errors/summary 200 5.879489ms
2026/05/28 15:32:31 main.go:404: GET /api/admin/ops/errors 200 12.893543ms
2026/05/28 15:32:31 main.go:404: GET /api/admin/keys 200 8.49027ms
2026/05/28 15:32:34 main.go:402: POST /v1/messages 200 8.95703531s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:32:37 store.go:4132: [账号 176] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:37 store.go:4132: [账号 166] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:37 store.go:4132: [账号 175] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:37 store.go:4132: [账号 168] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:37 store.go:4132: [账号 170] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:37 store.go:4132: [账号 180] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:37 store.go:4132: [账号 186] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:37 store.go:4132: [账号 120] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:38 store.go:4132: [账号 178] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:38 store.go:4132: [账号 174] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:38 store.go:3990: [账号 181] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:38 store.go:3990: [账号 184] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:38 store.go:3990: [账号 172] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:38 store.go:3990: [账号 169] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:39 store.go:3990: [账号 185] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:39 store.go:3990: [账号 170] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:41 store.go:4132: [账号 203] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:41 store.go:3990: [账号 188] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:41 store.go:3990: [账号 187] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:41 store.go:4132: [账号 205] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:41 store.go:4132: [账号 207] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:42 store.go:3990: [账号 199] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:42 store.go:4132: [账号 208] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:42 store.go:3990: [账号 206] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:42 store.go:3990: [账号 204] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:42 store.go:4132: [账号 210] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:42 store.go:4132: [账号 209] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:43 store.go:3990: [账号 189] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:43 store.go:3990: [账号 203] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:43 store.go:3990: [账号 205] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:44 main.go:402: POST /v1/messages 200 8.817180047s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:32:44 store.go:3990: [账号 210] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:44 store.go:4132: [账号 215] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:44 store.go:4132: [账号 216] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:45 store.go:4132: [账号 220] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:45 store.go:4132: [账号 219] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:45 store.go:3990: [账号 218] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:45 store.go:4132: [账号 229] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:46 store.go:4132: [账号 230] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:46 store.go:4132: [账号 232] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:46 store.go:4132: [账号 233] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:46 store.go:4132: [账号 231] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:46 store.go:4132: [账号 234] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:46 store.go:3990: [账号 217] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:46 store.go:4132: [账号 235] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:46 store.go:3990: [账号 215] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:46 store.go:3990: [账号 216] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:47 store.go:3990: [账号 219] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:47 store.go:3990: [账号 220] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:47 store.go:3990: [账号 229] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:47 store.go:4132: [账号 237] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:47 handler.go:369: 查询 API Key 失败: context deadline exceeded
2026/05/28 15:32:47 main.go:404: POST /v1/messages 401 3.000466535s
2026/05/28 15:32:48 store.go:4132: [账号 238] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:48 store.go:3990: [账号 236] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:48 store.go:3990: [账号 231] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:48 store.go:3990: [账号 234] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:49 store.go:4132: [账号 241] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:49 store.go:4132: [账号 242] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:49 store.go:4132: [账号 243] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:49 store.go:4132: [账号 240] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:50 store.go:4132: [账号 246] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:50 store.go:4132: [账号 247] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:50 store.go:4132: [账号 245] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:50 store.go:4132: [账号 249] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:51 store.go:4132: [账号 251] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:52 store.go:3990: [账号 248] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:52 store.go:3990: [账号 250] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:52 store.go:4132: [账号 253] 持久化用量快照失败: context deadline exceeded
2026/05/28 15:32:55 main.go:404: GET /api/admin/bootstrap-status 200 26.958µs
2026/05/28 15:32:55 store.go:3990: [账号 275] 清理账号状态失败: context deadline exceeded
2026/05/28 15:32:55 main.go:404: GET /api/admin/keys 200 145.095846ms
2026/05/28 15:33:02 main.go:402: POST /v1/messages 200 13.842064435s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:33:18 main.go:402: POST /v1/messages 200 11.0317715s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:33:22 main.go:402: POST /v1/responses 200 18.563912941s gpt-5.5 effort=high [Ka****@outlook.com] [no proxy]
2026/05/28 15:33:22 main.go:402: POST /v1/messages 200 14.634283253s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:33:30 main.go:402: POST /v1/messages 200 16.061195286s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:33:30 main.go:404: GET /api/admin/keys 200 1.072958ms
2026/05/28 15:33:30 main.go:404: GET /api/admin/bootstrap-status 200 15.767µs
2026/05/28 15:33:31 main.go:404: GET /api/admin/bootstrap-status 200 43.185µs
2026/05/28 15:33:31 main.go:404: GET /api/admin/ops/errors 200 9.111004ms
2026/05/28 15:33:31 main.go:404: GET /api/admin/ops/errors/summary 200 12.336563ms
2026/05/28 15:33:31 main.go:404: GET /api/admin/keys 200 11.111598ms
2026/05/28 15:33:31 main.go:404: GET /api/admin/keys 200 14.119047ms
2026/05/28 15:33:31 main.go:404: GET /api/admin/bootstrap-status 200 30.193µs
2026/05/28 15:33:31 main.go:404: GET /api/admin/keys 200 1.067287ms
2026/05/28 15:33:31 main.go:404: GET /api/admin/keys 200 775.137µs
2026/05/28 15:33:31 main.go:404: GET /api/admin/bootstrap-status 200 19.431µs
2026/05/28 15:33:33 main.go:402: POST /v1/messages 200 10.351043953s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:33:37 main.go:402: POST /v1/responses 200 13.628562482s gpt-5.5 effort=high [Ka****@outlook.com] [no proxy]
2026/05/28 15:33:39 main.go:404: GET /api/admin/bootstrap-status 200 29.417µs
2026/05/28 15:33:39 main.go:404: GET /api/admin/bootstrap-status 200 23.101µs
2026/05/28 15:33:40 main.go:404: GET /api/admin/settings 200 1.750035ms
2026/05/28 15:33:40 main.go:404: GET /api/admin/keys 200 62.923087ms
2026/05/28 15:33:41 main.go:404: GET /api/admin/usage/stats 200 579.395208ms
2026/05/28 15:33:41 main.go:402: POST /v1/messages 200 22.599789611s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:33:43 main.go:402: POST /v1/messages 200 13.096379947s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:33:47 main.go:402: POST /v1/responses 200 8.731093637s gpt-5.5 effort=high [Ka****@outlook.com] [no proxy]
2026/05/28 15:33:49 main.go:402: POST /v1/messages 200 14.670876502s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:33:54 main.go:402: POST /v1/messages 200 12.163101678s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:33:55 main.go:404: GET /api/admin/bootstrap-status 200 39.874µs
2026/05/28 15:33:55 main.go:404: GET /api/admin/keys 200 1.040917ms
2026/05/28 15:33:56 main.go:402: POST /v1/messages 200 7.25786689s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:34:05 main.go:402: POST /v1/messages 200 8.017170462s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:34:12 main.go:402: POST /v1/messages 200 17.408647999s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:34:13 main.go:402: POST /v1/responses 200 11.400526726s gpt-5.5 effort=high [Ka****@outlook.com] [no proxy]
2026/05/28 15:34:16 main.go:402: POST /v1/messages 200 10.954830947s gpt-5.5 effort=xhigh [Ka****@outlook.com] [no proxy]
2026/05/28 15:34:18 handler_anthropic.go:475: 流异常结束 (account 358, /v1/messages, status 598): 上游流读取失败: context deadline exceeded (Client.Timeout or context cancellation while reading body),已转发约 20174 字符
2026/05/28 15:34:18 main.go:402: POST /v1/messages 200 10m1.105885372s gpt-5.5 effort=high [to****@outlook.com] [no proxy]

我是怎么触发的?(可选)

高频率出现断连的情况, 怀疑是sql排队导致的, 但是总共才200个账号左右, 是不是可以优化下或者协助排查下

Image

我的环境信息(可选,能填就填)

  • 我的部署形态:SQLite+Memory
  • 我的版本或 commit:2.2.4
  • 我用的客户端: Claude Code

我的补充信息(可选)

目前正在尝试切换PostgreSQL + redis 部署看看是否有问题

Metadata

Metadata

Assignees

No one assigned

    Labels

    type/bug缺陷 / 报错 / 异常行为

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions