database is locked error

[Mark Warpool]

Julian,
Thank you for your response.  I had figured that it probably had something
to do with the SA cache database, so stopping MS and deleting the cache was
the first thing that I did.  And I've since done it a couple more times, and
it continues to surface.  Any idea what might be causing the corruption, or
what I can do to prevent it?  This is MailScanner 4.61.7 btw (I forgot to
mention that).



-----Original Message-----
From: mailscanner-bounces at lists.mailscanner.info
[mailto:mailscanner-bounces at lists.mailscanner.info] On Behalf Of Julian
Field
Sent: Thursday, September 20, 2007 7:22 PM
To: MailScanner discussion
Subject: Re: database is locked error

This is usually caused by the SpamAssassin Cache db getting corrupted.
Stop MailScanner, delete the db file in /var/spool/MailScanner/incoming 
and restart MailScanner. Then the errors and slowness will go away.

Can someone add this one to the wiki please?

Mark Warpool wrote:
> 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
>
>   

Jules

-- 
Julian Field MEng CITP
www.MailScanner.info
Buy the MailScanner book at www.MailScanner.info/store

MailScanner customisation, or any advanced system administration help?
Contact me at Jules at Jules.FM

PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
For all your IT requirements visit www.transtec.co.uk


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
For all your IT requirements visit www.transtec.co.uk

-- 
MailScanner mailing list
mailscanner at lists.mailscanner.info
http://lists.mailscanner.info/mailman/listinfo/mailscanner

Before posting, read http://wiki.mailscanner.info/posting

Support MailScanner development - buy the book off the website!