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:

[r...@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:

[r...@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.standardsessionfac...@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@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Reply via email to