On 2018-09-17 19:00, David Newman wrote:
On 9/17/18 2:58 AM, Tom Sommer wrote:
I'm frankly not qualified to answer: Is this an amavisd problem, or a
p5-DBD-mysql problem? As it is, amavisd-new is getting bad data.
FYI: I just hit this issue when updating DBD::mysql to 4.048,
reverting
to 4.037 solved it for me (no other version worked).
I filed bug 231250 against amavisd-new for this. Previously I'd
contacted the package/port maintainer. I haven't heard back on either
that contact or the bug report.
At this point I'm pretty sure this is a bug in amavisd-new, as the
change in p5-DBD-mysql from 4.038 onward corrected a data-typing issue.
Any newer version "now returns mysql doubles as perl doubles and mysql
floats as perl floats (and not as a string anymore)" and that seems
like
correct behavior to me.
Problem is, while amavisd-new can coexist with 4.037, there are other
issues in that older version, never mind the additional need to exclude
that pkg/port when updating a system.
For what it's worth; this is appears as a general issue throughout
amavisd-new. _My_ problem is with the msgs-table where "sender id"/"sid"
and "receiver id"/"rid" is interpreted as 0, but still tagged as
"exists", leading to foreign key errors and thus breaking
penpals/quarantine.
--
Tom
