Bug 52173 - Higher count of imports in database causes timeout
Higher count of imports in database causes timeout
Status: NEW
Product: UCS@school
Classification: Unclassified
Component: UMC - User Import UI
UCS@school 4.4
Other Linux
: P5 normal (vote)
: ---
Assigned To: UCS@school maintainers
Depends on:
  Show dependency treegraph
Reported: 2020-10-01 17:18 CEST by Dirk Schnick
Modified: 2021-02-05 11:21 CET (History)
2 users (show)

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?: 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
Bug group (optional):
Max CVSS v3 score:


Note You need to log in before you can comment on or make changes to this bug.
Description Dirk Schnick univentionstaff 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 univentionstaff 2021-01-21 15:43:06 CET
Happened in another customer environment.
Comment 4 Dirk Schnick univentionstaff 2021-02-05 08:57:50 CET
More and more customers are complaining this.
Comment 5 Patrick Ziegler univentionstaff 2021-02-05 11:21:09 CET
Added to backlog: https://taiga.knut.univention.de/project/oschwieg-ucs-5/us/5247