Question

Received SHUTDOWN from user boot. Shutting down mysqld

Posted May 13, 2021 229 views
MySQL

I received MySQL has gone away notification from my alerting system out of nowhere while there is no serious load on my server. When I checked logs I see there was a shutdown signal sent. How is this possible, can this happen because of some maintenance.

2021-05-13T06:48:09.762481Z 7 [System] [MY-013172] [Server] Received SHUTDOWN from user boot. Shutting down mysqld (Version: 8.0.25-0ubuntu0.20.04.1).

2021-05-13T06:47:35.318280Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.
23-0ubuntu0.20.04.1)

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer

We experience the same thing. It seams to be happening at the same time every day! I think it started last week. We have more servers with similar set. But only one shuts down mysql!

May 17 07:37:47 api systemd[1]: Stopping MySQL Community Server…
May 17 07:37:47 api mysqld[503074]: 2021-05-17T07:37:47.347579Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.25-0ubuntu0.20.04.1).
May 17 07:37:48 api mysqld[503074]: 2021-05-17T07:37:48.379424Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.25-0ubuntu0.20.04.1) (Ubuntu).
May 17 07:37:48 api systemd[1]: mysql.service: Succeeded.
May 17 07:37:48 api systemd[1]: Stopped MySQL Community Server.

  • I only have this problem on one server. This server is different from our other droplets in one way: It was created based on a snapshot from another droplet.