Re: The user specified as a definer does not exist
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!
Subject
Views
Written By
Posted
10710
March 07, 2012 02:54PM
Re: The user specified as a definer does not exist
10306
March 07, 2012 05:44PM
4702
March 21, 2012 02:56PM
3112
March 08, 2012 02:23AM
3010
March 08, 2012 05:04PM
2344
March 08, 2012 11:06PM
2449
March 09, 2012 10:58AM
2520
March 09, 2012 12:49PM
2840
March 09, 2012 01:29PM
1946
March 10, 2012 11:20PM
3052
March 14, 2012 12:17PM
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.