Hi, Sorry to pressure,
Any idea on this, on how to make the full sql query go to the log? > -----Original Message----- > From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On > Behalf Of Jorge Bastos > Sent: quinta-feira, 8 de Janeiro de 2015 00:07 > To: 'DBMail mailinglist' > Subject: Re: [Dbmail] Rebuilding headercache > > 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 _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
