database corruption

[David Relson]

At 11:10 AM 5/28/03, Fred Yankowski wrote:
>Prompted by these recent messages I tried db_verify, and my
>spamlist.db also fails to verify:
>
>         db_verify: Page 1522: incorrect next_pgno 893 found in leaf chain 
> (should be 391)
>         db_verify: Page 391: incorrect prev_pgno 893 found in leaf chain 
> (should be 1522)
>
>I too use "bogofilter -u" from procmail scripts without any explicit
>locking.  Is that wrong?

Fred,

I've been using '-u' for months - since it was added in October.  It's been 
working well for me.  Just be sure to correct any errors.

>Even with this error in the database, bogofilter (0.12.2, after a
>series of upgrades from earlier releases carrying same database
>forward) is doing a fine job of discriminating my incoming mail.  Any
>thoughts on what level of noise from db_verify would justify
>rebuilding the database?

The noise indicates a problem.  I don't have solid info on what's 
significant and what's not.  One test would be simply to run "bogoutil -d 
xxxlist.db".  Output is alphabetical and you could see how far it gets 
before it stops/loops/whatever...

Errors might also affect whether it can add to the wordlists.

Question for those of you with problems:  What versions of bogofilter and 
BerkeleyDB are you using?  What operating system?  If there're are problems 
it's important to know about it.

David