database is locked error

[Scott Silva]

Mark Warpool spake the following on 9/20/2007 1:57 PM:
> Hi all,
> I've recently started getting a lot of these errors in my mail.warn log.
> 
> 	Sep 20 16:48:37 mail03 MailScanner[25144]: database is locked(5) at
> dbdimp.c line 402
> 	Sep 20 16:48:40 mail03 MailScanner[24966]: database is locked(5) at
> dbdimp.c line 402
> 	Sep 20 16:49:08 mail03 MailScanner[25144]: database is locked(5) at
> dbdimp.c line 402
> 	Sep 20 16:49:39 mail03 MailScanner[25144]: database is locked(5) at
> dbdimp.c line 402
> 
> My server is under extremely heavy load at the moment, doing about 30k - 40k
> messages per day.  It's a SUSE 10.2 box with dual-dual core Opterons and 2GB
> of RAM.  I've been running MailScanner for many years now on various
> different servers, but I've never run across this error before.
> 
> It seems to be processing mail, however it also seems the mail is piling up
> and not processing as fast as I would normally expect it to.  As of this
> writing, it has about 1000 messages in queue, where I normally am able to
> keep that to the 200 - 400 range.
> 
> Any suggestions?
> 
> TIA
> 
> Mark Warpool
> Ideate Technology Solutions
> 
That is from SQLite. Trey running analyze_SpamAssassin_cache and see if it can 
fix the db. Or you can just stop mailscanner long enough to kill the 
spamassassin cache db and restart. It might be harmless, but it could be 
slowing things down.

-- 

MailScanner is like deodorant...
You hope everybody uses it, and
you notice quickly if they don't!!!!