database corruption

[David Relson]

At 11:42 AM 5/28/03, Dave Lovelace wrote:
>David Relson wrote:
> >
> > You're the first person to report database corruption in a long
> > time.  Hopefully it's a fluke and doesn't happen again.
> >
> > David
> >
>Hmm.  This caused me to try db_verify on our databases.  (Should I be doing
>some kind of locking?  Incoming mail may be trying to run bogofilter -u
>as I do it.)

...[snip verify errors]...


>Just for what it's worth.  I'm running 0.11.1.8

Dave,

Sounds like remedial actions are in store for you as well :-(

FWIW, since I started running bogofilter on 10-07-02 I've had an hourly 
cron job running to collect statistics.  I did it out of curiosity, but it 
gives me a history I wouldn't have otherwise.  It does (roughly):

cp -p $BOGODIR/*.db .
COUNTS=`bogoutil -w . .MSGCOUNT`
SPAM=`bogoutil -d spamlist.db | wc -l`
GOOD=`bogoutil -d goodlist.db | wc -l`
echo $COUNTS, $SPAM, $GOOD >> wordlist.history.txt

Note the "cp" command.  On my 133Mhz machine, "bogoutil -d" takes a while 
and I wanted to minimize locking/contention issues.

Good luck!

David