宝塔用户_pwsdvp 发表于 2025-8-6 09:50:55

【已完成】最近计划任务日志经常报错面板发生错误: 数据..

系统：CentOS 7.6.1810 x86_64(Py3.7.9) Linux面板9.6.0 MySQL 8.0.24
宝塔计划任务日志报错：Traceback (most recent call last):File ＂class/db.py＂, line 569, in save    result = self.__DB_CONN.execute(sql,self.__OPT_PARAM)sqlite3.OperationalError: database is lockedDuring handling of the above exception, another exception occurred:Traceback (most recent call last):File ＂/www/server/panel/script/log_task_analyzer.py＂, line 74, in ＜module＞    public.M(＇crontab＇).where(＇echo=?＇, (echo_value,)).setField(＇result＇, 1)File ＂class/db.py＂, line 381, in setField    return self.save(keyName,(keyValue,))File ＂class/db.py＂, line 578, in save    raise public.PanelError(＂数据库保存出错：＂ + ＂error: ＂ + str(ex))public.PanelError: 面板运行时发生错误: 数据库保存出错：error: database is locked

阿珂 发表于 2025-8-6 14:10:28

检查一下磁盘空间，inode空间是否充足
充足的话，可能面板数据库损坏了，可以尝试下面操作
1，将/www/server/panel/data/db重命名为/www/server/panel/data/db_bak
2，解压/www/backup/panel目录前一天的压缩包
3，将压缩包内的/data/db目录复制粘贴到/www/server/panel/data/
4，重启面板
以上方式仍有报错，则再重复操作，第一步删除复制过来的/www/server/panel/data/db，第二步的压缩包选择更前一天的，依次循环


宝塔用户_pwsdvp 发表于 2025-8-6 16:25:57

阿珂 发表于 2025-8-6 14:10
检查一下磁盘空间，inode空间是否充足
充足的话，可能面板数据库损坏了，可以尝试下面操作
1，将/www/serve ...

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAOcAAABnCAYAAAD7RFX4AAAQ/UlEQVR4Ae1dDY7bOg/87pTjFe8wxZ4je4sCOUTu4A+UNNKQJmUnzaZqlwZeJeuHooYzkpOVX/53uVy2/C8xSA6sx4H/ZVDWC0rGJGMiHAjF+ePzvo3rtn30HfZju42K7f75Y+y8/1031evnAPnjF3e6bj9O2PtWPkywexsO6UPl8iI4hOLM1XssLIlFYvEnOJDi7Dt4EvBPEDDHjHmX4kxxjo8licVSWKQ4k5BLETJ30rGTpjhTnCnORTmQ4lw0MLmDjB3ku2KR4kxx5s65KAdSnIsG5rvuFjnv8cSQ4kxx5s65KAeeFqec9+FVju/pLNAuy32+Os8+yVj2Phr/bLuof5aP1T+xeB4LV5yFxfSPB7BHYK+M+x7Vc1ubJ3cOs+hrx7P3aMcpt/EG4raZf554id0xdqE4AR6TFWWSRuXcxuZVHz6/eOeztj+2Kx3QvdH5XGvvyA813gmfbXtvvCw7JlVi9BqMTotTiOtdCITUST66UFfby+H5+3b9r06iHOz+9VH6ywH5cZhe2vGh+/2kMS78QMp+YGwus/34nvOwl+ke+8TkazE5LU4bCEtg3CPl9ihDevl527YmRmlX31gREcquOUSLumj37PaCD/S2nu85H/kqbbyL22f+awn6nfENxcmk9ACSei7HPdJZneyUdXesj7D3z2vbIet9F2N79O33JEL4J+N4Y3rl3I7z8LUYMvPiOuQzTUG+gwOhODE4kzjKS1vUlYzzD7ep4vwony2r8Ojx1XwWvf7aNitOHsvzk8u4LfLsC7f1ym097kvKvm7az3x/tQo4xGGCXb6/WrF7SJxMXib6rNytk8daJnMJlPfZcv+Yy+NynsdB/qhe2tn/bB/UR+Woz3SPZWLye5j8GXFeaKfEZ076DIqg8hdFIg65UCepvbdlXI+8Tdme7c916Mdlmf898iV+c/xCcQoZcXkgSh2X4x59bCpt0ab0a7tnKeQ/pXC5I1hvTC7jPI+HfJSiH+pxjzQqR32mc6IlPo/jE4oTYEaktOX2Hv05PdOG2x/lj+yhHqm1J+Vycbm9R11UjvpMHydfYjbHzBXnDLTC5vYPt5uRN+rD/Z/Jv2JMa8O7h//P+Jh95gRMfGJ8HhZnghmDmdgkNq/kQIrT+cb2lQCnrRTssxxIcaY41WfuZ4mU/V6/CKU4U5wpzkU5kOJcNDC5E71+J/rbMD0tTvst5t820fQ3yf63cSDFmTtnPtYuyoFT4sTf+ea7pxzJw8XnZOubJr1GvTzNdfpVMXX4mU8K8QkiMcqniyYg8wFsdZDeHMAe75LOd5rQ3uWyse/n7D2Bw2Su5ZU8AK7w4XH0Qf3prtIx4rgOfDBfhSvHieM387sc64Tjm3qtcOrf1Obw86ttMCcO4074RG1fLE4neD9v4+Xp4tBoI5PpjqnD7x/brZOqir4HXmycDnYNDJ/RvRQCYCGoZO22zZnfKJixvSbMB/0LcZC5dhzqe6/D14h0MidgXOfXMZ7EIpprEbr4oOJDY7fym/P2ULF5Ol42FjTGIuILMRL/BAeK1bQtzUe41OND5dLfFSetXYfZ4YQ+zD7KGWRuw/nLhtXeI5+Qt5efDjbGlaBDjA1E2XDbTxeW1Q5iMmLw5zCzZ+ZkwPbtmT7iQ3tjZxc4O/ciDMLGGW9no7cx40r5zF4T4fgpSMF3CErFqI/R4gp8uXyXH7Z2OBni2znJfb+UQKpN1CHmYr/EvVVweV280WPwRPqocez/ocPGpszPYOy0sXPhubvilAZnLjZUJ4UVG8IwqTgH8AjwMun7dfPe3dQ73RAx/Oui3QUbYxNAMv52265mteqgnyLRxF6bk8yjXrQoRP5NcCh+dZ8a0fr9gZjKeBPCcyzgm/jCr/KhXNJSp+PL/v2+ODm2ehy7K8m4XVDePJrf4lNvR3NR/WmBgQC9PiG/G2aIeE3hP3FFxhdfOX5N8P54wc4J0ekB9R3ajNQ4QmCUNmUSRFa5v1+3D1n1msP7AFdyRc5XwgybhSzdTQMQBZGDU/q0BaOsplg8zOraFxU8+nr2pIzJTW0GTlg0WjrFgVf++3b93Ac3tAv/DRncWNhYefclfsB0L9Z97Nr8BAPPB28MlDUce7+GEX5wmeMXjos4wWZPGdNOFv1kJsU7n9Fv8E1h787TaMJpw3NR9qLHWm403B85rh9540gHA4G0j1/SnkGokx87YQNjBxKTW9oEYPXxmx0juip48YH7Wx94LOQn9gyJwtW2+yY2j3DAuPWxKlyolM322EZz7nEqIrOxGGP0dsae3TnLojYoMXI2Xg4hwzHUmBQbgysT+jlxcsyDudsFovvW4q944++Ku/g7WPBcLC7hYy0aDtRHDnU6FTBpZe2TqeQbohtgKGALGKO/1O1Xr9G3jG36aH9GWwVAISeCY8VIhOj+DzuwH9sz/cU/TyDG9gwHjGnFUcoDoYl//rhxLGb2Rt2IT/erzUXNgefnENL2de85TiXfxm5zxiIVz7XGFu14jNLHLiLsM/IyVhC/3XzdeTIfKvaW04pLGLelU3EOOe5zPNmal8H3wSsiM90HYM3hUg/B8GcP6thAKsD24v14e79EXFjtake1ULRgw6SqM2AN22ftnfUvwAG7anHOsdV8Vz6b+bQZb/JFzjwWwROOZ88h9o6swM4l7X7B608QCAR/PFC+778zUPNSYmJc+fOnjp98D4EvupQt9sHioMaJdk7+Ekl/LNE8blFSf2Y8+ZlzkHJ8UcRlNe+Lc9/OC0yW/bM4nRZncsByINw5Rcu2Md/v63mVGisR98n8NyKgiBKXs9MmF465EIozwTsGLzFKjL6SAylOfDbKdPqk9JUkTNv+IpfiTFGmKBflQIpz0cDkbuLvJt8JlxRnijN3zkU5kOJcNDDfaYfIufpPCSnOFGfunItyIMW5aGByN/F3k++ES4ozxZk756IcSHEuGpjvtEPkXP2nhBRnijN3zkU5EIpTn5rns7J8hpZP+o+3GnCkkt+WUKf91Yn+2N638sG89cDYvQ2H9KEuVIvgEIozHzX8R43EJXF5FwdSnIs+0ryLADnOuotNijPFmZ85F+VAinPRwOSOtu6O9q7YpDhTnLlzLsqBFOeigXnX6pzjrLtDpzhTnLlzLsqBFOeigckdbd0d7V2xSXGmOHPnXJQDKc5FA/Ou1TnHWXeHflqcckSPA8v3OL7npdznq/Psk4xl76Pxz7aL+mf5uoT/m2LjirOwmP7xJuQR2Cvjvkf13NbmyZ3DLPra8ew92nHKbbyBuG3mU4RfyYFQnBiUyYoySaNybmPzqg8fLlYH4fX/Kp8PgFt7R36o8U74bNt742VZCvJdHDgtTiGud8FRqZN8dKGutpc3UcZvo5S3Ltr/FVzeXtG/pcJvxOyJgXHhB1L2A2Nzme3H95yHvUz32CcmX4vJaXHaQFgC4x4pt0cZUvsjovV1MhGh7JpDtGJD6qLds9sLvtSx9XzP+chXaeNd3D7zX0vQ74xvKE4mpQeQ1HM57pHO6mSnrLtjfYS9f17bL5TV+y7G9ujb70mE8E/G8cb0yrkd5+FrMWTmxXXIZ5qCfAcHQnFicCZxlJe2qCsZ5x9uU8X5sV3v2BXlMbc9vprPot5P0fNYnp9cxm2RZ1+4rVdu63FfUvaVfy5O/WTdZn4rM18uP8IuXy6vi99D4hRQQXCkICvukaLc7dN+garviIXk3mfL/WMu2+c8j4P8UT37iLztc1SO+kxzN301B/6MOMuPwg4xls+czs/E8RdFIhq5GAB7L3Vc5uVRhpTt2f5cF7XnNplPgb6SA6E4hYy4vAGljstxjz42lbZoU/rx7zfyn1K43BGsNyaXcZ7HQz5K0Q/1uEcalaM+0xTmqzkQihMDRaS05fYe/Tk904bbH+WP7KEeqbUn5XJxub1HXVSO+kxTnK/mgCvO2SCFze0fbjcjb9SH+z+Tf8WY1oZ3D/+f8TH7pGif5cDD4nx2oOyXJE0OPMaBFCf97TTJ8xh5Eq+vxSvFmeJUn7lTcF8ruEfwTXGmOFOci3IgxbloYB5ZYbPtOrvdK2NxWpz2W8xXOpG2/k1yZVx/L64pztw587F2UQ6cEif+zjffPflA9ziadymvgQ0L/TxtAaS+hVJr9ati6vAznxTiE0TSkU8XTUCur6XVkZQP5vD6eJd0vuqF9i6XjX0/Z+8JHMK5si2Dj8FO4RDau2zlFT+EkGNRjmGiQscv7jPDlTm0bZsaa9ZvjTrmxGHcKRZR2xeLk0XZAPt5Gy9PF4dGG5lMd0wdfv/Ybl10NWCdSGLjwaDxGd1LIRSIVIncbZszv9FjWWyvCfNB/0IcZK4dh/m7rZGvyjYLUOE9IbdpN+wZ7KQd+dr9OR0vY499/Rvy0fwPfBcudQ2Ytq44sRaeSXsQThFbhAZxcn6szkMogzBCiF5+OtjoL0GHGMdviAIQsd3FbsQw5gZbks7smTkZsH17po/40F4/2wXOzr0Ih7DZjTchvDdXx572odqrC4bx2+ICX6zPKN+lE18N8bVP+kmFFzP71IaYSxxK3BvBubwu3oP5XCfjjgs8btxw52kwctrYuTBHXHFKgzMXG6qTMg7bADAhCPAy6ft1897d1DvdEDH866K1Y/V7AkjG327b1axWHfRTO97EXpuTzKNetCh0f1jobbFoO47Fodx3n5ow+v1YaPYYiI/t4vbqkdvxzRHnWBirzdsndki5JxsFW7rHfB1Cat4QHsWG+G14RFyRvoJLF4308XbsJsDeDv7Y/u1jFzBUtqlPyO+GGeCuKfwnrogtB4t4vMsWivNIoHuAjSNqYiASBa8B/iGrUSPQIAICVgnpAVzGL8AMm4XMHSUDEAWRASl9WnDLakqB5tV1EKDN07MnZfzSNbXZ49XmOMWhCbJYvW/Xz8cf6cscjEA97CL/akxIiM3fHyAb8P511U8oiL9g4I2Pei9tOPZ+PKYRV/UPfOE04iNjCufp6cOO3f1Dv8E3hZk7T+OD04a5qOxdDsQpjb3LGqn3xpE+KQiTACh10p4eKc0K1h9JpoEVwAKw+vgNVCO6KnjxgfvXtlhF/XlO7BkShatt903IdITDINwskL6vbbWmuY92Z+aKR0bCSAjm2gvi7xBy+DDmti+j2BhcGYfnxEnzUbEgf8RvxU/Utfgr3vi74i7+DhY8F4vBdOeUxt5ljdT7IDiNfB7hFbAFDOx27TPBVJh4xB19fL/MY5AEugNrCUqEiIJmVu6Lsmf6y5xcIiPQNZ3h0OdUxjFzLWV20dvbdp88ztqTdn0OFS/PnszBK/ce5fqcJhgrXNnXNmeMJeT2MY59LX2OuCW+qbnvcVWcdoRXxYmFQLjBm1G197Q4PWGibA+wL04Jmr0AbN81SgNMAqIzvRpBCrC9ypA1DDZWu9pRgdqCDZOq7rftnfWvBa44QThgVy3ljq3mu/aZbWnBHGLn2sPu2RAiUrO9EVNN4vPi1H7LaDyvwaP9dwajzvzpSOHHWGg+8GdcZYt9MDzZLQiuOBk7/bGEsWvIqvmKvqY7JzqxEL2yWu+Lk/tm3hA3FP8/1C4gbXLhOMahOEWEMwD39bzyOav8dyBiznFwRkSJi3bbGaeyTgs2FGcCpYFKPBKPd3MgxZm73djtEoulsEhxJiGXIuS7d6eVx0txpjhTnItyIMW5aGBWXtHTt/d8/k5xpjhz51yUAynORQOTu9N7dqeVcU5xpjhz51yUAynORQOz8oqevr1nV09xpjhz51yUA6E49cFcPo7Hx/T4MPF4NQyntvyDy2cPJ/OhYbH4j/tgDlYzdm+LRfpQF6pFcPg/SJ5a49IizswAAAAASUVORK5CYII= 问题是过了时间，再执行又是正常的显示

宝塔用户_pwsdvp 发表于 2025-8-6 18:17:35

阿珂 发表于 2025-8-6 14:10
检查一下磁盘空间，inode空间是否充足
充足的话，可能面板数据库损坏了，可以尝试下面操作
1，将/www/serve ...

但是过段时间，计划任务再执行 ，日志又显示正常

阿珂 发表于 2025-8-7 15:00:15

那可能是有其他操作，或者其他原因导致sqlite数据库临时被锁了
恢复后，在操作就正常了

宝塔用户_pwsdvp 发表于 2025-8-7 16:07:26

阿珂 发表于 2025-8-7 15:00
那可能是有其他操作，或者其他原因导致sqlite数据库临时被锁了
恢复后，在操作就正常了 ...

好的，了解了
页: [1]
查看完整版本: 【已完成】最近计划任务日志经常报错面板发生错误: 数据..