Re: Rebuilding SpamProbe database

Thomas Schürger <[email protected]> Fri, 24 Oct 2008 08:46:54 +0200
Newsgroups gmane.mail.spam.spamprobe.general
Message-ID <[email protected]>
David A. Lee schrieb:
> Toss BDB and use PBL, or Hash.
> I like Hash better because it doesnt grow on you ....
>
> Many users, including myself, had exactly the same problem with BDB,
> that is intermittiant, then sometimes constant hangs.
> Noone has found anything wrong with spamprobe's use of BDB so the conclusion 
> is that
> it must be the BDB itself.  Noone to my knowledge has reported hangs in PBL 
> or Hash.
>   

I converted all my SpamProbe databases to PBL now. PBL seems to be
quicker than BDB, especially for mass processing (import, export, dump
and cleanup are faster). I need to see if the BDB problems I had once
in a while are gone now.

I would still like to see a rebuild-db command included into SpamProbe 
itself
with the following functionality:

- locking the lockfile
- opening present DB for reading
- opening new (temporary) DB for writing
- reading all data from present DB, writing to new DB
- closing DBs
- moving new DB over old DB, optionally retaining old DB as a backup
- unlocking the lockfile

This should be safe even on production systems.


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