论坛 › Linux面板 › 【待反馈】Mysql启动不了

赵三晓啦 发表于 2024-12-2 11:33:17

【待反馈】Mysql启动不了

为了能快速了解并处理您的问题，请提供以下基础信息：面板、插件版本：Linux面板9.2.0
系统版本：Alibaba Cloud Linux 3.2104 LTS 64位
问题描述：服务器无法启动
相关截图（日志、错误）：

赵三晓啦 发表于 2024-12-2 11:34:12

2024-12-02T03:29:27.045415Z 0 Binlog end
2024-12-02T03:29:27.045476Z 0 Shutting down plugin ＇ngram＇
2024-12-02T03:29:27.045479Z 0 Shutting down plugin ＇partition＇
2024-12-02T03:29:27.045481Z 0 Shutting down plugin ＇BLACKHOLE＇
2024-12-02T03:29:27.045482Z 0 Shutting down plugin ＇ARCHIVE＇
2024-12-02T03:29:27.045484Z 0 Shutting down plugin ＇PERFORMANCE_SCHEMA＇
2024-12-02T03:29:27.045511Z 0 Shutting down plugin ＇MRG_MYISAM＇
2024-12-02T03:29:27.045513Z 0 Shutting down plugin ＇MyISAM＇
2024-12-02T03:29:27.045525Z 0 Shutting down plugin ＇INNODB_SYS_VIRTUAL＇
2024-12-02T03:29:27.045527Z 0 Shutting down plugin ＇INNODB_SYS_DATAFILES＇
2024-12-02T03:29:27.045528Z 0 Shutting down plugin ＇INNODB_SYS_TABLESPACES＇
2024-12-02T03:29:27.045530Z 0 Shutting down plugin ＇INNODB_SYS_FOREIGN_COLS＇
2024-12-02T03:29:27.045532Z 0 Shutting down plugin ＇INNODB_SYS_FOREIGN＇
2024-12-02T03:29:27.045533Z 0 Shutting down plugin ＇INNODB_SYS_FIELDS＇
2024-12-02T03:29:27.045535Z 0 Shutting down plugin ＇INNODB_SYS_COLUMNS＇
2024-12-02T03:29:27.045536Z 0 Shutting down plugin ＇INNODB_SYS_INDEXES＇
2024-12-02T03:29:27.045538Z 0 Shutting down plugin ＇INNODB_SYS_TABLESTATS＇
2024-12-02T03:29:27.045539Z 0 Shutting down plugin ＇INNODB_SYS_TABLES＇
2024-12-02T03:29:27.045541Z 0 Shutting down plugin ＇INNODB_FT_INDEX_TABLE＇
2024-12-02T03:29:27.045542Z 0 Shutting down plugin ＇INNODB_FT_INDEX_CACHE＇
2024-12-02T03:29:27.045544Z 0 Shutting down plugin ＇INNODB_FT_CONFIG＇
2024-12-02T03:29:27.045545Z 0 Shutting down plugin ＇INNODB_FT_BEING_DELETED＇
2024-12-02T03:29:27.045547Z 0 Shutting down plugin ＇INNODB_FT_DELETED＇
2024-12-02T03:29:27.045548Z 0 Shutting down plugin ＇INNODB_FT_DEFAULT_STOPWORD＇
2024-12-02T03:29:27.045550Z 0 Shutting down plugin ＇INNODB_METRICS＇
2024-12-02T03:29:27.045551Z 0 Shutting down plugin ＇INNODB_TEMP_TABLE_INFO＇
2024-12-02T03:29:27.045553Z 0 Shutting down plugin ＇INNODB_BUFFER_POOL_STATS＇
2024-12-02T03:29:27.045554Z 0 Shutting down plugin ＇INNODB_BUFFER_PAGE_LRU＇
2024-12-02T03:29:27.045556Z 0 Shutting down plugin ＇INNODB_BUFFER_PAGE＇
2024-12-02T03:29:27.045557Z 0 Shutting down plugin ＇INNODB_CMP_PER_INDEX_RESET＇
2024-12-02T03:29:27.045575Z 0 Shutting down plugin ＇INNODB_CMP_PER_INDEX＇
2024-12-02T03:29:27.045576Z 0 Shutting down plugin ＇INNODB_CMPMEM_RESET＇
2024-12-02T03:29:27.045578Z 0 Shutting down plugin ＇INNODB_CMPMEM＇
2024-12-02T03:29:27.045579Z 0 Shutting down plugin ＇INNODB_CMP_RESET＇
2024-12-02T03:29:27.045581Z 0 Shutting down plugin ＇INNODB_CMP＇
2024-12-02T03:29:27.045583Z 0 Shutting down plugin ＇INNODB_LOCK_WAITS＇
2024-12-02T03:29:27.045584Z 0 Shutting down plugin ＇INNODB_LOCKS＇
2024-12-02T03:29:27.045586Z 0 Shutting down plugin ＇INNODB_TRX＇
2024-12-02T03:29:27.045588Z 0 Shutting down plugin ＇InnoDB＇
2024-12-02T03:29:27.045662Z 0 InnoDB: FTS optimize thread exiting.
2024-12-02T03:29:27.045766Z 0 InnoDB: Starting shutdown...
2024-12-02T03:29:27.145940Z 0 InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2024-12-02T03:29:27.146107Z 0 InnoDB: Buffer pool(s) dump completed at 241202 11:29:27
2024-12-02T03:29:28.695832Z 0 InnoDB: Shutdown completed; log sequence number 487415371568
2024-12-02T03:29:28.697400Z 0 InnoDB: Removed temporary tablespace data file: ＂ibtmp1＂
2024-12-02T03:29:28.697440Z 0 Shutting down plugin ＇MEMORY＇
2024-12-02T03:29:28.697444Z 0 Shutting down plugin ＇CSV＇
2024-12-02T03:29:28.697448Z 0 Shutting down plugin ＇sha256_password＇
2024-12-02T03:29:28.697450Z 0 Shutting down plugin ＇mysql_native_password＇
2024-12-02T03:29:28.697568Z 0 Shutting down plugin ＇binlog＇
2024-12-02T03:29:28.698622Z 0 /www/server/mysql/bin/mysqld: Shutdown complete

大炮运维V587 发表于 2024-12-2 11:42:26

您好，您把 MySQL 的错误日志（error）级别的日志发出来

赵三晓啦 发表于 2024-12-2 11:44:11

大炮运维V587 发表于 2024-12-2 11:42
您好，您把 MySQL 的错误日志（error）级别的日志发出来

重启过好几次，一直都是失败

大炮运维V587 发表于 2024-12-2 11:50:57

赵三晓啦 发表于 2024-12-2 11:44
重启过好几次，一直都是失败

期间是不是重启过服务器？

赵三晓啦 发表于 2024-12-2 11:53:34

大炮运维V587 发表于 2024-12-2 11:50
期间是不是重启过服务器？

重启过服务器

赵三晓啦 发表于 2024-12-2 11:55:20

大炮运维V587 发表于 2024-12-2 11:50
期间是不是重启过服务器？

重启过服务器，还根据其他的案列删除ib_log开头的文件

大炮运维V587 发表于 2024-12-2 11:55:31

赵三晓啦 发表于 2024-12-2 11:53
重启过服务器

2024-12-02T03:29:27.145940Z 0 InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2024-12-02T03:29:27.146107Z 0 InnoDB: Buffer pool(s) dump completed at 241202 11:29:27
2024-12-02T03:29:28.695832Z 0 InnoDB: Shutdown completed; log sequence number 487415371568
2024-12-02T03:29:28.697400Z 0 InnoDB: Removed temporary tablespace data file: ＂ibtmp1＂
大概率就是重启服务器造成的 mysql 二进制日志损坏，如果需要我司运维服务，请扫码联系我司运维专属客服李经理

赵三晓啦 发表于 2024-12-2 11:57:05

mysql/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306Unix socket: /tmp/mysql.sock
Time               Id Command    Argument
慢日志的内容

运维技术阿闯 发表于 2024-12-21 11:29:55

您好，您的问题解决了吗，慢日志我们解决不了的，这个慢日志需要您项目的 开发者解决

查看完整版本: 【待反馈】Mysql启动不了