RE: slave replication with lots of 'duplicate entry' errors

[Rick James]

Recommend, for security reasons, you rectify that.
If you need some SUPER action, create a stored procedure with privileges 'creator', so the security hole is still mostly contained.

> -----Original Message-----
> From: Robert Citek [mailto:robert.citek@stripped]
> Sent: Thursday, February 14, 2013 2:59 PM
> To: Rick James
> Cc: mysql
> Subject: Re: slave replication with lots of 'duplicate entry' errors
> 
> On Thu, Feb 14, 2013 at 5:46 PM, Rick James <rjames@stripped>
> wrote:
> >> Is it in read only mode?
> > Furthermore, are all users logging in as non-SUPER users?  Note:
> root bypasses the readonly flag!
> 
> No.  The user that is commonly used does have Super privileges.  I am
> not sure why, but it does.
> 
> Regards,
> - Robert