Leonel Nunez wrote:
> Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
> query [INSERT INTO dbmail_messageblks (is_header, messageblk, blocksize,
> physmessage_id) VALUES ('1','Received: from CHANGED (debian [127.0.0.1])
> ^Iby CHANGED (Postfix) with ESMTP id 7A966601FD; ^IMon, 5 Sep 2005
> 14:21:37 -0400 (EDT) Received: from CHANGED (unknown [211.155.235.11])
> ^Iby CHANGED (Postfix) with SMTP id 024AC601F2; ^IMon, 5 Sep 2005
> 14:21:27 -0400 (EDT) X-Message-Info: 03EG895Pyoc5UT18p[1 Message-Id:
> <[EMAIL PROTECTED]> Date: Mon, 5 Sep 2005
> 14:21:27 -0400 (EDT) From: [EMAIL PROTECTED] To: undisclosed-recipients:
> ; ', '481', '323959')]
So far so good. But heh! The sender is gmail.com...
> Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
> query [SELECT currval('dbmail_messageblk_idnr_seq')]
> Sep 6 06:18:36 debian dbmail/smtp[1886]: store_message_temp():
> allocating [524288] bytes of memory for readblock
> Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
> query [UPDATE dbmail_messages SET unique_id =
> 'f62e398dbb67086b653a17a8f8381568', status = '0' WHERE message_idnr =
> '324498']
> Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
> query [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr =
> '324498']
> Sep 6 06:18:36 debian dbmail/smtp[1886]: dbpgsql.c,db_query: executing
> query [UPDATE dbmail_physmessage SET messagesize = '481', rfcsize =
> '13835055048805057005' WHERE id = '323959']
This is obviously incorrect. The rfcsize is way too large. The
mime-parser is very definitely messed up here. But what else is new...
>
> here comes the error
No, just fallout from the incorrect rfcsize.
>
> Does this 2 tables dbmail_physmessage and dbmail_message should have
> the same row count ?
No it doesn't. Many messages can point to the same physmessage.
Could you please send me a message that is causing this. Preferably
zipped. If I can reproduce I can fix this.
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
