Comments - How to identify this mysqld (initiated by: unknown): Normal shutdown

2 years, 10 months ago Daniel Black

This shutdown was instigated by a TERM signal. This is normally done with a killall mysqld or kill $(pidof mysqld).

If you are running under systemd the TErm signal approach is also the default used in a systemctl stop mariadb.service.

 
2 years, 10 months ago Mahfudz Aji

Yes, but the problem is there's no one stopping the service manually, so I believe that it's stopped by something maybe other program, service, etc. But is there any way to know what is 'unknown' mean or refer to?

 
2 years, 10 months ago Daniel Black

The log message, that I'm looking at improving, is designed around putting the username where 'unknown' is when they run SQL - SHUTDOWN.

The signal is the only other shutdown mechanism so its just unknown -> signal. Maybe this could be modified to log the process id and user (from sigwaitinfo).

For another program or service to issue a signal to the MariaDB process it would need to be a root user, or the mysql user, or a user that has capability CAP_KILL.

Currently look at systemctl status mariadb.service. Maybe something in systemd-analyze dump.

 
2 years, 10 months ago Daniel Black

Task MDEV-25840 was written to improve the future log message here, hopefully with some information you'd like. Any feedback or contributions with the task welcome.

 
2 years, 10 months ago Mahfudz Aji

Nice. Thank you so much. I think it will really helping to troubleshooting.

 
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.