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

[Christian Ehrhardt ]

FYI there is [1] now (since an hour), which is building atm.
The delta added is [2] to 

The code that seems to be related and not working is not using a view, but who knows [3]
  self.append('ALTER TABLE %s RENAME TO migration_tmp' % table_name)
(If that is the right code at all, I need to check the package)


I first reproduced it locally with cinder as corey has shown.
it worked with 3.24 and got massive (not just this) errors with 3.26

Note: by enabling cosmic, disco and disco-proposed repos you can up and downgrade to all three.
Also useful [4] on how to run isolated tests of cinder.

Much more tests fail BTW, it seems all of the same class of tests fail.
So maybe it is a DB setup issue with the new sqlite.

sqlite 3.24.0-1: works
sqlite 3.26.0-1: fails
sqlite 3.26.0-2: fails

So the next version is not a fix that will unblock us.
Also [5] changelog isn't pointing to anything obvious (I'm sure once we know it later it will be obvious).

We need to isolate the first fail as all others could be follow on issues.
So far it refused be isolated to a reasonable subset of tests.
But I didn't focus on that yet, I'll go back to 3.24 and try to shrink the set.

[1]: https://launchpad.net/ubuntu/+source/sqlite3/3.26.0-2
[2]: http://launchpadlibrarian.net/400530194/sqlite3_3.26.0-1_3.26.0-2.diff.gz
[3]: https://gitlab.cern.ch/cloud-infrastructure/rally/commit/3995f1fcd03b76f923637f39cc1b12f599fa61f6?expanded=1#21dac577876a8712e411fa71aa768fbd11a87883_108_0
[4]: https://docs.openstack.org/cinder/latest/contributor/testing.html
[5]: https://www.sqlite.org/changes.html

-- 
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
Status in sqlite3 package in Ubuntu:
  New

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/

  Update: The test in the paste above also works successfully with
  libsqlite3-0 3.25.3-2.

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