这是一个创建于 2488 天前的主题，其中的信息可能已经有所发展或是发生改变。
求助。。我啥也没动。。mariadb 挂了。。
昨天晚上发现的，重启了一下服务，好了。
今天早晨一看又不行了，mariadb 也启动不了了。
systemctl restart mariadb
Job for mariadb.service failed because a fatal signal was delivered causing the control process to dump core.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: activating (start-pre) since Fri 2017-07-21 10:25:07; 396ms ago
Process: 10166 ExecStart=/usr/bin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=dumped, signal=ABRT)
Process: 10187 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 10166 (code=dumped, signal=ABRT); Control PID: 10189 ((sh))
CGroup: /system.slice/mariadb.service
└─control
└─10189 (sh)
Jul 21 10:25:07 xxx systemd[1]: Starting MariaDB database server...
journalctl -xe
...
Jul 21 10:26:32 xxx systemd-coredump[11177]: Failed to connect to coredump service: No such file or directory
Jul 21 10:26:32 xxx systemd[1]: mariadb.service: Main process exited, code=dumped, status=6/ABRT
Jul 21 10:26:32 xxx 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.
Jul 21 10:26:32 xxx systemd[1]: mariadb.service: Unit entered failed state.
Jul 21 10:26:32 xxx systemd[1]: mariadb.service: Failed with result 'core-dump'.
google 了一下 coredump 也没找到啥有用的东西。。
有知道如何解决的朋友么？
昨天晚上发现的，重启了一下服务，好了。
今天早晨一看又不行了，mariadb 也启动不了了。
systemctl restart mariadb
Job for mariadb.service failed because a fatal signal was delivered causing the control process to dump core.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: activating (start-pre) since Fri 2017-07-21 10:25:07; 396ms ago
Process: 10166 ExecStart=/usr/bin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=dumped, signal=ABRT)
Process: 10187 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 10166 (code=dumped, signal=ABRT); Control PID: 10189 ((sh))
CGroup: /system.slice/mariadb.service
└─control
└─10189 (sh)
Jul 21 10:25:07 xxx systemd[1]: Starting MariaDB database server...
journalctl -xe
...
Jul 21 10:26:32 xxx systemd-coredump[11177]: Failed to connect to coredump service: No such file or directory
Jul 21 10:26:32 xxx systemd[1]: mariadb.service: Main process exited, code=dumped, status=6/ABRT
Jul 21 10:26:32 xxx 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.
Jul 21 10:26:32 xxx systemd[1]: mariadb.service: Unit entered failed state.
Jul 21 10:26:32 xxx systemd[1]: mariadb.service: Failed with result 'core-dump'.
google 了一下 coredump 也没找到啥有用的东西。。
有知道如何解决的朋友么？
 |
1
fl2d OP http://www.fromdual.com/innodb-table-hit-by-page-corruption
按照这里面说的，我把 innodb_force_recovery 改成 1 然后再改回 0，就好了。。。 完全不明白啥意思。。 观察一下，一会儿是不是还出问题。。。。 |
Select Language