Re: (ITS#4411) ldapsearch hangs with proxyCache

[daveh@ci.com.au]

On Tue, 28 Feb 2006, Howard Chu wrote:

> Those lock counts are ridiculously high. What does db_stat -c say for 
> this same directory?

Yeah, I thought it was rather high...

mippet:/var/tmp/AdminViewCache [29]# db_stat-4.2 -c -h .
7       Last allocated locker ID.
2147M   Current maximum unused locker ID.
9       Number of lock modes.
1000    Maximum number of locks possible.
1000    Maximum number of lockers possible.
1000    Maximum number of lock objects possible.
5       Number of current locks.
5       Maximum number of locks at any one time.
9       Number of current lockers.
9       Maximum number of lockers at any one time.
3       Number of current lock objects.
3       Maximum number of lock objects at any one time.
5818483 Total number of locks requested.
1939500 Total number of locks released.
0       Total number of lock requests failing because DB_LOCK_NOWAIT was set.
0       Total number of locks not immediately available due to conflicts.
0       Number of deadlocks.
0       Lock timeout value.
0       Number of locks that have timed out.
0       Transaction timeout value.
0       Number of transactions that have timed out.
360KB   The size of the lock region..
0       The number of region locks granted after waiting.
7758015 The number of region locks granted without waiting.

Gadzooks...

> It seems you've run out of BDB lock resources, which can easily happen 
> when you have a lot of indexing configured.

OK, I'll turn off the cache indices for the proxy (except for 
objectClass), and...

Still hangs.

mippet:/var/tmp/AdminViewCache [41]# db_stat-4.2 -c -h .
7       Last allocated locker ID.
2147M   Current maximum unused locker ID.
9       Number of lock modes.
1000    Maximum number of locks possible.
1000    Maximum number of lockers possible.
1000    Maximum number of lock objects possible.
5       Number of current locks.
5       Maximum number of locks at any one time.
9       Number of current lockers.
9       Maximum number of lockers at any one time.
3       Number of current lock objects.
3       Maximum number of lock objects at any one time.
4534675 Total number of locks requested.
1511564 Total number of locks released.
0       Total number of lock requests failing because DB_LOCK_NOWAIT was set.
0       Total number of locks not immediately available due to conflicts.
0       Number of deadlocks.
0       Lock timeout value.
0       Number of locks that have timed out.
0       Transaction timeout value.
0       Number of transactions that have timed out.
360KB   The size of the lock region..
0       The number of region locks granted after waiting.
6046274 The number of region locks granted without waiting.

OK, turn off objectClass as well, and...  Nope, still hangs.  Anything 
else I can do?  There's nothing confidential as such in the directory, so 
if you have access to a FreeBSD box (4.10-STABLE is what we have, but I've 
reproduced it on another box running 4.11-RELEASE) I can send you the lot; 
the entire tree is just over 60Mb.

-- 
Dave Horsfall  DTM  VK2KFU  daveh@ci.com.au  Ph: +61 2 9552-5509 (d) -5500 (sw)
Corinthian Engrng P/L, Ste 54 Jones Bay Whf, 26-32 Pirrama Rd, Pyrmont 2009, AU