Bayesian expiry & couldn't find a good delta atime, need more token difference, skipping expire

[Nico Prenzel]

Hello All,

I've found out, that my SpamAssassin system doesn't expire old bayesian tokens from my mysql database. This happens only for one specific user.
Token expiry for other users works fine (log):
Mon Mar 20 00:31:27 2006 [28542] dbg: bayes: expired old bayes database entries in 61 seconds: 181742 entries kept, 2003 deleted

The following is the log that I'll get if expiry does occur for that one user:

Mon Mar 20 03:21:09 2006 [28542] dbg: bayes: DB expiry: tokens in DB: 208101, Expiry max size: 150000, Oldest atime: 1114657202, Newest atime: 1142821269, Last expire: 1142766961, Current time: 1142821269
Mon Mar 20 03:21:09 2006 [28542] dbg: bayes: opportunistic call found expiry due
Mon Mar 20 03:21:09 2006 [28542] dbg: bayes: bayes journal sync starting
Mon Mar 20 03:21:09 2006 [28542] dbg: bayes: bayes journal sync completed
Mon Mar 20 03:21:09 2006 [28542] dbg: bayes: expiry starting
Mon Mar 20 03:21:09 2006 [28542] dbg: bayes: DB expiry: tokens in DB: 208101, Expiry max size: 150000, Oldest atime: 1114657202, Newest atime: 1142821269, Last expire: 1142766961, Current time: 1142821269
Mon Mar 20 03:21:09 2006 [28542] dbg: bayes: expiry check keep size, 0.75 * max: 112500
Mon Mar 20 03:21:09 2006 [28542] dbg: bayes: token count: 208101, final goal reduction size: 95601
Mon Mar 20 03:21:09 2006 [28542] dbg: bayes: first pass?  current: 1142821269, Last: 1142766961, atime: 0, count: 0, newdelta: 0, ratio: 0, period: 43200
Mon Mar 20 03:21:09 2006 [28542] dbg: bayes: can't use estimation method for expiry, unexpected result, calculating optimal atime delta (first pass)
Mon Mar 20 03:21:09 2006 [28542] dbg: bayes: expiry max exponent: 9
Mon Mar 20 03:21:40 2006 [28543] dbg: prefork: periodic ping from spamd parent
Mon Mar 20 03:21:40 2006 [28543] dbg: prefork: sysread(8) not ready, wait max 300 secs
Mon Mar 20 03:22:15 2006 [28542] dbg: bayes: atime_token reduction
Mon Mar 20 03:22:15 2006 [28542] dbg: bayes: ========_===============
Mon Mar 20 03:22:15 2006 [28542] dbg: bayes: 43200_349041
Mon Mar 20 03:22:15 2006 [28542] dbg: bayes: 86400_348756
Mon Mar 20 03:22:15 2006 [28542] dbg: bayes: 172800_347330
Mon Mar 20 03:22:15 2006 [28542] dbg: bayes: 345600_342948
Mon Mar 20 03:22:15 2006 [28542] dbg: bayes: 691200_339475
Mon Mar 20 03:22:15 2006 [28542] dbg: bayes: 1382400_330902
Mon Mar 20 03:22:15 2006 [28542] dbg: bayes: 2764800_317278
Mon Mar 20 03:22:15 2006 [28542] dbg: bayes: 5529600_284111
Mon Mar 20 03:22:15 2006 [28542] dbg: bayes: 11059200_227054
Mon Mar 20 03:22:15 2006 [28542] dbg: bayes: 22118400_139879
Mon Mar 20 03:22:15 2006 [28542] dbg: bayes: couldn't find a good delta atime, need more token difference, skipping expire
Mon Mar 20 03:22:15 2006 [28542] dbg: bayes: expiry completed

How do I get around that problem and recude the tokens for that user? (BTW: I don't want to clear all tokens for that user!)


Greetings.

NicoP.