yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

** Changed in: neutron
       Status: Fix Committed => Fix Released

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

Title:
  Cannot add or update a child row: a foreign key constraint fails
  ml2_dvr_port_bindings

Status in OpenStack Neutron (virtual network service):
  Fix Released

Bug description:
  We've hit this foreign key constraint error.  This is due to a sync
  message coming in from the L3 agent over RPC.  The message contains n
  update for  a port that has just been deleted.  This is just log noise
  because it all gets worked out quickly following the error.  The full
  trace is here [1].

  2014-09-18 21:22:39.735 29984 TRACE oslo.messaging.rpc.dispatcher
  DBReferenceError: (IntegrityError) (1452, 'Cannot add or update a
  child row: a foreign key constraint fails
  (`neutron`.`ml2_dvr_port_bindings`, CONSTRAINT
  `ml2_dvr_port_bindings_ibfk_1` FOREIGN KEY (`port_id`) REFERENCES
  `ports` (`id`) ON DELETE CASCADE)') 'INSERT INTO ml2_dvr_port_bindings
  (port_id, host, router_id, vif_type, vif_details, vnic_type, profile,
  cap_port_filter, driver, segment, status) VALUES (%s, %s, %s, %s, %s,
  %s, %s, %s, %s, %s, %s)' ('0fe7b532-343e-4ba0-83d9-c51b1c55f533',
  'devstack-trusty-hpcloud-b4-2246632',
  '45248fa2-4372-4ad9-8e60-afabe39c6f6a', 'unbound', '', 'normal', '',
  0, None, None, 'DOWN')

  [1] http://paste.openstack.org/show/113360/

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