Re: SQLException: Incorrect string value
Maxim <[email protected]> Sun, 7 Oct 2018 13:04:04 +0300
| Newsgroups | gmane.mail.imap.dbmail |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --===============2117318539== Content-Type: multipart/alternative; boundary=------------A908064D960911EC63315988 Content-Language: ru This is a multi-part message in MIME format. --------------A908064D960911EC63315988 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable I use Posgres, now I switched to version 10, it works much faster. dbmail-utils almost never use, sql scripts directly run faster and more=20 reliably. sorry, but also thought about switching to dovecot. 05.10.18 22:30, Reindl Harald (mobile) =D0=BF=D0=B8=D1=88=D0=B5=D1=82: > MariaDB 10.2.18 but that issue exists virtually forever and predates Ma= riaDB > > I don't get what is that hard to handle database input properly and no = you can't reject non rfc conform messages on postfix side as long the ser= ver is not for personal use > > when dbmail-util is not able to cleanup stuff which cannot be handled i= t is a major bug and I am tired of turn on debug logging to get the fucki= ng physical ID for delete the record (and so the whole) message by hand a= fter all that years > > Am 5. Oktober 2018 21:09:28 MESZ schrieb Maxim <[email protected]>: >> which DBMS do you use? >> >> 05.10.18 14:52, Reindl Harald =D0=BF=D0=B8=D1=88=D0=B5=D1=82: >>> that there is a invalid char in a header is one thing, but that >> dbmail >>> produces non-recovery errors in that case sucks >>> >>> <147609553.1537264268556.JavaMail.=C3=BDkids2@oekids-server> >>> "<[email protected]>")] >>> >>> Oct 05 13:36:09 mail.thelounge. dbmail-util[200378]: [0x562cfcc0a600] >>> Error:[message] dbmail_message_cache_envelope(+1844): SQLException: >>> Incorrect string value: '\xFDkids2...' for column 'envelope' at row 1 >>> >>> Am 05.10.18 um 11:51 schrieb Reindl Harald: >>>> this sucks for years >>>> >>>> * why does this happen at all >>>> * why no output of database-id instead a dot >>>> * why no dbmail-util switch "kill messages you can't handle" >>>> * why spit lines with breaks into maillog confusing mailgraph >>>> ------------------------------ >>>> >>>> Ok. Found [3] missing envelope values. >>>> ... >>>> Maintenance done. Errors were found and fixed. >>>> We suggest running dbmail-util again to confirm that all errors were >>>> repaired. >>>> Ok. Found [3] missing envelope values. >>>> ... >>>> Maintenance done. Errors were found and fixed. >>>> We suggest running dbmail-util again to confirm that all errors were >>>> repaired. >>>> Ok. Found [3] missing envelope values. >>>> ... >>>> Maintenance done. Errors were found and fixed. >>>> We suggest running dbmail-util again to confirm that all errors were >>>> repaired. >>>> >>>> ------------------------------ >>>> >>>> Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message] >>>> dbmail_message_cache_envelope(+1844): SQLException: Incorrect string >>>> value: '\xFDkids2...' for column 'envelope' at row 1 >>>> Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message] >>>> dbmail_message_cache_envelope(+1846): insert envelope failed [("Tue, >> 02 >>>> Oct 2018 19:07:51 +0000" >> "=3D?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=3D >>>> =3D?UTF-8?Q?ktobe >>>> Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message] >>>> dbmail_message_cache_envelope(+1844): SQLException: Incorrect string >>>> value: '\xFDkids2...' for column 'envelope' at row 1 >>>> Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message] >>>> dbmail_message_cache_envelope(+1846): insert envelope failed [("Tue, >> 18 >>>> Sep 2018 10:26:26 +0000" {159} >>>> =3D?UTF-8?Q?Fw:_Einladung_zum_Vortrag_"Focusing_und_kre >>>> Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message] >>>> dbmail_message_cache_envelope(+1844): SQLException: Incorrect string >>>> value: '\xFDkids2...' for column 'envelope' at row 1 >>>> Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message] >>>> dbmail_message_cache_envelope(+1846): insert envelope failed [("Tue, >> 11 >>>> Sep 2018 12:49:54 +0000" "[SPAM] >>>> =3D?UTF-8?Q?Fw:_Einladung_zum_Jour_Fixe_am?=3D =3D?UTF-8?Q >>>> Oct 5 11:45:55 mail dbmail/maintenance[190013]: Error:[message] >>>> dbmail_message_cache_envelope(+1844): SQLException: Incorrect string >>>> value: '\xFDkids2...' for column 'envelope' at row 1 >>>> Oct 5 11:45:55 mail dbmail/maintenance[190013]: Error:[message] >>>> dbmail_message_cache_envelope(+1846): insert envelope failed [("Tue, >> 02 >>>> Oct 2018 19:07:51 +0000" >> "=3D?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=3D >>>> =3D?UTF-8?Q?ktobe >>>> Oct 5 11:45:55 mail dbmail/maintenance[190013]: Error:[message] >>>> dbmail_message_cache_envelope(+1844): SQLException: Incorrect string >>>> value: '\xFDkids2...' for column 'envelope' at row 1 >>>> Oct 5 11:45:55 mail dbmail/maintenance[190013]: Error:[message] >>>> dbmail_message_cache_envelope(+1846): insert envelope failed [("Tue, >> 18 >>>> Sep 2018 10:26:26 +0000" {159} >>>> =3D?UTF-8?Q?Fw:_Einladung_zum_Vortrag_"Focusing_und_kre > _______________________________________________ > DBmail mailing list > [email protected] > http://lists.nfg.nl/mailman/listinfo/dbmail --------------A908064D960911EC63315988 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <html> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dutf= -8"> </head> <body text=3D"#000000" bgcolor=3D"#FFFFFF"> <div class=3D"moz-cite-prefix"><br> <span id=3D"result_box" class=3D"" tabindex=3D"-1" lang=3D"en"><spa= n>I use Posgres, now I switched to version 10, it works much faster.</s= pan><br> <span>dbmail-utils almost never use, sql scripts directly run faster and more reliably.</span></span><br> <br> <span id=3D"result_box" class=3D"" tabindex=3D"-1" lang=3D"en"><spa= n class=3D"">sorry, but also thought about switching to dovecot.<= br> <br> <br> </span></span>05.10.18 22:30, Reindl Harald (mobile) =D0=BF=D0=B8= =D1=88=D0=B5=D1=82:<br> </div> <blockquote type=3D"cite" cite=3D"mid:[email protected]"> <pre wrap=3D"">MariaDB 10.2.18 but that issue exists virtually fore= ver and predates MariaDB I don't get what is that hard to handle database input properly and no yo= u can't reject non rfc conform messages on postfix side as long the serve= r is not for personal use when dbmail-util is not able to cleanup stuff which cannot be handled it = is a major bug and I am tired of turn on debug logging to get the fucking= physical ID for delete the record (and so the whole) message by hand aft= er all that years=20 Am 5. Oktober 2018 21:09:28 MESZ schrieb Maxim <a class=3D"moz-txt-link-r= fc2396E" href=3D"mailto:[email protected]"><[email protected]></a= >: </pre> <blockquote type=3D"cite"> <pre wrap=3D""> which DBMS do you use? 05.10.18 14:52, Reindl Harald =D0=BF=D0=B8=D1=88=D0=B5=D1=82: </pre> <blockquote type=3D"cite"> <pre wrap=3D"">that there is a invalid char in a header is one = thing, but that </pre> </blockquote> <pre wrap=3D"">dbmail </pre> <blockquote type=3D"cite"> <pre wrap=3D"">produces non-recovery errors in that case sucks <147609553.1537264268556.JavaMail.=C3=BDkids2@oekids-server> "<a class=3D"moz-txt-link-rfc2396E" href=3D"mailto:75106708.5820290.15372= [email protected]"><[email protected]= m></a>")] Oct 05 13:36:09 mail.thelounge. dbmail-util[200378]: [0x562cfcc0a600] Error:[message] dbmail_message_cache_envelope(+1844): SQLException: Incorrect string value: '\xFDkids2...' for column 'envelope' at row 1 Am 05.10.18 um 11:51 schrieb Reindl Harald: </pre> <blockquote type=3D"cite"> <pre wrap=3D"">this sucks for years * why does this happen at all * why no output of database-id instead a dot * why no dbmail-util switch "kill messages you can't handle" * why spit lines with breaks into maillog confusing mailgraph ------------------------------ Ok. Found [3] missing envelope values. ... Maintenance done. Errors were found and fixed. We suggest running dbmail-util again to confirm that all errors were repaired. Ok. Found [3] missing envelope values. ... Maintenance done. Errors were found and fixed. We suggest running dbmail-util again to confirm that all errors were repaired. Ok. Found [3] missing envelope values. ... Maintenance done. Errors were found and fixed. We suggest running dbmail-util again to confirm that all errors were repaired. ------------------------------ Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message] dbmail_message_cache_envelope(+1844): SQLException: Incorrect string value: '\xFDkids2...' for column 'envelope' at row 1 Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message] dbmail_message_cache_envelope(+1846): insert envelope failed [("Tue, </pre> </blockquote> </blockquote> <pre wrap=3D"">02 </pre> <blockquote type=3D"cite"> <blockquote type=3D"cite"> <pre wrap=3D"">Oct 2018 19:07:51 +0000" </pre> </blockquote> </blockquote> <pre wrap=3D"">"=3D?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=3D </pre> <blockquote type=3D"cite"> <blockquote type=3D"cite"> <pre wrap=3D"">=3D?UTF-8?Q?ktobe Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message] dbmail_message_cache_envelope(+1844): SQLException: Incorrect string value: '\xFDkids2...' for column 'envelope' at row 1 Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message] dbmail_message_cache_envelope(+1846): insert envelope failed [("Tue, </pre> </blockquote> </blockquote> <pre wrap=3D"">18 </pre> <blockquote type=3D"cite"> <blockquote type=3D"cite"> <pre wrap=3D"">Sep 2018 10:26:26 +0000" {159} =3D?UTF-8?Q?Fw:_Einladung_zum_Vortrag_"Focusing_und_kre Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message] dbmail_message_cache_envelope(+1844): SQLException: Incorrect string value: '\xFDkids2...' for column 'envelope' at row 1 Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message] dbmail_message_cache_envelope(+1846): insert envelope failed [("Tue, </pre> </blockquote> </blockquote> <pre wrap=3D"">11 </pre> <blockquote type=3D"cite"> <blockquote type=3D"cite"> <pre wrap=3D"">Sep 2018 12:49:54 +0000" "[SPAM] =3D?UTF-8?Q?Fw:_Einladung_zum_Jour_Fixe_am?=3D =3D?UTF-8?Q Oct 5 11:45:55 mail dbmail/maintenance[190013]: Error:[message] dbmail_message_cache_envelope(+1844): SQLException: Incorrect string value: '\xFDkids2...' for column 'envelope' at row 1 Oct 5 11:45:55 mail dbmail/maintenance[190013]: Error:[message] dbmail_message_cache_envelope(+1846): insert envelope failed [("Tue, </pre> </blockquote> </blockquote> <pre wrap=3D"">02 </pre> <blockquote type=3D"cite"> <blockquote type=3D"cite"> <pre wrap=3D"">Oct 2018 19:07:51 +0000" </pre> </blockquote> </blockquote> <pre wrap=3D"">"=3D?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=3D </pre> <blockquote type=3D"cite"> <blockquote type=3D"cite"> <pre wrap=3D"">=3D?UTF-8?Q?ktobe Oct 5 11:45:55 mail dbmail/maintenance[190013]: Error:[message] dbmail_message_cache_envelope(+1844): SQLException: Incorrect string value: '\xFDkids2...' for column 'envelope' at row 1 Oct 5 11:45:55 mail dbmail/maintenance[190013]: Error:[message] dbmail_message_cache_envelope(+1846): insert envelope failed [("Tue, </pre> </blockquote> </blockquote> <pre wrap=3D"">18 </pre> <blockquote type=3D"cite"> <blockquote type=3D"cite"> <pre wrap=3D"">Sep 2018 10:26:26 +0000" {159} =3D?UTF-8?Q?Fw:_Einladung_zum_Vortrag_"Focusing_und_kre </pre> </blockquote> </blockquote> </blockquote> <pre wrap=3D"">_______________________________________________ DBmail mailing list <a class=3D"moz-txt-link-abbreviated" href=3D"mailto:[email protected]">D= [email protected]</a> <a class=3D"moz-txt-link-freetext" href=3D"http://lists.nfg.nl/mailman/li= stinfo/dbmail">http://lists.nfg.nl/mailman/listinfo/dbmail</a> </pre> </blockquote> <br> </body> </html> --------------A908064D960911EC63315988-- --===============2117318539== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ DBmail mailing list [email protected] http://lists.nfg.nl/mailman/listinfo/dbmail --===============2117318539==--