[Bug 1807262] Re: stein unit tests fail with sqlalchemy.exc.NoSuchTableError: migration_tmp
OpenStack Infra
1807262 at bugs.launchpad.net
Mon Jan 21 22:12:08 UTC 2019
Reviewed: https://review.openstack.org/623564
Committed: https://git.openstack.org/cgit/openstack/sqlalchemy-migrate/commit/?id=231a4d2ae9f8496cfc8eea2e6bb8186a0dd602f9
Submitter: Zuul
Branch: master
commit 231a4d2ae9f8496cfc8eea2e6bb8186a0dd602f9
Author: Corey Bryant <corey.bryant at canonical.com>
Date: Fri Dec 7 13:49:20 2018 -0500
Use legacy_alter_table ON in sqlite recreate_table
Use "PRAGMA legacy_alter_table = ON" with sqlite >= 3.26 when
using "ALTER TABLE RENAME TO migration_tmp" to maintain legacy
behavior.
As of sqlite version 3.26, when a table is renamed using
"ALTER TABLE RENAME TO", REFERENCES clauses that refer to the
table will be updated. To maintain legacy (3.24 and earlier)
behavior, "PRAGMA legacy_alter_table" can be set to true and
"PRAGMA foreign_keys" can be set to false. [1]
[1] https://www.sqlite.org/src/info/ae9638e9c0ad0c36
Thanks to "László Böszörményi (GCS)" <gcs at debian.org> for
providing the code for this patch, which has since been
slightly modified.
Change-Id: I539988ab2ad6df6c8f423ecec15364ad8fcc7267
Closes-Bug: 1807262
** Changed in: sqlalchemy-migrate
Status: In Progress => Fix Released
--
You received this bug notification because you are a member of Ubuntu
OpenStack, which is subscribed to migrate in Ubuntu.
https://bugs.launchpad.net/bugs/1807262
Title:
stein unit tests fail with sqlalchemy.exc.NoSuchTableError:
migration_tmp
Status in sqlalchemy-migrate:
Fix Released
Status in cinder package in Ubuntu:
Fix Released
Status in migrate package in Ubuntu:
Fix Released
Status in nova package in Ubuntu:
Fix Released
Status in sqlite3 package in Ubuntu:
Invalid
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/sqlalchemy-migrate/+bug/1807262/+subscriptions
More information about the Ubuntu-openstack-bugs
mailing list