yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

** Changed in: neutron
       Status: Fix Committed => Fix Released

** Changed in: neutron
    Milestone: None => havana-rc1

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

Title:
  Raise an exception if starting neutron-l3-agent without creating a
  router

Status in OpenStack Neutron (virtual network service):
  Fix Released

Bug description:
  Version : Havana
  OS : RHEL
  Running Neutron services  : neutron-server, neutron-openvswitch-agent, neutron-l3-agent 
  No routers being created, then the following exception will be raised.

  2013-09-16 08:51:32.820 23737 ERROR neutron.openstack.common.rpc.amqp [-] Exception during message handling
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp Traceback (most recent call last):
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.6/site-packages/neutron/openstack/common/rpc/amqp.py", line 438, in _process_data
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp     **args)
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.6/site-packages/neutron/common/rpc.py", line 44, in dispatch
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp     neutron_ctxt, version, method, namespace, **kwargs)
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.6/site-packages/neutron/openstack/common/rpc/dispatcher.py", line 172, in dispatch
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp     result = getattr(proxyobj, method)(ctxt, **kwargs)
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.6/site-packages/neutron/db/l3_rpc_base.py", line 54, in sync_routers
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp     l3plugin.auto_schedule_routers(context, host, router_ids)
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.6/site-packages/neutron/db/l3_agentschedulers_db.py", line 241, in auto_schedule_routers
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp     self, context, host, router_ids)
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.6/site-packages/neutron/scheduler/l3_agent_scheduler.py", line 113, in auto_schedule_routers
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp     context.session.add(binding)
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/session.py", line 449, in __exit__
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp     self.commit()
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/session.py", line 361, in commit
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp     self._prepare_impl()
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/session.py", line 340, in _prepare_impl
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp     self.session.flush()
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.6/site-packages/neutron/openstack/common/db/sqlalchemy/session.py", line 542, in _wrap
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp     raise exception.DBError(e)
  2013-09-16 08:51:32.820 23737 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_1` FOREIGN KEY (`router_id`) REFERENCES `routers` (`id`) ON DELETE CASCADE)') 'INSERT INTO routerl3agentbindings (id, router_id, l3_agent_id) VALUES (%s, %s, %s)' ('28570d41-e7ab-4ca5-bed5-922bfbc154fc', '', '0214005e-8876-4bb1-a3b5-68f629b6e987')
  2013-09-16 08:51:32.820 23737 TRACE neutron.openstack.common.rpc.amqp
                                                                                                                                                 

  The root cause is that the router_ids transferred is defined as [''],
  which is not None, but have an invalid empty value, the DB can't take
  this value in.

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