Open Stack

Thanks Björn,

That's exactly it.

-Jon


On Tue, Aug 6, 2013 at 9:26 AM, Björn Hagemeier
<b.hagemeier at fz-juelich.de>wrote:

> Hi Jonathan,
>
> without reading your full thread, I found the same problem yesterday while
> upgrading. I deleted the extra users from DB and everything worked fine.
>
> There's a bug related to update issues from folsom to grizzly in which I
> meant to report what I had to do, but didn't do yet. I'll do after sending
> this email.
>
> https://bugs.launchpad.net/**keystone/+bug/1131174<https://bugs.launchpad.net/keystone/+bug/1131174>
>
> The cause of the "problem" is that originally there was no enforcement of
> referential integrity of the DB, which has now been added. Transforming the
> old data, which possibly contains integrity violations, can cause these
> problems. So actually, it is a good thing, but legacy data may not quite
> fit in.
>
> I think the table from which I deleted the entries was
> user_project_metadata. You'll find the right place anyhow.
>
>
> Cheers,
> Björn
>
> On 06.08.2013 15:05, Jonathan Proulx wrote :
>
>>
>> I believe this relates to deleted users.
>>
>> The old metadata table has entries for user_id's that have no
>> corresponding entry in the user table.  I've not quite worked out the
>> SQL for showing these lines but it appears they also have no roles in
>> the projects they are associated with.  Just a little more coffee and I
>> think I've got it.
>>
>> If my suspicion is correct then the patch is pretty easy just don't try
>> to migrate rows where the role list is null.
>>
>> -Jon
>>
>>
>> On Tue, Aug 6, 2013 at 8:38 AM, Jonathan Proulx <jon at jonproulx.com
>> <mailto:jon at jonproulx.com>> wrote:
>>
>>     On Tue, Aug 6, 2013 at 2:15 AM, Robert van Leeuwen
>>     <Robert.vanLeeuwen at spilgames.**com <Robert.vanLeeuwen at spilgames.com>
>>     <mailto:Robert.vanLeeuwen@**spilgames.com<Robert.vanLeeuwen at spilgames.com>>>
>> wrote:
>>
>>          > On Ubuntu 12.04 using cloud-archieve repos I just upgraded
>>         keystone to grizzly from folsom,
>>          > but 'keystone-manage db_sync' is failing with something like:
>>
>>          > sqlalchemy.exc.IntegrityError: (IntegrityError) (1452,
>>         'Cannot add or update a child row: a foreign key
>>
>>          > Any clues on how to get my db to sync?
>>
>>         Jon,
>>
>>         Could you check if your tables are innodb?
>>         I've seen something similar when the tables where myisam.
>>
>>         Cheers,
>>         Robert van Leeuwen
>>
>>
>>
>>
>>     They are innodb, SHOW TABLE STATUS confirms.
>>
>>     Thanks,
>>     -Jon
>>
>>
>>
>>
>> ______________________________**_________________
>> OpenStack-operators mailing list
>> OpenStack-operators at lists.**openstack.org<OpenStack-operators at lists.openstack.org>
>> http://lists.openstack.org/**cgi-bin/mailman/listinfo/**
>> openstack-operators<http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators>
>>
>>
>
> --
> Dipl.-Inform. Björn Hagemeier
> Federated Systems and Data
> Juelich Supercomputing Centre
> Institute for Advanced Simulation
>
> Phone: +49 2461 61 1584
> Fax  : +49 2461 61 6656
> Email: b.hagemeier at fz-juelich.de
> Skype: bhagemeier
> WWW  : http://www.fz-juelich.de/jsc
>
> JSC is the coordinator of the
> John von Neumann Institute for Computing
> and member of the
> Gauss Centre for Supercomputing
>
> ------------------------------**------------------------------**
> -------------------------
> ------------------------------**------------------------------**
> -------------------------
> Forschungszentrum Juelich GmbH
> 52425 Juelich
> Sitz der Gesellschaft: Juelich
> Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498
> Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher
> Geschaeftsfuehrung: Prof. Dr. Achim Bachem (Vorsitzender),
> Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt,
> Prof. Dr. Sebastian M. Schmidt
> ------------------------------**------------------------------**
> -------------------------
> ------------------------------**------------------------------**-------------------------
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20130806/47b9503f/attachment.html>