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

[Christian Ehrhardt ]

git bisect start
# good: [cbb6e4f7de0115395269860fed18d56beb7ac2bb] Version 3.24.0
git bisect good cbb6e4f7de0115395269860fed18d56beb7ac2bb
# bad: [d4f098763eb4fd12a99497340e2f589b37234676] Version 3.26.0
git bisect bad d4f098763eb4fd12a99497340e2f589b37234676
# good: [bf92c08976ad16818be09a6941995bfbf43858f0] Add the "atrc" test program to the Makefiles.  Fix a typo in the instructions in the header comment of the atrc program.
git bisect good bf92c08976ad16818be09a6941995bfbf43858f0
# good: [ab747c198137c2890b16c2e28afa0d447bcfe8a2] Minor simplification: In OP_ParseSchema, read the p1 register once.
git bisect good ab747c198137c2890b16c2e28afa0d447bcfe8a2
# good: [43172f4b080b5f9f8563b8df351dc742afe21bb0] Eponymous virtual tables appear to exist in all schemas. This is an alternative and improved fix to the eponymous virtual table in trigger problem that was previously addressed by checkin [1fa74930ab56171e].
git bisect good 43172f4b080b5f9f8563b8df351dc742afe21bb0
# bad: [e504cfa1878e1d3253e6ff03b33156db2c99c931] Improvements to the CSV virtual table.
git bisect bad e504cfa1878e1d3253e6ff03b33156db2c99c931
# bad: [910531f62a723fec548be99fa7dd71888d07d5e7] Merge fixes from trunk.
git bisect bad 910531f62a723fec548be99fa7dd71888d07d5e7
# good: [fba76ed87c26c84fb14277efd80ac774533bc92a] Merge the permutations fix from trunk.
git bisect good fba76ed87c26c84fb14277efd80ac774533bc92a
# good: [6436da628906b028a2e15c273ff03f7984310111] Improved documentation for SQLITE_DBCONFIG_DEFENSIVE.  Add a NEVER() macro on an unreachable branch.
git bisect good 6436da628906b028a2e15c273ff03f7984310111
# good: [eb689e572223191847e3ed3140902d0d309d04d4] Fix for ticket [787fa716be3a7f650cac]
git bisect good eb689e572223191847e3ed3140902d0d309d04d4
# bad: [3cab37c2f2261ccca632a1843b8baeccdecd110d] Fix invalid use of unprotected sqlite3_value objects in the sqldiff utility, when using the --changeset option.
git bisect bad 3cab37c2f2261ccca632a1843b8baeccdecd110d
# bad: [2defce45c5670e0258374eeb2e293fcf6f82bddd] When a table is renamed using "ALTER TABLE RENAME TO", update any REFERENCES clauses that refer to the table, unless "PRAGMA legacy_alter_table" is true and "PRAGMA foreign_keys" is set to false (i.e. so that when "PRAGMA legacy_alter_table" is set behaviour is still compatible with versions 3.24 and earlier).
git bisect bad 2defce45c5670e0258374eeb2e293fcf6f82bddd
# first bad commit: [2defce45c5670e0258374eeb2e293fcf6f82bddd] When a table is renamed using "ALTER TABLE RENAME TO", update any REFERENCES clauses that refer to the table, unless "PRAGMA legacy_alter_table" is true and "PRAGMA foreign_keys" is set to false (i.e. so that when "PRAGMA legacy_alter_table" is set behaviour is still compatible with versions 3.24 and earlier).

=>
https://github.com/mackyle/sqlite/commit/2defce45c5670e0258374eeb2e293fcf6f82bddd

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