Skip to content

Prevent frontend request pending #10992

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
88250 opened this issue Apr 12, 2024 · 4 comments
Closed

Prevent frontend request pending #10992

88250 opened this issue Apr 12, 2024 · 4 comments
Assignees
@88250
Labels
Enhancement
Milestone
3.0.10

Comments

@88250
Copy link
Member

88250 commented Apr 12, 2024 •
edited
Loading

image
@88250 88250 added the Refactor label Apr 12, 2024
@88250 88250 added this to the backlog milestone Apr 12, 2024
@88250 88250 self-assigned this Apr 12, 2024
@88250 88250 changed the title Caching SQLite table refs in memory Create in-memory SQLite table refs Apr 12, 2024
@88250 88250 removed the Refactor label Apr 12, 2024
@88250
Copy link
Member Author

88250 commented Apr 12, 2024

确认了下，SQLite WAL 模式下写入时不会阻塞查询，所以重构内存表意义不大。

目前需要确认的问题是某些情况下请求会被 pending，导致用户编辑时看上去正常，实际上数据并未写入从而导致数据丢失。

@88250 88250 changed the title Create in-memory SQLite table refs Troubleshooting request pending issues Apr 12, 2024
@88250 88250 mentioned this issue Apr 12, 2024
Closed
@88250 88250 changed the title Troubleshooting request pending issues Prevent request pending Apr 12, 2024
@88250 88250 changed the title Prevent request pending Prevent frontend request pending Apr 12, 2024
88250 added a commit that referenced this issue Apr 12, 2024
@88250
🎨 Prevent frontend request pending #10992
ee47328
@88250 88250 closed this as completed Apr 12, 2024
@88250
Copy link
Member Author

88250 commented Apr 12, 2024

已经确认并修复，是因为 sql queue 中的锁使用不当造成了死锁。

@TCOTC
Copy link
Contributor

TCOTC commented Apr 15, 2024

@88250 这个 issue 的 Milestones 应该要改一下

@88250 88250 modified the milestones: backlog, 3.0.10 Apr 15, 2024
@88250
Copy link
Member Author

88250 commented Apr 15, 2024

多谢提醒。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@88250 88250

Labels
Enhancement
Projects
None yet
Milestone
3.0.10
Development

No branches or pull requests
2 participants
@88250 @TCOTC