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

Reply via email to