hi, we have some replication-problems using dbmail 1.1 and mysql 4.0.13. we updated the database today because we want to use the nice query-cache in mysql-4.0. we have to datebase-servers with mysql-master-slave-replication. everything is ok with it except that the synchronisation gets lost very often since we updatet the db:
ERROR: 1062 Duplicate entry '17603' for key 1 030606 13:11:37 Slave: error 'Duplicate entry '17603' for key 1' on query 'INSERT INTO messageblks(messageblk,blocksize,message_idnr) VALUES etc.... it is always the same insert-command which causes the mysql-slave to stop replication. has anyone a solution for it? btw.: all other replication-things are working ok... since the upgrade we had about 180000 updates and 30000 inserts which were replicated correctly... only dbmail makes problems... regards, ingo brand
