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
demandé il y a 5 ans218 vues
2 réponses
0
Réponse acceptée

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

cmyers
répondu il y a 5 ans
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
répondu il y a 5 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions