Home > Cannot Open > Cannot Open Bayes Databases File Exists

Cannot Open Bayes Databases File Exists

How do I remove the database? I'm still really concerned that I'll hit another deadlock situation like happened earlier this afternoon. Don On Tue, 11 May 2004, Matt Kettler wrote: > At 04:07 PM 5/11/2004, Don Newcomer wrote: > >What am I missing that it's still creating lockfiles? I noticed that when I ran sa-learn, I was creating new Bayes files in /.spamassassin and, since I had commented the 'bayes_path' entry out, I removed the comment and it seemed http://scriptkeeper.net/cannot-open/cannot-open-bayes-databases-lock-failed-file-exists.html

Free forum by Nabble Edit this page By pucky in forum FreeBSD 6.x Replies: 0 Last Post: 10-16-2006, 11:31 PM Posting Permissions You may not post new threads You may not post replies You may not post attachments newfield_no1, Dec 7, 2010 #10 falko Super Moderator ISPConfig Developer What userfiles? Why did this deadlock happen and how can I prevent it in the future? http://forum.directadmin.com/showthread.php?t=21648

It seems I don't have an existing AWL to convert to be imported into mysql. What bayes backend are you using? falko, Dec 7, 2010 #8 newfield_no1 New Member I tryed to run apt-get update, apt-get upgrade on the old server to se if the DB-files would be updated but the DB_file I have yet to have someone show me a message that exhibits this behavior, so I can't debug why atimes in the future occur, but there is a kluge in 3.0

And the bayes_journal file is gone, though unfortunately I forgot to check that before re-running sa-learn so I don't know which pass sync'd it. Comment 10 gdr+apache 2014-11-07 16:18:13 UTC This problem seems to persist in version 3.4.0, to the extent that the service can be stopped entirely and the lock file remains until removed Are you really running 2.60? I can see it >generating a lockfile to do an expiry but why would I have had six or seven >lockfiles unless they were separate expiry runs (every 5 minutes or

if it's still an issue w/ a recent (3.1/etc) SA version, please let us know and we can reopen. Does it happen during expiration? Aug 17 00:05:28 mail-in-1 spamd[81959]: connection from localhost [] at port 3997 Aug 17 00:05:28 mail-in-1 spamd[82878]: processing message <2352774.1092695757739.JavaMail.oracle [at] app-6> for exim:99. https://lists.amavis.org/pipermail/amavis-users/2011-October/000948.html Then I get errors in mail.warn but it lokks as it works any way, both I and oter accounts get their mail.

Brian ( bcwhite@precidia.com ) ------------------------------------------------------------------------------- Premature optimization is the root of all evil. -- Donald Knuth Comment 2 J 2003-09-30 00:07:16 UTC i run sa-learn and spamd as user spamc the at /Library/Perl/5.8.6/Mail/SpamAssassin/BayesStore/DBM.pm line 195.bayes: bayes db version 0 is not able to be used, aborting! Aug 17 00:05:37 mail-in-1 spamd[81959]: connection from localhost [] at port 4001 Aug 17 00:05:37 mail-in-1 spamd[82884]: processing message <FZMYDGXPTZTDCMSVWELEGWWJR [at] fadmail> for exim:99. I thougt that it could be that mistake I did before changen to a new server.

It only happened a few times (at least that I noticed), and only under extreme load, so I also suspect it was a locking issue? > A better solution is to https://www.howtoforge.com/community/threads/bayes-cannot-open-bayes-databases.50288/ newfield_no1, Dec 1, 2010 #3 falko Super Moderator ISPConfig Developer What's the output of Code: ls -la /var/www/web6/.spamassassin/ ? M$ Win's are shit, do not use it ! felicity at apache May6,2008,8:51AM Post #19 of 19 (10990 views) Permalink Re: Bayes database [In reply to] On Tue, May 06, 2008 at 04:16:06PM You're not swapping, or having some other i/o issue are you? /Jason R - elists Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as

I am getting tons of spam and when I look it shows no spam in the database. weblink Oct 25, 2006 9:14 AM Helpful (0) Reply options Link to this post Apple Footer This site contains user submitted content, comments and opinions and is for informational purposes only. My problem was that I was running sa-learn as "root" while MailScanner runs as "mail". Aug 17 00:05:25 mail-in-1 spamd[81959]: connection from localhost [] at port 3994 Aug 17 00:05:25 mail-in-1 spamd[82874]: processing message <E1BwqXb-000LYX-6J [at] mss-mail-in-1> for exim:99.

Tac Anti Spam from Surrey Forum SA Bugzilla – Bug3790 spamd fails to remove bayes.lock file? Any help would be greatly appreciated. Comment 7 Andrey Melnikov 2010-04-20 06:52:00 UTC In my case - SHORTCIRCUIT plugin is involved. navigate here Delete ALL bayes files from the directory mentioned above.

I > read that by removing all bayes_* files from the > /usr/local/share/spamassassin/run would work to reset the database. > Does spamassassin then recreate the database files? > > Dont do newfield_no1, Dec 6, 2010 #7 falko Super Moderator ISPConfig Developer Maybe you can find the .deb package of DB_File in /var/cache/apt/archives on the old server and install it on the new decrease it.

Are you sure the integrity of it (disks, RAM, etc) are sound?

Oct 25, 2006 8:57 AM Helpful (0) Reply options Link to this post by pterobyte, pterobyte Oct 25, 2006 4:14 PM in response to Kristoffer Level 6 (11,101 points) Servers Enterprise these file locking errors *appear* to be happening when a scan takes 5 to 20 times or more times longer again, still investigating... Aug 17 00:05:15 mail-in-1 spamd[81959]: connection from localhost [] at port 3988 Aug 17 00:05:15 mail-in-1 spamd[82864]: processing message <110101c483e5$b39ee63b$633b10f6 [at] belast> for exim:99. To start, the schema doesn't work with current versions of mysql.

should i stop spamd, restore bayes info and then restart spamd ? at /Library/Perl/5.8.6/Mail/SpamAssassin/BayesStore/DBM.pm line 195.locker: safe_unlock: lock on /var/clamav/.spamassassin/bayes.lock was lost due to expiry at /Library/Perl/5.8.6/Mail/SpamAssassin/Locker/UnixNFSSafe.pm line 196.Learned new HAM (not junk mail)Syncing SpamAssassin DatabaseDisplaying SpamAssassin Database Stats0.000 0 7733 0 non-token You could always shut down spamd, make a physical copy of it, then restart. his comment is here newfield_no1, Dec 9, 2010 #12 falko Super Moderator ISPConfig Developer newfield_no1 said: ↑ Can I then copy only them by using: /var/www/web*/user/web*/.spamassassin/b* and /var/www/web*/user/web*/.spamassassin/a* Maby by using this command: tar -pczf

That's only true when you run spamassassin as root. If you know there were inappropriate mails trained, one way or the other, and you still have them, you can relearn them (or forget them) easily. Gary ________________________________ From: Clinton Mills [mailto:clinton.mills [at] hitcents] Sent: Saturday, December 18, 2004 12:59 PM To: users [at] spamassassin Subject: Bayes Database I am having a problem with the bayes database. S 0:00 spamd child 32632 pts/1 S 0:01 /usr/bin/perl -T -w /usr/bin/sa-learn --spam --single 32638 pts/1 S+ 0:00 grep spam The sa-learn, 32632, is stuck waiting for a lock file to

The same on both the old and new server. You can not post a blank message. Is there a way to update the files to the same version? Format For Printing -XML -Clone This Bug -Top of page This is SA Bugzilla: the Apache SpamAssassin bug system.

I hadn't heard of that before, so have now added it. is bayes_seen necessary ? (i seem to recall it is not and can be deleted) if bayes_seen is large, isnt that the file we can delete and it will not make Don Newcomer Senior Manager, Systems Infrastructure Systems Department Library and Information Services Dickinson College P.O. Format For Printing -XML -Clone This Bug -Top of page This is SA Bugzilla: the Apache SpamAssassin bug system.

Thanks, Zoe Aug 17 00:05:02 mail-in-1 spamd[82829]: Cannot open bayes databases /usr/local/share/spamassassin/run/bayes_* R/W: lock failed: File exists Aug 17 00:05:03 mail-in-1 spamd[82832]: Cannot open bayes databases /usr/local/share/spamassassin/run/bayes_* R/W: lock failed: File Description J 2003-09-29 00:55:47 UTC I use spamc and spamd combination First the bayes database is ok After a few days I get the follwing error on sa-learn sa-learn rebuild: Cannot Have you run memtest? > spamd[19334]: bayes: cannot open bayes databases > /home/spamd/.spamassassin/bayes_* R/W: lock failed: File exists Have you stopped spamd, deleted these files, then restarted?