Bug 694043 - redstone.xmlrpc.XmlRpcFault: unhandled internal exception: ORA-00001: unique constraint (SPACEWALK.RHN_CP_CP_UQ) violated
Summary: redstone.xmlrpc.XmlRpcFault: unhandled internal exception: ORA-00001: unique ...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: Server
Version: 1.4
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: ---
Assignee: Michael Mráka
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space16
TreeView+ depends on / blocked
 
Reported: 2011-04-06 10:17 UTC by Jiri Kastner
Modified: 2017-08-02 08:21 UTC (History)
2 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2011-09-02 09:53:37 UTC
Embargoed:


Attachments (Terms of Use)
tomcat log (410.30 KB, text/plain)
2011-04-06 10:23 UTC, Jiri Kastner
no flags Details

Description Jiri Kastner 2011-04-06 10:17:11 UTC
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:

Comment 5 Miroslav Suchý 2011-04-11 07:33:31 UTC
We did not have time for this one during Spacewalk 1.4 time frame. Mass moving to Spacewalk 1.5.

Comment 6 Miroslav Suchý 2011-04-11 07:37:11 UTC
We did not have time for this one during Spacewalk 1.4 time frame. Mass moving to Spacewalk 1.5.

Comment 7 Jan Pazdziora (Red Hat) 2011-07-20 11:51:46 UTC
Aligning under space16.

Comment 9 Michael Mráka 2011-09-02 09:53:37 UTC
I can't reproduce the bug any more.

If you still experience this behavior feel free to reopen the bug.


Note You need to log in before you can comment on or make changes to this bug.