When trying to delete a heat stack because neutron-server couldn't update firewall groups, the stack trace found in the logs is:
2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager Traceback (most recent call last): 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager File "/usr/lib/python3/dist-packages/neutron_lib/callbacks/manager.py", line 197, in _notify_loop 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager callback(resource, event, trigger, **kwargs) 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager File "/usr/lib/python3/dist-packages/neutron_fwaas/services/firewall/fwaas_plugin_v2.py", line 307, in handle_update_port 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager {'firewall_group': {'ports': port_ids}}) 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager File "/usr/lib/python3/dist-packages/oslo_log/helpers.py", line 67, in wrapper 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager return method(*args, **kwargs) 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager File "/usr/lib/python3/dist-packages/neutron_fwaas/services/firewall/fwaas_plugin_v2.py", line 369, in update_firewall_group 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager return self.driver.update_firewall_group(context, id, firewall_group) 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager File "/usr/lib/python3/dist-packages/neutron_fwaas/services/firewall/service_drivers/driver_api.py", line 211, in update_firewall_group 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager context, id, firewall_group_delta) 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager File "/usr/lib/python3/dist-packages/neutron_fwaas/db/firewall/v2/firewall_db_v2.py", line 981, in update_firewall_group 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager self._delete_ports_in_firewall_group(context, id) 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager File "/usr/lib/python3/dist-packages/neutron_fwaas/db/firewall/v2/firewall_db_v2.py", line 832, in _delete_ports_in_firewall_group 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager firewall_group_id=firewall_group_id).delete() [...] 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager File "/usr/lib/python3/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager raise errorclass(errno, errval) 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager oslo_db.exception.DBError: (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': '8da85bcb-1e1d-4d5a-b508-25c1d4c85d50'}] (Background on this error at: http://sqlalche.me/e/2j85) 2020-02-11 13:14:21.356 1998511 ERROR neutron_lib.callbacks.manager
When trying to delete a heat stack because neutron-server couldn't update firewall groups, the stack trace found in the logs is:
2020-02-11 13:14:21.356 1998511 ERROR neutron_ lib.callbacks. manager Traceback (most recent call last): lib.callbacks. manager File "/usr/lib/ python3/ dist-packages/ neutron_ lib/callbacks/ manager. py", line 197, in _notify_loop lib.callbacks. manager callback(resource, event, trigger, **kwargs) lib.callbacks. manager File "/usr/lib/ python3/ dist-packages/ neutron_ fwaas/services/ firewall/ fwaas_plugin_ v2.py", line 307, in handle_update_port lib.callbacks. manager {'firewall_group': {'ports': port_ids}}) lib.callbacks. manager File "/usr/lib/ python3/ dist-packages/ oslo_log/ helpers. py", line 67, in wrapper lib.callbacks. manager return method(*args, **kwargs) lib.callbacks. manager File "/usr/lib/ python3/ dist-packages/ neutron_ fwaas/services/ firewall/ fwaas_plugin_ v2.py", line 369, in update_ firewall_ group lib.callbacks. manager return self.driver. update_ firewall_ group(context, id, firewall_group) lib.callbacks. manager File "/usr/lib/ python3/ dist-packages/ neutron_ fwaas/services/ firewall/ service_ drivers/ driver_ api.py" , line 211, in update_ firewall_ group lib.callbacks. manager context, id, firewall_ group_delta) lib.callbacks. manager File "/usr/lib/ python3/ dist-packages/ neutron_ fwaas/db/ firewall/ v2/firewall_ db_v2.py" , line 981, in update_ firewall_ group lib.callbacks. manager self._delete_ ports_in_ firewall_ group(context, id) lib.callbacks. manager File "/usr/lib/ python3/ dist-packages/ neutron_ fwaas/db/ firewall/ v2/firewall_ db_v2.py" , line 832, in _delete_ ports_in_ firewall_ group lib.callbacks. manager firewall_ group_id= firewall_ group_id) .delete( ) lib.callbacks. manager File "/usr/lib/ python3/ dist-packages/ pymysql/ err.py" , line 107, in raise_mysql_ exception lib.callbacks. manager raise errorclass(errno, errval) lib.callbacks. manager oslo_db. exception. DBError: (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': '8da85bcb- 1e1d-4d5a- b508-25c1d4c85d 50'}] (Background on this error at: http:// sqlalche. me/e/2j85) lib.callbacks. manager
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
[...]
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_