[dspam-users] stats don't "add up" after dspam_merge and clean

From: Jelle Hillen <jelle.hillen@catsanddogs.com>
Date: Tue Feb 21 2006 - 08:28:15 EST

Hi list,

We're running DSPAM 3.6.3 with MySQL 4.1 (InnoDB) storage backend.
Recently, we've cleaned out our database by deleting a lot of obsolete
profiles and merging (using dspam_merge) profiles (usually of aliases)
to the proper (already existing) profile, so the stats are correctly
combined for a particular user.

Although everything went splendid, the thing I've noticed today is that
stats of some of those merged profiles no longer work the way they
should: when a falsely classified email is retrained, the stats don't
get updated, while the system.log does get updated. Since nothing is
reported in syslog, I guess it's safe to assume the email does get
retrained, but the stats are not updated. If an email gets retrained on
a profile which is not the result of a merge, stats get updated
correctly (so my dspam installation does work).
A closer look also reveiled that the stats in de database (dspam_stats
table) and the .stats file don't have the same figures, so my guess is
that there must be some corruption somewhere.

My two questions now are:
1) Should I worry if the stats don't get updated for those merged accounts?
2) Can I delete those .stats files in order to regenerate them, or do I
need to alter each of them manually. Note that we don't use the CGI, but
we do occassionally check the stats with dspam_stats (which seems to
read the .stats files, rather than looking in the database).

Thanks.

Sincerely

-- 
Jelle Hillen
Cats & Dogs bvba
Industrieweg 1506
3540 HERK-DE-STAD - BELGIUM
http://www.catsanddogs.com/
Tel : +32 13 539110
Fax : +32 13 539111
Received on Tue Feb 21 08:29:53 2006

This archive was generated by hypermail 2.1.8 : Wed Feb 22 2006 - 00:00:02 EST