- 积分
- 16843
在线时间 小时
最后登录1970-1-1
|
马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。
您需要 登录 才可以下载或查看，没有账号？开始注册
x
[root@controller1 ~]# openstack compute service list
; L( I; B9 j4 z& r4 h. d+----+------------------+-------------+----------+---------+-------+----------------------------+
: E1 N$ X, D3 ? K+ x7 Q" f. A# I$ q& B| ID | Binary | Host | Zone | Status | State | Updated At |
: P6 R& d5 {) A0 k8 @+----+------------------+-------------+----------+---------+-------+----------------------------+ f% B7 B" T: u: d7 Q
| 19 | nova-scheduler | controller2 | internal | enabled | down | 2021-09-07T02:31:45.000000 |
8 G6 [$ t1 Y) n/ d| 22 | nova-scheduler | controller3 | internal | enabled | down | 2021-09-07T02:31:52.000000 |
7 X7 a1 j$ Y% x+ A7 \& \/ X| 23 | nova-scheduler | controller1 | internal | enabled | down | 2021-09-07T02:31:49.000000 |
u8 L" G8 S; T; f; A9 Z4 N$ ~ t| 24 | nova-conductor | controller3 | internal | enabled | up | 2021-09-07T02:54:26.000000 |
9 q* V: F$ ]6 C6 i! x( ?1 s| 28 | nova-conductor | controller1 | internal | enabled | up | 2021-09-07T02:54:25.000000 |0 S ? d) M5 x8 D8 b* R3 P8 q
| 33 | nova-conductor | controller2 | internal | enabled | up | 2021-09-07T02:54:25.000000 |+ u. _# H- q# N8 Q6 @
| 34 | nova-consoleauth | controller2 | internal | enabled | down | 2021-09-07T02:31:40.000000 |
`, a3 f% y0 ]0 E. ?) x0 S) {9 I| 36 | nova-consoleauth | controller1 | internal | enabled | up | 2021-09-07T02:54:25.000000 |* J2 C7 Q o6 T h/ V, H
| 38 | nova-consoleauth | controller3 | internal | enabled | down | 2021-09-07T02:31:42.000000 |' ^7 `% q) [% o9 j) ^6 M+ R
| 42 | nova-compute | compute02 | nova | enabled | up | 2021-09-07T02:54:21.000000 |
8 y- A2 m# N8 h) h7 K7 [" ?| 43 | nova-compute | compute03 | nova | enabled | up | 2021-09-07T02:54:17.000000 |
/ ]1 x9 s f; b' Y4 q) a| 45 | nova-compute | compute01 | nova | enabled | up | 2021-09-07T02:54:22.000000 |" j9 J3 |8 Y( @# S" V
+----+------------------+-------------+----------+---------+-------+----------------------------+% K6 W4 L4 \& f4 v+ G
- a V; l0 ?9 m6 |, x删除虚机命令：- O, {2 [$ ` @
[root@controller1 ~]# openstack server delete 69088d55-eb76-4674-98fe-7909ba5476745 t9 K$ s4 A% I4 Y$ h# L# W( i
No server with a name or ID of '69088d55-eb76-4674-98fe-7909ba547674' exists.
, S. @* Z' M; V. a1 x无法删除，头疼：
$ M5 K; {2 D7 R+ g) z[root@controller1 ~]# openstack server list 4 u! ^* |9 _* x* r7 Y$ b
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
6 o8 h) _- }& G0 g# ]% }| ID | Name | Status | Networks | Image | Flavor |
" y3 I" \8 J; A2 O4 _2 _6 L+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+* W& Q! B; h7 l0 v
| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |
M" Z! d6 q0 o, y1 [2 _9 ~| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |
& Q# z j2 f3 ], v6 }( K# i6 X0 F| 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 | test1 | ACTIVE | bridge=192.168.0.206, 192.168.0.233; zhangyj_network=192.168.1.20 | | type-1c-1g-10g |
! P0 S4 X1 D- b6 n! v5 Q( a2 x2 |0 t| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |, U6 j* T6 Y4 O. _; Y
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
' I P U; @# o% H/ t9 k
; y5 C' C3 E1 b" j! r1 y$ e/ y- Q+ d- v
[root@controller1 ~]# openstack server delete 69088d55-eb76-4674-98fe-7909ba547674! P0 S- g p0 }- @% ?9 N
No server with a name or ID of '69088d55-eb76-4674-98fe-7909ba547674' exists.$ Q6 l5 |) v3 Q2 r3 `* d- U) G3 z
[root@controller1 ~]# : B' G, r% N4 h* J+ X
还是删不掉：
9 }/ d ?8 `6 Q+ Q& x: n: z3 G[root@controller1 ~]# openstack server list - v6 U8 Q# ]" e" Q/ r8 K$ J- K
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
1 g; W8 D- Y6 @! r+ b" s| ID | Name | Status | Networks | Image | Flavor |
. ~$ U7 Q8 v/ g) r9 m' p& m- x+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
+ B4 a* e, `. o| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |- W/ B4 ]8 U& y. L
| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |
f5 Z/ ^, | Z4 N5 v| 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 | test1 | ACTIVE | bridge=192.168.0.206, 192.168.0.233; zhangyj_network=192.168.1.20 | | type-1c-1g-10g |0 D+ g' A/ j* m
| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |+ O. S3 L3 Q, T" J/ o9 k
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+9 X# U* z3 p+ C# `5 G, f- h
[root@controller1 ~]# openstack server list % z' O9 q: _+ ?1 @# t! q) i! Y
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
2 ]! P' j; p6 ]) g- c% L: w* Z| ID | Name | Status | Networks | Image | Flavor |
# ]. u: |; H. ]* M3 p1 f+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+* l" k5 v& X! t: M8 T2 O
| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |
& K, F) ?* ~6 I1 B8 I- Y) v$ u| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |
# u2 y1 _* ]8 ~| 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 | test1 | ACTIVE | bridge=192.168.0.206, 192.168.0.233; zhangyj_network=192.168.1.20 | | type-1c-1g-10g |
" G# o; U, l0 x| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |
& Z5 `5 S4 W. B! u7 ~$ M2 t: H+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
2 p0 F0 i1 e' @" G# L* |0 T5 k1 {5 j5 `0 S5 t) ?$ a) `" P: A& D
[root@controller1 ~]# openstack server ; E0 L7 n. F; v) [
add dump list reboot resize resume ssh unlock unshelve
# D* K) Z, d8 d+ Ybackup event lock rebuild resize_confirm set start unpause
4 b) D$ J+ J3 S2 w; d9 t+ {1 a6 F8 Lcreate group migrate remove resize_revert shelve stop unrescue
# k# {! M% H0 m) O$ I7 Ddelete image pause rescue restore show suspend unset . u* ]4 `1 b& P, k; ]
[root@controller1 ~]# openstack server " E h; ?3 N; }: R/ a$ _" |
add dump list reboot resize resume ssh unlock unshelve
4 F$ K, ~" ^. G( Rbackup event lock rebuild resize_confirm set start unpause , u! v/ i3 l: t8 ]8 f2 A0 g% h
create group migrate remove resize_revert shelve stop unrescue 5 |6 @6 s/ w ^: x; E( p }: Q
delete image pause rescue restore show suspend unset N4 w2 ^6 G+ p7 E
' r! L- Q0 d; g( k也无法show：
8 @+ @; _& L' G1 c# j# K[root@controller1 ~]# openstack server show 69088d55-eb76-4674-98fe-7909ba547674
$ ~" T' O+ m* ]5 a8 E4 gNo server with a name or ID of '69088d55-eb76-4674-98fe-7909ba547674' exists.
) x$ @6 f6 e% d3 R o[root@controller1 ~]# openstack server list
+ A; j: l. k* x, R, v+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+, x: }* M6 a/ W8 i% [8 p
| ID | Name | Status | Networks | Image | Flavor |
5 i7 ~* L0 e4 g* h1 b8 i+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+; s, p& V, ]$ m" G: w
| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |3 \' K( l/ l2 }( X( a# C1 D- ]" h
| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |# W3 }- ]/ F+ {! O
| 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 | test1 | ACTIVE | bridge=192.168.0.206, 192.168.0.233; zhangyj_network=192.168.1.20 | | type-1c-1g-10g |5 Q2 X8 {; w6 W, X8 G6 W
| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |
, K; B) ?8 ?1 C+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
/ g, {2 e) }0 \4 s+ G" B j: n* z1 z- S1 K+ y
上面的有问题，只能去数据库查看了：( `$ Z$ P' i* c7 ]) K
, A* ^$ i2 F; [$ }
$ v$ M3 n s5 }% e# M0 B% E. ?! X[root@controller1 ~]# openstack server list
, U, Z7 ^9 n: F- M) ?) ~+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
7 }' Q% [; |' @3 k$ q8 o$ F| ID | Name | Status | Networks | Image | Flavor |
8 ^9 s e) P0 f7 v+--------------------------------------+----------+--------+----------------------+-------------------+----------------+5 W' n$ D7 q7 o
| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |
# c( g: F9 n2 J) y' a( z4 A| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |6 H: I. j& L9 w! {" u+ g0 y
| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |
( j* J7 i8 b2 l* f. k0 S+--------------------------------------+----------+--------+----------------------+-------------------+----------------+0 R4 x$ G- j T5 u0 P
[root@controller1 ~]# openstack server delete test1
% g8 m" _5 _4 y V+ R1 u5 C+ KNo server with a name or ID of 'test1' exists.( P4 @8 A1 F7 P. {& q% e0 s. n. z
[root@controller1 ~]# ) f1 }& r* K: `0 A
' h( g! J: ^! W[root@controller1 ~]# openstack server list 3 n! j" T9 d) {( H, o
+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
) G6 H4 k, s8 O& r| ID | Name | Status | Networks | Image | Flavor |
: T4 r- y/ J p6 B! s( X+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
! c; }, n$ U2 M: K( e| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |
# s$ l1 V- Y+ j/ ^0 ]! T: K| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |
4 K9 X* {% W! ~$ U, I| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |# J4 `9 J! C a4 y6 [; i. _* B
+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
/ m! j+ T8 @7 C3 R/ x: ^% |[root@controller1 ~]# mysql -u root -pdxFxylGX6K65rDh8hu2TWhWTKcIkZVZM6fEvmuW7 -h 192.168.6.233+ \1 M" \+ k [8 y& h# B3 t
Welcome to the MariaDB monitor. Commands end with ; or \g.- N' k' Z5 c8 Y% {
Your MariaDB connection id is 1669555* _* ~, W6 g2 [
Server version: 10.1.20-MariaDB MariaDB Server
- x+ ?1 x* j7 H i. KCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
2 V* ~/ p) F" t, T$ K" Y+ `. I% JType 'help;' or '\h' for help. Type '\c' to clear the current input statement.# Q2 Q% c* e2 C a. y5 G; P3 W3 E
MariaDB [(none)]> use nova1 J. w$ ~" Y& @# r' ^( v
Reading table information for completion of table and column names
) I( E7 I1 p' G0 D' j9 l/ X) QYou can turn off this feature to get a quicker startup with -A
: f' J( U: f: p, q. D/ h. N/ y0 UDatabase changed q* G6 |* k) s8 L* M
MariaDB [nova]> select * from in
, T5 L# H' t/ @) eDisplay all 219 possibilities? (y or n)
7 n6 n* ]5 V. G" X: K' G* xin_use instance_groups.created_at instance_types.root_gb
; i( f: ` ], a: {information_schema instance_groups.deleted instance_types.rxtx_factor
! O8 L+ Z9 D5 g7 R: Rinjected instance_groups.deleted_at instance_types.swap
6 r$ d+ k/ {4 B1 c8 V' f vinstance_actions instance_groups.id instance_types.updated_at
3 g: K; M: i ]* y& K i) i& E/ r; winstance_actions.action instance_groups.name instance_types.vcpu_weight
# K- W- x3 `1 O" rinstance_actions.created_at instance_groups.project_id instance_types.vcpus
4 M2 k" ^# @: ainstance_actions.deleted instance_groups.updated_at instance_uuid
5 A5 w6 W% k7 r& x Jinstance_actions.deleted_at instance_groups.user_id instances
6 r! M+ O- f" c( F" s* J* c3 Binstance_actions.finish_time instance_groups.uuid instances.access_ip_v4
' Q6 x* v6 F4 o2 ninstance_actions.id instance_id instances.access_ip_v6" A, e) W+ e0 C) O
instance_actions.instance_uuid instance_id_mappings instances.architecture- [/ N, x1 {8 L0 z( t
instance_actions.message instance_id_mappings.created_at instances.auto_disk_config( @* k7 T' O* P& L7 N5 R" s
instance_actions.project_id instance_id_mappings.deleted instances.availability_zone
1 j. n+ _9 _/ w) X; n+ {0 l, qinstance_actions.request_id instance_id_mappings.deleted_at instances.cell_name2 H3 p9 q5 e8 E
instance_actions.start_time instance_id_mappings.id instances.cleaned
; R; F( K$ p! o) Qinstance_actions.updated_at instance_id_mappings.updated_at instances.config_drive+ e" i" J% P* ~0 J( ?( p
instance_actions.user_id instance_id_mappings.uuid instances.created_at0 o. E9 A. f1 o; T
instance_actions_events instance_info_caches instances.default_ephemeral_device$ K3 Q7 ?" M5 o8 y9 I
instance_actions_events.action_id instance_info_caches.created_at instances.default_swap_device
( y7 B) R5 n, linstance_actions_events.created_at instance_info_caches.deleted instances.deleted
1 R* R/ ]6 O! x( ^, pinstance_actions_events.deleted instance_info_caches.deleted_at instances.deleted_at
n j8 I' k1 u; yinstance_actions_events.deleted_at instance_info_caches.id instances.disable_terminate
1 `( u8 V: e- Z$ k5 p0 sinstance_actions_events.details instance_info_caches.instance_uuid instances.display_description/ B* T( g: i% l5 a# N$ ?! f
instance_actions_events.event instance_info_caches.network_info instances.display_name2 h1 f& } |' ]0 g3 }7 e
instance_actions_events.finish_time instance_info_caches.updated_at instances.ephemeral_gb
; J( r6 D8 a y: T, M. ]instance_actions_events.host instance_metadata instances.ephemeral_key_uuid
3 {* M4 \" y3 M4 R7 kinstance_actions_events.id instance_metadata.created_at instances.host
, E2 }& M( i0 ]0 H, N0 h% h3 rinstance_actions_events.result instance_metadata.deleted instances.hostname
+ C$ o' P4 s& q% u, h; f* binstance_actions_events.start_time instance_metadata.deleted_at instances.id
) k* ?5 F* @1 Y- Jinstance_actions_events.traceback instance_metadata.id instances.image_ref" @9 v' D V3 `
instance_actions_events.updated_at instance_metadata.instance_uuid instances.instance_type_id3 y' Q/ V- @/ k/ F% O' J
MariaDB [nova]> select * from instance
/ l ~! A0 W5 U$ rDisplay all 203 possibilities? (y or n)
9 O. g: E: n$ E# w% I" x' W9 K3 NMariaDB [nova]> select * from instance;
# g8 X: z& \# M/ M' g- iERROR 1146 (42S02): Table 'nova.instance' doesn't exist l( Q5 a8 Y. y* G, ?
MariaDB [nova]> select * from instance;
* c) T: r: r) k% i& m8 AERROR 1146 (42S02): Table 'nova.instance' doesn't exist7 s `. q' {' f# i
MariaDB [nova]> select * from instance;6 j0 C0 L* Y. C1 J2 G- p
Display all 203 possibilities? (y or n)
1 B8 I7 s. c3 h5 m* @instance_actions instance_group_policy.updated_at instance_types.disabled
7 s6 L! \ O" ninstance_actions.action instance_groups instance_types.ephemeral_gb$ ?/ d1 ?" a' O3 c$ i% ]+ o( H
instance_actions.created_at instance_groups.created_at instance_types.flavorid, \8 a- x9 m0 a6 Z4 \* A# Z/ V
instance_actions.deleted instance_groups.deleted instance_types.id
0 _5 R; R3 T8 ?, U' G" Dinstance_actions.deleted_at instance_groups.deleted_at instance_types.is_public2 ^) W& z- V3 k w0 F! E) M
instance_actions.finish_time instance_groups.id instance_types.memory_mb3 e P5 I4 u1 K3 |
instance_actions.id instance_groups.name instance_types.name
7 r) [: J, i. m* Hinstance_actions.instance_uuid instance_groups.project_id instance_types.root_gb
9 X0 o% l+ Y* g/ u8 f9 X. Z0 jinstance_actions.message instance_groups.updated_at instance_types.rxtx_factor6 Z2 E) S( y/ s' r: ]8 }2 S
instance_actions.project_id instance_groups.user_id instance_types.swap
6 t0 j2 {3 x9 I0 Rinstance_actions.request_id instance_groups.uuid instance_types.updated_at( x" a; _; H0 L9 y5 K* J. N
instance_actions.start_time instance_id instance_types.vcpu_weight
: {0 z7 E% P1 j+ v' E! vinstance_actions.updated_at instance_id_mappings instance_types.vcpus$ Z/ b; Z; ]/ |% |+ N
instance_actions.user_id instance_id_mappings.created_at instance_uuid
0 Y$ E4 O# |$ Q9 V6 M4 Kinstance_actions_events instance_id_mappings.deleted instances G' X8 J' e- ?
instance_actions_events.action_id instance_id_mappings.deleted_at instances.access_ip_v42 u# N$ h! q" `" Z! F
instance_actions_events.created_at instance_id_mappings.id instances.access_ip_v6
V7 j9 Y: W4 V* qinstance_actions_events.deleted instance_id_mappings.updated_at instances.architecture/ L4 H; o* b) I* g5 P2 @' o
instance_actions_events.deleted_at instance_id_mappings.uuid instances.auto_disk_config
) K* N# L! U& g; c+ x% v, I3 oinstance_actions_events.details instance_info_caches instances.availability_zone+ ]- h( v1 G* b
instance_actions_events.event instance_info_caches.created_at instances.cell_name& S/ a! L' Z9 X! Z8 q1 j% b$ Z
instance_actions_events.finish_time instance_info_caches.deleted instances.cleaned: v# z3 S) j6 h! i" A& c: _
instance_actions_events.host instance_info_caches.deleted_at instances.config_drive) U& i3 [" P" ~6 t3 Z4 h
instance_actions_events.id instance_info_caches.id instances.created_at. \$ j1 r' n% M5 m
instance_actions_events.result instance_info_caches.instance_uuid instances.default_ephemeral_device
: V+ @. ?) l" E+ binstance_actions_events.start_time instance_info_caches.network_info instances.default_swap_device
# ^) B5 `: _& v7 w Ginstance_actions_events.traceback instance_info_caches.updated_at instances.deleted5 ^: t- B9 k% ~/ s3 r6 j( R
instance_actions_events.updated_at instance_metadata instances.deleted_at
/ `2 r. Q! ~+ B+ T# Uinstance_extra instance_metadata.created_at instances.disable_terminate
; k* n3 R( o! S3 P& _" d& l8 y2 E& hinstance_extra.created_at instance_metadata.deleted instances.display_description; `( W' z2 H8 O. q" F
instance_extra.deleted instance_metadata.deleted_at instances.display_name
s! A/ a% G+ U. T$ f$ c4 Z7 w* R: O( lMariaDB [nova]> select * from instances;
# | j8 F, D. f3 O+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-------------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+! m; A$ F! b0 ?. X# t
| created_at | updated_at | deleted_at | id | internal_id | user_id | project_id | image_ref | kernel_id | ramdisk_id | launch_index | key_name | key_data | power_state | vm_state | memory_mb | vcpus | hostname | host | user_data | reservation_id | launched_at | terminated_at | display_name | display_description | availability_zone | locked | os_type | launched_on | instance_type_id | vm_mode | uuid | architecture | root_device_name | access_ip_v4 | access_ip_v6 | config_drive | task_state | default_ephemeral_device | default_swap_device | progress | auto_disk_config | shutdown_terminate | disable_terminate | root_gb | ephemeral_gb | cell_name | node | deleted | locked_by | cleaned | ephemeral_key_uuid |
2 t* U4 a9 v2 s+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-------------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+
8 _8 n6 t; J/ A7 U# R, p1 u- J| 2021-08-25 07:37:43 | 2021-09-07 03:02:01 | 2021-09-07 03:02:01 | 2 | NULL | b1ffbc1f84cf42c99a8e59fdaf7f1cf5 | 92a5a26fc14d418d881ade0ccbcffc59 | | | | 0 | NULL | NULL | 0 | deleted | 1024 | 1 | test1 | compute02 | NULL | r-uqofhf0v | 2021-08-31 03:10:00 | 2021-09-07 03:02:01 | test1 | NULL | nova | 0 | NULL | compute02 | 3 | NULL | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 1 | 0 | 0 | 10 | 0 | NULL | compute02 | 2 | NULL | 1 | NULL |
: N4 a, E3 E2 r2 r5 `| 2021-08-25 08:02:10 | 2021-08-25 08:11:58 | 2021-08-25 08:11:58 | 4 | NULL | b1ffbc1f84cf42c99a8e59fdaf7f1cf5 | 92a5a26fc14d418d881ade0ccbcffc59 | 96e683e6-18b5-4912-b9ad-2f3846bd931c | | | 0 | NULL | NULL | 0 | deleted | 1024 | 1 | zhangyj | compute03 | NULL | r-9nkzr3zg | 2021-08-25 08:02:43 | 2021-08-25 08:11:57 | zhangyj | zhangyj | nova | 0 | NULL | compute03 | 3 | NULL | 7c6e79e3-2d94-40ba-b45f-087d559f12ee | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 10 | 0 | NULL | compute03 | 4 | NULL | 1 | NULL |
( r. Z9 }% i: |; h1 {, t| 2021-08-25 08:10:10 | 2021-08-25 08:37:55 | 2021-08-25 08:37:56 | 6 | NULL | b1ffbc1f84cf42c99a8e59fdaf7f1cf5 | 92a5a26fc14d418d881ade0ccbcffc59 | | | | 0 | NULL | NULL | 0 | deleted | 1024 | 1 | test8subnet | compute01 | NULL | r-xi06wdxe | 2021-08-25 08:10:46 | 2021-08-25 08:37:55 | test8subnet | NULL | nova | 0 | NULL | compute01 | 3 | NULL | bfabb27e-cf5a-4409-a464-5162dde24df1 | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 1 | 0 | 0 | 10 | 0 | NULL | compute01 | 6 | NULL | 1 | NULL |
9 A8 f) ^7 [; E| 2021-08-25 08:15:40 | 2021-08-25 08:21:25 | 2021-08-25 08:21:25 | 7 | NULL | b1ffbc1f84cf42c99a8e59fdaf7f1cf5 | 92a5a26fc14d418d881ade0ccbcffc59 | | | | 0 | NULL | NULL | 0 | deleted | 2048 | 1 | zhangyj1 | compute03 | NULL | r-sp42737c | 2021-08-25 08:16:11 | 2021-08-25 08:21:25 | zhangyj1 | NULL | nova | 0 | NULL | compute03 | 6 | NULL | 075e0dcb-8992-4a92-b1ad-ad09167e391d | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 1 | 0 | 0 | 20 | 0 | NULL | compute03 | 7 | NULL | 1 | NULL |3 M& M- u. m* L
| 2021-08-25 08:22:04 | 2021-08-25 08:24:16 | 2021-08-25 08:24:16 | 9 | NULL | b1ffbc1f84cf42c99a8e59fdaf7f1cf5 | 92a5a26fc14d418d881ade0ccbcffc59 | 96e683e6-18b5-4912-b9ad-2f3846bd931c | | | 0 | NULL | NULL | 0 | deleted | 1024 | 1 | zhangyj1 | compute03 | NULL | r-e4g5sj3u | 2021-08-25 08:22:29 | 2021-08-25 08:24:16 | zhangyj1 | zhangyj1 | nova | 0 | NULL | compute03 | 3 | NULL | 1ecefb25-d285-4d1b-9257-2960a765605e | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 10 | 0 | NULL | compute03 | 9 | NULL | 1 | NULL |$ D+ a) a5 {4 E$ b. Z u' i
| 2021-08-25 08:25:33 | 2021-08-25 08:33:26 | 2021-08-25 08:33:26 | 10 | NULL | b1ffbc1f84cf42c99a8e59fdaf7f1cf5 | 92a5a26fc14d418d881ade0ccbcffc59 | 96e683e6-18b5-4912-b9ad-2f3846bd931c | | | 0 | NULL | NULL | 0 | deleted | 1024 | 1 | zhangyj | compute03 | NULL | r-xnkibj5d | 2021-08-25 08:25:56 | 2021-08-25 08:33:26 | zhangyj | zhangyj | nova | 0 | NULL | compute03 | 3 | NULL | f3cfa018-51f3-4c00-a549-1cac5a4c4857 | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 10 | 0 | NULL | compute03 | 10 | NULL | 1 | NULL |
. B/ E6 z& O* H| 2021-08-25 08:34:22 | 2021-08-25 09:09:13 | 2021-08-25 09:09:13 | 13 | NULL | b1ffbc1f84cf42c99a8e59fdaf7f1cf5 | 92a5a26fc14d418d881ade0ccbcffc59 | 96e683e6-18b5-4912-b9ad-2f3846bd931c | | | 0 | NULL | NULL | 0 | deleted | 1024 | 1 | zhangyj | compute03 | NULL | r-103iot04 | 2021-08-25 08:59:43 | 2021-08-25 09:09:13 | zhangyj | zhangyj | nova | 0 | NULL | compute03 | 3 | NULL | 6269828d-fb8b-474c-81e1-2c13652a5892 | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 10 | 0 | NULL | compute03 | 13 | NULL | 1 | NULL |4 R( u7 O/ \4 i4 @+ Y
| 2021-08-25 09:12:15 | 2021-08-25 10:04:15 | 2021-08-25 10:04:15 | 15 | NULL | b1ffbc1f84cf42c99a8e59fdaf7f1cf5 | 92a5a26fc14d418d881ade0ccbcffc59 | 96e683e6-18b5-4912-b9ad-2f3846bd931c | | | 0 | NULL | NULL | 0 | deleted | 1024 | 1 | zhangyj | compute03 | NULL | r-6wb8qpjq | 2021-08-25 09:12:40 | 2021-08-25 10:04:14 | zhangyj | zhangyj | nova | 0 | NULL | compute03 | 3 | NULL | e1df84c5-f049-49fc-b7ae-885660ff2238 | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 10 | 0 | NULL | compute03 | 15 | NULL | 1 | NULL |, ]* N. R/ b0 f8 Y w+ L: [: Q
| 2021-08-26 01:27:07 | 2021-08-27 07:11:08 | 2021-08-27 07:11:08 | 21 | NULL | b1ffbc1f84cf42c99a8e59fdaf7f1cf5 | 92a5a26fc14d418d881ade0ccbcffc59 | 96e683e6-18b5-4912-b9ad-2f3846bd931c | | | 0 | NULL | NULL | 0 | deleted | 1024 | 1 | zhangyj | compute03 | NULL | r-ygnc68le | 2021-08-26 06:23:17 | 2021-08-27 07:11:08 | zhangyj | zhangyj | nova | 0 | NULL | compute03 | 3 | NULL | f8f4dfe7-ada7-4b25-94f4-5c00e414b0c8 | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 10 | 0 | NULL | compute03 | 21 | NULL | 1 | NULL |/ |+ C# T# V1 `2 H, s( s/ U R
| 2021-08-26 01:30:14 | 2021-08-27 07:10:50 | 2021-08-27 07:10:50 | 24 | NULL | b1ffbc1f84cf42c99a8e59fdaf7f1cf5 | 92a5a26fc14d418d881ade0ccbcffc59 | 96e683e6-18b5-4912-b9ad-2f3846bd931c | | | 0 | NULL | NULL | 0 | deleted | 1024 | 1 | zhangyj1 | compute01 | NULL | r-38rbbj0w | 2021-08-27 06:44:13 | 2021-08-27 07:10:50 | zhangyj2 | zhangyj1 | nova | 0 | NULL | compute01 | 3 | NULL | bd25efff-f97f-4576-a0ab-f4da6821cfce | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 10 | 0 | NULL | compute01 | 24 | NULL | 1 | NULL |
+ {8 v0 ?" Y$ ?3 d| 2021-08-27 07:11:59 | 2021-09-03 01:13:48 | NULL | 25 | NULL | b1ffbc1f84cf42c99a8e59fdaf7f1cf5 | 92a5a26fc14d418d881ade0ccbcffc59 | 96e683e6-18b5-4912-b9ad-2f3846bd931c | | | 0 | NULL | NULL | 1 | active | 1024 | 1 | zhangyj | compute01 | NULL | r-56pwl8q1 | 2021-08-27 07:12:25 | NULL | zhangyj1 | zhangyj | nova | 0 | NULL | compute01 | 3 | NULL | 590e3822-085b-4273-bce1-bf0e7a09b9f7 | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 10 | 0 | NULL | compute01 | 0 | NULL | 0 | NULL |
8 _$ s! i0 @. @7 ?5 i% X& I| 2021-08-30 08:55:34 | 2021-08-31 09:34:34 | NULL | 27 | NULL | b1ffbc1f84cf42c99a8e59fdaf7f1cf5 | 92a5a26fc14d418d881ade0ccbcffc59 | 96e683e6-18b5-4912-b9ad-2f3846bd931c | | | 0 | NULL | NULL | 1 | active | 1024 | 1 | zhangyj | compute01 | NULL | r-3jdx8v5m | 2021-08-31 09:34:33 | NULL | zhangyj2 | zhangyj | nova | 0 | NULL | compute03 | 3 | NULL | 347d5d2e-1516-41ef-b247-a42bc72e093c | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 10 | 0 | NULL | compute01 | 0 | NULL | 0 | NULL |1 s5 Q/ H4 m0 S- S0 W
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-------------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+
6 @ K, E$ j" |/ s* u12 rows in set (0.01 sec)
) ~9 e* @. @- |. u6 {5 m' z* hMariaDB [nova]> select * from instances where id="69088d55-eb76-4674-98fe-7909ba547674";+ h5 T6 |4 x/ V# n3 A3 i
Empty set (0.00 sec). T" b: y3 O( Y' e8 u
MariaDB [nova]> select id,vmstate,hostname,instance_type_id,uuid from instances;
4 J& W: w8 R5 S( _. u4 j0 dERROR 1054 (42S22): Unknown column 'vmstate' in 'field list'
1 J c. r+ w+ Z: c2 X2 `/ @MariaDB [nova]> select id,hostname,instance_type_id,uuid from instances;. D! e# \& k7 H" [/ v# [3 d
+----+-------------+------------------+--------------------------------------+
& g2 S* H+ ]& W- u# Z| id | hostname | instance_type_id | uuid |2 t- M/ n) l! V1 ~* x9 G" l
+----+-------------+------------------+--------------------------------------+
# u X" M; h- d| 2 | test1 | 3 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 |/ ]5 M! ?( _& b) X, K6 p9 x i6 y
| 4 | zhangyj | 3 | 7c6e79e3-2d94-40ba-b45f-087d559f12ee |
. ~; v0 S+ _9 T: U, y| 6 | test8subnet | 3 | bfabb27e-cf5a-4409-a464-5162dde24df1 |
/ t( E; ]' e, h4 i; B' Y| 7 | zhangyj1 | 6 | 075e0dcb-8992-4a92-b1ad-ad09167e391d |
- A9 ?6 y: l7 a( v) W6 E| 9 | zhangyj1 | 3 | 1ecefb25-d285-4d1b-9257-2960a765605e |
3 d3 Z2 R! P9 C4 |4 O6 J2 I| 10 | zhangyj | 3 | f3cfa018-51f3-4c00-a549-1cac5a4c4857 |- q! c. B5 v/ V' q; C Y) e# G
| 13 | zhangyj | 3 | 6269828d-fb8b-474c-81e1-2c13652a5892 |
n7 J F5 r: M& Q* c2 w| 15 | zhangyj | 3 | e1df84c5-f049-49fc-b7ae-885660ff2238 |7 q' \' `0 {1 u- q
| 21 | zhangyj | 3 | f8f4dfe7-ada7-4b25-94f4-5c00e414b0c8 |
" d. _! N, x; w# G& s4 n$ }- y| 24 | zhangyj1 | 3 | bd25efff-f97f-4576-a0ab-f4da6821cfce |0 d$ s. G. y# {; ~) e4 y+ `
| 25 | zhangyj | 3 | 590e3822-085b-4273-bce1-bf0e7a09b9f7 |
4 w [# O0 m2 Q6 b# `9 v8 \6 Z% Z+ l| 27 | zhangyj | 3 | 347d5d2e-1516-41ef-b247-a42bc72e093c |: u5 i d, T8 R
+----+-------------+------------------+--------------------------------------+
, }& H, g- ?* ~4 W12 rows in set (0.01 sec)/ @6 P6 h: H2 P& k) \; `- Q* q
MariaDB [nova]> select * from instances where uuid="69088d55-eb76-4674-98fe-7909ba547674";
6 ~3 q+ h; g7 u7 @' m/ b; [, ?Empty set (0.00 sec)& J# o {! o4 S2 s
MariaDB [nova]> select id,hostname,instance_type_id,uuid,deleted from instances;9 ?, C) }$ ?0 x) G
+----+-------------+------------------+--------------------------------------+---------+4 A1 ]! F8 C, L% I% T" p6 ]
| id | hostname | instance_type_id | uuid | deleted |
. d! h) _/ ]& G2 \& S* C+----+-------------+------------------+--------------------------------------+---------+2 y2 F1 |, m% V, e! }' s
| 2 | test1 | 3 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 | 2 |
) o& l" d! k- z$ d* I) y| 4 | zhangyj | 3 | 7c6e79e3-2d94-40ba-b45f-087d559f12ee | 4 |5 H- `, M+ `9 t k- }( c8 P9 s
| 6 | test8subnet | 3 | bfabb27e-cf5a-4409-a464-5162dde24df1 | 6 |
, k2 [5 a! G- G6 _% Q0 ~3 Z| 7 | zhangyj1 | 6 | 075e0dcb-8992-4a92-b1ad-ad09167e391d | 7 |+ N0 M6 J- L" O+ ]6 ?; D& o+ g
| 9 | zhangyj1 | 3 | 1ecefb25-d285-4d1b-9257-2960a765605e | 9 |' `. i. H8 k+ y K3 }+ M* w; W
| 10 | zhangyj | 3 | f3cfa018-51f3-4c00-a549-1cac5a4c4857 | 10 |6 q! I! _/ w4 t+ U) ^
| 13 | zhangyj | 3 | 6269828d-fb8b-474c-81e1-2c13652a5892 | 13 |, \, g+ ^2 I3 }# l$ _4 h! C
| 15 | zhangyj | 3 | e1df84c5-f049-49fc-b7ae-885660ff2238 | 15 |. C3 X& V# H- }1 c; Z+ q3 \$ V
| 21 | zhangyj | 3 | f8f4dfe7-ada7-4b25-94f4-5c00e414b0c8 | 21 |* ?8 {3 X# ?; I) k" X/ w- m
| 24 | zhangyj1 | 3 | bd25efff-f97f-4576-a0ab-f4da6821cfce | 24 | d% a! [; G0 c9 _ ]/ q. A* b
| 25 | zhangyj | 3 | 590e3822-085b-4273-bce1-bf0e7a09b9f7 | 0 |! {& n1 |* x0 n
| 27 | zhangyj | 3 | 347d5d2e-1516-41ef-b247-a42bc72e093c | 0 |7 @+ Y5 o! g' Z" n# b4 D! |$ N8 G
+----+-------------+------------------+--------------------------------------+---------+! C5 Q" J% Y9 l
12 rows in set (0.03 sec)5 e1 y2 j! Z" v: x3 {- |! W
MariaDB [nova]> select * from instances where display_name='test1';
7 w' h! m9 P0 T' q/ |! {5 a' c6 K+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+-----------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+----------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+
8 N% U7 f( A2 E$ f8 ?6 Y| created_at | updated_at | deleted_at | id | internal_id | user_id | project_id | image_ref | kernel_id | ramdisk_id | launch_index | key_name | key_data | power_state | vm_state | memory_mb | vcpus | hostname | host | user_data | reservation_id | launched_at | terminated_at | display_name | display_description | availability_zone | locked | os_type | launched_on | instance_type_id | vm_mode | uuid | architecture | root_device_name | access_ip_v4 | access_ip_v6 | config_drive | task_state | default_ephemeral_device | default_swap_device | progress | auto_disk_config | shutdown_terminate | disable_terminate | root_gb | ephemeral_gb | cell_name | node | deleted | locked_by | cleaned | ephemeral_key_uuid |# E% |. f0 q: A. O8 E% m* @
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+-----------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+----------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+
$ S( A& ^! _8 U, a| 2021-08-25 07:37:43 | 2021-09-07 03:02:01 | 2021-09-07 03:02:01 | 2 | NULL | b1ffbc1f84cf42c99a8e59fdaf7f1cf5 | 92a5a26fc14d418d881ade0ccbcffc59 | | | | 0 | NULL | NULL | 0 | deleted | 1024 | 1 | test1 | compute02 | NULL | r-uqofhf0v | 2021-08-31 03:10:00 | 2021-09-07 03:02:01 | test1 | NULL | nova | 0 | NULL | compute02 | 3 | NULL | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 1 | 0 | 0 | 10 | 0 | NULL | compute02 | 2 | NULL | 1 | NULL |
0 ?3 Y7 a4 w% D+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+-----------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+----------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+
- G! c% j. n, G4 X9 W1 row in set (0.01 sec)/ `0 t- x6 g. {% l8 o
MariaDB [nova]> select id,uuid from instances where display_name='test1';. C+ H$ Z6 L4 R& Q$ c+ A
+----+--------------------------------------+
: c1 t! E; P- N| id | uuid |
) [) {- k# T& O# ^& V+----+--------------------------------------+
3 s) t% K( E7 q! i# |) c| 2 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 |
( x( U9 X0 B2 d5 b' t% u/ U& l+----+--------------------------------------+
' |) d& J6 P" d; L6 c1 row in set (0.01 sec): r9 ?3 y9 H _0 q
MariaDB [nova]> select id,uuid,display_name from instances where display_name='test1';
; S/ G( C6 x8 h& d& J+----+--------------------------------------+--------------+
9 o- z% z! ?% ~8 l# X. S| id | uuid | display_name |4 l6 F1 `: N! h7 F
+----+--------------------------------------+--------------+4 o B1 ^3 j0 N$ P/ V7 a5 P
| 2 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 | test1 |
" ?% F7 _3 `4 A9 l1 B E+----+--------------------------------------+--------------+
2 D: v. Y# t# {7 O& S7 O6 ]) Q1 row in set (0.01 sec)
. t0 G- L/ g( C+ ~7 \+ {7 d! i
% y! P' a9 B9 Z# K# W数据库也无法查询到：0 ]" x9 [7 m- j5 T# P" }- [4 _
放弃吧，反正也不影响openstack平台使用：
1 j( l' `# q4 k8 B
& g1 ?6 ^0 C2 q! @5 n' Y7 N3 }$ i i/ i" g$ @* k
另外解锁下我们界面上看到的被锁虚机：# B. X X" f; y- A( v I& [4 c) R3 c
[root@controller1 ~]# openstack server unlock 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2/ Z. I$ c6 a( p) b- @
! D1 V# ~: u; \& E& y# _$ d9 T+ D8 S今天的处理就这么多
! W9 @4 e' b; R G5 o1 j: X5 P R |
|
/4 
|返回首页|Archiver|小黑屋|易陆发现技术论坛
( 蜀ICP备2026014127号-1 )
窥视卡
雷达卡
发表于 2021-9-7 11:29:33
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
照妖镜
楼主