Learn about Centmin Mod LEMP Stack today
Register Now

MariaDB MySQL Keep crashing after OVH Changed MotherBoard.. Twice!

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by Oxide, Aug 5, 2016.

  1. Oxide

    Oxide Active Member

    503
    29
    28
    Mar 19, 2015
    Ratings:
    +54
    Local Time:
    8:07 AM
    OVH Has changed motherboard twice on my server, the second time they also changed CPU Cooler. Now my mysql won't start..

    No idea what to do! :(


    Code:
    OVH Has changed motherboard twice on my server, the second time they also changed CPU Cooler. Now my mysql won't start..
    
    No idea what to do! :(
    
    
    [CODE] systemctl status mariadb.service
    ● mariadb.service - MariaDB database server
       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
      Drop-In: /etc/systemd/system/mariadb.service.d
               └─migrated-from-my.cnf-settings.conf, protecthome.conf
       Active: failed (Result: exit-code) since Fri 2016-08-05 05:20:05 UTC; 5s ago
      Process: 5242 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
      Process: 5112 ExecStartPre=/bin/sh -c VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] &&   systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
      Process: 5110 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Main PID: 5242 (code=exited, status=1/FAILURE)
       Status: "Applying batch of log records for InnoDB: Progress 0"
       CGroup: /system.slice/mariadb.service
    
    Aug 05 05:20:05 example.domain.net mysqld[5242]: sql/handler.cc:513(ha_initialize_handlerton(st_plugin_int*))[0x7f1d39fbb4d4]
    Aug 05 05:20:05 example.domain.net mysqld[5242]: sql/sql_plugin.cc:1408(plugin_initialize)[0x7f1d39e4c4e5]
    Aug 05 05:20:05 example.domain.net mysqld[5242]: sql/sql_plugin.cc:1685(plugin_init(int*, char**, int))[0x7f1d39e4de4a]
    Aug 05 05:20:05 example.domain.net mysqld[5242]: sql/mysqld.cc:5197(init_server_components)[0x7f1d39da63fa]
    Aug 05 05:20:05 example.domain.net mysqld[5242]: sql/mysqld.cc:5777(mysqld_main(int, char**))[0x7f1d39daa513]
    Aug 05 05:20:05 example.domain.net mysqld[5242]: /lib64/libc.so.6(__libc_start_main+0xf5)[0x7f1d3791cb15]
    Aug 05 05:20:05 example.domain.net systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
    Aug 05 05:20:05 example.domain.net systemd[1]: Failed to start MariaDB database server.
    Aug 05 05:20:05 example.domain.net systemd[1]: Unit mariadb.service entered failed state.
    Aug 05 05:20:05 example.domain.net systemd[1]: mariadb.service failed.

    [/CODE]


    [​IMG]
     
  2. eva2000

    eva2000 Administrator Staff Member

    30,131
    6,778
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,128
    Local Time:
    8:07 AM
    Nginx 1.13.x
    MariaDB 5.5
    what version of mariadb mysql server you using ? the last 2 MariaDB 10.1.15 and 10.1.16 updates (centmin mod 123.09beta01 default 10.1 branch) have had issues for some folks if they're using Galera in 10.1.16
    So may need downgrading to MariaDB 10.1.14 if on 10.1.15 or 10.1.16 via instructions outlined here

    edit: i see screenshot says MariaDB 10.1.16, so maybe want to downgrade to MariaDB 10.1.14 ?