neutron

DBReferenceError in create_ha_port_and_bind：Cannot add or update a child row

Bug #1522268 reported by LIU Yulong
This bug report is a duplicate of:  Bug #1499647: test_ha_router fails intermittently. Edit Remove
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
neutron
New
Undecided
Unassigned

Bug Description

Use rally to test l3 all:
NeutronNetworks.create_and_delete_floating_ips
NeutronNetworks.create_and_delete_routers
NeutronNetworks.create_and_list_floating_ips
NeutronNetworks.create_and_list_routers
NeutronNetworks.create_and_update_routers

The below error comes,
Log:
"DBReferenceError: (IntegrityError) (1452, 'Cannot add or update a child row: a foreign key constraint fails (`neutron`.`ha_router_agent_port_bindings`, CONSTRAINT `ha_router_agent_port_bindings_ibfk_2` FOREIGN KEY (`router_id`) REFERENCES `routers` (`id`) ON DELETE CASCADE)') 'INSERT INTO ha_router_agent_port_bindings (port_id, router_id, l3_agent_id, state) VALUES (%s, %s, %s, %s)' ('f368c83f-40aa-45b4-89b5-d0ae6424ebb1', 'a1e4b69c-21a5-4bd4-b5e8-7e7346b29d85', None, 'standby')\n"]

similar bugs:
https://bugs.launchpad.net/neutron/+bug/1385257
https://bugs.launchpad.net/neutron/+bug/1371696

So the L3HARouterAgentPortBinding may do the same thing.

LIU Yulong (dragon889)
summary: - DBReferenceError in create_ha_router_binding
+ DBReferenceError in create_ha_router_binding：Cannot add or update a
+ child row
Revision history for this message
LIU Yulong (dragon889) wrote : Re: DBReferenceError in create_ha_router_binding：Cannot add or update a child row

Some error log similar here:
https://bugs.launchpad.net/neutron/+bug/1499647 -- https://review.openstack.org/#/c/227821/

LIU Yulong (dragon889)
summary: - DBReferenceError in create_ha_router_binding：Cannot add or update a
- child row
+ DBReferenceError in create_ha_port_and_bind：Cannot add or update a child
+ row
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.