1Panel [BUG] 服务内部错误: database is locked

联系方式

[email protected]

1Panel 版本

v1.0.2

问题描述

经常出现提示：服务内部错误: database is locked 可能是因为跟服务器连接速度相关，或者是1Panel采用的内置数据库性能有关比较影响使用体验

重现步骤

不确定

期待的正确结果

No response

相关日志输出

3月 20 15:09:45 stack-server 1panel[193911]: 2023/03/20 15:09:45 github.com/1Panel-dev/1Panel/backend/app/repo/setting.go:47 database is locked
3月 20 15:09:45 stack-server 1panel[193911]: [5005.545ms] [rows:0] SELECT * FROM `settings` WHERE key = "SystemStatus" ORDER BY `settings`.`id` LIMIT 1
3月 20 15:09:45 stack-server 1panel[193911]: [GIN] 2023/03/20 - 15:09:45 | 200 |   5.00565872s |     172.16.4.78 | GET      "/api/v1/auth/demo"
3月 20 15:09:45 stack-server 1panel[193911]: 2023/03/20 15:09:45 github.com/1Panel-dev/1Panel/backend/cron/job/monitor.go:88 SLOW SQL >= 200ms
3月 20 15:09:45 stack-server 1panel[193911]: [7664.904ms] [rows:1] INSERT INTO `monitor_ios` (`created_at`,`updated_at`,`name`,`read`,`write`,`count`,`time`) VALUES ("2023-03-20 15:09:38.02","2023-03-20 15:09:38.02","sda1",0,0,0,0) RETURNING `id`
3月 20 15:09:46 stack-server 1panel[193911]: 2023/03/20 15:09:46 github.com/1Panel-dev/1Panel/backend/cron/job/monitor.go:88 SLOW SQL >= 200ms
3月 20 15:09:46 stack-server 1panel[193911]: [762.951ms] [rows:1] INSERT INTO `monitor_ios` (`created_at`,`updated_at`,`name`,`read`,`write`,`count`,`time`) VALUES ("2023-03-20 15:09:45.685","2023-03-20 15:09:45.685","sda2",0,0,0,0) RETURNING `id`
3月 20 15:09:46 stack-server 1panel[193911]: 2023/03/20 15:09:46 github.com/1Panel-dev/1Panel/backend/cron/job/monitor.go:111 database is locked
3月 20 15:09:46 stack-server 1panel[193911]: [8438.215ms] [rows:0] INSERT INTO `monitor_networks` (`created_at`,`updated_at`,`name`,`up`,`down`) VALUES ("2023-03-20 15:09:41.453","2023-03-20 15:09:41.453","br-302-1",0.000000,0.000000) RETURNING `id`
3月 20 15:09:46 stack-server 1panel[193911]: [2023-03-20 15:09:46] [ERROR] Insert network monitoring data failed, err: database is locked