Re: Rebuilding SpamProbe database

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 conclusio=
n =

is that
it must be the BDB itself.  Noone to my knowledge has reported hangs in PBL =

or Hash.


----- Original Message ----- =

From: "Thomas Sch=FCrger" <[email protected]>
To: "Victor Sudakov" <vas-n1J9iPLYpbYGA+p/[email protected]>; =

<spamprobe-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>
Sent: Wednesday, October 15, 2008 3:29 AM
Subject: Re: [Spamprobe-users] Rebuilding SpamProbe database


> >
>> 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=3D100&url=3D/
> _______________________________________________
> Spamprobe-users mailing list
> Spamprobe-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/spamprobe-users
> =



-------------------------------------------------------------------------
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 priz=
es
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=3D100&url=3D/