RDS MySQL instance unexpected shutdown

Question

My MySQL RDS instance has restarted unexpectedly several times in the last few days.

This is an excerpt of the log:

2023-07-25T21:23:33.526018Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user . Shutting down mysqld (Version: 8.0.28).
2023-07-25T21:23:37.069563Z 0 [Warning] [MY-010909] [Server] /rdsdbbin/mysql/bin/mysqld: Forcing close of thread 13954 user: 'm***'.
2023-07-25T21:23:37.109788Z 0 [Warning] [MY-010909] [Server] /rdsdbbin/mysql/bin/mysqld: Forcing close of thread 11 user: 'rdsadmin'.
2023-07-25T21:23:37.109881Z 0 [Warning] [MY-010909] [Server] /rdsdbbin/mysql/bin/mysqld: Forcing close of thread 13956 user: 'm***'.
2023-07-25T21:23:37.109910Z 0 [Warning] [MY-010909] [Server] /rdsdbbin/mysql/bin/mysqld: Forcing close of thread 13957 user: 'm***'.
2023-07-25T21:23:43.993075Z 0 [System] [MY-010910] [Server] /rdsdbbin/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.28) Source distribution.
2023-07-25T21:26:22.004027Z 0 [Warning] [MY-011068] [Server] The syntax 'log_slv_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead.
[...]
2023-07-25T21:26:22.007138Z 0 [System] [MY-010116] [Server] /rdsdbbin/mysql/bin/mysqld (mysqld 8.0.28) starting as process 768
2023-07-25T21:26:22.089045Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-07-25T21:26:22.098517Z 1 [Warning] [MY-012191] [InnoDB] Scan path '/rdsdbdata/db/innodb' is ignored because it is a sub-directory of '/rdsdbdata/db/
2023-07-25T21:26:22.997537Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-07-25T21:26:23.443201Z 0 [Warning] [MY-013414] [Server] Server SSL certificate doesn't verify: unable to get issuer certificate
2023-07-25T21:26:23.443376Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-07-25T21:26:23.518685Z 0 [System] [MY-010931] [Server] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '8.0.28' socket: '/tmp/mysql.sock' port: 3306 Source distribution.
2023-07-25T21:31:55.426074Z 12 [Warning] [MY-010055] [Server] IP address '172.31.11.91' could not be resolved: Name or service not known

How can I troubleshoot this?

Thanks!

Didier_Durand · Answer

Hi, your issue probably comes from message *"Server SSL certificate doesn't verify" *

Look at this article for possible solutions depending on your use case: https://tecadmin.net/mysql-connection-error-certificate-verify-failed/

You seem to have log replications in place from the various messages: then, it's probably the SSL certificate used by the replica connection that has an issue.

Best

Didier

Javiero_Spain · Answer

Hi,
Thanks for your answer.
I don´t have log replications, and I don´t even know what log replications are. This is a DB isntance used to host several Wordpress sites. Could you explain what is the replica connection you refer to?

RDS MySQL instance unexpected shutdown

Relevant content