Mailing List Archive

Keystone Error
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@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": "admin@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
Re: Keystone Error [ In reply to ]
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@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": "
> admin@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": "admin@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
Re: Keystone Error [ In reply to ]
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@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.somanchi@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": "
>> admin@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": "admin@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
>



--
Regards,
----------------------------------------------
Trinath Somanchi,
+91 9866 235 130
Re: Keystone Error [ In reply to ]
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@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.somanchi@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": "admin@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": "admin@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
Re: Keystone Error [ In reply to ]
Hi-

Oh. got the difference, thanks for the reply

How to kow wat are all the differences that are in place form Essex to
Folsom-3 in Openstack. Can you share me a document/link/details on this
area.

Thanking you for the help.

--
TNS

On Wed, Aug 29, 2012 at 9:52 PM, Vishvananda Ishaya
<vishvananda@gmail.com>wrote:

> 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@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.somanchi@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": "
>> admin@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": "admin@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
>
>
>


--
Regards,
----------------------------------------------
Trinath Somanchi,
+91 9866 235 130
Re: Keystone Error [ In reply to ]
On 6/30/2018 5:15 PM, Kevin Kwon wrote:
> "Can't connect to MySQL server on 'OpenStack-Controller' ([Errno 111]
> Connection refused)")
This error message means that no process is listening at the MySQL port
on OpenStack-Controller. Initial thoughts: Either OpenStack-Controller
is the wrong server, or MySQL is not running.