database is locked error

[Julian Field]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

All I can suggest is check that you have the latest DBD::SQLite installed.

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

Jules

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

Need help customising MailScanner?
Contact me!
Need help fixing or optimising your systems?
Contact me!
Need help getting you started solving new requirements from your boss?
Contact me!

PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654


-----BEGIN PGP SIGNATURE-----
Version: PGP Desktop 9.6.3 (Build 3017)
Comment: (pgp-secured)
Charset: ISO-8859-1

wj8DBQFG8815EfZZRxQVtlQRAu3bAKDai7E/VpL4qfG3eapI26ONNw/yYACeOjY0
P/B2RTu/2d8THVOqeBFTLWA=
=UocY
-----END PGP SIGNATURE-----

-- 
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