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
