Re: Physmessage missing
David in Denver <[email protected]> Thu, 31 Dec 2020 04:23:59 +0000
| Newsgroups | gmane.mail.imap.dbmail |
|---|---|
| Message-ID | <CY4PR15MB1240740AEEDCE69FF920EE19B4D60@CY4PR15MB1240.namprd15.prod.outlook.com> |
--===============5486029656230397104== Content-Language: en-US Content-Type: multipart/alternative; boundary="_000_CY4PR15MB1240740AEEDCE69FF920EE19B4D60CY4PR15MB1240namp_" --_000_CY4PR15MB1240740AEEDCE69FF920EE19B4D60CY4PR15MB1240namp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable as far as I can tell, no one is supporting dbmail anymore. I tried for a m= onth 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 <[email protected]> on behalf of Pascal Longrais <pa= [email protected]> Sent: Wednesday, December 30, 2020 2:44 AM To: [email protected] <[email protected]> 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/mis= sing [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_physmes= sage p ON b.physmessage_id=3Dp.id WHERE b.physmessage_id =3D 63704 ORDER BY= b.messageblk_idnr] Dec 30 10:31:40 gen8 dbmail/maintenance[15829]: Error:[message] dbmail_mess= age_retrieve(+1093): retrieval failed for physid [63704] Dec 30 10:31:40 gen8 dbmail/maintenance[15829]: Warning:[db] db_set_envelop= e(+1830): error retrieving physmessage: [63704] Do someone have a way to repair ? Thanks & Greetings --_000_CY4PR15MB1240740AEEDCE69FF920EE19B4D60CY4PR15MB1240namp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <html> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-= 1"> <style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo= ttom:0;} </style> </head> <body dir=3D"ltr"> <div style=3D"font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;= color: rgb(0, 0, 0);"> as far as I can tell, no one is supporting dbmail anymore. I tried fo= r a month to install a version on linux Debian Lenny, and I couldn't get an= yone 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.</div> <div> <div id=3D"appendonsend"></div> <div style=3D"font-family:Calibri,Helvetica,sans-serif; font-size:12pt; col= or:rgb(0,0,0)"> <br> </div> <hr tabindex=3D"-1" style=3D"display:inline-block; width:98%"> <div id=3D"divRplyFwdMsg" dir=3D"ltr"><font face=3D"Calibri, sans-serif" co= lor=3D"#000000" style=3D"font-size:11pt"><b>From:</b> DBmail <dbmail-bou= [email protected]> on behalf of Pascal Longrais <pascal.longrais@oran= ge.fr><br> <b>Sent:</b> Wednesday, December 30, 2020 2:44 AM<br> <b>To:</b> [email protected] <[email protected]><br> <b>Subject:</b> [Dbmail] Physmessage missing</font> <div> </div> </div> <div> <p><font face=3D"monospace">Hello,</font></p> <p><font face=3D"monospace">Since sometimes DBmail (3.2.3) is reporting man= y SQLException errors.</font></p> <p><font face=3D"monospace">When performing a maintenance, it appears a phy= sical message is corrupt/missing [63704].</font></p> <p><font face=3D"Consolas">Dec 30 10:31:40 gen8 dbmail/maintenance[15829]: = Error:[db] db_query(+421): SQLException:<br> </font></p> <font face=3D"Consolas">Dec 30 10:31:40 gen8 dbmail/maintenance[15829]: Err= or:[db] db_query(+422): failed query [SELECT b.messageblk, b.is_header, DAT= E_FORMAT(p.internal_date, GET_FORMAT(DATETIME,'ISO')) FROM dbmail_messagebl= ks b JOIN dbmail_physmessage p ON b.physmessage_id=3Dp.id WHERE b.physmessage_id =3D 63704 ORDER BY b.messag= eblk_idnr]</font><br> <font face=3D"Consolas"></font><br> <font face=3D"Consolas">Dec 30 10:31:40 gen8 dbmail/maintenance[15829]: Err= or:[message] dbmail_message_retrieve(+1093): retrieval failed for physid [6= 3704]</font><br> <br> <font face=3D"Consolas">Dec 30 10:31:40 gen8 dbmail/maintenance[15829]: War= ning:[db] db_set_envelope(+1830): error retrieving physmessage: [63704]</fo= nt><br> <br> <p><font face=3D"monospace">Do someone have a way to repair ?</font></p> <p><font face=3D"monospace">Thanks & Greetings</font><br> </p> </div> </div> </body> </html> --_000_CY4PR15MB1240740AEEDCE69FF920EE19B4D60CY4PR15MB1240namp_-- --===============5486029656230397104== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: inline X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KREJtYWlsIG1h aWxpbmcgbGlzdApEQm1haWxAbGlzdHMubmZnLm5sCmh0dHBzOi8vbGlzdHMubmZnLm5sL2NnaS1i aW4vbWFpbG1hbi9saXN0aW5mby9kYm1haWwK --===============5486029656230397104==--