On 07/17/2010 06:01 PM, Reindl Harald wrote:
> I can confirm this and it seems there are different
> handlings between mail-clients

Harald,

exactly what are you confirming?

Since dbmail-lmtpd and dbmail-imapd are completely separate processes I
have a hard time coming up with a likely scenario that would explain the
behaviour described by Victor.

The only point where those processes interact are the database. And that
would /not/ explain why delivery through lmtp would trigger a high CPU
load on the imapd.

> * thunderbird takes a really long time and freezes
> * horde-webmail is fast and let download the attachment normally
> 
> Maybe theres is some difference how both clients fetch
> attachments and one of them possible could be optimized
> in dbmail without knowing much about internas of it

I know that thunderbird uses chunked fetching where horde probably
simply downloads the full message in one go. You could test this by
disabling chunked-fetch in tb. In the config-editor togglle

mail.server.defaults.fetch_by_chunks

But I don't really expect that is what is causing grief for Victor.



> 
> Am 17.07.2010 17:29, schrieb only-victor:
>>
>>         I use: ArchLinux x86_64, dbmail-2.2.16
>>         
>>         If I send mail without attached files, then all work well. But if I
>> attach file which size about 2M or more, then dbmail-imapd uses 100% CPU
>> and works long time. But postgres uses 0-1% CPU and loads about 2-3
>> seconds. After I accept message. 
>>         I have only 2 mail accounts at postgres database and about 10-20
>> mail
>> messages.
>>         Please, help me to resolve this problem.
>>         I attached debug log below and I mark where my problem started.
>>
>>
>>
>> #### DEBUG LOG   when attached file size 2.8M #####################
>>
>> Jul 14 22:13:04 mail-musson dbmail-imapd[3281]: Info:[serverchild]
>> serverchild.c,SetChildSigHandler(+152): signal handler placed
>>
>> Jul 14 22:13:04 mail-musson dbmail-imapd[3230]: Message:[server]
>> pool.c,scoreboard_state(+584): Scoreboard state: children [4/100],
>> spares [3 (3 - 10)]
>>
>> Jul 14 22:13:05 mail-musson dbmail-lmtpd[3255]: Info:[sort]
>> sort.c,sort_and_deliver(+55): Destination [[email protected]] useridnr [6],
>> mailbox [(null)], source [0]
>>
>> Jul 14 22:13:05 mail-musson dbmail-lmtpd[3255]: Info:[misc]
>> misc.c,find_bounded(+350): Found nothing between '+' and '@'
>>
>> Jul 14 22:13:05 mail-musson dbmail-lmtpd[3255]: Info:[sort]
>> sort.c,sort_deliver_to_mailbox(+127): useridnr [6] mailbox [INBOX]
>>
>> Jul 14 22:13:05 mail-musson dbmail-lmtpd[3255]: Info:[sort]
>> sort.c,sort_deliver_to_mailbox(+166): user [6] has right to deliver mail
>> to [INBOX]
>>
>> Jul 14 22:13:05 mail-musson dbmail-lmtpd[3255]: Message:[sort]
>> sort.c,sort_deliver_to_mailbox(+196): message id=1844, size=3922481 is
>> inserted
>>
>> Jul 14 22:13:05 mail-musson dbmail-lmtpd[3255]: Info:[sort]
>> sort.c,sort_and_deliver(+102): Keep was not cancelled. Message will be
>> delivered by default.
>>
>> Jul 14 22:13:05 mail-musson dbmail-lmtpd[3255]: Info:[delivery]
>> pipe.c,insert_messages(+625): successful sort_and_deliver for useridnr
>> [6]
>>
>> Jul 14 22:13:05 mail-musson dbmail-lmtpd[3255]: Info:[serverchild]
>> serverchild.c,PerformChildTask(+397): connection closed
>>
>>
>> ##############################################################
>>    In this time:    CPU LOAD 100%    from 22:13:05 till 22:13:30 
>> ##############################################################
>>
>>
>> Jul 14 22:13:30 mail-musson dbmail-imapd[3241]: Info:[imap]
>> imap4.c,IMAPClientHandler(+302): Executing command append...
>>
>> Jul 14 22:13:32 mail-musson dbmail-imapd[3241]: Message:[db]
>> db.c,db_imap_append_msg(+2618): message id=1846 is inserted
>> Jul 14 22:13:32 mail-musson dbmail-imapd[3241]: Info:[imap]
>> imap4.c,IMAPClientHandler(+321): Finished command append [0]
>>
>> Jul 14 22:13:32 mail-musson dbmail-imapd[3241]: Info:[imap]
>> imap4.c,IMAPClientHandler(+191): COMMAND: [A004 LOGOUT]
>>
>> Jul 14 22:13:32 mail-musson dbmail-imapd[3241]: Info:[imap]
>> imap4.c,IMAPClientHandler(+302): Executing command logout...
>>
>> Jul 14 22:13:32 mail-musson dbmail-imapd[3241]: Message:[imap]
>> imapcommands.c,_ic_logout(+126): user (id:6) logging out @ [2010-07-14
>> 22:13:32] 
> 
> 
> 
> _______________________________________________
> DBmail mailing list
> [email protected]
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail


-- 
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Reply via email to