← Back to team overview

openstack team mailing list archive

Re: Keystone Error

 

Hi Dolph-


Thanks for reply.

Can you guide me on how to troubleshoot the same...

-
TNS


On Wed, Aug 29, 2012 at 1:08 PM, 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
>



-- 
Regards,
----------------------------------------------
Trinath Somanchi,
+91 9866 235 130

References