Cross-Region Replicas - can't replicate views or procedures

0

When I create a procedure on my master cluster in eu-west-1, my cross-region replica in eu-central-1 will start spewing errors to "error/mysql-error-running.log" like this:

[ERROR] Slave SQL: Error 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation' on query. Default database: 'mydatabasename'. Query: 'CREATE DEFINER=`myusername`@`%` PROCEDURE `MyProcedureName`... (sql here)
2019-05-09 02:29:10 8118 [Warning] Slave: Access denied; you need (at least one of) the SUPER privilege(s) for this operation Error_code: 1227
2019-05-09 02:29:10 8118 [Warning] Slave: Access denied; you need (at least one of) the SUPER privilege(s) for this operation Error_code: 1227
2019-05-09 02:29:10 8118 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin-changelog.000016' position 24293051

Is there a way I can avoid this or just not replicate VIEWS or PROCEDURES to the cross-region replica?

When this happens my Cross-region replica breaks and stops replicating. I can call CALL mysql.rds_skip_repl_error; which sometimes gets me past it, but not always.

Note that this ONLY happens on cross-region replicas. Read replicas in the same cluster in my primary region (eu-west-1) do not have this problem at all.

Edited by: dtchadmyers on May 9, 2019 8:34 AM

cmyers
asked 5 years ago205 views
2 Answers
0
Accepted Answer

Aurora 1.19.1 fixed the issue. Thanks AWS Support and Aurora Team!

cmyers
answered 5 years ago
0

AWS Support confirmed this is a known issue with Aurora mysql 1.x platform cross-region replicas. The workaround is to call mysql.rds_skip_repl_error; on the replica after making view/procedure/function changes on the master until the replica is un-stuck and then make those view/procedure/function changes on the replica manually

cmyers
answered 5 years 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