Mailing List Archive

SQLException: Incorrect string value
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" "=?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=
=?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}
=?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]
=?UTF-8?Q?Fw:_Einladung_zum_Jour_Fixe_am?= =?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" "=?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=
=?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}
=?UTF-8?Q?Fw:_Einladung_zum_Vortrag_"Focusing_und_kre
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://lists.nfg.nl/mailman/listinfo/dbmail
Re: SQLException: Incorrect string value [ In reply to ]
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.ýkids2@oekids-server>
"<75106708.5820290.1537266387974@mail.yahoo.com>")]

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" "=?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=
> =?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}
> =?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]
> =?UTF-8?Q?Fw:_Einladung_zum_Jour_Fixe_am?= =?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" "=?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=
> =?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}
> =?UTF-8?Q?Fw:_Einladung_zum_Vortrag_"Focusing_und_kre

--

Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / CISO / Software-Development
m: +43 676 40 221 40
p: +43 1 595 3999 33
http://www.thelounge.net/

GPG-Public-Key:
https://arrakis-tls.thelounge.net/gpg/h.reindl_thelounge.net.pub.txt
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://lists.nfg.nl/mailman/listinfo/dbmail
Re: SQLException: Incorrect string value [ In reply to ]
which DBMS do you use?

05.10.18 14:52, Reindl Harald ?????:
> 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.ýkids2@oekids-server>
> "<75106708.5820290.1537266387974@mail.yahoo.com>")]
>
> 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" "=?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=
>> =?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}
>> =?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]
>> =?UTF-8?Q?Fw:_Einladung_zum_Jour_Fixe_am?= =?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" "=?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=
>> =?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}
>> =?UTF-8?Q?Fw:_Einladung_zum_Vortrag_"Focusing_und_kre
Re: SQLException: Incorrect string value [ In reply to ]
MariaDB 10.2.18 but that issue exists virtually forever and predates MariaDB

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 server 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 after all that years

Am 5. Oktober 2018 21:09:28 MESZ schrieb Maxim <max_conf@e-foto.ru>:
>
>which DBMS do you use?
>
>05.10.18 14:52, Reindl Harald ?????:
>> 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.ýkids2@oekids-server>
>> "<75106708.5820290.1537266387974@mail.yahoo.com>")]
>>
>> 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"
>"=?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=
>>> =?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}
>>> =?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]
>>> =?UTF-8?Q?Fw:_Einladung_zum_Jour_Fixe_am?= =?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"
>"=?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=
>>> =?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}
>>> =?UTF-8?Q?Fw:_Einladung_zum_Vortrag_"Focusing_und_kre
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://lists.nfg.nl/mailman/listinfo/dbmail
Re: SQLException: Incorrect string value [ In reply to ]
I used to use dbmail for my service. I thought it would be a no-brainer to
set up with some sort of control panel app since, hey, it's SQL. However,
I had t stop using it because it doesn't look like it's maintained any
longer. There hasn't been an update since early last year. I was also
having trouble with database size vs the actual dump size. After much
time, I decided that the command-line invited too many errors. IMAP
searches always timed out. All the solutions I saw used dovecot and
dovecot's message store. I had to switch. such a shame. It was a good
idea, but I'm not sure SQL is the right technology for the store. hadoopor
mongo or some such might actually work better. I know I had an extensive
set of save queries. It was just too much to manage. I'm a purist, but
I"m getting too old be working the command-line.

--Curtis Maurand

On Fri, Oct 5, 2018 at 3:32 PM Reindl Harald (mobile) <
h.reindl@thelounge.net> wrote:

> MariaDB 10.2.18 but that issue exists virtually forever and predates
> MariaDB
>
> 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 server 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 after
> all that years
>
> Am 5. Oktober 2018 21:09:28 MESZ schrieb Maxim <max_conf@e-foto.ru>:
> >
> >which DBMS do you use?
> >
> >05.10.18 14:52, Reindl Harald ?????:
> >> 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.ýkids2@oekids-server>
> >> "<75106708.5820290.1537266387974@mail.yahoo.com>")]
> >>
> >> 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"
> >"=?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=
> >>> =?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}
> >>> =?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]
> >>> =?UTF-8?Q?Fw:_Einladung_zum_Jour_Fixe_am?= =?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"
> >"=?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=
> >>> =?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}
> >>> =?UTF-8?Q?Fw:_Einladung_zum_Vortrag_"Focusing_und_kre
> _______________________________________________
> DBmail mailing list
> DBmail@dbmail.org
> http://lists.nfg.nl/mailman/listinfo/dbmail
>


--
--Curtis
Re: SQLException: Incorrect string value [ In reply to ]
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
reliably.

sorry, but also thought about switching to dovecot.


05.10.18 22:30, Reindl Harald (mobile) ?????:
> MariaDB 10.2.18 but that issue exists virtually forever and predates MariaDB
>
> 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 server 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 after all that years
>
> Am 5. Oktober 2018 21:09:28 MESZ schrieb Maxim <max_conf@e-foto.ru>:
>> which DBMS do you use?
>>
>> 05.10.18 14:52, Reindl Harald ?????:
>>> 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.ýkids2@oekids-server>
>>> "<75106708.5820290.1537266387974@mail.yahoo.com>")]
>>>
>>> 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"
>> "=?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=
>>>> =?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}
>>>> =?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]
>>>> =?UTF-8?Q?Fw:_Einladung_zum_Jour_Fixe_am?= =?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"
>> "=?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=
>>>> =?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}
>>>> =?UTF-8?Q?Fw:_Einladung_zum_Vortrag_"Focusing_und_kre
> _______________________________________________
> DBmail mailing list
> DBmail@dbmail.org
> http://lists.nfg.nl/mailman/listinfo/dbmail
Re: SQLException: Incorrect string value [ In reply to ]
Am 07.10.18 um 12:04 schrieb Maxim:
> 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
> reliably.

i doubt that you are faster and more relieable with sql-scripts instead
"dbmail-util -y -c -t -u -b -p -d -r 24h" and without don't wonder why
your database grows endless

> 05.10.18 22:30, Reindl Harald (mobile) ?????:
>> MariaDB 10.2.18 but that issue exists virtually forever and predates MariaDB
>>
>> 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 server 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 after all that years
>>
>> Am 5. Oktober 2018 21:09:28 MESZ schrieb Maxim <max_conf@e-foto.ru>:
>>> which DBMS do you use?
>>>
>>> 05.10.18 14:52, Reindl Harald ?????:
>>>> 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.ýkids2@oekids-server>
>>>> "<75106708.5820290.1537266387974@mail.yahoo.com>")]
>>>>
>>>> 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"
>>> "=?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=
>>>>> =?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}
>>>>> =?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]
>>>>> =?UTF-8?Q?Fw:_Einladung_zum_Jour_Fixe_am?= =?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"
>>> "=?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=
>>>>> =?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
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://lists.nfg.nl/mailman/listinfo/dbmail