Re: DB_PAGE_NOTFOUND error

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

John Hinton wrote:
> [root@irongate .spamprobe]# db_recover -v
> db_recover: Recovery complete at Wed Nov 16 16:01:42 2005
> db_recover: Maximum transaction id 80000000 Recovery checkpoint [0][0]
> 
> but I still get the same error. This is happening on only two of many 
> accounts. I'm not much with Berkeley DB, but that is what I'm using, 
> running under CentOS EL 3.6 (a RHEL 3.6 clone).
> 
> Any ideas about how to fix this without asking these users to start all 
> over? I hate egg on my face! :)

Hmm.  Run, do not walk, to PBL. That's not very helpful is it? :-)

The berkeley db database is corrupted.  I googled the error message you 
provided and found some talk on lots of different project forums about 
these errors.  There was some talk that Berkeley DB 4.0.x had some 
issues that led to this?  I really don't know what causes it.  SP uses 
an exclusive lock while updating the database so it can't be a 
concurrency issue unless fcntl() locking is broken.

Things to try:

1. does spamprobe export work?  If so then export to a text file and 
then use import to build a new database.

2. if export won't work maybe you can use db_dump and db_load.  Note 
before using these you should rename the database file or prevent 
spamprobe from running because these commands don't lock the database 
the same way as SP.

    mv sp_words bad_sp_words
    db_dump -r bad_sp_words > bad_sp_words.dump
    db_load sp_words.new < bad_sp_words.dump
    mv sp_words.new sp_words

Hopefully one of those will help.

All the best,
++Brian

-----BEGIN PGP SIGNATURE-----
Version: PGP Desktop 9.0.2 (Build 2425)

iQEVAwUBQ3umRDxRyEoJfXIFAQg3igf/c057klsw6t53Uripgg99gqRa+FE/rcU2
PJt70aDZjjwqhyzWxhmFZD5wkHYjI8vaxeH3XS56nb1Y8ZeSqfZztoQqsosSli6H
e/HvqwYG9dBx/cMC62Pkma8Snjli/dQ2AygWdXqPq2gZTNx7l2XIlwuQmccr4S+A
ym3xFHkvcNNk5qOZNc9ZvuhPh6ICNU7XVaCvv1daS/rEKRG5oOZhlu2Z64YBBcm1
Z4wljed3lZvLkI38Rb0LsPqLDR30GbtgXnn4P8ksQGDCho1n8dj1CUHvS0w7hhAP
6z294zk5mRnkyQs03qL1IG4daLxNilqngSm3/fUkNrX8EVwVAPN/zg==
=WxIG
-----END PGP SIGNATURE-----


-------------------------------------------------------
This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
Register for a JBoss Training Course.  Free Certification Exam
for All Training Attendees Through End of 2005. For more info visit:
http://ads.osdn.com/?ad_id=7628&alloc_id=16845&op=click