[Bug 1807262] [NEW] stein unit tests fail with sqlalchemy.exc.NoSuchTableError: migration_tmp

[Corey Bryant]

Public bug reported:

Several tests that use sqlite fail with:
"sqlalchemy.exc.NoSuchTableError: migration_tmp". I'm currently hitting
this with nova and cinder packages in disco.

Note this started sometime after 11/19 when nova
2:19.0.0~b1~git2018111953.3e756ff674-0ubuntu1 was uploaded (and built
successfully at the time).

After doing some digging this appears to occur with libsqlite3-0
3.26.0-1 but does not occur with libsqlite3-0 3.25.3-1. Here are some
more details on that, shown by running a failing unit test from the
cinder package: https://paste.ubuntu.com/p/hsnQFQD572/

** Affects: cinder (Ubuntu)
     Importance: High
         Status: Triaged

** Affects: nova (Ubuntu)
     Importance: High
         Status: Triaged

** Summary changed:

- stein unit test failures with libsqlite3-0 3.26.0-1
+ stein unit tests fail with sqlalchemy.exc.NoSuchTableError: migration_tmp

** Also affects: cinder (Ubuntu)
   Importance: Undecided
       Status: New

** Description changed:

  Several tests that use sqlite fail with:
- "sqlalchemy.exc.NoSuchTableError: migration_tmp"
+ "sqlalchemy.exc.NoSuchTableError: migration_tmp". I'm currently hitting
+ this with nova and cinder packages in disco.
  
  After doing some digging this appears to occur with libsqlite3-0
  3.26.0-1 but does not occur with libsqlite3-0 3.25.3-1. Here are some
  more details on that, shown by running a failing unit test from the
  cinder package: https://paste.ubuntu.com/p/hsnQFQD572/

** Description changed:

  Several tests that use sqlite fail with:
  "sqlalchemy.exc.NoSuchTableError: migration_tmp". I'm currently hitting
  this with nova and cinder packages in disco.
+ 
+ Note this started sometime after 11/19 when nova
+ 2:19.0.0~b1~git2018111953.3e756ff674-0ubuntu1 was uploaded (and built
+ successfully at the time).
  
  After doing some digging this appears to occur with libsqlite3-0
  3.26.0-1 but does not occur with libsqlite3-0 3.25.3-1. Here are some
  more details on that, shown by running a failing unit test from the
  cinder package: https://paste.ubuntu.com/p/hsnQFQD572/

** Changed in: cinder (Ubuntu)
       Status: New => Triaged

** Changed in: nova (Ubuntu)
       Status: New => Triaged

** Changed in: cinder (Ubuntu)
   Importance: Undecided => High

** Changed in: nova (Ubuntu)
   Importance: Undecided => High

-- 
You received this bug notification because you are a member of Ubuntu
OpenStack, which is subscribed to nova in Ubuntu.
https://bugs.launchpad.net/bugs/1807262

Title:
  stein unit tests fail with sqlalchemy.exc.NoSuchTableError:
  migration_tmp

Status in cinder package in Ubuntu:
  Triaged
Status in nova package in Ubuntu:
  Triaged

Bug description:
  Several tests that use sqlite fail with:
  "sqlalchemy.exc.NoSuchTableError: migration_tmp". I'm currently
  hitting this with nova and cinder packages in disco.

  Note this started sometime after 11/19 when nova
  2:19.0.0~b1~git2018111953.3e756ff674-0ubuntu1 was uploaded (and built
  successfully at the time).

  After doing some digging this appears to occur with libsqlite3-0
  3.26.0-1 but does not occur with libsqlite3-0 3.25.3-1. Here are some
  more details on that, shown by running a failing unit test from the
  cinder package: https://paste.ubuntu.com/p/hsnQFQD572/

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/cinder/+bug/1807262/+subscriptions