Hi, We are testing policyd on multiple SMTP servers with the same load balanced master-master replicated MySQL database as backend to be able to keep quotas synced between different SMTP servers.
Is this generally a supported setup? The reason I am asking is that occationally we are seeing replication breaking with: Duplicate entry '363e.534ea5ea.49a4c.0' for key 'Instance'' on INSERT INTO session_tracking. It seems to be related to a mail from one sender to multiple recipients and policyd attempting to insert two session_tracking entries with the same Instance value. If those ends up on different database backends at about the same time so the two databases are not syncronized we end up with two conflicting entries. One interesting thing is that the entry on one of the databases doesn't have a QueueID but the other one does. Any ideas on solutions to this problem? Regards //Magnus _______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users_lists.policyd.org
