From: Alex <mys...@gm...> - 2016-03-07 20:06:51
|
Hi, I've been using sqlgrey for a while with mariadb and noticed there is what appears to be a duplicate entry: 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: I have the system set up with a master on one system and replicated to three others. This occurred on one of the slaves. This isn't the first time it's happened. Is this to be expected? Is it possible it's a problem with my setup? If I run "select count(*) from from_awl;" from the master and each of the slaves, the count differs by a hundred on one system, and multiple hundreds on another. If the Relay_Log_Pos on the slave matches that of the master, doesn't it mean they're in sync? I'd sure appreciate any ideas you may have. Thanks, Alex |