将设为首页浏览此站
开启辅助访问 天气与日历 收藏本站联系我们切换到窄版

易陆发现论坛

 找回密码
 开始注册
查看: 281|回复: 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):
. H8 u# Q- }$ m2 B2021-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
8 `5 O, Y  g1 L( Y. K6 d3 s2021-09-10 11:04:47.284 27 ERROR nova.context     result = fn(cctxt, *args, **kwargs)1 }" g& J4 a, {  V8 O" |1 B
2021-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
, }& a) r- [0 d2021-09-10 11:04:47.284 27 ERROR nova.context     **kwargs)
' E, r" {/ \7 U2021-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
2 r  q. d2 r4 L  k. E9 Z( W7 p2021-09-10 11:04:47.284 27 ERROR nova.context     **kwargs)
2 H. x5 \2 K+ l& y: H$ a' V, ~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  ^  M: Q4 \/ c+ n& J2 l  B9 M
2021-09-10 11:04:47.284 27 ERROR nova.context     sort_dirs=sort_dirs)
$ X" ^. o+ p9 ]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
# P$ |( o8 B# b5 h, I2021-09-10 11:04:47.284 27 ERROR nova.context     return f(*args, **kwargs)! ~' k( U. t8 Z% @
2021-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
7 H7 L; [3 E' q7 a9 G# u/ a2021-09-10 11:04:47.284 27 ERROR nova.context     return f(context, *args, **kwargs)
# Z) ?( Q8 L. j7 ^& w2021-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# G: l; F5 \! Z1 L6 G- l9 a) d
2021-09-10 11:04:47.284 27 ERROR nova.context     return _instances_fill_metadata(context, query_prefix.all(), manual_joins)
5 O; i8 Q4 s% ?! U6 N0 r2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
7 y5 v# _1 k$ k+ ~% n- f2021-09-10 11:04:47.284 27 ERROR nova.context     return list(self)
& t8 o& C* e* E; W) W  y* I& ?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__* |, K3 \! d0 |+ g$ |& T+ ?
2021-09-10 11:04:47.284 27 ERROR nova.context     return self._execute_and_instances(context)
( h2 [, v! M$ @8 A2 e2021-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_instances8 H) O4 [: M2 T% c8 v3 }" I! k
2021-09-10 11:04:47.284 27 ERROR nova.context     result = conn.execute(querycontext.statement, self._params)4 ]5 |0 ]1 ?/ t" a: V& D
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  y5 }. H* D  w* Q; p2 ]0 ^8 W' h
2021-09-10 11:04:47.284 27 ERROR nova.context     return meth(self, multiparams, params)
8 P, _5 d+ c( P5 Q2021-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_connection8 y$ H. T/ K3 ~3 d3 g
2021-09-10 11:04:47.284 27 ERROR nova.context     return connection._execute_clauseelement(self, multiparams, params)
+ p2 e5 a9 O8 Q* e, t- N# o0 b2021-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( V* l# i( O: [. u5 s! F
2021-09-10 11:04:47.284 27 ERROR nova.context     compiled_sql, distilled_params
& m2 g8 V* ^) L$ P3 D7 X+ f' U2021-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( m! l6 D0 D7 w' z- k. @3 f' C$ h
2021-09-10 11:04:47.284 27 ERROR nova.context     context)3 ]4 A4 N- X, J0 }2 S) y
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/ Y2 b3 i: T9 m- g8 T" S' p/ [3 m% i
2021-09-10 11:04:47.284 27 ERROR nova.context     util.raise_from_cause(newraise, exc_info)
0 z: T( m) M8 c! T+ f! x2021-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_cause
& |# S# M) S1 `# c2 |2021-09-10 11:04:47.284 27 ERROR nova.context     reraise(type(exception), exception, tb=exc_tb, cause=cause)  |, u: `  \6 [2 A7 |; A( b
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_context
* u; |0 W/ d5 G% e3 u' ?. h5 ~2021-09-10 11:04:47.284 27 ERROR nova.context     context)
) C3 L5 ]- @6 ]' H0 X9 W2021-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" S% D% y% |6 W6 B+ }, C( l8 Y
2021-09-10 11:04:47.284 27 ERROR nova.context     cursor.execute(statement, parameters)3 U- n: }+ _% I9 ]3 C/ V$ v9 j, ^
2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute% \+ R4 [1 B" ~' r4 l% G* F
2021-09-10 11:04:47.284 27 ERROR nova.context     result = self._query(query)! N, T' P4 ^8 q3 f% q
2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
, J# o1 a8 W2 e( ^2 d- x7 S/ N2021-09-10 11:04:47.284 27 ERROR nova.context     conn.query(q)
, ?" H/ n' N) D& B/ C2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 516, in query
# \# o( l( x- F2021-09-10 11:04:47.284 27 ERROR nova.context     self._affected_rows = self._read_query_result(unbuffered=unbuffered)& m3 K7 @# [. c, P) S
2021-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_result) i- A" K3 K: E* N1 c; N0 ?* }4 y7 w
2021-09-10 11:04:47.284 27 ERROR nova.context     result.read()
7 m1 A. Q1 f& Q" N; D" Y( m3 ?2021-09-10 11:04:47.284 27 ERROR nova.context   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1066, in read
# x5 [/ D. B$ v/ m" Y2021-09-10 11:04:47.284 27 ERROR nova.context     first_packet = self.connection._read_packet()
! X+ s9 Y2 a% r6 D- l# M2021-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, D8 q, C" ?% z7 q! @" _
2021-09-10 11:04:47.284 27 ERROR nova.context     packet.check_error()* ?# c! e4 L! o+ u9 u! t2 }6 J
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_error
! e% t  L( V. p/ c7 d8 ^* s2021-09-10 11:04:47.284 27 ERROR nova.context     err.raise_mysql_exception(self._data)2 [8 |4 f( |6 ^. w4 m! t! l
2021-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_exception7 ]: c4 e2 n% J4 P: t! r0 Z
2021-09-10 11:04:47.284 27 ERROR nova.context     raise errorclass(errno, errval)4 ?) i5 {- h. m3 Y" k+ a6 W. n
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)
1 V, v, N, k9 H9 H# s4 t, I% {2021-09-10 11:04:47.284 27 ERROR nova.context
0 x* l" R& l) z& i: G3 c/ w2021-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.
& k( s0 t: h4 L! l3 o6 J% u: e$ e4 B) u; _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.75066020 a4 F( e3 r- ~
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
- m1 B  n* b+ d/ r3 ]2 ~) w8 c
0 v. Z* l: W( P
 楼主| 发表于 2021-9-10 11:22:22 | 显示全部楼层
2021-09-10 11:20:05.546 27 ERROR nova.context
1 C/ f  ^8 J' ^+ ]# ?( d2021-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.
$ N: y1 {% w# H2021-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)
6 E! s; C) w' @! P+ D9 @/ ?1 |2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines Traceback (most recent call last):9 F" k% P0 x. b  j4 k* L
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' W+ t1 t7 U7 i
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     connection.scalar(select([1]))
# {  {# @: ], L9 S9 E& r2021-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
7 d4 F' m: N0 Y3 v2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     return self.execute(object, *multiparams, **params).scalar()' n: ~4 y$ H8 p1 \8 M
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, A5 h  t1 U+ X0 o+ E, B+ n
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     return meth(self, multiparams, params)
1 N% x% Z# U7 m5 ~( H2021-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_connection
/ m# V) m6 Y$ m2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     return connection._execute_clauseelement(self, multiparams, params)
1 N5 M* g8 k" K2021-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
/ P1 c( h2 h/ I$ m2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     compiled_sql, distilled_params
9 x5 |: n& N7 y' L1 W2021-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
6 [0 y9 w; t( t3 u: B1 [5 @2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     context)
, ]+ Z# ^+ u* t4 W- J, a2021-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" L4 ?  f  [6 r
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     util.raise_from_cause(newraise, exc_info)
6 ]  c( c+ ?$ D2 g9 J2 Z2021-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, O, w0 s4 I1 }* K% `$ K; _) g3 _
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     reraise(type(exception), exception, tb=exc_tb, cause=cause)$ n6 N4 I, Z% \/ k! y& |- g! ^. T4 ^
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 1193, in _execute_context( J& @; ^8 Z% F! y! r+ v1 L4 V* i
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     context)( n, x- c1 [. r* T* N
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_execute9 @- V7 R% j. u8 e
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     cursor.execute(statement, parameters)+ {! `! ^1 p' [& T
2021-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
$ n: Y; R6 [4 L1 I4 K2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     result = self._query(query)
6 h7 g8 P5 {! o5 N2021-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 _query
7 m1 S3 q5 l' Y2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     conn.query(q)
  g8 @7 Q6 b0 {3 l2021-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+ [  ?7 ~# E: [
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
6 I8 V( A& P6 p: V* J- W2021-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_result8 O: s7 J% _" n1 t* I3 B
2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     result.read()
7 m) p) B4 B3 t' K2021-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
  j. @1 p. `( D/ {1 B+ C4 O: R2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     first_packet = self.connection._read_packet()* s8 X3 M6 k: e" p
2021-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
+ z0 z! }( x7 u2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     packet_header = self._read_bytes(4)5 `& b. m; S6 P( B; @" Y( P# Y1 I' }/ {
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_bytes
* X/ Y2 }  J6 y; m2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines     CR.CR_SERVER_LOST, "Lost connection to MySQL server during query")& N) V- M- N2 Y$ q* ]- C( z% u
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)
0 v9 ?4 F+ `, l4 T6 {- Z# B2021-09-10 11:20:05.666 27 ERROR oslo_db.sqlalchemy.engines 5 K% m  ~  f5 V* N" B9 K- @) ~2 k
2021-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
) \; H( r1 ^) X+ P! f  `2 U7 |- B; g2021-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.41303807 K2 B/ y  _8 L9 A4 j9 |! R1 }
2021-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.5925341
2 ~( ?, w. \% l& x) T  x) U. {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 下一条

如有购买积分卡请联系497906712

QQ|返回首页|Archiver|手机版|小黑屋|易陆发现 点击这里给我发消息

GMT+8, 2021-10-28 15:24 , Processed in 0.046194 second(s), 22 queries .

Powered by LR.LINUX.cloud bbs168x X3.2 Licensed

© 2012-2022 Comsenz Inc.

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