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

Benedetto Vassallo vassallo at unipa.it
Mon Nov 22 13:57:42 UTC 2010


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.





More information about the Spacewalk-list mailing list