Greetings,

I have a fresh Spacewalk 2.3 install that I'm using for Oracle Linux 6.

I created an OL6 channel and repo, then cloned the channel to a DEV channel 
with the Current state of the channel (all errata) option checked.

I then cloned the DEV channel to a QA channel. When I view Cloned Errata and 
select the QA channel, roughly 1700 errata are listed, and their status is not 
cloned. When I try to publish any of the errata to the QA channel I get the 
below java stack trace.

If I go into channel management and try to add or sync errata it doesn't show 
any errata, so this makes me think that the DEV and QA channels match, which 
they do for number of pkgs and errata, so I'm not sure why the Cloned Errata 
tab is showing them as available to be cloned. Has anyone else seen this issue 
with cloned channels?

Exception:
javax.servlet.ServletException: 
com.redhat.rhn.common.hibernate.HibernateRuntimeException: HibernateException 
executing CachedStatement
        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: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: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:744)
Caused by: com.redhat.rhn.common.hibernate.HibernateRuntimeException: 
HibernateException executing CachedStatement
        at 
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:482)
        at 
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:443)
        at 
com.redhat.rhn.common.db.datasource.CachedStatement.executeUpdate(CachedStatement.java:276)
        at 
com.redhat.rhn.common.db.datasource.WriteMode.executeUpdate(WriteMode.java:33)
        at 
com.redhat.rhn.manager.errata.ErrataManager.clearErrataChannelNotifications(ErrataManager.java:1576)
        at 
com.redhat.rhn.domain.errata.AbstractErrata.addChannelNotification(AbstractErrata.java:618)
        at 
com.redhat.rhn.manager.errata.ErrataManager.addChannelsToErrata(ErrataManager.java:204)
        at 
com.redhat.rhn.manager.errata.ErrataManager.publish(ErrataManager.java:162)
        at 
com.redhat.rhn.frontend.action.errata.ChannelAction.publish(ChannelAction.java:94)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at 
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
        at 
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
        at 
org.apache.struts.actions.LookupDispatchAction.execute(LookupDispatchAction.java:146)
        at 
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
        ... 40 more
Caused by: org.hibernate.exception.ConstraintViolationException: could not 
insert: [com.redhat.rhn.domain.errata.impl.PublishedClonedErrata]
        at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
        at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
        at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
        at 
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
        at 
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
        at 
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at 
com.redhat.rhn.common.db.datasource.CachedStatement.stealConnection(CachedStatement.java:892)
        at 
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:454)
        ... 56 more
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value 
violates unique constraint "rhn_errata_advisory_uq"
        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.executeUpdate(AbstractJdbc2Statement.java:330)
        at 
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:469)
        at 
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
        at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
        ... 66 more




_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list

Reply via email to