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 21:00 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:31 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 s to ms) Here's a tidied up patch that I am using that implements a query_timeout value. ---------------------------------------------------------------------- (0003135) paul (administrator) - 03-Jan-11 21:00 http://www.dbmail.org/mantis/view.php?id=870#c3135 ---------------------------------------------------------------------- Hi there, I just pushed a change today to fix this. Config setup is almost /exactly/ the same as your patch, btw. But I selected other locations for setting the timeout that covers /all/ queries: http://git.dbmail.eu/paul/dbmail/commit/?id=06be17a485b3d33cc443a32c91f21ac82439cb10 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 03-Jan-11 19:25 cmayo File Added: dbmail-3.0.0_rc1-query_timeout.patch 03-Jan-11 19:31 cmayo Note Edited: 0003134 03-Jan-11 21:00 paul Note Added: 0003135 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev