https://bz.apache.org/SpamAssassin/show_bug.cgi?id=8028
Bug ID: 8028
Summary: Errors in t/sql_based_welcomelist.t
Product: Spamassassin
Version: unspecified
Hardware: PC
OS: FreeBSD
Status: NEW
Severity: normal
Priority: P2
Component: Regression Tests
Assignee: dev@spamassassin.apache.org
Reporter: sid...@sidney.com
Target Milestone: Undefined
I'm seeing two questionable things in results for t/sql_based_welcomelist.t,
one consistent and the other sporadic and not reproducible.
They both can be seen in the following CPAN test report of a test package in
which I added diagnostic output to dump the log file when the error happened.
Since I can't consistently make the error happen that was the only way I had to
view the log file when it did:
http://www.cpantesters.org/cpan/report/e01cc734-1d23-11ed-81f7-fd3d6e8775ea
Notice this line in the log, in the test looking for "scores -2.4":
>Aug 16 02:18:50.658 [73299] dbg: auto-welcomelist:
> sql-based whitelist_t...@whitelist.spamassassin.taint.org|144.137
> scores -2.39999999999999991, msgcount 2
The extra 0.00000000000000009 points seem to come from this extra AWL rule that
shows up in the score summary, which does not appear in the log output of
successful tests:
>-1.2 NICE_002 BODY: No description available.
> 0.0 AWL AWL: No description available.
Anyone have an idea what could inconsistently cause the 0 point AWL to add
0.00000000000000009 to the total? As I said, I cannot reproduce this at will.
The other strange thing I see even in successful tests is in the line of the
log output
>Aug 16 02:18:50.658 [73299] dbg: auto-welcomelist: sql-based add_score/insert
> cpansand|whitelist_t...@whitelist.spamassassin.taint.org|144.137|1|-1.2:
> SQL error: UNIQUE constraint failed: awl.username, awl.email, awl.signedby,
> awl.ip
The test creates the AWL table itself. Is this SQL error a bug in the test or
in the code, or something that is expected in the test that can be ignored?
--
You are receiving this mail because:
You are the assignee for the bug.
