Public bug reported: Description =========== When working with the latest master branch (commit 002128208cdfb238568acea74a0d8b03492d714d), the py27 tests report 18 failed tests with no changes made to the project/code. The test output is much larger than I remember from other projects (Nova / Cinder) at a whopping 8.9MB (63,634 lines) and ultimately seems to be complaining (repeatedly) with:
oslo_db.exception.DBNonExistentTable: (sqlite3.OperationalError) error in trigger federated_user_insert_trigger: no such table: main.migration_tmp [SQL: u'ALTER TABLE federated_user RENAME TO migration_tmp'] (Background on this error at: http://sqlalche.me/e/e3q8) Possible related bug report - https://bugs.debian.org/cgi- bin/bugreport.cgi?bug=909989 Steps to reproduce ================== virtualenv keystone-venv source keystone-venv/bin/activate pip install tox flake8 sudo zypper in openssl-devel python-devel openldap2-devel sqlite3 git clone https://git.openstack.org/openstack/keystone.git cd keystone pip install -r test-requirements.txt tox -e pep8 # succeeded tox -r -e py27 # failed Expected result =============== All py27 tests pass Actual result ============= 18 tests failed Environment =========== (keystone-venv) cerealkiller@thegibson:~/Desktop/Dev/python/keystone> cat /etc/SUSE-brand openSUSE VERSION = 15.0 (keystone-venv) cerealkiller@thegibson:~/Desktop/Dev/python/keystone> uname -a Linux thegibson 4.18.14-1-default #1 SMP PREEMPT Sat Oct 13 18:49:22 UTC 2018 (ce1c446) x86_64 x86_64 x86_64 GNU/Linux (keystone-venv) cerealkiller@thegibson:~/Desktop/Dev/python/keystone> git show commit 002128208cdfb238568acea74a0d8b03492d714d (HEAD -> master, origin/master, origin/HEAD) Merge: 96a39282a 9c38bb5bd Author: Zuul <z...@review.openstack.org> Date: Tue Nov 6 21:23:19 2018 +0000 Merge "Delete PKI middleware debugging section" (keystone-venv) cerealkiller@thegibson:~/Desktop/Dev/python/keystone> pip list --not-required Package Version ----------------- ----------- bashate 0.6.0 configparser 3.5.0 coverage 4.5.1 flake8-docstrings 0.2.1.post1 freezegun 0.3.11 hacking 0.12.0 lxml 4.2.5 os-testr 1.0.0 oslo.db 4.42.0 oslotest 3.7.0 pip 18.1 psycopg2 2.7.5 pycodestyle 2.4.0 PyMySQL 0.9.2 python-ldap 3.1.0 tempest 19.0.0 tox 3.5.3 WebTest 2.0.32 wheel 0.32.2 (keystone-venv) cerealkiller@thegibson:~/Desktop/Dev/python/keystone> rpm -qa | grep "libopenssl-devel\|python-devel\|openldap2-devel\|sqlite3" libopenssl-devel-1.1.0h-1.1.noarch python-devel-2.7.15-2.1.x86_64 sqlite3-3.25.2-1.1.x86_64 libsqlite3-0-3.25.2-1.1.x86_64 openldap2-devel-2.4.46-37.1.x86_64 ** Affects: keystone Importance: Undecided Status: New ** Attachment added: "tox log" https://bugs.launchpad.net/bugs/1802035/+attachment/5209823/+files/tox-py27.log -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to OpenStack Identity (keystone). https://bugs.launchpad.net/bugs/1802035 Title: Master branch failing py27 tests (oslo_db.exception.DBNonExistentTable:) Status in OpenStack Identity (keystone): New Bug description: Description =========== When working with the latest master branch (commit 002128208cdfb238568acea74a0d8b03492d714d), the py27 tests report 18 failed tests with no changes made to the project/code. The test output is much larger than I remember from other projects (Nova / Cinder) at a whopping 8.9MB (63,634 lines) and ultimately seems to be complaining (repeatedly) with: oslo_db.exception.DBNonExistentTable: (sqlite3.OperationalError) error in trigger federated_user_insert_trigger: no such table: main.migration_tmp [SQL: u'ALTER TABLE federated_user RENAME TO migration_tmp'] (Background on this error at: http://sqlalche.me/e/e3q8) Possible related bug report - https://bugs.debian.org/cgi- bin/bugreport.cgi?bug=909989 Steps to reproduce ================== virtualenv keystone-venv source keystone-venv/bin/activate pip install tox flake8 sudo zypper in openssl-devel python-devel openldap2-devel sqlite3 git clone https://git.openstack.org/openstack/keystone.git cd keystone pip install -r test-requirements.txt tox -e pep8 # succeeded tox -r -e py27 # failed Expected result =============== All py27 tests pass Actual result ============= 18 tests failed Environment =========== (keystone-venv) cerealkiller@thegibson:~/Desktop/Dev/python/keystone> cat /etc/SUSE-brand openSUSE VERSION = 15.0 (keystone-venv) cerealkiller@thegibson:~/Desktop/Dev/python/keystone> uname -a Linux thegibson 4.18.14-1-default #1 SMP PREEMPT Sat Oct 13 18:49:22 UTC 2018 (ce1c446) x86_64 x86_64 x86_64 GNU/Linux (keystone-venv) cerealkiller@thegibson:~/Desktop/Dev/python/keystone> git show commit 002128208cdfb238568acea74a0d8b03492d714d (HEAD -> master, origin/master, origin/HEAD) Merge: 96a39282a 9c38bb5bd Author: Zuul <z...@review.openstack.org> Date: Tue Nov 6 21:23:19 2018 +0000 Merge "Delete PKI middleware debugging section" (keystone-venv) cerealkiller@thegibson:~/Desktop/Dev/python/keystone> pip list --not-required Package Version ----------------- ----------- bashate 0.6.0 configparser 3.5.0 coverage 4.5.1 flake8-docstrings 0.2.1.post1 freezegun 0.3.11 hacking 0.12.0 lxml 4.2.5 os-testr 1.0.0 oslo.db 4.42.0 oslotest 3.7.0 pip 18.1 psycopg2 2.7.5 pycodestyle 2.4.0 PyMySQL 0.9.2 python-ldap 3.1.0 tempest 19.0.0 tox 3.5.3 WebTest 2.0.32 wheel 0.32.2 (keystone-venv) cerealkiller@thegibson:~/Desktop/Dev/python/keystone> rpm -qa | grep "libopenssl-devel\|python-devel\|openldap2-devel\|sqlite3" libopenssl-devel-1.1.0h-1.1.noarch python-devel-2.7.15-2.1.x86_64 sqlite3-3.25.2-1.1.x86_64 libsqlite3-0-3.25.2-1.1.x86_64 openldap2-devel-2.4.46-37.1.x86_64 To manage notifications about this bug go to: https://bugs.launchpad.net/keystone/+bug/1802035/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp