Table 'keystone.domain' doesn't exist after keystone deployed

[Wu Hong Guang]

$source openrc

$openstack service list
An unexpected error prevented the server from fulfilling your request. (HTTP 500) (Request-ID: req-2cf18a5e-ac5b-4363-96da-5fafd22fcfe0)

$tail -f /var/log/keystone/keystone-error.log
4 21 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642354 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi return meth(self, multiparams, params)
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642355 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642356 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi return connection._execute_clauseelement(self, multiparams, params)
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642357 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642358 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi compiled_sql, distilled_params
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642359 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642360 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi context)
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642361 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642363 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi util.raise_from_cause(newraise, exc_info)
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642364 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642365 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi reraise(type(exception), exception, tb=exc_tb)
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642366 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642367 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi context)
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642368 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642369 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi cursor.execute(statement, parameters)
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642370 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 205, in execute
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642371 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi self.errorhandler(self, exc, value)
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642372 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642373 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi raise errorclass, errorvalue
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642374 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi ProgrammingError: (_mysql_exceptions.ProgrammingError) (1146, "Table 'keystone.domain' doesn't exist") [SQL: u'SELECT domain.id AS domain_id, domain.name AS domain_name, domain.enabled AS domain_enabled, domain.extra AS domain_extra \\nFROM domain \\nWHERE domain.id = %s'] [parameters: ('default',)]
Nov 24 15:28:16 k1 keystone-error: 2015-11-24 15:28:16.642376 2015-11-24 15:28:16.634 21 ERROR keystone.common.wsgi

[Wu Hong Guang (whg)]

have to create the service entity and endpoint for the Identity service after deploy with OS_TOKEN=password

[Hui Kang (huikang27)]

Isn't OS_TOKEN is defined in etc/kolla/password.yml? The keystone bootstrap.yum does have OS_TOKEN.

[Wu Hong Guang (whg)]

can we add this into the post-deploy ? so the OSC is ready to be used after the deploy

[Sam Yaple (s8m)]

This looks like you didn't clean your environment between deploying so the database was created in a different run than it was bootstrapped in.

Can you reproduce this in a completely clean environment deply?

[Steven Dake (sdake)]

I am pretty sure this is all fixed up in master. Please try to reproduce on master in a clean environment.

Thanks
-steve

[Launchpad Janitor (janitor)]

[Expired for kolla because there has been no activity for 60 days.]

[ai_ja_nai (albertomassidda)]

docker exec keystone keystone-manage db_sync