On Mon, 2009-11-09 at 14:04 -0500, Justin Sherrill wrote: > Mullis, Josh (CCI - Atlanta) wrote: > > > > On Mon, 2009-11-09 at 10:45 -0500, Justin Sherrill wrote: > >> Andy Speagle wrote: > >> > On Sat, 2009-11-07 at 08:48 -0600, [email protected] > >> > <mailto:[email protected]> wrote: > >> >> Good day all, > >> >> > >> >> So I've only got 8 systems registered in spacewalk at this time. > >> >> > >> >> I started loading up the errata via rhn-clone-errata.py from Andy. > >> >> > >> >> After all my errata is loaded, I click on "System Groups" and it > >> >> times-out after a few minutes with a "Service Unavailable" message. > >> >> > >> >> So I search on redhat kbase for this and I find this here: > >> >> > >> >> http://kbase.redhat.com/faq/docs/DOC-19873 > >> >> > >> >> This for the most part fits my problem. > >> >> However if you look at the packages, they are from spacewalk v0.5. > >> >> > >> >> I have spacewalk v0.6 so this issue should be fixed right? > >> >> > >> >> The issue seems to be that it is calculating the errata for all the > >> >> groups and can't do it fast enough. > >> >> If no other solution, would it be possible to disable the errata > >> >> calculation for system groups? > >> > > >> > Hey Josh, > >> > > >> > At this point, I have all errata for RHEL 4 and 5, both 32- and 64-bit, > >> > loaded into my Spacewalk and I don't have any problems with this on SPWK > >> > v0.6 I really can't speak to status of the issue or that KBASE entry, > >> > but I can confirm for you that my 0.6 implementation isn't bugged in > >> > this manner. > >> > > >> > My SPWK server isn't all that robust either. It's a simple ESX VM > >> > running RHEL 5 64-bit. However, with the amount of channel data > >> > (packages and errata) and system data, I ran into the size limit of the > >> > Oracle XE some time ago and migrated it to a production database > >> > server... > >> > > >> > Could you be having some other sort of system or database issue that > >> > would contribute to the speed of the query? > >> > > >> > > >> > > >> > ------------------------------------------------------------------------ > >> > > >> > _______________________________________________ > >> > Spacewalk-list mailing list > >> > [email protected] <mailto:[email protected]> > >> > https://www.redhat.com/mailman/listinfo/spacewalk-list > >> > >> > >> Hey Josh, > >> > >> So this issue exists in spacewalk 0.5 and 0.6, and was discovered by a > >> Satellite customer in Satellite 5.3. We've fixed the issue in the > >> master branch of git, but haven't backported it to 0.6 and rebuilt > >> packages. > >> > >> We have backported it to an errata for Satellite 5.3 which is what that > >> kbase article is describing. > >> > >> > >> If you'd like to apply these fixes yourself, simply apply these two > >> commits: > >> > >> 5713ce473236d273c2a4c1608ec3f7f144e9b4e8 > >> b0b4c2d7e0a0bf55c50d996a35f05d4f6703d0c3 > >> > >> These fixes will be in 0.7 for sure, and if there is enough interest we > >> might be able to backport it to 0.6. > >> > >> -Justin > >> > >> > >> _______________________________________________ > >> Spacewalk-list mailing list > >> [email protected] <mailto:[email protected]> > >> https://www.redhat.com/mailman/listinfo/spacewalk-list > > > > > > > > > > Thanks Andy and Justin for the response. > > > > > > Justin - > > > > Want to make sure I'm doing the right thing here... > > > > I downloaded the full file from the > > 5713ce473236d273c2a4c1608ec3f7f144e9b4e8 revision, then applied the diff > > from b0b4c2d7e0a0bf55c50d996a35f05d4f6703d0c3. > > > > > > Is there an easier way to do this? > > My apologies for my lack of knowledge with git. > > > > The file I'm replacing is > > "/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/DataSource/xml/SystemGroup_queries.xml" > > > > > > Thanks > > -Josh > > > > > > > > > > Just curious, how long > > > > > > > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > Spacewalk-list mailing list > > [email protected] > > https://www.redhat.com/mailman/listinfo/spacewalk-list > > Well actually this is a java page, so you'd need to update the > SystemGroup_queries.xml in the jar (/usr/share/rhn/lib/rhn.jar). > > You should just be able to extract the jar, patch that file with both > diff's, then rezip the jar file. I would just patch the existing file. > > Hope that helps, > > -Justin
Very cool... This worked. Thank you very much!
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
