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 10:30 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? ---------------------------------------------------------------------- (0002861) jasb (reporter) - 28-Jul-09 10:30 http://dbmail.org/mantis/view.php?id=791#c2861 ---------------------------------------------------------------------- Can you check to see what you have in dbmail_partlists for physmessage_id=3561592 -- select * from dbmail_partlists where physmessage_id=3561592; "3561592, 1, 6, 0, 0, 7563359" -- And also see what you have for dbmail_mimeparts id=7563359 -- select * from dbmail_mimeparts where id=7563359; "7563359, '0d1a592e0654d5c837091b1b27190710c07cd502', '', 1441" -- Also - what is the select max(id) from dbmail_physmessage -- select max(id) from dbmail_physmessage; "3562712" -- ------------------------------------- So, it seems that there's something messing up the ID's no? maybe when two messages are beeing inserted at the same exact time, and they both get the same ID? About the sieve part, have to confirm, but for this particular user it doesnit have any sieve script. 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 28-Jul-09 10:30 jasb Note Added: 0002861 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev