Public bug reported: In current neutron.tests.unit.objects.test_router.FloatingIPDbObjectTestCase.test_update_objects code path, all the field values are generated randomly by get_random_object_fields(). However in several cases, the actual object is required to fulfill Foreign Key requirement.
An example here is FloatingIP OVO. It updates router_id and fixed_port_id, but without actual objects we will see the following errors. oslo_db.exception.DBReferenceError: (sqlite3.IntegrityError) FOREIGN KEY constraint failed [SQL: u'UPDATE floatingips SET project_id=?, floating_ip_address=?, floating_network_id=?, floating_port_id=?, fixed_port_id=?, fixed_ip_address=?, router_id=?, last_known_router_id=?, status=? WHERE floatingips.id = ?'] [parameters: (u'082f1ab417', '10.81.171.5', '7290820a-186b-43d5-bdb6-b06390d62f96', '96a2689b-f31d-4660-9253-cb27d1d44ffc', '323da865-b33d- 48e9-b5c2-650cb7ead20f', '10.186.214.129', '0b093c10-5947-44b6-9c11-3484ef7565fc', 'fc9e158f-522f- 42b2-9ce4-49a88e22d535', u'DOWN', u'11d0ed9e-191a- 41b6-839b-107257559929')] Reference to more logs can be found in https://review.openstack.org/#/c/481972 ** Affects: neutron Importance: Undecided Assignee: Lujin Luo (luo-lujin) Status: New ** Changed in: neutron Assignee: (unassigned) => Lujin Luo (luo-lujin) ** Description changed: In current neutron.tests.unit.objects.test_router.FloatingIPDbObjectTestCase.test_update_objects - code path, all the field values are generated randomly. However in - several cases, the actual object is required to fulfill Foreign Key - requirement. + code path, all the field values are generated randomly by + get_random_object_fields(). However in several cases, the actual object + is required to fulfill Foreign Key requirement. An example here is FloatingIP OVO. It updates router_id and fixed_port_id, but without actual objects we will see the following errors. oslo_db.exception.DBReferenceError: (sqlite3.IntegrityError) FOREIGN KEY constraint failed [SQL: u'UPDATE floatingips SET project_id=?, floating_ip_address=?, floating_network_id=?, floating_port_id=?, fixed_port_id=?, fixed_ip_address=?, router_id=?, last_known_router_id=?, status=? WHERE floatingips.id = ?'] [parameters: (u'082f1ab417', '10.81.171.5', '7290820a-186b-43d5-bdb6-b06390d62f96', '96a2689b-f31d-4660-9253-cb27d1d44ffc', '323da865-b33d- 48e9-b5c2-650cb7ead20f', '10.186.214.129', '0b093c10-5947-44b6-9c11-3484ef7565fc', 'fc9e158f-522f- 42b2-9ce4-49a88e22d535', u'DOWN', u'11d0ed9e-191a- 41b6-839b-107257559929')] Reference to more logs can be found in https://review.openstack.org/#/c/481972 ** Summary changed: - Add specific values to random object fields + Add specific values to specific fields in get_random_object_fields() -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1705187 Title: Add specific values to specific fields in get_random_object_fields() Status in neutron: New Bug description: In current neutron.tests.unit.objects.test_router.FloatingIPDbObjectTestCase.test_update_objects code path, all the field values are generated randomly by get_random_object_fields(). However in several cases, the actual object is required to fulfill Foreign Key requirement. An example here is FloatingIP OVO. It updates router_id and fixed_port_id, but without actual objects we will see the following errors. oslo_db.exception.DBReferenceError: (sqlite3.IntegrityError) FOREIGN KEY constraint failed [SQL: u'UPDATE floatingips SET project_id=?, floating_ip_address=?, floating_network_id=?, floating_port_id=?, fixed_port_id=?, fixed_ip_address=?, router_id=?, last_known_router_id=?, status=? WHERE floatingips.id = ?'] [parameters: (u'082f1ab417', '10.81.171.5', '7290820a-186b- 43d5-bdb6-b06390d62f96', '96a2689b-f31d-4660-9253-cb27d1d44ffc', '323da865-b33d-48e9-b5c2-650cb7ead20f', '10.186.214.129', '0b093c10-5947-44b6-9c11-3484ef7565fc', 'fc9e158f-522f- 42b2-9ce4-49a88e22d535', u'DOWN', u'11d0ed9e-191a- 41b6-839b-107257559929')] Reference to more logs can be found in https://review.openstack.org/#/c/481972 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1705187/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp