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.
AWS UFFICIALEAggiornata un anno fa