Bug 53709 - index: nextcloudEnabled not indexed - mdb_presence_candidates
index: nextcloudEnabled not indexed - mdb_presence_candidates
Status: NEW
Product: UCS
Classification: Unclassified
Component: LDAP
UCS 5.0
Other Linux
: P5 normal (vote)
: ---
Assigned To: UCS maintainers
UCS maintainers
https://unix.stackexchange.com/questi...
:
Depends on: 48835
Blocks:
  Show dependency treegraph
 
Reported: 2021-08-27 11:38 CEST by Arvid Requate
Modified: 2023-07-12 18:25 CEST (History)
7 users (show)

See Also:
What kind of report is it?: Development Internal
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

Note You need to log in before you can comment on or make changes to this bug.
Description Arvid Requate univentionstaff 2021-08-27 11:38:13 CEST
I just had to handle a system where I found this line repeated very often in syslog:

Aug 27 00:01:33 server slapd[820]: <= mdb_equality_candidates: (nextcloudEnabled) not indexed


root@server:# grep -c 'mdb_equality_candidates: (nextcloudEnabled) not indexed' /var/log/syslog /var/log/syslog.1
/var/log/syslog:5175
/var/log/syslog.1:10620

root@server:# univention-app info
UCS: 5.0-0 errata75
Installed: [...stuff...] 4.4/nextcloud=21.0.4-0


The system was updated from UCS 4.4 and setup.log shows it was installed with

UCS Linux 4.4 GNU/Linux 4.4-0 _Ucs440_ - Official amd64 DVD Binary-1 20190311-13:38



+++ This bug was initially created as a clone of Bug #48835 +++
Comment 1 Dirk Ahrnke univentionstaff 2021-11-02 09:18:02 CET
I have seen that yesterday again during setup of a PoC for a customer. 
It is worth to mention that the cause is different than for the bug that is linked as "depends on" here. 
In Bug 48835 a situation is described where the attributes that have already been added to be indexed where removed during an upgrade. 

In this case we should finally address the long known problem that an application which is installed through the App Center enables new attributes without taking care of proper indexing. I guess that this is the case for other "Apps" too. 

From my point of view this bug is a duplicate of Bug 49748
Comment 2 Dirk Ahrnke univentionstaff 2023-07-12 17:16:49 CEST
this problem is of course still not addressed. 

and it is most likely one of the reasons why the performance if the Nextcloud integration is poor


root@c:~# occ ldap:show-config |grep nextcloudEnabled
| ldapGroupFilter               | (&(objectclass=nextcloudGroup)(nextcloudEnabled=1))          |
| ldapLoginFilter               | (&(objectclass=nextcloudUser)(nextcloudEnabled=1)(uid=%uid)) |
| ldapUserFilter                | (&(objectclass=nextcloudUser)(nextcloudEnabled=1))           |
root@c:~# 

This means that most ldap-queries are using a filter which is known to be slow. 

For me it doesnt make any sense to think about splitting the Nextcloud-App into pieces (epic 595) without thinking to address obvious things.