bayes db version 2 is not able to be used, aborting!

[Bobby Johnson <bo...@plexuscomp.com>]

I'm running Spamassassin 3.10 from the OpenBSD ports on OpenBSD 3.9.  It
was upgraded a while ago, but was never running earlier than
Spamassassin 3.0.4.

Recently noticed some problems with sa-learn.  Users have been able to
put in maybe 50 messages at a time, started receiving timeouts from
postfix running sa-learn ( sa-learn is run as a postfix service), even
sending just a few messages.

When I do an sa-learn --dump magic I get this error.
bayes: bayes db version 2 is not able to be used, aborting!
at /usr/local/libdata/perl5/site_perl/Mail/SpamAssassin/BayesStore/DBM.pm line 195.
bayes: bayes db version 2 is not able to be used, aborting!
at /usr/local/libdata/perl5/site_perl/Mail/SpamAssassin/BayesStore/DBM.pm line 195.
ERROR: Bayes dump returned an error, please re-run with -D for more
information

Found this page, http://wiki.apache.org/spamassassin/BayesUpgradeError

Ran sa-learn -D --sync, and I got this:

[22990] dbg: logger: adding facilities: all
[22990] dbg: logger: logging level is DBG
[22990] dbg: generic: SpamAssassin version 3.1.0
[22990] dbg: config: score set 0 chosen.
[22990] dbg: util: running in taint mode? yes
[22990] dbg: util: taint mode: deleting unsafe environment variables,
resetting PATH
[22990] dbg: util: PATH included '/home/bob/bin', which doesn't exist,
dropping   
[22990] dbg: util: PATH included '/bin', keeping
[22990] dbg: util: PATH included '/sbin', keeping
[22990] dbg: util: PATH included '/usr/bin', keeping
[22990] dbg: util: PATH included '/usr/sbin', keeping
[22990] dbg: util: PATH included '/usr/X11R6/bin', which doesn't exist,
dropping
[22990] dbg: util: PATH included '/usr/local/bin', keeping
[22990] dbg: util: PATH included '/usr/local/sbin', keeping
[22990] dbg: util: PATH included '/usr/games', keeping
[22990] dbg: util: PATH included '.', which is not absolute, dropping
[22990] dbg: util: final PATH set
to: /bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/games
[22990] dbg: dns: is Net::DNS::Resolver available? yes
[22990] dbg: dns: Net::DNS version: 0.54
[22990] dbg: dns: name server: 217.13.28.15, family: 2, ipv6: 0
[22990] dbg: config: using "/etc/mail/spamassassin" for site rules pre
files
[22990] dbg: config: read file /etc/mail/spamassassin/init.pre
[22990] dbg: config: read file /etc/mail/spamassassin/v310.pre
[22990] dbg: config: using "/usr/local/share/spamassassin" for sys rules
pre files
[22990] dbg: config: using "/usr/local/share/spamassassin" for default
rules dir
[22990] dbg: config: read file /usr/local/share/spamassassin/10_misc.cf
[22990] dbg: config: read
file /usr/local/share/spamassassin/20_advance_fee.cf
[22990] dbg: config: read
file /usr/local/share/spamassassin/20_anti_ratware.cf
[22990] dbg: config: read 

------CUT--------

[22990] dbg: config: read
file /usr/local/share/spamassassin/60_whitelist_subject.cf
[22990] dbg: config: using "/etc/mail/spamassassin" for site rules dir
[22990] dbg: config: read file /etc/mail/spamassassin/local.cf
[22990] dbg: config: using "/home/bob/.spamassassin/user_prefs" for user
prefs file
[22990] dbg: config: read file /home/bob/.spamassassin/user_prefs
[22990] dbg: plugin: loading Mail::SpamAssassin::Plugin::URIDNSBL from
@INC
[22990] dbg: plugin: registered
Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x7c32052c)
[22990] dbg: plugin: loading Mail::SpamAssassin::Plugin::Hashcash from
@INC
[22990] dbg: plugin: registered
Mail::SpamAssassin::Plugin::Hashcash=HASH(0x7e120ef4)
[22990] dbg: plugin: loading Mail::SpamAssassin::Plugin::SPF from @INC
[22990] dbg: plugin: registered
Mail::SpamAssassin::Plugin::SPF=HASH(0x845744fc)
[22990] dbg: plugin: loading Mail::SpamAssassin::Plugin::Pyzor from @INC
[22990] dbg: pyzor: network tests on, attempting Pyzor
[22990] dbg: plugin: registered
Mail::SpamAssassin::Plugin::Pyzor=HASH(0x8685f3c0)
[22990] dbg: plugin: loading Mail::SpamAssassin::Plugin::SpamCop from
@INC
[22990] dbg: reporter: network tests on, attempting SpamCop
[22990] dbg: plugin: registered
Mail::SpamAssassin::Plugin::SpamCop=HASH(0x7dc6de58)
[22990] dbg: plugin: loading Mail::SpamAssassin::Plugin::AWL from @INC
[22990] dbg: plugin: registered
Mail::SpamAssassin::Plugin::AWL=HASH(0x874142b8)
[22990] dbg: plugin: loading
Mail::SpamAssassin::Plugin::AutoLearnThreshold from @INC
[22990] dbg: plugin: registered
Mail::SpamAssassin::Plugin::AutoLearnThreshold=HASH(0x896bec6c)
[22990] dbg: plugin: loading
Mail::SpamAssassin::Plugin::WhiteListSubject from @INC
[22990] dbg: plugin: registered
Mail::SpamAssassin::Plugin::WhiteListSubject=HASH(0x855132ac)
[22990] dbg: plugin: loading Mail::SpamAssassin::Plugin::MIMEHeader from
@INC
[22990] dbg: plugin: registered
Mail::SpamAssassin::Plugin::MIMEHeader=HASH(0x7c217b30)
[22990] dbg: plugin: loading Mail::SpamAssassin::Plugin::ReplaceTags
from @INC
[22990] dbg: plugin: registered
Mail::SpamAssassin::Plugin::ReplaceTags=HASH(0x84241fc0)
[22990] dbg: config: adding redirector regex: /^http:\/\/chkpt\.zdnet
\.com\/chkpt\/\w+\/(.*)$/i
[22990] dbg: config: adding redirector regex: /^http:\/\/www(?:\d
+)?\.nate\.com\/r\/\w+\/(.*)$/i
[22990] dbg: config: adding redirector regex: /^http:\/\/.+\.gov\/(?:.*
\/)?externalLink\.jhtml\?.*url=(.*?)(?:&.*)?$/i
[22990] dbg: config: adding redirector regex: /^http:\/\/redir\.internet
\.com\/.+?\/.+?\/(.*)$/i
[22990] dbg: config: adding redirector regex: /^http:
\/\/(?:.*?\.)?adtech\.de\/.*(?:;|\|)link=(.*?)(?:;|$)/i
[22990] dbg: config: adding redirector regex: m'^http.*?/redirect\.php
\?.*(?<=[?&])goto=(.*?)(?:$|[&\#])'i
[22990] dbg: config: adding redirector regex:
m'^https?:/*(?:[^/]+\.)?emf\d\.com/r\.cfm.*?&r=(.*)'i
[22990] info: config: failed to parse line, skipping: use_razor2 1
[22990] info: config: failed to parse line, skipping: use_dcc 1
[22990] dbg: plugin:
Mail::SpamAssassin::Plugin::ReplaceTags=HASH(0x84241fc0) implements
'finish_parsing_end'
[22990] dbg: replacetags: replacing tags
[22990] dbg: replacetags: done replacing tags
[22990] dbg: bayes: tie-ing to DB file
R/O /var/amavisd/.spamassassin/bayes_toks
[22990] dbg: bayes: tie-ing to DB file
R/O /var/amavisd/.spamassassin/bayes_seen
[22990] dbg: bayes: found bayes db version 2
bayes: bayes db version 2 is not able to be used, aborting!
at /usr/local/libdata/perl5/site_perl/Mail/SpamAssassin/BayesStore/DBM.pm
line 195.
[22990] dbg: config: score set 1 chosen.
[22990] dbg: learn: initializing learner
[22990] dbg: bayes: bayes journal sync starting
[22990] dbg: bayes: bayes journal sync completed
[22990] dbg: bayes: expiry starting
[22990] dbg: locker: safe_lock:
created /var/amavisd/.spamassassin/bayes.lock.mailgw.emkc.com.22990
[22990] dbg: locker: safe_lock: trying to get lock
on /var/amavisd/.spamassassin/bayes with 0 retries
[22990] dbg: locker: safe_lock: trying to get lock
on /var/amavisd/.spamassassin/bayes with 1 retries
[22990] dbg: locker: safe_lock: trying to get lock
on /var/amavisd/.spamassassin/bayes with 2 retries
[22990] dbg: locker: safe_lock: trying to get lock
on /var/amavisd/.spamassassin/bayes with 3 retries
[22990] dbg: locker: safe_lock: trying to get lock
on /var/amavisd/.spamassassin/bayes with 4 retries

This appears to retry forever.

I didn't find any sa-learn processes running, I killed amavisd, spamc
and spamd weren't running.  Same error.  So I deleted the lock files and
reran sa-learn -D --sync. I get this.

--- CUT ---

[25988] dbg: bayes: found bayes db version 2
bayes: bayes db version 2 is not able to be used, aborting!
at /usr/local/libdata/perl5/site_perl/Mail/SpamAssassin/BayesStore/DBM.pm
line 195.
[25988] dbg: config: score set 1 chosen.
[25988] dbg: learn: initializing learner
[25988] dbg: bayes: bayes journal sync starting
[25988] dbg: bayes: bayes journal sync completed
[25988] dbg: bayes: expiry starting
[25988] dbg: locker: safe_lock:
created /var/amavisd/.spamassassin/bayes.lock.mailgw.emkc.com.25988
[25988] dbg: locker: safe_lock: trying to get lock
on /var/amavisd/.spamassassin/bayes with 0 retries
[25988] dbg: locker: safe_lock: link
to /var/amavisd/.spamassassin/bayes.lock: link ok
[25988] dbg: bayes: tie-ing to DB file
R/W /var/amavisd/.spamassassin/bayes_toks
[25988] dbg: bayes: tie-ing to DB file
R/W /var/amavisd/.spamassassin/bayes_seen
[25988] dbg: bayes: found bayes db version 2
[25988] dbg: bayes: detected bayes db format 2, upgrading
[25988] dbg: bayes: upgrading database format from v2 to v3
[25988] dbg: locker: refresh_lock:
refresh /var/amavisd/.spamassassin/bayes.lock
[25988] dbg: bayes: expiry completed


When I run sa-learn -D --sync again I get the same output as the first
time.


Bobby