当前位置:论坛首页 > Linux面板 > 求助

【已完成】宝塔数据库启动失败

发表在 Linux面板昨天 14:37 [复制链接] 2 37

为了能快速了解并处理您的问题,请提供以下基础信息:
面板、插件版本:[backcolor=rgba(242, 242, 242, 0.004)]MySQL 8.0.24
系统版本:9.2.0
问题描述:MySQL启动失败
相关截图(日志、错误):
2025-07-15T06:35:19.873172Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2025-07-15T06:35:19.873388Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2025-07-15T06:35:19.873573Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 13174
2025-07-15T06:35:19.897842Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-07-15T06:35:20.141229Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-07-15T06:35:20.305585Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
mysqld: File './mysql-bin.000001' not found (OS errno 2 - No such file or directory)
2025-07-15T06:35:20.373517Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2025-07-15T06:35:20.374224Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2025-07-15T06:35:20.375392Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-07-15T06:35:21.817202Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)  Source distribution.
2025-07-15T06:35:23.939529Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2025-07-15T06:35:23.939671Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2025-07-15T06:35:23.939873Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 13894
2025-07-15T06:35:23.961565Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-07-15T06:35:24.206399Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-07-15T06:35:24.375550Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
mysqld: File './mysql-bin.000001' not found (OS errno 2 - No such file or directory)
2025-07-15T06:35:24.437297Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2025-07-15T06:35:24.437848Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2025-07-15T06:35:24.438669Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-07-15T06:35:25.894908Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)  Source distribution.
2025-07-15T06:35:28.516488Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2025-07-15T06:35:28.516605Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2025-07-15T06:35:28.516779Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 14616
2025-07-15T06:35:28.539977Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-07-15T06:35:28.780511Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-07-15T06:35:28.939205Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
mysqld: File './mysql-bin.000001' not found (OS errno 2 - No such file or directory)
2025-07-15T06:35:29.017102Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2025-07-15T06:35:29.017898Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2025-07-15T06:35:29.019101Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-07-15T06:35:30.459105Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)  Source distribution.
2025-07-15T06:35:33.148904Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2025-07-15T06:35:33.149045Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2025-07-15T06:35:33.149223Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 15340
2025-07-15T06:35:33.177353Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-07-15T06:35:33.413224Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-07-15T06:35:33.567311Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
mysqld: File './mysql-bin.000001' not found (OS errno 2 - No such file or directory)
2025-07-15T06:35:33.626514Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2025-07-15T06:35:33.626871Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2025-07-15T06:35:33.627424Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-07-15T06:35:35.090955Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)  Source distribution.
2025-07-15T06:35:37.722235Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2025-07-15T06:35:37.722358Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2025-07-15T06:35:37.722511Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 16071
2025-07-15T06:35:37.753883Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-07-15T06:35:37.994550Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-07-15T06:35:38.151855Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
mysqld: File './mysql-bin.000001' not found (OS errno 2 - No such file or directory)
2025-07-15T06:35:38.226638Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2025-07-15T06:35:38.227005Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2025-07-15T06:35:38.227564Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-07-15T06:35:39.669517Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)  Source distribution.
2025-07-15T06:35:42.314245Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2025-07-15T06:35:42.314373Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2025-07-15T06:35:42.314517Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 16799
2025-07-15T06:35:42.337613Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-07-15T06:35:42.566956Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-07-15T06:35:42.728860Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
mysqld: File './mysql-bin.000001' not found (OS errno 2 - No such file or directory)
2025-07-15T06:35:42.788715Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2025-07-15T06:35:42.789035Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2025-07-15T06:35:42.789526Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-07-15T06:35:44.249873Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)  Source distribution.
2025-07-15T06:35:46.891039Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2025-07-15T06:35:46.891156Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2025-07-15T06:35:46.891297Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 17523
2025-07-15T06:35:46.914642Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-07-15T06:35:47.143056Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-07-15T06:35:47.302404Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
mysqld: File './mysql-bin.000001' not found (OS errno 2 - No such file or directory)
2025-07-15T06:35:47.365909Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2025-07-15T06:35:47.366382Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2025-07-15T06:35:47.367186Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-07-15T06:35:48.823647Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)  Source distribution.
2025-07-15T06:35:51.566090Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2025-07-15T06:35:51.566218Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2025-07-15T06:35:51.566402Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 18261
2025-07-15T06:35:51.591206Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-07-15T06:35:51.837308Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-07-15T06:35:51.992330Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
mysqld: File './mysql-bin.000001' not found (OS errno 2 - No such file or directory)
2025-07-15T06:35:52.064997Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2025-07-15T06:35:52.065430Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2025-07-15T06:35:52.066075Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-07-15T06:35:53.512038Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)  Source distribution.

使用道具 举报 只看该作者 回复
发表于 昨天 16:39 | 显示全部楼层
二进制日志文件./mysql-bin.000001找不到
在/www/server/data/mysql-bin.index内删除对应的文件,重启mysql
使用道具 举报 回复 支持 反对
发表于 昨天 20:17 | 显示全部楼层
阿珂 发表于 2025-7-15 16:39
二进制日志文件./mysql-bin.000001找不到
在/www/server/data/mysql-bin.index内删除对应的文件,重启mysql ...

好的感谢
使用道具 举报 回复 支持 反对
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

普通问题处理

论坛响应时间:72小时

问题处理方式:排队(仅解答)

工作时间:白班:9:00 - 18:00

紧急运维服务

响应时间:3分钟

问题处理方式:宝塔专家1对1服务

工作时间:工作日:9:00 - 18:30

宝塔专业团队为您解决服务器疑难问题

点击联系技术免费分析

工作时间:09:00至18:30

快速回复 返回顶部 返回列表