Re: SQLException: Incorrect string value
Maxim <[email protected]> Fri, 5 Oct 2018 22:09:28 +0300
| Newsgroups | gmane.mail.imap.dbmail |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --===============0222821636== Content-Type: multipart/alternative; boundary=------------C5BA5A5BF39E4B2658436EF0 Content-Language: ru This is a multi-part message in MIME format. --------------C5BA5A5BF39E4B2658436EF0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable 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, 0= 2 >> 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, 1= 8 >> 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, 1= 1 >> 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, 0= 2 >> 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, 1= 8 >> Sep 2018 10:26:26 +0000" {159} >> =3D?UTF-8?Q?Fw:_Einladung_zum_Vortrag_"Focusing_und_kre --------------C5BA5A5BF39E4B2658436EF0 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"short_text" lang=3D"en"><span clas= s=3D"">which DBMS do you use?</span></span><br> <br> 05.10.18 14:52, Reindl Harald =D0=BF=D0=B8=D1=88=D0=B5=D1=82:<br> </div> <blockquote type=3D"cite" cite=3D"mid:[email protected]"> <pre wrap=3D"">that there is a invalid char in a header is one thin= g, but that dbmail 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, 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 </pre> </blockquote> <pre wrap=3D""> </pre> </blockquote> <br> </body> </html> --------------C5BA5A5BF39E4B2658436EF0-- --===============0222821636== 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 --===============0222821636==--