The following bug has been CLOSED ====================================================================== http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000110 ====================================================================== Reported By: simonlange Assigned To: ====================================================================== Project: DBMail Bug ID: 110 Category: IMAP daemon Reproducibility: always Severity: major Priority: normal Status: closed ====================================================================== Date Submitted: 27-Oct-04 03:31 CEST Last Modified: 19-May-05 14:17 CEST ====================================================================== Summary: Huge load on mysql server Description: dbmail-imapd causes a massive amount of queries. a dozen logged ppl with an usual behavour do cause every couple of days upto 300.000queries per second! this is huge... this brings the whole system down since it causes a pretty high load on the system ======================================================================
---------------------------------------------------------------------- ilja - 24-Nov-04 16:20 CET ---------------------------------------------------------------------- IMAP does cause a lot of queries. Some speedups have already gone in (2.0.1), and more are on the way. ---------------------------------------------------------------------- ilja - 13-Dec-04 11:34 CET ---------------------------------------------------------------------- This has not been resolved at all, so I'm reopening this bug. ---------------------------------------------------------------------- paul - 30-Dec-04 10:05 CET ---------------------------------------------------------------------- I'm merging bugs 110 and 91 since they refer to the same problem. ---------------------------------------------------------------------- paul - 05-Jan-05 10:49 CET ---------------------------------------------------------------------- I think I found the problem. I got my hands on a looping imapd and noticed the sk argument to be 0x0 for every second iteration. This shouldn't happen. Empty searchkeys indicate end-of-search at best, and possibly even stack corruption. So I changed the return value on the if (!sk) check to return -2 (error). ---------------------------------------------------------------------- paul - 08-Jan-05 19:11 CET ---------------------------------------------------------------------- Ok. Together with SeanC I've nailed the sucker. Turns out the out-of-sync code in _ic_search was none functional. Now perform_imap_search will resync the cached mailbox data if an out-of-sync condition is encountered. I've also nailed a race condition in _ic_search which was probably causing the stack corruption in the search loops. So: no more looping imapd I hope. I'm setting this bug to resolved. If no-one complains over the next couple of days, I will close it. Bug History Date Modified Username Field Change ====================================================================== 27-Oct-04 03:31simonlange New Bug 24-Nov-04 16:20ilja Bugnote Added: 0000373 24-Nov-04 16:20ilja Status new => resolved 13-Dec-04 11:34ilja Bugnote Added: 0000445 13-Dec-04 11:34ilja Resolution open => reopened 13-Dec-04 11:34ilja Status resolved => feedback 30-Dec-04 10:05paul Bugnote Added: 0000479 30-Dec-04 10:05paul duplicate_id 0 => 91 05-Jan-05 10:49paul Bugnote Added: 0000486 08-Jan-05 19:11paul Bugnote Added: 0000492 08-Jan-05 19:13paul Resolution reopened => fixed 08-Jan-05 19:13paul Status feedback => resolved 19-May-05 14:17paul Status resolved => closed ======================================================================
