Skip to main content

mysql restarts itself

ctorres

hello,

I am having a problem with my mysql service, which restarts itself every so often, I have checked the logs and I still do not see the possible cause... the log that I get is as follows:

024-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:41:27.270165Z 0 [Note] [MY-010067] [Server] Giving 7 client threads a chance to die gracefully
2024-04-03T13:41:27.270268Z 0 [Note] [MY-010117] [Server] Shutting down replica threads
2024-04-03T13:41:27.270322Z 0 [Note] [MY-010054] [Server] Event Scheduler: Killing the scheduler thread, thread id 5
2024-04-03T13:41:27.270362Z 0 [Note] [MY-010050] [Server] Event Scheduler: Waiting for the scheduler thread to reply
2024-04-03T13:41:27.270671Z 0 [Note] [MY-010048] [Server] Event Scheduler: Stopped
2024-04-03T13:41:29.270962Z 0 [Note] [MY-010118] [Server] Forcefully disconnecting 2 remaining clients
2024-04-03T13:41:29.271172Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 395  user: 'inmobiliariatere_condominio'.
2024-04-03T13:41:29.271903Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 516  user: 'pagocond_condominio'.
2024-04-03T13:41:29.272845Z 0 [Note] [MY-010043] [Server] Event Scheduler: Purging the queue. 0 events
2024-04-03T13:41:29.281881Z 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2024-04-03T13:41:29.379628Z 0 [Note] [MY-010120] [Server] Binlog end
2024-04-03T13:41:29.558242Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner'
2024-04-03T13:41:29.558379Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram'
2024-04-03T13:41:29.558431Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE'
2024-04-03T13:41:29.558479Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE'
2024-04-03T13:41:29.558503Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable'
2024-04-03T13:41:29.558521Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA'
2024-04-03T13:41:29.558629Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM'
2024-04-03T13:41:29.558666Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
2024-04-03T13:41:29.558700Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES'
2024-04-03T13:41:29.558776Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES'
2024-04-03T13:41:29.558802Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL'
2024-04-03T13:41:29.558820Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS'
2024-04-03T13:41:29.558838Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES'
2024-04-03T13:41:29.558854Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES'
2024-04-03T13:41:29.558871Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS'
2024-04-03T13:41:29.558888Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES'
2024-04-03T13:41:29.558905Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2024-04-03T13:41:29.558922Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2024-04-03T13:41:29.558969Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG'
2024-04-03T13:41:29.558989Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2024-04-03T13:41:29.559006Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED'
2024-04-03T13:41:29.559022Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2024-04-03T13:41:29.559039Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS'
2024-04-03T13:41:29.559071Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2024-04-03T13:41:29.559105Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2024-04-03T13:41:29.559156Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2024-04-03T13:41:29.559176Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE'
2024-04-03T13:41:29.559193Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2024-04-03T13:41:29.559238Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2024-04-03T13:41:29.559295Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET'
2024-04-03T13:41:29.559329Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM'
2024-04-03T13:41:29.559350Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET'
2024-04-03T13:41:29.559367Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP'
2024-04-03T13:41:29.559383Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX'
2024-04-03T13:41:29.559400Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB'
2024-04-03T13:41:29.559606Z 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2024-04-03T13:41:29.560770Z 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2024-04-03T13:41:29.562102Z 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 240403  9:41:29
2024-04-03T13:41:29.684592Z 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2024-04-03T13:41:30.431909Z 0 [Note] [MY-013854] [InnoDB] Bytes written to disk by DBLWR (ON): 90636288
2024-04-03T13:41:30.433342Z 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 790497615506
2024-04-03T13:41:30.436436Z 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2024-04-03T13:41:30.436537Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY'
2024-04-03T13:41:30.436580Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'
2024-04-03T13:41:30.436627Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'daemon_keyring_proxy_plugin'
2024-04-03T13:41:30.436674Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner'
2024-04-03T13:41:30.436704Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password'
2024-04-03T13:41:30.436796Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password'
2024-04-03T13:41:30.436835Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysql_native_password'
2024-04-03T13:41:30.437052Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog'

Comments

7 comments

Date Votes
  • 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
  • ctorres

    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
  • ctorres

    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
  • ctorres

    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.

Didn't find what you were looking for?

New post