Re: Rebuilding SpamProbe database

Thomas Schürger <[email protected]> Wed, 15 Oct 2008 09:29:02 +0200
Newsgroups gmane.mail.spam.spamprobe.general
Message-ID <[email protected]>
>
> Thomas Sch?rger wrote:
>   
>> what is the best way to clean (i.e., export and import) a SpamProbe 
>> database to reduce
>> its size?
>>
>> Some readme.txt suggests using
>>
>> cd ~
>> mkdir new.spamprobe
>> spamprobe export | spamprobe -d new.spamprobe import
>> mv .spamprobe old.spamprobe
>> mv new.spamprobe .spamprobe
>>
>> Is this feasible on a production system where mail can come in at any 
>> time? I've experienced serious issues with that (SpamProbe hanging, 
>>     
>
> I think it is not hanging. spamprobe locks the database while
> exporting (try "fstat ~/.spamprobe/lock" at the moment of exporting),
> therefore other spamprobe processes have to wait
>
>   
>> qmail lockups, 
>>     
>
> for the same reason maybe. 
>
>   
No, it's not the case that this happens just while import/export is 
running, this happens
afterwards. I haven't checked fstat though. And qmail hangs because 
SpamProbe hangs,
that's for sure. After a while all qmail delivery threads are blocked 
and no mails are delivered
at all.

>> destroyed
>> SpamProbe databases). 
>>     
>
> And this happens even without any reason with BDB.
>
>   

Would PBL instead of BDB be any  better?


Greetings,
Thomas.


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/