宝塔官网 IDC推荐 宝塔币商城 邀请大使
█ 菠萝云-免费装宝塔,4G内存68 █ █ 易探云·香港/美国vps仅9元 █ ▅▆▇ 慈云数据-服务器9.9/月 ▇▆▅ 4C4G500M带宽高防69元 【多途云】高防CDN
高防服务器，无视一切流量攻击 A7招租，联系qq394030111 OV/EV SSL证书，可当日签发 【阿里云】宝塔一键部署，5.5折 宝塔一键部署DV,EV,OV,SSL证书
█ 易探云·高防云4核8G仅88元 █ 高防CDN全球节点99元 █香港站群 新年大促█ 免费试用 █ 【阿里云】2核2G，3M，45.1元/年 在线网站测速、批量PING运维工具
当前位置：论坛首页 > Linux面板 > 求助

【待反馈】Mysql启动不了

赵三晓啦发表在 Linux面板2024-12-2 11:33 [复制链接] 9 248

为了能快速了解并处理您的问题，请提供以下基础信息：
面板、插件版本：Linux面板9.2.0

系统版本：Alibaba Cloud Linux 3.2104 LTS 64位

问题描述：服务器无法启动

相关截图（日志、错误）：

使用道具 举报 只看该作者 回复
赵三晓啦
发表于 2024-12-2 11:34:12 | 显示全部楼层
  1. 2024-12-02T03:29:27.045415Z 0 [Note] Binlog end
  2. 2024-12-02T03:29:27.045476Z 0 [Note] Shutting down plugin ＇ngram＇
  3. 2024-12-02T03:29:27.045479Z 0 [Note] Shutting down plugin ＇partition＇
  4. 2024-12-02T03:29:27.045481Z 0 [Note] Shutting down plugin ＇BLACKHOLE＇
  5. 2024-12-02T03:29:27.045482Z 0 [Note] Shutting down plugin ＇ARCHIVE＇
  6. 2024-12-02T03:29:27.045484Z 0 [Note] Shutting down plugin ＇PERFORMANCE_SCHEMA＇
  7. 2024-12-02T03:29:27.045511Z 0 [Note] Shutting down plugin ＇MRG_MYISAM＇
  8. 2024-12-02T03:29:27.045513Z 0 [Note] Shutting down plugin ＇MyISAM＇
  9. 2024-12-02T03:29:27.045525Z 0 [Note] Shutting down plugin ＇INNODB_SYS_VIRTUAL＇
  10. 2024-12-02T03:29:27.045527Z 0 [Note] Shutting down plugin ＇INNODB_SYS_DATAFILES＇
  11. 2024-12-02T03:29:27.045528Z 0 [Note] Shutting down plugin ＇INNODB_SYS_TABLESPACES＇
  12. 2024-12-02T03:29:27.045530Z 0 [Note] Shutting down plugin ＇INNODB_SYS_FOREIGN_COLS＇
  13. 2024-12-02T03:29:27.045532Z 0 [Note] Shutting down plugin ＇INNODB_SYS_FOREIGN＇
  14. 2024-12-02T03:29:27.045533Z 0 [Note] Shutting down plugin ＇INNODB_SYS_FIELDS＇
  15. 2024-12-02T03:29:27.045535Z 0 [Note] Shutting down plugin ＇INNODB_SYS_COLUMNS＇
  16. 2024-12-02T03:29:27.045536Z 0 [Note] Shutting down plugin ＇INNODB_SYS_INDEXES＇
  17. 2024-12-02T03:29:27.045538Z 0 [Note] Shutting down plugin ＇INNODB_SYS_TABLESTATS＇
  18. 2024-12-02T03:29:27.045539Z 0 [Note] Shutting down plugin ＇INNODB_SYS_TABLES＇
  19. 2024-12-02T03:29:27.045541Z 0 [Note] Shutting down plugin ＇INNODB_FT_INDEX_TABLE＇
  20. 2024-12-02T03:29:27.045542Z 0 [Note] Shutting down plugin ＇INNODB_FT_INDEX_CACHE＇
  21. 2024-12-02T03:29:27.045544Z 0 [Note] Shutting down plugin ＇INNODB_FT_CONFIG＇
  22. 2024-12-02T03:29:27.045545Z 0 [Note] Shutting down plugin ＇INNODB_FT_BEING_DELETED＇
  23. 2024-12-02T03:29:27.045547Z 0 [Note] Shutting down plugin ＇INNODB_FT_DELETED＇
  24. 2024-12-02T03:29:27.045548Z 0 [Note] Shutting down plugin ＇INNODB_FT_DEFAULT_STOPWORD＇
  25. 2024-12-02T03:29:27.045550Z 0 [Note] Shutting down plugin ＇INNODB_METRICS＇
  26. 2024-12-02T03:29:27.045551Z 0 [Note] Shutting down plugin ＇INNODB_TEMP_TABLE_INFO＇
  27. 2024-12-02T03:29:27.045553Z 0 [Note] Shutting down plugin ＇INNODB_BUFFER_POOL_STATS＇
  28. 2024-12-02T03:29:27.045554Z 0 [Note] Shutting down plugin ＇INNODB_BUFFER_PAGE_LRU＇
  29. 2024-12-02T03:29:27.045556Z 0 [Note] Shutting down plugin ＇INNODB_BUFFER_PAGE＇
  30. 2024-12-02T03:29:27.045557Z 0 [Note] Shutting down plugin ＇INNODB_CMP_PER_INDEX_RESET＇
  31. 2024-12-02T03:29:27.045575Z 0 [Note] Shutting down plugin ＇INNODB_CMP_PER_INDEX＇
  32. 2024-12-02T03:29:27.045576Z 0 [Note] Shutting down plugin ＇INNODB_CMPMEM_RESET＇
  33. 2024-12-02T03:29:27.045578Z 0 [Note] Shutting down plugin ＇INNODB_CMPMEM＇
  34. 2024-12-02T03:29:27.045579Z 0 [Note] Shutting down plugin ＇INNODB_CMP_RESET＇
  35. 2024-12-02T03:29:27.045581Z 0 [Note] Shutting down plugin ＇INNODB_CMP＇
  36. 2024-12-02T03:29:27.045583Z 0 [Note] Shutting down plugin ＇INNODB_LOCK_WAITS＇
  37. 2024-12-02T03:29:27.045584Z 0 [Note] Shutting down plugin ＇INNODB_LOCKS＇
  38. 2024-12-02T03:29:27.045586Z 0 [Note] Shutting down plugin ＇INNODB_TRX＇
  39. 2024-12-02T03:29:27.045588Z 0 [Note] Shutting down plugin ＇InnoDB＇
  40. 2024-12-02T03:29:27.045662Z 0 [Note] InnoDB: FTS optimize thread exiting.
  41. 2024-12-02T03:29:27.045766Z 0 [Note] InnoDB: Starting shutdown...
  42. 2024-12-02T03:29:27.145940Z 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
  43. 2024-12-02T03:29:27.146107Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 241202 11:29:27
  44. 2024-12-02T03:29:28.695832Z 0 [Note] InnoDB: Shutdown completed; log sequence number 487415371568
  45. 2024-12-02T03:29:28.697400Z 0 [Note] InnoDB: Removed temporary tablespace data file: ＂ibtmp1＂
  46. 2024-12-02T03:29:28.697440Z 0 [Note] Shutting down plugin ＇MEMORY＇
  47. 2024-12-02T03:29:28.697444Z 0 [Note] Shutting down plugin ＇CSV＇
  48. 2024-12-02T03:29:28.697448Z 0 [Note] Shutting down plugin ＇sha256_password＇
  49. 2024-12-02T03:29:28.697450Z 0 [Note] Shutting down plugin ＇mysql_native_password＇
  50. 2024-12-02T03:29:28.697568Z 0 [Note] Shutting down plugin ＇binlog＇
  51. 2024-12-02T03:29:28.698622Z 0 [Note] /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 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2024-12-02T03:29:27.146107Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 241202 11:29:27
2024-12-02T03:29:28.695832Z 0 [Note] InnoDB: Shutdown completed; log sequence number 487415371568
2024-12-02T03:29:28.697400Z 0 [Note] InnoDB: Removed temporary tablespace data file: ＂ibtmp1＂

大概率就是重启服务器造成的 mysql 二进制日志损坏，如果需要我司运维服务，请扫码联系我司运维专属客服李经理 李经理企业微信图.png
使用道具 举报 回复 支持 反对
赵三晓啦
发表于 2024-12-2 11:57:05 | 显示全部楼层
mysql
  1. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  2. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  3. Time                 Id Command    Argument
  4. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  5. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  6. Time                 Id Command    Argument
  7. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  8. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  9. Time                 Id Command    Argument
  10. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  11. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  12. Time                 Id Command    Argument
  13. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  14. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  15. Time                 Id Command    Argument
  16. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  17. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  18. Time                 Id Command    Argument
  19. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  20. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  21. Time                 Id Command    Argument
  22. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  23. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  24. Time                 Id Command    Argument
  25. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  26. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  27. Time                 Id Command    Argument
  28. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  29. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  30. Time                 Id Command    Argument
  31. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  32. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  33. Time                 Id Command    Argument
  34. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  35. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  36. Time                 Id Command    Argument
  37. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  38. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  39. Time                 Id Command    Argument
  40. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  41. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  42. Time                 Id Command    Argument
  43. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  44. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  45. Time                 Id Command    Argument
  46. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  47. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  48. Time                 Id Command    Argument
  49. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  50. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  51. Time                 Id Command    Argument
  52. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  53. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  54. Time                 Id Command    Argument
  55. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  56. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  57. Time                 Id Command    Argument
  58. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  59. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  60. Time                 Id Command    Argument
  61. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  62. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  63. Time                 Id Command    Argument
  64. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  65. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  66. Time                 Id Command    Argument
  67. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  68. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  69. Time                 Id Command    Argument
  70. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  71. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  72. Time                 Id Command    Argument
  73. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  74. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  75. Time                 Id Command    Argument
  76. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  77. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  78. Time                 Id Command    Argument
  79. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  80. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  81. Time                 Id Command    Argument
  82. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  83. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  84. Time                 Id Command    Argument
  85. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  86. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  87. Time                 Id Command    Argument
  88. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  89. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  90. Time                 Id Command    Argument
  91. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  92. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  93. Time                 Id Command    Argument
  94. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  95. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  96. Time                 Id Command    Argument
  97. /www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
  98. Tcp port: 3306  Unix socket: /tmp/mysql.sock
  99. Time                 Id Command    Argument
复制代码

慢日志的内容
使用道具 举报 回复 支持 反对
运维技术阿闯
发表于 2024-12-21 11:29:55 | 显示全部楼层
您好，您的问题解决了吗，慢日志我们解决不了的，这个慢日志需要您项目的 开发者解决
使用道具 举报 回复 支持 反对
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

登录 注册
普通问题处理

论坛响应时间：72小时

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

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

紧急运维服务

响应时间：3分钟

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

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

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

立即付费处理

工作时间：09:00至24:00

  • 联系我们
  • 周一至周六，节假日除外
  • 9:15~12:30，14:00~18:15
  • 联系电话：0769-23030556
  • 如有问题，论坛发帖咨询
  • 商务合作QQ/WX：394030111

《开源许可协议》 | 《用户协议》 | 《隐私声明》 |

高新技术企业编号GR201944000059|粤B2-20201398|粤ICP备17030143号|粤公网安备44190002003211号

Copyright © 2021 宝塔面板|让运维简单高效(www.bt.cn) 广东堡塔安全技术有限公司     Powered by Discuz! X3.4Rights Reserved

违法网站请勿向我司工作人员发起任何形式的人工服务请求，严禁使用宝塔面板从事任何非法活动 | 违规信息举报入口 | 中国互联网举报中心

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