API tools faq
paste
Guest User

Untitled

a guest
Feb 21st, 2016
157
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.62 KB | None | 0 0
raw download clone embed print report
  1. 2016-02-21 16:57:16.555 ERROR oslo_messaging.rpc.dispatcher [req-c50307ba-097a-43f8-a9c5-30e8ae91657d None None] Exception during message handling: (pymysql.err.IntegrityError) (145
  2. 2, u'Cannot add or update a child row: a foreign key constraint fails (`neutron`.`ha_router_agent_port_bindings`, CONSTRAINT `ha_router_agent_port_bindings_ibfk_2` FOREIGN KEY (`rou
  3. ter_id`) REFERENCES `routers` (`id`) ON DELETE CASCADE)') [SQL: u'INSERT INTO ha_router_agent_port_bindings (port_id, router_id, l3_agent_id, state) VALUES (%s, %s, %s, %s)'] [param
  4. eters: ('07af9440-4675-427f-941c-ea959ebd6b67', u'5af2ad9e-bad8-4c20-b919-8cc2e2115b6a', None, 'standby')]
  5. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher Traceback (most recent call last):
  6. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 142, in _dispatch_and_reply
  7. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher executor_callback))
  8. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 186, in _dispatch
  9. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher executor_callback)
  10. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 129, in _do_dispatch
  11. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher result = func(ctxt, **new_args)
  12. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 147, in wrapper
  13. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher ectxt.value = e.inner_exc
  14. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 204, in __exit__
  15. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher six.reraise(self.type_, self.value, self.tb)
  16. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 137, in wrapper
  17. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher return f(*args, **kwargs)
  18. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/opt/openstack/neutron/neutron/api/rpc/handlers/l3_rpc.py", line 96, in sync_routers
  19. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher self.l3plugin.auto_schedule_routers(context, host, router_ids)
  20. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/opt/openstack/neutron/neutron/db/l3_agentschedulers_db.py", line 496, in auto_schedule_routers
  21. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher self, context, host, router_ids)
  22. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/opt/openstack/neutron/neutron/scheduler/l3_agent_scheduler.py", line 142, in auto_schedule_routers
  23. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher plugin, context, l3_agent)
  24. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/opt/openstack/neutron/neutron/scheduler/l3_agent_scheduler.py", line 296, in _schedule_ha_routers_to_additional_
  25. agent
  26. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher agent)
  27. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/opt/openstack/neutron/neutron/scheduler/l3_agent_scheduler.py", line 263, in create_ha_port_and_bind
  28. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher ha_network.network.id, tenant_id)
  29. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/opt/openstack/neutron/neutron/db/l3_hamode_db.py", line 351, in add_ha_port
  30. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher deletion, content)
  31. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/opt/openstack/neutron/neutron/db/common_db_mixin.py", line 65, in safe_creation
  32. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher 'exc': e})
  33. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 204, in __exit__
  34. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher six.reraise(self.type_, self.value, self.tb)
  35. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/opt/openstack/neutron/neutron/db/common_db_mixin.py", line 57, in safe_creation
  36. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher value = create_bindings(obj['id'])
  37. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/opt/openstack/neutron/neutron/db/l3_hamode_db.py", line 324, in _create_ha_port_binding
  38. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher context.session.add(portbinding)
  39. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 502, in __exit__
  40. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher self.rollback()
  41. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
  42. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher compat.reraise(exc_type, exc_value, exc_tb)
  43. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 499, in __exit__
  44. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher self.commit()
  45. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 392, in commit
  46. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher self._prepare_impl()
  47. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 372, in _prepare_impl
  48. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher self.session.flush()
  49. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2027, in flush
  50. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher self._flush(objects)
  51. 016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2145, in _flush
  52. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher transaction.rollback(_capture_exception=True)
  53. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
  54. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher compat.reraise(exc_type, exc_value, exc_tb)
  55. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2109, in _flush
  56. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher flush_context.execute()
  57. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute
  58. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher rec.execute(self)
  59. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute
  60. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher uow
  61. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj
  62. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher mapper, table, insert)
  63. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 752, in _emit_insert_statements
  64. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher execute(statement, multiparams)
  65. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
  66. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher return meth(self, multiparams, params)
  67. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
  68. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher return connection._execute_clauseelement(self, multiparams, params)
  69. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
  70. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher compiled_sql, distilled_params
  71. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
  72. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher context)
  73. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
  74. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher util.raise_from_cause(newraise, exc_info)
  75. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
  76. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher reraise(type(exception), exception, tb=exc_tb)
  77. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
  78. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher context)
  79. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
  80. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher cursor.execute(statement, parameters)
  81. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 146, in execute
  82. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher result = self._query(query)
  83. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 296, in _query
  84. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher conn.query(q)
  85. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 781, in query
  86. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  87. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 942, in _read_query_result
  88. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher result.read()
  89. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1138, in read
  90. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher first_packet = self.connection._read_packet()
  91. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 906, in _read_packet
  92. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher packet.check_error()
  93. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 367, in check_error
  94. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher err.raise_mysql_exception(self._data)
  95. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 120, in raise_mysql_exception
  96. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher _check_mysql_exception(errinfo)
  97. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 112, in _check_mysql_exception
  98. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher raise errorclass(errno, error value)
  99. 2016-02-21 16:57:16.555 TRACE oslo_messaging.rpc.dispatcher DBReferenceError: (pymysql.err.IntegrityError) (1452, u'Cannot add or update a child row: a foreign key constraint fails (`neutron`.`ha_router_agent_port_bindings`, CONSTRAINT `ha_router_agent_port_bindings_ibfk_2` FOREIGN KEY (`router_id`) REFERENCES `routers` (`id`) ON DELETE CASCADE)') [SQL: u'INSERT INTO ha_router_agent_port_bindings (port_id, router_id, l3_agent_id, state) VALUES (%s, %s, %s, %s)'] [parameters: ('07af9440-4675-427f-941c-ea959ebd6b67', u'5af2ad9e-bad8-4c20-b919-8cc2e2115b6a', None, 'standby')]
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!