<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:748038868;
mso-list-type:hybrid;
mso-list-template-ids:511350176 -1685185586 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-font-family:Calibri;
mso-bidi-font-family:"Times New Roman";}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hi all,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I seem to have a problem removing a package from a channel. Let me describe the situation:<o:p></o:p></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><![if !supportLists]><span style="mso-list:Ignore">-<span style="font:7.0pt "Times New Roman"">
</span></span><![endif]>We have some custom packages in a separate channel in spacewalk<o:p></o:p></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><![if !supportLists]><span style="mso-list:Ignore">-<span style="font:7.0pt "Times New Roman"">
</span></span><![endif]>It seems that a colleague of mine created a new version of a package, ran reposync; updated the package again (keeping the version the same) and ran reposync again<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The result is that in /var/satellite/redhat/, I now have 2 occurrences of the same package name (since the md5sum differs), but in spacewalk only the “oldest” one is being used.<o:p></o:p></p>
<p class="MsoNormal">I wanted to clean up the situation by removing the package from spacewalk, but it seems that even though spacewalk uses only one package, the 2 are somehow present in the database resulting in an error when trying to remove the package
(see below). So I was wondering if there’s any method of forcibly removing the problem entries from the database?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The tomcat catalina error:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">2012-01-09 11:17:21,802 [TP-Processor8] WARN org.apache.struts.action.RequestProcessor - Unhandled Exception thrown: class com.redhat.rhn.common.db.ConstraintViolationException<o:p></o:p></p>
<p class="MsoNormal">2012-01-09 11:17:21,803 [TP-Processor8] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back<o:p></o:p></p>
<p class="MsoNormal">javax.servlet.ServletException: ORA-00001: unique constraint (SPACEWALK_MAIN.RHN_CNP_CID_NID_UQ) violated<o:p></o:p></p>
<p class="MsoNormal">ORA-06512: at "SPACEWALK_MAIN.RHN_CHANNEL", line 1087<o:p></o:p></p>
<p class="MsoNormal">ORA-06512: at line 1<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"> at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237)<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:82)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)<o:p></o:p></p>
<p class="MsoNormal"> at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)<o:p></o:p></p>
<p class="MsoNormal"> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<o:p></o:p></p>
<p class="MsoNormal"> <span lang="FR-BE">at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR-BE"> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR-BE"> </span>at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:101)<o:p></o:p></p>
<p class="MsoNormal">…<o:p></o:p></p>
<p class="MsoNormal"><snip><o:p></o:p></p>
<p class="MsoNormal">…<o:p></o:p></p>
<p class="MsoNormal">Caused by: com.redhat.rhn.common.db.ConstraintViolationException: ORA-00001: unique constraint (SPACEWALK_MAIN.RHN_CNP_CID_NID_UQ) violated<o:p></o:p></p>
<p class="MsoNormal">ORA-06512: at "SPACEWALK_MAIN.RHN_CHANNEL", line 1087<o:p></o:p></p>
<p class="MsoNormal">ORA-06512: at line 1<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.common.translation.SqlExceptionTranslator.oracleSQLException(SqlExceptionTranslator.java:77)<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:42)<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:118)<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:511)<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:34)<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.domain.channel.ChannelFactory.refreshNewestPackageCache(ChannelFactory.java:610)<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.manager.channel.ChannelManager.refreshWithNewestPackages(ChannelManager.java:179)<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.manager.channel.ChannelManager.refreshWithNewestPackages(ChannelManager.java:166)<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.frontend.action.channel.manage.ChannelPackagesRemoveAction.removePackages(ChannelPackagesRemoveAction.java:117)<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.frontend.action.channel.manage.ChannelPackagesRemoveAction.execute(ChannelPackagesRemoveAction.java:92)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)<o:p></o:p></p>
<p class="MsoNormal"> ... 40 more<o:p></o:p></p>
<p class="MsoNormal">Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SPACEWALK_MAIN.RHN_CNP_CID_NID_UQ) violated<o:p></o:p></p>
<p class="MsoNormal">ORA-06512: at "SPACEWALK_MAIN.RHN_CHANNEL", line 1087<o:p></o:p></p>
<p class="MsoNormal">ORA-06512: at line 1<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759)<o:p></o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:661)<o:p></o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.T2CCallableStatement.executeForDescribe(T2CCallableStatement.java:544)<o:p></o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.T2CCallableStatement.executeForRows(T2CCallableStatement.java:727)<o:p></o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)<o:p></o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)<o:p></o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)<o:p></o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4714)<o:p></o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)<o:p></o:p></p>
<p class="MsoNormal"> at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2706)<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:115)<o:p></o:p></p>
<p class="MsoNormal"> ... 48 more<o:p></o:p></p>
<p class="MsoNormal">2012-01-09 11:17:21,817 [TP-Processor8] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[action] - Servlet.service() for servlet action threw exception<o:p></o:p></p>
<p class="MsoNormal">java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SPACEWALK_MAIN.RHN_CNP_CID_NID_UQ) violated<o:p></o:p></p>
<p class="MsoNormal">ORA-06512: at "SPACEWALK_MAIN.RHN_CHANNEL", line 1087<o:p></o:p></p>
<p class="MsoNormal">ORA-06512: at line 1<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759)<o:p></o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:661)<o:p></o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.T2CCallableStatement.executeForDescribe(T2CCallableStatement.java:544)<o:p></o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.T2CCallableStatement.executeForRows(T2CCallableStatement.java:727)<o:p></o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)<o:p></o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)<o:p></o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)<o:p></o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4714)<o:p></o:p></p>
<p class="MsoNormal"> at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)<o:p></o:p></p>
<p class="MsoNormal"> at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2706)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">With friendly regards,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Franky<o:p></o:p></p>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1"><br>
Atos Worldline SA/NV - Chaussee de Haecht 1442 Haachtsesteenweg<br>
- 1130 Brussels - Belgium<br>
RPM-RPR Bruxelles-Brussel - TVA-BTW BE 0418.547.872<br>
Bankrekening-Compte Bancaire-Bank Account 310-0269424-44<br>
BIC BBRUBEBB - IBAN BE55 3100 2694 2444<br>
<br>
"The information contained in this e-mail and any attachment thereto is confidential and may contain information which is protected by intellectual property rights.<br>
This information is intended for the exclusive use of the recipient(s) named above.<br>
This e-mail does not constitute any binding relationship or offer toward any of the addressees.<br>
If you are not one of the addressees , one of their employees or a proxy holder entitled to hand over this message to the addressee(s), any use of the information contained herein (e.g. reproduction, divulgation, communication or distribution,...) is prohibited.<br>
If you have received this message in error, please notify the sender and destroy it immediately after.<br>
The integrity and security of this message cannot be guaranteed and it may be subject to data corruption, interception and unauthorized amendment, for which we accept no liability."<br>
</font>
</body>
</html>