Open Stack

Lance,

I can provide everything, no problem... I'm doing this to reproduce it:


root at controller-1:~# keystone-manage db_sync
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)' ()


Log shows:

==> /var/log/keystone/keystone.log <==
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)' ()


root at controller-1:~# dpkg -l | grep keystone
iF  keystone                         1:2013.2.2-0ubuntu1~cloud0
             OpenStack identity service - Daemons
ii  python-keystone                  1:2013.2.2-0ubuntu1~cloud0
             OpenStack identity service - Python library
ii  python-keystoneclient            1:0.3.2-0ubuntu1~cloud0
              Client library for OpenStack Identity API

...

If I run "apt-get -f install", to try to fix it ("iF" dpkg status above),
same problem, look:

---
root at controller-1:~# apt-get -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Setting up keystone (1:2013.2.2-0ubuntu1~cloud0) ...
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)' ()
dpkg: error processing keystone (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 keystone
E: Sub-process /usr/bin/dpkg returned an error code (1)
---

I'm lost...    :-/

Maybe the upgrade procedure got stucked, then the second time I tried, it
triggered this error... I'm not sure...

Tks!
Thiago



On 8 March 2014 01:55, Lance D Bragstad <ldbragst at us.ibm.com> wrote:

> Thiago,
>
> Are you able to provide a little more information? Log files maybe? What
> are the steps you're taking to recreate the issue?
>
>
>
> Best Regards,
>
> Lance Bragstad
> ldbragst at us.ibm.com
>
> Martinx - ジェームズ <thiagocmartinsc at gmail.com> wrote on 03/07/2014 08:34:11
> PM:
>
>
> > From: Martinx - ジェームズ <thiagocmartinsc at gmail.com>
>
> > To: Lance D Bragstad/Rochester/IBM at IBMUS,
> > Cc: "openstack at lists.openstack.org" <openstack at lists.openstack.org>
> > Date: 03/07/2014 08:34 PM
> > Subject: Re: [Openstack] Error on upgrading to latest Keystone -
> > Ubuntu 12.04.4 + UCA
> >
> > Thanks Lance!
>
> >
> > I just did: "keystone-manage db_sync" and the output is the same:
> >
> > ---
> > 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)' ()
> > ---
> >
> > I just read [1] and [2] but, not a clue about how to fix it.
> >
> > 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...    :'(
> >
> > Do you know if there is something that I can do directly on MySQL to
> > try to fix it?!
> >
> > Best,
> > Thiago
> >
>
> > On 7 March 2014 23:18, Lance D Bragstad <ldbragst at us.ibm.com> wrote:
> > Thiago,
> >
> > 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.
> >
> > [1] http://docs.openstack.org/developer/keystone/
> > configuration.html#step-2-sync-your-new-empty-database
> > [2]
> http://docs.openstack.org/developer/keystone/man/keystone-manage.html
> >
> > Best Regards,
> >
> > Lance Bragstad
> > ldbragst at us.ibm.com
> >
> > Martinx - ジェームズ <thiagocmartinsc at gmail.com> wrote on 03/07/2014
> > 06:50:01 PM:
> >
> > > From: Martinx - ジェームズ <thiagocmartinsc at gmail.com>
> > > To: "openstack at lists.openstack.org" <openstack at lists.openstack.org>,
> > > Date: 03/07/2014 07:03 PM
> > > Subject: [Openstack] Error on upgrading to latest Keystone - Ubuntu
> > > 12.04.4 + UCA
> >
> > >
> > > Guys,
> > >
> > > I just did:
> > >
> > > apt-get update
> > > apt-get dist-upgrade
> > >
> > > And I'm seeing the following error:
> > >
> > > ---
> > > Setting up keystone (1:2013.2.2-0ubuntu1~cloud0) ...
> > > 2014-03-07 21:45:39.473 15540 CRITICAL keystone [-]
> > > (OperationalError) (1061, "Duplicate key name
> > > 'ix_token_expires_valid'") 'CREATE INDEX ix_token_expires_valid ON
> > > token (expires, valid)' ()
> > > dpkg: error processing keystone (--configure):
> > >  subprocess installed post-installation script returned error exit
> status 1
> > > Errors were encountered while processing:
> > >  keystone
> > > E: Sub-process /usr/bin/dpkg returned an error code (1)
> > > ---
> > >
> > > What can I do?!
> > >
> > > Tks!
> > > Thiago_______________________________________________
> > > Mailing list:
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> > > Post to     : openstack at lists.openstack.org
> > > Unsubscribe :
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20140308/9ae27517/attachment.html>