Tomas,
Sorry and thank you it was my bad, i looked at the issue really early and i saw the update but at first i when i went to the sql directory i missed the "files" for that particular script for "postgres", i emailed as i thought it was a packaging error. I after found out that it was my mistake and had made corrections. In all honesty my bad, though at first (and very sleepy) assumed packaging had no shipped those files. Thank you and sorry and no more checking at 5 am in the morning. Cheers FC From: Tomáš Kašpárek [mailto:tkaspa...@redhat.com] Sent: 04 March 2015 09:28 To: francisco.card...@gmail.com; spacewalk-devel@redhat.com Subject: Re: [Spacewalk-devel] Overnight Issues 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(RequestProces sor.java:427) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcess or.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(Application FilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:206) at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:127) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.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(Application FilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:206) at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(Localiz edEnvironmentFilter.java:67) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:206) at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilte r.java:100) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:206) at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:5 7) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:206) at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetChar acterEncodingFilter.java:97) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va: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.jav a: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(Hi bernateFactory.java:191) at com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(Hi bernateFactory.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(RequestProces sor.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.j ava:48) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.j ava:42) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPe rsister.java:3044) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultL oadEventListener.java:395) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventList ener.java:375) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListen er.java:139) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEven tListener.java:179) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventList ener.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.ja va: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(Hi bernateFactory.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(QueryExecutorI mpl.java:2094) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.ja va:1827) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j ava:508) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2St atement.java:384) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statem ent.java:269) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPrep aredStatement.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.ja va: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
