yahoo-eng-team team mailing list archive

[Carl Baldwin <carl.baldwin@xxxxxx>]

Public bug reported:

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/

** Affects: neutron
     Importance: Medium
     Assignee: Armando Migliaccio (armando-migliaccio)
         Status: New


** Tags: l3-dvr-backlog

** Changed in: neutron
   Importance: Undecided => Medium

** Changed in: neutron
     Assignee: (unassigned) => Armando Migliaccio (armando-migliaccio)

** Tags added: l3-dvr-backlog

-- 
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):
  New

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