Bug #10429
closed
/var/log/rudder/ldap/slapd.log is full of not indexed message
Added by Nicolas CHARLES over 7 years ago.
Updated over 7 years ago.
Category:
System integration
Description
There are gazillions lines of
Mar 15 22:28:42 edited rudder-slapd[2245]: <= mdb_equality_candidates: (isDynamic) not indexed
Mar 15 22:28:42 edited rudder-slapd[2245]: <= mdb_equality_candidates: (nodeGroupId) not indexed
Mar 15 22:28:42 edited rudder-slapd[2245]: <= mdb_equality_candidates: (directiveId) not indexed
Mar 15 22:28:42 edited rudder-slapd[2245]: <= mdb_equality_candidates: (cn) not indexed
Mar 15 22:28:42 edited rudder-slapd[2245]: <= mdb_equality_candidates: (nodeHostname) not indexed
Mar 15 22:28:42 edited rudder-slapd[2245]: <= mdb_equality_candidates: (osName) not indexed
Mar 15 22:28:42 edited rudder-slapd[2245]: <= mdb_equality_candidates: (software) not indexed
Mar 15 22:28:42 edited rudder-slapd[2245]: <= mdb_inequality_candidates: (modifyTimestamp) not indexed
Mar 15 22:28:42 edited rudder-slapd[2245]: <= mdb_equality_candidates: (container) not indexed
Mar 15 22:28:42 edited rudder-slapd[2245]: <= mdb_equality_candidates: (container) not indexed
messages in /var/log/rudder/ldap/slapd.log
don't know if they are relevant, but there is something weird there
Ah, we used to not indexes them because of the cache strategy used before we switched to mdb. It mostly does not make sense anymore, quite the opposite.
- Related to Bug #7667: Disable ldap logging on non existing indexes added
It would make sense to try to index them again by adding in slapd.conf, for database mdb, starting with the following indexes:
# Indices to maintain
index objectClass eq
index isEnabled,isDynamic,isModified,isSystem eq
index uuid eq
index container,software eq
# Software search
index cn,softwareVersion eq
And if it still not make sense to use indexes, we will need to make the same patch on mdb (in #7667) than we did on bdb.
After some tests, it seems that indexes don't bring any gain:
Cycling between several request some hundreds times gave:
Without index:
real 2m39.565s
user 0m22.688s
sys 0m16.208s
With indexes:
real 2m0.766s
user 0m22.554s
sys 0m16.454s
So that's saying that OpenLDAP cache is working ok, and that we still don't really need indexes given our usage. (the real diff is certainly due to the logs not written in the log file).
So, we have to patch mdb like we did bdb.
- Status changed from New to In progress
- Assignee set to Alexis Mousset
- Status changed from In progress to Pending technical review
- Assignee changed from Alexis Mousset to Benoît PECCATTE
- Pull Request set to https://github.com/Normation/rudder-packages/pull/1295
- Status changed from Pending technical review to Pending release
- Status changed from Pending release to Released
- Priority set to 0
This bug has been fixed in Rudder 4.1.0 which was released today.
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by