BerkeleyDB error

[David Relson]

Matthias,

As part of my bogofilter integrity checks, at 8:00, 16:00, and 24:00 I make 
a copy of spamlist.db and goodlist.db and run db_verify.  (I also keep the 
24:00 files for a week.).

The 8:00AM check found revealed an error that wasn't there 8 hours 
earlier.  The db_verify messages (or lack of them) is shown below for the 
midnight and 8:00AM databases.  The mail server is running 
bogofilter-static-0.13.4 (May 28 22:44).  The db3 version is 
db3.3-3.3.11-11mdk.

I've reverted the spamlist.db to the previous good copy.  Any thoughts on 
further checks/diagnostics to run on the bad file?

David



[relson at osage spam-fixups]$ for f in `ls -t wordlists.0603.*/*.db` ; do ls 
-lt $f ; db_verify $f ; done

-rw-r-----    1 relson   wheel     8642560 Jun  3 08:00 
wordlists.0603.0800.bad/spamlist.db
-rw-r-----    1 relson   wheel    14553088 Jun  3 08:00 
wordlists.0603.0800.bad/goodlist.db
db_verify: Page 1299: last item on page sorted greater than parent entry
db_verify: Page 1299: incorrect next_pgno 1300 found in leaf chain (should 
be 3552)
db_verify: Page 1300: incorrect prev_pgno 1299 found in leaf chain (should 
be 3552)
db_verify: DB->verify: wordlists.0603.0800.bad/goodlist.db: DB_VERIFY_BAD: 
Database verification failed

-rw-r-----    1 relson   wheel    14307328 Jun  2 23:59 
wordlists.0603.0000.ok/goodlist.db
-rw-r-----    1 relson   wheel     8220672 Jun  2 23:59 
wordlists.0603.0000.ok/spamlist.db