|
|
[root@controller1 ~]# openstack compute service list 8 X7 ?# `3 Q4 M* G; L T) S
+----+------------------+-------------+----------+---------+-------+----------------------------+
' C3 [& H5 g8 I9 m3 _| ID | Binary | Host | Zone | Status | State | Updated At |
- v" d& h2 X/ e" W, h4 E+----+------------------+-------------+----------+---------+-------+----------------------------+& V F! @9 |( G
| 19 | nova-scheduler | controller2 | internal | enabled | down | 2021-09-07T02:31:45.000000 |& Y- S2 J v$ F6 M" i, I T
| 22 | nova-scheduler | controller3 | internal | enabled | down | 2021-09-07T02:31:52.000000 |+ c$ `8 ~1 g4 E' P# X
| 23 | nova-scheduler | controller1 | internal | enabled | down | 2021-09-07T02:31:49.000000 |8 I+ u$ L7 G5 w4 n2 J7 S6 W
| 24 | nova-conductor | controller3 | internal | enabled | up | 2021-09-07T02:54:26.000000 |- G3 {$ C, V$ S6 {$ _0 u B% r
| 28 | nova-conductor | controller1 | internal | enabled | up | 2021-09-07T02:54:25.000000 |
3 D! s" W; _$ p0 N0 H7 V| 33 | nova-conductor | controller2 | internal | enabled | up | 2021-09-07T02:54:25.000000 |
/ h( V/ k+ w4 |& _2 B; R( w| 34 | nova-consoleauth | controller2 | internal | enabled | down | 2021-09-07T02:31:40.000000 |( s7 Z1 k7 _5 J# z) _2 b+ D
| 36 | nova-consoleauth | controller1 | internal | enabled | up | 2021-09-07T02:54:25.000000 |* ?. m+ [2 H; R, X, T
| 38 | nova-consoleauth | controller3 | internal | enabled | down | 2021-09-07T02:31:42.000000 |
- y3 o0 r2 |' v7 x* V! k8 M! n; T1 i| 42 | nova-compute | compute02 | nova | enabled | up | 2021-09-07T02:54:21.000000 |8 @/ {1 E5 }5 U: G0 ~9 F
| 43 | nova-compute | compute03 | nova | enabled | up | 2021-09-07T02:54:17.000000 |
( |2 _6 [4 F0 U& c( W( b8 T| 45 | nova-compute | compute01 | nova | enabled | up | 2021-09-07T02:54:22.000000 |
: t- v. J. \' ~) `+----+------------------+-------------+----------+---------+-------+----------------------------+. L" z A/ R2 v
* A! L) p; z1 \% h7 s
删除虚机命令：
3 r* x4 t% {1 [$ s m5 O[root@controller1 ~]# openstack server delete 69088d55-eb76-4674-98fe-7909ba5476743 q; T% O6 J8 W+ O/ \! G5 V
No server with a name or ID of '69088d55-eb76-4674-98fe-7909ba547674' exists.8 \' }" U8 Y9 n% }
无法删除，头疼：+ a% w4 t& I: C8 r- `/ P; v. L
[root@controller1 ~]# openstack server list
. D9 O2 q0 C3 L; ^3 T+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+7 U8 i3 y- |0 {+ Y3 w. s% }
| ID | Name | Status | Networks | Image | Flavor |
6 d. a9 ~1 a5 C5 T, D+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
( E4 d% e6 z0 g9 _| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |# n" a- Q; O, n3 s( Z1 h
| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g | v- o- I0 {7 r F" 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 |
/ g0 w; B# X c; X| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |
E8 w$ C/ N- ]" k2 u+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+& n0 J& W, x. ~
8 Z( {- y5 _3 ]5 E* E
% Q# j: ]( o: `: x. D[root@controller1 ~]# openstack server delete 69088d55-eb76-4674-98fe-7909ba547674
; D5 |0 f- z0 j& `5 l8 d1 WNo server with a name or ID of '69088d55-eb76-4674-98fe-7909ba547674' exists.1 p8 V# i4 X3 _
[root@controller1 ~]#
7 I2 v4 j5 R9 S5 Q还是删不掉：
! R( h6 r7 R- r2 [[root@controller1 ~]# openstack server list
5 A6 M2 h+ e0 [- Z$ F; t% |# Z+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+9 a8 l9 K9 @3 _* Z& z: I' ?; M
| ID | Name | Status | Networks | Image | Flavor |; j u3 S6 o* F# ?! U
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
2 d5 ]2 O+ ]: X7 V) `0 H1 J| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |! x4 ?% k; n7 \/ O" t) g: D, {0 U' L. `
| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |' a! I8 q7 z; L: R
| 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 |( v" B; ?, c/ C$ q
| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |; S' p* ]5 S5 f! Y5 f6 z/ |
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+3 p6 ?* P5 i8 M" h
[root@controller1 ~]# openstack server list
$ B2 s! Y) m9 `' \+ s# e, P- U* \+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
7 U) J! r5 q$ O, `2 v; |. A| ID | Name | Status | Networks | Image | Flavor |9 Z6 R. r( R* T; \- ]
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+' T. N1 J ?& i6 T9 ?
| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |
' O3 k1 Q R. T. a. M4 w| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |
4 Z7 o7 [+ C7 P# 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 |2 J, S6 f$ |! Y
| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |, q( Z) T4 \4 J, M
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
( X& e+ S, P9 T6 a) R! V" ~8 r
6 H0 W, y0 h/ D' N7 l7 A[root@controller1 ~]# openstack server
( m$ X4 ^( R7 m* b, V ]3 Wadd dump list reboot resize resume ssh unlock unshelve / L W. `8 k& Q9 i4 o
backup event lock rebuild resize_confirm set start unpause / h; t/ ~. O9 ]6 J3 g% s1 H
create group migrate remove resize_revert shelve stop unrescue 7 ^, ^ ?7 z* r& _: G+ ?
delete image pause rescue restore show suspend unset + w: h6 r; Z+ W- o
[root@controller1 ~]# openstack server % |( d9 W. j6 S, p4 ]; p( c
add dump list reboot resize resume ssh unlock unshelve
, u- M; {+ g( g. o& q! W ^backup event lock rebuild resize_confirm set start unpause ' ]7 I# {9 H* C9 k2 ?# O7 L& f
create group migrate remove resize_revert shelve stop unrescue
' Z9 @, {9 O" _. g& r" Q) L; Hdelete image pause rescue restore show suspend unset g/ j$ J+ M/ w& d( l& S) k+ @1 C, |
% J& F" s' \1 P6 q
也无法show：- ~ [% s; X" T
[root@controller1 ~]# openstack server show 69088d55-eb76-4674-98fe-7909ba5476748 N# R6 y& ~! T7 }6 O
No server with a name or ID of '69088d55-eb76-4674-98fe-7909ba547674' exists.+ m' P7 `1 L7 ?# o1 Q3 ^/ \$ T6 {
[root@controller1 ~]# openstack server list
& H e! ]& }5 W$ t# I: Q+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
1 v2 G6 ^" g2 i# g| ID | Name | Status | Networks | Image | Flavor |% K2 X+ j! s6 A8 i
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------++ Q8 K: k6 y2 D9 |
| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |# o' |9 b: `5 C' ]) k% |' F" ]- L' W
| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |- g( |& r, w/ H5 q3 ~. 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 r! {( }' O! E" u# U# @! r| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |; D5 d/ h( d1 }
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+* g0 s! n( ~4 n# T; K/ [5 H2 _
8 @8 [7 u3 d5 \$ _+ x上面的有问题，只能去数据库查看了：
6 m+ Q- h4 M& ~
- M$ j. c8 d5 O+ O: @) K
3 V; Y% Y" V" Q) P[root@controller1 ~]# openstack server list ; M T& e5 E1 ? w
+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
4 S2 ^! o& q7 x( O+ [| ID | Name | Status | Networks | Image | Flavor |" m6 D% A" t' Z- R3 ~
+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
5 y% R2 g, j ]| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |
" H+ y7 k- \" u `) f% D( m: K| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |4 U/ u- h) ~" q# N4 |
| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |9 B; _# o$ R4 S4 n q
+--------------------------------------+----------+--------+----------------------+-------------------+----------------+" J& G+ P5 b1 p" G8 |3 R9 M" J: `
[root@controller1 ~]# openstack server delete test1
+ l: I. t/ L+ D |; O- Y0 mNo server with a name or ID of 'test1' exists.& R2 @& F3 h, s4 \; E7 B9 J9 \ A
[root@controller1 ~]# " {: X' e( C1 v! i, o4 q4 E+ j1 v
# ?/ V6 ^1 Q9 l- y* U3 k6 J
[root@controller1 ~]# openstack server list * _; ^& c. R6 k5 Q3 s r: ^! s
+--------------------------------------+----------+--------+----------------------+-------------------+----------------+: Y. P$ @- u: r0 B; V$ O
| ID | Name | Status | Networks | Image | Flavor |
' k( a3 { ]# k# n B; `% |+--------------------------------------+----------+--------+----------------------+-------------------+----------------+. ^3 w2 b0 p1 T7 v e2 ~
| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |; {) i; T7 a% h
| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |
6 T; F# P D) C| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |
8 m, W& C" D; }3 T0 R" D4 ^+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
7 D7 @% \) z' K {6 a/ z( W, J+ ^[root@controller1 ~]# mysql -u root -pdxFxylGX6K65rDh8hu2TWhWTKcIkZVZM6fEvmuW7 -h 192.168.6.2335 G( \; s3 @& \. L
Welcome to the MariaDB monitor. Commands end with ; or \g.
7 B, H8 P2 c+ U, `, T% W! s% Y/ wYour MariaDB connection id is 1669555
+ m: g/ e3 d( hServer version: 10.1.20-MariaDB MariaDB Server+ J1 |9 Q/ K; m
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
; ?$ q2 w$ C( d. s7 d) b2 BType 'help;' or '\h' for help. Type '\c' to clear the current input statement.
3 U( q/ U) d% H1 \. P/ G2 B* JMariaDB [(none)]> use nova
5 \& R4 m# i8 C) KReading table information for completion of table and column names; R- @; a+ L4 Y& c' k; v
You can turn off this feature to get a quicker startup with -A
/ H0 e- _/ X H n9 {6 _/ x) qDatabase changed
3 f' K1 n" ]. VMariaDB [nova]> select * from in: l9 j4 s+ K/ _0 d% E
Display all 219 possibilities? (y or n)
}$ Z1 m3 w/ B+ d" nin_use instance_groups.created_at instance_types.root_gb- g+ |4 V, r& M" s- Z, K3 c* u
information_schema instance_groups.deleted instance_types.rxtx_factor
& ]6 b0 v) h( {, X* v8 zinjected instance_groups.deleted_at instance_types.swap
" j; m' l! r; [ \6 sinstance_actions instance_groups.id instance_types.updated_at
" V" g/ K# a ~instance_actions.action instance_groups.name instance_types.vcpu_weight
1 R' g$ s) ?! A4 ?0 vinstance_actions.created_at instance_groups.project_id instance_types.vcpus
9 i% v/ @# Z9 o' o5 [& O; l* Qinstance_actions.deleted instance_groups.updated_at instance_uuid
% A' k0 R y5 S. z! f$ vinstance_actions.deleted_at instance_groups.user_id instances: t1 y6 [! q7 I* y4 J3 c" H9 N) {
instance_actions.finish_time instance_groups.uuid instances.access_ip_v4" t( r! ?6 U+ x* N1 P$ M
instance_actions.id instance_id instances.access_ip_v68 E- S, ^* `! r# Z ]: } H7 v
instance_actions.instance_uuid instance_id_mappings instances.architecture6 n8 o1 g! ?8 o W9 v
instance_actions.message instance_id_mappings.created_at instances.auto_disk_config
: R& N# e7 F% Kinstance_actions.project_id instance_id_mappings.deleted instances.availability_zone
9 T% A) D; {, K# V8 P5 binstance_actions.request_id instance_id_mappings.deleted_at instances.cell_name
B6 [; u; j' U$ Linstance_actions.start_time instance_id_mappings.id instances.cleaned$ P( g1 l0 f' i0 h! P& d- [( i
instance_actions.updated_at instance_id_mappings.updated_at instances.config_drive* U0 B3 Q; g# o: \3 s" \
instance_actions.user_id instance_id_mappings.uuid instances.created_at7 V: Z8 ~1 [' c" m- t3 ? L
instance_actions_events instance_info_caches instances.default_ephemeral_device
2 q3 A2 F) e; ?7 e8 ?5 V2 Qinstance_actions_events.action_id instance_info_caches.created_at instances.default_swap_device
1 f6 \. _ a* b8 S( s& xinstance_actions_events.created_at instance_info_caches.deleted instances.deleted( [" |- N' n, ]3 E8 @: a6 w
instance_actions_events.deleted instance_info_caches.deleted_at instances.deleted_at
" \2 U( A9 Y+ t/ F0 p2 s2 n: Ainstance_actions_events.deleted_at instance_info_caches.id instances.disable_terminate
! R! k% D/ E$ \( ]instance_actions_events.details instance_info_caches.instance_uuid instances.display_description4 V/ V/ V0 L, L2 R2 _9 g+ \
instance_actions_events.event instance_info_caches.network_info instances.display_name
7 M/ r- c/ o3 Cinstance_actions_events.finish_time instance_info_caches.updated_at instances.ephemeral_gb
' ?. e: P. c4 f4 I4 @" zinstance_actions_events.host instance_metadata instances.ephemeral_key_uuid
5 ?1 g' u- p; d7 V ~+ zinstance_actions_events.id instance_metadata.created_at instances.host
& f0 v8 i6 w2 u/ d/ {- a9 [% ainstance_actions_events.result instance_metadata.deleted instances.hostname4 z, f b _- }$ M' ~: R7 K
instance_actions_events.start_time instance_metadata.deleted_at instances.id
A, o% W" O/ ginstance_actions_events.traceback instance_metadata.id instances.image_ref! Z3 U; @1 b8 |* U% m; O9 C |
instance_actions_events.updated_at instance_metadata.instance_uuid instances.instance_type_id
! |$ t- [+ ^# r8 RMariaDB [nova]> select * from instance
3 Z* F( E! w- d; o$ eDisplay all 203 possibilities? (y or n)$ H/ H5 e& v5 @# U
MariaDB [nova]> select * from instance;# l. a: H. Z$ H9 c
ERROR 1146 (42S02): Table 'nova.instance' doesn't exist9 h' h( C' ]2 f p+ f
MariaDB [nova]> select * from instance;
+ j) J. j5 s% |, x# B' {ERROR 1146 (42S02): Table 'nova.instance' doesn't exist ~( z: `/ t+ j
MariaDB [nova]> select * from instance;
6 ]- u( X2 R8 pDisplay all 203 possibilities? (y or n)8 }# E' n3 _; U
instance_actions instance_group_policy.updated_at instance_types.disabled
9 y6 {) k9 S0 N5 Yinstance_actions.action instance_groups instance_types.ephemeral_gb0 F/ S) S. i" ^! M+ S Z
instance_actions.created_at instance_groups.created_at instance_types.flavorid$ |) W! P+ Y( ]7 G: e5 R7 q
instance_actions.deleted instance_groups.deleted instance_types.id
$ v: p% s1 J* S1 C' y( Q6 Z& S' W4 Yinstance_actions.deleted_at instance_groups.deleted_at instance_types.is_public8 P8 r5 K2 l" A7 m# u
instance_actions.finish_time instance_groups.id instance_types.memory_mb
H/ C" Z1 u3 Einstance_actions.id instance_groups.name instance_types.name
2 L; _' ?' c/ Z4 Q5 Y# D& linstance_actions.instance_uuid instance_groups.project_id instance_types.root_gb- R1 `8 z$ D8 |* m# y
instance_actions.message instance_groups.updated_at instance_types.rxtx_factor
" X0 u- j; D" g. oinstance_actions.project_id instance_groups.user_id instance_types.swap
3 x1 y' M* @9 Z7 r. i% Y4 cinstance_actions.request_id instance_groups.uuid instance_types.updated_at
9 Z' x4 C1 b- u% E0 V4 k; einstance_actions.start_time instance_id instance_types.vcpu_weight
8 A2 o$ b! F, d( F/ A( W7 `instance_actions.updated_at instance_id_mappings instance_types.vcpus! L) Y6 p. Y8 M1 D, f) s6 T
instance_actions.user_id instance_id_mappings.created_at instance_uuid- r7 ?1 y7 w6 a8 t
instance_actions_events instance_id_mappings.deleted instances
- e0 Q R$ T5 M- W& L9 Pinstance_actions_events.action_id instance_id_mappings.deleted_at instances.access_ip_v4' ]0 d0 r0 T W3 J% ]% z
instance_actions_events.created_at instance_id_mappings.id instances.access_ip_v6
" e& \* }$ @& ?instance_actions_events.deleted instance_id_mappings.updated_at instances.architecture
; H8 V. O, J) [' ~( C+ G1 L( o( U7 }1 Ninstance_actions_events.deleted_at instance_id_mappings.uuid instances.auto_disk_config
. |0 a; I2 r& U% H: I! z2 Winstance_actions_events.details instance_info_caches instances.availability_zone5 f' F: |, [" U3 ~* X; x
instance_actions_events.event instance_info_caches.created_at instances.cell_name
8 J2 U0 u8 P% J# a* F2 c! C1 Y/ x5 Minstance_actions_events.finish_time instance_info_caches.deleted instances.cleaned
( r7 @! j% Z& w& w+ R, linstance_actions_events.host instance_info_caches.deleted_at instances.config_drive
- Q2 T, y3 k0 u+ Linstance_actions_events.id instance_info_caches.id instances.created_at1 P5 b: E& F# X2 ^) |3 N# v9 c. m
instance_actions_events.result instance_info_caches.instance_uuid instances.default_ephemeral_device
3 }' B# h$ ]( _instance_actions_events.start_time instance_info_caches.network_info instances.default_swap_device3 y7 t: V" B) K! n0 T1 H: N& c
instance_actions_events.traceback instance_info_caches.updated_at instances.deleted
* Q0 ]# @# x: W! F7 ?: g' |instance_actions_events.updated_at instance_metadata instances.deleted_at
( i) E# h/ A j7 _, dinstance_extra instance_metadata.created_at instances.disable_terminate
* w5 J* D" h8 T6 k1 Ginstance_extra.created_at instance_metadata.deleted instances.display_description
# {. G( V; h! r& k Einstance_extra.deleted instance_metadata.deleted_at instances.display_name
4 w# Z: H- o* ]MariaDB [nova]> select * from instances;+ \9 b% \4 T3 j7 b6 e2 ?
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-------------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+
& x, v0 x1 _0 E7 T8 }& J; p| 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 |
) J8 j; D$ Z1 @1 h- p+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-------------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+
! F* e. S2 K$ B, o| 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 |
1 d8 R+ l, u" Z4 L" ~| 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 |! t8 S, O% C! L3 J, f/ L' S+ A/ Q: w+ 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 |
0 x' k" P1 W+ z| 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 O( i: |# n! d7 J8 x( f3 m| 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 |
/ g0 {# h! a6 V8 Z) N% ^% N( `3 c| 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 |
5 \, m: u4 R& l, a0 v# ?| 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 |: C1 A8 s3 l9 @! r+ ~
| 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 |
! x8 {& k& _1 h6 _7 i1 P| 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 |7 r8 l5 Q) K0 }/ u( u6 I8 x
| 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 |
2 h. `/ A5 h% t, N% o9 v- U7 }| 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 |" d4 k8 V( `0 W
| 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 `8 V4 i& Z- i" }+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-------------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+
2 Y! ~* k4 E9 r, k* G% w9 s2 ^12 rows in set (0.01 sec)+ K% u' G3 m$ I' C
MariaDB [nova]> select * from instances where id="69088d55-eb76-4674-98fe-7909ba547674";
. V( W, D i3 \, ~* a0 b/ z k3 |Empty set (0.00 sec); m5 G' a9 @# v" w
MariaDB [nova]> select id,vmstate,hostname,instance_type_id,uuid from instances;
+ u) H ~. Y3 ^* E, e* YERROR 1054 (42S22): Unknown column 'vmstate' in 'field list') E$ C, f" u1 R6 y6 q
MariaDB [nova]> select id,hostname,instance_type_id,uuid from instances;7 g) `7 t! O! Z& _
+----+-------------+------------------+--------------------------------------+* n) A! E9 F4 p& ?, x
| id | hostname | instance_type_id | uuid |
" n, E5 s+ v+ U. |6 W7 d" I+----+-------------+------------------+--------------------------------------+0 U# @& e% f; b& z
| 2 | test1 | 3 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 |
4 w! F$ p; p y" h X| 4 | zhangyj | 3 | 7c6e79e3-2d94-40ba-b45f-087d559f12ee |
" T6 k* A0 z5 d7 ?' c| 6 | test8subnet | 3 | bfabb27e-cf5a-4409-a464-5162dde24df1 |5 d9 `( x4 s, K6 m# e o
| 7 | zhangyj1 | 6 | 075e0dcb-8992-4a92-b1ad-ad09167e391d |
& ^1 R2 H# J. @8 C& e! {/ x| 9 | zhangyj1 | 3 | 1ecefb25-d285-4d1b-9257-2960a765605e |) e( j: S6 M+ T/ G5 t/ d4 Y: V# x
| 10 | zhangyj | 3 | f3cfa018-51f3-4c00-a549-1cac5a4c4857 |
% I9 Q; W4 u: _3 ~" X| 13 | zhangyj | 3 | 6269828d-fb8b-474c-81e1-2c13652a5892 |2 r! T c9 h; G/ K$ H C
| 15 | zhangyj | 3 | e1df84c5-f049-49fc-b7ae-885660ff2238 |
( P6 @2 W2 z! @' i( h8 Z1 S| 21 | zhangyj | 3 | f8f4dfe7-ada7-4b25-94f4-5c00e414b0c8 |
" I, G9 C/ u/ x% \) i; K& V6 || 24 | zhangyj1 | 3 | bd25efff-f97f-4576-a0ab-f4da6821cfce |/ g: `8 F% X( J3 x
| 25 | zhangyj | 3 | 590e3822-085b-4273-bce1-bf0e7a09b9f7 |
3 {# y, Z% b. S( F| 27 | zhangyj | 3 | 347d5d2e-1516-41ef-b247-a42bc72e093c |' J' A; }/ ?( N1 N3 m
+----+-------------+------------------+--------------------------------------+
9 G" J- E: M# t. w; D" ^12 rows in set (0.01 sec)
0 B% {- r7 U, jMariaDB [nova]> select * from instances where uuid="69088d55-eb76-4674-98fe-7909ba547674";; Q2 B5 a! F" r. Q
Empty set (0.00 sec)2 I6 T0 b* L& f4 g! b9 R1 J: m
MariaDB [nova]> select id,hostname,instance_type_id,uuid,deleted from instances;
9 ^' }$ p( S. k+----+-------------+------------------+--------------------------------------+---------+
( `$ r3 e/ V* v% I% `; _% H| id | hostname | instance_type_id | uuid | deleted |
2 {( M% x# I2 }1 V' t+----+-------------+------------------+--------------------------------------+---------+
i' }# G9 a0 |9 U% f| 2 | test1 | 3 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 | 2 |
. l- Y% e% t0 n/ L/ y/ w| 4 | zhangyj | 3 | 7c6e79e3-2d94-40ba-b45f-087d559f12ee | 4 |# X z9 x3 p6 k
| 6 | test8subnet | 3 | bfabb27e-cf5a-4409-a464-5162dde24df1 | 6 |
U* C; B! g! ]$ k1 T. x e! i| 7 | zhangyj1 | 6 | 075e0dcb-8992-4a92-b1ad-ad09167e391d | 7 |
$ I s6 V9 I' b8 P6 J X| 9 | zhangyj1 | 3 | 1ecefb25-d285-4d1b-9257-2960a765605e | 9 |
% P1 a K% o+ U3 S# X| 10 | zhangyj | 3 | f3cfa018-51f3-4c00-a549-1cac5a4c4857 | 10 |: t: R) ~ F( q# n* w" ^# j8 D
| 13 | zhangyj | 3 | 6269828d-fb8b-474c-81e1-2c13652a5892 | 13 |$ T9 s; V% B! }* g* p3 A
| 15 | zhangyj | 3 | e1df84c5-f049-49fc-b7ae-885660ff2238 | 15 |3 L( p- I. l3 M. g5 V7 b# x
| 21 | zhangyj | 3 | f8f4dfe7-ada7-4b25-94f4-5c00e414b0c8 | 21 |. I+ l- o g, V" x0 l
| 24 | zhangyj1 | 3 | bd25efff-f97f-4576-a0ab-f4da6821cfce | 24 |% @: C* I. L$ E" e! o3 ?! f" E
| 25 | zhangyj | 3 | 590e3822-085b-4273-bce1-bf0e7a09b9f7 | 0 |. c7 u; H- T6 ] s
| 27 | zhangyj | 3 | 347d5d2e-1516-41ef-b247-a42bc72e093c | 0 |
6 @6 D$ E- Y0 m3 f$ J4 S5 P! y+----+-------------+------------------+--------------------------------------+---------+
% M- `2 ^5 f B12 rows in set (0.03 sec)
0 R/ O8 b( J: I! N6 lMariaDB [nova]> select * from instances where display_name='test1';
" }$ @+ M4 Z5 v3 x6 r: U+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+-----------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+----------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+: z+ C8 W3 g l Y! r5 r4 Z
| 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 |
, n" Z' Y( T- i3 t0 p+ n+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+-----------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+----------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+/ _, K& F4 u! t; P
| 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 |& {' N& b( d6 h; N
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+-----------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+----------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+
5 a, A7 o4 h6 m3 L/ z9 C- A1 row in set (0.01 sec)9 j9 i% q7 ~7 ?8 i$ H
MariaDB [nova]> select id,uuid from instances where display_name='test1';
6 Y1 {0 w! t1 @6 Y. s4 I+----+--------------------------------------+
3 K! e- c; {1 W% X| id | uuid |; c& I" N$ R4 a# T8 U- x
+----+--------------------------------------+: d3 O7 k) y$ K$ P
| 2 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 |
) X8 l$ o4 I/ y5 S9 S+----+--------------------------------------+* N; _. J. f- q; J/ n# z% d
1 row in set (0.01 sec)
! r+ Z% v+ s* w- yMariaDB [nova]> select id,uuid,display_name from instances where display_name='test1';
; W! r+ m/ j/ P$ e3 N3 \) y+----+--------------------------------------+--------------+( J$ ^. a$ h8 i( y" N
| id | uuid | display_name |
" B6 O; [: _! d X4 X5 F. r3 A- x% r+----+--------------------------------------+--------------+' g* g% V. B; b
| 2 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 | test1 |+ x' B1 C2 r# M% F. F- i0 c; b
+----+--------------------------------------+--------------+
& {# y" g+ x8 e" G0 I: C+ T1 row in set (0.01 sec)
3 |' ]2 I" O" [1 a5 m2 {$ R0 p( o! o; \" S' ~) Z
数据库也无法查询到：
! @! L# H/ |6 E2 Q5 _放弃吧，反正也不影响openstack平台使用：5 i, h k8 E7 e: {1 C3 C; g; V. M5 j2 \
4 S) m$ {8 ?2 p' b
) ~5 @9 z1 h# b* u
另外解锁下我们界面上看到的被锁虚机：
( m0 D9 ~& r( m) w. p% Z! R+ |[root@controller1 ~]# openstack server unlock 7b01d71a-40d4-45fa-bf5c-97e676b2b9a20 U& W2 Z {& \+ R3 c" O
; }' H; k$ v. r' [% U. [3 l今天的处理就这么多: R9 t9 X( d, m
|
|
发表于 2021-9-7 11:29:33