|
|
[root@controller1 ~]# openstack compute service list 6 W2 n4 r, }% z H+ G1 m) K2 C* |
+----+------------------+-------------+----------+---------+-------+----------------------------+
' E& j! {/ l& w/ B) t9 N" {0 d1 h6 F: {| ID | Binary | Host | Zone | Status | State | Updated At |
! L) B; u! m) J2 u1 v: ^# N, k. z+----+------------------+-------------+----------+---------+-------+----------------------------+
b- C' }+ _ N' _! h: U9 n| 19 | nova-scheduler | controller2 | internal | enabled | down | 2021-09-07T02:31:45.000000 |% E( J; I+ m* k
| 22 | nova-scheduler | controller3 | internal | enabled | down | 2021-09-07T02:31:52.000000 |6 G/ j$ Z2 j. d/ U _. g
| 23 | nova-scheduler | controller1 | internal | enabled | down | 2021-09-07T02:31:49.000000 |4 h3 o! N! o) O( f: m
| 24 | nova-conductor | controller3 | internal | enabled | up | 2021-09-07T02:54:26.000000 |
4 L. o% p, v/ h4 F| 28 | nova-conductor | controller1 | internal | enabled | up | 2021-09-07T02:54:25.000000 |0 s8 T" a. v' q4 ^! M6 s
| 33 | nova-conductor | controller2 | internal | enabled | up | 2021-09-07T02:54:25.000000 |+ d9 W, P, W+ H! ~" w+ o4 W" w) ]7 A
| 34 | nova-consoleauth | controller2 | internal | enabled | down | 2021-09-07T02:31:40.000000 |
9 ~% o7 b3 u+ e. v5 l| 36 | nova-consoleauth | controller1 | internal | enabled | up | 2021-09-07T02:54:25.000000 |+ k# Q. G- _/ z- A+ s& `4 i' _
| 38 | nova-consoleauth | controller3 | internal | enabled | down | 2021-09-07T02:31:42.000000 |
# t U( Y/ {( [1 O' t3 ]| 42 | nova-compute | compute02 | nova | enabled | up | 2021-09-07T02:54:21.000000 |2 @# W' f: i0 [$ _0 a
| 43 | nova-compute | compute03 | nova | enabled | up | 2021-09-07T02:54:17.000000 |4 h! @$ o! o7 @; r% c, n* N: N/ C
| 45 | nova-compute | compute01 | nova | enabled | up | 2021-09-07T02:54:22.000000 |
' T! l3 c4 V; b* [2 U+----+------------------+-------------+----------+---------+-------+----------------------------+, J. o3 x' |6 g! p' \
" w9 w6 e2 V9 H' A2 d
删除虚机命令：
9 k% k* ^8 [5 c[root@controller1 ~]# openstack server delete 69088d55-eb76-4674-98fe-7909ba547674
0 `$ ?/ D" j; a' k2 PNo server with a name or ID of '69088d55-eb76-4674-98fe-7909ba547674' exists.
& M7 w( P) {" }$ n2 p9 l无法删除，头疼：5 r3 @) s2 K1 y' Y
[root@controller1 ~]# openstack server list
5 S" v! a' ^) @+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
1 Y0 j' H3 c: X( r+ {, ?" R. g| ID | Name | Status | Networks | Image | Flavor |( y6 y) |5 e; D
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
' P, ~9 u! y( w( @| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |
$ }, j- T6 x$ f" C: I| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |# `2 H% i4 S8 l
| 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 |
& I" R. V& W' d' T| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |
0 N6 k- j1 a& j- _+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+% G& m: G( `* A
+ M( z4 S! T: ^' d, k$ P, F1 M) ^
' U. Y2 M$ t+ V[root@controller1 ~]# openstack server delete 69088d55-eb76-4674-98fe-7909ba547674- c3 ^& n# K) @$ A( u: d2 F' M
No server with a name or ID of '69088d55-eb76-4674-98fe-7909ba547674' exists.$ ~9 r: J) X; n* ?
[root@controller1 ~]# 1 J$ e/ L, L* h+ J' s/ J3 h
还是删不掉：( D. {# M, Q1 i, N4 K! i
[root@controller1 ~]# openstack server list
# L2 ~; L5 e2 p8 J( v% G5 g+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
$ X7 s8 ~8 `' X4 b! U4 l6 ~| ID | Name | Status | Networks | Image | Flavor |# `- r$ j% O* m7 z: F X$ m5 a
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+ ~6 C$ I7 @+ O
| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |2 y3 r: ^+ l, Y- m! r) G' Y" h
| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |! y* f m: @' h! `; T) ~
| 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 |1 d0 y1 l! f. g7 z E
| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |# Y- _! `% E* Q6 b& q
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+: F. _- u, j: E$ p
[root@controller1 ~]# openstack server list 1 F) K7 f4 t$ D( O4 L, S
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+; ^. R/ D2 ]. E8 l. R+ G( V: @
| ID | Name | Status | Networks | Image | Flavor |
4 E, }# e. N$ I, L+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+; }0 v A" }) o" c6 ^: V
| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |
& e3 t5 R% U3 I1 g| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |( u1 b* Q' m4 h
| 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 |$ u: g* q9 F7 V. N
| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |% |- v% \/ V1 N0 `
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
' [4 ^' D- a& E% Z3 e( j1 D
% c5 i4 l! V0 V* |( Y# c[root@controller1 ~]# openstack server 8 J. P. [7 y8 W% T! }; O- t
add dump list reboot resize resume ssh unlock unshelve + G( h) y3 H) v6 v- \5 B+ R
backup event lock rebuild resize_confirm set start unpause # M* M3 J" b: r
create group migrate remove resize_revert shelve stop unrescue ( g# K6 V! y( w) K! v. M
delete image pause rescue restore show suspend unset - Z- ]1 C/ L" m1 F/ P
[root@controller1 ~]# openstack server
8 D- R& i+ D" `# ^add dump list reboot resize resume ssh unlock unshelve ! a2 m* B; k$ w* M' Q
backup event lock rebuild resize_confirm set start unpause 6 c6 r) G! n: v' J! G* D2 R
create group migrate remove resize_revert shelve stop unrescue
0 Z+ k0 l: S# i* o. xdelete image pause rescue restore show suspend unset
0 W" }' b) U9 z+ x3 w0 |& C; B, g, E; u# |2 w! z" S/ Y/ ]8 }6 B
也无法show：
% o$ `% N& H1 u5 N[root@controller1 ~]# openstack server show 69088d55-eb76-4674-98fe-7909ba547674- m9 @% f9 r1 @# u* q
No server with a name or ID of '69088d55-eb76-4674-98fe-7909ba547674' exists.) Z* P# ?% |( o: |' m8 M- }8 x& ?7 |
[root@controller1 ~]# openstack server list ) U2 ]) X% q- q' F& y6 C! E$ K
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+! u+ q( e4 [+ _" k8 ~7 o/ N
| ID | Name | Status | Networks | Image | Flavor |
: x# P. J1 @7 U: x+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
. `& h7 r8 s& q$ b| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |
! C$ U) c4 J8 c$ W: ]1 N7 n0 b| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |% ^0 n4 |5 r. B0 e& f9 d
| 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 R* j; m, e; Y0 g' s| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |
/ z* {/ {% C0 V) w# }7 l+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+7 y1 K, E7 Q0 s/ E( l3 t. v
' K' d; [5 |' O) W" M+ O- n, w+ i
上面的有问题，只能去数据库查看了：
2 w9 E1 i. [; N6 c# R y2 m. H
+ a% F3 k% k9 t- O& S+ u: H
' {7 Y5 D% q- g' o[root@controller1 ~]# openstack server list 6 j1 Y6 U8 J4 R H" ]
+--------------------------------------+----------+--------+----------------------+-------------------+----------------+! u7 b' U" J4 J- r7 r
| ID | Name | Status | Networks | Image | Flavor |
2 t8 q4 \7 p$ x+--------------------------------------+----------+--------+----------------------+-------------------+----------------+4 W# @ T3 H! e& h$ b
| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |
! e: X6 r3 Q6 F| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |
) e& t: x! M/ {( V| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |+ h P: |8 `; l2 |0 |* b5 }
+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
3 x8 @8 @2 c W: w @4 j( F[root@controller1 ~]# openstack server delete test1 - t/ d% t0 f c u8 I# A5 N
No server with a name or ID of 'test1' exists.
% S" a. @- b& |! c, J% W2 r[root@controller1 ~]#
) k$ l& W9 \ L; l0 ^( m3 m* L4 I
+ S: ]" w& W, P# Q[root@controller1 ~]# openstack server list
* L2 |2 J. L9 X+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
5 I9 |) x. l7 g| ID | Name | Status | Networks | Image | Flavor |
, p: V7 z: h% Z& d; |+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
* P6 K+ P7 K3 d* }, E6 F| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |
* k1 Z9 t$ K" D% t% {- U$ @| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |
7 g0 W& N8 E0 O# K- U| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |
y3 Q+ ~7 Y# X" u/ ^+--------------------------------------+----------+--------+----------------------+-------------------+----------------+5 [ M6 F* T0 ]3 D* ]6 v7 H
[root@controller1 ~]# mysql -u root -pdxFxylGX6K65rDh8hu2TWhWTKcIkZVZM6fEvmuW7 -h 192.168.6.233% h7 _* x) G% C
Welcome to the MariaDB monitor. Commands end with ; or \g.
" ]( L/ r$ Y; ^Your MariaDB connection id is 1669555$ r; b3 f+ F) q+ K" m
Server version: 10.1.20-MariaDB MariaDB Server& ^) ^% ]3 ]7 y' V: U. J& V
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.3 q! f* [/ j) s" ~
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
; _) E7 O+ Y# N7 V+ AMariaDB [(none)]> use nova
4 w" m |' V* `- z# H9 l- {: FReading table information for completion of table and column names, `& R* q) [- F4 K, ?# u
You can turn off this feature to get a quicker startup with -A
1 b8 t, v. ]$ t% M, Q7 QDatabase changed! `* d+ m7 W# l: _8 v
MariaDB [nova]> select * from in, K$ g- q2 B o j( y9 N
Display all 219 possibilities? (y or n)
* \& m; H) I. i+ o* @in_use instance_groups.created_at instance_types.root_gb
+ G2 [5 H8 I9 e4 ?" o0 Yinformation_schema instance_groups.deleted instance_types.rxtx_factor
' t7 v+ `9 R8 k0 h; Winjected instance_groups.deleted_at instance_types.swap, M0 o2 b# M9 Y) ]4 I6 z
instance_actions instance_groups.id instance_types.updated_at. E# ]! r& M7 m, F; J( e* \0 L
instance_actions.action instance_groups.name instance_types.vcpu_weight2 G5 ]& G5 E8 n) Q1 Z+ p1 T: {
instance_actions.created_at instance_groups.project_id instance_types.vcpus
. h# z9 Z% U9 \7 p3 |* tinstance_actions.deleted instance_groups.updated_at instance_uuid* Q) S v/ M. u3 \
instance_actions.deleted_at instance_groups.user_id instances; J2 }( f& u3 E* A, E) [& r( B# Q
instance_actions.finish_time instance_groups.uuid instances.access_ip_v41 F R& z8 t6 P, R) a- n
instance_actions.id instance_id instances.access_ip_v64 P, L8 p- E* y5 U; U
instance_actions.instance_uuid instance_id_mappings instances.architecture
$ W) S0 V0 q* p2 C# Ginstance_actions.message instance_id_mappings.created_at instances.auto_disk_config
9 t+ ]- x( w O$ V8 ?instance_actions.project_id instance_id_mappings.deleted instances.availability_zone
% U+ m$ i* m8 K% Dinstance_actions.request_id instance_id_mappings.deleted_at instances.cell_name- W% u* X9 H5 Q5 [& Q
instance_actions.start_time instance_id_mappings.id instances.cleaned7 f& V( s) n" D5 V
instance_actions.updated_at instance_id_mappings.updated_at instances.config_drive+ [. u" v( H8 o9 Z. L! ?+ i
instance_actions.user_id instance_id_mappings.uuid instances.created_at3 x+ a0 v1 a! F) d s) F* c
instance_actions_events instance_info_caches instances.default_ephemeral_device
8 ^# e: G4 U* m0 rinstance_actions_events.action_id instance_info_caches.created_at instances.default_swap_device! t6 ^& U5 P7 {
instance_actions_events.created_at instance_info_caches.deleted instances.deleted R, l0 l4 y# ^
instance_actions_events.deleted instance_info_caches.deleted_at instances.deleted_at* r% \7 Q# D1 g& V5 h3 u
instance_actions_events.deleted_at instance_info_caches.id instances.disable_terminate
, F. `6 E% O6 a! D6 `; M( ^instance_actions_events.details instance_info_caches.instance_uuid instances.display_description( ?) \8 K* j' ^ D( m0 Y
instance_actions_events.event instance_info_caches.network_info instances.display_name
# a/ e4 v* x* a: k4 [instance_actions_events.finish_time instance_info_caches.updated_at instances.ephemeral_gb$ X" `7 D$ u9 m3 c4 n5 E
instance_actions_events.host instance_metadata instances.ephemeral_key_uuid
( @7 A0 J- W" T! hinstance_actions_events.id instance_metadata.created_at instances.host
$ Q" I4 y' F/ P1 S: [instance_actions_events.result instance_metadata.deleted instances.hostname
+ J1 n: M* ~6 D% k, vinstance_actions_events.start_time instance_metadata.deleted_at instances.id
" T, i! T8 P* s3 i6 M: T7 G0 M4 [instance_actions_events.traceback instance_metadata.id instances.image_ref
7 @0 ]/ Q! P7 Y w; Finstance_actions_events.updated_at instance_metadata.instance_uuid instances.instance_type_id
! k% v; u, D. g NMariaDB [nova]> select * from instance
! n! j! W: j- C' U- S1 c* iDisplay all 203 possibilities? (y or n)
! }' {" L% n2 DMariaDB [nova]> select * from instance;
: M. W0 ]3 W6 h" ?( C: P4 XERROR 1146 (42S02): Table 'nova.instance' doesn't exist m8 M) Y1 s5 t. M5 H: p
MariaDB [nova]> select * from instance;7 p6 J) P* m+ K* J3 R1 A4 B
ERROR 1146 (42S02): Table 'nova.instance' doesn't exist5 b. F! A# |* }( {3 Q/ R
MariaDB [nova]> select * from instance;
3 J1 W H- n# [& Y) t, y8 pDisplay all 203 possibilities? (y or n)
7 K4 Y, |9 A h7 Zinstance_actions instance_group_policy.updated_at instance_types.disabled
" t$ |+ j0 Q0 ]& Y+ U' Z3 ~instance_actions.action instance_groups instance_types.ephemeral_gb
& B0 N3 m" {1 q# @3 m& }' H1 Ninstance_actions.created_at instance_groups.created_at instance_types.flavorid
& B. S e% u- G2 u% X5 a9 Xinstance_actions.deleted instance_groups.deleted instance_types.id
! }- A: ?; X7 h: j6 q+ einstance_actions.deleted_at instance_groups.deleted_at instance_types.is_public9 F* b2 J: d. A: x Q, ^
instance_actions.finish_time instance_groups.id instance_types.memory_mb% l1 w8 i" Y5 L6 t1 `1 a9 P# W
instance_actions.id instance_groups.name instance_types.name
3 _) C6 Q; j; S! j* Ainstance_actions.instance_uuid instance_groups.project_id instance_types.root_gb( y- w$ x4 i# |
instance_actions.message instance_groups.updated_at instance_types.rxtx_factor
( c' j/ _* j. O& R; g+ L# kinstance_actions.project_id instance_groups.user_id instance_types.swap
. r& c3 G3 X$ ]; W- h, G3 R+ v' yinstance_actions.request_id instance_groups.uuid instance_types.updated_at
; V6 @; o+ p, }- C" G% i, kinstance_actions.start_time instance_id instance_types.vcpu_weight, B1 Q. m$ d+ r: Y
instance_actions.updated_at instance_id_mappings instance_types.vcpus0 C0 L- U; T0 o) _) N" o
instance_actions.user_id instance_id_mappings.created_at instance_uuid- f7 C4 g! m) l1 E* k
instance_actions_events instance_id_mappings.deleted instances D6 }/ R8 H) U) d
instance_actions_events.action_id instance_id_mappings.deleted_at instances.access_ip_v48 @- |0 W7 M' p/ p
instance_actions_events.created_at instance_id_mappings.id instances.access_ip_v68 r$ ?* m& u' C, `: a, ^
instance_actions_events.deleted instance_id_mappings.updated_at instances.architecture
+ b- G* F0 Z( P- U1 K! \instance_actions_events.deleted_at instance_id_mappings.uuid instances.auto_disk_config+ m3 N5 P5 X) q" s* _8 D- Q
instance_actions_events.details instance_info_caches instances.availability_zone
# Q' F% ^5 w8 R" i: |, H5 \instance_actions_events.event instance_info_caches.created_at instances.cell_name( P1 t2 O% ^) X7 {6 F; a4 T
instance_actions_events.finish_time instance_info_caches.deleted instances.cleaned
- p+ I; Y6 H! |0 _9 k* i. C$ iinstance_actions_events.host instance_info_caches.deleted_at instances.config_drive
5 ~1 L" K9 {3 \instance_actions_events.id instance_info_caches.id instances.created_at
]0 }# d" D3 W$ y1 P3 Yinstance_actions_events.result instance_info_caches.instance_uuid instances.default_ephemeral_device4 P0 @( ^( ^, @+ N+ d8 ^/ C9 Z$ M
instance_actions_events.start_time instance_info_caches.network_info instances.default_swap_device
# A8 s; z! Y9 [0 S7 j5 p. }+ N2 `instance_actions_events.traceback instance_info_caches.updated_at instances.deleted) W% v2 t, b B: u* r
instance_actions_events.updated_at instance_metadata instances.deleted_at' ^$ e7 i* q6 Y" Z
instance_extra instance_metadata.created_at instances.disable_terminate# T( H0 `7 _1 Q8 A3 ^5 P: E
instance_extra.created_at instance_metadata.deleted instances.display_description
4 B3 }$ c- E {( c( uinstance_extra.deleted instance_metadata.deleted_at instances.display_name, I' |- A- A5 P# C4 B% D+ y! \$ C: Y
MariaDB [nova]> select * from instances;2 _" C2 x/ H: w3 `8 T4 J. O6 C/ q
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-------------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+3 U% i7 y* D8 a4 ?9 w# S; r' D( x! F
| 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 |
' v+ s; a/ A _) `/ U+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-------------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+2 g- d X: T( I* v! t# v
| 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 |$ k; {& n' A: e6 X- A) \$ b. }6 w
| 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 |5 p* V" G" A; G$ T+ C
| 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 |
5 M: y! M& b, Y5 u. v- N| 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 |
6 J% d8 t9 M1 Y: H: y O2 p$ b| 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 |
) W" A0 i, L, ~| 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 |
( R `1 _# n5 B0 b| 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 |
5 W, z$ c' D% N7 A( ?5 h8 z% z5 w| 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 |; ]3 F- C+ Y, _
| 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 | O& d$ V0 O& H) _) X: o
| 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 |# s+ I" r5 x7 _, b- d1 n
| 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 |3 E! i5 h7 |2 B$ U9 Z
| 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 |
5 u, u2 A4 J% v1 s U/ g5 n. t+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-------------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+
7 l: j4 v- X0 U! l. ~. h( C12 rows in set (0.01 sec)
% U% k! }4 z% V1 g( E* `MariaDB [nova]> select * from instances where id="69088d55-eb76-4674-98fe-7909ba547674";
% G% T: C- X7 ~- ?0 v: U7 hEmpty set (0.00 sec)
) R5 @( ]4 I2 d1 X- |0 S1 hMariaDB [nova]> select id,vmstate,hostname,instance_type_id,uuid from instances;
A, k, z3 ^* O2 H) Q5 QERROR 1054 (42S22): Unknown column 'vmstate' in 'field list'* w* i+ n! i0 A) w6 N e
MariaDB [nova]> select id,hostname,instance_type_id,uuid from instances;- M. j* w# F2 H8 O
+----+-------------+------------------+--------------------------------------+8 O- ]) [1 g8 _5 y
| id | hostname | instance_type_id | uuid |3 A6 M' H( z2 G' t$ g+ f% x
+----+-------------+------------------+--------------------------------------+
1 U3 ^3 R0 S6 y3 D$ E| 2 | test1 | 3 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 |
' D0 W* c) _/ L# L" t8 i| 4 | zhangyj | 3 | 7c6e79e3-2d94-40ba-b45f-087d559f12ee |8 z7 [* w$ i1 C2 w
| 6 | test8subnet | 3 | bfabb27e-cf5a-4409-a464-5162dde24df1 |/ j/ r- g" B9 Y) g
| 7 | zhangyj1 | 6 | 075e0dcb-8992-4a92-b1ad-ad09167e391d |' X! m+ w- ?+ ^! B# I: i. {! c
| 9 | zhangyj1 | 3 | 1ecefb25-d285-4d1b-9257-2960a765605e |
' L6 H* O$ G% T6 w0 p) |& p/ w$ N* y" M| 10 | zhangyj | 3 | f3cfa018-51f3-4c00-a549-1cac5a4c4857 |
7 j( Y# ^5 E3 S" S| 13 | zhangyj | 3 | 6269828d-fb8b-474c-81e1-2c13652a5892 |
3 y# L/ s; o( {3 r. J8 z( J& v| 15 | zhangyj | 3 | e1df84c5-f049-49fc-b7ae-885660ff2238 |
9 ?( N- {% s8 x8 E. g| 21 | zhangyj | 3 | f8f4dfe7-ada7-4b25-94f4-5c00e414b0c8 |' K( r" z5 V& J% o( H
| 24 | zhangyj1 | 3 | bd25efff-f97f-4576-a0ab-f4da6821cfce |
2 V/ Z2 _7 `& h| 25 | zhangyj | 3 | 590e3822-085b-4273-bce1-bf0e7a09b9f7 |' O0 I0 Q* B3 ?
| 27 | zhangyj | 3 | 347d5d2e-1516-41ef-b247-a42bc72e093c |2 ~. X: ]+ S' ]
+----+-------------+------------------+--------------------------------------+
2 F( e% T0 J5 B- n9 L$ T/ D12 rows in set (0.01 sec)7 U3 i3 D+ H( z
MariaDB [nova]> select * from instances where uuid="69088d55-eb76-4674-98fe-7909ba547674";
, b) h: @, N& o4 bEmpty set (0.00 sec): @, T1 H3 h2 B" Q8 o6 {
MariaDB [nova]> select id,hostname,instance_type_id,uuid,deleted from instances;3 o2 F& O8 O1 T: Z, o) _4 k
+----+-------------+------------------+--------------------------------------+---------+! W1 R& k0 v( A0 |. g8 H( X
| id | hostname | instance_type_id | uuid | deleted |
! {$ H' e' V4 |+----+-------------+------------------+--------------------------------------+---------+
' R" U0 [7 T2 z4 ^& r3 || 2 | test1 | 3 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 | 2 |, n1 k( B. @/ p! F, e! [
| 4 | zhangyj | 3 | 7c6e79e3-2d94-40ba-b45f-087d559f12ee | 4 |
. r7 z: R7 X) K" F| 6 | test8subnet | 3 | bfabb27e-cf5a-4409-a464-5162dde24df1 | 6 |
4 C. [* O4 k+ C e| 7 | zhangyj1 | 6 | 075e0dcb-8992-4a92-b1ad-ad09167e391d | 7 |
+ ]& f" Z$ n7 j6 B7 X| 9 | zhangyj1 | 3 | 1ecefb25-d285-4d1b-9257-2960a765605e | 9 |0 A! h- t4 G8 o# }0 O" Z8 y
| 10 | zhangyj | 3 | f3cfa018-51f3-4c00-a549-1cac5a4c4857 | 10 |" }+ k* K6 |- O Q
| 13 | zhangyj | 3 | 6269828d-fb8b-474c-81e1-2c13652a5892 | 13 |
% E3 l+ ]6 x* b& c* p R| 15 | zhangyj | 3 | e1df84c5-f049-49fc-b7ae-885660ff2238 | 15 |8 \' ~, }. t3 w o
| 21 | zhangyj | 3 | f8f4dfe7-ada7-4b25-94f4-5c00e414b0c8 | 21 |
, H3 ~+ ^4 a/ N2 K6 M& h3 K+ ~( F| 24 | zhangyj1 | 3 | bd25efff-f97f-4576-a0ab-f4da6821cfce | 24 |! J) X2 D8 g2 Z6 R$ k
| 25 | zhangyj | 3 | 590e3822-085b-4273-bce1-bf0e7a09b9f7 | 0 |
. w/ q( f, m( p' D9 r1 F G- Q| 27 | zhangyj | 3 | 347d5d2e-1516-41ef-b247-a42bc72e093c | 0 |
u. T _ D6 ?0 `- T7 W1 }+----+-------------+------------------+--------------------------------------+---------+, J" g: x& Q+ R, `
12 rows in set (0.03 sec)0 G" ]- Q. U9 H8 {* E5 Z4 z
MariaDB [nova]> select * from instances where display_name='test1';4 U% U1 Z( v' Q v
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+-----------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+----------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+
8 n4 w$ T2 @7 I9 Z* 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 |
: e7 v2 a+ M8 F, d" K+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+-----------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+----------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+5 C; c& R; m; D
| 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 |$ l! P9 D, h! f' q9 e
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+-----------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+----------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+5 t f4 N+ o0 w' c1 s" ]* x4 a
1 row in set (0.01 sec)
3 h+ d+ q9 T5 C* _6 i) TMariaDB [nova]> select id,uuid from instances where display_name='test1';
7 z7 _- z) t6 J; }+ S* y+----+--------------------------------------+
$ c! v# u( N8 _. \ N6 |2 Y! c+ \| id | uuid |; K4 i6 o8 r9 q I
+----+--------------------------------------+
1 k8 V8 z9 ^8 p- d0 H1 _| 2 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 |
4 B3 J5 g9 y5 ]9 j) K! I! u+----+--------------------------------------+
+ j$ [+ P0 j; Z1 C5 R- h! ?6 G+ D1 row in set (0.01 sec): h* C9 A& t* P4 P2 ~; J
MariaDB [nova]> select id,uuid,display_name from instances where display_name='test1';
+ L! w" X0 f# D8 }! T+----+--------------------------------------+--------------+
3 k- [) U3 l2 H( @+ ~| id | uuid | display_name |
& T3 v4 u% K7 I6 R8 i. C8 Z+----+--------------------------------------+--------------+( {* a! D; P) X, f) @
| 2 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 | test1 |* ]. w; y- }/ f" w9 o
+----+--------------------------------------+--------------+
2 E$ t8 h$ J, ^1 row in set (0.01 sec)- F# Z% b3 R% m# Q B+ K3 n: R
0 E# z2 U5 x9 U) F数据库也无法查询到：& L4 F/ X- z+ M. i7 G- m# F2 a
放弃吧，反正也不影响openstack平台使用：
5 J/ N" k% ?' }2 b$ m
" e: [3 e0 J4 Q% D4 M0 \7 C! E2 P, y3 L( h8 [4 }
另外解锁下我们界面上看到的被锁虚机：
! I) }5 u3 I0 n# x3 G[root@controller1 ~]# openstack server unlock 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2! u! a: h, \7 }
9 X% h W3 ]2 v今天的处理就这么多+ ^5 K4 W$ H; N5 o
|
|
发表于 2021-9-7 11:29:33