Mám problém s mým MariaDB 10.5.9, který se restartuje každých 5 minut každý den po půlnoci mezi 0:00 a 50:00. Před a po běží OK. Obecně není sql log nic zvláštního a žádný problém. Všechny prostředky serveru jsou v pořádku a s dostatecnou kapacitou. Z logu databáze vidím časy restartů:
2021-04-29 0:00:01 0 /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
2021-04-29 0:05:02 0 /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
2021-04-29 0:10:01 0 /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
2021-04-29 0:15:01 0 /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
2021-04-29 0:20:01 0 /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
2021-04-29 0:25:01 0 /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
2021-04-29 0:30:01 0 /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
2021-04-29 0:35:01 0 /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
2021-04-29 0:40:01 0 /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
2021-04-29 0:45:01 0 /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
2021-04-29 0:50:01 0 /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
V protokolu cron je pouze:
Apr 29 00:00:01 server1 CROND: (root) CMD (/usr/lib64/sa/sa1 1 1)
Apr 29 00:00:01 server1 CROND: (root) CMD (/usr/local/sim/sim -q > /dev/null 2>&1)
ale po> 01:00 v cronu vidím:
Apr 29 00:55:01 server1 CROND: (mailman) CMD (/usr/lib/mailman/cron/gate_news)
Apr 29 00:55:01 server1 CROND: (root) CMD (/usr/local/sim/sim -q > /dev/null 2>&1)
a databázový server běží normálně.
Takže moje otázka zní, co by mělo restartovat můj server, když tam není žádný jiný cron? Jak zaznamenat, co databázy restartuje, protože v protokolu vidím pouze (initiated by: unknown)?
log messages:
Apr 29 00:00:01 server1 systemd: Started Session 514904 of user root.
Apr 29 00:00:01 server1 systemd: Started Session 514906 of user root.
Apr 29 00:00:01 server1 systemd: Created slice User Slice of mailman.
Apr 29 00:00:01 server1 systemd: Started Session 514908 of user mailman.
Apr 29 00:00:01 server1 systemd: Removed slice User Slice of mailman.
Apr 29 00:00:01 server1 systemd: Stopping MariaDB 10.5.9 database server...
Apr 29 00:00:02 server1 systemd: Stopped MariaDB 10.5.9 database server.
Apr 29 00:00:02 server1 systemd: Starting MariaDB 10.5.9 database server...
Apr 29 00:00:02 server1 mariadbd: 2021-04-29 0:00:02 0 /usr/sbin/mariadbd (mysqld 10.5.9-MariaDB-log) starting as process 19514 ...
Apr 29 00:00:02 server1 systemd: Started MariaDB 10.5.9 database server.