Ahh. So does this look like a new message from the database point of view?
So this means that this setup could cause a duplicate message_idnr, correct? Thanks for your help! Angus On Thu, 16 Dec 2004 13:07:11 -0800, Blake Mitchell <[EMAIL PROTECTED]> wrote: > The IMAP APPEND command will insert new messages. For example, my mail > client will put messages into my "Sent" folder on the IMAP server once > I've sent them. > > ----------------------------------------------- > Date: Thu, 16 Dec 2004 08:31:30 -0800 > From: Angus Jordan <[EMAIL PROTECTED]> > To: Blake Mitchell <[EMAIL PROTECTED]> > Subject: Re: [Dbmail] DB questions > > Blake, > > My understanding is that IMAP only does updates on the database. Can > you describe to me a specific situation where there could be > corruption? > > From what I can remember of the thread that was on the -dev list a few > months ago, the only issue they brought up and were discussing was the > idea of having two seperate database servers both running MTA software > and inserting into both of the seperate databases with *new messages*. > This was because the inserts are not kept ACID across a multi master > setup in MySql, and the auto_increment on the dbmail_messages table > may not take this into account. > > Since the IMAP daemon would not be changing the message_idnr field, > wouldn't running the MTA software on only 1 database solve this issue > partially? > > Thanks, > Angus > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
