mariadb server mysteriously seems to be crashing

You are viewing an old version of this question. View the current version here.

hello - the last couple of days my server seems to have mysteriously stopped. simply doing:

systemctl stop mariadb.service ; systemctl staart mariadb.service ;

seems to temporarily fix it. i am tempted to have something like this run in a cron job every hour just to be safe.

Server version: 10.2.27-MariaDB MariaDB Server

# systemctl  status  mariadb.service  ;  
● mariadb.service - MariaDB 10.2.27 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
   Active: failed (Result: timeout) since Sun 2019-10-06 15:28:21 EDT; 2h 27min ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 20375 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 20343 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=KILL)
  Process: 14181 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemct                                              l set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=killed, signal=TERM)
  Process: 14154 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 20343 (code=killed, signal=KILL)
   CGroup: /system.slice/mariadb.service
 

EDIT:

here is what i am seeing now:

# systemctl  status  -l  mariadb.service  ;   ## restart mariadb
● mariadb.service - MariaDB 10.2.27 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
   Active: activating (start) since Sun 2019-10-06 18:31:14 EDT; 43s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 10240 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 13399 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 13320 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 13455 (mysqld)
   CGroup: /system.slice/mariadb.service
           └─13455 /usr/sbin/mysqld

Oct 06 18:31:37 edwardsmark.info mysqld[13455]: 2019-10-06 18:31:32 140379062454464 [Note] InnoDB: Using Linux native AIO
Oct 06 18:31:37 edwardsmark.info mysqld[13455]: 2019-10-06 18:31:32 140379062454464 [Note] InnoDB: Number of pools: 1
Oct 06 18:31:37 edwardsmark.info mysqld[13455]: 2019-10-06 18:31:32 140379062454464 [Note] InnoDB: Using SSE2 crc32 instructions
Oct 06 18:31:37 edwardsmark.info mysqld[13455]: 2019-10-06 18:31:32 140379062454464 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
Oct 06 18:31:37 edwardsmark.info mysqld[13455]: 2019-10-06 18:31:32 140379062454464 [Note] InnoDB: Completed initialization of buffer pool
Oct 06 18:31:37 edwardsmark.info mysqld[13455]: 2019-10-06 18:31:32 140378200946432 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
Oct 06 18:31:37 edwardsmark.info mysqld[13455]: 2019-10-06 18:31:34 140379062454464 [Note] InnoDB: Highest supported file format is Barracuda.
Oct 06 18:31:37 edwardsmark.info mysqld[13455]: 2019-10-06 18:31:35 140379062454464 [Note] InnoDB: Starting crash recovery from checkpoint LSN=38062514322
Oct 06 18:31:13 edwardsmark.info systemd[1]: Stopped MariaDB 10.2.27 database server.
Oct 06 18:31:14 edwardsmark.info systemd[1]: Starting MariaDB 10.2.27 database server...

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.