[Spacewalk-list] Problems after 1.1 -> 1.2 upgrade

Noles, Dave david.noles at petrotechnics.com
Mon Nov 22 14:31:05 UTC 2010 

I seem to be suffering from a similar issue after a 1.1 -> 1.2 upgrade.

The OSAD / Jabber issue is present, but I don’t get any 500 errors on the webapp. I do remember on my initial (1.1) setup I had the same error. I had to modify an SSL related setting regarding jabber, but it seems to be missing from my documentation. If I can resolve the issue ill post back :)

D

-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Benedetto Vassallo
Sent: 22 November 2010 13:58
To: spacewalk-list at redhat.com
Subject: [Spacewalk-list] Problems after 1.1 -> 1.2 upgrade

Hello list,
I upgraded my spacewalk server from v1.1 to v1.2 following the  
instructions at https://fedorahosted.org/spacewalk/wiki/HowToUpgrade  
and when issuing the command /usr/sbin/rhn-satellite start I have a  
notice about osa dispatcher doesn't work:

[root at spacewalk ~]# /usr/sbin/rhn-satellite start
Starting spacewalk services...
Initializing jabberd processes ...
Starting router:                                           [  OK  ]
Starting sm:                                               [  OK  ]
Starting c2s:                                              [  OK  ]
Starting s2s:                                              [  OK  ]
Starting osa-dispatcher: RHN 13752 2010/11/22 14:40:54 +02:00:  
('Traceback (most recent call last):\n  File  
"/usr/share/rhn/osad/jabber_lib.py", line 254, in setup_connection\n    
  c = self._get_jabber_client(js)\n  File  
"/usr/share/rhn/osad/jabber_lib.py", line 311, in _get_jabber_client\n  
    c.connect()\n  File "/usr/share/rhn/osad/jabber_lib.py", line 568,  
in connect\n    jabber.Client.connect(self)\n  File  
"/usr/lib/python2.4/site-packages/jabber/xmlstream.py", line 464, in  
connect\n    else: self._sock.connect((self._hostIP, self._port))\n   
File "<string>", line 1, in connect\nerror: (111, \'Connection  
refused\')\n',)
                                                            [  OK  ]
Starting tomcat5:                                          [  OK  ]
Starting httpd:                                            [  OK  ]
Starting Monitoring ...
         Starting InstallSoftwareConfig ...  [ OK ]
         Starting GenerateNotifConfig ...  [ OK ]
         Starting NotifEscalator ...  [ OK ]
         Starting NotifLauncher ...  [ OK ]
         Starting Notifier ...  [ OK ]
         Starting AckProcessor ...  [ OK ]
         Starting TSDBLocalQueue ...  [ OK ]
[ OK ]
Starting MonitoringScout ...
         Starting NPBootstrap ...  [ OK ]
         Starting SputLite ...  [ OK ]
         Starting Dequeuer ...  [ OK ]
         Starting Dispatcher ...  [ OK ]
[ OK ]
Starting rhn-search...
Starting cobbler daemon: SERVING!
                                                            [  OK  ]
Starting RHN Taskomatic...
Done.

When I issue the command /usr/sbin/rhn-satellite status I see sm and  
c2s are dead:

[root at spacewalk ~]# rhn-satellite status
router (pid 13668) is running...
sm dead but subsys locked
c2s dead but subsys locked
s2s (pid 13740) is running...
osa-dispatcher (pid  13753) is running...
/etc/init.d/tomcat5 is already running (14290)
httpd (pid  14322) is running...
2010-11-22 14:45:23 Monitoring: ----------- InstallSoftwareConfig  
STATUS ---------------
2010-11-22 14:45:23 Monitoring: ----------- GenerateNotifConfig STATUS  
---------------
2010-11-22 14:45:24 Monitoring: ----------- NotifEscalator STATUS  
---------------
2010-11-22 14:45:25 Monitoring: ----------- NotifLauncher STATUS  
---------------
2010-11-22 14:45:25 Monitoring: ----------- Notifier STATUS ---------------
2010-11-22 14:45:26 Monitoring: ----------- AckProcessor STATUS  
---------------
2010-11-22 14:45:26 Monitoring: ----------- TSDBLocalQueue STATUS  
---------------
2010-11-22 14:45:33 MonitoringScout: ----------- InstallSoftwareConfig  
STATUS ---------------
2010-11-22 14:45:33 MonitoringScout: ----------- NPBootstrap STATUS  
---------------
2010-11-22 14:45:33 MonitoringScout: ----------- SputLite STATUS  
---------------
2010-11-22 14:45:34 MonitoringScout: ----------- Dequeuer STATUS  
---------------
2010-11-22 14:45:34 MonitoringScout: ----------- Dispatcher STATUS  
---------------
rhn-search is running (14655).
cobblerd (pid 14870) is running...
RHN Taskomatic is running (14970).


When I access via web-ui and click on systems I got an Internal server  
error and the web traceback is this:

The following exception occurred while executing this request:
GET /rhn/systems/Overview.do

Date:11/22/10 2:42:39 PM CET
Headers:
   host: spacewalk.unipa.it
   connection: Keep-Alive
   user-agent: Mozilla/5.0 (X11; U; Linux x86_64; it-IT)  
AppleWebKit/533.3 (KHTML, like Gecko) rekonq Safari/533.3
   referer: https://spacewalk.unipa.it/rhn/YourRhn.do
   accept: text/html, image/jpeg;q=0.9, image/png;q=0.9, text/*;q=0.9,  
image/*;q=0.9, */*;q=0.8
   accept-encoding: x-gzip, x-deflate, gzip, deflate
   accept-charset: utf-8, utf-8;q=0.5, *;q=0.5
   accept-language: it,en-US;q=0.9,en;q=0.8, it, en_US
   cookie: JSESSIONID=1D1EBD88EC5A1E976E161D6A29C445E3;  
auth_key=ed590246a70526015b020467ed2cde33;  
imp_key=875ac27d19e3728f52dc508c89fc0d31;  
Horde=15lel28htelpa4qf3n7k14n3k3; default_imp_view=dimp;  
pxt-session-cookie=16148xdeb0792bfcdf8121f73dafd8adb2ba51

Request:
Local Name = spacewalk.unipa.it
Server Name = spacewalk.unipa.it
Requested Session Id came from Cookie
Requested Session Valid = true
Session =  
org.apache.catalina.session.StandardSessionFacade at 1757322[session=StandardSession[1D1EBD88EC5A1E976E161D6A29C445E3]]
Protocol = https
Request Locale = en_US
Request Character Encoding = UTF-8
Attribute Names = rhnActiveLang, pageList,  
javax.servlet.jsp.jstl.fmt.timeZone.request, legends, scCrit,  
javax.servlet.error.servlet_name, javax.servlet.request.key_size,  
javax.servlet.request.ssl_session, scMod,  
org.apache.struts.action.MESSAGE, javax.servlet.error.message,  
list_1680466951_rhn_set, javax.servlet.request.cipher_suite,  
parentUrl, javax.servlet.error.request_uri, scBug, groups,  
org.apache.struts.action.MODULE, scImp,  
javax.servlet.error.status_code, list_1680466951_selected_amt, scLow,  
scEhn, requestedUri, session, __sitemesh__filterapplied,  
javax.servlet.error.exception,  
org.apache.struts.action.mapping.instance,


User Information:
User vassallo (id 2, org_id 2)

Exception:
java.sql.SQLException: ORA-01427: single-row subquery returns more  
than one row

         at  
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
         at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
         at  
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
         at  
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
         at  
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1072)
         at  
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)
         at  
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
         at  
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
         at  
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3476)
         at  
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:651)
         at  
com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:138)
         at  
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:455)
         at  
com.redhat.rhn.common.db.datasource.CachedStatement.executeElaboratorBatch(CachedStatement.java:371)
         at  
com.redhat.rhn.common.db.datasource.CachedStatement.executeElaboratorBatch(CachedStatement.java:406)
         at  
com.redhat.rhn.common.db.datasource.CachedStatement.executeElaborator(CachedStatement.java:352)
         at  
com.redhat.rhn.common.db.datasource.SelectMode.elaborate(SelectMode.java:163)
         at  
com.redhat.rhn.common.db.datasource.ModeElaborator.elaborate(ModeElaborator.java:48)
         at  
com.redhat.rhn.frontend.taglibs.list.decorators.ElaborationDecorator.elaborateContents(ElaborationDecorator.java:57)
         at  
com.redhat.rhn.frontend.taglibs.list.decorators.ElaborationDecorator.setCurrentList(ElaborationDecorator.java:37)
         at  
com.redhat.rhn.frontend.taglibs.list.ListTag.doAfterBody(ListTag.java:466)
         at  
org.apache.jsp.WEB_002dINF.pages.systems.overview_jsp._jspx_meth_rl_005flist_005f0(Unknown  
Source)
         at  
org.apache.jsp.WEB_002dINF.pages.systems.overview_jsp._jspx_meth_c_005fif_005f0(Unknown  
Source)
         at  
org.apache.jsp.WEB_002dINF.pages.systems.overview_jsp._jspx_meth_rl_005flistset_005f0(Unknown  
Source)
         at  
org.apache.jsp.WEB_002dINF.pages.systems.overview_jsp._jspService(Unknown  
Source)
         at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
         at  
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
         at  
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
         at  
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
         at  
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469)
         at  
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
         at  
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
         at  
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
         at  
org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)
         at  
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
         at  
com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:82)
         at  
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
         at  
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
         at  
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
         at  
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
         at  
com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:101)
         at  
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
         at  
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
         at  
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142)
         at  
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58)
         at  
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
         at  
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
         at  
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
         at  
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
         at  
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
         at  
com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108)
         at  
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
         at  
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
         at  
com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55)
         at  
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
         at  
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
         at  
com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
         at  
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
         at  
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
         at  
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
         at  
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
         at  
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
         at  
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
         at  
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
         at  
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
         at  
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
         at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
         at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
         at  
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
         at  
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
         at  
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
         at java.lang.Thread.run(Thread.java:636)


What I can do?
Thanks

-- 
Benedetto Vassallo
Sistema Informativo di Ateneo
Settore Gestione Reti Hardware e Software
U.O. Sviluppo e manutenzione dei sistemi
Università degli studi di Palermo

Red Hat Certified Engineer Certificate Number: 804007793324656

Phone: +3909123860056
Fax: +390916529124

-------------------------------------------------------------------------
This message was sent using the University of Palermo web mail interface.


_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Any opinions expressed in this email are those of the author and not necessarily those of Petrotechnics. If you are not the intended recipient of this email, please delete it and notify the sender. For quality assurance purposes, Petrotechnics may monitor incoming business communications. All email and attachments are scanned and free from viruses, although recipients are advised in accordance with best practise to confirm this for themselves.

More information about the Spacewalk-list mailing list