My MySQL instance in a slave node (set up to sync with a master node via replication) is showing this error when queried via
SHOW SLAVE STATUS\G:
Error 1304: PROCEDURE mydb.SOMEPROC does not exist' on query. Default database: 'mydb'. Query: 'INSERT INTO
someColumn, ...) VALUES ('12376', 'somevalue', ...)
What can cause this error? Replication has been runnning fine for weeks. I don't understand. (When I set up replication, back in the day, I remembered to specify the
--routines flag when executing the mysqldump to transfer the data from the master node to the slave node.)
NB: This database has some triggers that execute when some things are inserted in some tables, which result probably in execution of some stored procedures. However, as far as I understand, triggers should not be executed in the slave node (because if they did, then slave node would suddenly have different data than the master node, right?). And anyway this stored procedure should not be missing, I don't understand.