[Bug] Login Failed with Error: "database is locked (5) (SQLITE_BUSY)" — Caused by Disk I/O Performance Degradation #9268
Description
Contact Information
No response
1Panel Version
v2 beta
Problem Description
Today I was unable to log in to 1Panel, and the following error was shown:
Internal server error: database is locked (5) (SQLITE_BUSY)
After investigation, I found that this issue was caused by a significant degradation in disk write performance. The average disk write latency was around 60ms, whereas under normal conditions, SSDs typically operate below 10ms and HDDs below 100ms. Although the server remains otherwise functional, the SQLite database used by 1Panel appears to be sensitive to disk I/O delays, leading to frequent database lock contention.
Observed Symptoms:
- Unable to log in to 1Panel
- Error:
database is locked (5) (SQLITE_BUSY) - Increased disk write latency
Suggestion:
It would be helpful if 1Panel could implement better handling of SQLite database locks under high I/O latency scenarios, or provide guidance on switching to a more robust database backend for production environments.
API: /api/v2/core/auth/login
RESPONSE:
code: 500
data: null
message: "服务内部错误: database is locked (5) (SQLITE_BUSY)"
Steps to Reproduce
Just click login and error occur.
The expected correct result
No response
Related log output
Additional Information
No response