[Spacewalk-list] Database Error - PXTSessions

[Josh.Mullis at cox.com]

Andy,

I believe this has to do with that issue that I had where I had to apply a patch to the rhn.jar file. 

Search for my thread:

"System Groups timesout"


Hope it helps.
-Josh 


----- Original Message -----
From: spacewalk-list-bounces at redhat.com <spacewalk-list-bounces at redhat.com>
To: spacewalk-list at redhat.com <spacewalk-list at redhat.com>
Sent: Wed Dec 02 08:54:17 2009
Subject: Re: [Spacewalk-list] Database Error - PXTSessions

On Tue, 2009-12-01 at 12:35 -0600, Jesus M. Rodriguez wrote:
> On Tue, Dec 1, 2009 at 1:21 PM, Andy Speagle <andy.speagle at wichita.edu> wrote:
> > Hi all...
> >
> > I've had a problem rear its ugly head today.. and I'm loathe to explain
> > it.  Essentially, nearly anything I do in the WebUI times out.  I've
> > tracked it to a database issue.  It seems that I'm running into table
> > contention because anything I try fires up two queries... one SELECT and
> > one UPDATE... the offensive one I believe is the UPDATE.. which is:
> >
> > update PXTSessions set value=:1, web_user_id=:2, expires=:3 where id=:4
> 
> PXTSessions is the way the perl webui handles logged in sessions. It is
> shared with the java webui as well.  If you login with no cookies, we will create
> a new entry, each request updates the table to keep the expires date updated.
> If your login times out, but we get presented with the same cookie value, we simply
> update the record again to re-establish the session (if the row exists).
> 
> So the update above is quite normal. Are you seeing an error?
> 
> >
> > Can anyone speak to this issue?  I don't see anything in the archives
> > regarding this.  What I think happened is this:
> >
> > I have some automated jobs that run via cron on the Spacewalk server as
> > the "admin" user... while one of those was running, I logged into the
> > WebUI as the same user... I suspect that somehow these logins were in
> > contention for session info...
> 
> Are these cron jobs using the API? or are they screen scraping the webui?
> In theory, you should be able to login as many times as you want with the
> same user from different locations. It shouldn't affect anything.
> 
> Are all the jobs presenting the same cookie? That would cause them
> all to use the same sessions which would probably cause some bizarre
> issues.
> 
> Is there an error log in either /var/log/tomcat5/catalina.out or /var/log/httpd/error_log?
> 
> Sincerely,
> jesus

After even more digging... I've found that the function that doesn't
work for me now... is merely the "System Groups" link... 

One thing that may be of interest... is that I recently started
integrated Solaris 10 x86 hosts into my Spacewalk.  There is a group for
these hosts as well... could that have anything to do with it?

-- 
Andy Speagle

"THE Student" - UCATS
Wichita State University