A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=390 ====================================================================== Reported By: jnorell Assigned To: ====================================================================== Project: DBMail Issue ID: 390 Category: Command-Line programs (dbmail-users, dbmail-util) Reproducibility: always Severity: block Priority: normal Status: new target: ====================================================================== Date Submitted: 03-Aug-06 20:19 CEST Last Modified: 04-Aug-06 20:11 CEST ====================================================================== Summary: DEF_QUERYSIZE too small Description: DEF_QUERYSIZE is currently 1024, causing db_set_isheader() to fail during dbmail-util -ay.
Repairing DBMAIL for incorrect is_header flags... Ok. Found [4291] incorrect is_header flags. Error dbpgsql.c, db_query: Error executing query [UPDATE dbmail_messageblks SET is_header = '1' WHERE messageblk_idnr IN (93793903,98060014,98077374,99083639,99084409,99198119,99198261,99219437,99546559,99911465,101252056,101268114,101707614,102670265,102927551,103668187,103715340,104823570,105023569,105178339,106255768,107202646,107271147,109169596,109198078,109670036,109863443,109868049,109884055,109903270,109911632,109912467,109914168,109928479,109938422,109945972,109953386,109962557,109966403,109986404,109993587,110017640,110018292,110028237,110033708,110036495,110054553,110056874,110060590,110066643,110067484,110077596,110077753,110078354,110086154,110130349,110130776,110143373,110144375,110158164,110160247,110167293,110169681,110187387,110210148,110211965,110212061,110223102,110223960,110225223,110235523,110243032,110254844,110260252,110268562,110330175,110429441,110551666,110667559,110775322,110859792,110883271,110896930,110921282,110930608,110946869,110956154,110980251,110990557,111030305,111033592,111040643,111057696,111093491,111119017,111143880,1] : [ERROR: syntax error at end of input at character 1024 ] Error db.c,db_set_isheader: could not access messageblks table Error setting the is_header flags ====================================================================== ---------------------------------------------------------------------- aaron - 04-Aug-06 12:41 ---------------------------------------------------------------------- I count 96 commas in that query. Tell me if changing the value 100 in the call to g_list_slices down to, say, 90 fixes this. You'll probably have to zap all of the is_header values before testing it again. ---------------------------------------------------------------------- jnorell - 04-Aug-06 20:11 ---------------------------------------------------------------------- Yeah, cutting down to 90 gets that to run. To size the correctly, what's the largest (in # digits) numbers that would ever be there? We've got 9 digits, but if you had 10, that would again go over the 1024 chars. Issue History Date Modified Username Field Change ====================================================================== 03-Aug-06 20:19 jnorell New Issue 04-Aug-06 12:41 aaron Note Added: 0001330 04-Aug-06 20:11 jnorell Note Added: 0001331 ======================================================================
