Harry,

On 02/22/2012 04:49 PM, Reindl Harald wrote:
> info: 3.0.1 HEAD currently, same results
> http://git.dbmail.eu/paul/dbmail/commit/?id=24901216f5d51391e96e46500613c4e41e30c36f


You need

http://git.dbmail.eu/paul/dbmail/commit/?id=8e4f4ae008614912fc1cbf5c2b4eea57978150db

for the gmail fix.

It was done after bumping the version.


> well, with manual queries seems that there a hughe amount of messages have
> "deleted_flag", maybe they started cleanup per webmail in the meantime

Probably.

> mysql> select count(message_idnr) from `dbmail_mailboxes`, `dbmail_messages` 
> where owner_idnr=113 and
> dbmail_messages.mailbox_idnr=dbmail_mailboxes.mailbox_idnr and 
> (dbmail_messages.deleted_flag=0 and
> dbmail_messages.status<2);

You really shouldn't ignore messages with deleted_flag=1. Those are
marked for deletion in IMAP, but are still available both in IMAP and
POP3. Only after the IMAP client issues a EXPUNGE command are they
removed (status=2) and queued for purging from the database.

>>> webmail over imap says 2424 in "inbox"
>>> google says it received 200 messages via POP3, still 2224 outstanding
>>
>> At least webmail and google are consistent about the numbers.
> 
> but it is wrong, surely wrong

No it's not.

>> Maybe this is how google works: fetch batches of 200.
>>> google webinterface shows 110 messages in inbox
>>
>> What do you mean? How is the google webinterface connected to dbmail?
> 
> this is the "fetch account via pop3 to google-account" thing
> so it says it fecthed 200 mails via POP3 until error happended
> it shows only via https://mail.google.com/ in the inbox
> 
> my thunderbird is connected to the same gmail account
> via IMAP and shows 245 messages

Then thunderbird is not reading the IMAP results.

> so well, IMAP/POP3 are showing the same count
> but why a different than my query?

Your query is incorrect.

>> But I managed to reproduce the RETR error. Will trace it myself.
> 
> i guess this is the source of most troubles except lmtpd
> i can NOT reproduce the lmtpd-crash running gdb with 3.0.1
> but the "normal" service is still crashing :-(

So maybe it's not the message itself, but the way postfix talks to
dbmail - just guessing here.


-- 
________________________________________________________________
Paul J Stevens        pjstevns @ gmail, twitter, skype, linkedin

  * Premium Hosting Services and Web Application Consultancy *

           www.nfg.nl/[email protected]/+31.85.877.99.97
________________________________________________________________
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Reply via email to