[Expired for neutron because there has been no activity for 60 days.]

** Changed in: neutron
       Status: Incomplete => Expired

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

Title:
  DBIntegrityError when inserting into routersl3agentbindings

Status in OpenStack Neutron (virtual network service):
  Expired

Bug description:
  Traceback:
   TRACE oslo.messaging.rpc.dispatcher Traceback (most recent call last):
   TRACE oslo.messaging.rpc.dispatcher   File 
"/usr/local/lib/python2.7/dist-packages/oslo/messaging/rpc/dispatcher.py", line 
134, in _dispatch_and_reply
   TRACE oslo.messaging.rpc.dispatcher     incoming.message))
   TRACE oslo.messaging.rpc.dispatcher   File 
"/usr/local/lib/python2.7/dist-packages/oslo/messaging/rpc/dispatcher.py", line 
177, in _dispatch
   TRACE oslo.messaging.rpc.dispatcher     return self._do_dispatch(endpoint, 
method, ctxt, args)
   TRACE oslo.messaging.rpc.dispatcher   File 
"/usr/local/lib/python2.7/dist-packages/oslo/messaging/rpc/dispatcher.py", line 
123, in _do_dispatch
   TRACE oslo.messaging.rpc.dispatcher     result = getattr(endpoint, 
method)(ctxt, **new_args)
   TRACE oslo.messaging.rpc.dispatcher   File 
"/opt/stack/new/neutron/neutron/db/l3_rpc_base.py", line 55, in sync_routers
   TRACE oslo.messaging.rpc.dispatcher     
l3plugin.auto_schedule_routers(context, host, router_ids)
   TRACE oslo.messaging.rpc.dispatcher   File 
"/opt/stack/new/neutron/neutron/db/l3_agentschedulers_db.py", line 270, in 
auto_schedule_routers
   TRACE oslo.messaging.rpc.dispatcher     self, context, host, router_ids)
   TRACE oslo.messaging.rpc.dispatcher   File 
"/opt/stack/new/neutron/neutron/scheduler/l3_agent_scheduler.py", line 114, in 
auto_schedule_routers
   TRACE oslo.messaging.rpc.dispatcher     self.bind_router(context, router_id, 
l3_agent)
   TRACE oslo.messaging.rpc.dispatcher   File 
"/opt/stack/new/neutron/neutron/scheduler/l3_agent_scheduler.py", line 156, in 
bind_router
   TRACE oslo.messaging.rpc.dispatcher     'agent_id': chosen_agent.id})
   TRACE oslo.messaging.rpc.dispatcher   File 
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 447, in 
__exit__
   TRACE oslo.messaging.rpc.dispatcher     self.rollback()
   TRACE oslo.messaging.rpc.dispatcher   File 
"/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 58, in 
__exit__
   TRACE oslo.messaging.rpc.dispatcher     compat.reraise(exc_type, exc_value, 
exc_tb)
   TRACE oslo.messaging.rpc.dispatcher   File 
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 444, in 
__exit__
   TRACE oslo.messaging.rpc.dispatcher     self.commit()
   TRACE oslo.messaging.rpc.dispatcher   File 
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 354, in 
commit
   TRACE oslo.messaging.rpc.dispatcher     self._prepare_impl()
   TRACE oslo.messaging.rpc.dispatcher   File 
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 334, in 
_prepare_impl
   TRACE oslo.messaging.rpc.dispatcher     self.session.flush()
   TRACE oslo.messaging.rpc.dispatcher   File 
"/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line 
463, in _wrap
   TRACE oslo.messaging.rpc.dispatcher     raise exception.DBError(e)
   TRACE oslo.messaging.rpc.dispatcher DBError: (IntegrityError) insert or 
update on table "routerl3agentbindings" violates foreign key constraint 
"routerl3agentbindings_router_id_fkey"
   TRACE oslo.messaging.rpc.dispatcher DETAIL:  Key 
(router_id)=(5c70bab4-3176-4a93-ace0-653fdf48cf4c) is not present in table 
"routers".
   TRACE oslo.messaging.rpc.dispatcher  'INSERT INTO routerl3agentbindings (id, 
router_id, l3_agent_id) VALUES (%(id)s, %(router_id)s, %(l3_agent_id)s)' 
{'router_id': u'5c70bab4-3176-4a93-ace0-653fdf48cf4c', 'l3_agent_id': 
u'9fa2b62d-3a33-40ee-b502-89e615d9a852', 'id': 
'e8a59637-2525-4f31-92a4-9622c1d274fb'}

  Observed in the gate:
  
http://logs.openstack.org/44/106744/1/check/check-tempest-dsvm-neutron-pg-2/554a4b8/logs/screen-q-svc.txt.gz?level=TRACE#_2014-07-14_12_43_17_270

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

-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp

Reply via email to