#7792 Missing index on ipaconfigstring
Closed: fixed Opened by cheimes.

Issue

Bug https://pagure.io/freeipa/issue/7790 and my log analysis of other installations show repeatedly that 389-DS complains about a missing index on ipaconfigstring.

  Unindexed Component #1 (notes=U)
  -  Date/Time:             03/Dec/2018:17:42:08
  -  Connection Number:     289891
  -  Operation Number:      16
  -  Etime:                 0.0000473303
  -  Nentries:              1
  -  IP Address:            172.16.1.81
  -  Search Base:           cn=ops-ovc-ipa-1.ops.example.com,cn=masters,cn=ipa,cn=etc,dc=example,dc=com
  -  Search Scope:          2 (subtree)
  -  Search Filter:         (&(objectclass=ipaconfigobject)(ipaconfigstring=enabledservice)(cn=ca))
  -  Bind DN:               uid=admin,cn=users,cn=accounts,dc=example,dc=com

The ipaConfigString attribute is used in service definition in the cn=masters,cn=ipa,cn=etc,$SUFFIX subtree. It is queried to find active services, servers with a CA, the CA renewal master, and so on. The attribute is not only used during installation and in ipactl, but also in virtually any command that deals with CA, certs, and vault/KRA. Since not every IPA server has to be a CA master, clients and servers use a search with filter (ipaConfigString=enabledService) to locate a CA or KRA server.

Steps to Reproduce

  1. install server
  2. perform vault or cert operations
  3. restart 389-DS or wait until server flushes logs
  4. analyse log file with logconf.pl

Actual behavior

logconf shows unindexed filters with ipaconfigstring.

Expected behavior

There should be no unindexed filters.

Version/Release/Distribution

freeipa-server-4.7.2-0

Additional info:

IPA should add an eq and maybe also a pres index on ipaconfigstring

dn: cn=ipaconfigstring,cn=index,cn=userRoot,cn=ldbm database,cn=plugins,cn=config
objectClass: top
objectClass: nsIndex
cn: ipaconfigstring
nsIndexType: eq
nsIndexType: pres
nsSystemIndex: false

Metadata Update from @cheimes:
- Issue set to the milestone: FreeIPA 4.6.5
- Issue tagged with: performance

Metadata Update from @cheimes:
- Custom field on_review adjusted to https://github.com/freeipa/freeipa/pull/2649

Metadata Update from @cheimes:
- Issue assigned to cheimes

master:

  • 0fb87bfe827b10af25fcd35c327b33977053e0e3 LDAPUpdate: Batch index tasks
  • ed436e4b62c9d3ec02111d486ba77bd09e9838fc Add more LDAP indices
  • a34d92d25c97feb778d4c222704d8ac32e146768 Create reindex task for ipaca DB

ipa-4-6:

  • 55f18a8bd51267dacf6d048ac94179c1a44714b0 LDAPUpdate: Batch index tasks
  • f29ab7730b3b8866f9a10ddaffb0b828b53b1436 Add more LDAP indices
  • 26d90cdd69641d07a11b8f8ddbd340aded42280d Create reindex task for ipaca DB

ipa-4-7:

  • ad37e0c2b76afda289b7795f518ae9a1e0703151 LDAPUpdate: Batch index tasks
  • 903cfe390311b8e21273ceeb2a889974aabc1708 Add more LDAP indices
  • e484c4ba0a54813b84fffab5944d5ccec7a2c3b8 Create reindex task for ipaca DB

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)

Metadata