Comment 6 for bug 1595819

Gotcha. Thanks for the info.

The keystone error is easily re-creatable on a keystone only setup by just doing:

  $ openstack user create tempo --debug

In the keystone logs:

2016-06-24 05:08:18.701 76356 ERROR oslo_db.sqlalchemy.exc_filters [req-10b0b459-2bb6-4e19-b70a-92147a90a6bd c6de05b4530848748c977c79c4364a0b 9ece489efd7d4146a9a4aa7e81663e40 - default default] DBAPIError exception wrapped from (pymysql.err.IntegrityError) (1048, u"Column 'password' cannot be null") [SQL: u'INSERT INTO password (local_user_id, password, created_at, expires_at) VALUES (%(local_user_id)s, %(password)s, %(created_at)s, %(expires_at)s)'] [parameters: {'local_user_id': 5, 'password': None, 'created_at': datetime.datetime(2016, 6, 24, 12, 8, 18, 696911), 'expires_at': None}]
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters context)
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 161, in execute
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters result = self._query(query)
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 317, in _query
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters conn.query(q)
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters result.read()
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet()
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters packet.check_error()
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data)
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters _check_mysql_exception(errinfo)
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errorvalue)
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters IntegrityError: (1048, u"Column 'password' cannot be null")
2016-06-24 05:08:18.701 76356 TRACE oslo_db.sqlalchemy.exc_filters
2016-06-24 05:08:18.703 76356 DEBUG keystone.common.sql.core [req-10b0b459-2bb6-4e19-b70a-92147a90a6bd c6de05b4530848748c977c79c4364a0b 9ece489efd7d4146a9a4aa7e81663e40 - default default] Conflict user: (pymysql.err.IntegrityError) (1048, u"Column 'password' cannot be null") [SQL: u'INSERT INTO password (local_user_id, password, created_at, expires_at) VALUES (%(local_user_id)s, %(password)s, %(created_at)s, %(expires_at)s)'] [parameters: {'local_user_id': 5, 'password': None, 'created_at': datetime.datetime(2016, 6, 24, 12, 8, 18, 696911), 'expires_at': None}] wrapper /opt/stack/keystone/keystone/common/sql/core.py:444
2016-06-24 05:08:18.704 76356 WARNING keystone.common.wsgi [req-10b0b459-2bb6-4e19-b70a-92147a90a6bd c6de05b4530848748c977c79c4364a0b 9ece489efd7d4146a9a4aa7e81663e40 - default default] An unexpected error prevented the server from fulfilling your request.