Re: Lock table is out of available locks

[Jon Roberts <jon@jonanddeb.net>]

Howard Chu wrote:
> vadim wrote:
> > I have tried to add some entries to OpenLDAP server 2.3.29.
> > Everything crashes with following error message:
> >
> > bdb(o=bla): Lock table is out of available locks =>
> > bdb_idl_insert_key: c_get failed: Not enough space(12)
> >
> > Do you know what am I doing wrong?

> Sounds like you need to increase the size of the lock table. See the
> note at the bottom of this article.
> http://www.openldap.org/faq/data/cache/893.html
>
> The most common occurrence is running out of locks while creating the 
> substring index for an attribute with many values, or many long values. 
> The longer a value, the more index keys it uses. Each index key gets 
> written with its own lock, all under one BDB transaction. Since 
> transactions don't release locks until the entire transaction completes, 
> updating a single entry can use up a large number of locks.

For long values representing verses from four biblical books in 11 
translations I can do a full substring index and get by with:

set_lk_max_locks 8000
set_lk_max_objects 8000

in my DB_CONFIG.

Jon Roberts
www.mentata.com