openstack team mailing list archive

[Dolph Mathews <dolph.mathews@xxxxxxxxx>]

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