Paul, Forget about this, my dumbness.
Tell me, can I run -by while having messages exchanged? being inserted, deleted, etc etc, either pop3 and imap (I know imap will suffer) > -----Original Message----- > From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On > Behalf Of Jorge Bastos > Sent: domingo, 7 de Setembro de 2014 15:30 > To: 'DBMail mailinglist' > Subject: Re: [Dbmail] Help upgrading from arround 2.3.6 to 3.1.13 > > Hi Paul, > > I'm doing some offline tests with this, but the envelope table isn't > being filled, either with dbmail-util -by or -yb. > Any idea on what it could be? > > Steps were: > > Truncate dbmail_envelope; > CREATE UNIQUE INDEX dbmail_envelope_1 ON > dbmail_envelope(physmessage_id); > > Dbmail-util -yb (or -by) > > > > > -----Original Message----- > > From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On > > Behalf Of Paul J Stevens > > Sent: sábado, 24 de Maio de 2014 18:56 > > To: DBMail mailinglist > > Subject: Re: [Dbmail] Help upgrading from arround 2.3.6 to 3.1.13 > > > > > > On 21-05-14 21:33, Jorge Bastos wrote: > > > Hi Paul, > > > > > > Thanks, > > > > > > So steps should be: > > > > > > Truncate table > > > Apply unique index > > > Run Dbmail-util -by > > > > > > .... > > > > > > Later on/after it apply the rest of the DB changes and upgrade. > > > > > > Am I right? > > > > Yes. > > > > > > > > > > > Could I truncate the table, apply the unique index and run dbmail- > > util > > > -by with the system running? (receiving emails) or no email can be > > > received while this ends? > > > > I don't see a problem there. The envelope table will be empty and > only > > partially filled. This will confuse connecting IMAP clients. So you > > will probably want to disable IMAP while this is running. POP3 and > > delivery are not affected. > > > > > > > >> > > >> > > >> > > >> Truncate the envelope table. It can be re-filled using dbmail- > util. > > >> > > >> > > >> > > >> > > >> On 20-05-14 23:53, Jorge Bastos wrote: > > >>> Hi, > > >>> > > >>> I'm doing some offline tests to upgrade my DBMail to latest > 3.1.13. > > >>> > > >>> My 1^st sql upgrade script to run is: 2_3_6-3_0_0.mysql > > >>> > > >>> But when I run it I get: > > >>> > > >>> mysql> CREATE UNIQUE INDEX dbmail_envelope_1 ON > > >>> dbmail_envelope(physmessage_id); > > >>> > > >>> ERROR 1062 (23000): Duplicate entry '2424862' for key 3 > > >>> > > >>> mysql> > > >>> > > >>> So I went to see why and saw that have MANY duplicated records, > > >>> check the below image. > > >>> > > >>> Also, the table structure is different than the > > >>> create_tables.mysql file that has the column order: > > >>> > > >>> id/physmessage/envelope > > >>> > > >>> and I have: > > >>> > > >>> physmessage/id/envelope > > >>> > > >>> Is this problematic, or in the code the insertions on the table > > >>> are hardcoded with an "insert into dbmail_envelope > > >>> (id,physmessage,envelope) values (?,?,?)" and the column order > > >> doesn't matter at all? > > >>> > > >>> What can I do to proceed? > > >>> > > >>> Thanks in advanced, > > >>> > > >>> Jorge, > > >>> > > >>> dup envelope.jpg > > >>> > > >>> > > >>> > > >>> _______________________________________________ > > >>> DBmail mailing list > > >>> DBmail@dbmail.org > > >>> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > > >>> > > >> > > >> -- > > >> ________________________________________________________________ > > >> Paul J Stevens pjstevns @ gmail, twitter, github, linkedin > > >> www.nfg.nl/i...@nfg.nl/+31.85.877.99.97 > > >> _______________________________________________ > > >> DBmail mailing list > > >> DBmail@dbmail.org > > >> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > > > > > > _______________________________________________ > > > DBmail mailing list > > > DBmail@dbmail.org > > > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > > > > > > > -- > > ________________________________________________________________ > > Paul J Stevens pjstevns @ gmail, twitter, github, linkedin > > www.nfg.nl/i...@nfg.nl/+31.85.877.99.97 > > _______________________________________________ > > DBmail mailing list > > DBmail@dbmail.org > > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > > _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
