#90 Error adding new entries to db

[Hendrik Naumann]

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

[Hendrik Naumann]

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]

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

[Matthias Andree]

Logged In: YES
user_id=2788

RTFM, doc/README.db or
http://bogofilter.sourceforge.net/faq.php#locksize