[Spacewalk-list] [SW 1.7 I nternal Error when asigning rpms to channel

Thu Aug 9 08:38:01 UTC 2012

Hi Jan,

After looking all log files, this is all I could find. From the little
I understand there is a 'duplicate key value' somewhere?. As I said if
I select just a few packages they get added just fine.

- /var/log/tomcat6/catalina.out:

2012-08-09 10:10:06,418 [TP-Processor7] WARN
org.apache.struts.action.RequestProcessor - Unhandled Exception
thrown: class com.redhat.rhn.common.db.WrappedSQLException
2012-08-09 10:10:06,419 [TP-Processor7] ERROR
com.redhat.rhn.frontend.servlets.SessionFilter - Error during
transaction. Rolling back
javax.servlet.ServletException:
com.redhat.rhn.common.db.WrappedSQLException: ERROR: duplicate key
value violates unique constraint "rhn_cnp_cid_nid_uq"
  Where: SQL statement "insert into rhnChannelNewestPackage
(channel_id, name_id, evr_id, package_id, package_arch_id) (select
channel_id, name_id, evr_id, package_id, package_arch_id from
rhnChannelNewestPackageView where channel_id =  $1  and ( $2  is null
or name_id =  $2 ) )"
PL/pgSQL function "refresh_newest_package" line 8 at SQL statement
	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:99)
	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:91)
	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:108)
	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:55)
	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:679)
Caused by: com.redhat.rhn.common.db.WrappedSQLException: ERROR:
duplicate key value violates unique constraint "rhn_cnp_cid_nid_uq"
  Where: SQL statement "insert into rhnChannelNewestPackage
(channel_id, name_id, evr_id, package_id, package_arch_id) (select
channel_id, name_id, evr_id, package_id, package_arch_id from
rhnChannelNewestPackageView where channel_id =  $1  and ( $2  is null
or name_id =  $2 ) )"
PL/pgSQL function "refresh_newest_package" line 8 at SQL statement
	at com.redhat.rhn.common.translation.SqlExceptionTranslator.postgreSqlException(SqlExceptionTranslator.java:54)
	at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:44)
	at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:118)
	at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:511)
	at com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:34)
	at com.redhat.rhn.domain.channel.ChannelFactory.refreshNewestPackageCache(ChannelFactory.java:581)
	at com.redhat.rhn.manager.channel.ChannelManager.refreshWithNewestPackages(ChannelManager.java:179)
	at com.redhat.rhn.manager.channel.ChannelManager.refreshWithNewestPackages(ChannelManager.java:166)
	at com.redhat.rhn.frontend.action.channel.manage.ChannelPackagesAddConfirmAction.addPackages(ChannelPackagesAddConfirmAction.java:129)
	at com.redhat.rhn.frontend.action.channel.manage.ChannelPackagesAddConfirmAction.execute(ChannelPackagesAddConfirmAction.java:94)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
	... 40 more
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key
value violates unique constraint "rhn_cnp_cid_nid_uq"
  Where: SQL statement "insert into rhnChannelNewestPackage
(channel_id, name_id, evr_id, package_id, package_arch_id) (select
channel_id, name_id, evr_id, package_id, package_arch_id from
rhnChannelNewestPackageView where channel_id =  $1  and ( $2  is null
or name_id =  $2 ) )"
PL/pgSQL function "refresh_newest_package" line 8 at SQL statement
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:360)
	at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2417)
	at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:115)
	... 48 more
2012-08-09 10:10:06,523 [RHN Message Dispatcher] WARN
com.redhat.rhn.frontend.events.TraceBackAction - TraceBackAction can't
find localhost!
2012-08-09 10:10:06,523 [RHN Message Dispatcher] ERROR
com.redhat.rhn.common.messaging.ActionExecutor -
com.redhat.rhn.common.messaging.MessageExecuteException:
TraceBackAction can't find localhost!
com.redhat.rhn.common.messaging.MessageExecuteException:
TraceBackAction can't find localhost!
	at com.redhat.rhn.frontend.events.TraceBackAction.getSubject(TraceBackAction.java:51)
	at com.redhat.rhn.frontend.events.BaseMailAction.execute(BaseMailAction.java:41)
	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:679)

- /var/log/tomcat6/localhost.2012-08-09.log:

Aug 9, 2012 10:10:06 AM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet action threw exception
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "rhn_cnp_cid_nid_uq"
  Where: SQL statement "insert into rhnChannelNewestPackage
(channel_id, name_id, evr_id, package_id, package_arch_id) (select
channel_id, name_id, evr_id, package_id, package_arch_id from
rhnChannelNewestPackageView where channel_id =  $1  and ( $2  is null
or name_id =  $2 ) )"
PL/pgSQL function "refresh_newest_package" line 8 at SQL statement
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:360)
        at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2417)
        at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:115)
        at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:511)
        at com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:34)
        at com.redhat.rhn.domain.channel.ChannelFactory.refreshNewestPackageCache(ChannelFactory.java:581)
        at com.redhat.rhn.manager.channel.ChannelManager.refreshWithNewestPackages(ChannelManager.java:179)
        at com.redhat.rhn.manager.channel.ChannelManager.refreshWithNewestPackages(ChannelManager.java:166)
        at com.redhat.rhn.frontend.action.channel.manage.ChannelPackagesAddConfirmAction.addPackages(ChannelPackagesAddConfirmAction.java:129)
        at com.redhat.rhn.frontend.action.channel.manage.ChannelPackagesAddConfirmAction.execute(ChannelPackagesAddConfirmAction.java:94)
        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:99)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
        at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
        at javax.servlet.http.HttpServl

“Free software” is a matter of liberty, not price. To understand the
concept, you should think of “free” as in “free speech”, not as in
“free beer”.

Free software is a matter of the users' freedom to run, copy,
distribute, study, change and improve the software.

On Thu, Aug 9, 2012 at 8:56 AM, Jan Hutař <jhutar at redhat.com> wrote:
> On Wed, 8 Aug 2012 17:17:48 +0200 Registros Web
> <registros.web at gmail.com> wrote:
>
>> Hi all,
>>
>> First of all i'd like to say hello to everyone in the list,
>> since I'm new around here.
>>
>> I'm testing spacewalk 1.7 on Centos 6 and everything has gone
>> smoothly in the installation process, thanks to the guides in
>> the Spacewalk and Centos wikis.
>>
>> But right now I am getting an 'Internal Server Error' when
>> trying to add some rpms (uploaded via rpmpush) to a Software
>> Channel. I have over 1500 unassigned packages and the error
>> occurs when I do a 'Select All', then 'Confirm Addition' and
>> finally press 'Add packages'. If I try adding just a few of
>> them it works fine. if I select to display 25 packages in the
>> page and select all of them visible in the page, they are
>> added just fine. Same happens If I select to display 50
>> packages, but fails when I select 100.
>>
>> Am I doing something wrong or is this some kind of bug?
>>
>> Cheers,
>> Fred.
>
> Hello,
> this sounds more like a bug. Could you please post your logs:
>
> https://fedorahosted.org/spacewalk/wiki/SpacewalkFaq#IgotInternalServerError.Pleasehelp
>
> Thanks,
> Jan
>
>
>
> --
> Jan Hutar     Systems Management QA
> jhutar at redhat.com     Red Hat, Inc.