Univention Bugzilla – Full Text Bug Listing |
Summary: | Self service fails with postgres error | ||
---|---|---|---|
Product: | UCS | Reporter: | Florian Best <best> |
Component: | Self Service | Assignee: | Florian Best <best> |
Status: | CLOSED FIXED | QA Contact: | Daniel Tröder <troeder> |
Severity: | normal | ||
Priority: | P5 | CC: | troeder |
Version: | UCS 4.1 | ||
Target Milestone: | UCS 4.1-1-errata | ||
Hardware: | Other | ||
OS: | Linux | ||
What kind of report is it?: | --- | 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): | Error handling, External feedback | |
Max CVSS v3 score: | |||
Bug Depends on: | 40806 | ||
Bug Blocks: | |||
Attachments: |
Screenshot
patch |
Created attachment 7507 [details]
patch
patch: Don't fork a module process for every HTTP request by using the unofficial HTTP basic auth feature of UMC.
Patch applied. As the same UMC module process is used now for every request there might be side effects. Can you please test how the memcached connection and the postgresql connection behaves in terms of timeouts and restarts. The UCR variable umc/module/timeout can be used to specify the seconds how long a module process is kept open when idling. Btw: Can we remove the memcached thing at all with that change? Because the protection against DoS happens in the same process now. If yes, not now. OK: advisory OK: automated tests (ucs-test -E dangerous -s self-service), minor fixes in r67834 OK: manual tests checking number of database connections using: echo "SELECT * FROM pg_stat_activity"| su - postgres -c psql --> One connection per UMC module process. --> One UMC module process per language. --> Max. 35 UMC module processes. |
Created attachment 7504 [details] Screenshot OperationalError: FATAL … See Screenshot.