Bug #86635 mysqld should log data about shutdowns and signals
Submitted: 9 Jun 2017 9:52 Modified: 16 Apr 2018 16:47
Reporter: Mikhail Izioumtchenko (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Logging Severity:S4 (Feature request)
Version:5.6, 5.7 OS:Any
Assigned to: CPU Architecture:Any

[9 Jun 2017 9:52] Mikhail Izioumtchenko
Description:
There are two parts to this bug:

1. the thread that processes COM_SHUTDOWN logs something to general log and nothing to mysqld log file. It should log there as much information about the client issuing the shutdown as it can.

2. the signal processing thread logs nothing. It can't log much either because it uses sigwait(). It should use sigwaitinfo() and log all known data about the signal issuer.

How to repeat:
see code
[9 Jun 2017 11:42] MySQL Verification Team
Also:
 Bug 14601686 : MYSQLD SHOULD LOG WHICH USER INITIATED SERVER SHUTDOWN
[16 Apr 2018 16:47] Paul DuBois
Posted by developer:
 
Fixed in 8.0.12.

When a client shuts down the server, the server now writes a message
to the error log indicating which user performed this action.