On 18-02-14 12:17, Peter Milesson wrote:
>> I used 78bee4a96c625a9f22b1e13a7f7d9a9e72532f56. Then I backed down to
>> the standard 3.1.10 with the patch
>> 8c612adbe6468e2cb4d520789cd35156145c5f37. That didn't help a bit, the
>> behavior was the same.
78bee4a96c625a9f22b1e13a7f7d9a9e72532f56 is from the master branch. That
branch contains auto-migration of the database schema. All of those are
backward compatible as far as I can tell.
>> The database is currently around 70GB in size, with about 300000
>> messages stored. I've tuned it with mysqltuner.
I have no idea what that entails.
>> - First, DBMail 3.1.10 is much slower compared to 3.0.2. It seems to
>> take a lot more time to fetch the message body.
That is surprising since the underlying mechanism is very much identical.
>> - For those users that have got huge mailboxes with lots of folders and
>> subfolders, the message lists end up like a mixed salad. Mostly, the
>> same set of message headers are displayed in the list, when opening an
>> arbitrary folder. The Mozilla Repair function does not help. It does not
>> help deleting cached headers/messages, the mixed salad is there. Using
>> exactly the same database with 3.0.2, everything is displayed neatly and
>> in good order, and each message is listed in the folder where it belongs.
It must be something in your database. Would you mind sharing a schema-dump?
>> - If AVG mail scanning is active (here's your proxy Paul!) The messages
>> are not fetched from the database while browsing through the message
>> list, that is no preview is shown. It is necessary to open the message
>> in a separate window first, or choose to display it as plain text (a
>> Thunderbird-only function). Even that does not help sometimes. It's
>> necessary to open another message, and then go back. After the first
>> message has been opened, most messages are displayed in the preview
>> pane, but not all. I noticed in one case with 3.0.2, that neither the
>> message, nor information about attachment was displayed in the preview
>> pane. When I opened the message, text and attachment was visible.
I have *no* idea what AVG mail scanning is. You mean there is a proxy
between dbmail and the imap client that does scanning on the wire? If so
that is *so* weird. Normally emails are scanned before entering the
system using tools like amavis. But ok, people do weird shit :-) Maybe
if I could see a IMAP trace (tshark) of the actual conversation.
>> - There's still parts of a bug I reported previously, and that was
>> corrected with 8c612adbe6468e2cb4d520789cd35156145c5f37. The patch works
>> if there are attachments. If the message contains only plain text, the
>> message doesn't look right. I can supply messages processed by DBMail
>> 3.0.2, as well as 3.1.10.
If the message contains only plain text the patch is a no-op. Also, the
codebase contains a *lot* of unit-testing around message reconstruction,
and all those pass just fine.
But again, without seeing the imap conversation, I can't tell.
> After half a day of operation with DBMail 3.0.2 and support
> libraries/systems according to the following:
>
> MariaDB 5.5.34
> gmime 2.6.19
> glib 2.36.4
> glibc 2.17
> libevent 2.0.21
> libzdb 2.12 (also tried 3.0)
> libsieve 2.3.1
>
> To my dismay, I must state the following:
>
> - there is no indication of attachments in the message list
Afaik, Thunderbird derives that indication from the Content-Type header.
Again, this is an indication something is wrong with the schema.
--
________________________________________________________________
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
