Description of problem: While sync the repository facing error PG::ProtocolViolation: ERROR: invalid message format Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. Create a file type repo based on ch14.2: https://access.redhat.com/documentation/en-us/red_hat_satellite/6.5/html-single/content_management_guide/index#Importing_Custom_Content-Creating_a_Custom_File_Type_Repository_Local_Directory // Created just under 65533 tiny files in a repo. # for i in {1..65533}; do echo "$i" > myrepolocation/$i.txt; done // Created a new manifest. # pulp-manifest myrepolocation 2. Initiate the Sync from the "Select Action" button of the repo page After a while, the same error appears. We've hit the same error in other situations where the postgres query using "WHERE" could not handle that large number of parameters Actual results: Showing error PG::ProtocolViolation: ERROR: invalid message format Expected results: Sync should be successful.
This was actually fixed upstream as part of https://github.com/Katello/katello/pull/8171, but was included with a bunch of other stuff that isn't relevant for sat 6.5 and 6.6. I'll attach a patch for 6.5 and 6.6.
Created attachment 1638500 [details] 6.5 patch
Created attachment 1638501 [details] 6.6 patch
I was able to test the 6.6 patch on my lab satellite where I was reproducing the error consistently. After applying the patch, I can now successfully sync a file repo with 70,000 files in it.
Created attachment 1638604 [details] hotfix RPM for Satellite 6.6.0
Hotfix RPM is available for Satellite 6.6.0. To install it: 1. Take a snapshot or complete backup of your Satellite server 2. Download attached file tfm-rubygem-katello-3.12.0.29-2.HOTFIXRHBZ1758250.el7sat.noarch.rpm and copy it to Satellite server 3. # yum install tfm-rubygem-katello-3.12.0.29-2.HOTFIXRHBZ1758250.el7sat.noarch.rpm 4. # systemctl restart httpd
ON_QA Verified @Satellite 6.7.0 Snap 3,0 Steps/Observation: 1. Created a file type repo based on ch14.2: https://access.redhat.com/documentation/en-us/red_hat_satellite/6.5/html-single/content_management_guide/index#Importing_Custom_Content-Creating_a_Custom_File_Type_Repository_Local_Directory // Created just under 65533 tiny files in a repo. // Created a new manifest. # pulp-manifest myrepolocation 2. Initiate the Sync from the "Select Action" button of the repo page 3. Repo sync was successfully completed . 4. Tried with files '130001' as well and repo sync completed successfully. 5. Attached screenshots for reference .
Created attachment 1639346 [details] Screenshot
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHSA-2020:1454