Hi,
while extending an object by adding a lot of maildrop values, slapd refused to MOD with err 80:
May 4 15:31:57 rzhs720 slapd[27004]: conn=1007 op=3 MOD dn="ou=infogroup,ou=foo" May 4 15:31:57 rzhs720 slapd[27004]: conn=1007 op=3 MOD attr=objectClass ou cn mail member maildrop May 4 15:31:57 rzhs720 slapd[27004]: slap_queue_csn: queing 0x7fd30c0c20f0 20120504133157.956217Z#000000#000#000000 May 4 15:31:57 rzhs720 slapd[27004]: bdb(ou=foo): Lock table is out of available locks May 4 15:31:57 rzhs720 slapd[27004]: => bdb_idl_insert_key: c_put id failed: Cannot allocate memory (12) May 4 15:31:57 rzhs720 slapd[27004]: conn=1007 op=3: attribute "maildrop" index add failure
Adding the object with less maildrop entries is not a problem.
# db_stat -c -h /var/lib/ldap/main-data/ 1834 Last allocated locker ID 0x7fffffff 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 7 Number of current locks 1000 Maximum number of locks at any one time 131 Number of current lockers 196 Maximum number of lockers at any one time 8 Number of current lock objects 611 Maximum number of lock objects at any one time 447M Total number of locks requested (447627426) 447M Total number of locks released (447627285) 0 Total number of locks upgraded 550 Total number of locks downgraded 17M Lock requests not available due to conflicts, for which we waited (17614104) 0 Lock requests not available due to conflicts, for which we did not wait 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 544KB The size of the lock region 70M The number of region locks that required waiting (9%)
-rw------- 1 ldap ldap 14M May 4 16:16 mail.bdb -rw------- 1 ldap ldap 9.0M May 4 16:16 maildrop.bdb
# db_stat -m 2GB Total cache size 1 Number of caches 2GB Pool individual cache size 0 Maximum memory-mapped file size 0 Maximum open file descriptors 0 Maximum sequential buffer writes 0 Sleep after writing maximum sequential buffers 0 Requested pages mapped into the process' address space 511M Requested pages found in the cache (99%) 40787 Requested pages not found in the cache 14 Pages created in the cache 40787 Pages read into the cache 20862 Pages written from the cache to the backing file 0 Clean pages forced from the cache 0 Dirty pages forced from the cache 0 Dirty pages written by trickle-sync thread 40801 Current total page count 40801 Current clean page count 0 Current dirty page count 262147 Number of hash buckets used for page location 510M Total number of times hash chains searched for a page (510897500) 2 The longest hash chain searched for a page 564M Total number of hash chain entries checked for page (564617346) 1375049 The number of hash bucket locks that required waiting (0%) 364335 The maximum number of times any hash bucket lock was waited for (0%) 7486 The number of region locks that required waiting (12%) 0 The number of buffers frozen 0 The number of buffers thawed 0 The number of frozen buffers freed 49931 The number of page allocations 0 The number of hash buckets examined during allocations 0 The maximum number of hash buckets examined for an allocation 0 The number of pages examined during allocations 0 The max number of pages examined for an allocation 18790 Threads waited on page I/O Pool File: ou.bdb 4096 Page size 0 Requested pages mapped into the process' address space 8568 Requested pages found in the cache (99%) 30 Requested pages not found in the cache 0 Pages created in the cache 30 Pages read into the cache 579 Pages written from the cache to the backing file Pool File: givenName.bdb 4096 Page size 0 Requested pages mapped into the process' address space 9744 Requested pages found in the cache (92%) 811 Requested pages not found in the cache 0 Pages created in the cache 811 Pages read into the cache 508 Pages written from the cache to the backing file Pool File: mail.bdb 4096 Page size 0 Requested pages mapped into the process' address space 82597 Requested pages found in the cache (96%) 2802 Requested pages not found in the cache 1 Pages created in the cache 2802 Pages read into the cache 3687 Pages written from the cache to the backing file Pool File: uidNumber.bdb 4096 Page size 0 Requested pages mapped into the process' address space 911 Requested pages found in the cache (93%) 63 Requested pages not found in the cache 0 Pages created in the cache 63 Pages read into the cache 134 Pages written from the cache to the backing file Pool File: relativeDomainName.bdb 4096 Page size 0 Requested pages mapped into the process' address space 31932 Requested pages found in the cache (98%) 605 Requested pages not found in the cache 0 Pages created in the cache 605 Pages read into the cache 1890 Pages written from the cache to the backing file Pool File: cn.bdb 4096 Page size 0 Requested pages mapped into the process' address space 51546 Requested pages found in the cache (95%) 2683 Requested pages not found in the cache 2 Pages created in the cache 2683 Pages read into the cache 3198 Pages written from the cache to the backing file Pool File: maildrop.bdb 4096 Page size 0 Requested pages mapped into the process' address space 3908380 Requested pages found in the cache (99%) 2291 Requested pages not found in the cache 0 Pages created in the cache 2291 Pages read into the cache 3938 Pages written from the cache to the backing file Pool File: gidNumber.bdb 4096 Page size 0 Requested pages mapped into the process' address space 1097 Requested pages found in the cache (92%) 89 Requested pages not found in the cache 0 Pages created in the cache 89 Pages read into the cache 172 Pages written from the cache to the backing file Pool File: version.bdb 4096 Page size 0 Requested pages mapped into the process' address space 1744 Requested pages found in the cache (97%) 41 Requested pages not found in the cache 0 Pages created in the cache 41 Pages read into the cache 76 Pages written from the cache to the backing file Pool File: zoneName.bdb 4096 Page size 0 Requested pages mapped into the process' address space 3370 Requested pages found in the cache (99%) 30 Requested pages not found in the cache 0 Pages created in the cache 30 Pages read into the cache 131 Pages written from the cache to the backing file Pool File: entryCSN.bdb 4096 Page size 0 Requested pages mapped into the process' address space 83520 Requested pages found in the cache (99%) 306 Requested pages not found in the cache 0 Pages created in the cache 306 Pages read into the cache 1015 Pages written from the cache to the backing file Pool File: sn.bdb 4096 Page size 0 Requested pages mapped into the process' address space 10019 Requested pages found in the cache (92%) 765 Requested pages not found in the cache 0 Pages created in the cache 765 Pages read into the cache 643 Pages written from the cache to the backing file Pool File: objectClass.bdb 4096 Page size 0 Requested pages mapped into the process' address space 115341 Requested pages found in the cache (99%) 321 Requested pages not found in the cache 0 Pages created in the cache 321 Pages read into the cache 826 Pages written from the cache to the backing file Pool File: uid.bdb 4096 Page size 0 Requested pages mapped into the process' address space 2273 Requested pages found in the cache (91%) 216 Requested pages not found in the cache 0 Pages created in the cache 216 Pages read into the cache 171 Pages written from the cache to the backing file Pool File: id2entry.bdb 16384 Page size 0 Requested pages mapped into the process' address space 499M Requested pages found in the cache (99%) 17796 Requested pages not found in the cache 11 Pages created in the cache 17796 Pages read into the cache 1463 Pages written from the cache to the backing file Pool File: entryUUID.bdb 4096 Page size 0 Requested pages mapped into the process' address space 2183 Requested pages found in the cache (87%) 317 Requested pages not found in the cache 0 Pages created in the cache 317 Pages read into the cache 415 Pages written from the cache to the backing file Pool File: dn2id.bdb 4096 Page size 0 Requested pages mapped into the process' address space 7462379 Requested pages found in the cache (99%) 11621 Requested pages not found in the cache 0 Pages created in the cache 11621 Pages read into the cache 2016 Pages written from the cache to the backing file
# ps -eLf | grep slapd | wc -l 19
Can anyone tell me what happens here and what to do about it?
Marc
--On Tuesday, May 08, 2012 3:41 PM +0200 Marc Patermann hans.moser@ofd-z.niedersachsen.de wrote:
Hi,
while extending an object by adding a lot of maildrop values, slapd refused to MOD with err 80:
Can anyone tell me what happens here and what to do about it?
You ran out of locks. Increase them in your DB_CONFIG file.
1000 Maximum number of locks possible 1000 Maximum number of locks at any one time
--Quanah
--
Quanah Gibson-Mount Sr. Member of Technical Staff Zimbra, Inc A Division of VMware, Inc. -------------------- Zimbra :: the leader in open source messaging and collaboration
Quanah,
Quanah Gibson-Mount schrieb (08.05.2012 17:12 Uhr):
--On Tuesday, May 08, 2012 3:41 PM +0200 Marc Patermann hans.moser@ofd-z.niedersachsen.de wrote:
while extending an object by adding a lot of maildrop values, slapd refused to MOD with err 80:
Can anyone tell me what happens here and what to do about it?
You ran out of locks. Increase them in your DB_CONFIG file.
1000 Maximum number of locks possible 1000 Maximum number of locks at any one time
Does this say the maximum values were actually reached at one time?
Where the other values say that they were not even close the the maximum?
7 Number of current locks 131 Number of current lockers 196 Maximum number of lockers at any one time 8 Number of current lock objects 611 Maximum number of lock objects at any one time
So I have to set like dbconfig set_lk_max_objects 2000 dbconfig set_lk_max_lockers 2000 dbconfig set_lk_max_locks 2000 in slapd.conf, right?
Do I have to rebuild the database by slapcat/rm/slapadd or can these changes be done by one of the db_* tools? (While simply restarting slapd does not activate them.)
Marc
--On May 9, 2012 9:45:52 AM +0200 Marc Patermann hans.moser@ofd-z.niedersachsen.de wrote:
Quanah,
Quanah Gibson-Mount schrieb (08.05.2012 17:12 Uhr):
--On Tuesday, May 08, 2012 3:41 PM +0200 Marc Patermann hans.moser@ofd-z.niedersachsen.de wrote:
while extending an object by adding a lot of maildrop values, slapd refused to MOD with err 80:
Can anyone tell me what happens here and what to do about it?
You ran out of locks. Increase them in your DB_CONFIG file.
1000 Maximum number of locks possible 1000 Maximum number of locks at any one time
Does this say the maximum values were actually reached at one time?
Where the other values say that they were not even close the the maximum?
7 Number of current locks 131 Number of current lockers 196 Maximum number of lockers at any one time 8 Number of current lock objects 611 Maximum number of lock objects at any one time
These numbers say what was currently in use, not what the max was (for current ....)
There are 3 different buckets: lock objects, lockers, and locks. You ran out of locks, and were fine on lockers/lock objects. So the only thing you have to increase is locks. It would probably be wise to increase lock objects as well, because they were getting fairly close. lockers was hardly used.
So I have to set like dbconfig set_lk_max_objects 2000 dbconfig set_lk_max_lockers 2000 dbconfig set_lk_max_locks 2000 in slapd.conf, right?
Correct. As noted above, you probably don't have to increase the lockers value.
Do I have to rebuild the database by slapcat/rm/slapadd or can these changes be done by one of the db_* tools? (While simply restarting slapd does not activate them.)
Stop slapd, remove your existing DB_CONFIG file, and restart slapd should take care of it.
--Quanah
Hi,
Quanah Gibson-Mount schrieb (09.05.2012 10:17 Uhr):
--On May 9, 2012 9:45:52 AM +0200 Marc Patermann hans.moser@ofd-z.niedersachsen.de wrote:
Quanah Gibson-Mount schrieb (08.05.2012 17:12 Uhr):
--On Tuesday, May 08, 2012 3:41 PM +0200 Marc Patermann hans.moser@ofd-z.niedersachsen.de wrote:
while extending an object by adding a lot of maildrop values, slapd refused to MOD with err 80:
Can anyone tell me what happens here and what to do about it?
You ran out of locks. Increase them in your DB_CONFIG file.
1000 Maximum number of locks possible 1000 Maximum number of locks at any one time
So I have to set like dbconfig set_lk_max_objects 2000 dbconfig set_lk_max_lockers 2000 dbconfig set_lk_max_locks 2000 in slapd.conf, right?
Correct. As noted above, you probably don't have to increase the lockers value.
Stop slapd, remove your existing DB_CONFIG file, and restart slapd should take care of it.
Thank you, that worked!
locks reached 1384: 1384 Maximum number of locks at any one time
Marc
--On Wednesday, May 09, 2012 5:18 PM +0200 Marc Patermann hans.moser@ofd-z.niedersachsen.de wrote:
Stop slapd, remove your existing DB_CONFIG file, and restart slapd should take care of it.
Thank you, that worked!
locks reached 1384: 1384 Maximum number of locks at any one time
Glad to hear it. :)
--Quanah
--
Quanah Gibson-Mount Sr. Member of Technical Staff Zimbra, Inc A Division of VMware, Inc. -------------------- Zimbra :: the leader in open source messaging and collaboration
openldap-technical@openldap.org