← Back to team overview

yahoo-eng-team team mailing list archive

  1. yahoo-eng-team team
  2. Mailing list archive
  3. Message #17279

[Bug 1341765] [NEW] DBIntegrityError when inserting into routersl3agentbindings

  Thread Previous • Date Previous • • Thread Next 
Public bug reported:

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

** Affects: neutron
     Importance: High
         Status: New


** Tags: db gate-failure l3-ipam-dhcp

-- 
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):
  New

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

Follow ups

References

  Thread Previous • Date Previous • • Thread Next