API tools faq
paste
Advertisement
ioggstream

heat_alarm_stack_update_sql

ioggstream
Oct 10th, 2017
501
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.07 KB | None | 0 0
raw download clone embed print report
  1. # o stack resource list shift-coll
  2. +---------------------------+-------------------------------------------------------------------------------------+--------------------------------------------------------+-----------------+----------------------+
  3. | resource_name | physical_resource_id | resource_type | resource_status | updated_time |
  4. +---------------------------+-------------------------------------------------------------------------------------+--------------------------------------------------------+-----------------+----------------------+
  5. | lb_floating_ip | a3451042-1568-4c71-bfa6-a0ebdba5d6fb | OS::Neutron::FloatingIP | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  6. | openshift_masters | 01e453ff-475f-4e4b-854e-b27f3969d577 | OS::Heat::ResourceGroup | UPDATE_COMPLETE | 2017-10-05T10:52:53Z |
  7. | openshift_infra_nodes | 2d2fc4f1-4fa5-4ac3-a134-9dfe383fb086 | OS::Heat::ResourceGroup | UPDATE_COMPLETE | 2017-10-05T10:52:53Z |
  8. | fixed_subnet | 8ca8d4a4-6919-45d5-8501-a1bb1fac285d | OS::Neutron::Subnet | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  9. | bastion_floating_ip | e0e2b677-1726-4750-b3f3-3cbecf1df84c | OS::Neutron::FloatingIP | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  10. | ipfailover | ecf278a8-1ba5-4cd3-9e6c-3e664993ebf5 | OOShift::IPFailover | UPDATE_COMPLETE | 2017-10-05T10:52:20Z |
  11. | bastion_host | 422a1432-b97e-46e5-9e01-0e283c82c320 | file:///home/shift/openshift-on-openstack/bastion.yaml | UPDATE_COMPLETE | 2017-10-05T10:52:23Z |
  12. | infra_security_group | 9973118b-1036-4fc8-a762-2f5b443bee45 | OS::Neutron::SecurityGroup | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  13. | bastion_port | 752fa379-b234-4482-87ff-a8f8f97f7610 | OS::Neutron::Port | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  14. | cpu_alarm_high | 74f19f1e-1349-4cf5-b4af-787bcc787b26 | OS::Aodh::GnocchiAggregationByResourcesAlarm | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  15. | master_security_group | b7ee4346-7664-4491-b4e3-e7b6c3577027 | OS::Neutron::SecurityGroup | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  16. | node_security_group | 92abe441-0446-4ed3-b15b-d87857f92afc | OS::Neutron::SecurityGroup | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  17. | ipfailover_dns_wildcard | 70cfe268-d723-407c-ba4c-c8af66317448 | OOShift::DNSRecord | UPDATE_COMPLETE | 2017-10-05T10:52:53Z |
  18. | ansible_keys | ansible_keys_b3b9371e-3c1c-4c4c-8534-747741bfe9ae | OS::Nova::KeyPair | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  19. | common_cloud_config | 1ce5715a-280d-4a9c-af84-b4cf765faa82 | OS::Heat::CloudConfig | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  20. | common_config | d4207832-c804-422c-8647-8be09b4b9582 | OS::Heat::MultipartMime | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  21. | infra_server_group | 2e73f672-1756-4aac-9aa2-af3eb6645c29 | OS::Nova::ServerGroup | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  22. | lb_dns | 916b6a9d-7b1e-470d-a91c-14f7ce76f659 | OOShift::DNSRecord | UPDATE_COMPLETE | 2017-10-05T10:52:53Z |
  23. | registry_volume | bb551eda-6526-44fb-bd43-550139f24570 | OOShift::RegistryVolume | UPDATE_COMPLETE | 2017-10-05T10:52:06Z |
  24. | master_server_group | a8aa97f8-85a2-4b65-9d0e-d0d21ba96db9 | OS::Nova::ServerGroup | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  25. | scale_up_policy | 4034ed665ce942c69a4dddf1511f0b8e | OS::Heat::ScalingPolicy | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  26. | openshift_nodes | 3aef195b-1338-4e24-8de1-c8f721a794be | OS::Heat::AutoScalingGroup | UPDATE_COMPLETE | 2017-10-05T10:54:00Z |
  27. | node_server_group | 5dcf6658-6c3c-46e0-9167-0b360fb531df | OS::Nova::ServerGroup | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  28. | fixed_network | e5e7466c-dd9b-40b8-a053-e3ae770f5b90 | OS::Neutron::Net | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  29. | cpu_alarm_low | 943f29c8-e5d8-49c1-b56a-a6bce7ffc98c | OS::Aodh::GnocchiAggregationByResourcesAlarm | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  30. | cluster_subnet | d892d58b-cee4-45d8-be1f-ce1bc4f9b457 | OS::Neutron::Subnet | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  31. | loadbalancer | 8a15a0c0-8f55-43c6-ade3-34565e901b7f | OOShift::LoadBalancer | UPDATE_COMPLETE | 2017-10-05T10:53:37Z |
  32. | external_router | a9605b0c-d622-434c-9eeb-1c9d05dc1e15 | OS::Neutron::Router | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  33. | cluster_network | 6b8306fa-500a-4f4b-b315-f3d0c49d42d7 | OS::Neutron::Net | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  34. | scale_down_policy | 848d7206ce67482caefd434c698ef3fe | OS::Heat::ScalingPolicy | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  35. | external_router_interface | a9605b0c-d622-434c-9eeb-1c9d05dc1e15:subnet_id=8ca8d4a4-6919-45d5-8501-a1bb1fac285d | OS::Neutron::RouterInterface | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  36. | bastion_security_group | 5c086546-596e-4e11-b18d-605a477623ee | OS::Neutron::SecurityGroup | CREATE_COMPLETE | 2017-09-30T18:43:04Z |
  37. +---------------------------+-------------------------------------------------------------------------------------+--------------------------------------------------------+-----------------+----------------------+
  38.  
  39. # o stack resource list 3aef195b-1338-4e24-8de1-c8f721a794be
  40. +---------------+--------------------------------------+-----------------------------------------------------+-----------------+----------------------+
  41. | resource_name | physical_resource_id | resource_type | resource_status | updated_time |
  42. +---------------+--------------------------------------+-----------------------------------------------------+-----------------+----------------------+
  43. | ljz5ijdkhba2 | f17b454b-67e5-4b58-bd4a-8c70a1c3cf4e | file:///home/shift/openshift-on-openstack/node.yaml | UPDATE_COMPLETE | 2017-10-05T11:25:51Z |
  44. | up6a7atak4u3 | ae03ee05-c2df-447b-8cb7-f8ba9b1a816a | file:///home/shift/openshift-on-openstack/node.yaml | UPDATE_COMPLETE | 2017-10-05T11:25:51Z |
  45. | m4euriveslt5 | a28e96e7-7208-48f5-babe-ec0c79a5ffc6 | file:///home/shift/openshift-on-openstack/node.yaml | UPDATE_COMPLETE | 2017-10-05T11:25:51Z |
  46. | 75foan3wqp6a | 6b3a61e1-abe7-4423-82b9-f647341dd67c | file:///home/shift/openshift-on-openstack/node.yaml | UPDATE_COMPLETE | 2017-10-05T11:25:51Z |
  47. | quwd7umlstjx | 556e3009-6403-40ae-8399-1e714632af63 | file:///home/shift/openshift-on-openstack/node.yaml | UPDATE_COMPLETE | 2017-10-05T11:25:51Z |
  48. +---------------+--------------------------------------+-----------------------------------------------------+-----------------+----------------------+
  49.  
  50.  
  51. ## Logs
  52.  
  53. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.379 218927 ERROR heat.engine.resources.aws.autoscaling.autoscaling_group [req-34122fce-5ffd-4fef-b0f4-a77b358224f4 - - - - -] Error in performing scaling adjustment forgroup openshift_
  54. nodes.
  55. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.406 218927 ERROR heat.engine.resources.openstack.heat.scaling_policy [req-34122fce-5ffd-4fef-b0f4-a77b358224f4 - - - - -] Error in performing scaling adjustment with scale_up_policy al
  56. arm for group openshift_nodes.
  57. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service [req-34122fce-5ffd-4fef-b0f4-a77b358224f4 - - - - -] Unhandled error in asynchronous task
  58. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service Traceback (most recent call last):
  59. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service File "/usr/lib/python2.7/site-packages/heat/engine/service.py", line 134, in log_exceptions
  60. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service gt.wait()
  61. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service File "/usr/lib/python2.7/site-packages/eventlet/greenthread.py", line 175, in wait
  62. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service return self._exit_event.wait()
  63. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service File "/usr/lib/python2.7/site-packages/eventlet/event.py", line 125, in wait
  64. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service current.throw(*self._exc)
  65. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service File "/usr/lib/python2.7/site-packages/eventlet/greenthread.py", line 214, in main
  66. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service result = function(*args, **kwargs)
  67. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service File "/usr/lib/python2.7/site-packages/heat/engine/service.py", line 125, in _start_with_trace
  68. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service return func(*args, **kwargs)
  69. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service File "/usr/lib/python2.7/site-packages/heat/engine/service.py", line 1808, in _resource_signal
  70. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service needs_metadata_updates = rsrc.signal(details, need_check)
  71. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service File "/usr/lib/python2.7/site-packages/heat/engine/resource.py", line 2170, in signal
  72. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service self._handle_signal(details)
  73. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service File "/usr/lib/python2.7/site-packages/heat/engine/resource.py", line 2153, in _handle_signal
  74. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service raise failure
  75. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service ResourceFailure: MessagingTimeout: resources.scale_up_policy: Timed out waiting for a reply to message ID 99d91e43e7cd42649da64e9dbeeac618
  76. /var/log/heat/heat-engine.log:2017-10-09 15:35:29.427 218927 ERROR heat.engine.service
  77. /var/log/heat/heat-engine.log:2017-10-09 15:35:30.713 218921 WARNING heat.engine.service [req-c74b9d25-244a-4a0f-8418-12f8b59ba963 6b642fcc1d0640159984ad3d7577527b 89765874f07b47bab7bfcd225796ab59 - - -] Access denied to resource host
  78. /var/log/heat/heat-engine.log:2017-10-09 15:35:42.903 218917 ERROR oslo_messaging.rpc.server [req-db8f3f33-42cb-4936-9658-fb16ca1f5876 - f1bf9e2730c44e9d918d4a9c1e499b23 - - -] Exception during message handling
  79.  
  80.  
  81. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server [req-f3d45936-bfae-4379-93c7-e8cad3c7a03c - - - - -] Exception during message handling
  82. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server Traceback (most recent call last):
  83. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/server.py", line 133, in _process_incoming
  84. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server res = self.dispatcher.dispatch(message)
  85. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 150, in dispatch
  86. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server return self._do_dispatch(endpoint, method, ctxt, args)
  87. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 121, in _do_dispatch
  88. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server result = func(ctxt, **new_args)
  89. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/osprofiler/profiler.py", line 154, in wrapper
  90. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server return f(*args, **kwargs)
  91. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/heat/common/context.py", line 424, in wrapped
  92. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server return func(self, ctx, *args, **kwargs)
  93. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/heat/engine/service.py", line 981, in update_stack
  94. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server new_stack=updated_stack)
  95. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/osprofiler/profiler.py", line 154, in wrapper
  96. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server return f(*args, **kwargs)
  97. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/heat/engine/stack.py", line 1223, in converge_stack
  98. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server stack_id = self.store(exp_trvsl=previous_traversal)
  99. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/osprofiler/profiler.py", line 154, in wrapper
  100. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server return f(*args, **kwargs)
  101. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/heat/engine/stack.py", line 637, in store
  102. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server self.context, self.id, s, exp_trvsl=exp_trvsl)
  103. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/heat/objects/stack.py", line 192, in select_and_update
  104. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server exp_trvsl=exp_trvsl)
  105. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/heat/db/api.py", line 218, in stack_update
  106. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server return IMPL.stack_update(context, stack_id, values, exp_trvsl=exp_trvsl)
  107. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 151, in wrapper
  108. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server ectxt.value = e.inner_exc
  109. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
  110. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server self.force_reraise()
  111. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
  112. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server six.reraise(self.type_, self.value, self.tb)
  113. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 139, in wrapper
  114. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server return f(*args, **kwargs)
  115. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/heat/db/sqlalchemy/api.py", line 647, in stack_update
  116. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server .update(values, synchronize_session=False))
  117. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 3176, in update
  118. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server update_op.exec_()
  119. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 1127, in exec_
  120. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server self._do_exec()
  121. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 1282, in _do_exec
  122. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server mapper=self.mapper)
  123. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 1046, in execute
  124. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server bind, close_with_result=True).execute(clause, params or {})
  125. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
  126. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server return meth(self, multiparams, params)
  127. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
  128. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server return connection._execute_clauseelement(self, multiparams, params)
  129. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
  130. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server compiled_sql, distilled_params
  131. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
  132. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server context)
  133. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
  134. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server util.raise_from_cause(newraise, exc_info)
  135. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
  136. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server reraise(type(exception), exception, tb=exc_tb)
  137. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
  138. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server context)
  139. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
  140. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server cursor.execute(statement, parameters)
  141. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 146, in execute
  142. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server result = self._query(query)
  143. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 296, in _query
  144. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server conn.query(q)
  145. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 781, in query
  146. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  147. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 942, in _read_query_result
  148. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server result.read()
  149. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1138, in read
  150. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server first_packet = self.connection._read_packet()
  151. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 906, in _read_packet
  152. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server packet.check_error()
  153. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 367, in check_error
  154. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server err.raise_mysql_exception(self._data)
  155. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 120, in raise_mysql_exception
  156. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server _check_mysql_exception(errinfo)
  157. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 112, in _check_mysql_exception
  158. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server raise errorclass(errno, errorvalue)
  159. 2017-10-09 16:05:41.044 218936 ERROR oslo_messaging.rpc.server DBReferenceError: (pymysql.err.IntegrityError) (1452, u'Cannot add or update a child row: a foreign key constraint fails (`heat`.`stack`, CONSTRAINT `stack_ibfk_1` FOREIGN KEY (`raw_template_id`) REFERENCES `raw_template` (`id`))') [SQL: u'UPDATE stack SET action=%s, status=%s, status_reason=%s, name=%s, raw_template_id=%s, prev_raw_template_id=%s, username=%s, tenant=%s, user_creds_id=%s, owner_id=%s, parent_resource_name=%s, timeout=%s, disable_rollback=%s, stack_user_project_id=%s, backup=%s, nested_depth=%s, convergence=%s, current_traversal=%s, current_deps=%s, updated_at=%s WHERE stack.id = %s AND stack.current_traversal = %s'] [parameters: ('UPDATE', 'IN_PROGRESS', 'Stack UPDATE started', u'shift-coll-openshift_nodes-n7fczx35hnrp', 19229, 19136, None, u'f1bf9e2730c44e9d918d4a9c1e499b23', 1058, u'b3b9371e-3c1c-4c4c-8534-747741bfe9ae', u'openshift_nodes', None, 1, u'c16350b16453492bbfba08408ac934da', 0, 1, 1, '6306c6e7-1bc2-4692-9695-02d9c0e6c2dc', '{"edges": [[[42344, false], [42344, true]], [[41576, false], [41576, true]], [[42089, false], [42089, true]], [[41582, false], [41582, true]], [[41918, false], [41918, true]]]}', datetime.datetime(2017, 10, 9, 16, 5, 40, 996829), u'3aef195b-1338-4e24-8de1-c8f721a794be', u'e8357e8d-bc9c-4def-:
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!