On Friday, February 17, 2012 9:06:56 AM, Wojtak, Greg (Superfly) wrote: > Hi there, > > Spacewalk 1.6 > Postgres > Cent 6.2 (64-bit) > > Has anyone else run into an issue where, when updating a kickstart profile > (or cloning, or doing anything with it really) that you consistently time out > with a 500 error after the request times out? > > What I'm seeing looks to be nothing more than the query (queries?) taking too > long to run. I can see the queries while I'm waiting for a response after I > hit the "Update Profile" button. Eventually, when the request times out and > the query finally finishes and I browse back into Spacewalk, I get the > message at the top of the screen that the profile has been updated > successfully (and indeed it appears it has been). > > I've increased the HTTP timeout to 300 seconds (from 120) to try and work > around this, but should it really take five minutes to update a profile? > > The one query I was able to capture during this was: > SELECT CP.package_id, CP.name_id, CP.evr_id, CP.package_arch_id FROM > rhnPackageName PN inner join rhnChannelNewestPackage CP on CP.name_id = PN.id > inner join rhnChannel C on C.id = Cp.channel_id inner join rhnPackage P on > P.id = CP.package_id inner join rhnPackageEvr EVR on P.evr_id = EVR.id WHERE > ( C.id = $1 or C.parent_channel = $2) AND PN.name = $3 AND C.label not like > '%beta%' order by EVR.evr DESC > > (sorry for the bad formatting) > > I'm not sure what the $1, $2, and $3 are (I presume this is calling some sort > of a procedure and those are arguments). > > Thanks! > > Greg > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list
Yes, I have the timeout issue as well with "500 Error". I, too, have altered the /etc/httpd/conf/httpd.conf from "Timeout 60" (default) to "Timeout 300". However, any kickstart updates in my installation of CentOS 6.2/SW 1.6/Postgresql take about 70 seconds to complete. _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
