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.
gefragt vor einem Jahr459 Aufrufe
1 Antwort
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
EXPERTE
beantwortet vor einem Jahr
profile picture
EXPERTE
überprüft vor einem Monat

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen