maria-discuss team mailing list archive

["Reinis Rozitis" <r@xxxxxxx>]

> > A question for you is why is it important not to have it on the slave?

> Because the slave already has this procedure with a slightly different
> implementation,
> and different owner (definer).

As a workaround to not stop/break the replication you could run the slave 
with
slave-skip-errors = 1304

( 
https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-variables/#slave_skip_errors 
)


I'm just not sure if it is the right one for duplicate procedure.

Should be according to 
https://dev.mysql.com/doc/refman/5.6/en/error-messages-server.html

Error: 1304 SQLSTATE: 42000 (ER_SP_ALREADY_EXISTS)
Message: %s %s already exists

rr