Re: Rebuilding headercache

Hi,

Sorry to pressure,

Any idea on this, on how to make the full sql query go to the log?


> -----Original Message-----
> From: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:[email protected]] On
> > Behalf Of Reindl Harald
> > Sent: quarta-feira, 7 de Janeiro de 2015 14:21
> > To: [email protected]
> > 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
> [email protected]
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail