A NOTE has been added to this issue.
======================================================================
http://dbmail.org/mantis/view.php?id=730
======================================================================
Reported By: jasb
Assigned To:
======================================================================
Project: DBMail
Issue ID: 730
Category: LMTP daemon
Reproducibility: always
Severity: block
Priority: normal
Status: new
target:
======================================================================
Date Submitted: 21-Sep-08 20:20 CEST
Last Modified: 21-Sep-08 23:43 CEST
======================================================================
Summary: Failed to store mimeparts for a 10k message
Description:
I see several messages in queue that are in state "(lost connection with
127.0.0.1[127.0.0.1] while sending end of data -- message may be sent more
than once)"
And i forced the queue to reinsert the message, and i got this:
---
Sep 21 19:08:49 lira postfix/qmgr[15754]: 8ED4A2BD4F:
from=<[EMAIL PROTECTED]>, size=2869, nrcpt=1 (queue active)
Sep 21 19:08:49 lira dbmail/lmtpd[4879]: FATAL:[message]
dbmail-message.c,dbmail_message_store(+1285): Failed to store mimeparts
Sep 21 19:08:49 lira postfix/lmtp[11907]: 8ED4A2BD4F:
to=<[EMAIL PROTECTED]>, relay=127.0.0.1[127.0.0.1]:24, delay=363607,
delays=363607/0/0/0.04, dsn=4.4.2, status=deferred (lost connection with
127.0.0.1[127.0.0.1] while sending end of data -- message may be sent more
than once)
---
Attached there's the raw message in the postfix queue, and the lmtpd log
level 5
======================================================================
----------------------------------------------------------------------
paul - 21-Sep-08 23:27
----------------------------------------------------------------------
Jorge,
Isn't there anything in the mysql errorlog? This indicates failure to
execute a simple insert query. How big is your max_allowed_packet in
my.ncf?
----------------------------------------------------------------------
jasb - 21-Sep-08 23:34
----------------------------------------------------------------------
max_allowed_packet = 100MB
----
and on mysql error log there's nothing.
what can i get you more?
----------------------------------------------------------------------
jasb - 21-Sep-08 23:43
----------------------------------------------------------------------
Paul, here's the normal log for the query, it seams that it was completly
executed somehow, at least the query is completed.
Please confirm i may be missing something.
--------
080921 22:41:23 64 Connect [EMAIL PROTECTED] on postfix
64 Query SELECT domain FROM dbmail_mydomains
WHERE domain='larus.pt' and status='true'
2 Query SELECT deliver_to FROM dbmail_aliases
WHERE lower(alias) = lower('[EMAIL PROTECTED]') AND lower(alias) <>
lower(deliver_to)
2 Query SELECT deliver_to FROM dbmail_aliases
WHERE lower(alias) = lower('423') AND lower(alias) <> lower(deliver_to)
2 Query SELECT user_idnr FROM dbmail_users
WHERE lower(userid) = lower('[EMAIL PROTECTED]@__')
2 Query BEGIN
2 Query SELECT mailbox_idnr FROM
dbmail_mailboxes WHERE name LIKE 'INBOX' AND owner_idnr=1
2 Query INSERT INTO dbmail_physmessage
(messagesize, internal_date) VALUES (0, CURRENT_TIMESTAMP)
2 Query SELECT LAST_INSERT_ID()
2 Query INSERT INTO
dbmail_messages(mailbox_idnr, physmessage_id, unique_id,recent_flag,
status) VALUES (3, 1924608, 'a68b38c8e3ba80b8abdb6212c17c634e', 1, 5)
2 Query SELECT LAST_INSERT_ID()
2 Query SELECT id,data FROM dbmail_mimeparts
WHERE hash='060c40c6d0fdf7882772e54a51ebd17a97fc4069'
2 Query INSERT INTO dbmail_mimeparts (hash,
data, size) VALUES ('060c40c6d0fdf7882772e54a51ebd17a97fc4069', 'Received:
from smtp.decimal.pt (localhost.localdomain [127.0.0.1])\n by
smtp.decimal.pt (Postfix) with ESMTP id 8ED4A2BD4F\n for
<[EMAIL PROTECTED]>; Wed, 17 Sep 2008 14:08:42 +0100 (WEST)\nReceived: by
smtp.decimal.pt (Postfix, from userid 1001) id 824C32BD5C;\n Wed,
17 Sep 2008 14:08:42 +0100 (WEST)\nX-Spam-Checker-Version: SpamAssassin
3.2.5 (2008-06-10) on lira\nX-Spam-Level: \nX-Spam-Status: No, score=-2.6
required=5.0 tests=AWL,BAYES_00,SPF_HELO_FAIL\n autolearn=no
version=3.2.5\nReceived: from raposa.lenaconstrucoes.pt
(gate.lenaconstrucoes.pt [213.13.184.129])\n by smtp.decimal.pt (Postfix)
with SMTP id C5F722BD56\n for <[EMAIL PROTECTED]>; Wed, 17 Sep 2008
14:08:40 +0100 (WEST)\nReceived: (qmail 41580 invoked by uid 1011); 17 Sep
2008 13:08:41 -0000\nReceived: from 62.48.229.28\n by
raposa.lenaconstrucoes.pt (envelope-from <[EMAIL PROTECTED]>,
uid 1008)\n with qmail-scanner-1.25-st-qms (clamdscan: 0.87/1205.
spamassassin: 3.0.4. perlscan: 1.25-st-qms.
Clear:RC:0(62.48.229.28):SA:0(-5.6/5.0):. Processed in 12.467668 secs);
17 Sep 2008 13:08:41 -0000\nX-Antivirus-lenaconstrucoes.pt-Mail-From:
[EMAIL PROTECTED] via\n
raposa.lenaconstrucoes.pt\nX-Antivirus-lenaconstrucoes.pt: 1.25-st-qms\n
(Clear:RC:0(62.48.229.28):SA:0(-5.6/5.0):. Processed in 12.467668 secs\n
Process 41472)\nReceived: from unknown (HELO RuiSilva)
([EMAIL PROTECTED]@62.48.229.28)\n by
raposa.lenaconstrucoes.pt with SMTP; 17 Sep 2008 13:08:28 -0000\nFrom: Rui
Silva <[EMAIL PROTECTED]>\nTo: \'Susana Pereira - Larus\'
<[EMAIL PROTECTED]>\nSubject:
=?Windows-1252?Q?Lida:_Pedido_de_cota=E7=E3o_para_a_empreitada_da_=22INFR?=\n
=?Windows-1252?Q?AESTRUTURAS_DO_LOTEAMENTO_DO_OLIVAL_DA_MOITA_GRANDE_=28T?=\n
=?Windows-1252?Q?ORRES_NOVAS=29_-_FASE_1_PARTE_I=22_-_Propnery?=\nDate:
Wed, 17 Sep 2008 14:06:17 +0100\nMessage-ID:
<[EMAIL PROTECTED]>\nX-Mailer: Microsoft Office
Outlook 11\nX-MimeOLE: Produced By Microsoft MimeOLE
V6.00.2900.3198\nThread-Index:
AchBXQyUvr+PCsRgSqeLFZw8Xs9wVQAA8RkAAD0WMdAL+2KwsASsqjsgAPo5zyAB0/fpIAKBNU0gADyXEiAFQ9RY8AA39mmwACkU8SAAADPdIAAKR8sgAAex3VAAABVSEAAAG4LQAI6Sl5AALhnAkAAAFbHgA+svXiAABc2wMAK+2NtQAACcLfABWBiOIAAIMukgAAHTg7AABYuNIArtX3ogAAYiyeAABLarQAXdktywAAUNeJAAATUAog==\nIn-Reply-To:
<[EMAIL PROTECTED]>\nX-Virus-Scanned:
ClamAV using ClamSMTP\nReturn-Path:
[EMAIL PROTECTED]: 1.0\nContent-Type:
message/disposition-notification\nContent-Transfer-Encoding: 7bit\n',
2548)
2 Query SELECT LAST_INSERT_ID()
2 Query INSERT INTO dbmail_partlists
(physmessage_id, is_header, part_key, part_depth, part_order, part_id)
VALUES (1924608,1,1,0,0,2645126)
65 Connect [EMAIL PROTECTED] on postfix
65 Query SET NAMES utf8
65 Query SHOW VARIABLES LIKE 'collation_%'
66 Connect [EMAIL PROTECTED] on postfix
66 Query SELECT domain FROM dbmail_mydomains
WHERE domain='larus.pt' and status='true'
67 Connect [EMAIL PROTECTED] on postfix
67 Query SELECT domain FROM dbmail_mydomains
WHERE domain='larus.pt' and status='true'
Issue History
Date Modified Username Field Change
======================================================================
21-Sep-08 20:20 jasb New Issue
21-Sep-08 20:20 jasb File Added: debug.zip
21-Sep-08 23:27 paul Note Added: 0002605
21-Sep-08 23:34 jasb Note Added: 0002606
21-Sep-08 23:43 jasb Note Added: 0002607
======================================================================
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
