OpenStack Identity (keystone)

Unit test failures with sqlalchemy 1.0.6

Bug #1474760 reported by Thomas Goirand on 2015-07-15

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	OpenStack Identity (keystone)	Expired	Undecided	Unassigned

Bug Description

Hi,

Building Keystone in Jessie poses no problem, but it looks like in Sid, Keystone doesn't like SQLAlchemy 1.0.6. Here's a full build log:

http://sid.gplhost.com/keystone_8.0.0~b1-1_amd64.build

Just in case if that file wasn't available, here's an example crash. There's one single occurence of the first failure, and 26 of the 2nd one with migrate.exceptions.DatabaseAlreadyControlledError as error.

FAIL: keystone.tests.unit.test_sql_upgrade.SqlUpgradeTests.test_add_actor_id_index
----------------------------------------------------------------------
Traceback (most recent call last):
testtools.testresult.real._StringException: Empty attachments:
  pythonlogging:''-1
  stderr
  stdout

pythonlogging:'': {{{
Adding cache-proxy 'keystone.tests.unit.test_cache.CacheIsolatingProxy' to backend.
Loading repository /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo...
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/044_icehouse.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/044_icehouse.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/045_placeholder.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/045_placeholder.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/046_placeholder.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/046_placeholder.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/047_placeholder.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/047_placeholder.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/048_placeholder.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/048_placeholder.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/049_placeholder.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/049_placeholder.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/050_fk_consistent_indexes.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/050_fk_consistent_indexes.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/051_add_id_mapping.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/051_add_id_mapping.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/052_add_auth_url_to_region.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/052_add_auth_url_to_region.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/053_endpoint_to_region_association.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/053_endpoint_to_region_association.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/054_add_actor_id_index.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/054_add_actor_id_index.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/055_add_indexes_to_token_table.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/055_add_indexes_to_token_table.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/056_placeholder.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/056_placeholder.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/057_placeholder.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/057_placeholder.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/058_placeholder.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/058_placeholder.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/059_placeholder.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/059_placeholder.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/060_placeholder.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/060_placeholder.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/061_add_parent_project.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/061_add_parent_project.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/062_drop_assignment_role_fk.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/062_drop_assignment_role_fk.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/063_drop_region_auth_url.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/063_drop_region_auth_url.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/064_drop_user_and_group_fk.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/064_drop_user_and_group_fk.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/065_add_domain_config.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/065_add_domain_config.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/066_fixup_service_name_value.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/066_fixup_service_name_value.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/067_drop_redundant_mysql_index.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/067_drop_redundant_mysql_index.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/068_placeholder.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/068_placeholder.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/069_placeholder.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/069_placeholder.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/070_placeholder.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/070_placeholder.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/071_placeholder.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/071_placeholder.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/072_placeholder.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/072_placeholder.py loaded successfully
Loading script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/073_insert_assignment_inherited_pk.py...
Script /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo/versions/073_insert_assignment_inherited_pk.py loaded successfully
Repository /home/zigo/sources/openstack/liberty/keystone/build-area/keystone-8.0.0~b1/keystone/common/sql/migrate_repo loaded successfully
Config: OrderedDict([('db_settings', OrderedDict([('__name__', 'db_settings'), ('repository_id', 'keystone'), ('version_table', 'migrate_version'), ('required_dbs', '[]'), ('use_timestamp_numbering', 'False')]))])
}}}

Traceback (most recent call last):
  File "keystone/tests/unit/test_sql_upgrade.py", line 196, in tearDown
    conn.execute(schema.DropConstraint(fkc))
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
    return connection._execute_ddl(self, multiparams, params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
    compiled
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
    util.raise_from_cause(newraise, exc_info)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (pysqlite2.dbapi2.OperationalError) near "DROP": syntax error [SQL: u'ALTER TABLE endpoint DROP CONSTRAINT fk_endpoint_region_id']

======================================================================
FAIL: keystone.tests.unit.test_sql_upgrade.SqlUpgradeTests.test_add_domain_config
----------------------------------------------------------------------
Traceback (most recent call last):
testtools.testresult.real._StringException: Empty attachments:
  pythonlogging:''-1
  stderr
  stdout

Traceback (most recent call last):
  File "keystone/tests/unit/test_sql_upgrade.py", line 167, in setUp
    self.repo_path, self.initial_db_version)
  File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 141, in create
    table = cls._create_table_version(engine, repository, version)
  File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 189, in _create_table_version
    raise exceptions.DatabaseAlreadyControlledError
migrate.exceptions.DatabaseAlreadyControlledError

Thomas Goirand (thomas-goirand) on 2015-07-15

Changed in keystone:
status:	New → Confirmed

Revision history for this message

Boris Bobrov (bbobrov) wrote on 2015-07-15:

I cannot confirm that with SQLAlchemy==1.0.6. Could you please post an output of `pip freeze` of the env where you run the tests?

Revision history for this message

Thomas Goirand (thomas-goirand) wrote on 2015-07-15:

Download full text (7.1 KiB)

Hi. pip freeze, no, bug dpkg -l, yes. Here's the output:

Hi. pip freeze, no, bug dpkg -l, yes. Here's the output:

# dpkg -l | grep "^ii  python-" | awk '{print $2 " " $3}'
python-aioeventlet 0.4-1
python-alembic 0.7.6-1
python-all 2.7.9-1
python-all-dev 2.7.9-1
python-amqp 1.4.6-2
python-anyjson 0.3.3-1
python-autobahn 0.10.3+dfsg1-2
python-awsauth 0.1.5-1
python-babel 1.3+dfsg.1-5
python-babel-localedata 1.3+dfsg.1-5
python-barbicanclient 3.0.3-1
python-bashate 0.3.1-1
python-beaker 1.6.4-2
python-boto 2.38.0-1
python-bs4 4.3.2-2
python-bson 3.0.1-1
python-cachetools 1.0.0-1
python-cffi 1.1.2-1
python-cffi-backend 1.1.2-1
python-characteristic 0.1.0-1
python-chardet 2.3.0-1
python-chardet-whl 2.3.0-1
python-cinderclient 1:1.2.2-1
python-cliff 1.10.1-2
python-cmd2 0.6.7-2
python-colorama 0.3.3-1
python-colorama-whl 0.3.3-1
python-concurrent.futures 3.0.3-1
python-contextlib2 0.4.0-2.1
python-coverage 3.7.1+dfsg.1-1+b1
python-crank 0.7.2-1
python-croniter 0.3.8-1
python-crypto 2.6.1-5+b2
python-cryptography 0.8.2-4
python-d2to1 0.2.11-1
python-dateutil 2.2-2
python-ddt 1.0.0-1
python-debian 0.1.27
python-debtcollector 0.5.0-1
python-decorator 3.4.0-2
python-demjson 2.2.2-1
python-dev 2.7.9-1
python-distlib 0.2.0-2
python-distlib-whl 0.2.0-2
python-dns 2.3.6-3
python-dnspython 1.12.0-1
python-docutils 0.12+dfsg-1
python-dogpile.cache 0.5.4-1
python-dogpile.core 0.4.1+dfsg1-2
python-dput 1.9
python-ecdsa 0.13-2
python-elasticsearch 1.6.0-1
python-enum34 1.0.4-1
python-eventlet 0.17.4-2
python-extras 0.0.3-3
python-falcon 0.1.8-3
python-fasteners 0.12.0-1
python-feedparser 5.1.3-3
python-fixtures 0.3.14-1.1
python-flake8 2.2.2-1
python-flask 0.10.1-2
python-formencode 1.2.6-2
python-futurist 0.1.2-1
python-futurist-doc 0.1.2-1
python-genshi 0.7-3
python-gevent 1.0.1-2
python-gflags 1.5.1-2
python-glanceclient 1:0.19.0-1
python-greenlet 0.4.7-1
python-hacking 0.10.2-2
python-happybase 0.8-2
python-html5lib 0.999-3
python-html5lib-whl 0.999-3
python-httplib2 0.9+dfsg-2
python-ibm-db-sa 0.3.0-2
python-ipaddr 2.1.11-2
python-ironicclient 0.7.0-1
python-iso8601 0.1.10-2
python-itsdangerous 0.24+dfsg1-1
python-jinja2 2.7.3-1
python-json-patch 1.3-5
python-json-pointer 1.0-2
python-jsonpatch 1.3-5
python-jsonpath-rw 1.2.0-1
python-jsonrpclib 0.1.3-1
python-jsonschema 2.4.0-1
python-jwt 0.2.1-1
python-kafka 0.9.3-2
python-kazoo 2.2.1-0.1
python-keyring 4.0-1
python-keystoneclient 1:1.6.0-1
python-keystonemiddleware 1.5.0-2
python-kid 0.9.6-2.1
python-kombu 3.0.26-1
python-ldap 2.4.10-1
python-ldappool 1.0-1
python-linecache2 1.0.0-1
python-lockfile 1:0.10.2-2
python-logutils 0.3.3-4
python-lxml 3.4.2-1
python-lz4 0.7.0+dfsg-2
python-mako 1.0.0+dfsg-0.1
python-markupsafe 0.23-2
python-mccabe 0.2.1-1
python-memcache 1.54+20150423+git+48e882719c-2
python-migrate 0.9.7-2
python-mimeparse 0.1.4-1
python-minimal 2.7.9-1
python-mock 1.0.1-3
python-monotonic 0.2-1
python-mox 0.5.3-4
python-mox3 0.7.0-2
python-msgpack 0.4.2-1
python-mysqldb 1.2.3-2.1
python-netaddr 0.7.14-1
python-netifaces 0.10.4-0.1
python-networkx 1.9+dfsg1-1
python-neutronclient 1:2.6.0-1
python-nose 1.3.6-1
python-novaclient 2:2.26.0-1
python-numpy 1:1.8.2-2
python-oauthlib 0.6.3-1
python-openid 2.2.5-6
python-openssl 0.15.1-2
python-os-testr 0.2.0-1
python-os-testr-doc 0.2.0-1
python-oslo-db 1.11.0-2
python-oslo-db-doc 1.11.0-2
python-oslo.concurrency 2.0.0-1
python-oslo.config 1:1.12.1-3
python-oslo.context 0.3.0-1
python-oslo.db 1.11.0-2
python-oslo.db-doc 1.11.0-2
python-oslo.i18n 1.7.0-1
python-oslo.log 1.4.0-1
python-oslo.messaging 1.14.0-1
python-oslo.middleware 2.1.0-1
python-oslo.policy 0.5.0-1
python-oslo.rootwrap 2.0.0-2
python-oslo.serialization 1.6.0-1
python-oslo.utils 1.6.0-2
python-oslo.versionedobjects 0.3.0-1
python-oslo.vmware 0.13.1-1
python-oslosphinx 2.5.0-1
python-oslotest 1:1.7.0-2
python-oslotest-doc 1:1.7.0-2
python-osprofiler 0.3.0-2
python-pam 0.4.2-13.1
python-pandas 0.16.2+git65-g054821d-1
python-pandas-lib 0.16.2+git65-g054821d-1
python-paramiko 1.15.2-1
python-passlib 1.6.1-1.3
python-paste 1.7.5.1-6
python-pastedeploy 1.5.2-1
python-pastedeploy-tpl 1.5.2-1
python-pastescript 1.7.5-3
python-pbr 1.2.0-1
python-pbr-doc 1.2.0-1
python-peak.rules 0.5a1+r2707-1
python-peak.util 20110909-1
python-peak.util.decorators 1.8-2
python-pecan 0.8.2-1
python-pexpect 3.2-1
python-pip 1.5.6-6
python-pip-whl 1.5.6-6
python-pkg-resources 17.0-1
python-ply 3.4-5
python-posix-ipc 0.9.8-2+b1
python-prettytable 0.7.2-3
python-psutil 2.1.1-1+b1
python-psycopg2 2.6.1-1
python-pyasn1 0.1.7-1
python-pyasn1-modules 0.0.5-0.1
python-pycadf 0.8.0-1
python-pycparser 2.14+dfsg-1
python-pygments 2.0.1+dfsg-1.1
python-pylons 1.0.1-3
python-pymemcache 1.2.4-2
python-pymongo 3.0.1-1
python-pymysql 0.6.2-1
python-pyparsing 2.0.3+dfsg1-1
python-pysaml2 2.4.0-2
python-pysnmp4 4.2.5-1
python-pysqlite2 2.6.3-4
python-pyudev 0.16.1-3
python-qpid 0.22+dfsg-1
python-redis 2.10.3-3
python-repoze.lru 0.6-5
python-repoze.tm2 2.0-1
python-repoze.what 1.0.9-5
python-repoze.what-plugins 20090531-3.1
python-repoze.who 1.0.18-4
python-repoze.who-plugins 20090913-2
python-requestbuilder 0.2.3-1
python-requests 2.7.0-3
python-requests-mock 0.6.0-2
python-requests-whl 2.7.0-3
python-retrying 1.3.3-1
python-rfc3986 0.2.0-2
python-roman 2.0.0-1
python-routes 2.0-1
python-rtslib-fb 2.1.45-4
python-scripttest 1.3-1
python-service-identity 1.0.0-3
python-setuptools 17.0-1
python-setuptools-whl 17.0-1
python-simplegeneric 0.8.1-1
python-simplejson 3.7.3-1
python-singledispatch 3.4.0.3-2
python-six 1.9.0-3
python-six-whl 1.9.0-3
python-snappy 0.5-1
python-sphinx 1.2.3+dfsg-1
python-sphinx-rtd-theme 0.1.8-1
python-sphinxcontrib-docbookrestapi 0.2.1-1
python-sphinxcontrib-httpdomain 1.3.0-1
python-sphinxcontrib-pecanwsme 0.8.0-2
python-sphinxcontrib.docbookrestapi 0.2.1-1
python-sphinxcontrib.httpdomain 1.3.0-1
python-sphinxcontrib.issuetracker 0.11-1
python-sqlalchemy 1.0.6+ds1-1
python-sqlparse 0.1.13-2
python-stevedore 1.5.0-1
python-subunit 1.1.0-1
python-suds 0.4.1-16
python-support 1.0.15
python-tablib 0.9.11-2
python-tempest-lib 0.5.0-2
python-tempest-lib-doc 0.5.0-2
python-tempita 0.5.2-1
python-testrepository 0.0.20-1
python-testresources 0.2.7-4
python-testscenarios 0.4-4
python-testtools 1.8.0-1
python-testtools-doc 1.8.0-1
python-thrift 0.9.1-2
python-tidylib 0.2.1~dfsg-2
python-toscawidgets 0.9.7.2-3
python-traceback2 1.4.0-1
python-transaction 1.4.3-3
python-trollius 1.0.1-1
python-turbogears2 2.3.5-0.1
python-turbojson 1.3.2-2.1
python-turbokid 1.0.5-1
python-twisted 14.0.2-3
python-twisted-bin 14.0.2-3
python-twisted-conch 1:14.0.2-3
python-twisted-core 14.0.2-3
python-twisted-lore 14.0.2-3
python-twisted-mail 14.0.2-3
python-twisted-names 14.0.2-3
python-twisted-news 14.0.2-3
python-twisted-runner 14.0.2-3
python-twisted-web 14.0.2-3
python-twisted-words 14.0.2-3
python-txaio 1.0.0-2
python-tz 2012c+dfsg-0.1
python-unittest2 1.1.0-3
python-urllib3 1.10.4-1
python-urllib3-whl 1.10.4-1
python-virtualenv 1.11.6+ds-1
python-waitress 0.8.9-2
python-warlock 1.0.1-2
python-weberror 0.10.3+dfsg-1
python-webflash 0.1a9-5
python-webhelpers 1.3-4
python-webob 1.4.1-1
python-webtest 2.0.17-1
python-werkzeug 0.9.6+dfsg-1
python-wrapt 1.8.0-5
python-wsgi-intercept 0.8.1-2
python-wsme 0.6-3
python-yaml 3.11-2
python-zake 0.1.6-1
python-zmq 14.4.0-1
python-zope.interface 4.1.1-3.1
python-zope.sqlalchemy 0.6.1-2

Revision history for this message

Dolph Mathews (dolph) wrote on 2015-07-15:

I'm unable to confirm this either, but just looking at the backtrace... it references an ALTER TABLE command:

ALTER TABLE endpoint DROP CONSTRAINT fk_endpoint_region_id

And Sqlite neither enforces FKs by default nor supports ALTER TABLE [..] DROP CONSTRAINT [..].

https://www.sqlite.org/lang_altertable.html

So Keystone specifically skips trying to tear down foreign keys in sqlite for that reason. If you're not running a 'sqlite' engine, and your engine does not support DROP CONSTRAINT either, then what engine are you running?

Changed in keystone:
status:	Confirmed → Incomplete

Revision history for this message

Thomas Goirand (thomas-goirand) wrote on 2015-07-16:

Hi. I'm running SQLite for the unit tests, as it's a way more complicated to run anything else.

Revision history for this message

Mike Bayer (zzzeek) wrote on 2015-07-16:

I think this issue has been seen elsewhere in keystone as well as many other openstack projects. all of them cut-and-paste the same "drop all tables" logic which drops all FKs and all tables. SQLite does not support DROP CONSTRAINT, and SQLA 1.0 now reflects named FKs on SQLite. so the "drop fk" must be conditional based on "engine.name != 'sqlite'".

I think there's a review present for keystone already ill try to find it later.

Revision history for this message

Launchpad Janitor (janitor) wrote on 2015-09-15:

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

Changed in keystone:
status:	Incomplete → Expired

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.