Public bug reported:
If auto_scheduler the router, during race between HA router creating and
deleting, the neutron server may treat the HA router as 'no scheduled', then it
will create a new HA port binding with the router(id) which is deleted
concurrently, and
then foreign key constraint error(Integrity Error) raised.
Exception:
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)' ('xxxxxxxxxxx', 'xxxxxxxxxxxxxxxxxxx', None, 'standby')
For more information:
https://bugs.launchpad.net/neutron/+bug/1523780/comments/7
** Affects: neutron
Importance: Undecided
Status: New
** Summary changed:
- DBReferenceError rasied during race between HA router creating and deleting
+ DBReferenceError rasied during race between HA router deleting and L3 agent
sync router info
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1533460
Title:
DBReferenceError rasied during race between HA router deleting and L3
agent sync router info
Status in neutron:
New
Bug description:
If auto_scheduler the router, during race between HA router creating and
deleting, the neutron server may treat the HA router as 'no scheduled', then it
will create a new HA port binding with the router(id) which is deleted
concurrently, and
then foreign key constraint error(Integrity Error) raised.
Exception:
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)' ('xxxxxxxxxxx', 'xxxxxxxxxxxxxxxxxxx', None, 'standby')
For more information:
https://bugs.launchpad.net/neutron/+bug/1523780/comments/7
To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1533460/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
