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/11/09 22:46:01 UTC
[Bug 8072] AWL incorrectly resets message count
https://bz.apache.org/SpamAssassin/show_bug.cgi?id=8072
Matija Nalis <mn...@voyager.hr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |mnalis-sabug@voyager.hr
--- Comment #1 from Matija Nalis <mn...@voyager.hr> ---
Some 20 minutes earlier, I find possibly related AWL update - for same email
address, but different IP range, the msgcount was increased from 3 to 4 (and
the above obviously buggy change sets msgcount to 5:
/*!*/;
# at 579668809
# at 579669029
#221104 9:34:03 server id 1 end_log_pos 579669029 CRC32 0xff91a46d
Annotate_rows:
#Q> UPDATE awl SET msgcount = '4', totscore = totscore + '1.39' WHERE username
= 'amavis' AND email = 'redacted@example.com' AND signedby =
'example-com.20210112.gappssmtp.com' AND ip >
#221104 9:34:03 server id 1 end_log_pos 579669099 CRC32 0xa7d7c1f0
Table_map: `spamassassin`.`awl` mapped to number 22
# at 579669099
#221104 9:34:03 server id 1 end_log_pos 579669313 CRC32 0x460a91e9
Update_rows: table id 22 flags: STMT_END_F
### UPDATE `spamassassin`.`awl`
### WHERE
### @1='amavis'
### @2='redacted@example.com'
### @3='195.190'
### @4=3
### @5=9.794
### @6='example-com.20210112.gappssmtp.com'
### @7=1667550842
### SET
### @1='amavis'
### @2='redacted@example.com'
### @3='195.190'
### @4=4
### @5=11.184
### @6='example-com.20210112.gappssmtp.com'
### @7=1667550843
# Number of rows: 1
# at 579669313
#221104 9:34:03 server id 1 end_log_pos 579669344 CRC32 0xb73804b3 Xid =
8550665
COMMIT/*!*/;
--
You are receiving this mail because:
You are the assignee for the bug.