|
|
2021-09-10 11:04:47.284 27 ERROR nova.context Traceback (most recent call last):
, Y2 E/ p, ~4 m) ^; z' [2021-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+ E; m- H5 j' u3 B9 l: g
2021-09-10 11:04:47.284 27 ERROR nova.context result = fn(cctxt, *args, **kwargs). |% ^1 q' T9 w: U
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
3 { D$ Y, S8 V3 Y% {2021-09-10 11:04:47.284 27 ERROR nova.context **kwargs): e2 T- e4 S" \3 w" J8 w" l# v0 G
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
( P( @; d/ O5 V: L2 y# q5 \ n2021-09-10 11:04:47.284 27 ERROR nova.context **kwargs)
- Q% n* Y* V% W/ K( |5 W% w n4 K5 C2021-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: A- b( {: r4 t( u4 f
2021-09-10 11:04:47.284 27 ERROR nova.context sort_dirs=sort_dirs), H) `8 }* C, k* o' k% O
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
2 e$ q* U* y) ^( P( ~; @ |2021-09-10 11:04:47.284 27 ERROR nova.context return f(*args, **kwargs)
* ~% A/ X+ _) a* T$ M7 \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+ [2 f5 a7 Q" T @
2021-09-10 11:04:47.284 27 ERROR nova.context return f(context, *args, **kwargs)
9 I7 a1 B @* h C8 q3 U2021-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
9 f3 I: w$ z$ O, h& E* W6 E2021-09-10 11:04:47.284 27 ERROR nova.context return _instances_fill_metadata(context, query_prefix.all(), manual_joins)& ^0 [. Q5 ~! z1 _( b5 H3 o* V/ h
2021-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# q; f% K$ _2 B% p2 U" `6 T! I/ H% A
2021-09-10 11:04:47.284 27 ERROR nova.context return list(self)
- T! `+ c4 {* b" v* P3 E2021-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__
* P2 ~8 P! G4 N! l2021-09-10 11:04:47.284 27 ERROR nova.context return self._execute_and_instances(context). |0 j& \8 `) x5 N* v; T
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" x/ o8 T% U* x6 R- S7 _; N" z
2021-09-10 11:04:47.284 27 ERROR nova.context result = conn.execute(querycontext.statement, self._params)8 m, q q0 V5 `2 A2 }, ^) x
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$ C6 d$ L: R i: ~. j( E- M
2021-09-10 11:04:47.284 27 ERROR nova.context return meth(self, multiparams, params)
$ y% M _& ~/ `& M& c* `" R( t$ y2021-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_connection0 w+ z7 |+ h1 i: t2 B9 M
2021-09-10 11:04:47.284 27 ERROR nova.context return connection._execute_clauseelement(self, multiparams, params)
. @5 C. d |& _& B' [& R5 N2 W2021-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
6 w$ B0 S0 M( P5 Y2021-09-10 11:04:47.284 27 ERROR nova.context compiled_sql, distilled_params/ \7 I' b2 w% H8 Z( W% |
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
' v5 m- |1 Z' h3 I5 e3 b2021-09-10 11:04:47.284 27 ERROR nova.context context)( O: Y! o2 f- _& b( m5 _
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
# q2 u0 R6 ]/ d2021-09-10 11:04:47.284 27 ERROR nova.context util.raise_from_cause(newraise, exc_info)
* Y( F1 l- ~! a; M: G0 C7 s2021-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+ Q3 F% x2 W2 i( U
2021-09-10 11:04:47.284 27 ERROR nova.context reraise(type(exception), exception, tb=exc_tb, cause=cause)
6 z. [8 z4 a. K% f( Q. ]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( }$ I4 {9 b4 U5 d# |
2021-09-10 11:04:47.284 27 ERROR nova.context context)
& K6 {* g) \2 b6 a4 T4 M2021-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
9 h- b# d4 e! u% b2021-09-10 11:04:47.284 27 ERROR nova.context cursor.execute(statement, parameters)& f3 W1 \9 v& D0 D
2021-09-10 11:04:47.284 27 ERROR nova.context File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute8 r, D2 |( U1 S
2021-09-10 11:04:47.284 27 ERROR nova.context result = self._query(query)2 U) \) h- O2 M) ~
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
6 j1 O8 \, f; Z1 ~3 y5 L! [2021-09-10 11:04:47.284 27 ERROR nova.context conn.query(q)
f+ v/ R% U& R) h$ b: [2021-09-10 11:04:47.284 27 ERROR nova.context File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 516, in query$ \ t- `# t# C) R% K) s
2021-09-10 11:04:47.284 27 ERROR nova.context self._affected_rows = self._read_query_result(unbuffered=unbuffered)
1 P% Q* k, o- z2 `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_result2 x y6 g) X2 N3 w$ z
2021-09-10 11:04:47.284 27 ERROR nova.context result.read()
, ?7 Y3 K; e, ?1 p/ M: q2021-09-10 11:04:47.284 27 ERROR nova.context File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1066, in read
* A5 s8 O R: k- P2 H8 ?* D$ e( G( i2021-09-10 11:04:47.284 27 ERROR nova.context first_packet = self.connection._read_packet()
6 S9 M+ T9 x3 y2021-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
c G- Q7 D9 ^6 o2021-09-10 11:04:47.284 27 ERROR nova.context packet.check_error()
* Q+ Y: p" L0 P2 q2021-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
+ _' t1 S# i+ M3 Q; N' {2021-09-10 11:04:47.284 27 ERROR nova.context err.raise_mysql_exception(self._data)
# m$ @0 l7 ?% i$ G2021-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
* U( {' B7 n& d( Z2021-09-10 11:04:47.284 27 ERROR nova.context raise errorclass(errno, errval). A; }; V0 u. U0 k+ g4 ~. d( z$ L* j
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)" I( y _* |; p {7 J* B' p( j
2021-09-10 11:04:47.284 27 ERROR nova.context ( O$ b- P9 F5 a8 `. P
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.
4 Q# |# f' M2 Q6 Z2021-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% c9 c, ^6 ~+ b, z5 W
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.00975704 ` E+ V4 N! y2 ?% Y- L: U
# A& D: i) Q5 v; v b0 y9 v+ X
+ u6 k: s9 E% H, P8 D1 v |
|
发表于 2021-9-10 11:09:36