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
