Bug 694043

Description of problem:
copying packages from one channel to another results with "ORA-00001: unique constraint (SPACEWALK.RHN_CP_CP_UQ) violated"

Version-Release number of selected component (if applicable):
spacewalk-1.4 @ rhel6

How reproducible:


Steps to Reproduce:
1. install spacewalk 1.4
2. run test "/CoreOS/RHN-Satellite/FrontendAPI/Regression/bz506279-addPackages-with-many-packages-fails"
3. check catalina.out
  
Actual results:
2011-04-06 05:41:48,170 [TP-Processor6] ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing cached statement sql: INSERT INTO rhnChannelPackage (channel_id, package_id)
      select ?, P.id from rhnPackage P where P.id in (5829,5519,4925,4148,5895,5039,4008,5761,5236,4604,4061,5457,5387,6401,6399,5673,5114,5369,4461,6194,4253,4434,6100,5832,4887,6083,4780,6059,4044,4696,477
6,5420,4100,5362,4951,4398,5338,5708,4378,4197,5908,4754,5406,5098,5447,4174,6289,4523,5265,4370,5564,6104,5371,4913,5488,6286,6026,5945,4390,6446,4165,5505,5101,6087,4331,5526,4015,4330,4442,6025,5495,4638,
6204,5563,6196,5878,4512,5722,5902,6033,4215,5400,5397,4598,6075,6225,4155,4664,4407,4426,4702,5804,4083,4540,4950,6395,4366,4783,5383,6114,6090,5918,4436,5217,4492,5916,6443,4881,5842,5251,4007,5055,4936,52
55,5226,4385,5753,4668,4629,4673,5416,5879,6239,5487,5861,6151,4335,4917,4462,5426,4660,5079,5269,4307,4793,4379,5790,6200,4153,6248,4988,6185,4170,5145,4493,4539,5170,5680,5824,4365,4632,5713,4476,4569,4561
,5774,4226,4753,5274,6150,5221,5684,4154,4268,4006,5424,5806,6291,4425,5690,4110,5052,4440,6250,5317,5142,4395,5359,5443,6048,5010,4635,4163,5411,5111,5691,4431,5529,5535,5229,4786,5956,6453,5877,4617,5848,5
568,5063,3985,4210,6199,4945,5705,5834,6073,4302,4924,5822,5304,5026,5318,5228,5367,6008,5649,6281,4305,5016,4160,4931,6191,4232,4653,6445,5959,5133,6006,6345,4762,5270,4647,5711,5913,4181,4009,3999,5310,599
9,5734,5936,6074,5674,6180,5693,6436,4814,5928,6439,4315,5216,4992,4189,4596,5883,5075,5319,4555,5518,5860,6001,4077,6423,5588,5502,5907,4648,5053,4368,6081,5955,4051,5635,4342,5515,4847,6244,5851,3966,4107,
4245,5986,6449,4838,4990,5737,4542,5964,4577,5833,6198,4078,4105,4351,6332,4047,5138,6323,4609,5372,5508,4631,6306,5311,5374,5655,4363,5743,5193,5932,5196,5227,4234,5622,4272,4691,4111,5464,4485,4333,6272,44
54,4473,6409,5528,5191,5037,4630,5749,4038,4846,6317,4303,4074,4029,6164,6095,5965,6343,4486,5042,4711,4912,6256,4301,6364,4271,6336,5937,3980,4164,5987,4080,6261,4124,6458,5869,5845,6363,5745,5612,5746,5356
,4687,5300,4259,6018,5123,4411,6019,5840,5415,4934,5050,5461,4495,6042,4796,5582,4501,4610,4725,6007,4027,4806,4194,4377,6396,6186,5204,4159,4453,5768,4955,4719,4573,5412,5874,4071,4017,5380,6315,6393,6258,4
836,5671,6328,4812,5587,6260,4848,5687,5438,4184,4450,5215,4484,5237,5778,5794,5127,4982,5485,4962,5189,6120,4636,5725,5280,6413,5985,5609,4820,4564,5533,5109,4408,5726,4717,5354,5592,4037,4998,5797,3967,4902,5770,5013,5045,5926,4612,4580,4875,4298,4114,4178,5828,4911,5521,6197,5350,5435,4937,4325,5408,5885,4559,4186,5343,5621,4993,4072,4423,5969,4685,4946,4728,4141,5446,4877,4276,4388,5729,4873,5802,5065,4375,5294,5524,4565,4158,4024,5919,5316,5670,4727,4678,6041,6297,5031,4187)
com.redhat.rhn.common.db.ConstraintViolationException: ORA-00001: unique constraint (SPACEWALK.RHN_CP_CP_UQ) violated


Expected results:
no constraints 

Additional info: