Murano migrations failed due to mysql driver was updated in devstack
Bug #1464271 reported by
Ekaterina Chernova
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Murano |
Fix Released
|
Critical
|
Kirill Zaitsev |
Bug Description
After fix https:/
murano migrations failed
Need to adopt this in murano
Changed in murano: | |
importance: | Undecided → High |
status: | New → Confirmed |
assignee: | nobody → Ekaterina Chernova (efedorova) |
milestone: | none → liberty-1 |
summary: |
- Murano migrations failed due to mysql driver was updated + Murano migrations failed due to mysql driver was updated in devstack |
Changed in murano: | |
assignee: | Ekaterina Chernova (efedorova) → Kirill Zaitsev (kzaitsev) |
Changed in murano: | |
status: | Fix Committed → Fix Released |
Changed in murano: | |
status: | Fix Released → Fix Committed |
Changed in murano: | |
status: | Fix Committed → Fix Released |
Changed in murano: | |
milestone: | liberty-1 → 1.0.0 |
Changed in murano: | |
milestone: | 1.0.0 → 1.0.1 |
To post a comment you must log in.
The problem is more complicated, that we expected
We do support SQLite migrations. that why we do have this function to support 'alter' in sqlite:
https:/ /github. com/openstack/ murano/ blob/master/ murano/ db/migration/ alembic_ migrations/ versions/ 004_change_ package_ desc_type. py#L39
After switching to pymysql, force ignoring of foreign keys in Mysql is not working, so it's not possible to drop the table in transform_table functions.
We can drop sqlite support and use alter in this migration.