ubuntu下mysql无法启动问题& syslog报“multipath add missing path”问题

已于 2022-06-11 21:01:34 修改
阅读量1.3k 收藏
点赞数
分类专栏： ubuntu 文章标签： ubuntu mysql linux
于 2022-06-11 21:00:43 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u010857736/article/details/125238589
版权

文章目录

环境描述

底层环境：esxi虚拟出来的ubuntu20.04.04
mysql版本：mysql Ver 14.14 Distrib 5.7.38, for Linux (x86_64) using EditLine wrapper

问题现象

由于给ubuntu虚拟机设置了快照，导致磁盘空间不足，进而导致ubuntu直接被挂起死机，删除快照并重启ubuntu后，则发现mysql无法启动。使用sudo service mysql status命令后，报错是这样的：

× mysqld.service - MySQL Server
     Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
     Active: failed (Result: exit-code) since Mon 2021-04-19 00:01:33 CST; 533ms ago
       Docs: man:mysqld(8)
             http://dev.mysql.com/doc/refman/en/using-systemd.html
    Process: 14629 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
    Process: 14650 ExecStart=/usr/bin/mysqld $MYSQLD_OPTS (code=exited, status=127)
   Main PID: 14650 (code=exited, status=127)
        CPU: 112ms
​
4月 19 00:01:33 RISE systemd[1]: mysqld.service: Scheduled restart job, restart counter is at 5.
4月 19 00:01:33 RISE systemd[1]: Stopped MySQL Server.
4月 19 00:01:33 RISE systemd[1]: mysqld.service: Start request repeated too quickly.
4月 19 00:01:33 RISE systemd[1]: mysqld.service: Failed with result 'exit-code'.
4月 19 00:01:33 RISE systemd[1]: Failed to start MySQL Server.

排查/var/log/syslog日志文件，发现大量如下报错：

Jun 11 12:27:28 ubuntu multipathd[681]: sda: add missing path
Jun 11 12:27:28 ubuntu multipathd[681]: sda: failed to get udev uid: Invalid argument
Jun 11 12:27:28 ubuntu multipathd[681]: sda: failed to get sysfs uid: Invalid argument
Jun 11 12:27:28 ubuntu multipathd[681]: sda: failed to get sgio uid: No such file or directory
Jun 11 12:27:33 ubuntu multipathd[681]: sda: add missing path
Jun 11 12:27:33 ubuntu multipathd[681]: sda: failed to get udev uid: Invalid argument
Jun 11 12:27:33 ubuntu multipathd[681]: sda: failed to get sysfs uid: Invalid argument
Jun 11 12:27:33 ubuntu multipathd[681]: sda: failed to get sgio uid: No such file or directory
Jun 11 12:27:38 ubuntu multipathd[681]: sda: add missing path
Jun 11 12:27:38 ubuntu multipathd[681]: sda: failed to get udev uid: Invalid argument
Jun 11 12:27:38 ubuntu multipathd[681]: sda: failed to get sysfs uid: Invalid argument
Jun 11 12:27:38 ubuntu multipathd[681]: sda: failed to get sgio uid: No such file or directory
Jun 11 12:27:43 ubuntu multipathd[681]: sda: add missing path
Jun 11 12:27:43 ubuntu multipathd[681]: sda: failed to get udev uid: Invalid argument
Jun 11 12:27:43 ubuntu multipathd[681]: sda: failed to get sysfs uid: Invalid argument
Jun 11 12:27:43 ubuntu multipathd[681]: sda: failed to get sgio uid: No such file or directory
Jun 11 12:27:48 ubuntu multipathd[681]: sda: add missing path
Jun 11 12:27:48 ubuntu multipathd[681]: sda: failed to get udev uid: Invalid argument
Jun 11 12:27:48 ubuntu multipathd[681]: sda: failed to get sysfs uid: Invalid argument
Jun 11 12:27:48 ubuntu multipathd[681]: sda: failed to get sgio uid: No such file or directory
Jun 11 12:27:53 ubuntu multipathd[681]: sda: add missing path
Jun 11 12:27:53 ubuntu multipathd[681]: sda: failed to get udev uid: Invalid argument
Jun 11 12:27:53 ubuntu multipathd[681]: sda: failed to get sysfs uid: Invalid argument
Jun 11 12:27:53 ubuntu multipathd[681]: sda: failed to get sgio uid: No such file or directory

经过百度搜索得知，是multipath 的配置问题，需要排除本地的sda磁盘（此问题有可能是ubuntu是虚拟机导致的，直接在物理机上部署ubuntu从来没遇到过）。

解决multipath多路径配置问题

1.修改/etc/multipath.conf文件

sudo vi /etc/multipath.conf

2.添加以下内容，sda视本地环境做调整

blacklist {
        devnode "sda"
}

3.重启multipath-tools服务

sudo service multipath-tools restart

再次查看/var/log/syslog日志，发现没有报错了，但尝试重启mysql仍然无法启动，排查发现/var/log/syslog提示没有/etc/mysql/my.cnf这个文件，日志截图如下：

Jun 11 12:36:12 ubuntu multipathd[681]: --------shut down-------
Jun 11 12:36:12 ubuntu systemd[1]: Stopping Device-Mapper Multipath Device Controller...
Jun 11 12:36:12 ubuntu systemd[1]: multipathd.service: Succeeded.
Jun 11 12:36:12 ubuntu systemd[1]: Stopped Device-Mapper Multipath Device Controller.
Jun 11 12:36:12 ubuntu systemd[1]: Starting Device-Mapper Multipath Device Controller...
Jun 11 12:36:12 ubuntu multipathd[2463]: --------start up--------
Jun 11 12:36:12 ubuntu multipathd[2463]: read /etc/multipath.conf
Jun 11 12:36:12 ubuntu multipathd[2463]: path checkers start up
Jun 11 12:36:12 ubuntu systemd[1]: Started Device-Mapper Multipath Device Controller.
Jun 11 12:36:38 ubuntu systemd[1]: Starting MySQL Community Server...
Jun 11 12:36:38 ubuntu mysql-systemd-start[2498]: MySQL configuration not found at /etc/mysql/my.cnf. Please create one.
Jun 11 12:36:38 ubuntu systemd[1]: mysql.service: Control process exited, code=exited, status=1/FAILURE
Jun 11 12:36:38 ubuntu systemd[1]: mysql.service: Failed with result 'exit-code'.
Jun 11 12:36:38 ubuntu systemd[1]: Failed to start MySQL Community Server.
Jun 11 12:36:38 ubuntu systemd[1]: mysql.service: Scheduled restart job, restart counter is at 1.
Jun 11 12:36:38 ubuntu systemd[1]: Stopped MySQL Community Server.
Jun 11 12:36:38 ubuntu systemd[1]: Starting MySQL Community Server...

手动创建配置文件

cd /etc
sudo mkdir mysql
cd mysql
sudo touch my.cnf

使用sudo service mysql start 命令重启mysql，发现已经可以正常启动了。

lanyirenjg@ubuntu:/etc/mysql$ sudo service mysql start
lanyirenjg@ubuntu:/etc/mysql$ sudo service mysql status
● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: active (running) since Sat 2022-06-11 12:43:20 UTC; 6s ago
    Process: 2875 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
    Process: 2897 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid (code=exited, status=0/SUCCESS)
   Main PID: 2899 (mysqld)
      Tasks: 27 (limit: 4612)
     Memory: 198.0M
     CGroup: /system.slice/mysql.service
             └─2899 /usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid

Jun 11 12:43:20 ubuntu mysqld[2899]: 2022-06-11T12:43:20.634817Z 0 [Warning] CA certificate ca.pem is self signed.
Jun 11 12:43:20 ubuntu mysqld[2899]: 2022-06-11T12:43:20.634934Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
Jun 11 12:43:20 ubuntu mysqld[2899]: 2022-06-11T12:43:20.636509Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
Jun 11 12:43:20 ubuntu mysqld[2899]: 2022-06-11T12:43:20.636673Z 0 [Note] IPv6 is available.
Jun 11 12:43:20 ubuntu mysqld[2899]: 2022-06-11T12:43:20.636738Z 0 [Note]   - '::' resolves to '::';
Jun 11 12:43:20 ubuntu mysqld[2899]: 2022-06-11T12:43:20.636779Z 0 [Note] Server socket created on IP: '::'.
Jun 11 12:43:20 ubuntu mysqld[2899]: 2022-06-11T12:43:20.669118Z 0 [Note] Event Scheduler: Loaded 0 events
Jun 11 12:43:20 ubuntu mysqld[2899]: 2022-06-11T12:43:20.669508Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Jun 11 12:43:20 ubuntu mysqld[2899]: Version: '5.7.38-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
Jun 11 12:43:20 ubuntu systemd[1]: Started MySQL Community Server.
大奖状
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
ubuntu系统中nginx启动脚本
01-10
Provides: nginx# Required-Start: $remote_fs $syslog# Required-Stop: $remote_fs $syslog# Default-Start: 2 3 4 5# Default-Stop: 0 1 6# Short-Description: nginx init.d dash script for Ubuntu or ...
mysql异常退出定位及解决记录
guotianqing的博客
07-23 5615
现象 运行正常的程序，早上出现了异常。 查看日志报错，是读写数据时失败。这个时候需要检查一下数据库是否正常。 先在终端里用mysql客户端连接一下吧。 mysql -uuser -p 输入密码，果然连接失败。 再查看mysql服务的状态，发现已经挂了： # systemctl status mysqld.service ● mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; ena
Ubuntu 16.04 安装mysql5.7，Failed to start mysqld.service: Unit mysqld.service not found.
hewengbo的博客
07-20 9075
Ubuntu 16.04 安装mysql5.7，Failed to start mysqld.service: Unit mysqld.service not found. 这里写自定义目录标题Ubuntu 16.04 安装mysql5.7，Failed to start mysqld.service: Unit mysqld.service not found.问题解决办法功能快捷键合理的创建标题，有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定
MySQL启动失败报错
最新发布
weixin_74856273的博客
03-01 527
mysql.service: Failed with result 'exit-code'.
mysql启动失败排查
热门推荐
weixin_38052017的博客
05-15 2万+
修改mysql配置文件之后，使用service mysqld restart 重启，发现停止成功但是启动失败了。 Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" f...
MYSQL 启动失败
我的LOG
07-19 3501
异常信息 ● mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: failed (Result: start-limit) since 一 2021-07-19 17:01:31 CST; 3min 0s ago Docs: man:mysqld(8) http:
MySQL启动错误总结
天涯的浪子
10-17 1399
centos7中出现mysql启动失败排查方法
MySQL启动报错的处理方式：/usr/lib/systemd/system/mysqld.service； enabled； vendor preset: disabled
Sukamuljo的博客
09-28 6423
在公司的测试环境中，发现所有数据均不展示，经排查发现为MySQL的问题，重启后报如下错误： [root@mysql-common-01 ~]# systemctl status mysqld.service ● mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: activating (start) sin
Linux-安装mysql出现问题-启动服务器失败
种子不服古怪的博客
10-23 2220
环境 centos7.3 想要安装mysql5.7 启动mysql服务失败 service mysqld restart Redirecting to /bin/systemctl restart mysqld.service Job for mysqld.service failed because the control process exited with error code. S...
Mysql学习
half_cup的博客
08-14 435
1. CentOS 下启动、关闭、重启、查看MySQL服务 1. 启动服务 [root@localhost ~]# service mysqld start Redirecting to /bin/systemctl start mysqld.service 2. 查看服务 [root@localhost ~]# service mysqld status Redirecting to /bin/systemctl status mysqld.service ● mysqld.service -
ubuntu中编写shell脚本开机自动启动(推荐)
01-20
编写脚本是为了不用手动去开启各种服务（也是为了偷懒哈哈） ...# Required-Start: $remote_fs $syslog # Required-Stop: $remote_fs $syslog # Default-Start: 2 3 4 5 # Default-Stop: 0 1 6 # Sh
F5-log&syslog
12-16
F5-log ——syslog 配置文档
syslog4j-0.9.46.jar (解决消息内容发送不完整问题)
09-04
syslog4j-0.9.46.jar ，能够解决消息内容发送不完整问题，maven官网仓库只有0.9.30版本，那个版本会出现发送的消息过长时截断问题
tftp client & tftp server & syslog server
03-04
集三大功能于一体，大小只有0.07M的绿色软件。开发人员不可不用。 tftp client tftp server syslog server
Mysql启动过程错误解决方案
gaojingsong的专栏
04-25 5439
1、下载 mysql5.7 的rpm包 wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm 2.安装rpm包 rpm -ivh mysql57-community-release-el7-9.noarch.rpm 执行完成后会在/etc/yum.repos.d/目录下生成两个repo文件：mysql-community.repo、mysql-community-source.repo ls /etc/yum
记录一下Centos7 安装mysql8遇到的问题
a719953132的博客
10-06 3295
最近想试一下mysql8，所以在阿里云上安装了一下，结果遇到了各种问题 安装完成后，启动 systemctl start mysqld.service; 结果报错，我们查看一下状态 ● mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: failed (Result: exit-c
systemctl status mysqld.service或者systemctl start mysqld 启动失败的解决办法
xuna118的博客
11-26 1万+
报错过程： mysql需要重启，执行一下命令启动mysql： systemctl start mysqld.service 出现一下提示，启动失败： Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details. 根据提示运行命令查看错误： syste.
Centos 安装配置 Mysql5.7
随风随想
06-04 213
系统为centos7，安装的mysql5.7版本 #获取repo [root@slave1 home]# wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm #安装repo [root@slave1 home]# rpm -ivh mysql57-community-release-el7-9.noarch.rpm #安装mysql-server [root@slave1 home]# yum install
Linux 下 MySQL 安装教程
暗诺星刻的博客
09-13 2万+
Linux 下 MySQL 安装教程事先准备下载 MySQL卸载 MySQL安装 MySQL设置 MySQL 开机自启动远程访问 MySQL使用 MySQL Workbench 远程访问 MySQL使用 Navicat Premium 远程访问 MySQL 笔者的运行环境： CentOS Stream 8 x86_64 MySQL 8.0.26 事先准备 进行这个教程之前，必须要先安装好一个 Linux 操作系统。这个 Linux 操作系统可以安装在虚拟机中，也可以安装在真实的电脑中。关
ubuntu下设置syslog文件最大值
07-09
在Ubuntu下，你可以通过以下步骤设置syslog文件的最大大小： 1. 打开`/etc/syslog.conf`文件： ``` sudo nano /etc/syslog.conf ``` 2. 在文件中找到关于syslog文件的行，通常是以`/var/log/syslog`开头的行。 ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值