Comment 1 for bug 1210664

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
2013-08-09 20:56:11.357 27802 ERROR neutron.openstack.common.rpc.amqp [-] Exception during message handling
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp Traceback (most recent call last):
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp File "/opt/stack/new/neutron/neutron/openstack/common/rpc/amqp.py", line 424, in _process_data
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp **args)
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp File "/opt/stack/new/neutron/neutron/common/rpc.py", line 44, in dispatch
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp neutron_ctxt, version, method, namespace, **kwargs)
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp File "/opt/stack/new/neutron/neutron/openstack/common/rpc/dispatcher.py", line 172, in dispatch
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp result = getattr(proxyobj, method)(ctxt, **kwargs)
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp File "/opt/stack/new/neutron/neutron/db/l3_rpc_base.py", line 47, in sync_routers
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp plugin.auto_schedule_routers(context, host, router_ids)
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp File "/opt/stack/new/neutron/neutron/db/agentschedulers_db.py", line 303, in auto_schedule_routers
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp self, context, host, router_ids)
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp File "/opt/stack/new/neutron/neutron/scheduler/l3_agent_scheduler.py", line 113, in auto_schedule_routers
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp context.session.add(binding)
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 456, in __exit__
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp self.commit()
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 368, in commit
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp self._prepare_impl()
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 347, in _prepare_impl
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp self.session.flush()
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp File "/opt/stack/new/neutron/neutron/openstack/common/db/sqlalchemy/session.py", line 542, in _wrap
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp raise exception.DBError(e)
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp DBError: (IntegrityError) (1452, 'Cannot add or update a child row: a foreign key constraint fails (`ovs_neutron`.`routerl3agentbindings`, CONSTRAINT `routerl3agentbindings_ibfk_2` FOREIGN KEY (`router_id`) REFERENCES `routers` (`id`) ON DELETE CASCADE)') 'INSERT INTO routerl3agentbindings (id, router_id, l3_agent_id) VALUES (%s, %s, %s)' ('881b6e28-282e-4c6f-b1c5-7ec2c6e428aa', 'e3e94782-14eb-4bc5-908c-4b1953d43cbe', '71ae6cbb-8f6a-44bf-90eb-9a62069f9970')
2013-08-09 20:56:11.357 27802 TRACE neutron.openstack.common.rpc.amqp
2013-08-09 20:56:11.360 27802 ERROR neutron.openstack.common.rpc.common [-] Returning exception (IntegrityError) (1452, 'Cannot add or update a child row: a foreign key constraint fails (`ovs_neutron`.`routerl3agentbindings`, CONSTRAINT `routerl3agentbindings_ibfk_2` FOREIGN KEY (`router_id`) REFERENCES `routers` (`id`) ON DELETE CASCADE)') 'INSERT INTO routerl3agentbindings (id, router_id, l3_agent_id) VALUES (%s, %s, %s)' ('881b6e28-282e-4c6f-b1c5-7ec2c6e428aa', 'e3e94782-14eb-4bc5-908c-4b1953d43cbe', '71ae6cbb-8f6a-44bf-90eb-9a62069f9970') to caller