|
»
»
»
[DBMail 0000730]: Failed to store mimeparts for a 10k message
|
View:
New views
1 Messages
—
Rating Filter:
Alert me
|
 |
[DBMail 0000730]: Failed to store mimeparts for a 10k message
by bugtrack
::
Rate this Message:
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: 24-Sep-08 13:03 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=<rui.silva@...>, 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=<spereira@...>, 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 postfix_usr@... 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('spereira@...') 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('__@!internal_delivery_user!@__') 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 <spereira@...>; 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 <spereira@...>; 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 <rui.silva@...>, 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: rui.silva@... 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) (rui.silva@...@62.48.229.28)\n by raposa.lenaconstrucoes.pt with SMTP; 17 Sep 2008 13:08:28 -0000\nFrom: Rui Silva <rui.silva@...>\nTo: \'Susana Pereira - Larus\' <spereira@...>\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: <006b01c918c6$39362210$1451a8c0@...>\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: <!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAeVngOnhV+EmX7Qaz4D7Sx8KAAAAQAAAA8UyemXxtU0m4TbySU8TX4gEAAAAA@...>\nX-Virus-Scanned: ClamAV using ClamSMTP\nReturn-Path: rui.silva@...\nMIME-Version: 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 postfix_usr@localhost on postfix 65 Query SET NAMES utf8 65 Query SHOW VARIABLES LIKE 'collation_%' 66 Connect postfix_usr@... on postfix 66 Query SELECT domain FROM dbmail_mydomains WHERE domain='larus.pt' and status='true' 67 Connect postfix_usr@... on postfix 67 Query SELECT domain FROM dbmail_mydomains WHERE domain='larus.pt' and status='true' ---------------------------------------------------------------------- jasb - 21-Sep-08 23:46 ---------------------------------------------------------------------- hum..., here should exist a space beteewen the table name and the the field? --- 2 Query INSERT INTO dbmail_messages(mailbox_idnr, physmessage_id, unique_id,recent_flag, status) VALUES (3, 1924608, 'a68b38c8e3ba80b8abdb6212c17c634e', 1, 5) ---------------------------------------------------------------------- jasb - 24-Sep-08 13:03 ---------------------------------------------------------------------- Hi Paul, Any suggestion? 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 21-Sep-08 23:46 jasb Note Added: 0002608 24-Sep-08 13:03 jasb Note Added: 0002609 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@... http://twister.fastxs.net/mailman/listinfo/dbmail-dev |
| Free Forum Powered by Nabble | Forum Help |
