易陆发现互联网技术论坛

 找回密码
 开始注册
查看: 2750|回复: 1
收起左侧

ERROR nova.context DBError: (pymysql.err.InternalError) 删除虚机报错

[复制链接]
发表于 2021-9-10 11:09:36 | 显示全部楼层 |阅读模式

马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。

您需要 登录 才可以下载或查看,没有账号?开始注册

x
2021-09-10 11:04:47.284 27 ERROR nova.context Traceback (most recent call last):
9 u% v; i; Q5 N) P' q2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/nova/context.py", line 438, in gather_result
; _  |3 t/ @; |- a$ c4 F8 r6 Y2021-09-10 11:04:47.284 27 ERROR nova.context     result = fn(cctxt, *args, **kwargs)
5 O' ~) Y0 C3 j# i7 G3 s9 s2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/nova/compute/multi_cell_list.py", line 243, in do_query
3 @/ J, \' X$ a3 c. z; b( l2021-09-10 11:04:47.284 27 ERROR nova.context     **kwargs)7 c) z8 l, G  l1 Q: n4 Y/ Z# t
2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/nova/compute/instance_list.py", line 82, in get_by_filters
* K, n9 M' {  F7 V# w* B4 e% @, }2021-09-10 11:04:47.284 27 ERROR nova.context     **kwargs)0 R) k' w" Y8 |+ e
2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/nova/db/api.py", line 802, in instance_get_all_by_filters_sort" v, t0 C+ o( {# K
2021-09-10 11:04:47.284 27 ERROR nova.context     sort_dirs=sort_dirs)6 Z. o6 P# ?) I* ?
2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 169, in wrapper
* K. E5 S, N: Q5 X2021-09-10 11:04:47.284 27 ERROR nova.context     return f(*args, **kwargs)
9 Q& _  {+ q; ~7 w8 c2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 270, in wrapped
. h* O5 N6 B" a$ }2021-09-10 11:04:47.284 27 ERROR nova.context     return f(context, *args, **kwargs)/ \8 B$ [+ |0 M
2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 2249, in instance_get_all_by_filters_sort' `& r  Q, S4 B! r5 I# w$ d  b
2021-09-10 11:04:47.284 27 ERROR nova.context     return _instances_fill_metadata(context, query_prefix.all(), manual_joins)
3 o  a" o; a: E3 t2 C# q9 q8 I3 O2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all2 A* j4 O6 N! t2 ~: F/ y- [
2021-09-10 11:04:47.284 27 ERROR nova.context     return list(self)& g+ `/ j4 j4 E6 R% R  X2 G7 E
2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
* W7 h: O3 M4 W' w9 c2021-09-10 11:04:47.284 27 ERROR nova.context     return self._execute_and_instances(context)9 u6 e3 Z& v( t4 ?- i, F
2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances! K+ B& D' l6 W" Y
2021-09-10 11:04:47.284 27 ERROR nova.context     result = conn.execute(querycontext.statement, self._params)
7 m8 X- n/ A5 V$ F; e# O! @2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute/ |2 \. r4 x8 v4 S+ ?; s6 Y
2021-09-10 11:04:47.284 27 ERROR nova.context     return meth(self, multiparams, params)
; @9 F) I# C* ^% d2 Z2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection5 ~8 v: E: ?' x3 R3 L
2021-09-10 11:04:47.284 27 ERROR nova.context     return connection._execute_clauseelement(self, multiparams, params)
4 ^4 x8 U: A# Q$ [6 P. m/ q2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
# [' i/ {3 @5 n2021-09-10 11:04:47.284 27 ERROR nova.context     compiled_sql, distilled_params+ z& K7 l! P* p9 I' l) V: l
2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context& V3 Z. i* ^4 |
2021-09-10 11:04:47.284 27 ERROR nova.context     context)2 @6 l9 k4 V0 A. k* Y6 t  V
2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1409, in _handle_dbapi_exception
$ a  w, W/ C6 V' E9 Y& l2021-09-10 11:04:47.284 27 ERROR nova.context     util.raise_from_cause(newraise, exc_info)& B' ]$ D' t) R# G9 c) G
2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause8 }0 a" W1 E* @1 y/ @1 b, E  A
2021-09-10 11:04:47.284 27 ERROR nova.context     reraise(type(exception), exception, tb=exc_tb, cause=cause)6 j! y; h. m/ G" m5 I
2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context9 r; _$ P8 J- T- S( ]( S6 B7 t* u
2021-09-10 11:04:47.284 27 ERROR nova.context     context)
" c% y( _+ O6 Y: @2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute. u0 ]% Q- ?. D; ~3 B# N
2021-09-10 11:04:47.284 27 ERROR nova.context     cursor.execute(statement, parameters)
2 W4 t" }5 |8 P/ C; D% g5 q) P2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
0 w5 s9 Q! O0 T. R  S+ h2021-09-10 11:04:47.284 27 ERROR nova.context     result = self._query(query)
/ h1 n  d6 @& o( h5 X8 A2 i2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
+ E# f% ]$ f* N9 ~) Q# \2021-09-10 11:04:47.284 27 ERROR nova.context     conn.query(q)
! Z8 g$ F) `4 d' S& e2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 516, in query
+ v: Z8 a! I; C  x* j0 e1 W0 ~& W2021-09-10 11:04:47.284 27 ERROR nova.context     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
9 j( b8 K: s2 p8 j2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 727, in _read_query_result4 `6 H3 y% T! L/ j7 N* ?
2021-09-10 11:04:47.284 27 ERROR nova.context     result.read()
! ]& v2 o, [: O! \# V# `: x2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1066, in read
( L: {( d; y/ E" c. R3 C1 t2021-09-10 11:04:47.284 27 ERROR nova.context     first_packet = self.connection._read_packet()+ [" Z; j0 z1 F$ \
2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 683, in _read_packet
+ F% z5 H3 e; h9 V' M4 ~0 m0 W) C4 V  r2021-09-10 11:04:47.284 27 ERROR nova.context     packet.check_error(). q  i8 m2 `4 \9 H0 p1 y# V8 q
2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error5 Z& H+ b! I- [. z
2021-09-10 11:04:47.284 27 ERROR nova.context     err.raise_mysql_exception(self._data)
3 j) P" j& @/ Z! I4 w2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception( }1 Y: R# }* o. K* B- t2 A/ X, v
2021-09-10 11:04:47.284 27 ERROR nova.context     raise errorclass(errno, errval)
: H+ Q; P. _; p4 s2 |2021-09-10 11:04:47.284 27 ERROR nova.context DBError: (pymysql.err.InternalError) (1054, u"Unknown column 'services_1.uuid' in 'field list'") [SQL: u'SELECT anon_1.instances_created_at AS anon_1_instances_created_at, anon_1.instances_updated_at AS anon_1_instances_updated_at, anon_1.instances_deleted_at AS anon_1_instances_deleted_at, anon_1.instances_deleted AS anon_1_instances_deleted, anon_1.instances_id AS anon_1_instances_id, anon_1.instances_user_id AS anon_1_instances_user_id, anon_1.instances_project_id AS anon_1_instances_project_id, anon_1.instances_image_ref AS anon_1_instances_image_ref, anon_1.instances_kernel_id AS anon_1_instances_kernel_id, anon_1.instances_ramdisk_id AS anon_1_instances_ramdisk_id, anon_1.instances_hostname AS anon_1_instances_hostname, anon_1.instances_launch_index AS anon_1_instances_launch_index, anon_1.instances_key_name AS anon_1_instances_key_name, anon_1.instances_key_data AS anon_1_instances_key_data, anon_1.instances_power_state AS anon_1_instances_power_state, anon_1.instances_vm_state AS anon_1_instances_vm_state, anon_1.instances_task_state AS anon_1_instances_task_state, anon_1.instances_memory_mb AS anon_1_instances_memory_mb, anon_1.instances_vcpus AS anon_1_instances_vcpus, anon_1.instances_root_gb AS anon_1_instances_root_gb, anon_1.instances_ephemeral_gb AS anon_1_instances_ephemeral_gb, anon_1.instances_ephemeral_key_uuid AS anon_1_instances_ephemeral_key_uuid, anon_1.instances_host AS anon_1_instances_host, anon_1.instances_node AS anon_1_instances_node, anon_1.instances_instance_type_id AS anon_1_instances_instance_type_id, anon_1.instances_user_data AS anon_1_instances_user_data, anon_1.instances_reservation_id AS anon_1_instances_reservation_id, anon_1.instances_launched_at AS anon_1_instances_launched_at, anon_1.instances_terminated_at AS anon_1_instances_terminated_at, anon_1.instances_availability_zone AS anon_1_instances_availability_zone, anon_1.instances_display_name AS anon_1_instances_display_name, anon_1.instances_display_description AS anon_1_instances_display_description, anon_1.instances_launched_on AS anon_1_instances_launched_on, anon_1.instances_locked AS anon_1_instances_locked, anon_1.instances_locked_by AS anon_1_instances_locked_by, anon_1.instances_os_type AS anon_1_instances_os_type, anon_1.instances_architecture AS anon_1_instances_architecture, anon_1.instances_vm_mode AS anon_1_instances_vm_mode, anon_1.instances_uuid AS anon_1_instances_uuid, anon_1.instances_root_device_name AS anon_1_instances_root_device_name, anon_1.instances_default_ephemeral_device AS anon_1_instances_default_ephemeral_device, anon_1.instances_default_swap_device AS anon_1_instances_default_swap_device, anon_1.instances_config_drive AS anon_1_instances_config_drive, anon_1.instances_access_ip_v4 AS anon_1_instances_access_ip_v4, anon_1.instances_access_ip_v6 AS anon_1_instances_access_ip_v6, anon_1.instances_auto_disk_config AS anon_1_instances_auto_disk_config, anon_1.instances_progress AS anon_1_instances_progress, anon_1.instances_shutdown_terminate AS anon_1_instances_shutdown_terminate, anon_1.instances_disable_terminate AS anon_1_instances_disable_terminate, anon_1.instances_cell_name AS anon_1_instances_cell_name, anon_1.instances_cleaned AS anon_1_instances_cleaned, services_1.created_at AS services_1_created_at, services_1.updated_at AS services_1_updated_at, services_1.deleted_at AS services_1_deleted_at, services_1.deleted AS services_1_deleted, services_1.id AS services_1_id, services_1.uuid AS services_1_uuid, services_1.host AS services_1_host, services_1.`binary` AS services_1_binary, services_1.topic AS services_1_topic, services_1.report_count AS services_1_report_count, services_1.disabled AS services_1_disabled, services_1.disabled_reason AS services_1_disabled_reason, services_1.last_seen_up AS services_1_last_seen_up, services_1.forced_down AS services_1_forced_down, services_1.version AS services_1_version, tags_1.resource_id AS tags_1_resource_id, tags_1.tag AS tags_1_tag, instance_info_caches_1.created_at AS instance_info_caches_1_created_at, instance_info_caches_1.updated_at AS instance_info_caches_1_updated_at, instance_info_caches_1.deleted_at AS instance_info_caches_1_deleted_at, instance_info_caches_1.deleted AS instance_info_caches_1_deleted, instance_info_caches_1.id AS instance_info_caches_1_id, instance_info_caches_1.network_info AS instance_info_caches_1_network_info, instance_info_caches_1.instance_uuid AS instance_info_caches_1_instance_uuid, security_groups_1.created_at AS security_groups_1_created_at, security_groups_1.updated_at AS security_groups_1_updated_at, security_groups_1.deleted_at AS security_groups_1_deleted_at, security_groups_1.deleted AS security_groups_1_deleted, security_groups_1.id AS security_groups_1_id, security_groups_1.name AS security_groups_1_name, security_groups_1.description AS security_groups_1_description, security_groups_1.user_id AS security_groups_1_user_id, security_groups_1.project_id AS security_groups_1_project_id, instance_extra_1.flavor AS instance_extra_1_flavor, instance_extra_1.created_at AS instance_extra_1_created_at, instance_extra_1.updated_at AS instance_extra_1_updated_at, instance_extra_1.deleted_at AS instance_extra_1_deleted_at, instance_extra_1.deleted AS instance_extra_1_deleted, instance_extra_1.id AS instance_extra_1_id, instance_extra_1.instance_uuid AS instance_extra_1_instance_uuid \nFROM (SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.hostname AS instances_hostname, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS instances_key_data, instances.power_state AS instances_power_state, instances.vm_state AS instances_vm_state, instances.task_state AS instances_task_state, instances.memory_mb AS instances_memory_mb, instances.vcpus AS instances_vcpus, instances.root_gb AS instances_root_gb, instances.ephemeral_gb AS instances_ephemeral_gb, instances.ephemeral_key_uuid AS instances_ephemeral_key_uuid, instances.host AS instances_host, instances.node AS instances_node, instances.instance_type_id AS instances_instance_type_id, instances.user_data AS instances_user_data, instances.reservation_id AS instances_reservation_id, instances.launched_at AS instances_launched_at, instances.terminated_at AS instances_terminated_at, instances.availability_zone AS instances_availability_zone, instances.display_name AS instances_display_name, instances.display_description AS instances_display_description, instances.launched_on AS instances_launched_on, instances.locked AS instances_locked, instances.locked_by AS instances_locked_by, instances.os_type AS instances_os_type, instances.architecture AS instances_architecture, instances.vm_mode AS instances_vm_mode, instances.uuid AS instances_uuid, instances.root_device_name AS instances_root_device_name, instances.default_ephemeral_device AS instances_default_ephemeral_device, instances.default_swap_device AS instances_default_swap_device, instances.config_drive AS instances_config_drive, instances.access_ip_v4 AS instances_access_ip_v4, instances.access_ip_v6 AS instances_access_ip_v6, instances.auto_disk_config AS instances_auto_disk_config, instances.progress AS instances_progress, instances.shutdown_terminate AS instances_shutdown_terminate, instances.disable_terminate AS instances_disable_terminate, instances.cell_name AS instances_cell_name, instances.cleaned AS instances_cleaned \nFROM instances \nWHERE instances.deleted = %(deleted_1)s AND (instances.vm_state != %(vm_state_1)s OR instances.vm_state IS NULL) ORDER BY instances.created_at DESC, instances.uuid ASC, instances.id DESC \n LIMIT %(param_1)s) AS anon_1 LEFT OUTER JOIN services AS services_1 ON services_1.host = anon_1.instances_host AND services_1.`binary` = %(binary_1)s AND anon_1.instances_deleted = %(deleted_2)s LEFT OUTER JOIN tags AS tags_1 ON tags_1.resource_id = anon_1.instances_uuid AND anon_1.instances_deleted = %(deleted_3)s LEFT OUTER JOIN instance_info_caches AS instance_info_caches_1 ON instance_info_caches_1.instance_uuid = anon_1.instances_uuid LEFT OUTER JOIN (security_group_instance_association AS security_group_instance_association_1 INNER JOIN security_groups AS security_groups_1 ON security_groups_1.id = security_group_instance_association_1.security_group_id AND security_group_instance_association_1.deleted = %(deleted_4)s AND security_groups_1.deleted = %(deleted_5)s) ON security_group_instance_association_1.instance_uuid = anon_1.instances_uuid AND anon_1.instances_deleted = %(deleted_6)s LEFT OUTER JOIN instance_extra AS instance_extra_1 ON instance_extra_1.instance_uuid = anon_1.instances_uuid ORDER BY anon_1.instances_created_at DESC, anon_1.instances_uuid ASC, anon_1.instances_id DESC'] [parameters: {u'vm_state_1': 'soft-delete', u'binary_1': 'nova-compute', u'deleted_3': 0, u'deleted_5': 0, u'deleted_4': 0, u'param_1': 21, u'deleted_2': 0, u'deleted_1': 0, u'deleted_6': 0}] (Background on this error at: http://sqlalche.me/e/2j85)' Y& E+ c1 H" Y1 o
2021-09-10 11:04:47.284 27 ERROR nova.context 1 w7 ]& f" I! S" n6 V9 ?& V8 f2 y' {
2021-09-10 11:04:47.295 27 WARNING nova.compute.multi_cell_list [req-8201556b-c83d-41e4-8bc3-25b2f16d20d1 b1ffbc1f84cf42c99a8e59fdaf7f1cf5 92a5a26fc14d418d881ade0ccbcffc59 - default default] Cell 00000000-0000-0000-0000-000000000000 is not responding and hence skipped from the results.1 Y# L: H0 ?- N! t1 F4 k% j
2021-09-10 11:04:47.693 27 INFO nova.osapi_compute.wsgi.server [req-8201556b-c83d-41e4-8bc3-25b2f16d20d1 b1ffbc1f84cf42c99a8e59fdaf7f1cf5 92a5a26fc14d418d881ade0ccbcffc59 - default default] 192.168.6.233,192.168.6.235 "GET /v2.1/92a5a26fc14d418d881ade0ccbcffc59/servers/detail?all_tenants=True&limit=21 HTTP/1.1" status: 200 len: 9638 time: 0.7506602% V5 G; j0 p# O7 `6 O: M1 Q, @
2021-09-10 11:04:58.033 26 INFO nova.osapi_compute.wsgi.server [req-05d402b1-7387-4ac7-982a-001ee07a20a4 b1ffbc1f84cf42c99a8e59fdaf7f1cf5 92a5a26fc14d418d881ade0ccbcffc59 - default default] 192.168.6.233,192.168.6.235 "GET /v2.1/92a5a26fc14d418d881ade0ccbcffc59 HTTP/1.1" status: 404 len: 358 time: 0.0097570
/ E/ o& m% B( m8 k- f; I) p+ ^; z0 A* @
7 e' P" R( `- o8 n% D) x
 楼主| 发表于 2021-9-10 11:22:22 | 显示全部楼层
2021-09-10 11:20:05.546 27 ERROR nova.context 7 g% J( D- l! z: F+ @
2021-09-10 11:20:05.642 27 WARNING nova.compute.multi_cell_list [req-b3465d9f-eaa6-4b64-aa87-43b0e656bb10 b1ffbc1f84cf42c99a8e59fdaf7f1cf5 92a5a26fc14d418d881ade0ccbcffc59 - default default] Cell 00000000-0000-0000-0000-000000000000 is not responding and hence skipped from the results.
$ g0 |( D4 h& f! Z/ [$ `2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines [req-b3465d9f-eaa6-4b64-aa87-43b0e656bb10 b1ffbc1f84cf42c99a8e59fdaf7f1cf5 92a5a26fc14d418d881ade0ccbcffc59 - default default] Database connection was found disconnected; reconnecting: DBConnectionError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query') [SQL: u'SELECT 1'] (Background on this error at: http://sqlalche.me/e/e3q8)
4 i3 F1 Q$ v: w. |) b2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines Traceback (most recent call last):, L  \) j# u$ d# w
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 73, in _connect_ping_listener
9 w  G" ^1 ~, m  e2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     connection.scalar(select([1])), k- [6 B8 M, z( M( M" M# r
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 880, in scalar
& {! \* z" `! s! b5 M( ]  d9 s, V2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     return self.execute(object, *multiparams, **params).scalar()5 p$ X1 A3 \* i& U
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
2 C% P# O' B- [- k2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     return meth(self, multiparams, params)
9 u8 j% u# ^% i! i, d2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection7 g* V% b' V( L
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     return connection._execute_clauseelement(self, multiparams, params)8 E( o2 G# m+ @  _% g- U" y8 p
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement% y1 L: b/ |( H% A; x* R- m
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     compiled_sql, distilled_params+ f: O; s8 t# o/ \% u! f
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
0 G' D% M$ t6 Y* e- @; T2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     context)9 G/ [0 U& N) H% T& ~& U3 `6 M/ y
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1409, in _handle_dbapi_exception- ~+ `0 q$ T! }9 R: {/ j
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     util.raise_from_cause(newraise, exc_info)4 L( {5 G6 e% m8 m0 a+ z3 R
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
7 I2 c2 ?6 l/ V; h3 \' u  M  D7 e$ i2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     reraise(type(exception), exception, tb=exc_tb, cause=cause)
/ }+ j+ Q: j1 W5 Y2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context! k: [! A" D2 F& V3 O
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     context)2 [* R  L) W3 S+ K; g9 q6 ~
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute4 G% k; S4 \3 g
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     cursor.execute(statement, parameters)
$ C. W$ G: C+ C$ E6 L2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
8 ?+ c: B6 \& w. y/ J; @* |2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     result = self._query(query)
8 Z4 v" Q6 L2 c1 _3 z2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query0 h  `3 F2 z. V2 Q% ]; M
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     conn.query(q)
6 Z" L2 I. J) ]- B$ e2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 516, in query
( u0 P; `- L) S" H0 L2 \2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
* q: C/ M. H* q+ V7 L2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 727, in _read_query_result
( [  ~* [: {2 t1 |2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     result.read()
9 U( B& e6 H; e  P5 L' H2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1066, in read
' k5 {' D) [9 w: w+ e. j2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     first_packet = self.connection._read_packet()
9 A+ M* H1 j2 d( Y, [$ h2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 656, in _read_packet
% `' L/ a6 G% n2 |0 g& f2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     packet_header = self._read_bytes(4)8 q# g- a. a/ d( U, K
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 702, in _read_bytes0 L4 E. {5 R' J% Z5 N
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     CR.CR_SERVER_LOST, "Lost connection to MySQL server during query")
( J4 A9 w7 Y( u% q# l$ @2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines DBConnectionError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query') [SQL: u'SELECT 1'] (Background on this error at: http://sqlalche.me/e/e3q8)6 N7 G- x2 F2 ?3 x
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines
- @) ?$ e4 l) y2021-09-10 11:20:08.257 27 INFO nova.osapi_compute.wsgi.server [req-b3465d9f-eaa6-4b64-aa87-43b0e656bb10 b1ffbc1f84cf42c99a8e59fdaf7f1cf5 92a5a26fc14d418d881ade0ccbcffc59 - default default] 192.168.6.235,192.168.6.234 "GET /v2.1/92a5a26fc14d418d881ade0ccbcffc59/servers/detail?all_tenants=True&limit=21 HTTP/1.1" status: 200 len: 9625 time: 10.4952159
5 a5 u% x8 C& o; i& D7 U, y- {$ s2021-09-10 11:20:24.964 29 INFO nova.osapi_compute.wsgi.server [req-9cad86bc-aac3-431c-b77e-352b3cd62d36 b1ffbc1f84cf42c99a8e59fdaf7f1cf5 92a5a26fc14d418d881ade0ccbcffc59 - default default] 192.168.6.235,192.168.6.234 "GET /v2.1/92a5a26fc14d418d881ade0ccbcffc59 HTTP/1.1" status: 404 len: 358 time: 0.4130380
9 l' U" f5 V8 [* G( [8 m2021-09-10 11:20:29.720 27 INFO nova.osapi_compute.wsgi.server [req-ae166738-5576-4250-9bf6-80cd69a32a2d b1ffbc1f84cf42c99a8e59fdaf7f1cf5 92a5a26fc14d418d881ade0ccbcffc59 - default default] 192.168.6.235,192.168.6.234 "DELETE /v2.1/92a5a26fc14d418d881ade0ccbcffc59/servers/1f1f3e16-2d58-4687-823b-a1302e9197ae HTTP/1.1" status: 204 len: 381 time: 0.59253419 u$ A) N. `# r$ G6 I
2021-09-10 11:20:30.472 29 INFO nova.osapi_compute.wsgi.server [req-f45b82e1-b10a-4439-8f33-ef2be97991be b1ffbc1f84cf42c99a8e59fdaf7f1cf5 92a5a26fc14d418d881ade0ccbcffc59 - default default] 192.168.6.235,192.168.6.234 "GET /v2.1/ HTTP/1.1" status: 200 len: 762 time: 0.0455852
您需要登录后才可以回帖 登录 | 开始注册

本版积分规则

关闭

站长推荐上一条 /4 下一条

北京云银创陇科技有限公司以云计算运维,代码开发

QQ|返回首页|Archiver|小黑屋|易陆发现技术论坛 点击这里给我发消息

GMT+8, 2026-4-8 17:15 , Processed in 0.044545 second(s), 22 queries .

Powered by Discuz! X3.4 Licensed

© 2012-2025 Discuz! Team.

快速回复 返回顶部 返回列表