Just shooting in the dark.
We recently merged a devstack change that creates the db by running migrations rather than letting the models autogenerate.
This means that if there's something wacky in migrations this could be the cuplrit, and you can blame me as the author of that patch.
Just shooting in the dark.
We recently merged a devstack change that creates the db by running migrations rather than letting the models autogenerate.
This means that if there's something wacky in migrations this could be the cuplrit, and you can blame me as the author of that patch.
I am suspicious because of this error i am seeing in: http:// logs.openstack. org/95/ 41195/1/ check/gate- tempest- devstack- vm-neutron/ 6718173/ logs/screen- q-svc.txt. gz
2013-08-09 20:56:11.341 27802 DEBUG neutron. openstack. common. rpc.amqp [-] unpacked context: {'user_id': None, 'roles': [u'admin'], 'tenant_id': None, 'is_admin': True, 'timestamp': u'2013-08-09 20:43:50.109330', 'project_id': None, 'read_deleted': u'no'} _safe_log /opt/stack/ new/neutron/ neutron/ openstack/ common/ rpc/common. py:276 openstack. common. rpc.amqp [-] Exception during message handling openstack. common. rpc.amqp Traceback (most recent call last): openstack. common. rpc.amqp File "/opt/stack/ new/neutron/ neutron/ openstack/ common/ rpc/amqp. py", line 424, in _process_data openstack. common. rpc.amqp **args) openstack. common. rpc.amqp File "/opt/stack/ new/neutron/ neutron/ common/ rpc.py" , line 44, in dispatch openstack. common. rpc.amqp neutron_ctxt, version, method, namespace, **kwargs) openstack. common. rpc.amqp File "/opt/stack/ new/neutron/ neutron/ openstack/ common/ rpc/dispatcher. py", line 172, in dispatch openstack. common. rpc.amqp result = getattr(proxyobj, method)(ctxt, **kwargs) openstack. common. rpc.amqp File "/opt/stack/ new/neutron/ neutron/ db/l3_rpc_ base.py" , line 47, in sync_routers openstack. common. rpc.amqp plugin. auto_schedule_ routers( context, host, router_ids) openstack. common. rpc.amqp File "/opt/stack/ new/neutron/ neutron/ db/agentschedul ers_db. py", line 303, in auto_schedule_ routers openstack. common. rpc.amqp self, context, host, router_ids) openstack. common. rpc.amqp File "/opt/stack/ new/neutron/ neutron/ scheduler/ l3_agent_ scheduler. py", line 113, in auto_schedule_ routers openstack. common. rpc.amqp context. session. add(binding) openstack. common. rpc.amqp File "/usr/local/ lib/python2. 7/dist- packages/ sqlalchemy/ orm/session. py", line 456, in __exit__ openstack. common. rpc.amqp self.commit() openstack. common. rpc.amqp File "/usr/local/ lib/python2. 7/dist- packages/ sqlalchemy/ orm/session. py", line 368, in commit openstack. common. rpc.amqp self._prepare_ impl() openstack. common. rpc.amqp File "/usr/local/ lib/python2. 7/dist- packages/ sqlalchemy/ orm/session. py", line 347, in _prepare_impl openstack. common. rpc.amqp self.session. flush() openstack. common. rpc.amqp File "/opt/stack/ new/neutron/ neutron/ openstack/ common/ db/sqlalchemy/ session. py", line 542, in _wrap openstack. common. rpc.amqp raise exception. DBError( e) openstack. common. rpc.amqp DBError: (IntegrityError) (1452, 'Cannot add or update a child row: a foreign key constraint fails (`ovs_neutron` .`routerl3agent bindings` , CONSTRAINT `routerl3agentb indings_ ibfk_2` FOREIGN KEY (`router_id`) REFERENCES `routers` (`id`) ON DELETE CASCADE)') 'INSERT INTO routerl3agentbi ndings (id, router_id, l3_agent_id) VALUES (%s, %s, %s)' ('881b6e28- 282e-4c6f- b1c5-7ec2c6e428 aa', 'e3e94782- 14eb-4bc5- 908c-4b1953d43c be', '71ae6cbb- 8f6a-44bf- 90eb-9a62069f99 70') openstack. common. rpc.amqp openstack. common. rpc.common [-] Returning exception (IntegrityError) (1452, 'Cannot add or update a child row: a foreign key constraint fails (`ovs_neutron` .`routerl3agent bindings` , CONSTRAINT `routerl3agentb indings_ ibfk_2` FOREIGN KEY (`router_id`) REFERENCES `routers` (`id`) ON DELETE CASCADE)') 'INSERT INTO routerl3agentbi ndings (id, router_id, l3_agent_id) VALUES (%s, %s, %s)' ('881b6e28- 282e-4c6f- b1c5-7ec2c6e428 aa', 'e3e94782- 14eb-4bc5- 908c-4b1953d43c be', '71ae6cbb- 8f6a-44bf- 90eb-9a62069f99 70') to caller
2013-08-09 20:56:11.357 27802 ERROR neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.357 27802 TRACE neutron.
2013-08-09 20:56:11.360 27802 ERROR neutron.