You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@spamassassin.apache.org by bu...@spamassassin.apache.org on 2022/03/27 23:39:24 UTC
[Bug 7965] SQL storage backend miscalculates mean score for AWL (and others?)
https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7965
Matija Nalis <mn...@voyager.hr> changed:
What |Removed |Added
----------------------------------------------------------------------------
Severity|major |normal
CC| |mnalis-sabug@voyager.hr
--- Comment #1 from Matija Nalis <mn...@voyager.hr> ---
Ops, that was with current trunk (1899268) version of SQLBasedAddrList.pm,
sorry.
The 3.4.6 version of SQLBasedAddrList.pm returns score correctly (albeit clean
3.4.6 does complain a lot about "SQL error: Duplicate entry
'amavis-adminoffice@unist.hr-hotelfrontera.cl-170.246' for key 'PRIMARY'"):
> Mar 28 01:35:05.570 [10739] dbg: auto-whitelist: sql-based adminoffice@unist.hr|hotelfrontera.cl scores 0, msgcount 0
> Mar 28 01:35:05.571 [10739] dbg: auto-whitelist: sql-based adminoffice@unist.hr|none scores 0, msgcount 0
> Mar 28 01:35:05.571 [10739] dbg: auto-whitelist: AWL active, pre-score: 12.692, autolearn score: 12.692, mean: undef, IP: 170.246.172.8, address: adminoffice@unist.hr signed by hotelfrontera.
> Mar 28 01:35:05.573 [10739] dbg: auto-whitelist: sql-based add_score/insert score 12.692: amavis|adminoffice@unist.hr|170.246|1|12.692|hotelfrontera.cl
> Mar 28 01:35:05.573 [10739] dbg: auto-whitelist: post auto-whitelist score: 12.692
>
> Mar 28 01:35:15.181 [10961] dbg: auto-whitelist: sql-based adminoffice@unist.hr|hotelfrontera.cl scores 12.692, msgcount 1
> Mar 28 01:35:15.181 [10961] dbg: auto-whitelist: AWL active, pre-score: 12.692, autolearn score: 12.692, mean: 12.692, IP: 170.246.172.8, address: adminoffice@unist.hr signed by hotelfrontera
> Mar 28 01:35:15.182 [10961] dbg: auto-whitelist: sql-based add_score/insert amavis|adminoffice@unist.hr|170.246|1|12.692|hotelfrontera.cl: SQL error: Duplicate entry 'amavis-adminoffice@unist
> Mar 28 01:35:15.184 [10961] dbg: auto-whitelist: sql-based add_score/update new msgcount: 2, new totscore: 25.384 for 2|12.692|amavis|adminoffice@unist.hr|hotelfrontera.cl|170.246
> Mar 28 01:35:15.184 [10961] dbg: auto-whitelist: post auto-whitelist score: 12.692
>
> Mar 28 01:35:24.964 [11234] dbg: auto-whitelist: sql-based adminoffice@unist.hr|hotelfrontera.cl scores 25.384, msgcount 2
> Mar 28 01:35:24.964 [11234] dbg: auto-whitelist: AWL active, pre-score: 12.692, autolearn score: 12.692, mean: 12.692, IP: 170.246.172.8, address: adminoffice@unist.hr signed by hotelfrontera
> Mar 28 01:35:24.966 [11234] dbg: auto-whitelist: sql-based add_score/insert amavis|adminoffice@unist.hr|170.246|1|12.692|hotelfrontera.cl: SQL error: Duplicate entry 'amavis-adminoffice@unist
> Mar 28 01:35:24.968 [11234] dbg: auto-whitelist: sql-based add_score/update new msgcount: 3, new totscore: 38.076 for 3|12.692|amavis|adminoffice@unist.hr|hotelfrontera.cl|170.246
> Mar 28 01:35:24.968 [11234] dbg: auto-whitelist: post auto-whitelist score: 12.692
--
You are receiving this mail because:
You are the assignee for the bug.