Token expiration and MySQL

[Rocco Scappatura <Ro...@sttspa.it>]

Hello,

I have two different SpamAssassin installed on two different server.
Thet store information on two different MySQL server database.

On both I have scheduled several jobs for forcing expiration of tokens.
In crontab I have the following lines:


30 4 * * 0 sa-learn -u amavis --dump magic
40 4 * * 0 sa-learn --sync --force-expire
50 4 * * 0 sa-learn -u amavis --dump magic
0 5 * * 0 echo "optimize table bayes_expire, bayes_seen, bayes_token,
awl;" | mysql -u bayes -h mysql2.sttspa.intranet -p***** bayes

While on one server I get that regularly tokens are expired (for
example:

Date: Sun, 17 Dec 2006 04:40:38 +0100
From: Cron Daemon <ro...@stt.vir>
To: amavis@av3.sttspa.it
Subject: Cron <am...@av3> sa-learn --sync --force-expire

expired old bayes database entries in 37 seconds
18682012 entries kept, 76418 deleted
token frequency: 1-occurrence tokens: 1.83%
token frequency: less than 8 occurrences: 0.33%

) on the other one I get always that the token are not expired (for
example:

Date: Sun, 4 Feb 2007 04:40:01 +0100
From: Cron Daemon <ro...@stt.vir>
To: amavis@av4.sttspa.it
Subject: Cron <am...@av4> sa-learn --sync --force-expire
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/var/amavis>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=amavis>
X-Virus-Scanned: by amavisd-new

[16717] warn: FuzzyOcr: Cannot find executable for ocrad
[16717] warn: FuzzyOcr: Cannot find executable for pamthreshold
[16717] warn: FuzzyOcr: Cannot find executable for tesseract
expired old bayes database entries in 617 seconds
13109996 entries kept, 0 deleted
token frequency: 1-occurrence tokens: 79.61%
token frequency: less than 8 occurrences: 16.04%

)

Could someone explai why on the secon machine the tokens are never
expired?

PS: The local.cf is the the same on both machine and I don't get any
error message..

BR,

rocsca

RE: Token expiration and MySQL

[Rocco Scappatura <Ro...@sttspa.it>]

> Not without seeing -D output.  My guess is most of your 
> tokens are within a very small timestamp band.

Tonight I will collect the verbose debug output and submit it to you..

Thanks,

rocsca

Re: Token expiration and MySQL

[Theo Van Dinter <fe...@apache.org>]

On Wed, Feb 07, 2007 at 11:40:24AM +0100, Rocco Scappatura wrote:
> Could someone explai why on the secon machine the tokens are never
> expired?

Not without seeing -D output.  My guess is most of your tokens are within a
very small timestamp band.

-- 
Randomly Selected Tagline:
"Programming is like sex. One mistake and you have to support it for
 the rest of your life." - Michael Sinz