bugtrack at dbmail
Jul 29, 2009, 3:50 AM
Post #11 of 13
(2265 views)
Permalink
|
|
[DBMail 0000791]: Several LMTPD problems on delevery
[In reply to]
|
|
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: 29-Jul-09 12:50 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.duarte [at] domain>: host 127.0.0.1[127.0.0.1] said: 511 Recipient
<ricardo.duarte [at] domain> 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.
----------------------------------------------------------------------
(0002862) jasb (reporter) - 28-Jul-09 15:50
http://dbmail.org/mantis/view.php?id=791#c2862
----------------------------------------------------------------------
The next error after that, was from a user with a sieve script.
A simple script as this:
---
require
["fileinto","envelope","reject","vacation","relational","comparator-i;ascii-numeric","regex"];
if
header :contains "Subject" "*****SPAM*****"
{
discard;
---
Well, the problem is in users with and without sieve scripts, so this may
not be the problem.
----------------------------------------------------------------------
(0002864) netvulture (developer) - 29-Jul-09 05:28
http://dbmail.org/mantis/view.php?id=791#c2864
----------------------------------------------------------------------
I cannot duplicate this issue. There is nothing in the logs to indicate why
it is thinking it could not store mimepart or the partlist rows. From your
response, we can see that it did succeed with inserting the partlist and
the mimepart already exists as well. Will have to look at adding some
additional logging to the process to determine what the issue is.
----------------------------------------------------------------------
(0002881) jasb (reporter) - 29-Jul-09 12:50
http://dbmail.org/mantis/view.php?id=791#c2881
----------------------------------------------------------------------
Jon,
When you have that extra info to make it more "verbose debugable" tell
me.
Anyway, the message that is with those ID's, it's the message that was
sent and gave error. The user didn't received the message on his INBOX.
I'm not sure about it but, it seems that two diferrent threads catch the
same ID and tried to insert the message with that ID.
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
28-Jul-09 15:50 jasb Note Added: 0002862
29-Jul-09 05:28 netvulture Note Added: 0002864
29-Jul-09 12:50 jasb Note Added: 0002881
======================================================================
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
|
