Maria数据库未启动,mariadb.service的作业失败,有关详细信息，请参阅“systemctl status mariadb.service”和“journalctl -xn”

fzwojiic 于 2022-11-08 发布在其他

关注(0)|答案(4)|浏览(360)

我正在尝试安装maria db，但遇到以下问题。

[root@localhost ~]# service mysqld start
Redirecting to /bin/systemctl start  mysqld.service
Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details.

我尝试了“systemctl status mariadb.service”和“journalctl -xn”，并遵循了详细信息。

[root@localhost ~]# systemctl status mariadb.service
mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
   Active: failed (Result: exit-code) since Sun 2014-09-21 17:19:44 IST; 23s ago
  Process: 2712 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)
  Process: 2711 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
  Process: 2683 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 2711 (code=exited, status=0/SUCCESS)

Sep 21 17:19:42 localhost.localdomain mysqld_safe[2711]: 140921 17:19:42 mysqld_safe Logging to '/var/lib/mysql/localhost.localdomain.err'.
Sep 21 17:19:42 localhost.localdomain mysqld_safe[2711]: 140921 17:19:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Sep 21 17:19:43 localhost.localdomain mysqld_safe[2711]: 140921 17:19:43 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdoma...d ended
Sep 21 17:19:44 localhost.localdomain systemd[1]: mariadb.service: control process exited, code=exited status=1
Sep 21 17:19:44 localhost.localdomain systemd[1]: Failed to start MariaDB database server.
Sep 21 17:19:44 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.

[root@localhost ~]# journalctl -xn
-- Logs begin at Sun 2014-09-21 02:33:29 IST, end at Sun 2014-09-21 17:20:11 IST. --
Sep 21 17:16:26 localhost.localdomain systemd[1]: Started dnf makecache.
-- Subject: Unit dnf-makecache.service has finished start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit dnf-makecache.service has finished starting up.
-- 
-- The start-up result is done.
Sep 21 17:18:11 localhost.localdomain NetworkManager[683]: <warn> nl_recvmsgs() error: (-33) Dump inconsistency detected, interrupted
Sep 21 17:19:42 localhost.localdomain systemd[1]: Starting MariaDB database server...
-- Subject: Unit mariadb.service has begun with start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mariadb.service has begun starting up.
Sep 21 17:19:42 localhost.localdomain mysqld_safe[2711]: 140921 17:19:42 mysqld_safe Logging to '/var/lib/mysql/localhost.localdomain.err'.
Sep 21 17:19:42 localhost.localdomain mysqld_safe[2711]: 140921 17:19:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Sep 21 17:19:43 localhost.localdomain mysqld_safe[2711]: 140921 17:19:43 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid end
Sep 21 17:19:44 localhost.localdomain systemd[1]: mariadb.service: control process exited, code=exited status=1
Sep 21 17:19:44 localhost.localdomain systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mariadb.service has failed.
-- 
-- The result is failed.
Sep 21 17:19:44 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
Sep 21 17:20:11 localhost.localdomain NetworkManager[683]: <warn> nl_recvmsgs() error: (-33) Dump inconsistency detected, interrupted

有人能帮忙吗？
我已经尝试卸载和安装了很多次，但收到了同样的错误。
先谢谢你。

mariadb

来源：https://stackoverflow.com/questions/25958993/maria-db-not-starting-job-for-mariadb-service-failed-see-systemctl-status-mar

4条答案

按热度按时间

omqzjyyz1#

大多数情况下，如果系统日志（journalctl）没有显示问题所在，MariaDB错误日志（位于/var/lib/mysql/localhost.localdomain.err）会显示。查看该文件，您通常会发现问题所在。
重新安装后未消失的最常见错误表示数据目录（默认为/var/lib/mysql/）已损坏，需要使用mysql_install_db重新安装数据库。要确保执行干净安装，请删除位于数据目录中的所有文件，然后运行sudo mysql_install_db --user=mysql。

赞(0）回复(0）举报 2022-11-08

kmynzznz2#

我解决如下：
安装后

Run: > mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/

Then: > mysql_secure_installation

And then: systemctl start mariadb

有了这个这个，我就可以解决了。

赞(0）回复(0）举报 2022-11-08

c0vxltue3#

一个快速更新，为任何人来到这里通过网络搜索。
在Debian 9 -〉Debian 10（Buster）就地服务器升级后，我收到了一条“无法启动”的消息，经过一番挖掘，我发现/etc/mysql/my.cnf中的以下行需要更新：
发件人：

[mysqld]
: (other stuff)
:
innodb_large_prefix

收件人：

[mysqld]
: (other stuff)
:
innodb_large_prefix = "ON"

线索是/var/log/mysql/error. log中的以下几行

2020-06-06 16:41:24 0 [ERROR] /usr/sbin/mysqld: option '--innodb-large-prefix' requires an argument
2020-06-06 16:41:24 0 [ERROR] Parsing options for plugin 'InnoDB' failed.

赞(0）回复(0）举报 2022-11-08

yrdbyhpb4#

不知道你的情况下，但你可以检查如果mariadb/mysql客户端被意外删除，因为在我的情况下，我已经删除了共享文件的mariadb客户端repo，所以重新安装客户端，

sudo apt-get install libmariadb-dev

注：但在安装客户端之前，请做一件事，对于Rails应用程序，只需更改gemfile中的mysql版本，并尝试安装为bundle install mysql2，如果其mariadb客户端问题，则会抛出错误，提示需要安装mariadb客户端或mysql 2客户端，

sudo apt-get install libmariadb-dev

或

sudo apt-get install libmysqlclient-dev

如果不是mariadb客户问题，请参考其他答案😊😜

赞(0）回复(0）举报 2022-11-08

我来回答

Maria数据库未启动,mariadb.service的作业失败,有关详细信息，请参阅“systemctl status mariadb.service”和“journalctl -xn”

4条答案

相关问题

热门标签

最新问答