Re: The user specified as a definer does not exist

[Andrew Blake]

I have more information, but it doesn't make anything less mysterious.

Here's the full text of the error as it shows in the slave status:

Last_Error: Error 'The user specified as a definer ('vn12'@'localhost') does not exist' on query. Default database: 'vn12_prod'. Query: 'update match_community_profiles
set maximum_score=refresh_maximum_score(id)'

However, I have run this exact query on both master and slave with no error:

mysql> update match_community_profiles
-> set maximum_score=refresh_maximum_score(id);
Query OK, 0 rows affected (0.33 sec)
Rows matched: 395 Changed: 0 Warnings: 0


Nonetheless, the only way I can get replication not to keep stopping is to put slave-skip-errors='1449'. I don't think this is a very good solution.

I wish I understood what causes this error!