https://bz.apache.org/SpamAssassin/show_bug.cgi?id=8072
Bug ID: 8072
Summary: AWL incorrectly resets message count
Product: Spamassassin
Version: 3.4.6
Hardware: PC
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: Plugins
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: Undefined
I've had situations when some legit messages suddenly have spam score increase
of several hundreds after one email. Trying to debug, I've tracked it down to
AWL module (using mysql backend).
First looking at the mail log, it seems AWL is changing minimally as expected,
and then suddenly it jumps HUGELY (and than trail off slowly again):
AWL=0.016
AWL=0.016
AWL=0.016
AWL=-0.085
AWL=0.016
AWL=0.937
AWL=1.406
AWL=1.627
AWL=318.182
AWL=265.033
AWL=176.606
[...]
sifting through mysqlbinlog to find what happened I find this piece of
evidence:
/*!*/;
# at 585992025
# at 585992247
#221104 9:54:16 server id 1 end_log_pos 585992247 CRC32 0x3d2066fc
Annotate_rows:
#Q> UPDATE awl SET msgcount = '5', totscore = totscore + '-0.459' WHERE
username = 'amavis' AND email = '[email protected]' AND signedby =
'example-com.20210112.gappssmtp.com' AND i>
#221104 9:54:16 server id 1 end_log_pos 585992317 CRC32 0x3463013b
Table_map: `spamassassin`.`awl` mapped to number 22
# at 585992317
#221104 9:54:16 server id 1 end_log_pos 585992531 CRC32 0xd7fcc32a
Update_rows: table id 22 flags: STMT_END_F
### UPDATE `spamassassin`.`awl`
### WHERE
### @1='amavis'
### @2='[email protected]'
### @3='213.191'
### @4=2392
### @5=3189.25
### @6='example-com.20210112.gappssmtp.com'
### @7=1667550625
### SET
### @1='amavis'
### @2='[email protected]'
### @3='213.191'
### @4=5
### @5=3188.79
### @6='example-com.20210112.gappssmtp.com'
### @7=1667552056
# Number of rows: 1
# at 585992531
#221104 9:54:16 server id 1 end_log_pos 585992562 CRC32 0xff0bfeb5 Xid =
8567075
COMMIT/*!*/;
So it seems that while totscore is correctly increased, message count gets
reset -- instead of increasing from 2392 to 2393, it gets reset to 5 -- which
obviously leads to all further uses to get hugely increased AWL!
That is spamassassin 3.4.6-1 from Debian Bullseye.
--
You are receiving this mail because:
You are the assignee for the bug.
