FS#38506 - {bugtracker} Advanced Search returns blank page or http 500
Attached to Project:
Arch Linux
Opened by Alexander Schnaidt (Namarrgon) - Tuesday, 14 January 2014, 14:53 GMT
Last edited by Toolybird (Toolybird) - Sunday, 04 June 2023, 02:20 GMT
Opened by Alexander Schnaidt (Namarrgon) - Tuesday, 14 January 2014, 14:53 GMT
Last edited by Toolybird (Toolybird) - Sunday, 04 June 2023, 02:20 GMT
|
Details
Description:
An 'Advanced Search' for 'Archlinux' projects with an empty search-field and 'Status' set to 'All Statuses' either results in a blank page or sometimes (under webserver load?) returns an HTTP 500. Additional information: - Searches related to other projects than 'Archlinux' return the expected information. - The 'Miscellaneous' options semm to have no influence on that behavior. Steps to reproduce: 1. open https://bugs.archlinux.org/ 2. set Project to 'Arch Linux' 3. open the 'Advanced' options 4. set 'Status' to 'All Statuses' 5. leave search-field empty 6. hit the search-button |
This task depends upon
Closed by Toolybird (Toolybird)
Sunday, 04 June 2023, 02:20 GMT
Reason for closing: Won't fix
Additional comments about closing: See comments
Sunday, 04 June 2023, 02:20 GMT
Reason for closing: Won't fix
Additional comments about closing: See comments
This is probably from high memory usage when a search finds many tasks of arch fork of Flyspray. Probably the arch web server then just kills the request with the error 500. A look at arch monitoring/logging should verify that.
I think I solved that issue several years ago in the official Flyspray sources. At least I have no problems with a 50k tasks/5k users test install on a cheap shared hosting with apache web server and php7.2
Cannot say much more because I do not know archs flyspray setup and configuration and they use nginx which official is not yet supported because nobody yet provided a nginx setup to Flyspray.
It took me a long time to figure this nginx configuration, but I think it covers everything.
My today's test with 100k tasks and 30k users with current https://github.com/Flyspray/flyspray master branch works ok.
Probably similar problem is handling 30k users on the admin 'editallusers' page that has not yet a pagination or search/filter feature. Handling 2k users is ok with the 'basic' user fields select.
The current Flyspray 1.0-rcX sources assume Apache .htaccess working and is used to restrict direct access to some directories. So when you upgrade adapt your nginx configuration so.
For instance any direct access from outside to any file in the vendor/ directory should be prohibited.
[1] https://lists.archlinux.org/archives/list/arch-dev-public%40lists.archlinux.org/thread/4MSI7GPL5OQCK55ODSWEECYVOTB7N62M/