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: minor Priority: low Status: acknowledged target: ====================================================================== Date Submitted: 21-Sep-08 20:20 CEST Last Modified: 04-Aug-09 10:29 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.si...@lenaconstrucoes.pt>, 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=<spere...@larus.pt>, 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 ====================================================================== ---------------------------------------------------------------------- (0002605) paul (administrator) - 21-Sep-08 23:27 http://dbmail.org/mantis/view.php?id=730#c2605 ---------------------------------------------------------------------- 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? ---------------------------------------------------------------------- (0002606) jasb (reporter) - 21-Sep-08 23:34 http://dbmail.org/mantis/view.php?id=730#c2606 ---------------------------------------------------------------------- max_allowed_packet = 100MB ---- and on mysql error log there's nothing. what can i get you more? ---------------------------------------------------------------------- (0002607) jasb (reporter) - 21-Sep-08 23:43 http://dbmail.org/mantis/view.php?id=730#c2607 ---------------------------------------------------------------------- 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_...@127.0.0.1 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('spere...@larus.pt') 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 <spere...@larus.pt>; 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 <spere...@larus.pt>; 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.si...@lenaconstrucoes.pt>, 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.si...@lenaconstrucoes.pt 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.si...@lenaconstrucoes.pt@62.48.229.28)\n by raposa.lenaconstrucoes.pt with SMTP; 17 Sep 2008 13:08:28 -0000\nFrom: Rui Silva <rui.si...@lenaconstrucoes.pt>\nTo: \'Susana Pereira - Larus\' <spere...@larus.pt>\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$1451a...@redelc.pt>\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+emx7qaz4d7sx8kaaaaqaaaa8uyemxxtu0m4tbysu8tx4geaa...@larus.pt>\nX-Virus-Scanned: ClamAV using ClamSMTP\nReturn-Path: rui.si...@lenaconstrucoes.pt\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_...@localhost on postfix 65 Query SET NAMES utf8 65 Query SHOW VARIABLES LIKE 'collation_%' 66 Connect postfix_...@127.0.0.1 on postfix 66 Query SELECT domain FROM dbmail_mydomains WHERE domain='larus.pt' and status='true' 67 Connect postfix_...@127.0.0.1 on postfix 67 Query SELECT domain FROM dbmail_mydomains WHERE domain='larus.pt' and status='true' ---------------------------------------------------------------------- (0002608) jasb (reporter) - 21-Sep-08 23:46 http://dbmail.org/mantis/view.php?id=730#c2608 ---------------------------------------------------------------------- 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) ---------------------------------------------------------------------- (0002609) jasb (reporter) - 24-Sep-08 13:03 http://dbmail.org/mantis/view.php?id=730#c2609 ---------------------------------------------------------------------- Hi Paul, Any suggestion? ---------------------------------------------------------------------- (0002614) paul (administrator) - 05-Oct-08 12:06 http://dbmail.org/mantis/view.php?id=730#c2614 ---------------------------------------------------------------------- Jorge, given the massive changes since 2.3.2 - especially the usage of prepared statements since 2.3.3 - it's impossible to work on this without confirmation that it's still a problem in git-HEAD (or svn-trunk if you prefer). ---------------------------------------------------------------------- (0002617) jasb (reporter) - 05-Oct-08 12:28 http://dbmail.org/mantis/view.php?id=730#c2617 ---------------------------------------------------------------------- Hum i understand. I thinked that too, i'm still using the 2.3.2. Is the SVN HEAD "stable" for production? I ask this so that i can test it. ---------------------------------------------------------------------- (0002899) jasb (reporter) - 04-Aug-09 10:29 http://dbmail.org/mantis/view.php?id=730#c2899 ---------------------------------------------------------------------- I think this can be closed, not happening anymore since =>2.3.6. 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 05-Oct-08 12:06 paul Note Added: 0002614 05-Oct-08 12:06 paul Priority normal => low 05-Oct-08 12:06 paul Severity block => minor 05-Oct-08 12:06 paul Status new => acknowledged 05-Oct-08 12:06 paul Resolution open => won't fix 05-Oct-08 12:28 jasb Note Added: 0002617 04-Aug-09 10:29 jasb Note Added: 0002899 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev