Hi reindl, Jan 8 00:00:23 lira dbmail/maintenance[1195]: Database:[db] db_con_close(+291): [0x8c25dd0] connection to pool Jan 8 00:00:23 lira dbmail/maintenance[1195]: Error:[message] dbmail_message_retrieve(+1070): retrieval failed for physid [13211157] Jan 8 00:00:23 lira dbmail/maintenance[1195]: Warning:[db] db_set_envelope(+1685): error retrieving physmessage: [13211157]
And then: Jan 8 00:02:39 lira dbmail/maintenance[1195]: Database:[db] db_con_close(+291): [0x8c25dd0] connection to pool Jan 8 00:02:39 lira dbmail/maintenance[1195]: Debug:[message] dbmail_message_set_internal_date(+824): internal_date [2009-07-10 10:44:00] [1247222640] offset [0] Jan 8 00:02:39 lira dbmail/maintenance[1195]: Error:[message] dbmail_message_cache_headers(+1324): self->content is not a message Jan 8 00:02:39 lira dbmail/maintenance[1195]: Warning:[db] db_set_headercache(+1621): error caching headers for physmessage: [3460623] How to track this? I remember some discursion on how to put the full queries on the logs, do you remember what's needed to tune? Never noted that down since never nedeed :( I'd like to run the query manually to see the result, I think that would give me the real reason of it. > -----Original Message----- > From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On > Behalf Of Reindl Harald > Sent: quarta-feira, 7 de Janeiro de 2015 14:21 > To: dbmail@dbmail.org > Subject: Re: [Dbmail] Rebuilding headercache > > file_logging_levels = 511 and look in *both* logsfiles > > i guess that's the same i reported multiple times here like > "SQLException: Incorrect string value" or envelope too long > > Am 07.01.2015 um 15:15 schrieb Jorge Bastos: > > How could I know the origin of this errors when rebuilding cached > tables? > > > > lira:/etc/cron.hourly# dbmail-util -by > > > > Repairing DBMAIL for rfcsize field... > > > > Ok. Found [4] missing rfcsize values. > > > > EEEE > > > > Repairing DBMAIL for cached envelopes... > > > > Ok. Found [12] missing envelope values. > > > > .......EEEEE > > > > Repairing DBMAIL for cached header values... > > > > Ok. Found [347] un-cached physmessages. > > > > > .....EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE > > > EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE > > > EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE > > > EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE > > EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE > > > > Maintenance done. Errors were found and fixed. > > > > We suggest running dbmail-util again to confirm that all errors were > > repaired > > _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail