#90 Error adding new entries to db

closed-invalid
nobody
None
5
2004-12-02
2004-12-02
Hendrik Naumann
No

Hi

After dababase loss (see bug #1076110) I tried to
recreate my database. I registered all my Spam messages
of the last two years (~110MB). Bogofilter exit
successfully without error messages.

> bogofilter -vsM < Spamarchiv
# 6081793 words, 23112 messages

After than I wanted to register some ham, this worked
once but with the second mbox file

> bogofilter -vnM < ~/Mail/Privat
# 228822 words, 705 messages
Lock table is out of available locks
bogofilter: (db) db_set_dbvalue( 'abbauen' ), err: 12,
Cannot allocate memory
bogofilter: db_close called with transaction still
open, program fault!

> db4.2_verify ~/.bogofilter/wordlist.db
gives no errors.

I could reproduce the above several times, but the
point of the error varied. I all cases the first run of
bogofilter went successfull.

I tried it with both debian combinations

bogofilter 0.93.1-1 and libdb4.2 4.2.52-17 (sarge)
bogofilter 0.93.1-2 and libdb4.3 4.3.21 (unstable)

If you think this is an packaging error, I will report
this to the debian tracker.

But it seems that some locks are not closed in previos
runs?

Hendrik

Discussion

  • Logged In: YES
    user_id=78470

    Hi

    Ok. RTFM :(. Increasing the locks solved the problem.

    From a usability (using bogofilter as Desktopuser behind the
    Mailclient) point of view, this is verry inconvenient. Isn't
    it possible that bogofilter takes care of it?

    Sorry

    Hendrik

     
  • David Relson
    David Relson
    2004-12-02

    Logged In: YES
    user_id=30510

    Hendrik,
    This question has been asked and answered many times in the
    last 3 weeks. There's lots of info in the RELEASE.NOTES
    and README.db files on working with BerkeleyDB and its
    transaction capability. The current FAQ
    (http://www.bogofilter.org/faq.php or sourceforge) answers
    the question. Also google is a resource to use, i.e.
    google for "bogofilter +'Lock table is out of available locks'".

    HTH,
    David

     
    • status: open --> closed-invalid