Bug 41749 – Useless handling of foreign school groups increases load during squid restart/reload

Bug 41749 - Useless handling of foreign school groups increases load during squid restart/reload


Summary:	Useless handling of foreign school groups increases load during squid restart...

Status:	CLOSED FIXED

Product:	UCS@school
Classification:	Unclassified
Component:	Proxy services
Version:	UCS@school 4.1 R2
Hardware:	Other Linux

Importance:	P5 normal (vote)
Target Milestone:	UCS@school 4.1 R2 vXXX
Assigned To:	Florian Best
QA Contact:	Daniel Tröder

URL:
Keywords:	interim-3

Depends on:
Blocks:	43118
	Show dependency tree / graph

Reported:	2016-07-07 17:35 CEST by Sönke Schwardt-Krummrich
Modified:	2016-12-12 13:10 CET (History)
CC List:	2 users (show)

See Also:
What kind of report is it?:	Bug Report
What type of bug is this?:	4: Minor Usability: Impairs usability in secondary scenarios
Who will be affected by this bug?:	4: Will affect most installed domains
How will those affected feel about the bug?:	3: A User would likely not purchase the product
User Pain:	0.274
Enterprise Customer affected?:
School Customer affected?:	Yes
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):	Error handling
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 Sönke Schwardt-Krummrich

2016-07-07 17:35:29 CEST

During reload of squid, the system load is already quite high (see also bug 41361). Since UCS@school 4.1R2 the main groups of all schools ("schueler-$OU", "lehrer-$OU" and "Domain User $OU") are also replicated to each school server.
The listener module pupilgroups.py syncs these large groups also to local UCR (for squidguard) and and indirectly triggers a reload of squid.

The listener module should only sync groups for schools, the school server is responsible for (→ school server is member of "OU${OU}-DC-Edukativnetz").

Comment 1 Markus Dählmann 2016-07-20 17:43:24 CEST

I can confirm that the now visible groups of all the other OUs really cause a massive increase of system load on our school DCs on group modifications. Should be fixed asap.

Comment 2 Florian Best

2016-11-18 16:08:02 CET

Local schools are now omitted. I did not build the package because the buildsystem is not ready yet.

ucs-school-webproxy (12.0.4-1):
r74582 | Bug #41749: adjust listener to only react to groups belonging to local schools

ucs-school-webproxy.yaml:
r74582 | Bug #41749: adjust listener to only react to groups belonging to local schools

Comment 3 Florian Best

2016-11-21 13:38:47 CET

Package: ucs-school-webproxy
Version: 12.0.4-1.123.201611211251

Comment 4 Daniel Tröder

2016-11-29 15:40:44 CET

OK: code change
OK: manual test
OK: added automated test 122_pupilgroups_updates_ucr
OK: advisory

Comment 5 Sönke Schwardt-Krummrich

2016-12-12 13:10:24 CET

UCS@school 4.1 R2 v9 has been released.

http://docs.software-univention.de/changelog-ucsschool-4.1R2v9-de.html