It looks like the primary key is not being inserted. It looks like you are
trying to run an essex release of keystone against a folsom keystone db. The
folsom db has a primary key of id_hash so the insert is failing.
Vish
On Aug 29, 2012, at 12:38 AM, Dolph Mathews <dolph.math...@gmail.com> wrote:
> Have you gotten this error more than once / is it reproducible at all? If it
> is reproducible, is the same token ID value
> (6796383476b8442d9a3b9fd488d56e05) being produced consistently?
>
> If I'm reading the traceback correctly, you actually produced a UUID4
> collision (the probability of which is insanely small.. 1 in 2^256 I
> believe). It's far more likely that something else is broken :)
>
> Are you running more than one keystone instance? (would theoretically
> increase the likelihood of a collision, if that's actually what happened)
>
> -Dolph
>
> On Wed, Aug 29, 2012 at 2:17 AM, Trinath Somanchi
> <trinath.soman...@gmail.com> wrote:
> Hi-
>
> When I'm logging into Horizon of Openstack Essex release,
>
> I'm getting this error in the keystone log file...
>
> (root): 2012-08-29 12:45:50,030 ERROR (IntegrityError) (1062, "Duplicate
> entry '' for key 'PRIMARY'") 'INSERT INTO token (id, expires, extra) VALUES
> (%s, %s, %s)' ('6796383476b8442d9a3b9fd488d56e05', datetime.datetime(2012, 8,
> 30, 7, 15, 50, 24114), '{"metadata": {}, "user": {"email":
> "ad...@openstack.com", "enabled": true, "id":
> "668f5d9ca716417fa16208828c5acea8", "name": "admin", "tenantId": null},
> "tenant": null}')
> Traceback (most recent call last):
> File "/usr/lib/python2.7/dist-packages/keystone/common/wsgi.py", line 184,
> in __call__
> result = method(context, **params)
> File "/usr/lib/python2.7/dist-packages/keystone/service.py", line 286, in
> authenticate
> metadata=metadata_ref))
> File "/usr/lib/python2.7/dist-packages/keystone/common/manager.py", line
> 48, in _wrapper
> return f(*args, **kw)
> File "/usr/lib/python2.7/dist-packages/keystone/token/backends/sql.py",
> line 70, in create_token
> session.flush()
> File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line
> 1547, in flush
> self._flush(objects)
> File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line
> 1616, in _flush
> flush_context.execute()
> File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line
> 328, in execute
> rec.execute(self)
> File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line
> 472, in execute
> uow
> File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line
> 2264, in _save_obj
> execute(statement, multiparams)
> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
> 1405, in execute
> params)
> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
> 1538, in _execute_clauseelement
> compiled_sql, distilled_params
> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
> 1646, in _execute_context
> context)
> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
> 1639, in _execute_context
> context)
> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line
> 330, in do_execute
> cursor.execute(statement, parameters)
> File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in
> execute
> self.errorhandler(self, exc, value)
> File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in
> defaulterrorhandler
> raise errorclass, errorvalue
> IntegrityError: (IntegrityError) (1062, "Duplicate entry '' for key
> 'PRIMARY'") 'INSERT INTO token (id, expires, extra) VALUES (%s, %s, %s)'
> ('6796383476b8442d9a3b9fd488d56e05', datetime.datetime(2012, 8, 30, 7, 15,
> 50, 24114), '{"metadata": {}, "user": {"email": "ad...@openstack.com",
> "enabled": true, "id": "668f5d9ca716417fa16208828c5acea8", "name": "admin",
> "tenantId": null}, "tenant": null}')
>
>
>
>
>
> Can any one guide me on trouble shooting the same
>
>
>
>
> --
> Regards,
> ----------------------------------------------
> Trinath Somanchi,
> +91 9866 235 130
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openstack
> Post to : openstack@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~openstack
> More help : https://help.launchpad.net/ListHelp
>
>
>
>
> --
> -Dolph
> _______________________________________________
> Mailing list: https://launchpad.net/~openstack
> Post to : openstack@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~openstack
> More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~openstack
Post to : openstack@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openstack
More help : https://help.launchpad.net/ListHelp
