[Spacewalk-list] Problems with Upgrade from Spacewalk 2.3 to 2.4, RHEL7

[Gavin Jones]

Hi All,
          I have recently done a spacewalk upgrade in RHEL7 from 2.3 to 2.4.

Everything looked to be fine except now when I login I get this error.

* When I login to spacewalk now I get this error

Internal Server Error
The server experienced a problem which prevented your request from being
filled out. It may not be possible to execute this action at this time.

Please help us correct this problem by contacting us with details of how
you received this message.



- The main error that concerns me in the Tomcat Log is:

org.postgresql.util.PSQLException: ERROR: column userinfo0_.tasko_notify
does not exist
  Position: 174


Obviously something happened during migration to this column,
userinfo0_.tasko_notify in the POSTGRES Database.

I am a novice at postgresql so any advice would be great.

Any ideas, on how to resolve this?


* Here is the Full Output of the Tomcat Log:

Jun 16, 2015 8:24:02 AM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [action] in context with path [/rhn]
threw exception [com.redhat.rhn.common.hibernate.HibernateRuntimeException:
Executing query User.findByLogin with params {loginUc=USER at DOMAIN.LOCAL}
failed] with root cause
org.postgresql.util.PSQLException: ERROR: column userinfo0_.tasko_notify
does not exist
  Position: 174
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
        at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:440)
        at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
        at org.hibernate.loader.Loader.doQuery(Loader.java:674)
        at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
        at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)
        at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
        at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
        at
org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3044)
        at
org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)
        at
org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
        at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
        at
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:179)
        at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
        at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846)
        at
org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:557)
        at org.hibernate.type.EntityType.resolve(EntityType.java:379)
        at
org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:116)
        at
org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854)
        at org.hibernate.loader.Loader.doQuery(Loader.java:729)
        at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
        at org.hibernate.loader.Loader.doList(Loader.java:2220)
        at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
        at org.hibernate.loader.Loader.list(Loader.java:2099)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
        at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
        at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at
org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
        at
com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:185)
        at
com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:161)
        at
com.redhat.rhn.domain.user.UserFactory.lookupByLogin(UserFactory.java:255)
        at
com.redhat.rhn.manager.user.UserManager.loginUser(UserManager.java:462)
        at
com.redhat.rhn.frontend.action.LoginAction.loginUser(LoginAction.java:138)
        at
com.redhat.rhn.frontend.action.LoginAction.execute(LoginAction.java:81)
        at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
        at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
        at
com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:105)
        at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
        at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
 Thanks for your time.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20150616/404d9d0e/attachment.htm>