Unable to start RDS replication to MariaDB RDS instance from AuroraDB for MySQL instance
0
votes
1
answer
215
views
I am following this guide in order to migrate MariaDB RDS instance into AuroraDB for MySQL.
https://aws.amazon.com/blogs/database/migrate-self-managed-mariadb-to-amazon-aurora-mysql/
Reduce downtime associated with logical exports
In step 6 I ran in AuroraDB instance I got Fatal error during log purge
, I have no idea what is wrong.
I continue to step 8 and I got Replica has encountered an error. Run SHOW REPLICA STATUS; to see the error.
When I run SHOW REPLICA STATUS;
I got:
{
"data":
[
{
"Replica_IO_State": "",
"Source_Host": "my-mariadb.xxxxxx.us-west-2.rds.amazonaws.com",
"Source_User": "repl_user",
"Source_Port": 3306,
"Connect_Retry": 60,
"Source_Log_File": "mysql-bin-changelog.024419",
"Read_Source_Log_Pos": 245991,
"Relay_Log_File": "relaylog.000002",
"Relay_Log_Pos": 1716,
"Relay_Source_Log_File": "",
"Replica_IO_Running": "No",
"Replica_SQL_Running": "No",
"Replicate_Do_DB": "",
"Replicate_Ignore_DB": "",
"Replicate_Do_Table": "",
"Replicate_Ignore_Table": "",
"Replicate_Wild_Do_Table": "",
"Replicate_Wild_Ignore_Table": "mysql.%",
"Last_Errno": 13117,
"Last_Error": "Could not find relay log file.",
"Skip_Counter": 0,
"Exec_Source_Log_Pos": 0,
"Relay_Log_Space": 168667,
"Until_Condition": "None",
"Until_Log_File": "",
"Until_Log_Pos": 0,
"Source_SSL_Allowed": "No",
"Source_SSL_CA_File": "",
"Source_SSL_CA_Path": "",
"Source_SSL_Cert": "",
"Source_SSL_Cipher": "",
"Source_SSL_Key": "",
"Seconds_Behind_Source": null,
"Source_SSL_Verify_Server_Cert": "No",
"Last_IO_Errno": 13114,
"Last_IO_Error": "Got fatal error 1236 from source when reading data from binary log: 'Failed to replace GTID event with backwards-compatible event: corrupt event.; the first event 'mysql-bin-changelog.024419' at 162661, the last event read from 'mysql-bin-changelog.024419' at 245991, the last byte read from 'mysql-bin-changelog.024419' at 246037.'",
"Last_SQL_Errno": 13117,
"Last_SQL_Error": "Could not find relay log file.",
"Replicate_Ignore_Server_Ids": "",
"Source_Server_Id": 1235731222,
"Source_UUID": "",
"Source_Info_File": "mysql.slave_master_info",
"SQL_Delay": 0,
"SQL_Remaining_Delay": null,
"Replica_SQL_Running_State": "",
"Source_Retry_Count": 86400,
"Source_Bind": "",
"Last_IO_Error_Timestamp": "240417 12:41:55",
"Last_SQL_Error_Timestamp": "240417 12:41:55",
"Source_SSL_Crl": "",
"Source_SSL_Crlpath": "",
"Retrieved_Gtid_Set": "",
"Executed_Gtid_Set": "",
"Auto_Position": 0,
"Replicate_Rewrite_DB": "",
"Channel_Name": "",
"Source_TLS_Version": "",
"Source_public_key_path": "",
"Get_Source_public_key": 0,
"Network_Namespace": ""
}
]
}
I have tried to search a few error messages and have no solution at all.
Asked by tom10271
(143 rep)
Apr 17, 2024, 05:25 PM
Last activity: Jun 15, 2025, 04:06 PM
Last activity: Jun 15, 2025, 04:06 PM