Re: [Sqlgrey-users] #Error Messages in Log

[Karl O. P. <ko...@me...>]

On 12/19/2013 05:12:21 PM, Michael Ludvig wrote:

> Why don't we do INSERT IGNORE ... to prevent the duplicate key error?

That would prevent sqlgrey from working with non-MySQL databases
.
> It's probably only a timing issue, the pre-existing record would
> eventually propagate from the master to the slave over time so it's
> not
> a problem if we can't insert it again.
> 
> One other thing - could the index be corrupted? The index may think
> the
> record is there while in fact it isn't.

If it's a MySQL problem then the problem should be fixed on
the MySQL side, IMO.



Karl <ko...@me...>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein