database is locked error

[Julian Field]

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