MySQL Forums
Forum List  »  Replication

Re: The user specified as a definer does not exist
Posted by: Andrew Blake
Date: March 07, 2012 05:44PM

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!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: The user specified as a definer does not exist
10306
March 07, 2012 05:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.