Re: intermittent lock issue

On 9/15/15 11:05 PM, Dirk Bonengel wrote:
> David,
> 
> i suggest using MySQL to store SpamAssassin's Bayes data. Should give
> you a performance boost and you get rid of the lovking issues. Should be
> no problem migrating your data ....
> 
> Dirk

Thanks, Dirk.

Per the pho-postfix setup instructions [1], Maia comes with a
maia-mysql.sql initial setup script to create a 'maia' database. Pasting
the comments from the script, the database sets up these tables:

[bayes_expire] is SpamAssassin 3.x's Bayes database expiry reference

[bayes_global_vars] is SpamAssassin 3.x's Bayes database global variables

[bayes_seen] is SpamAssassin 3.x's Bayes database token reference

[bayes_token] is SpamAssassin 3.x's Bayes database token list

[bayes_vars] is SpamAssassin 3.x's Bayes database variables scoreboard

Is that what you meant, or is some other setup needed to use MySQL to
store Bayes data?

Thanks again.

dn

[1] http://www.purplehat.org/?page_id=5


> 
> -------- Ursprüngliche Nachricht --------
> Von: David Newman <[email protected]>
> Datum: 15.09.2015 20:29 (GMT+01:00)
> An: [email protected]
> Betreff: [Maia-users] intermittent lock issue
> 
> (cross-posting from the pho-postfix list, as I haven't gotten an answer
> there)
> 
> Maia 1.0.4 on FreeBSD running as user vscan. User vscan's crontab
> includes this line:
> 
> 0 * * * * /usr/local/share/maia/scripts/process-quarantine.pl --learn
> --report > /dev/null
> 
> Around once a day or so, and not at any particular time I can discern,
> the cron job fails with errors like this:
> 
> bayes: cannot open bayes databases /var/maiad/.spamassassin/bayes_* R/W:
> lock failed: File exists
> bayes: cannot open bayes databases /var/maiad/.spamassassin/bayes_* R/W:
> lock failed: File exists
> bayes: cannot open bayes databases /var/maiad/.spamassassin/bayes_* R/W:
> lock failed: File exists
> bayes: cannot open bayes databases /var/maiad/.spamassassin/bayes_* R/W:
> lock failed: File exists
> bayes: cannot open bayes databases /var/maiad/.spamassassin/bayes_* R/W:
> lock failed: File exists
> bayes: cannot open bayes databases /var/maiad/.spamassassin/bayes_* R/W:
> lock failed: File exists
> bayes: cannot open bayes databases /var/maiad/.spamassassin/bayes_* R/W:
> lock failed: File exists
> 
> How to address the locking issue?
> 
> Thanks!
> 
> dn
> 
> _______________________________________________
> Maia-users mailing list
> [email protected]
> http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
_______________________________________________
Maia-users mailing list
[email protected]
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users