A NOTE has been added to this issue. ====================================================================== http://dbmail.org/mantis/view.php?id=791 ====================================================================== Reported By: jasb Assigned To: netvulture ====================================================================== Project: DBMail Issue ID: 791 Category: LMTP daemon Reproducibility: have not tried Severity: minor Priority: normal Status: acknowledged target: ====================================================================== Date Submitted: 23-Jul-09 16:45 CEST Last Modified: 28-Jul-09 06:18 CEST ====================================================================== Summary: Several LMTPD problems on delevery Description: I'm chasing now LMTPD for some problems that is has. Below there's some of them, i believe it's some of folowing that is causing the problem of missing rfcsize/envelope/un-cached values that are corrected by dbmail-util, i say this 'cause at the moment this happened i had some problematic messages.
Jul 23 15:25:35 lira dbmail/lmtpd[19475]: [0x8f53b08] Warning:[message] dbmail_message_store(+1318): Failed to store mimeparts Jul 23 15:25:35 lira dbmail/lmtpd[19475]: [0x8f53b08] Error:[db] db_copymsg(+2678): error getting size for message [6073908] Jul 23 15:25:35 lira dbmail/lmtpd[19475]: [0x8f53b08] Error:[message] sort_deliver_to_mailbox(+2132): error copying message to user [657] Jul 23 15:25:36 lira dbmail/lmtpd[19475]: [0x8f53b08] Error:[message] insert_messages(+2437): unknown temporary failure in sort_and_deliver for useridnr [657] Jul 23 15:27:32 lira dbmail/lmtpd[19475]: [0x8f53b08] Warning:[message] dbmail_message_store(+1318): Failed to store mimeparts Jul 23 15:27:32 lira dbmail/lmtpd[19475]: [0x8f53b08] Error:[db] db_copymsg(+2678): error getting size for message [6073922] Jul 23 15:27:32 lira dbmail/lmtpd[19475]: [0x8f53b08] Error:[message] sort_deliver_to_mailbox(+2132): error copying message to user [657] Jul 23 15:27:32 lira dbmail/lmtpd[19475]: [0x8f53b08] Error:[message] insert_messages(+2437): unknown temporary failure in sort_and_deliver for useridnr [657] ====================================================================== ---------------------------------------------------------------------- (0002845) netvulture (developer) - 24-Jul-09 19:27 http://dbmail.org/mantis/view.php?id=791#c2845 ---------------------------------------------------------------------- Still waiting on those logs. ---------------------------------------------------------------------- (0002856) jasb (reporter) - 27-Jul-09 16:06 http://dbmail.org/mantis/view.php?id=791#c2856 ---------------------------------------------------------------------- check the attached file "lmtp size.txt". Anyway i think it doesn't gived any useful information anyway... What do you suggest? ---------------------------------------------------------------------- (0002857) jasb (reporter) - 27-Jul-09 19:16 http://dbmail.org/mantis/view.php?id=791#c2857 ---------------------------------------------------------------------- Jon, Check this log (dbmail_error_getting_msg_size.txt), it's from filelog and it has the full query's. ---------------------------------------------------------------------- (0002858) jasb (reporter) - 27-Jul-09 22:58 http://dbmail.org/mantis/view.php?id=791#c2858 ---------------------------------------------------------------------- Aditional info, This just happened to me right now. I sent an email, and is came back with: -- <ricardo.dua...@domain.pt>: host 127.0.0.1[127.0.0.1] said: 511 Recipient <ricardo.dua...@domain.pt> Permanent Failure Address Status Bad destination mailbox address (in reply to end of DATA command) -- Went to check the logs, and that's the same error. Well, people are seeing this return message when this problems ocorrs, which it's not good :( And the messages WAS NOT delivered to the receipient, I confirmed it. ---------------------------------------------------------------------- (0002859) netvulture (developer) - 28-Jul-09 06:15 http://dbmail.org/mantis/view.php?id=791#c2859 ---------------------------------------------------------------------- INSERT INTO dbmail_partlists (physmessage_id, is_header, part_key, part_depth, part_order, part_id) VALUES (3561592,1,6,0,0,7563359) This query appears to be failing. Can you check to see what you have in dbmail_partlists for physmessage_id=3561592 And also see what you have for dbmail_mimeparts id=7563359 Also - what is the select max(id) from dbmail_physmessage If the part pointer row can't be inserted, then message insertion will fail. Returning a 511 though for failure to insert should be changed to a 4xx temp error. ---------------------------------------------------------------------- (0002860) netvulture (developer) - 28-Jul-09 06:18 http://dbmail.org/mantis/view.php?id=791#c2860 ---------------------------------------------------------------------- Also - I see that the user has sieve script. Does it occur only for sieve script enabled users? Issue History Date Modified Username Field Change ====================================================================== 23-Jul-09 16:45 jasb New Issue 24-Jul-09 19:27 netvulture Note Added: 0002845 24-Jul-09 19:27 netvulture Assigned To => netvulture 24-Jul-09 19:27 netvulture Status new => feedback 27-Jul-09 16:06 jasb Note Added: 0002856 27-Jul-09 16:06 jasb File Added: lmtp size.txt 27-Jul-09 19:16 jasb Note Added: 0002857 27-Jul-09 19:17 jasb File Added: dbmail_error_getting_msg_size.txt 27-Jul-09 22:56 jasb Note Added: 0002858 27-Jul-09 22:58 jasb Note Edited: 0002858 28-Jul-09 06:15 netvulture Note Added: 0002859 28-Jul-09 06:15 netvulture Status feedback => acknowledged 28-Jul-09 06:18 netvulture Note Added: 0002860 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
