[PKG-Openstack-devel] Bug#846981: DBError: (pymysql.err.InternalError) (1049, u"Unknown database 'keystone'")

Turbo Fredriksson turbo at bayour.com
Sun Dec 4 19:45:57 UTC 2016 

Package: keystone
Version: 2:10.0.0-2
Severity: important

Trying to start over, this time using Stretch (no backports).

When I try to pre-seed keystone, I endup with no database. Running

  dpkg-reconfigure keystone

manually to try to figure out if there's something _I_ did, I eventually end up with:

----- s n i p -----
Running su keystone -s /bin/sh -c 'keystone-manage --noverbose db_sync'...
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped from (pymysql.err.InternalError) (1049, u"Unknown database 'keystone'")
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     return fn()
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 318, in unique_connection
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     return _ConnectionFairy._checkout(self)
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 713, in _checkout
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     fairy = _ConnectionRecord.checkout(pool)
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 480, in checkout
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     rec = pool._do_get()
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1060, in _do_get
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     self._dec_overflow()
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     compat.reraise(exc_type, exc_value, exc_tb)
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1057, in _do_get
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     return self._create_connection()
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 323, in _create_connection
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     return _ConnectionRecord(self)
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 449, in __init__
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     self.connection = self.__connect()
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 607, in __connect
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     connection = self.__pool._invoke_creator(self)
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 97, in connect
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     return dialect.connect(*cargs, **cparams)
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 385, in connect
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     return self.dbapi.connect(*cargs, **cparams)
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/pymysql/__init__.py", line 90, in Connect
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     return Connection(*args, **kwargs)
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 688, in __init__
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     self.connect()
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 906, in connect
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     self._request_authentication()
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1114, in _request_authentication
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     auth_packet = self._read_packet()
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     packet.check_error()
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     err.raise_mysql_exception(self._data)
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters     raise errorclass(errno, errval)
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters InternalError: (1049, u"Unknown database 'keystone'")
2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters
2016-12-04 19:33:36.362 28208 CRITICAL keystone [-] DBError: (pymysql.err.InternalError) (1049, u"Unknown database 'keystone'")
2016-12-04 19:33:36.362 28208 ERROR keystone Traceback (most recent call last):
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/bin/keystone-manage", line 10, in <module>
2016-12-04 19:33:36.362 28208 ERROR keystone     sys.exit(main())
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/cmd/manage.py", line 44, in main
2016-12-04 19:33:36.362 28208 ERROR keystone     cli.main(argv=sys.argv, config_files=config_files)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 1254, in main
2016-12-04 19:33:36.362 28208 ERROR keystone     CONF.command.cmd_class.main()
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 445, in main
2016-12-04 19:33:36.362 28208 ERROR keystone     CONF.command.version)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 207, in offline_sync_database_to_version
2016-12-04 19:33:36.362 28208 ERROR keystone     expand_schema()
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 232, in expand_schema
2016-12-04 19:33:36.362 28208 ERROR keystone     _sync_common_repo(version=None)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 123, in _sync_common_repo
2016-12-04 19:33:36.362 28208 ERROR keystone     with sql.session_for_write() as session:
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__
2016-12-04 19:33:36.362 28208 ERROR keystone     return self.gen.next()
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 874, in _transaction_scope
2016-12-04 19:33:36.362 28208 ERROR keystone     allow_async=self._allow_async) as resource:
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__
2016-12-04 19:33:36.362 28208 ERROR keystone     return self.gen.next()
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 518, in _session
2016-12-04 19:33:36.362 28208 ERROR keystone     bind=self.connection, mode=self.mode)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 277, in _create_session
2016-12-04 19:33:36.362 28208 ERROR keystone     self._start()
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 363, in _start
2016-12-04 19:33:36.362 28208 ERROR keystone     engine_args, maker_args)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 387, in _setup_for_connection
2016-12-04 19:33:36.362 28208 ERROR keystone     sql_connection=sql_connection, **engine_kwargs)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 155, in create_engine
2016-12-04 19:33:36.362 28208 ERROR keystone     test_conn = _test_connection(engine, max_retries, retry_interval)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 331, in _test_connection
2016-12-04 19:33:36.362 28208 ERROR keystone     return engine.connect()
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2018, in connect
2016-12-04 19:33:36.362 28208 ERROR keystone     return self._connection_cls(self, **kwargs)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 72, in __init__
2016-12-04 19:33:36.362 28208 ERROR keystone     if connection is not None else engine.raw_connection()
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2104, in raw_connection
2016-12-04 19:33:36.362 28208 ERROR keystone     self.pool.unique_connection, _connection)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2078, in _wrap_pool_connect
2016-12-04 19:33:36.362 28208 ERROR keystone     e, dialect, self)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1401, in _handle_dbapi_exception_noconnection
2016-12-04 19:33:36.362 28208 ERROR keystone     util.raise_from_cause(newraise, exc_info)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
2016-12-04 19:33:36.362 28208 ERROR keystone     reraise(type(exception), exception, tb=exc_tb, cause=cause)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect
2016-12-04 19:33:36.362 28208 ERROR keystone     return fn()
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 318, in unique_connection
2016-12-04 19:33:36.362 28208 ERROR keystone     return _ConnectionFairy._checkout(self)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 713, in _checkout
2016-12-04 19:33:36.362 28208 ERROR keystone     fairy = _ConnectionRecord.checkout(pool)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 480, in checkout
2016-12-04 19:33:36.362 28208 ERROR keystone     rec = pool._do_get()
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1060, in _do_get
2016-12-04 19:33:36.362 28208 ERROR keystone     self._dec_overflow()
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
2016-12-04 19:33:36.362 28208 ERROR keystone     compat.reraise(exc_type, exc_value, exc_tb)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1057, in _do_get
2016-12-04 19:33:36.362 28208 ERROR keystone     return self._create_connection()
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 323, in _create_connection
2016-12-04 19:33:36.362 28208 ERROR keystone     return _ConnectionRecord(self)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 449, in __init__
2016-12-04 19:33:36.362 28208 ERROR keystone     self.connection = self.__connect()
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 607, in __connect
2016-12-04 19:33:36.362 28208 ERROR keystone     connection = self.__pool._invoke_creator(self)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 97, in connect
2016-12-04 19:33:36.362 28208 ERROR keystone     return dialect.connect(*cargs, **cparams)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 385, in connect
2016-12-04 19:33:36.362 28208 ERROR keystone     return self.dbapi.connect(*cargs, **cparams)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/pymysql/__init__.py", line 90, in Connect
2016-12-04 19:33:36.362 28208 ERROR keystone     return Connection(*args, **kwargs)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 688, in __init__
2016-12-04 19:33:36.362 28208 ERROR keystone     self.connect()
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 906, in connect
2016-12-04 19:33:36.362 28208 ERROR keystone     self._request_authentication()
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1114, in _request_authentication
2016-12-04 19:33:36.362 28208 ERROR keystone     auth_packet = self._read_packet()
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2016-12-04 19:33:36.362 28208 ERROR keystone     packet.check_error()
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2016-12-04 19:33:36.362 28208 ERROR keystone     err.raise_mysql_exception(self._data)
2016-12-04 19:33:36.362 28208 ERROR keystone   File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
2016-12-04 19:33:36.362 28208 ERROR keystone     raise errorclass(errno, errval)
2016-12-04 19:33:36.362 28208 ERROR keystone DBError: (pymysql.err.InternalError) (1049, u"Unknown database 'keystone'")
2016-12-04 19:33:36.362 28208 ERROR keystone
----- s n i p -----

And a 'mysqlshow' doesn't show the 'keystone' database..

-- System Information:
Debian Release: stretch/sid
  APT prefers testing-updates
  APT policy: (500, 'testing-updates'), (500, 'testing-proposed-updates'), (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 3.16.0-4-amd64 (SMP w/16 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages keystone depends on:
ii  adduser                                 3.115
ii  apache2                                 2.4.23-8
ii  dbconfig-common                         2.0.6
ii  debconf [debconf-2.0]                   1.5.59
ii  init-system-helpers                     1.46
ii  libapache2-mod-wsgi                     4.5.7-1
ii  lsb-base                                9.20161125
ii  python-keystone                         2:10.0.0-2
ii  python-q-text-as-data [q-text-as-data]  1.4.0-1
ii  sqlite3                                 3.15.1-1
ii  ssl-cert                                1.0.38

keystone recommends no packages.

Versions of packages keystone suggests:
pn  apparmor  <none>

-- debconf information:
* keystone/admin-password: (password omitted)
* keystone/mysql/admin-pass: (password omitted)
* keystone/admin-password-confirm: (password omitted)
* keystone/auth-token: (password omitted)
* keystone/app-password-confirm: (password omitted)
* keystone/mysql/app-pass: (password omitted)
* keystone/password-confirm: (password omitted)
* keystone/rabbit_password: (password omitted)
* keystone/dbconfig-remove: true
* keystone/db/app-user: keystone
* keystone/upgrade-backup: true
* keystone/missing-db-package-error: abort
* keystone/remote/port:
* keystone/dbconfig-install: true
* keystone/remote/host: openstack.bayour.com
* keystone/register-endpoint: true
* keystone/internal/reconfiguring: true
* keystone/remove-error: abort
* keystone/rabbit_userid: openstack
* keystone/install-error: abort
* keystone/mysql/admin-user: root
* keystone/configure_db: true
* keystone/remote/newhost: openstack.bayour.com
* keystone/admin-role-name: admin
* keystone/internal/skip-preseed: true
* keystone/purge: true
  keystone/passwords-do-not-match:
* keystone/create-admin-tenant: true
* keystone/dbconfig-reinstall: false
* keystone/mysql/method: TCP/IP
* keystone/dbconfig-upgrade: true
* keystone/region-name: europe-london
* keystone/database-type: mysql
* keystone/admin-user: admin
* keystone/upgrade-error: abort
* keystone/admin-email: turbo at bayour.com
* keystone/endpoint-ip: 10.0.4.1
* keystone/db/dbname: keystone
* keystone/admin-tenant-name: admin

More information about the Openstack-devel mailing list