[spambayes-bugs] [ spambayes-Bugs-788051 ] database corruption (bsddb)

[SourceForge.net]

Bugs item #788051, was opened at 2003-08-13 08:48
Message generated for change (Comment added) made by montanaro
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=498103&aid=788051&group_id=61702

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Michal Vitecek (fufsource)
Assigned to: Nobody/Anonymous (nobody)
>Summary: database corruption (bsddb)

Initial Comment:
when the pop3proxy.py is run for some longish time (2
hours) the database file (DBM) gets corrupted and each
mail then contains:

X-Spambayes-Exception:
bsddb._db.DBRunRecoveryError((-30989,
        'DB_RUNRECOVERY: Fatal error,
        run database recovery')) in __getitem__() at
        /usr/lib/python2.3/bsddb/__init__.py line 86:
return
        self.db[key]

----------------------------------------------------------------------

>Comment By: Skip Montanaro (montanaro)
Date: 2003-08-18 11:21

Message:
Logged In: YES 
user_id=44345

Just a point of reference.  I use bsddb with Berkeley DB 3.3.11
on Mac OS X via the hammie and hammiefilter programs
with no problem.


----------------------------------------------------------------------

Comment By: Michal Vitecek (fufsource)
Date: 2003-08-18 03:09

Message:
Logged In: YES 
user_id=698198

i did some experimenting with various bsddb3 versions:
  - with db-3.3.11 the python segfaults and core is dumped
  - with db-3.2.9 the database is corrupted
  - with db-4.1.25 everything works as it should (no db
corruption)

hth,

----------------------------------------------------------------------

Comment By: Richie Hindle (richiehindle)
Date: 2003-08-15 02:31

Message:
Logged In: YES 
user_id=85414

We still don't know what causes this, but as a workaround
you can delete your spambayes.messageinfo.db file - that
file doesn't (yet) do anything important for pop3proxy, and
it's that file that's becoming corrupt.  A new one will be
created, which may eventually become corrupt as well -
again, just delete it.  You'll need to stop pop3proxy while
you delete it.


----------------------------------------------------------------------

Comment By: Michal Vitecek (fufsource)
Date: 2003-08-13 11:01

Message:
Logged In: YES 
user_id=698198

the operating system is RH 7.2 with those versions of the
Berkeley DB:
db1-1.85-7
db2-2.4.14-7
db3-3.2.9-4

sorry i didn't include this in right away with the bug report.

----------------------------------------------------------------------

Comment By: Tim Peters (tim_one)
Date: 2003-08-13 10:37

Message:
Logged In: YES 
user_id=31435

Which operating system, and which version of Sleepycat's 
Berkeley code (spambayes shouldn't be able to corrupt a 
Berkeley DB, so the problem is probably specific to the bsddb 
version in use)?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=498103&aid=788051&group_id=61702