求助, mariadb 莫名其妙的挂了。。

2017-07-21 10:39:23 +08:00
 fl2d
求助。。我啥也没动。。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 也没找到啥有用的东西。。
有知道如何解决的朋友么?
6153 次点击
所在节点    问与答
1 条回复
fl2d
2017-07-21 13:24:36 +08:00
http://www.fromdual.com/innodb-table-hit-by-page-corruption

按照这里面说的,我把 innodb_force_recovery 改成 1 然后再改回 0,就好了。。。
完全不明白啥意思。。

观察一下,一会儿是不是还出问题。。。。

这是一个专为移动设备优化的页面(即为了让你能够在 Google 搜索结果里秒开这个页面),如果你希望参与 V2EX 社区的讨论,你可以继续到 V2EX 上打开本讨论主题的完整版本。

https://www.v2ex.com/t/376906

V2EX 是创意工作者们的社区,是一个分享自己正在做的有趣事物、交流想法,可以遇见新朋友甚至新机会的地方。

V2EX is a community of developers, designers and creative people.

© 2021 V2EX