Mailing List Archive

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.
>
> .....EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
>
> Maintenance done. Errors were found and fixed.
>
> We suggest running dbmail-util again to confirm that all errors were
> repaired

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-bounces@dbmail.org [mailto:dbmail-bounces@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

Hi,

Sorry to pressure,

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


> -----Original Message-----
> From: dbmail-bounces@dbmail.org [mailto:dbmail-bounces@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-bounces@dbmail.org [mailto:dbmail-bounces@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

> Hi,
>
> Sorry to pressure,
>
> Any idea on this, on how to make the full sql query go to the log?

Hi Paul,

On this, I discovered that, on the rebuild after the query returns some
values

SELECT p.id FROM dbmail_physmessage p LEFT JOIN dbmail_header h ON p.id =
h.physmessage_id WHERE h.physmessage_id IS NULL

The query on the loop for the results, returns nothing:

mysql> SELECT b.messageblk, b.is_header, DATE_FORMAT(p.internal_date,
GET_FORMAT(DATETIME,'ISO')) FROM dbmail_messageblks b JOIN
dbmail_physmessage p ON b.physmessage_id=p.id WHERE b.physmessage_id =
12953193 ORDER BY b.messageblk_idnr;
Empty set (0.00 sec)

mysql> SELECT
l.part_key,l.part_depth,l.part_order,l.is_header,DATE_FORMAT(ph.internal_dat
e, GET_FORMAT(DATETIME,'ISO')),data FROM dbmail_mimeparts p JOIN
dbmail_partlists l ON p.id = l.part_id JOIN dbmail_physmessage ph ON ph.id =
l.physmessage_id WHERE l.physmessage_id = 12953193 ORDER BY
l.part_key,l.part_order ASC;
Empty set (0.01 sec)


Any idea?

_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail