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_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
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://lists.nfg.nl/mailman/listinfo/dbmail
