<div dir="ltr">Lance,<div><br></div><div>I can provide everything, no problem... I'm doing this to reproduce it:</div><div><br></div><div><div><br></div><div>root@controller-1:~# keystone-manage db_sync</div><div>2014-03-08 02:44:46.723 5407 CRITICAL keystone [-] (OperationalError) (1061, "Duplicate key name 'ix_token_expires_valid'") 'CREATE INDEX ix_token_expires_valid ON token (expires, valid)' ()</div>
</div><div><br></div><div><br></div><div>Log shows:<br></div><div><br></div><div><div>==> /var/log/keystone/keystone.log <==</div><div>2014-03-08 02:44:46.723 5407 CRITICAL keystone [-] (OperationalError) (1061, "Duplicate key name 'ix_token_expires_valid'") 'CREATE INDEX ix_token_expires_valid ON token (expires, valid)' ()</div>
</div><div><br></div><div><br></div><div><div>root@controller-1:~# dpkg -l | grep keystone</div><div>iF keystone 1:2013.2.2-0ubuntu1~cloud0 OpenStack identity service - Daemons</div>
<div>ii python-keystone 1:2013.2.2-0ubuntu1~cloud0 OpenStack identity service - Python library</div><div>ii python-keystoneclient 1:0.3.2-0ubuntu1~cloud0 Client library for OpenStack Identity API</div>
</div><div><br></div><div>...</div><div><br></div><div>If I run "apt-get -f install", to try to fix it ("iF" dpkg status above), same problem, look:</div><div><br></div><div>---</div><div><div>root@controller-1:~# apt-get -f install</div>
<div>Reading package lists... Done</div><div>Building dependency tree </div><div>Reading state information... Done</div><div>0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.</div><div>1 not fully installed or removed.</div>
<div>After this operation, 0 B of additional disk space will be used.</div><div>Setting up keystone (1:2013.2.2-0ubuntu1~cloud0) ...</div><div>2014-03-08 02:49:11.050 5469 CRITICAL keystone [-] (OperationalError) (1061, "Duplicate key name 'ix_token_expires_valid'") 'CREATE INDEX ix_token_expires_valid ON token (expires, valid)' ()</div>
<div>dpkg: error processing keystone (--configure):</div><div> subprocess installed post-installation script returned error exit status 1</div><div>Errors were encountered while processing:</div><div> keystone</div><div>
E: Sub-process /usr/bin/dpkg returned an error code (1)</div>
</div><div>---</div><div><br></div><div>I'm lost... :-/</div><div><br></div><div>Maybe the upgrade procedure got stucked, then the second time I tried, it triggered this error... I'm not sure...</div><div><br>
</div>
<div>Tks!</div><div>Thiago</div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 8 March 2014 01:55, 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">Are you able to provide a little more information? Log files maybe? What are the steps you're taking to recreate the issue?</font></p><div class=""><br>
<font face="sans-serif"><br>
<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>
</div><tt><font>Martinx - ジェームズ <<a href="mailto:thiagocmartinsc@gmail.com" target="_blank">thiagocmartinsc@gmail.com</a>> wrote on 03/07/2014 08:34:11 PM:<div class=""><br>
<br>
> From: Martinx - ジェームズ <<a href="mailto:thiagocmartinsc@gmail.com" target="_blank">thiagocmartinsc@gmail.com</a>></div></font></tt><br>
<tt><font>> To: Lance D Bragstad/Rochester/IBM@IBMUS, </font></tt><br>
<tt><font>> Cc: "<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 08:34 PM</font></tt><br>
<tt><font>> Subject: Re: [Openstack] Error on upgrading to latest Keystone - <br>
> Ubuntu 12.04.4 + UCA</font></tt><br>
<tt><font>> <br>
> Thanks Lance!</font></tt><div><div class="h5"><br>
<tt><font>> <br>
> I just did: "keystone-manage db_sync" and the output is the same:</font></tt><br>
<tt><font>> <br>
> ---</font></tt><br>
<tt><font>> 2014-03-07 23:23:48.564 2258 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>> ---</font></tt><br>
<tt><font>> <br>
> I just read [1] and [2] but, not a clue about how to fix it.</font></tt><br>
<tt><font>> <br>
> My Keystone is still running and I have no idea if I can restart it <br>
> or not... What if it doesn't come back?! My entire Cloud will become<br>
> useless... This is a production environment, it was working smoothly<br>
> for months... :'(</font></tt><br>
<tt><font>> <br>
> Do you know if there is something that I can do directly on MySQL to<br>
> try to fix it?!</font></tt><br>
<tt><font>> <br>
> Best,</font></tt><br>
<tt><font>> Thiago</font></tt><br>
<tt><font>> <br>
</font></tt><br>
<tt><font>> On 7 March 2014 23:18, Lance D Bragstad <<a href="mailto:ldbragst@us.ibm.com" target="_blank">ldbragst@us.ibm.com</a>> wrote:</font></tt><br>
<tt><font>> Thiago, <br>
> <br>
> Your database might be out of sync with the latest Keystone code if <br>
> you just performed an update. Try migrating your database [1]. The <br>
> link gives some information on how to do that, but you'll <br>
> essentially want to do a `keystone-manage db_sync`, also check the <br>
> man pages [2]. This should ensure your Keystone database has the <br>
> proper schema for the Keystone code you're running.<br>
> <br>
> [1] <a href="http://docs.openstack.org/developer/keystone/" target="_blank">http://docs.openstack.org/developer/keystone/</a><br>
> configuration.html#step-2-sync-your-new-empty-database<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><br>
> <br>
> Best Regards, <br>
> <br>
> Lance Bragstad <br>
> <a href="mailto:ldbragst@us.ibm.com" target="_blank">ldbragst@us.ibm.com</a><br>
> <br>
> Martinx - ジェームズ <<a href="mailto:thiagocmartinsc@gmail.com" target="_blank">thiagocmartinsc@gmail.com</a>> wrote on 03/07/2014 <br>
> 06:50:01 PM:<br>
> <br>
> > From: Martinx - ジェームズ <<a href="mailto:thiagocmartinsc@gmail.com" target="_blank">thiagocmartinsc@gmail.com</a>><br>
> > 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>>, <br>
> > Date: 03/07/2014 07:03 PM<br>
> > Subject: [Openstack] Error on upgrading to latest Keystone - Ubuntu <br>
> > 12.04.4 + UCA</font></tt><br>
<tt><font>> <br>
> > <br>
> > Guys,<br>
> > <br>
> > I just did:<br>
> > <br>
> > apt-get update<br>
> > apt-get dist-upgrade<br>
> > <br>
> > And I'm seeing the following error:<br>
> > <br>
> > ---<br>
> > Setting up keystone (1:2013.2.2-0ubuntu1~cloud0) ...<br>
> > 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)' ()<br>
> > dpkg: error processing keystone (--configure):<br>
> > subprocess installed post-installation script returned error exit status 1<br>
> > Errors were encountered while processing:<br>
> > keystone<br>
> > E: Sub-process /usr/bin/dpkg returned an error code (1)<br>
> > ---<br>
> > <br>
> > What can I do?!<br>
> > <br>
> > Tks!</font></tt><br>
<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></font></tt></div></div><p></p></div></blockquote>
</div><br></div>