The following issue has been UPDATED. ====================================================================== http://dbmail.org/mantis/view.php?id=619 ====================================================================== Reported By: asianux-keith Assigned To: ====================================================================== Project: DBMail Issue ID: 619 Category: Database layer Reproducibility: always Severity: major Priority: normal Status: new target: ====================================================================== Date Submitted: 04-Jul-07 03:39 CEST Last Modified: 04-Jul-07 10:32 CEST ====================================================================== Summary: sqlite locking: "sqlite3_get_table failed" results in msgs not being inserted into db, msgs bounced. Description: When sending a message from thunderbird or evolution to a server with postfix and dbmail 2.2.5 and a sqlite(3) backend, the messages are often not delivered because dbmail-smtp/lmtp cannot lock/write to the sqlite db. Non-delivered msgs bounce.
In each test, a msg is crafted with three local TO: address (including self). 1st test: (logfile sqlite-non-delivery-log.txt) dbmail-lmtp, dbmail-imapd and dbmail-pop3d are all running. The client sending the msg uses imap. One receiving client is imap, and the other is pop. postfix uses dbmail-smtp to deliver. 2nd test: (logfile sqlite-lmtp-non-delivery-log.txt) dbmail-lmtp, dbmail-imapd and dbmail-pop3d are all running. The client sending the msg uses imap. One receiving client is imap, and the other is pop. postfix uses dbmail-lmtp to deliver. 3rd test: (logfile sqlite-pop_only-non-delivery-log.txt) only dbmail-pop3d is running. The client sending the msg uses pop. Two receiving clients are imap. postfix uses dbmail-smtp to deliver. ====================================================================== ---------------------------------------------------------------------- paul - 04-Jul-07 10:32 ---------------------------------------------------------------------- I've added a retry loop to the sqlite code to help deal with these situation. Please try the attached patch. Also: try to lower the concurrency settings in postfix's master.cf. Set the width of the lmtp and pipe transports to 1. Issue History Date Modified Username Field Change ====================================================================== 04-Jul-07 03:39 asianux-keith New Issue 04-Jul-07 10:32 paul Note Added: 0002282 ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
