Got same errors.
Solved by commenting out below lines of code under this
(d6a12e637e28_neutron_fwaas_v2_0.py) python file:
op.create_primary_key(
'pk_firewall_group_port_associations_v2',
'firewall_group_port_associations_v2',
['firewall_group_id', 'port_id'])
For anyone new encountering same issue, follow tracebacks thoroughly and
you shall see something like this:
File "/usr/lib/python3/dist-
packages/neutron_fwaas/db/migration/alembic_migrations/versions/newton/expand/d6a12e637e28_neutron_fwaas_v2_0.py",
line 107, in upgrade
to know your similar file name. CD into that dir and vim it, and comment
out above lines of code that says op.create_primary_key ...
Once, you make those changes, you also need to delete this table
(firewall_policies_v2) which is under neutron database. However, you
won't be able to delete it as it has foreign key connected to some other
tables. Solution to this is to rather delete entire neutron database
(DROP database neutron).
After that, re-create neutron database and just apply:
su -s /bin/sh -c "neutron-db-manage --config-file /etc/neutron/neutron.conf \
--config-file /etc/neutron/plugins/ml2/ml2_conf.ini upgrade head" neutron
to populate Neutron database.
Hope this helps.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1863257
Title:
Neutron db sync fails
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/neutron-fwaas/+bug/1863257/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs