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_c...@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.1537266387...@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
