DBIntegrityError in check-tempest-devstack-vm-neutron-pg-isolated

[Akihiro Motoki]

In the gate job of check-tempest-devstack-vm-neutron-pg-isolated,

DBError: (IntegrityError) update or delete on table "networks" violates foreign key constraint "ports_network_id_fkey" on table "ports"
http://logs.openstack.org/28/52128/2/check/check-tempest-devstack-vm-neutron-pg-isolated/ba1064f/

I see several times in IntegrityError related to foreign key in PostgreSQL Neutron gate.

2013-10-17 06:00:46.339 1678 ERROR neutron.api.v2.resource [req-90f78223-9230-4c03-9a13-ab657765fe2a admin admin] delete failed
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource Traceback (most recent call last):
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource File "/opt/stack/new/neutron/neutron/api/v2/resource.py", line 84, in resource
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource result = method(request=request, **args)
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource File "/opt/stack/new/neutron/neutron/api/v2/base.py", line 432, in delete
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource obj_deleter(request.context, id, **kwargs)
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource File "/opt/stack/new/neutron/neutron/plugins/ml2/plugin.py", line 420, in delete_network
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource break
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 456, in __exit__
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource self.commit()
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 368, in commit
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource self._prepare_impl()
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 347, in _prepare_impl
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource self.session.flush()
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource File "/opt/stack/new/neutron/neutron/openstack/common/db/sqlalchemy/session.py", line 542, in _wrap
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource raise exception.DBError(e)
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource DBError: (IntegrityError) update or delete on table "networks" violates foreign key constraint "ports_network_id_fkey" on table "ports"
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource DETAIL: Key (id)=(c6028c2b-3c51-4b2c-a727-70956b9591a0) is still referenced from table "ports".
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource 'DELETE FROM networks WHERE networks.id = %(id)s' {'id': u'c6028c2b-3c51-4b2c-a727-70956b9591a0'}
2013-10-17 06:00:46.339 1678 TRACE neutron.api.v2.resource

[Akihiro Motoki (amotoki)]

Another log is:

http://logs.openstack.org/22/52122/1/gate/gate-tempest-devstack-vm-neutron-pg-isolated/b28daad/logs/screen-q-svc.txt.gz?level=TRACE#_2013-10-16_15_50_37_522

In this test we had another IntegrityError:
DBError: (IntegrityError) null value in column "network_id" violates not-null constraint
http://logs.openstack.org/22/52122/1/gate/gate-tempest-devstack-vm-neutron-pg-isolated/b28daad/logs/screen-q-svc.txt.gz?level=TRACE#_2013-10-16_15_48_09_004