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
gefragt vor 5 Jahren218 Aufrufe
2 Antworten
0
Akzeptierte Antwort

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

cmyers
beantwortet vor 5 Jahren
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
beantwortet vor 5 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen