Re: [Sqlgrey-users] duplicate entry

[Alex <mys...@gm...>]

Hi,

>>                Last_SQL_Error: Error 'Duplicate entry
>> '69.25.195-mk1.netatlantic.com-bounce-#' for key 'PRIMARY'' on query.
>> Default database: 'sqlgrey'. Query: 'INSERT INTO from_awl
>> (sender_name, sender_domain, src, first_seen, last_seen)
>> VALUES('bounce-#','mk1.netatlantic.com','69.25.195','2016-03-07
>> 11:51:51',NOW())'
>>   Replicate_Ignore_Server_Ids:
>
> It might happen in rare cases where the same source sends an email
> through two independent mail servers at the very same time that confirm
> an earlier attempt. They will both try to insert the same auto whitelist
> entry.
>
> Another possibility is that the dbcluster support uses slaves for all
> its reads and they are not synchronized with the master properly, which
> given the following seems the most likely explanation.

Yes, I'm pretty sure that's it as well.

> Note that if you don't need slaves to support your current load and
> greylisting is not critical you are better off without them. SQLgrey can
> withstand a database failure : it will attempt to reconnect but in the
> meantime it will stop filtering incoming mail to avoid any service
> disruption.

I've recreated the slaves making them read-only, and I believe that's
fixed the problem. Perhaps I should have done that at first.

Thanks for all your help.
Alex