Bug 34813 – add entryUUID to ldap/index/eq

Bug 34813 - add entryUUID to ldap/index/eq


Summary:	add entryUUID to ldap/index/eq

Status:	CLOSED FIXED

Product:	UCS
Classification:	Unclassified
Component:	LDAP
Version:	UNSTABLE
Hardware:	Other Linux

Importance:	P5 normal (vote)
Target Milestone:	UCS 3.2-1-errata
Assigned To:	Philipp Hahn
QA Contact:	Stefan Gohmann

URL:
Keywords:

Depends on:
Blocks:	34815
	Show dependency tree / graph

Reported:	2014-05-12 15:56 CEST by Felix Botner
Modified:	2014-05-20 12:57 CEST (History)
CC List:	2 users (show)

See Also:
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:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Felix Botner

2014-05-12 15:56:42 CEST

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:35:18 CEST

Added entryUUID to ldap/index/eq.
r50305 | Bug #34813 LDAP: Add entryUUID to LDAP index

ucs-3.2-1/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    0m5.220s
user    0m0.040s
sys     0m0.060s

Comment 2 Philipp Hahn

2014-05-19 11:44:28 CEST

1 VM @ xen12 : 2 CPU, 4 GiB

# apt-get install ucs-test-tools
# import_ldif_without_listener /usr/share/ucs-test-tools/customer5000.ldif
# univention-ldapsearch -LLL entryUUID | sed -ne 's/^entryUUID: //p' >/tmp/uuids
# time univention-ldapsearch -LLL -f /tmp/uuids '(entryUUID=%s)' entryUUID | sed -ne 's/^entryUUID: //p' >/tmp/uuids2

before:
real 387m27.964s (= 6h 27m)

after:
real 0m10.441s
real 0m10.124s
real 0m9.476s

Comment 3 Stefan Gohmann

2014-05-20 07:41:31 CEST

YAML: OK

Code: OK

Tests: OK

Comment 4 Moritz Muehlenhoff

2014-05-20 12:57:18 CEST

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