<div dir="ltr"><div><div>Thanks Björn,<br><br></div>That's exactly it.<br><br></div>-Jon<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Aug 6, 2013 at 9:26 AM, Björn Hagemeier <span dir="ltr"><<a href="mailto:b.hagemeier@fz-juelich.de" target="_blank">b.hagemeier@fz-juelich.de</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Jonathan,<br>
<br>
without reading your full thread, I found the same problem yesterday while upgrading. I deleted the extra users from DB and everything worked fine.<br>
<br>
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.<br>
<br>
<a href="https://bugs.launchpad.net/keystone/+bug/1131174" target="_blank">https://bugs.launchpad.net/<u></u>keystone/+bug/1131174</a><br>
<br>
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.<br>
<br>
I think the table from which I deleted the entries was user_project_metadata. You'll find the right place anyhow.<br>
<br>
<br>
Cheers,<br>
Björn<br>
<br>
On 06.08.2013 15:05, Jonathan Proulx wrote :<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
<br>
I believe this relates to deleted users.<br>
<br>
The old metadata table has entries for user_id's that have no<br>
corresponding entry in the user table. I've not quite worked out the<br>
SQL for showing these lines but it appears they also have no roles in<br>
the projects they are associated with. Just a little more coffee and I<br>
think I've got it.<br>
<br>
If my suspicion is correct then the patch is pretty easy just don't try<br>
to migrate rows where the role list is null.<br>
<br>
-Jon<br>
<br>
<br>
On Tue, Aug 6, 2013 at 8:38 AM, Jonathan Proulx <<a href="mailto:jon@jonproulx.com" target="_blank">jon@jonproulx.com</a><br></div><div class="im">
<mailto:<a href="mailto:jon@jonproulx.com" target="_blank">jon@jonproulx.com</a>>> wrote:<br>
<br>
On Tue, Aug 6, 2013 at 2:15 AM, Robert van Leeuwen<br>
<<a href="mailto:Robert.vanLeeuwen@spilgames.com" target="_blank">Robert.vanLeeuwen@spilgames.<u></u>com</a><br></div><div class="im">
<mailto:<a href="mailto:Robert.vanLeeuwen@spilgames.com" target="_blank">Robert.vanLeeuwen@<u></u>spilgames.com</a>>> wrote:<br>
<br>
> On Ubuntu 12.04 using cloud-archieve repos I just upgraded<br>
keystone to grizzly from folsom,<br>
> but 'keystone-manage db_sync' is failing with something like:<br>
<br>
> sqlalchemy.exc.IntegrityError: (IntegrityError) (1452,<br>
'Cannot add or update a child row: a foreign key<br>
<br>
> Any clues on how to get my db to sync?<br>
<br>
Jon,<br>
<br>
Could you check if your tables are innodb?<br>
I've seen something similar when the tables where myisam.<br>
<br>
Cheers,<br>
Robert van Leeuwen<br>
<br>
<br>
<br>
<br>
They are innodb, SHOW TABLE STATUS confirms.<br>
<br>
Thanks,<br>
-Jon<br>
<br>
<br>
<br>
<br></div>
______________________________<u></u>_________________<br>
OpenStack-operators mailing list<br>
<a href="mailto:OpenStack-operators@lists.openstack.org" target="_blank">OpenStack-operators@lists.<u></u>openstack.org</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators" target="_blank">http://lists.openstack.org/<u></u>cgi-bin/mailman/listinfo/<u></u>openstack-operators</a><br>
<br>
</blockquote>
<br>
<br>
-- <br>
Dipl.-Inform. Björn Hagemeier<br>
Federated Systems and Data<br>
Juelich Supercomputing Centre<br>
Institute for Advanced Simulation<br>
<br>
Phone: <a href="tel:%2B49%202461%2061%201584" value="+492461611584" target="_blank">+49 2461 61 1584</a><br>
Fax : <a href="tel:%2B49%202461%2061%206656" value="+492461616656" target="_blank">+49 2461 61 6656</a><br>
Email: <a href="mailto:b.hagemeier@fz-juelich.de" target="_blank">b.hagemeier@fz-juelich.de</a><br>
Skype: bhagemeier<br>
WWW : <a href="http://www.fz-juelich.de/jsc" target="_blank">http://www.fz-juelich.de/jsc</a><br>
<br>
JSC is the coordinator of the<br>
John von Neumann Institute for Computing<br>
and member of the<br>
Gauss Centre for Supercomputing<br>
<br>
------------------------------<u></u>------------------------------<u></u>-------------------------<br>
------------------------------<u></u>------------------------------<u></u>-------------------------<br>
Forschungszentrum Juelich GmbH<br>
52425 Juelich<br>
Sitz der Gesellschaft: Juelich<br>
Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498<br>
Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher<br>
Geschaeftsfuehrung: Prof. Dr. Achim Bachem (Vorsitzender),<br>
Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt,<br>
Prof. Dr. Sebastian M. Schmidt<br>
------------------------------<u></u>------------------------------<u></u>-------------------------<br>
------------------------------<u></u>------------------------------<u></u>------------------------- <br>
</blockquote></div><br></div>