Bug#846981: marked as done (DBError: (pymysql.err.InternalError) (1049, u"Unknown database 'keystone'"))

[Debian Bug Tracking System]

Your message dated Sun, 18 Dec 2016 11:53:44 +0100
with message-id <98658541-aee6-5ff6-3c72-4201d3d11...@debian.org>
and subject line Closing for now
has caused the Debian Bug report #846981,
regarding DBError: (pymysql.err.InternalError) (1049, u"Unknown database 
'keystone'")
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)


-- 
846981: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=846981
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems

--- Begin Message ---

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: tu...@bayour.com
* keystone/endpoint-ip: 10.0.4.1
* keystone/db/dbname: keystone
* keystone/admin-tenant-name: admin

--- End Message ---

--- Begin Message ---

It's not clear if this bug is valid, closing for now until we have more
info. Discussion is still open, but maybe best on the team's list.

Thomas Goirand (zigo)

--- End Message ---