First Last Prev Next    This bug is not in your last search results.
Bug 46280 - (7.8.4/4.2) Performance issue with listgroup and large environments
(7.8.4/4.2) Performance issue with listgroup and large environments
Status: CLOSED FIXED
Product: Z_Internal OX development
Classification: Unclassified
Component: Listener
UCS 4.2 / 7.8.4
Other Linux
: P5 normal (vote)
: 7.8.4-ucs11
Assigned To: Daniel Tröder
Sönke Schwardt-Krummrich
:
Depends on: 45784
Blocks: 46613
  Show dependency tree / graph
 
Reported: 2018-02-13 14:44 CET by Daniel Tröder
Modified: 2018-08-21 13:41 CEST (History)
0 users

See Also:
What kind of report is it?: Bug Report
What type of bug is this?: 5: Major Usability: Impairs usability in key scenarios
Who will be affected by this bug?: 1: Will affect a very few installed domains
How will those affected feel about the bug?: 4: A User would return the product
User Pain: 0.114
Enterprise Customer affected?:
School Customer affected?: Yes
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 Daniel Tröder univentionstaff 2018-02-13 14:44:03 CET 
+++ This bug was initially created as a clone of Bug #45784 +++

In a system with lots of groups, each group create takes a long time if no searchpattern is used.

--- a/univention-ox/share/listener_tools.py
+++ b/univention-ox/share/listener_tools.py
@@ -446,7 +446,7 @@ class OXGroupCache(object):
    '''
    Add group for a specific group and context with data from OX.
    '''
 -  for row in ox_list_group(admuser, admpass, context_id, logger=self.logger):
 +  for row in ox_list_group(admuser, admpass, context_id, searchpattern=groupname, logger=self.logger):
     if row[CSV_GROUP_ROW_GROUPNAME].lower() == groupname.lower():
      self.logger.debug('add_from_ox: groupname=%r  group_id=%r  context_id=%r  displayname=%r  members=%r' % (
       groupname,
Comment 1 Daniel Tröder univentionstaff 2018-02-13 14:52:37 CET 
[4.2 1165546] Bug #46280: speed up group query

univention-ox (9.0.7-12)
Comment 2 Sönke Schwardt-Krummrich univentionstaff 2018-03-16 14:23:48 CET 
I cannot find any advisory in doc/errata/staging.
Comment 3 Daniel Tröder univentionstaff 2018-03-19 07:36:05 CET 
[4.2 fdaf4d3] Bug #46280: advisory
Comment 4 Sönke Schwardt-Krummrich univentionstaff 2018-03-23 18:44:51 CET 
OK: code change
OK: functional change
OK: advisory
First Last Prev Next    This bug is not in your last search results.