A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=870 ====================================================================== Reported By: cmayo Assigned To: paul ====================================================================== Project: DBMail Issue ID: 870 Category: IMAP daemon Reproducibility: always Severity: major Priority: normal Status: acknowledged target: ====================================================================== Date Submitted: 02-Jan-11 19:14 CET Last Modified: 03-Jan-11 19:24 CET ====================================================================== Summary: Empty entries in Thunderbird message list after database query timeout Description: libzdb hardcodes a default query timeout of 3 seconds which is not enough time to run the query for me to retrieve all the messages in a large folder.
Probably I should tune my database better or just reduce the size of some of my folders! But, attached a patch that sprinkles a few Connection_setQueryTimeout()'s into dm_db.c that seems to fix it for me. More than one needed as libzdb resets timeout to default in several places e.g. Connection_clear. This kind of fix would probably be better be done in libzdb itself by allowing a configurable default query timeout. I had a similar issue with recreating all the header fields on the conversion from 2.2 to 3.0 and temporarily stuck a: Connection_setQueryTimeout(c, 0) in _header_value_insert(). Surely this timeout sets an upper bound for the configuration values: query_time_info, query_time_notice, query_time_warning Maybe this is the issue with bug http://www.dbmail.org/mantis/view.php?id=815? http://www.dbmail.org/mantis/view.php?id=815 ====================================================================== ---------------------------------------------------------------------- (0003133) paul (administrator) - 02-Jan-11 22:31 http://www.dbmail.org/mantis/view.php?id=870#c3133 ---------------------------------------------------------------------- Thanks for the report. I'm not clear why this didn't show up earlier. I can't accept the patch as is. This should be fixed elsewhere: all queries must obey the dbmail query_timeout value! ---------------------------------------------------------------------- (0003134) cmayo (reporter) - 03-Jan-11 19:24 http://www.dbmail.org/mantis/view.php?id=870#c3134 ---------------------------------------------------------------------- Fair enough. I do need this, so just in case it is of use to anyone else - at their risk (should especially check the maths of converting ms to s) Here's a tidied up patch that I am using that implements a query_timeout value. Issue History Date Modified Username Field Change ====================================================================== 02-Jan-11 19:14 cmayo New Issue 02-Jan-11 19:14 cmayo File Added: dbmail-3.0.0_rc1-timeout.patch 02-Jan-11 22:31 paul Note Added: 0003133 02-Jan-11 22:31 paul Assigned To => paul 02-Jan-11 22:31 paul Status new => acknowledged 02-Jan-11 22:31 paul Projection none => tweak 03-Jan-11 19:24 cmayo Note Added: 0003134 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev