[Bug] Database backup failed

[mengluo04]

Contact Information

No response

1Panel Version

V2.1.13

Problem Description

备份数据库超时失败，sys_log表才5000条数据，添加了--quick和--skip-extended-insert参数依旧不行。
mysql版本是8.4.5，配置都是在应用商安装的时候默认的

Steps to Reproduce

2026/05/22 12:42:44 执行 [cronjob-备份数据库] 任务开始 [START]
2026/05/22 12:50:33 备份 [mysql[mysql] - dream] 失败: handle backup database failed, err: mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table sys_log at row: 4167
2026/05/22 12:50:34 开始第 1 次重试
2026/05/22 12:50:35 备份 [mysql[mysql] - dream] 失败: handle backup database failed, err: mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) when trying to connect
2026/05/22 12:50:36 开始第 2 次重试
2026/05/22 12:50:36 备份 [mysql[mysql] - dream] 失败: handle backup database failed, err: mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) when trying to connect
2026/05/22 12:50:37 开始第 3 次重试
2026/05/22 12:50:37 备份 [mysql[mysql] - dream] 失败: handle backup database failed, err: mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) when trying to connect
2026/05/22 12:50:38 [TASK-END]

The expected correct result

No response

Related log output

Additional Information

No response

[mengluo04]

添加忽略sys_log表的备份之后正常了

[wanghe-fit2cloud]

从日志看，失败点是在 mysqldump 导出 sys_log 表时 MySQL 连接中断，且忽略该表后备份正常，暂时看更像是 MySQL 容器状态或 sys_log 表数据导致的问题。

建议先检查失败时间段的 MySQL 容器日志、是否发生 OOM/重启，并尝试单独导出 sys_log 表确认。