Hi,

I set

use_bayes                               1
bayes_auto_learn                        1
bayes_expiry_max_db_size                300000
bayes_auto_expire                       1
bayes_store_module
Mail::SpamAssassin::BayesStore::SQL
bayes_sql_dsn                           DBI:mysql:$mysqlserver

at local.cf. According to

http://spamassassin.apache.org/full/3.3.x/doc/sa-learn.html#expiration

I expected SA to automatically expire/cleanup/shrink the database. But
after 2 weeks the database grew to ~650k tokens.

[helmut@BSDHelmut ~]$ sudo sa-learn --dump magic
0.000          0          3          0  non-token data: bayes db version
0.000          0     354123          0  non-token data: nspam
0.000          0     157550          0  non-token data: nham
0.000          0     644732          0  non-token data: ntokens
0.000          0 1271332927          0  non-token data: oldest atime
0.000          0 1295434465          0  non-token data: newest atime
0.000          0          0          0  non-token data: last journal
sync atime
0.000          0 1295395414          0  non-token data: last expiry
atime
0.000          0          0          0  non-token data: last expire
atime delta
0.000          0          0          0  non-token data: last expire
reduction count
[helmut@BSDHelmut ~]$ sudo spamassassin -V
SpamAssassin version 3.3.1
  running on Perl version 5.10.1
[helmut@BSDHelmut ~]$

Did I miss anything?

Thanks, Helmut

Reply via email to