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
_______________________________________________ DBmail mailing list [email protected] https://lists.nfg.nl/cgi-bin/mailman/listinfo/dbmail
