A NOTE has been added to this issue.
======================================================================
http://dbmail.org/mantis/view.php?id=924
======================================================================
Reported By: gerritcap
Assigned To:
======================================================================
Project: DBMail
Issue ID: 924
Category: Command-Line programs (dbmail-users, dbmail-util)
Reproducibility: always
Severity: minor
Priority: normal
Status: new
target:
======================================================================
Date Submitted: 04-Sep-11 22:53 CEST
Last Modified: 21-Dec-11 18:58 CET
======================================================================
Summary: dbmail-util -by doesn't fix un-cached physmessages
Description:
Every time I run dbmail-util -by it informs me that there are 3 un-cached
physmessages. It seems to fix it (3 dots are displayed) and finally reports
that the errors were fixed and suggest to rerun dbmail-util to validate if
they really are.
Unfortunately repeatedly I relaunched dbmail-util but it continues to give
the same information.
Note: I had this problem with postgresql 8.4.1/dbmail-2-2.11 and recently
upgraded to postgresql 9.0.4/dbmail-2.2.17. Both combinations had the same
problem.
I then tried to upgrade to dbmail-3.0.0 rc3:
1) upgraded the dbmail software
2) upgraded the database with the upgrade script to upgrade 2_2 to
3_0
3) tried twice the dbmail-util -by script: it twice reported all of my
15.000+ emails, it also showed a lot of dots while correcting (or trying to
correct)
4) ran dbmail-util -My twice to update all messages to new database
structure
5) ran dbmail-util -by twice again, and again twice the same 15.000+
records were reported and were part of a fix
Note that after upgrading to 3.0.0 rc3, using thunderbird to connect to
the dbmails imap server, every message had empty header records: no
subject, no sender info was shown, no date etc... and this after step 2, 3,
4 & 5 detailed above. Each test was performed after emptying the
thunderbird cache in the thunderbird profile directory on disk
======================================================================
----------------------------------------------------------------------
(0003371) mverbert (reporter) - 21-Dec-11 18:58
http://dbmail.org/mantis/view.php?id=924#c3371
----------------------------------------------------------------------
I tried the latest tree (3ef7b075f722387d917836eb93fd09745aa53fa1), and the
same problem can be reproduced on different environment:
- debian stable (6.0.3)
- postgresql server 9.1.1 (package version: 9.1.1-1~bpo60+1)
I used the following sequence:
- stop dbmail 2.2.17 servers (imap and sieve)
- run dbmail -a, nothing to fix so no action taken
- run the update script 2_2-3_0.pgsql as the same user used by dbmail
- install dbmail 3.0.0rc3 (in reality it matches the commit mentioned
above)
- run dbmail-util -My multiple times (I didn't use -m to do the > 40000
messages at once)
- run dbmail -b, it complains that physmessages are un-cached, so ran
"dbmail -by". Ran again "dbmail -b", same complain.
I repeated the last step 3 times, no real progress is ever made.
For completeness, I re-ran the full procedure (with, obviously, a database
restore in between), and it is 100% reproducible.
Is there any step in the upgrade procedure that I missed ?
for me, the issue is a show-stopper to go for dbmail 3 as no previous mail
is fully accessible...
Issue History
Date Modified Username Field Change
======================================================================
04-Sep-11 22:53 gerritcap New Issue
21-Dec-11 18:58 mverbert Note Added: 0003371
======================================================================
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
