Attachment 318017 Details for Bug 464700 – The relevant catalina.out for this.

The relevant catalina.out for this.

catalina.out (text/plain), 37.06 KB, created by Jeremy Mueller on 2008-09-29 22:23:13 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jeremy Mueller

Created: 2008-09-29 22:23:13 UTC

Size: 37.06 KB

patch

obsolete

>2008-09-29 17:13:26,889 [TP-Processor5] WARN  org.hibernate.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
>2008-09-29 17:13:26,891 [TP-Processor5] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint (SPACEWALK.RHN_ERRATAFILE_EID_FILE_UQ) violated
>
>2008-09-29 17:13:26,891 [TP-Processor5] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
>org.hibernate.exception.ConstraintViolationException: could not insert: [com.redhat.rhn.domain.errata.impl.PublishedErrataFile]
>	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:839)
>	at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:496)
>	at com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:34)
>	at com.redhat.rhn.domain.channel.ChannelFactory.refreshNewestPackageCache(ChannelFactory.java:379)
>	at com.redhat.rhn.manager.channel.ChannelManager.refreshWithNewestPackages(ChannelManager.java:145)
>	at com.redhat.rhn.domain.errata.ErrataFactory.publishErrataPackagesToChannel(ErrataFactory.java:295)
>	at com.redhat.rhn.domain.errata.ErrataFactory.publishToChannel(ErrataFactory.java:231)
>	at com.redhat.rhn.frontend.xmlrpc.errata.ErrataHandler.publish(ErrataHandler.java:788)
>	at com.redhat.rhn.frontend.xmlrpc.errata.ErrataHandler.create(ErrataHandler.java:719)
>	at sun.reflect.GeneratedMethodAccessor682.invoke(Unknown Source)
>	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>	at java.lang.reflect.Method.invoke(Method.java:616)
>	at com.redhat.rhn.frontend.xmlrpc.BaseHandler.invoke(BaseHandler.java:106)
>	at redstone.xmlrpc.XmlRpcDispatcher.dispatch(XmlRpcDispatcher.java:123)
>	at com.redhat.rhn.frontend.xmlrpc.RhnXmlRpcServer.execute(RhnXmlRpcServer.java:53)
>	at com.redhat.rhn.frontend.xmlrpc.XmlRpcServlet.doPost(XmlRpcServlet.java:162)
>	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
>	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.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:283)
>	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
>	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
>	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
>	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
>	at java.lang.Thread.run(Thread.java:636)
>Caused by: java.sql.SQLException: ORA-00001: unique constraint (SPACEWALK.RHN_ERRATAFILE_EID_FILE_UQ) violated
>
>	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.executeForRows(T4CPreparedStatement.java:970)
>	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
>	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
>	at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
>	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
>	... 57 more
>2008-09-29 17:13:26,894 [TP-Processor5] ERROR com.redhat.rhn.frontend.xmlrpc.BaseHandler - Error calling method: 
>java.lang.reflect.InvocationTargetException
>	at sun.reflect.GeneratedMethodAccessor682.invoke(Unknown Source)
>	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>	at java.lang.reflect.Method.invoke(Method.java:616)
>	at com.redhat.rhn.frontend.xmlrpc.BaseHandler.invoke(BaseHandler.java:106)
>	at redstone.xmlrpc.XmlRpcDispatcher.dispatch(XmlRpcDispatcher.java:123)
>	at com.redhat.rhn.frontend.xmlrpc.RhnXmlRpcServer.execute(RhnXmlRpcServer.java:53)
>	at com.redhat.rhn.frontend.xmlrpc.XmlRpcServlet.doPost(XmlRpcServlet.java:162)
>	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
>	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.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:283)
>	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
>	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
>	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
>	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
>	at java.lang.Thread.run(Thread.java:636)
>Caused by: com.redhat.rhn.common.hibernate.HibernateRuntimeException: HibernateException executing CachedStatement
>	at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:509)
>	at com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:34)
>	at com.redhat.rhn.domain.channel.ChannelFactory.refreshNewestPackageCache(ChannelFactory.java:379)
>	at com.redhat.rhn.manager.channel.ChannelManager.refreshWithNewestPackages(ChannelManager.java:145)
>	at com.redhat.rhn.domain.errata.ErrataFactory.publishErrataPackagesToChannel(ErrataFactory.java:295)
>	at com.redhat.rhn.domain.errata.ErrataFactory.publishToChannel(ErrataFactory.java:231)
>	at com.redhat.rhn.frontend.xmlrpc.errata.ErrataHandler.publish(ErrataHandler.java:788)
>	at com.redhat.rhn.frontend.xmlrpc.errata.ErrataHandler.create(ErrataHandler.java:719)
>	... 40 more
>Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [com.redhat.rhn.domain.errata.impl.PublishedErrataFile]
>	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:839)
>	at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:496)
>	... 47 more
>Caused by: java.sql.SQLException: ORA-00001: unique constraint (SPACEWALK.RHN_ERRATAFILE_EID_FILE_UQ) violated
>
>	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.executeForRows(T4CPreparedStatement.java:970)
>	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
>	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
>	at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
>	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
>	... 57 more
>2008-09-29 17:13:26,896 [TP-Processor5] ERROR com.redhat.rhn.frontend.xmlrpc.BaseHandler - Caused by: 
>com.redhat.rhn.common.hibernate.HibernateRuntimeException: HibernateException executing CachedStatement
>	at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:509)
>	at com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:34)
>	at com.redhat.rhn.domain.channel.ChannelFactory.refreshNewestPackageCache(ChannelFactory.java:379)
>	at com.redhat.rhn.manager.channel.ChannelManager.refreshWithNewestPackages(ChannelManager.java:145)
>	at com.redhat.rhn.domain.errata.ErrataFactory.publishErrataPackagesToChannel(ErrataFactory.java:295)
>	at com.redhat.rhn.domain.errata.ErrataFactory.publishToChannel(ErrataFactory.java:231)
>	at com.redhat.rhn.frontend.xmlrpc.errata.ErrataHandler.publish(ErrataHandler.java:788)
>	at com.redhat.rhn.frontend.xmlrpc.errata.ErrataHandler.create(ErrataHandler.java:719)
>	at sun.reflect.GeneratedMethodAccessor682.invoke(Unknown Source)
>	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>	at java.lang.reflect.Method.invoke(Method.java:616)
>	at com.redhat.rhn.frontend.xmlrpc.BaseHandler.invoke(BaseHandler.java:106)
>	at redstone.xmlrpc.XmlRpcDispatcher.dispatch(XmlRpcDispatcher.java:123)
>	at com.redhat.rhn.frontend.xmlrpc.RhnXmlRpcServer.execute(RhnXmlRpcServer.java:53)
>	at com.redhat.rhn.frontend.xmlrpc.XmlRpcServlet.doPost(XmlRpcServlet.java:162)
>	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
>	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.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:283)
>	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
>	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
>	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
>	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
>	at java.lang.Thread.run(Thread.java:636)
>Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [com.redhat.rhn.domain.errata.impl.PublishedErrataFile]
>	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:839)
>	at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:496)
>	... 47 more
>Caused by: java.sql.SQLException: ORA-00001: unique constraint (SPACEWALK.RHN_ERRATAFILE_EID_FILE_UQ) violated
>
>	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.executeForRows(T4CPreparedStatement.java:970)
>	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
>	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
>	at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
>	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
>	... 57 more
>2008-09-29 17:13:26,897 [TP-Processor5] ERROR com.redhat.rhn.frontend.xmlrpc.LoggingInvocationProcessor - REQUESTED FROM: *callerIp* CALL: errata.create(5006xb729bcd01e2ad84734ad554c612fa071, {product=RedHat EL 5.2, topic=Test Topic, references=, advisory_type=Bug Fix Advisory, advisory_release=1, description=Testing Descript, advisory_name=ABC123, synopsis=Test Errata, notes=, solution=Test Solution}, [], [], [8580, 5438], 1, [rhel-5.2-i386, rhel-5.2-x86_64]) CALLER: (username) TIME: 32.973 seconds
>redstone.xmlrpc.XmlRpcFault: unhandled internal exception: HibernateException executing CachedStatement
>	at com.redhat.rhn.frontend.xmlrpc.BaseHandler.invoke(BaseHandler.java:129)
>	at redstone.xmlrpc.XmlRpcDispatcher.dispatch(XmlRpcDispatcher.java:123)
>	at com.redhat.rhn.frontend.xmlrpc.RhnXmlRpcServer.execute(RhnXmlRpcServer.java:53)
>	at com.redhat.rhn.frontend.xmlrpc.XmlRpcServlet.doPost(XmlRpcServlet.java:162)
>	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
>	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.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:283)
>	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
>	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
>	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
>	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
>	at java.lang.Thread.run(Thread.java:636)
>Sep 29, 2008 5:13:26 PM redstone.xmlrpc.XmlRpcDispatcher writeError
>WARNING: redstone.xmlrpc.XmlRpcFault: unhandled internal exception: HibernateException executing CachedStatement
>2008-09-29 17:13:27,526 [TP-Processor5] WARN  org.hibernate.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
>2008-09-29 17:13:27,527 [TP-Processor5] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint (SPACEWALK.RHN_ERRATAFILE_EID_FILE_UQ) violated
>
>2008-09-29 17:13:27,527 [TP-Processor5] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
>org.hibernate.exception.ConstraintViolationException: could not insert: [com.redhat.rhn.domain.errata.impl.PublishedErrataFile]
>	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 org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
>	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
>	at com.redhat.rhn.common.hibernate.ConnectionManager.commitTransaction(ConnectionManager.java:201)
>	at com.redhat.rhn.common.hibernate.HibernateFactory.commitTransaction(HibernateFactory.java:274)
>	at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:56)
>	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:283)
>	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
>	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
>	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
>	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
>	at java.lang.Thread.run(Thread.java:636)
>Caused by: java.sql.SQLException: ORA-00001: unique constraint (SPACEWALK.RHN_ERRATAFILE_EID_FILE_UQ) violated
>
>	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.executeForRows(T4CPreparedStatement.java:970)
>	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
>	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
>	at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
>	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
>	... 31 more
>2008-09-29 17:13:27,529 [TP-Processor5] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back
>org.hibernate.exception.ConstraintViolationException: could not insert: [com.redhat.rhn.domain.errata.impl.PublishedErrataFile]
>	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 org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
>	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
>	at com.redhat.rhn.common.hibernate.ConnectionManager.commitTransaction(ConnectionManager.java:201)
>	at com.redhat.rhn.common.hibernate.HibernateFactory.commitTransaction(HibernateFactory.java:274)
>	at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:56)
>	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:283)
>	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
>	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
>	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
>	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
>	at java.lang.Thread.run(Thread.java:636)
>Caused by: java.sql.SQLException: ORA-00001: unique constraint (SPACEWALK.RHN_ERRATAFILE_EID_FILE_UQ) violated
>
>	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.executeForRows(T4CPreparedStatement.java:970)
>	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
>	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
>	at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
>	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
>	... 31 more
>2008-09-29 17:13:28,238 [TP-Processor5] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[XMLRPC] - Servlet.service() for servlet XMLRPC threw exception
>com.redhat.rhn.common.hibernate.HibernateRuntimeException: Error during transaction. Rolling back
>	at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:70)
>	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:283)
>	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
>	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
>	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
>	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
>	at java.lang.Thread.run(Thread.java:636)
>Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [com.redhat.rhn.domain.errata.impl.PublishedErrataFile]
>	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 org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
>	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
>	at com.redhat.rhn.common.hibernate.ConnectionManager.commitTransaction(ConnectionManager.java:201)
>	at com.redhat.rhn.common.hibernate.HibernateFactory.commitTransaction(HibernateFactory.java:274)
>	at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:56)
>	... 18 more
>Caused by: java.sql.SQLException: ORA-00001: unique constraint (SPACEWALK.RHN_ERRATAFILE_EID_FILE_UQ) violated
>
>	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.executeForRows(T4CPreparedStatement.java:970)
>	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
>	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
>	at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
>	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
>	... 31 more

Actions: View

Attachments on bug 464700: 318015 | 318017