The following issue has been CLOSED ====================================================================== http://www.dbmail.org/mantis/view.php?id=498 ====================================================================== Reported By: Anne Assigned To: ====================================================================== Project: DBMail Issue ID: 498 Category: general delivery Reproducibility: always Severity: major Priority: normal Status: closed target: Resolution: no change required Fixed in Version: ====================================================================== Date Submitted: 24-Jan-07 10:27 CET Last Modified: 30-Jan-07 20:35 CET ====================================================================== Summary: some messages are empty, both pop and imap Description: Some messages which were received last night are empty!
Thunderbird IMAP: some messages are completely empty, date 1-1-1970 1:00 Squirrelmail: (no subject), date seems ok, clicking on message: Error retrieving contents (translated) POP: some messages are completely empty I ran dbmail-util -by I saw some 'insert into ...' errors as reported in bug 0000486 Next I ran dbmail-util -tuby: Opening connection to database... Opening connection to authentication... Ok. Connected. Repairing DBMAIL messageblocks integrity... Ok. Found [0] unconnected messageblks. Checking DBMAIL message integrity... Ok. Found [0] unconnected messages. Checking DBMAIL mailbox integrity... Ok. Found [0] unconnected mailboxes. Repairing DBMAIL for NULL messages... Ok. Found [0] NULL messages. Checking DBMAIL for NULL physmessages... Ok. Found [0] physmessages without messageblocks. Repairing DBMAIL for rfcsize field... Ok. Found [0] missing rfcsize values. Repairing DBMAIL for incorrect is_header flags... Ok. Found [0] incorrect is_header flags. Repairing DBMAIL for cached envelopes... Ok. Found [0] missing envelope values. Repairing DBMAIL for cached header values... Ok. Found [0] un-cached physmessages. Maintenance done. No errors found. Still the same problem. HELP! ====================================================================== ---------------------------------------------------------------------- Anne - 24-Jan-07 10:31 ---------------------------------------------------------------------- Meanwhile I've stopped all dbmail services to avoid customers getting empty messages. ---------------------------------------------------------------------- Anne - 24-Jan-07 10:32 ---------------------------------------------------------------------- Another note: / filesystem was full but the database is on /usr and /var which are separate filesystems with plenty of space. I doubt this was a problem. ---------------------------------------------------------------------- Anne - 24-Jan-07 10:53 ---------------------------------------------------------------------- Please let me know how to debug. I need to find out first if these empty messages can be salvated. If so, I won't startup the services until it's fixed. But if the messages are lost anyway I might as well startup everything. Lots of customers waiting..... ---------------------------------------------------------------------- Anne - 24-Jan-07 11:09 ---------------------------------------------------------------------- The empty messages all have a physical message size of 103. ---------------------------------------------------------------------- aaron - 24-Jan-07 18:01 ---------------------------------------------------------------------- As repeatedly noted on the mailing list, you need to set trace_syslog=5 in dbmail.conf, make sure you have disk space to capture those extremely verbose logs, restart the services to pick up the new trace level, do something to trigger the bug you are reporting, and then attach the logs to the bug (please do not paste them into the comments, please do attach a file, bz/g/zipped if it is very large). ---------------------------------------------------------------------- aaron - 24-Jan-07 18:03 ---------------------------------------------------------------------- As an aside, if you have customers, you owe it to them to have a backup server. I don't owe your customers anything; they're not paying me! We'll fix this bug as quickly as we can, because we fix all bugs as quickly as we can. If you need it fixed in a deadline, Paul and Lars are selling very good support services at dbmail.eu. ---------------------------------------------------------------------- Anne - 24-Jan-07 18:39 ---------------------------------------------------------------------- I actually typed something horribly wrong: "I won't start up the services until it's fixed." should have been "I won't start up the services until it's safe to do so" Of course I won't expect you to fix it asap because it's indeed my problem, not yours. I hope this clears things up :-) Concerning your remark about having a backup server, I will post a message on the list. ---------------------------------------------------------------------- paul - 30-Jan-07 20:35 ---------------------------------------------------------------------- I'm closing this bug. Clearly not a reproducable dbmail bug at all. Issue History Date Modified Username Field Change ====================================================================== 24-Jan-07 10:27 Anne New Issue 24-Jan-07 10:31 Anne Note Added: 0001778 24-Jan-07 10:32 Anne Note Added: 0001779 24-Jan-07 10:53 Anne Note Added: 0001780 24-Jan-07 11:08 Anne Note Added: 0001781 24-Jan-07 11:09 Anne Note Edited: 0001781 24-Jan-07 18:01 aaron Note Added: 0001788 24-Jan-07 18:03 aaron Note Added: 0001789 24-Jan-07 18:39 Anne Note Added: 0001790 30-Jan-07 20:35 paul Note Added: 0001795 30-Jan-07 20:35 paul Status new => closed 30-Jan-07 20:35 paul Resolution open => no change required ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
