Hello!
When I run dbmail-util with heavy system load like "dbmail-utul -ty"
or "'dbmail-utul -py" Dmail sometime return mail message with error
message:
+++
<[EMAIL PROTECTED]>: host 127.0.0.1[127.0.0.1] said: 511 Recipient
<[EMAIL PROTECTED]> Permanent Failure Address Status Bad destination mailbox
address (in reply to end of DATA command)
+++
where [EMAIL PROTECTED] is alias
dbmail.err contain:
Sep 17 14:17:29 newmail dbmail-lmtpd[4407]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [UPDATE dbmail_users SET
curmail_size = curmail_size + 632351
WHERE user_idnr = 25] : [ERROR: deadlock detected
DETAIL: Process 4408 waits for ShareLock on transaction 29882054;
blocked by process 4434.
Process 4434 waits for ShareLock on transaction 29882055; blocked by
process 4405.
Process 4405 waits for ExclusiveLock on tuple (240,1) of relation
17478 of database 17465; blocked by process 4408.
]
Sep 17 14:17:29 newmail dbmail-lmtpd[4407]: Error:[db]
db.c,db_copymsg(+3844): error setting the new quotum used value for
user [25]
Sep 17 14:17:29 newmail dbmail-lmtpd[4407]: Error:[sort]
sort.c,sort_deliver_to_mailbox(+192): error copying message to user
[25]
Sep 17 14:17:29 newmail dbmail-lmtpd[4407]: Error:[delivery]
pipe.c,insert_messages(+598): unknown temporary failure in
sort_and_deliver for useridnr [25]
Sep 17 14:17:29 newmail dbmail-lmtpd[4407]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT physmessage_id FROM
dbmail_messages WHERE message_idnr
= 1677109] : [ERROR: current transaction is aborted, commands
ignored until end of transaction block
]
Sep 17 14:17:29 newmail dbmail-lmtpd[4407]: Error:[db]
db.c,db_get_physmessage_id(+341): error getting physmessage_id
Sep 17 14:17:29 newmail dbmail-lmtpd[4407]: Error:[delivery]
pipe.c,insert_messages(+663): failed to delete temporary message
[1677109]
Sep 17 14:17:29 newmail dbmail-lmtpd[4433]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [UPDATE dbmail_users SET
curmail_size = curmail_size + 632351
WHERE user_idnr = 20] : [ERROR: deadlock detected
DETAIL: Process 4434 waits for ShareLock on transaction 29882055;
blocked by process 4405.
Process 4405 waits for ShareLock on transaction 29882054; blocked by
process 4434.
]
Sep 17 14:17:29 newmail dbmail-lmtpd[4433]: Error:[db]
db.c,db_copymsg(+3844): error setting the new quotum used value for
user [20]
Sep 17 14:17:29 newmail dbmail-lmtpd[4433]: Error:[sort]
sort.c,sort_deliver_to_mailbox(+192): error copying message to user
[20]
Sep 17 14:17:29 newmail dbmail-lmtpd[4433]: Error:[sort]
sortsieve.c,sort_fileinto(+340): Could not file message into mailbox;
not cancelling keep.
Sep 17 14:17:29 newmail dbmail-lmtpd[4433]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT mailbox_idnr FROM
dbmail_mailboxes WHERE name ILIKE 'I
NBOX' AND owner_idnr=20] : [ERROR: current transaction is aborted,
commands ignored until end of transaction block
]
Sep 17 14:17:29 newmail dbmail-lmtpd[4433]: Error:[db]
db.c,db_findmailbox_owner(+2724): could not select mailbox 'INBOX'
Sep 17 14:17:29 newmail dbmail-lmtpd[4433]: Error:[db]
db.c,db_findmailbox(+2623): error finding mailbox [INBOX] with owner
[(null), 20]
Sep 17 14:17:29 newmail dbmail-lmtpd[4433]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT mailbox_idnr FROM
dbmail_mailboxes WHERE name ILIKE 'I
NBOX' AND owner_idnr=20] : [ERROR: current transaction is aborted,
commands ignored until end of transaction block
]
Sep 17 14:17:29 newmail dbmail-lmtpd[4433]: Error:[db]
db.c,db_findmailbox_owner(+2724): could not select mailbox 'INBOX'
Sep 17 14:17:29 newmail dbmail-lmtpd[4433]: Error:[db]
db.c,db_findmailbox(+2623): error finding mailbox [INBOX] with owner
[(null), 20]
Sep 17 14:17:29 newmail dbmail-lmtpd[4433]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT mailbox_idnr FROM
dbmail_mailboxes WHERE name ILIKE 'I
NBOX' AND owner_idnr=20] : [ERROR: current transaction is aborted,
commands ignored until end of transaction block
]
Sep 17 14:17:29 newmail dbmail-lmtpd[4433]: Error:[db]
db.c,db_findmailbox_owner(+2724): could not select mailbox 'INBOX'
Sep 17 14:17:29 newmail dbmail-lmtpd[4433]: Error:[db]
db.c,db_findmailbox(+2623): error finding mailbox [INBOX] with owner
[(null), 20]
Sep 17 14:17:29 newmail dbmail-lmtpd[4433]: Error:[db]
db.c,db_mailbox_create_with_parents(+3230): Negative return code from
db_imap_split_mailbox.
Sep 17 14:17:29 newmail dbmail-lmtpd[4433]: Error:[db]
db.c,db_find_create_mailbox(+3448): could not create mailbox [INBOX]
because [Internal database error
while looking for mailbox]
Sep 17 14:17:29 newmail dbmail-lmtpd[4433]: Error:[sort]
sort.c,sort_deliver_to_mailbox(+130): mailbox [INBOX] not found
Sep 17 14:17:30 newmail dbmail-imapd[31701]: Error:[imap]
imap4.c,IMAPClientHandler(+139): [Illegal seek] on read-stream
Sep 17 14:17:30 newmail dbmail-lmtpd[4433]: Error:[delivery]
pipe.c,insert_messages(+587): permanent failure sort_and_deliver for
useridnr [20]
Sep 17 14:17:31 newmail dbmail-lmtpd[4433]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT physmessage_id FROM
dbmail_messages WHERE message_idnr
= 1677107] : [ERROR: current transaction is aborted, commands
ignored until end of transaction block
]
Sep 17 14:17:31 newmail dbmail-lmtpd[4433]: Error:[db]
db.c,db_get_physmessage_id(+341): error getting physmessage_id
Sep 17 14:17:31 newmail dbmail-lmtpd[4433]: Error:[delivery]
pipe.c,insert_messages(+663): failed to delete temporary message
[1677129]
Sep 17 14:17:48 newmail dbmail-imapd[21969]: Error:[imap]
imap4.c,IMAPClientHandler(+139): [Illegal seek] on read-stream
When I resend same mail later, all is OK.
My configuration:
Debian Etch
DBMAIL 2.2.6-rc2 from repoitory
PostgreSQL 8.1
Mail Messages: 454169
DB size 12GB
Edvins
P.S. sorry for My English
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
