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

[Christian Ehrhardt ]

Oh yeah sqlite uses special repository software - thanks :-/
But there is https://github.com/mackyle/sqlite/commits/master

I wrote a build and test script that worked against 3.24 and 3.26 from
git confirming the results.

Kicking that in git bisect to hopefully be able to pick up some insight
later on.

# git bisect start
# git bisect good version-3.24.0
# git bisect bad version-3.26.0
# git bisect run ~/bin/buildsqlite3.sh

The first commit built fine and tested as good, that seems ok'ish.
Walking away for now ...

$ cat #~/bin/buildsqlite3.sh
#!/bin/sh
set -ux
# See http://www.wtfpl.net/txt/copying for license details
# Creates a minimal manifest and manifest.uuid file so sqlite (and fossil) can build
testdir="/root/cinder-14.0.0~b1~git2018111617.4529b193d"
basedir=$(pwd)

# special bullshit for Fossil versioning system compat
git rev-parse --git-dir >/dev/null || exit 1
echo $(git log -1 --format=format:%H) > manifest.uuid
echo C $(cat manifest.uuid) > manifest
git log -1 --format=format:%ci%n | sed 's/ [-+].*$//;s/ /T/;s/^/D /' >> manifest

# get temp build dir
bdir=$(mktemp -d)
cd "${bdir}"

"${basedir}/configure" || exit 125
make -j || exit 125
make -j sqlite3.c || exit 125
make install || exit 125
# something did not install correctly
ls -laF /usr/local/lib/libsqlite3* || exit 125

# Test
cd "${testdir}"
export LD_LIBRARY_PATH=/usr/local/lib
pkgos-dh_auto_test --no-py2 "cinder.tests.unit.api.contrib.test_volume_type_encryption.VolumeTypeEncryptionTest.test_create_volume_exists"
rc=$?
unset LD_LIBRARY_PATH

# cleanup
# do not by accident test against older libs
rm -f /usr/local/lib/libsqlite3*
cd "${basedir}"
rm -rf "${bdir}"
git clean -f -x

# deliver actual test RC
exit ${rc};

-- 
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