[Openstack-operators] Openstack-Keystone error
Anwar Durrani
durrani.anwar at gmail.com
Thu Jan 15 09:09:36 UTC 2015
Hi Alex, below is error in log file
2015-01-15 01:08:34.128 50243 ERROR keystone.common.wsgi [-]
(ProgrammingError) (1146, "Table 'keystone.token' doesn't exist") 'SELECT
token.id AS token_id, token.expires AS token_expires, token.extra AS
token_extra, token.valid AS token_valid, token.user_id AS token_user_id,
token.trust_id AS token_trust_id \nFROM token \nWHERE token.id = %s'
('2c0dc0032d675623f37a',)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi Traceback (most
recent call last):
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/keystone/common/wsgi.py", line 430, in
__call__
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi response =
self.process_request(request)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/keystone/middleware/core.py", line 279,
in process_request
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi auth_context =
self._build_auth_context(request)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/keystone/middleware/core.py", line 259,
in _build_auth_context
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
token_data=self.token_provider_api.validate_token(token_id))
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/keystone/token/provider.py", line 225, in
validate_token
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi token =
self._validate_token(unique_id)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 1013, in
decorate
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
should_cache_fn)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 640, in
get_or_create
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi async_creator)
as value:
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/dogpile/core/dogpile.py", line 158, in
__enter__
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi return
self._enter()
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/dogpile/core/dogpile.py", line 98, in
_enter
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi generated =
self._enter_create(createdtime)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/dogpile/core/dogpile.py", line 149, in
_enter_create
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi created =
self.creator()
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 612, in
gen_value
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi created_value
= creator()
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 1009, in
creator
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi return
fn(*arg, **kw)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/keystone/token/provider.py", line 318, in
_validate_token
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi token_ref =
self._persistence.get_token(token_id)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/keystone/token/persistence/core.py", line
76, in get_token
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi token_ref =
self._get_token(unique_id)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 1013, in
decorate
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
should_cache_fn)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 640, in
get_or_create
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi async_creator)
as value:
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/dogpile/core/dogpile.py", line 158, in
__enter__
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi return
self._enter()
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/dogpile/core/dogpile.py", line 98, in
_enter
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi generated =
self._enter_create(createdtime)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/dogpile/core/dogpile.py", line 149, in
_enter_create
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi created =
self.creator()
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 612, in
gen_value
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi created_value
= creator()
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 1009, in
creator
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi return
fn(*arg, **kw)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/keystone/token/persistence/core.py", line
88, in _get_token
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi return
self.driver.get_token(token_id)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib/python2.7/site-packages/keystone/token/persistence/backends/sql.py",
line 92, in get_token
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi token_ref =
session.query(TokenModel).get(token_id)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 820, in
get
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi return
loading.load_on_ident(self, key)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib64/python2.7/site-packages/sqlalchemy/orm/loading.py", line 231,
in load_on_ident
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi return q.one()
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2369, in
one
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi ret =
list(self)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2412, in
__iter__
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi return
self._execute_and_instances(context)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2427, in
_execute_and_instances
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi result =
conn.execute(querycontext.statement, self._params)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 729,
in execute
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi return
meth(self, multiparams, params)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 321,
in _execute_on_connection
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi return
connection._execute_clauseelement(self, multiparams, params)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 826,
in _execute_clauseelement
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi compiled_sql,
distilled_params
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 958,
in _execute_context
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi context)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1156,
in _handle_dbapi_exception
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
util.raise_from_cause(newraise, exc_info)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 199,
in raise_from_cause
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
reraise(type(exception), exception, tb=exc_tb)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 951,
in _execute_context
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi context)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line
436, in do_execute
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
cursor.execute(statement, parameters)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 174, in
execute
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
self.errorhandler(self, exc, value)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi File
"/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in
defaulterrorhandler
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi raise
errorclass, errorvalue
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi ProgrammingError:
(ProgrammingError) (1146, "Table 'keystone.token' doesn't exist") 'SELECT
token.id AS token_id, token.expires AS token_expires, token.extra AS
token_extra, token.valid AS token_valid, token.user_id AS token_user_id,
token.trust_id AS token_trust_id \nFROM token \nWHERE token.id = %s'
('2c0dc0032d675623f37a',)
2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
2015-01-15 01:08:34.131 50243 INFO eventlet.wsgi.server [-] 192.168.0.200 -
- [15/Jan/2015 01:08:34] "POST /v2.0/tenants HTTP/1.1" 500 291 0.020139
On Thu, Jan 15, 2015 at 2:04 PM, Alex Leonhardt <aleonhardt.py at gmail.com>
wrote:
> I don't think anyone should try to install OS manually :) .. But check the
> keystone logs for what caused the 500? Maybe the admin tenant/project
> already exists?
>
> On Thu, 15 Jan 2015 08:29 Anwar Durrani <durrani.anwar at gmail.com> wrote:
>
>> Hi everyone,
>>
>> i am getting below error while running below command
>>
>> [root at localhost ~]# keystone tenant-create --name admin --description
>> "Admin Tenant"
>> An unexpected error prevented the server from fulfilling your request.
>> (HTTP 500)
>> [root at localhost ~]#
>>
>> Prior to run this command i have done following :
>>
>> *o - Juno - Juno - Juno - Juno - Juno - Juno - Juno - *
>>
>> * Create tenants, users, and roles*
>>
>> After you install the Identity service, create tenants (projects), users,
>> and roles for your environment. You must use the temporary
>> administration token that you created in the section called “Install and
>> configure”
>> <http://docs.openstack.org/juno/install-guide/install/yum/content/keystone-install.html>
>> and manually configure the location (endpoint) of the Identity service
>> before you run *keystone* commands.
>>
>> You can pass the value of the administration token to the *keystone*
>> command with the --os-token option or set the temporary OS_SERVICE_TOKEN
>> environment variable. Similarly, you can pass the location of the Identity
>> service to the *keystone* command with the --os-endpoint option or set
>> the temporary OS_SERVICE_ENDPOINT environment variable. This guide uses
>> environment variables to reduce command length.
>>
>> For more information, see the Operations Guide - Managing Project and
>> Users
>> <http://docs.openstack.org/openstack-ops/content/projects_users.html>.
>>
>>
>>
>> *To configure prerequisites*
>>
>> 1. Configure the administration token:
>> $ export OS_SERVICE_TOKEN=1dd717043ad277e29edb
>> $ export OS_SERVICE_TOKEN=294a4c8a8a475f9b9836
>> 2. Configure the endpoint:
>> $ export OS_SERVICE_ENDPOINT=http://*controller*:35357/v2.0
>>
>>
>> Please advise, how to fix this issue ?
>>
>> Thanks
>>
>> --
>> Thanks & regards,
>> Anwar M. Durrani
>> +91-8605010721
>> <http://in.linkedin.com/pub/anwar-durrani/20/b55/60b>
>>
>>
>> _______________________________________________
>> OpenStack-operators mailing list
>> OpenStack-operators at lists.openstack.org
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
>>
>
--
Thanks & regards,
Anwar M. Durrani
+91-8605010721
<http://in.linkedin.com/pub/anwar-durrani/20/b55/60b>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20150115/3fb18e61/attachment-0001.html>
More information about the OpenStack-operators
mailing list