V2EX = way to explore
V2EX 是一个关于分享和探索的地方
现在注册
已注册用户请  登录
V2EX 提问指南
fl2d
V2EX  ›  问与答

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

  •  
  •   fl2d · 2017-07-21 10:39:23 +08:00 · 6203 次点击
    这是一个创建于 2683 天前的主题,其中的信息可能已经有所发展或是发生改变。
    求助。。我啥也没动。。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 也没找到啥有用的东西。。
    有知道如何解决的朋友么?
    1 条回复    2017-07-21 13:24:36 +08:00
    fl2d
        1
    fl2d  
    OP
       2017-07-21 13:24:36 +08:00
    http://www.fromdual.com/innodb-table-hit-by-page-corruption

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

    观察一下,一会儿是不是还出问题。。。。
    关于   ·   帮助文档   ·   博客   ·   API   ·   FAQ   ·   实用小工具   ·   1647 人在线   最高记录 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 21ms · UTC 16:37 · PVG 00:37 · LAX 08:37 · JFK 11:37
    Developed with CodeLauncher
    ♥ Do have faith in what you're doing.