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
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