[Spacewalk-list] Spacewalk upgrade from 0.6 to 1.0

Wed May 26 17:14:13 UTC 2010

I am working on upgrade my spacewalk installation to 1.0.

The general process that I used was;

Yum update spacewalk-oracle

Yum update spacewalk

Which seems to update all the  pieces and did not generate any errors.

Upon completion the processes seem to start correctly,

But upon trying to see systems, overview or to see packages inside a channel
generates the following errors;

The following exception occurred while executing this request:

( see below )

Database access seems to be correct (tnsname, userids passwords, show
parameters).

Other than channels and systems most functionality seems correct.

Keys are in place, stats on all channel are correct.

I do also see some hiberation.HibernateRuntimeException and

java.lang.NoClassDefFoundError: org/postgresql/util/PSQLException

Any suggestions on what I need to do to fix this issue?

-Terry

This error occurs with

GET /rhn/channels/ChannelDetail.do

GET /rhn/systems/SystemList.do

GET /rhn/systems/Overview.do

==============================

*GET /rhn/systems/SystemList.do*

* *

*Date:5/26/10 7:55:36 AM PDT*

*Headers:*

*  host: h0595.corp.com*

*  user-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.3)
Gecko/20100401 Firefox/3.6.3*

*  accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8*

*  accept-language: en-us,en;q=0.5*

*  accept-encoding: gzip,deflate*

*  accept-charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7*

*  Keep-Alive: 115*

*  connection: keep-alive*

*  referer: https://h0595.corp.com/rhn/systems/Overview.do*

*  cookie: JSESSIONID=3E7BB09F9C43635BBB9C292CA2810CAE;
pxt-session-cookie=1210xa772573903ccf86495de42ab3c35dbdd*

* *

*Request:*

*Local Name = h0595.corp.com*

*Server Name = h0595.corp.com*

*Requested Session Id came from Cookie*

*Requested Session Valid = true*

*Session =
org.apache.catalina.session.StandardSessionFacade at 83cf00[session=StandardSession[3E7BB09F9C43635BBB9C292CA2810CAE
]]*

*Protocol = https*

*Request Locale = en_US*

*Request Character Encoding = UTF-8*

*Attribute Names = rhnActiveLang, pageList,
javax.servlet.jsp.jstl.fmt.timeZone.request, legends,
javax.servlet.request.key_size, requestedUri,
javax.servlet.request.ssl_session, org.apache.struts.action.MESSAGE,
session, list_1680466951_rhn_set, __sitemesh__filterapplied, parentUrl,
javax.servlet.request.cipher_suite,
org.apache.struts.action.mapping.instance, org.apache.struts.action.MODULE,
*

* *

* *

*User Information:*

*User spacewalk (id 1, org_id 1)*

* *

*Exception:*

*java.sql.SQLException: ORA-00904: "CONFIG_FILES_WITH_DIFFERENCES": invalid
identifier*

* *

*      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.executeForDescribe(T4CPreparedStatement.java:813)
*

*      at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
*

*      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:137)
*

*      at
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:454)
*

*      at
com.redhat.rhn.common.db.datasource.CachedStatement.executeElaboratorBatch(CachedStatement.java:370)
*

*      at
com.redhat.rhn.common.db.datasource.CachedStatement.executeElaboratorBatch(CachedStatement.java:405)
*

*      at
com.redhat.rhn.common.db.datasource.CachedStatement.executeElaborator(CachedStatement.java:351)
*

*      at
com.redhat.rhn.common.db.datasource.SelectMode.elaborate(SelectMode.java:149)
*

*      at
com.redhat.rhn.common.db.datasource.ModeElaborator.elaborate(ModeElaborator.java:44)
*

*      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:422)*

*      at
org.apache.jsp.WEB_002dINF.pages.systems.systemlist_jsp._jspx_meth_rl_005flist_005f0(Unknown
Source)*

*      at
org.apache.jsp.WEB_002dINF.pages.systems.systemlist_jsp._jspx_meth_rl_005flistset_005f0(Unknown
Source)*

*      at
org.apache.jsp.WEB_002dINF.pages.systems.systemlist_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)*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100526/5f0d5abf/attachment.htm>