Mailing List Archive

Physmessage missing
Hello,

Since sometimes DBmail (3.2.3) is reporting many SQLException errors.

When performing a maintenance, it appears a physical message is
corrupt/missing [63704].

Dec 30 10:31:40 gen8 dbmail/maintenance[15829]: Error:[db]
db_query(+421): SQLException:

Dec 30 10:31:40 gen8 dbmail/maintenance[15829]: Error:[db]
db_query(+422): failed query [.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 = 63704 ORDER BY b.messageblk_idnr]

Dec 30 10:31:40 gen8 dbmail/maintenance[15829]: Error:[message]
dbmail_message_retrieve(+1093): retrieval failed for physid [63704]

Dec 30 10:31:40 gen8 dbmail/maintenance[15829]: Warning:[db]
db_set_envelope(+1830): error retrieving physmessage: [63704]

Do someone have a way to repair ?

Thanks & Greetings
Re: Physmessage missing [ In reply to ]
as far as I can tell, no one is supporting dbmail anymore. I tried for a month to install a version on linux Debian Lenny, and I couldn't get anyone to answer even basic .config questions; and that was after having had a 2.x version installed and running beautifully on a box 5 years ago.

________________________________
From: DBmail <dbmail-bounces@lists.nfg.nl> on behalf of Pascal Longrais <pascal.longrais@orange.fr>
Sent: Wednesday, December 30, 2020 2:44 AM
To: dbmail@lists.nfg.nl <dbmail@lists.nfg.nl>
Subject: [Dbmail] Physmessage missing


Hello,

Since sometimes DBmail (3.2.3) is reporting many SQLException errors.

When performing a maintenance, it appears a physical message is corrupt/missing [63704].

Dec 30 10:31:40 gen8 dbmail/maintenance[15829]: Error:[db] db_query(+421): SQLException:

Dec 30 10:31:40 gen8 dbmail/maintenance[15829]: Error:[db] db_query(+422): failed query [.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 = 63704 ORDER BY b.messageblk_idnr]

Dec 30 10:31:40 gen8 dbmail/maintenance[15829]: Error:[message] dbmail_message_retrieve(+1093): retrieval failed for physid [63704]

Dec 30 10:31:40 gen8 dbmail/maintenance[15829]: Warning:[db] db_set_envelope(+1830): error retrieving physmessage: [63704]


Do someone have a way to repair ?

Thanks & Greetings
Re: Physmessage missing [ In reply to ]
El 12/30/20 a las 3:44 AM, Pascal Longrais escribió:
>
> Dec 30 10:31:40 gen8 dbmail/maintenance[15829]: Error:[message]
> dbmail_message_retrieve(+1093): retrieval failed for physid [63704]
>
> Dec 30 10:31:40 gen8 dbmail/maintenance[15829]: Warning:[db]
> db_set_envelope(+1830): error retrieving physmessage: [63704]
>
> Do someone have a way to repair ?
>
delete from dbmail_physmessage where id = 63704;