← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1385257] [NEW] Scary "Cannot add or update a child row: a foreign key constraint fails" ERROR

 

Public bug reported:

I see similar message in non dvr setups as mentioned in #1371696.

http://logstash.openstack.org/#eyJzZWFyY2giOiJtZXNzYWdlOlwiQ2Fubm90IGFkZCBvciB1cGRhdGUgYSBjaGlsZCByb3dcXDogYSBmb3JlaWduIGtleSBjb25zdHJhaW50IGZhaWxzXCIiLCJmaWVsZHMiOltdLCJvZmZzZXQiOjAsInRpbWVmcmFtZSI6IjYwNDgwMCIsImdyYXBobW9kZSI6ImNvdW50IiwidGltZSI6eyJ1c2VyX2ludGVydmFsIjowfSwic3RhbXAiOjE0MTQxNTQ0NTgzNDcsIm1vZGUiOiIiLCJhbmFseXplX2ZpZWxkIjoiIn0=


2014-10-24 12:01:09.517 1409 TRACE neutron.agent.l3_agent RemoteError: Remote error: DBReferenceError (IntegrityError) (1452, 'Cannot add or update a child row: a foreign key constraint fails (`neutron`.`routerl3agentbindings`, CONSTRAINT `routerl3agentbindings_ibfk_2` FOREIGN KEY (`router_id`) REFERENCES `routers` (`id`) ON DELETE CASCADE)') 'INSERT INTO routerl3agentbindings (router_id, l3_agent_id) VALUES (%s, %s)' ('63e69dd6-2964-42a2-ad67-9e7048c044e8', '24b9520c-0543-4968-9b2c-f4e86c5d26e4')

The ERROR most likely harmless, but very annoying when searching for a real issue.
Only a shorter message with lower error level (DEBUG)  should be logged on a concurrent delete event.

** Affects: neutron
     Importance: Undecided
         Status: New

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

Title:
  Scary "Cannot add or update a child row: a foreign key constraint
  fails" ERROR

Status in OpenStack Neutron (virtual network service):
  New

Bug description:
  I see similar message in non dvr setups as mentioned in #1371696.

  http://logstash.openstack.org/#eyJzZWFyY2giOiJtZXNzYWdlOlwiQ2Fubm90IGFkZCBvciB1cGRhdGUgYSBjaGlsZCByb3dcXDogYSBmb3JlaWduIGtleSBjb25zdHJhaW50IGZhaWxzXCIiLCJmaWVsZHMiOltdLCJvZmZzZXQiOjAsInRpbWVmcmFtZSI6IjYwNDgwMCIsImdyYXBobW9kZSI6ImNvdW50IiwidGltZSI6eyJ1c2VyX2ludGVydmFsIjowfSwic3RhbXAiOjE0MTQxNTQ0NTgzNDcsIm1vZGUiOiIiLCJhbmFseXplX2ZpZWxkIjoiIn0=

  
  2014-10-24 12:01:09.517 1409 TRACE neutron.agent.l3_agent RemoteError: Remote error: DBReferenceError (IntegrityError) (1452, 'Cannot add or update a child row: a foreign key constraint fails (`neutron`.`routerl3agentbindings`, CONSTRAINT `routerl3agentbindings_ibfk_2` FOREIGN KEY (`router_id`) REFERENCES `routers` (`id`) ON DELETE CASCADE)') 'INSERT INTO routerl3agentbindings (router_id, l3_agent_id) VALUES (%s, %s)' ('63e69dd6-2964-42a2-ad67-9e7048c044e8', '24b9520c-0543-4968-9b2c-f4e86c5d26e4')

  The ERROR most likely harmless, but very annoying when searching for a real issue.
  Only a shorter message with lower error level (DEBUG)  should be logged on a concurrent delete event.

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


Follow ups

References