Skip to main content

mysql restarts itself

Comments

7 comments

  • cPRex Jurassic Moderator

    Hey there!  That specific output looks like one normal restart.  Is there anything before that "Received SHUTDOWN" entry in the log that looks helpful?

    1
  • Unnamed User

    before the content you previously supplied appears, the following appears:

    2024-04-03T13:41:20.855155Z 516 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
    0
  • cPRex Jurassic Moderator

    Hmmmm...and there's nothing else that indicates why it shuts down and restarts?  I will say that it's normal for the service to restart every say often - my own machine has restarted about 50 times in 18 months:

    # grep "Received SHUTDOWN" /var/log/mysqld.log | wc -l
    50

    Is yours happening much more frequently than that?

    0
  • Unnamed User

    a few days ago I made some changes in case it was a problem of lack of memory and since about 4 days ago it does not fall.

    2024-02-02T16:04:31.641395Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.36).
    2024-02-05T08:48:48.511924Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.36).
    2024-02-06T04:17:55.500698Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.36).
    2024-02-06T04:21:31.814238Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.36).
    2024-02-23T09:25:12.915618Z 4176049 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.36).
    2024-03-24T01:23:03.821478Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.36).
    2024-03-26T09:03:39.359664Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.36).
    2024-03-26T13:35:18.603362Z 53238 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.36).
    2024-03-28T19:07:03.946167Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.36).
    2024-04-03T13:37:47.510004Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.36).
    2024-04-03T13:41:27.264646Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.36).
    2024-04-03T13:42:15.928395Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.36).
    2024-04-03T16:14:54.287370Z 30773 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.36).
    2024-04-04T08:25:17.746369Z 179278 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.36).
    0
  • cPRex Jurassic Moderator

    I'm glad to hear it's working better at this point!

    0
  • Unnamed User

    Taking into account the logs that I gave you, do you think that it could be a failure with the buffer, that maybe I need hardware for that server?

    0
  • cPRex Jurassic Moderator

    I don't think anything from that specifically indicates a hardware issue.  You could always check /var/log/messages to see if there are any more general, server-wide issues noted there.

    0

Please sign in to leave a comment.