← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1802035] Re: Master branch failing py27 tests (oslo_db.exception.DBNonExistentTable:)

 

[Expired for OpenStack Identity (keystone) because there has been no
activity for 60 days.]

** Changed in: keystone
       Status: Incomplete => Expired

-- 
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):
  Expired

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 <zuul@xxxxxxxxxxxxxxxxxxxx>
  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


References