<div dir="ltr">Thanks Lance!<div><br></div><div>I just did: "keystone-manage db_sync" and the output is the same:</div><div><br></div><div>---</div><div><div>2014-03-07 23:23:48.564 2258 CRITICAL keystone [-] (OperationalError) (1061, "Duplicate key name 'ix_token_expires_valid'") 'CREATE INDEX ix_token_expires_valid ON token (expires, valid)' ()</div>
</div><div>---</div><div><br></div><div>I just read [1] and [2] but, not a clue about how to fix it.</div><div><br></div><div>My Keystone is still running and I have no idea if I can restart it or not... What if it doesn't come back?! My entire Cloud will become useless... This is a production environment, it was working smoothly for months... :'(</div>
<div><br></div><div>Do you know if there is something that I can do directly on MySQL to try to fix it?!</div><div><br></div><div>Best,</div><div>Thiago</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">
On 7 March 2014 23:18, Lance D Bragstad <span dir="ltr"><<a href="mailto:ldbragst@us.ibm.com" target="_blank">ldbragst@us.ibm.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<p><font face="sans-serif">Thiago, </font><br>
<br>
<font face="sans-serif">Your database might be out of sync with the latest Keystone code if you just performed an update. Try migrating your database [1]. The link gives some information on how to do that, but you'll essentially want to do a `keystone-manage db_sync`, also check the man pages [2]. This should ensure your Keystone database has the proper schema for the Keystone code you're running.</font><br>
<br>
<font face="sans-serif">[1] <a href="http://docs.openstack.org/developer/keystone/configuration.html#step-2-sync-your-new-empty-database" target="_blank">http://docs.openstack.org/developer/keystone/configuration.html#step-2-sync-your-new-empty-database</a><br>
[2] <a href="http://docs.openstack.org/developer/keystone/man/keystone-manage.html" target="_blank">http://docs.openstack.org/developer/keystone/man/keystone-manage.html</a></font><br>
<font face="sans-serif"><br>
Best Regards, <br>
<br>
Lance Bragstad <br>
<a href="mailto:ldbragst@us.ibm.com" target="_blank">ldbragst@us.ibm.com</a></font><br>
<br>
<tt><font>Martinx - ジェームズ <<a href="mailto:thiagocmartinsc@gmail.com" target="_blank">thiagocmartinsc@gmail.com</a>> wrote on 03/07/2014 06:50:01 PM:<br>
<br>
> From: Martinx - ジェームズ <<a href="mailto:thiagocmartinsc@gmail.com" target="_blank">thiagocmartinsc@gmail.com</a>></font></tt><br>
<tt><font>> To: "<a href="mailto:openstack@lists.openstack.org" target="_blank">openstack@lists.openstack.org</a>" <<a href="mailto:openstack@lists.openstack.org" target="_blank">openstack@lists.openstack.org</a>>, </font></tt><br>
<tt><font>> Date: 03/07/2014 07:03 PM</font></tt><br>
<tt><font>> Subject: [Openstack] Error on upgrading to latest Keystone - Ubuntu <br>
> 12.04.4 + UCA</font></tt></p><div><div class="h5"><br>
<tt><font>> <br>
> Guys,</font></tt><br>
<tt><font>> <br>
> I just did:</font></tt><br>
<tt><font>> <br>
> apt-get update</font></tt><br>
<tt><font>> apt-get dist-upgrade</font></tt><br>
<tt><font>> <br>
> And I'm seeing the following error:</font></tt><br>
<tt><font>> <br>
> ---</font></tt><br>
<tt><font>> Setting up keystone (1:2013.2.2-0ubuntu1~cloud0) ...</font></tt><br>
<tt><font>> 2014-03-07 21:45:39.473 15540 CRITICAL keystone [-] <br>
> (OperationalError) (1061, "Duplicate key name <br>
> 'ix_token_expires_valid'") 'CREATE INDEX ix_token_expires_valid ON <br>
> token (expires, valid)' ()</font></tt><br>
<tt><font>> dpkg: error processing keystone (--configure):</font></tt><br>
<tt><font>> subprocess installed post-installation script returned error exit status 1</font></tt><br>
<tt><font>> Errors were encountered while processing:</font></tt><br>
<tt><font>> keystone</font></tt><br>
<tt><font>> E: Sub-process /usr/bin/dpkg returned an error code (1)</font></tt><br>
<tt><font>> ---</font></tt><br>
<tt><font>> <br>
> What can I do?!</font></tt><br>
<tt><font>> <br>
> Tks!</font></tt><br>
</div></div><tt><font>> Thiago_______________________________________________<br>
> Mailing list: <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
> Post to : <a href="mailto:openstack@lists.openstack.org" target="_blank">openstack@lists.openstack.org</a><br>
> Unsubscribe : <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
</font></tt><p></p></div></blockquote></div><br></div>