openstack team mailing list archive

[Vishvananda Ishaya <vishvananda@xxxxxxxxx>]

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.mathews@xxxxxxxxx> 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.somanchi@xxxxxxxxx> 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": "admin@xxxxxxxxxxxxx", "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": "admin@xxxxxxxxxxxxx", "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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openstack
> More help   : https://help.launchpad.net/ListHelp
> 
> 
> 
> 
> -- 
> -Dolph
> _______________________________________________
> Mailing list: https://launchpad.net/~openstack
> Post to     : openstack@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openstack
> More help   : https://help.launchpad.net/ListHelp