Re: Help upgrading from arround 2.3.6 to 3.1.13

Hey Jorge,

you should do this daily, so its not a problem. Only problem is that mails  
getting fetched while there are no header cached for this mail will not  
show a subject until the message is downloaded to the client.

bye

Harald

Am .09.2014, 20:24 Uhr, schrieb Jorge Bastos <[email protected]>:

> 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: [email protected] [mailto:[email protected]] 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: [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
>>
>> _______________________________________________
>> 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


-- 
Harald Leithner

ITronic
Wiedner Hauptstraße 120/5.1, 1050 Wien, Austria
Tel: +43-1-545 0 604
Fax: +43-1-786 23 88 26
Mobil: +43-699-123 78 4 78
Mail: [email protected] | itronic.at
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail