542 a9761fa9124740028d0c1d70ff7aa542] DBAPIError exception wrapped from (pymysql.err.InternalError) (1105, 'Percona-XtraDB-Cluster prohibits use of DML command on a table (neutron.firewall_group_port_associations_v2) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER') [SQL: 'DELETE FROM firewall_group_port_associations_v2 WHERE firewall_group_port_associations_v2.firewall_group_id = %(firewall_group_id_1)s'] [parameters: {'firewall_group_id_1': '85a277d0-ebaf-4a5d-9d45-6a74b8f54372'}] (Background on this error at: http://sqlalche.me/e/2j85): pymysql.err.InternalError: (1105, 'Percona-XtraDB-Cluster prohibits use of DML command on a table (neutron.firewall_group_port_associations_v2) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER') 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last): 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters context) 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 509, in do_execute 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters) 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 165, in execute 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query) 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 321, in _query 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q) 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 860, in query 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered) 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1061, in _read_query_result 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters result.read() 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1349, in read 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet() 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1018, in _read_packet 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error() 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 384, in check_error 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data) 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errval) 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters pymysql.err.InternalError: (1105, 'Percona-XtraDB-Cluster prohibits use of DML command on a table (neutron.firewall_group_port_associations_v2) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER') 2019-06-07 10:07:50.937 30837 ERROR oslo_db.sqlalchemy.exc_filters
ProblemType: Bug DistroRelease: Ubuntu 18.04 Package: neutron-server 2:14.0.0-0ubuntu1.1~cloud0 [origin: Canonical] ProcVersionSignature: Ubuntu 4.15.0-51.55-generic 4.15.18 Uname: Linux 4.15.0-51-generic x86_64 ApportVersion: 2.20.9-0ubuntu7.6 Architecture: amd64 CrashDB: { "impl": "launchpad", "project": "cloud-archive", "bug_pattern_url": "http://people.canonical.com/~ubuntu-archive/bugpatterns/bugpatterns.xml", } Date: Fri Jun 7 10:22:18 2019 Ec2AMI: ami-000005f0 Ec2AMIManifest: FIXME Ec2AvailabilityZone: nova Ec2InstanceType: m1.blue Ec2Kernel: unavailable Ec2Ramdisk: unavailable PackageArchitecture: all ProcEnviron: TERM=screen-256color PATH=(custom, no user) XDG_RUNTIME_DIR=<set> LANG=C.UTF-8 SHELL=/bin/bash SourcePackage: neutron UpgradeStatus: No upgrade log present (probably fresh install) mtime.conffile..etc.default.neutron-server: 2019-06-07T09:50:57.855385
542 a9761fa91247400 28d0c1d70ff7aa5 42] DBAPIError exception wrapped from (pymysql. err.InternalErr or) (1105, 'Percona- XtraDB- Cluster prohibits use of DML command on a table (neutron. firewall_ group_port_ associations_ v2) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER') [SQL: 'DELETE FROM firewall_ group_port_ associations_ v2 WHERE firewall_ group_port_ associations_ v2.firewall_ group_id = %(firewall_ group_id_ 1)s'] [parameters: {'firewall_ group_id_ 1': '85a277d0- ebaf-4a5d- 9d45-6a74b8f543 72'}] (Background on this error at: http:// sqlalche. me/e/2j85): pymysql. err.InternalErr or: (1105, 'Percona- XtraDB- Cluster prohibits use of DML command on a table (neutron. firewall_ group_port_ associations_ v2) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER') sqlalchemy. exc_filters Traceback (most recent call last): sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ sqlalchemy/ engine/ base.py" , line 1193, in _execute_context sqlalchemy. exc_filters context) sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ sqlalchemy/ engine/ default. py", line 509, in do_execute sqlalchemy. exc_filters cursor. execute( statement, parameters) sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ pymysql/ cursors. py", line 165, in execute sqlalchemy. exc_filters result = self._query(query) sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ pymysql/ cursors. py", line 321, in _query sqlalchemy. exc_filters conn.query(q) sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ pymysql/ connections. py", line 860, in query sqlalchemy. exc_filters self._affected_rows = self._read_ query_result( unbuffered= unbuffered) sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ pymysql/ connections. py", line 1061, in _read_query_result sqlalchemy. exc_filters result.read() sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ pymysql/ connections. py", line 1349, in read sqlalchemy. exc_filters first_packet = self.connection ._read_ packet( ) sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ pymysql/ connections. py", line 1018, in _read_packet sqlalchemy. exc_filters packet. check_error( ) sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ pymysql/ connections. py", line 384, in check_error sqlalchemy. exc_filters err.raise_ mysql_exception (self._ data) sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ pymysql/ err.py" , line 107, in raise_mysql_ exception sqlalchemy. exc_filters raise errorclass(errno, errval) sqlalchemy. exc_filters pymysql. err.InternalErr or: (1105, 'Percona- XtraDB- Cluster prohibits use of DML command on a table (neutron. firewall_ group_port_ associations_ v2) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER') sqlalchemy. exc_filters
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 0-0ubuntu1. 1~cloud0 [origin: Canonical] ature: Ubuntu 4.15.0- 51.55-generic 4.15.18
"impl" : "launchpad",
"project" : "cloud-archive",
"bug_ pattern_ url": "http:// people. canonical. com/~ubuntu- archive/ bugpatterns/ bugpatterns. xml", Zone: nova ture: all 256color DIR=<set> .etc.default. neutron- server: 2019-06- 07T09:50: 57.855385
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.