Re: 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: [email protected] [mailto:[email protected]] 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
> >>> [email protected]
> >>> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
> >>>
> >>
> >> --
> >> ________________________________________________________________
> >> Paul J Stevens       pjstevns @ gmail, twitter, github, linkedin
> >>              www.nfg.nl/[email protected]/+31.85.877.99.97
> >> _______________________________________________
> >> DBmail mailing list
> >> [email protected]
> >> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
> >
> > _______________________________________________
> > DBmail mailing list
> > [email protected]
> > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
> >
> 
> --
> ________________________________________________________________
> Paul J Stevens       pjstevns @ gmail, twitter, github, linkedin
>             www.nfg.nl/[email protected]/+31.85.877.99.97
> _______________________________________________
> DBmail mailing list
> [email protected]
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail