Physmessage missing
Pascal Longrais <[email protected]> Wed, 30 Dec 2020 10:44:44 +0100
| Newsgroups | gmane.mail.imap.dbmail |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format.
--===============8556169150901592121==
Content-Type: multipart/alternative;
boundary="------------B50F5CB74D196A41EA2EDE9A"
Content-Language: en-US
This is a multi-part message in MIME format.
--------------B50F5CB74D196A41EA2EDE9A
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
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
--------------B50F5CB74D196A41EA2EDE9A
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p><font face="monospace">Hello,</font></p>
<p><font face="monospace">Since sometimes DBmail (3.2.3) is
reporting many SQLException errors.</font></p>
<p><font face="monospace">When performing a maintenance, it appears
a physical message is corrupt/missing [63704].</font></p>
<p><font face="Consolas">Dec 30 10:31:40 gen8
dbmail/maintenance[15829]: Error:[db] db_query(+421):
SQLException:<br>
</font></p>
<font face="Consolas">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]</font><br>
<font face="Consolas"></font><br>
<font face="Consolas">Dec 30 10:31:40 gen8
dbmail/maintenance[15829]: Error:[message]
dbmail_message_retrieve(+1093): retrieval failed for physid
[63704]</font><br>
<br>
<font face="Consolas">Dec 30 10:31:40 gen8
dbmail/maintenance[15829]: Warning:[db] db_set_envelope(+1830):
error retrieving physmessage: [63704]</font><br>
<br>
<p><font face="monospace">Do someone have a way to repair ?</font></p>
<p><font face="monospace">Thanks & Greetings</font><br>
</p>
</body>
</html>
--------------B50F5CB74D196A41EA2EDE9A--
--===============8556169150901592121==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: base64
Content-Disposition: inline
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KREJtYWlsIG1h
aWxpbmcgbGlzdApEQm1haWxAbGlzdHMubmZnLm5sCmh0dHBzOi8vbGlzdHMubmZnLm5sL2NnaS1i
aW4vbWFpbG1hbi9saXN0aW5mby9kYm1haWwK
--===============8556169150901592121==--