yahoo-eng-team team mailing list archive

[Will Foster <wfoster@xxxxxxxxxx>]

Public bug reported:

When moving from Havana to Icehouse (Keystone version 38 -> 44) and
keystone-manage db_sync runs, it fails if there are duplicate project
entries.

2014-11-24 23:12:58.701 9239 CRITICAL keystone [-] IntegrityError:
(IntegrityError) (1062, "Duplicate entry 'UserProject-
096cb95691404a959289200afa7d4b2f-c0036d48a8524cf6ba1' for key
'PRIMARY'") 'INSERT INTO assignment (type, actor_id, target_id, role_id,
inherited) VALUES (%s, %s, %s, %s, %s)' ('UserProject',
'096cb95691404a959289200afa7d4b2f', 'c0036d48a8524cf6ba1ed6e857649989',
'9fe2ff9ee4384b1894a90878d3e92bab', False)

** Affects: keystone
     Importance: Undecided
     Assignee: Will Foster (wfoster-b)
         Status: New

** Project changed: nova => keystone

** Changed in: keystone
     Assignee: (unassigned) => Will Foster (wfoster-b)

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1395959

Title:
  assignment table migration fails for keystone-manage db_sync if
  duplicate entry exists

Status in OpenStack Identity (Keystone):
  New

Bug description:
  When moving from Havana to Icehouse (Keystone version 38 -> 44) and
  keystone-manage db_sync runs, it fails if there are duplicate project
  entries.

  2014-11-24 23:12:58.701 9239 CRITICAL keystone [-] IntegrityError:
  (IntegrityError) (1062, "Duplicate entry 'UserProject-
  096cb95691404a959289200afa7d4b2f-c0036d48a8524cf6ba1' for key
  'PRIMARY'") 'INSERT INTO assignment (type, actor_id, target_id,
  role_id, inherited) VALUES (%s, %s, %s, %s, %s)' ('UserProject',
  '096cb95691404a959289200afa7d4b2f',
  'c0036d48a8524cf6ba1ed6e857649989',
  '9fe2ff9ee4384b1894a90878d3e92bab', False)

To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1395959/+subscriptions