yahoo-eng-team team mailing list archive

Thread
Date

[Bug 1522268] [NEW] DBReferenceError in create_ha_router_binding：Cannot add or update a child row

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: LIU Yulong <yulong@xxxxxxxxxxxxx>
Date: Thu, 03 Dec 2015 05:28:02 -0000
Reply-to: Bug 1522268 <1522268@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

Public bug reported:

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.

** Affects: neutron
     Importance: Undecided
         Status: New

** Summary changed:

- DBReferenceError in create_ha_router_binding
+ DBReferenceError in create_ha_router_binding：Cannot add or update a child row

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1522268

Title:
  DBReferenceError in create_ha_router_binding：Cannot add or update a
  child row

Status in neutron:
  New

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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1522268/+subscriptions