Bug 34815

Summary:	add entryUUID to ldap/index/eq
Product:	UCS	Reporter:	Stefan Gohmann <gohmann>
Component:	LDAP	Assignee:	Philipp Hahn <hahn>
Status:	CLOSED FIXED	QA Contact:	Stefan Gohmann <gohmann>
Severity:	normal
Priority:	P5	CC:	botner, gohmann, jmm
Version:	UNSTABLE
Target Milestone:	UCS 3.2-2-errata
Hardware:	Other
OS:	Linux
What kind of report is it?:	---	What type of bug is this?:	---
Who will be affected by this bug?:	---	How will those affected feel about the bug?:	---
User Pain:		Enterprise Customer affected?:
School Customer affected?:		ISV affected?:
Waiting Support:		Flags outvoted (downgraded) after PO Review:
Ticket number:		Bug group (optional):
Max CVSS v3 score:
Bug Depends on:	34813
Bug Blocks:

Description Stefan Gohmann

2014-05-12 18:39:42 CEST

Should be fixed for UCS 3.2-2-errata too.


+++ This bug was initially created as a clone of Bug #34813 +++

Seems that the listener looks for entryUUID, which is not indexed 

-> ucr set ldap/debug/level='256'
-> udm users/user create ...

/var/log/syslog:
...
May 12 16:03:12 master slapd[21341]: conn=1084 op=8 SRCH base="dc=w2k12,dc=test" scope=2 deref=0 filter="(entryUUID=e61b8256-6e29-1033-9a0b-4f930effdc4f)"
May 12 16:03:12 master slapd[21341]: conn=1084 op=8 SRCH attr=* +
May 12 16:03:12 master slapd[21341]: <= bdb_equality_candidates: (entryUUID) not indexed
...

Comment 1 Philipp Hahn

2014-05-15 15:41:45 CEST

Added entryUUID to ldap/index/eq.
r50306 | Bug #34815 LDAP: Add entryUUID to LDAP index

ucs-3.2-2/doc/errata/staging/2014-05-15-univention-ldap.yaml
r50311 | Bug #34813,#34815 LDAP: Add entryUUID to LDAP index


# ucr get ldap/index/eq | grep -o entryUUID
entryUUID

# univention-ldapsearch -LLL entryUUID | sed -ne 's/^entryUUID: //p' > /tmp/uuids
# #univention-ldapsearch -LLL -f /tmp/uuid '(entryUUID=%)' dn entryUUID >/dev/null
# time xargs -a /tmp/uuids -r -n1 -I % ldapsearch -D "uid=Administrator,cn=users,$(ucr get ldap/base)" -w univention -LLL '(entryUUID=%)' dn entryUUID >/dev/null

before:
real    0m6.287s
user    0m0.020s
sys     0m0.076s

after:
real    0m4.494s
user    0m0.020s
sys     0m0.040s

Comment 2 Stefan Gohmann

2014-05-20 07:51:22 CEST

YAML: OK

Code: OK

Tests: OK

Comment 3 Moritz Muehlenhoff

2014-05-20 12:57:28 CEST

http://errata.univention.de/ucs/3.2/115.html