Bug 52173 – Higher count of imports in database causes timeout

Bug 52173 - Higher count of imports in database causes timeout


Summary:	Higher count of imports in database causes timeout

Status:	NEW

Product:	UCS@school
Classification:	Unclassified
Component:	UMC - User Import UI
Version:	UCS@school 4.4
Hardware:	Other Linux

Importance:	P5 normal (vote)
Target Milestone:	---
Assigned To:	UCS@school maintainers
QA Contact:

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2020-10-01 17:18 CEST by Dirk Schnick
Modified:	2024-04-18 10:41 CEST (History)
CC List:	4 users (show)

See Also:	48658 53383
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?:	3: Will affect average number of installed domains
How will those affected feel about the bug?:	2: A Pain – users won’t like this once they notice it
User Pain:	0.171
Enterprise Customer affected?:	Yes
School Customer affected?:	Yes
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:	2020092121000162, 2021011921000607, 2021020521000257, 2021060421000279, 2021101821000217, 2023103121000126
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 Dirk Schnick

2020-10-01 17:18:01 CEST

In the customer environment were 321 imports saved. The module was not opened and a 504 Error was displayed.
I have seen that the logfile /var/log/univention/ucs-school-import/gunicorn_error.log has logged even more entries than the 504 was already reported.
So I reduced the database entries and the module is shown again.

Currently the problem will not occur so often, but with time the entries will have a higher value for many customers.

An automatic reduction of the entries or an increase of the timeout time should be implemented. 

How to solve the problem manually see first attached ticket Notice 16

Comment 3 Dirk Schnick

2021-01-21 15:43:06 CET

Happened in another customer environment.

Comment 4 Dirk Schnick

2021-02-05 08:57:50 CET

More and more customers are complaining this.

Comment 5 Patrick Ziegler

2021-02-05 11:21:09 CET

Added to backlog: https://taiga.knut.univention.de/project/oschwieg-ucs-5/us/5247

Comment 6 Daniel Tröder

2021-06-03 09:31:20 CEST

When working on this, also check bug 53383. It may be a duplicate or it may add an additional problem (many OUs).

Comment 7 Dirk Schnick

2021-06-04 11:47:40 CEST

And again in a customer environment.

Comment 8 Dirk Schnick 2024-04-18 10:41:40 CEST

To point on that again. There are some environments where the webimport is absolutely essential. Bildungslogin f.e.
In these environments a lot of imports take place and the database grows fast...