Sample Header Ad - 728x90

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