Hello,
Spacewalk nightly is mainly for developers and experienced users so
these breakages are to be expected. I really recommend running stable
2.2 to avoid this sort of problems.
To fix the problem you're experiencing run following sql command
(spacewalk-sql -i command comes in handy).
ALTER TABLE rhnUserInfo ADD COLUMN tasko_notify CHAR(1)
DEFAULT('Y') NOT NULL
CONSTRAINT rhn_user_info_tasko_ck
CHECK (tasko_notify in ('Y', 'N'));
This command can also be found in
/etc/sysconfig/rhn/schema-upgrade/spacewalk-schema-2.2-to-spacewalk-schema-2.3/023-rhnUserInfo.sql
Best regards
Tomas Kasparek
On 03/04/2015 07:19 AM, Francisco Manuel Cardoso wrote:
Morning,
Overnight my spacewalk running on nightly (and i should have freezed
this install ages), has updated with some new rpm’s
Mar 4 03:31:59 accelerates yum[49836]: Updated:
spacewalk-base-minimal-2.3.39-1.el6.noarch
Mar 4 03:31:59 accelerates yum[49836]: Updated:
spacewalk-java-postgresql-2.3.158-1.el6.noarch
Mar 4 03:32:00 accelerates yum[49836]: Updated:
spacewalk-java-lib-2.3.158-1.el6.noarch
Mar 4 03:32:01 accelerates yum[49836]: Updated:
spacewalk-java-config-2.3.158-1.el6.noarch
Mar 4 03:32:01 accelerates yum[49836]: Updated:
spacewalk-base-minimal-config-2.3.39-1.el6.noarch
Mar 4 03:32:04 accelerates yum[49836]: Updated:
spacewalk-base-2.3.39-1.el6.noarch
Mar 4 03:32:04 accelerates yum[49836]: Updated:
spacewalk-pxt-2.3.39-1.el6.noarch
Mar 4 03:32:05 accelerates yum[49836]: Updated:
spacewalk-grail-2.3.39-1.el6.noarch
Mar 4 03:32:06 accelerates yum[49836]: Updated:
spacewalk-sniglets-2.3.39-1.el6.noarch
Mar 4 03:32:07 accelerates yum[49836]: Updated:
spacewalk-taskomatic-2.3.158-1.el6.noarch
Mar 4 03:32:14 accelerates yum[49836]: Updated:
spacewalk-java-2.3.158-1.el6.noarch
Mar 4 03:32:16 accelerates yum[49836]: Updated:
spacewalk-schema-2.3.37-1.el6.noarch
Mar 4 03:32:17 accelerates yum[49836]: Updated:
spacewalk-config-2.3.9-1.el6.noarch
Mar 4 03:32:18 accelerates yum[49836]: Updated:
spacewalk-html-2.3.39-1.el6.noarch
As a result this morning im unable to login with the following pages,
Unable to sign in in any way , after the schema update,
“2015-03-04 06:14:25,737 [TP-Processor2] WARN
org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 42703
2015-03-04 06:14:25,737 [TP-Processor2] ERROR
org.hibernate.util.JDBCExceptionReporter - ERROR: column
userinfo0_.tasko_notify does not exist
Position: 174
2015-03-04 06:14:25,737 [TP-Processor2] WARN
org.apache.struts.action.RequestProcessor - Unhandled Exception
thrown: class com.redhat.rhn.common.hibernate.HibernateRuntimeException
2015-03-04 06:14:25,737 [TP-Processor2] ERROR
com.redhat.rhn.frontend.servlets.SessionFilter - Error during
transaction. Rolling back
javax.servlet.ServletException:
com.redhat.rhn.common.hibernate.HibernateRuntimeException: Executing
query User.findByLogin with params {loginUc=FCARDOSO} failed
at
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:520)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:427)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
at
com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:102)
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:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:127)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129)
at
com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:100)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:57)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:701)
Caused by: com.redhat.rhn.common.hibernate.HibernateRuntimeException:
Executing query User.findByLogin with params {loginUc=FCARDOSO} failed
at
com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:191)
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:457)
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)
... 40 more
Caused by: org.hibernate.exception.SQLGrammarException: could not load
an entity: [com.redhat.rhn.domain.user.legacy.UserInfo#1]
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1874)
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)
... 46 more
Caused by: org.postgresql.util.PSQLException: ERROR: column
userinfo0_.tasko_notify does not exist
Position: 174
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2094)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1827)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:269)
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)
... 72 more
2015-03-04 06:14:25,746 [RHN Message Dispatcher] WARN
com.redhat.rhn.common.messaging.SmtpMail - MessagingException while
trying to send email: javax.mail.SendFailedException: Send failed;
nested exception is:
javax.mail.MessagingException: Connection refused;
nested exception is:
java.net.ConnectException: Connection refused
2015-03-04 06:14:25,746 [RHN Message Dispatcher] ERROR
com.redhat.rhn.common.messaging.ActionExecutor -
com.redhat.rhn.common.messaging.JavaMailException: MessagingException
while trying to send email: javax.mail.SendFailedException: Send failed;
nested exception is:
javax.mail.MessagingException: Connection refused;
nested exception is:
java.net.ConnectException: Connection refused
com.redhat.rhn.common.messaging.JavaMailException: MessagingException
while trying to send email: javax.mail.SendFailedException: Send failed;
nested exception is:
javax.mail.MessagingException: Connection refused;
nested exception is:
java.net.ConnectException: Connection refused
at com.redhat.rhn.common.messaging.SmtpMail.send(SmtpMail.java:145)
at
com.redhat.rhn.frontend.events.BaseMailAction.execute(BaseMailAction.java:43)
at
com.redhat.rhn.common.messaging.ActionExecutor.run(ActionExecutor.java:69)
at
com.redhat.rhn.common.messaging.MessageDispatcher.run(MessageDispatcher.java:58)
at java.lang.Thread.run(Thread.java:701)
Caused by: javax.mail.SendFailedException: Send failed;
nested exception is:
javax.mail.MessagingException: Connection refused;
nested exception is:
java.net.ConnectException: Connection refused
at javax.mail.Transport.doSend(Transport.java:231)
at javax.mail.Transport.send(Transport.java:75)
at com.redhat.rhn.common.messaging.SmtpMail.send(SmtpMail.java:139)
... 4 more
[root@accelerates hpc]#”
Regards,
Francisco
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel