)]}'
{"ironic/db/sqlalchemy/api.py":[{"author":{"_account_id":19258,"name":"lifen","email":"lovelyc.lifen@huawei.com"},"change_message_id":"842e830d709f30879e51bfd6829983ed48aee580","unresolved":false,"context_lines":[{"line_number":352,"context_line":""},{"line_number":353,"context_line":"            port_query \u003d model_query(models.Port)"},{"line_number":354,"context_line":"            port_query \u003d add_port_filter_by_node(port_query, node_id)"},{"line_number":355,"context_line":"            port_query.delete()"},{"line_number":356,"context_line":""},{"line_number":357,"context_line":"            portgroup_query \u003d model_query(models.Portgroup)"},{"line_number":358,"context_line":"            portgroup_query \u003d add_portgroup_filter_by_node(portgroup_query,"}],"source_content_type":"text/x-python","patch_set":1,"id":"dae33548_d9924e4b","line":355,"range":{"start_line":355,"start_character":23,"end_line":355,"end_character":29},"updated":"2016-02-19 06:53:43.000000000","message":"pls check. delete port and portgroup in one session will cause the node to be locked. log in gaussdb:\ngaussdb 19462  CONTEXT:  SQL statement \"SELECT 1 FROM ONLY \"PUBLIC\".\"PORTS\" x WHERE $1 OPERATOR(PG_CATALOG.\u003d) \"PORTGROUP_ID\" FOR SHARE OF x\"\ngaussdb 19462  LOG:  the system is trying to lock transaction 259658 (postgres.c:7612)\ngaussdb 19462  CONTEXT:  SQL statement \"SELECT 1 FROM ONLY \"PUBLIC\".\"PORTS\" x WHERE $1 OPERATOR(PG_CATALOG.\u003d) \"PORTGROUP_ID\" FOR SHARE OF x\"","commit_id":"1a9fcc97633ba79934e87eec95a090c7a03f298d"}]}