Recovery of the DB instance has started - AWS RDS MySQL

0

Hello. I'm having a problem with my instance of RDS MySQL 8.0.28, which is crashing and soon after I see in the logs on the RDS dashboard that a recovery process has been started that takes a few minutes due to the amount of records.

"Recovery of the DB instance has started. Recovery time will vary with the amount of data to be recovered."

Obs.: Drop instancie to recovery in "2023-05-31T18:02"

Logs to server sql:

2023-05-31T17:39:58.221422Z 3101 [Warning] [xxx] [Server] IP address '205.xxx.xx.xx' could not be resolved: Name or service not known
2023-05-31T17:58:32.090622Z 3126 [Warning] [xxx] [Server] IP address '34.xx.x.xxx' has been resolved to the host name 'xxx.x.xx.34.bc.googleusercontent.com', which resembles IPv4-address itself.
2023-05-31T17:58:43.072250Z 3129 [Warning] [xxx] [Server] IP address '35.xxx.xx.xx' has been resolved to the host name 'xx.xx.xxx.35.bc.googleusercontent.com', which resembles IPv4-address itself.
2023-05-31T18:02:39.144952Z 3159 [Warning] [xxx] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-05-31T18:06:36.597450Z 0 [Warning] [xxx] [Server] The syntax 'log_slaveI_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead.

2023-05-31T18:06:36.597473Z 0 [Warning] [xxx] [Server] The syntax '--masteXR-info-repository' is deprecated and will be removed in a future release.
2023-05-31T18:06:36.597488Z 0 [Warning] [xxx] [Server] The syntax '--masteXR-info-repository' is deprecated and will be removed in a future release.
2023-05-31T18:06:36.597573Z 0 [Warning] [xxx] [Server] The syntax '--relay-log-info-file' is deprecated and will be removed in a future release.
2023-05-31T18:06:36.597581Z 0 [Warning] [xxx] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2023-05-31T18:06:36.597622Z 0 [Warning] [xxx] [Server] The syntax 'skip_slavle_start' is deprecated and will be removed in a future release. Please use skip_replica_start instead.
2023-05-31T18:06:36.597632Z 0 [Warning] [xxx] [Server] The syntax 'slavIe_exec_mode' is deprecated and will be removed in a future release. Please use replica_exec_mode instead.
2023-05-31T18:06:36.597642Z 0 [Warning] [xxx] [Server] The syntax 'slavIe_load_tmpdir' is deprecated and will be removed in a future release. Please use replica_load_tmpdir instead.
2023-05-31T18:06:36.598059Z 0 [Warning] [xxx] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-05-31T18:06:36.599210Z 0 [System] [xxx] [Server] /rdsdbbin/mysql/bin/mysqld (mysqld 8.0.28) starting as process 761
2023-05-31T18:06:36.713374Z 1 [System] [xxx] [InnoDB] InnoDB initialization has started.
2023-05-31T18:06:36.729243Z 1 [Warning] [xxx] [InnoDB] Scan path '/rdsdbdata/db/innodb' is ignored because it is a sub-directory of '/rdsdbdata/db/
2023-05-31T18:06:37.428852Z 1 [System] [xxx] [InnoDB] InnoDB initialization has ended.
2023-05-31T18:06:37.762279Z 0 [System] [xxx] [Server] Starting XA crash recovery...
2023-05-31T18:06:37.778152Z 0 [System] [xxx] [Server] XA crash recovery finished.
2023-05-31T18:06:37.877010Z 0 [Warning] [xxx] [Server] Server SSL certificate doesn't verify: unable to get issuer certificate
2023-05-31T18:06:37.877140Z 0 [System] [xxx] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-05-31T18:06:37.923820Z 0 [System] [xxx] [Server] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '8.0.28' socket: '/tmp/mysql.sock' port: 3306 Source distribution.
asked a year ago439 views
1 Answer
0

It seems that you may receive a notification when a failure occurs in the underlying hardware of RDS.
https://www.reddit.com/r/aws/comments/iaumxi/rds_went_into_recovery_itself/

Does this mean that RDS cannot be used even if it is operated in Multi-AZ?

profile picture
EXPERT
answered a year ago
profile picture
EXPERT
reviewed 17 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions