Bug shows https://pagure.io/freeipa/issue/6722 unindexed searches for two automount related attributes. Unindexed filters can cause performance issues. Automount is commonly used to automatically mount user home directories or other shared resources.
The unindexed filters are:
- Unindexed Filter: (&(automountmapname=auto.direct)(objectclass=automountmap)) (occurrances 2) - Unindexed Filter: (&(automountmapname=auto.master)(objectclass=automountmap)) (occurrances 2) - Unindexed Filter: (&(automountkey=*)(objectclass=automount)) (occurrances 4)
There is already an index cn=automountkey,cn=index,cn=userRoot,cn=ldbm database,cn=plugins,cn=config. However automountkey is only index for eq. A automountkey=* filter seems to use pres index only.
cn=automountkey,cn=index,cn=userRoot,cn=ldbm database,cn=plugins,cn=config
automountkey
eq
automountkey=*
pres
logconf.pl shows unindexed filters
logconf.pl
No unindexed filters
freeipa-server-4.7.0-3
Metadata Update from @cheimes: - Issue tagged with: performance
Metadata Update from @cheimes: - Custom field on_review adjusted to https://github.com/freeipa/freeipa/pull/2649
master:
ipa-4-6:
ipa-4-7:
The new indices will be available in 4.7.3 and next 4.6 update.
Metadata Update from @cheimes: - Issue close_status updated to: fixed - Issue status updated to: Closed (was: Open)
Login to comment on this ticket.