SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
neutron |
Fix Released
|
Medium
|
Jakub Libosvar | ||
Juno |
Fix Released
|
Medium
|
Jakub Libosvar | ||
neutron (Ubuntu) |
Fix Released
|
Medium
|
Unassigned |
Bug Description
On a fresh installation of Juno, it seems that that the database is not being populated correctly on a fresh install. This is the output of the log (I also demonstrated the DB had no tables to begin with):
MariaDB [(none)]> use neutron
Database changed
MariaDB [neutron]> show tables;
Empty set (0.00 sec)
MariaDB [neutron]> quit
Bye
root@vm-1:~# neutron-db-manage --config-file /etc/neutron/
INFO [alembic.migration] Context impl MySQLImpl.
INFO [alembic.migration] Will assume non-transactional DDL.
Current revision for mysql:/
root@vm-1:~# neutron-db-manage --config-file /etc/neutron/
INFO [alembic.migration] Context impl MySQLImpl.
INFO [alembic.migration] Will assume non-transactional DDL.
INFO [alembic.migration] Running upgrade None -> havana, havana_initial
INFO [alembic.migration] Running upgrade havana -> e197124d4b9, add unique constraint to members
INFO [alembic.migration] Running upgrade e197124d4b9 -> 1fcfc149aca4, Add a unique constraint on (agent_type, host) columns to prevent a race condition when an agent entry is 'upserted'.
INFO [alembic.migration] Running upgrade 1fcfc149aca4 -> 50e86cb2637a, nsx_mappings
INFO [alembic.migration] Running upgrade 50e86cb2637a -> 1421183d533f, NSX DHCP/metadata support
INFO [alembic.migration] Running upgrade 1421183d533f -> 3d3cb89d84ee, nsx_switch_mappings
INFO [alembic.migration] Running upgrade 3d3cb89d84ee -> 4ca36cfc898c, nsx_router_mappings
INFO [alembic.migration] Running upgrade 4ca36cfc898c -> 27cc183af192, ml2_vnic_type
INFO [alembic.migration] Running upgrade 27cc183af192 -> 50d5ba354c23, ml2 binding:vif_details
INFO [alembic.migration] Running upgrade 50d5ba354c23 -> 157a5d299379, ml2 binding:profile
INFO [alembic.migration] Running upgrade 157a5d299379 -> 3d2585038b95, VMware NSX rebranding
INFO [alembic.migration] Running upgrade 3d2585038b95 -> abc88c33f74f, lb stats
INFO [alembic.migration] Running upgrade abc88c33f74f -> 1b2580001654, nsx_sec_
INFO [alembic.migration] Running upgrade 1b2580001654 -> e766b19a3bb, nuage_initial
INFO [alembic.migration] Running upgrade e766b19a3bb -> 2eeaf963a447, floatingip_status
INFO [alembic.migration] Running upgrade 2eeaf963a447 -> 492a106273f8, Brocade ML2 Mech. Driver
INFO [alembic.migration] Running upgrade 492a106273f8 -> 24c7ea5160d7, Cisco CSR VPNaaS
INFO [alembic.migration] Running upgrade 24c7ea5160d7 -> 81c553f3776c, bsn_consistency
INFO [alembic.migration] Running upgrade 81c553f3776c -> 117643811bca, nec: delete old ofc mapping tables
INFO [alembic.migration] Running upgrade 117643811bca -> 19180cf98af6, nsx_gw_devices
INFO [alembic.migration] Running upgrade 19180cf98af6 -> 33dd0a9fa487, embrane_
INFO [alembic.migration] Running upgrade 33dd0a9fa487 -> 2447ad0e9585, Add IPv6 Subnet properties
INFO [alembic.migration] Running upgrade 2447ad0e9585 -> 538732fa21e1, NEC Rename quantum_id to neutron_id
INFO [alembic.migration] Running upgrade 538732fa21e1 -> 5ac1c354a051, n1kv segment allocs for cisco n1kv plugin
INFO [alembic.migration] Running upgrade 5ac1c354a051 -> icehouse, icehouse
INFO [alembic.migration] Running upgrade icehouse -> 54f7549a0e5f, set_not_
INFO [alembic.migration] Running upgrade 54f7549a0e5f -> 1e5dd1d09b22, set_not_
INFO [alembic.migration] Running upgrade 1e5dd1d09b22 -> b65aa907aec, set_length_
INFO [alembic.migration] Running upgrade b65aa907aec -> 33c3db036fe4, set_length_
INFO [alembic.migration] Running upgrade 33c3db036fe4 -> 4eca4a84f08a, Remove ML2 Cisco Credentials DB
INFO [alembic.migration] Running upgrade 4eca4a84f08a -> d06e871c0d5, set_admin_
INFO [alembic.migration] Running upgrade d06e871c0d5 -> 6be312499f9, set_not_
INFO [alembic.migration] Running upgrade 6be312499f9 -> 1b837a7125a9, Cisco APIC Mechanism Driver
INFO [alembic.migration] Running upgrade 1b837a7125a9 -> 10cd28e692e9, nuage_extraroute
INFO [alembic.migration] Running upgrade 10cd28e692e9 -> 2db5203cb7a9, nuage_floatingip
INFO [alembic.migration] Running upgrade 2db5203cb7a9 -> 5446f2a45467, set_server_default
INFO [alembic.migration] Running upgrade 5446f2a45467 -> db_healing, Include all tables and make migrations unconditional.
INFO [alembic.migration] Context impl MySQLImpl.
INFO [alembic.migration] Will assume non-transactional DDL.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [neutron.
INFO [alembic.migration] Running upgrade db_healing -> 3927f7f7c456, L3 extension distributed mode
INFO [alembic.migration] Running upgrade 3927f7f7c456 -> 2026156eab2f, L2 models to support DVR
INFO [alembic.migration] Running upgrade 2026156eab2f -> 37f322991f59, removing_
INFO [alembic.migration] Running upgrade 37f322991f59 -> 31d7f831a591, add constraint for routerid
Traceback (most recent call last):
File "/usr/bin/
sys.
File "/usr/lib/
CONF.
File "/usr/lib/
do_
File "/usr/lib/
getattr(
File "/usr/lib/
script.
File "/usr/lib/
util.
File "/usr/lib/
module = load_module_
File "/usr/lib/
mod = imp.load_
File "/usr/lib/
run_
File "/usr/lib/
context.
File "<string>", line 7, in run_migrations
File "/usr/lib/
self.
File "/usr/lib/
change(**kw)
File "/usr/lib/
cols=
File "<string>", line 7, in create_primary_key
File "/usr/lib/
schema)
File "/usr/lib/
self.
File "/usr/lib/
conn.
File "/usr/lib/
return meth(self, multiparams, params)
File "/usr/lib/
return connection.
File "/usr/lib/
compiled
File "/usr/lib/
context)
File "/usr/lib/
util.
File "/usr/lib/
reraise(
File "/usr/lib/
context)
File "/usr/lib/
cursor.
File "/usr/lib/
self.
File "/usr/lib/
raise errorclass, errorvalue
sqlalchemy.
summary: |
- Openstack Neutron Database error. + Openstack Neutron Database error on package install |
summary: |
- Openstack Neutron Database error on package install + Openstack Neutron Database error on filling database |
Changed in neutron: | |
assignee: | nobody → Ann Kamyshnikova (akamyshnikova) |
Changed in neutron: | |
status: | Invalid → Incomplete |
Changed in neutron: | |
status: | Incomplete → Confirmed |
Changed in neutron: | |
status: | Confirmed → Invalid |
status: | Invalid → Opinion |
summary: |
- Openstack Neutron Database error on filling database + SQL error during alembic.migration when populating Neutron database on + MariaDB 10.0 |
Changed in neutron: | |
assignee: | Lars Kellogg-Stedman (larsks) → Jakub Libosvar (libosvar) |
Changed in neutron: | |
milestone: | none → kilo-1 |
importance: | Undecided → Medium |
tags: | added: juno-backport-potential |
tags: | removed: in-stable-juno juno-backport-potential |
tags: | removed: clean database error install networking neutron |
Changed in neutron: | |
status: | Fix Committed → Fix Released |
Changed in neutron (Ubuntu): | |
importance: | Undecided → Medium |
status: | Confirmed → Fix Released |
Changed in neutron: | |
milestone: | kilo-1 → 2015.1.0 |
Checked this on MySQL and MariaDB. In both cases this error does not appear. paste.openstack .org/show/ 123532/.
Logs of running with MariaDB - http://
I used Juno and master neutron code also, both works fine.