fwaas_v2 - unable to associate port with firewall (PXC strict mode)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Ubuntu Cloud Archive |
Fix Released
|
Medium
|
Unassigned | ||
Rocky |
Won't Fix
|
Medium
|
Unassigned | ||
Stein |
Fix Released
|
Medium
|
Unassigned | ||
Train |
Fix Released
|
Medium
|
Unassigned | ||
neutron |
In Progress
|
Undecided
|
James Page | ||
neutron-fwaas (Ubuntu) |
Fix Released
|
Medium
|
Unassigned | ||
Disco |
Won't Fix
|
Medium
|
Unassigned | ||
Eoan |
Fix Released
|
Medium
|
Unassigned |
Bug Description
[Impact]
Unable to associate ports with a firewall under FWaaS v2
[Test Case]
Deploy OpenStack (stein or Later) using Charms
Create firewall policy, apply to router - failure as unable to associate port with policy in underlying DB
[Regression Potential]
Medium; the proposed fix has not been accepted upstream as yet (discussion ongoing due to change of database migrations).
[Original Bug Report]
Impacts both Stein and Rocky (although rocky does not enable v2 just yet).
542 a9761fa91247400
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
2019-06-07 10:07:50.937 30837 ERROR oslo_db.
ProblemType: Bug
DistroRelease: Ubuntu 18.04
Package: neutron-server 2:14.0.
ProcVersionSign
Uname: Linux 4.15.0-51-generic x86_64
ApportVersion: 2.20.9-0ubuntu7.6
Architecture: amd64
CrashDB:
{
}
Date: Fri Jun 7 10:22:18 2019
Ec2AMI: ami-000005f0
Ec2AMIManifest: FIXME
Ec2Availability
Ec2InstanceType: m1.blue
Ec2Kernel: unavailable
Ec2Ramdisk: unavailable
PackageArchitec
ProcEnviron:
TERM=screen-
PATH=(custom, no user)
XDG_RUNTIME_
LANG=C.UTF-8
SHELL=/bin/bash
SourcePackage: neutron
UpgradeStatus: No upgrade log present (probably fresh install)
mtime.conffile.
tags: | added: py3 |
Changed in neutron: | |
assignee: | Sahid Orentino (sahid-ferdjaoui) → James Page (james-page) |
Changed in neutron-fwaas (Ubuntu Eoan): | |
status: | New → Triaged |
Changed in neutron-fwaas (Ubuntu Disco): | |
status: | New → Triaged |
importance: | Undecided → Medium |
Changed in neutron-fwaas (Ubuntu Eoan): | |
importance: | Undecided → Medium |
Changed in neutron: | |
assignee: | James Page (james-page) → Sahid Orentino (sahid-ferdjaoui) |
Changed in neutron: | |
assignee: | Sahid Orentino (sahid-ferdjaoui) → James Page (james-page) |
Changed in neutron: | |
assignee: | James Page (james-page) → Sahid Orentino (sahid-ferdjaoui) |
Changed in neutron: | |
assignee: | Sahid Orentino (sahid-ferdjaoui) → James Page (james-page) |
Changed in cloud-archive: | |
status: | Triaged → Fix Committed |
description: | updated |
tags: | removed: verification-needed verification-needed-disco |
tags: | added: db fwaas |
Changed in cloud-archive: | |
status: | Fix Released → Fix Committed |
Changed in cloud-archive: | |
status: | Fix Committed → Fix Released |
Missing primary keys for firewall_ group_port_ associations_ v2 and firewall_ policy_ rule_associatio ns_v2. The workaround is to change the mode used [0].
juju config percona-cluster pxc-strict- mode=PERMISSIVE
[0] https:/ /bugs.launchpad .net/ubuntu/ +source/ octavia/ +bug/1826875/ comments/ 3