| Summary: | Error 500 on AJAX request when trying to add Package Group to filter | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | yohan.bataille | ||||
| Component: | Content Views | Assignee: | satellite6-bugs <satellite6-bugs> | ||||
| Status: | CLOSED WONTFIX | QA Contact: | |||||
| Severity: | medium | Docs Contact: | |||||
| Priority: | medium | ||||||
| Version: | 6.1.9 | CC: | bbuckingham, jcallaha, yohan.bataille | ||||
| Target Milestone: | Unspecified | Keywords: | Triaged | ||||
| Target Release: | Unused | ||||||
| Hardware: | x86_64 | ||||||
| OS: | Linux | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | If docs needed, set a value | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2018-08-02 21:00:50 UTC | Type: | Bug | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Attachments: |
|
||||||
Hi, I have attempted to reproduce this issue on both Satellite 6.1.9 and 6.2; however, I have been unsuccessful. Would it be possible for you to re-generate the error, create a foreman-debug and attach it to the bugzilla? Does this occur for all content views or only certain ones? For those that it does occur it may be useful to get a list of the repositories that have been associated, if available. Hi, I reproduced it. Here are more detailed steps (the order of step 5+6 and 7 is crucial) : 1) I created a new content view 2) I added 2 repositories : "Red Hat Enterprise Linux 7 Server - Extras RPMs x86_64" and "Red Hat Enterprise Linux 7 Server RPMs x86_64 7Server" 3) I went to "filters" (in "yum content") and clicked "new filter" 4) I chose "content type : Package Group" and "type : include" 5) In "affected repositories", I clicked "This filter applies only to a subset of repositories in the content view." and selected only "Red Hat Enterprise Linux 7 Server - Extras RPMs x86_64" 6) I clicked "update repositories" 7) I clicked on the "Add" tab and the list of Package Group never showed up (in my web browser console, I see a 500 status for the GET request with the error message in the bug report) I'll attach the foreman-debug log file. The bug occurs for all content views. Still in the process of getting a proper foreman-debug log file : - this is a big production system and it takes more than 10 minutes for foreman-debug to finish. - by then, so much logs have been written that the relevant lines are not included in the archive (I checked the timestamps). I'm guessing I need to run it like this "foreman-debug -m 50000", then extract the archive and remove all the junk to reduce the size below 20Mo, so I can upload it here. This might take a while. Created attachment 1195842 [details]
foreman-debug archive
I had to edit the archive to reduce the file size.
You will find the error at 2016-08-30 11:39:37 in /var/log/foreman/production.log
Thank you for your interest in Satellite 6. We have evaluated this request, and we do not expect this to be implemented in the product in the forseeable future. We are therefore closing this out as WONTFIX. If you have any concerns about this, please feel free to contact Rich Jerrido or Bryan Kearney. Thank you. |
Description of problem: When creating a filter on the Satellite web interface, if we select only one repository (subset) for a filter of type Package Group, it hangs (error 500 on AJAX request) on the tab to add Package Groups and the list of Package Groups won't show. How reproducible: Everytime. Steps to Reproduce: 1.Create a new filter (type Package group) on a content view. 2.Select only a subset (tested with one of two) of repositories. 3.Go to "add" tab : the list of Package Groups won't load. Actual results: The list of Package Groups won't load. Expected results: The list of Package Groups should be displayed. Additional info: PGError: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 1: ...products"."id" FROM "katello_products" ) ORDER BY katello_re... ^ SELECT DISTINCT katello_repositories.pulp_id FROM "katello_repositories" INNER JOIN "katello_content_view_filters_repositories" ON "katello_repositories"."id" = "katello_content_view_filters_repositories"."repository_id" WHERE "katello_content_view_filters_repositories"."content_view_filter_id" = 51 AND "katello_repositories"."product_id" IN (SELECT "katello_products"."id" FROM "katello_products" ) ORDER BY katello_repositories.name ASC" If I select the package groups first then select only a subset of repositories, It works.