Project

General

Profile

Actions
Copy link

Bug #11339

closed

parameter unique index migration should account for duplicate data

Added by Justin Sherrill over 8 years ago. Updated almost 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Justin Sherrill
Category:
DB migrations
Target version:
1.9.1
Difficulty:
easy
Triaged:
Bugzilla link:
1213000
Pull request:
https://github.com/theforeman/foreman/pull/2600
Fixed in Releases:
Found in Releases:
1.7.2
Red Hat JIRA:

Description

20140805114754_add_unique_index_to_parameter.rb adds a unique migration but does not account for non-unique data. A previous bug related to host group cloning (we believe) led to a situation where duplicate data could be added to the db.

Related issues 1 (0 open — 1 closed)

Related to Foreman - Bug #6695: Adding two OS parameters with same name doesn't raise any error when values are differentClosedOri Rabin07/20/2014Actions
Actions
Copy link
 #1

Updated by Justin Sherrill over 8 years ago

Error in question:

PGError: ERROR: could not create unique index "index_parameters_on_type_and_reference_id_and_name"
DETAIL: Key (type, reference_id, name)=(GroupParameter, 2, kt_org) is
duplicated.

Actions
Copy link
 #2

Updated by The Foreman Bot over 8 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman/pull/2600 added
  • Pull request deleted ()
Actions
Copy link
 #3

Updated by Justin Sherrill over 8 years ago

  • Bugzilla link set to 1213000
Actions
Copy link
 #4

Updated by Dominic Cleal over 8 years ago

  • Related to Bug #6695: Adding two OS parameters with same name doesn't raise any error when values are different added
Actions
Copy link
 #5

Updated by Dominic Cleal over 8 years ago

  • translation missing: en.field_release set to 72
Actions
Copy link
 #6

Updated by Justin Sherrill over 8 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions
Copy link

Also available in: Atom PDF