|
|
[root@controller1 ~]# openstack compute service list
8 w& E3 ?: Q6 G+----+------------------+-------------+----------+---------+-------+----------------------------+5 P- w& m3 y8 J8 u- B/ c/ V
| ID | Binary | Host | Zone | Status | State | Updated At |
0 P& B' f$ h. V+----+------------------+-------------+----------+---------+-------+----------------------------+
/ Q* C8 O4 J" N, d. @$ K ^| 19 | nova-scheduler | controller2 | internal | enabled | down | 2021-09-07T02:31:45.000000 |; T0 S b O2 H; u! }8 M! Z- f$ g
| 22 | nova-scheduler | controller3 | internal | enabled | down | 2021-09-07T02:31:52.000000 |2 B9 b* L# S* x4 V, X
| 23 | nova-scheduler | controller1 | internal | enabled | down | 2021-09-07T02:31:49.000000 |
# b6 M: i& E% e; M3 v+ f" ?| 24 | nova-conductor | controller3 | internal | enabled | up | 2021-09-07T02:54:26.000000 |7 A8 h7 F# i5 @3 d- ~7 ^% Z+ a
| 28 | nova-conductor | controller1 | internal | enabled | up | 2021-09-07T02:54:25.000000 |) O$ B# p7 d# d" k
| 33 | nova-conductor | controller2 | internal | enabled | up | 2021-09-07T02:54:25.000000 |* `* `( c# v, [% p0 Z$ _% v
| 34 | nova-consoleauth | controller2 | internal | enabled | down | 2021-09-07T02:31:40.000000 |' q: Y: z8 t0 w1 P# m
| 36 | nova-consoleauth | controller1 | internal | enabled | up | 2021-09-07T02:54:25.000000 |' U6 D9 G6 `0 Y6 S% T/ |) }- c* G
| 38 | nova-consoleauth | controller3 | internal | enabled | down | 2021-09-07T02:31:42.000000 |
+ `- `" X5 D2 E! h3 D0 }| 42 | nova-compute | compute02 | nova | enabled | up | 2021-09-07T02:54:21.000000 |/ J) ~% G5 G L$ ^( W. \" Z6 _
| 43 | nova-compute | compute03 | nova | enabled | up | 2021-09-07T02:54:17.000000 |- J+ `' I9 U1 h* @2 O. e4 M$ u8 p
| 45 | nova-compute | compute01 | nova | enabled | up | 2021-09-07T02:54:22.000000 |" s1 G5 l- z, |/ I! U
+----+------------------+-------------+----------+---------+-------+----------------------------+
6 L9 U2 P% k. V1 }. W
. i; N$ w e \! s0 l删除虚机命令：
& f2 X! v& v# I, K3 }( K, M3 v9 j[root@controller1 ~]# openstack server delete 69088d55-eb76-4674-98fe-7909ba547674) y/ W' @' k) V1 H2 i5 w) W
No server with a name or ID of '69088d55-eb76-4674-98fe-7909ba547674' exists.
" A: R4 P' q. y' C: H无法删除，头疼：* V' Y6 Y$ R. X- E4 G& J
[root@controller1 ~]# openstack server list " N/ { I9 D- w$ ~2 F6 w0 ^) J
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+- P( A5 z# l Q+ L
| ID | Name | Status | Networks | Image | Flavor |
& d. T' H: ]4 w% {) j+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+& n/ Z! r5 [3 \& x1 Y: Z
| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |
( x5 k* h6 J/ x# V* {+ s| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |
% f% p7 V. g- L4 ~$ S2 s6 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 |3 N. j/ M" ?4 Z2 e0 D9 `. g
| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |$ V* P0 t5 f# m& ?. f
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+& H) }1 r0 U8 s$ Q6 a- v Q% I
6 j5 L& | z t! U
- L! V% ]; E7 u. V& @0 E[root@controller1 ~]# openstack server delete 69088d55-eb76-4674-98fe-7909ba547674
8 _4 i# t0 f7 o2 h/ l5 HNo server with a name or ID of '69088d55-eb76-4674-98fe-7909ba547674' exists.
, q/ ~& n; k) Q2 ^" ~' w0 F& `[root@controller1 ~]#
* ?3 H- _. n, W @3 r还是删不掉：
, r0 i; m r4 r- z[root@controller1 ~]# openstack server list 3 R4 h/ Y2 u5 L3 D- T1 h
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
" `/ `1 R3 S% t2 a3 E| ID | Name | Status | Networks | Image | Flavor |
8 a6 S/ j) A$ A& a! u4 J4 L+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+% S6 V! ?% N( r; m4 j& k
| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |. O- g9 `" C: t# t7 p
| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |% z/ Z) U: b- J$ [
| 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 |7 s ?, |1 f" A: V1 Y" i! f* L
| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g | W5 e {) R, s. W& f' M# T5 a
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+$ c6 N9 Y$ P7 F5 j3 N) {# ?
[root@controller1 ~]# openstack server list ! ~- q b. Y, V
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
2 M# R. J0 D& j1 @' S4 N/ K+ m9 F| ID | Name | Status | Networks | Image | Flavor |/ |! Q9 U0 S6 w' D
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
: y5 W- h' }2 o/ B1 ]& _| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |# {0 T9 u1 y6 O2 p, v% C4 w
| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |
/ }, s7 f# B: u7 M: q| 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 Y# G P# J( \& t6 X; b| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |3 W4 @2 Y5 J' c$ Z% ^( g* Y6 f
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
3 f7 x0 H- b, ?4 a2 q* `3 s: X9 Q/ w
[root@controller1 ~]# openstack server
; o% Z2 U, L- t; g( P6 Xadd dump list reboot resize resume ssh unlock unshelve 5 a0 R- O X: o" P
backup event lock rebuild resize_confirm set start unpause
( d( n" w& s' l& y+ ecreate group migrate remove resize_revert shelve stop unrescue * |) u8 U5 r: k/ |, W9 }' g
delete image pause rescue restore show suspend unset * X. M+ L) p1 g g7 D7 i3 c+ G* g
[root@controller1 ~]# openstack server
# ]) T4 G1 w0 k3 ]% ~: ]6 J' Vadd dump list reboot resize resume ssh unlock unshelve , Q! _3 k4 W$ E. [3 w
backup event lock rebuild resize_confirm set start unpause 3 n+ V7 r4 z: h- r
create group migrate remove resize_revert shelve stop unrescue 3 j9 }0 T/ p( o
delete image pause rescue restore show suspend unset 8 x5 q4 U, G7 f& P _
% I2 c! ~8 s) d z2 N8 i, @也无法show：# I# K% l4 ~# @4 p6 b* V4 m, k
[root@controller1 ~]# openstack server show 69088d55-eb76-4674-98fe-7909ba547674
6 s& \# B( D% t) H) f! d& yNo server with a name or ID of '69088d55-eb76-4674-98fe-7909ba547674' exists.
/ e K! W/ ]8 I4 |6 N/ k& X6 q9 O[root@controller1 ~]# openstack server list
. L# f6 {& K) H" K: L$ \+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+" j3 e8 C! ` m& C/ n1 |4 f; F
| ID | Name | Status | Networks | Image | Flavor |
% q/ P7 D6 K2 Q$ R+ j* o+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
( r2 X1 B; B, e2 J| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |3 i4 y( M$ _1 V
| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |+ d) L2 f$ f! Z& V: O' a
| 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 |" A8 v- }6 m" H- T6 l' U
| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |: f0 c2 b1 Y! o, n; [, y
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+. l. P; O% `8 o) i$ k
( B, p) X8 q7 @$ C5 S: Y9 G+ Y! b$ i/ V
上面的有问题，只能去数据库查看了：
) n9 ?+ v8 q: E2 W
, U+ P- h' I* F6 z/ U3 a2 q: P/ c9 a2 e$ _/ f5 N+ R1 ?" a
[root@controller1 ~]# openstack server list
3 H1 R# M( M: o: t9 v/ v" z$ U1 s+--------------------------------------+----------+--------+----------------------+-------------------+----------------+) ]: t. L( ]2 W$ [; c
| ID | Name | Status | Networks | Image | Flavor |; w' G1 ?" n* F# y4 e
+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
! B9 C) s, w3 a| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |4 T; f2 O: f8 B
| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |
2 u1 G: q! O4 T, g) M1 x| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |5 {% c7 ~% r9 k P+ ?9 d' V
+--------------------------------------+----------+--------+----------------------+-------------------+----------------+ K0 Z' Z7 J& \
[root@controller1 ~]# openstack server delete test1
2 J f* x$ t3 hNo server with a name or ID of 'test1' exists.
' Q5 @: b4 K( G$ n[root@controller1 ~]#
2 t" R( v3 m3 B+ m: A) W5 ~
) F& Y( X! a2 B3 i+ K- }0 M5 a" \[root@controller1 ~]# openstack server list - V- Y1 P/ A3 E$ J2 D
+--------------------------------------+----------+--------+----------------------+-------------------+----------------+( l- u l5 W% r, ~2 ]
| ID | Name | Status | Networks | Image | Flavor |- D2 _- G/ i# a( R6 }
+--------------------------------------+----------+--------+----------------------+-------------------+----------------+" E& [+ M D4 J2 f `4 N
| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |7 _5 C: U; }& C- T" h2 c
| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |/ H: { R. j5 j
| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |. c1 j4 Q2 X1 T$ [0 d0 e
+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
2 o4 {- r2 G6 F4 M$ l. _[root@controller1 ~]# mysql -u root -pdxFxylGX6K65rDh8hu2TWhWTKcIkZVZM6fEvmuW7 -h 192.168.6.233* }" B- C8 O6 c: h
Welcome to the MariaDB monitor. Commands end with ; or \g.
, e& {7 y- N* g7 AYour MariaDB connection id is 1669555* K4 o# v) J: B/ ~' q' D+ s* g6 E
Server version: 10.1.20-MariaDB MariaDB Server& Z- M" r8 v8 @# L( d' w
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
9 M$ ?1 @) o( F. K! [: q* k6 S4 `Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.1 t) g; b7 K# n* }) I( N
MariaDB [(none)]> use nova
* B7 I! j, K& i7 V! k% i9 X# NReading table information for completion of table and column names0 z, B0 J$ s, ~& D7 G5 q' }( }2 R8 ]
You can turn off this feature to get a quicker startup with -A1 J& F+ f" K3 N
Database changed0 i1 ~5 c" z! W% `
MariaDB [nova]> select * from in
9 H0 v, d1 M0 E/ zDisplay all 219 possibilities? (y or n)
( J8 |1 l8 P- Y8 Q% _, |in_use instance_groups.created_at instance_types.root_gb
- a7 i: s- g3 F3 ^- V* iinformation_schema instance_groups.deleted instance_types.rxtx_factor
/ J: C& t5 {7 w! T9 d4 einjected instance_groups.deleted_at instance_types.swap
E2 f4 L1 V% U- `: |" Rinstance_actions instance_groups.id instance_types.updated_at1 g& [- E8 i; c
instance_actions.action instance_groups.name instance_types.vcpu_weight
' Q, |8 N7 F# ]2 o8 D- P& Einstance_actions.created_at instance_groups.project_id instance_types.vcpus% o3 N2 y7 @# y+ F1 L$ C9 o0 m+ W
instance_actions.deleted instance_groups.updated_at instance_uuid" b, `# O% g# L t$ W
instance_actions.deleted_at instance_groups.user_id instances& ^, y4 h9 w, J4 }! j; V
instance_actions.finish_time instance_groups.uuid instances.access_ip_v4
8 o& n" ]: g+ dinstance_actions.id instance_id instances.access_ip_v6) o% Y& f! c- Z Q t
instance_actions.instance_uuid instance_id_mappings instances.architecture) H, e, L, U# |) Y8 o' W. i
instance_actions.message instance_id_mappings.created_at instances.auto_disk_config2 }0 H# F a! ^3 d) _
instance_actions.project_id instance_id_mappings.deleted instances.availability_zone: k7 v! Q6 z& R, }
instance_actions.request_id instance_id_mappings.deleted_at instances.cell_name
8 f- L1 s5 A& [( X( X+ g( X: \0 _: E# t& Jinstance_actions.start_time instance_id_mappings.id instances.cleaned+ g6 r# a0 C2 X
instance_actions.updated_at instance_id_mappings.updated_at instances.config_drive
, O7 h3 R+ o7 U" f' e- E! e6 cinstance_actions.user_id instance_id_mappings.uuid instances.created_at
1 s- ]$ u8 M* n5 v* X6 g' {instance_actions_events instance_info_caches instances.default_ephemeral_device9 T9 r& z6 h3 K; [3 U3 g
instance_actions_events.action_id instance_info_caches.created_at instances.default_swap_device
7 V% ]% D- t) v% m+ t; l" _3 winstance_actions_events.created_at instance_info_caches.deleted instances.deleted6 r/ a2 E$ x6 f3 O7 Z) {6 H- a
instance_actions_events.deleted instance_info_caches.deleted_at instances.deleted_at
5 L P# Q& c' a& Q& d) O0 Sinstance_actions_events.deleted_at instance_info_caches.id instances.disable_terminate: G7 a7 [5 G5 b: b" D& \7 k4 z, S
instance_actions_events.details instance_info_caches.instance_uuid instances.display_description/ O5 |( O9 m1 f4 U1 r9 \
instance_actions_events.event instance_info_caches.network_info instances.display_name
, {. F8 t! ~9 G8 U# Binstance_actions_events.finish_time instance_info_caches.updated_at instances.ephemeral_gb! K7 _% J. B! `$ q. P3 V5 E
instance_actions_events.host instance_metadata instances.ephemeral_key_uuid! {" ]3 A! o' G7 s, p
instance_actions_events.id instance_metadata.created_at instances.host
, |* s3 E+ g7 ~instance_actions_events.result instance_metadata.deleted instances.hostname. Z0 G/ d# e& Z4 `5 R) m
instance_actions_events.start_time instance_metadata.deleted_at instances.id1 h0 ?" s6 x' t9 b& s3 T1 ~, k
instance_actions_events.traceback instance_metadata.id instances.image_ref- v7 @5 y7 I L) E8 O3 F
instance_actions_events.updated_at instance_metadata.instance_uuid instances.instance_type_id
8 p9 f e) l5 M( e4 KMariaDB [nova]> select * from instance
* [7 |9 k+ p2 ?$ h. ~+ w) ^/ sDisplay all 203 possibilities? (y or n)! Q( W' l/ u4 W9 U5 _& P
MariaDB [nova]> select * from instance; z. z0 f2 {+ L& q1 C+ P( R
ERROR 1146 (42S02): Table 'nova.instance' doesn't exist2 C8 ]" N7 z$ r3 Y7 a U# T
MariaDB [nova]> select * from instance; ]5 T0 s. C, H: b; h) I& ?* F
ERROR 1146 (42S02): Table 'nova.instance' doesn't exist! N: Q7 [2 l& C" j1 \) |
MariaDB [nova]> select * from instance;4 s7 ^4 U- \+ u; m/ a7 K1 \
Display all 203 possibilities? (y or n)
2 O8 N/ [. v0 Oinstance_actions instance_group_policy.updated_at instance_types.disabled# I7 _- q& `9 m2 U8 x$ d
instance_actions.action instance_groups instance_types.ephemeral_gb- B/ j' o" Z& p: u& T& C2 d
instance_actions.created_at instance_groups.created_at instance_types.flavorid
" L: e1 Y+ v e/ Xinstance_actions.deleted instance_groups.deleted instance_types.id: {' h: a/ J* g
instance_actions.deleted_at instance_groups.deleted_at instance_types.is_public
- B8 h! n+ ~+ _instance_actions.finish_time instance_groups.id instance_types.memory_mb2 K4 L6 x' K" ~. j, k8 r
instance_actions.id instance_groups.name instance_types.name
5 i) }2 e+ W8 ainstance_actions.instance_uuid instance_groups.project_id instance_types.root_gb
% \/ ^9 w+ {+ A8 r0 @instance_actions.message instance_groups.updated_at instance_types.rxtx_factor" f6 \2 i' V0 C4 {2 ^' C
instance_actions.project_id instance_groups.user_id instance_types.swap3 c# J' A' y$ V$ {# x; a0 C. N3 H4 A
instance_actions.request_id instance_groups.uuid instance_types.updated_at! k) b: h" h, M. p6 w% s
instance_actions.start_time instance_id instance_types.vcpu_weight
: Y. O& F2 q1 q$ t' ]5 _! M: B# Sinstance_actions.updated_at instance_id_mappings instance_types.vcpus
& c* r/ y7 X# Zinstance_actions.user_id instance_id_mappings.created_at instance_uuid
{: N2 P# ?) m" W* w" minstance_actions_events instance_id_mappings.deleted instances
( I8 h( p# S" a% L. Z, xinstance_actions_events.action_id instance_id_mappings.deleted_at instances.access_ip_v40 w1 I! y, A1 |. y0 N
instance_actions_events.created_at instance_id_mappings.id instances.access_ip_v6% F4 Q, x3 @ \4 i: b; R
instance_actions_events.deleted instance_id_mappings.updated_at instances.architecture
" L0 J3 R) o7 ~9 Y' b) [instance_actions_events.deleted_at instance_id_mappings.uuid instances.auto_disk_config2 |) |. ]7 G- O" o
instance_actions_events.details instance_info_caches instances.availability_zone) i6 ^% u: f. w
instance_actions_events.event instance_info_caches.created_at instances.cell_name
% M$ ?% l8 e4 O# j. Z8 iinstance_actions_events.finish_time instance_info_caches.deleted instances.cleaned7 r, {! y. ?5 }2 K% _
instance_actions_events.host instance_info_caches.deleted_at instances.config_drive# Q7 e2 P5 D) Q0 ^- ?' F+ A0 K
instance_actions_events.id instance_info_caches.id instances.created_at
) O$ W: J( X6 C, v/ Q6 O7 [; Uinstance_actions_events.result instance_info_caches.instance_uuid instances.default_ephemeral_device
$ o" f% I$ G+ w yinstance_actions_events.start_time instance_info_caches.network_info instances.default_swap_device
- [- R+ S; N! j. T" C, h2 Rinstance_actions_events.traceback instance_info_caches.updated_at instances.deleted: ?6 z& H; W( r7 H" ~) q( J
instance_actions_events.updated_at instance_metadata instances.deleted_at. l7 q, h( R( e, f2 ?
instance_extra instance_metadata.created_at instances.disable_terminate
1 f8 j( G; n. k5 z) E- g( Winstance_extra.created_at instance_metadata.deleted instances.display_description
% J/ P1 Q w' i; _6 w# N# _instance_extra.deleted instance_metadata.deleted_at instances.display_name
1 y k; D* c$ R; ?5 S, C' qMariaDB [nova]> select * from instances;2 { r! h9 U3 s( O1 n! O* I7 f/ z: |
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-------------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+
. O+ Y3 U6 i" B+ 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 |
0 M7 ]3 M4 H5 F+ k( S1 P. s4 q+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-------------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+& h3 v' _$ r8 p3 ]0 C) W% I
| 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 c- n4 G( h% K
| 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 |- a* A& d! f8 a/ G( P4 D5 K& J q
| 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 |
' K2 O% ]# S% s! m+ h$ b% y+ _| 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 |
! ~$ ^9 n+ p+ f3 C| 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 |9 @. c) \* {' f7 d( \$ S0 L0 ?0 M
| 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 |
4 H6 X0 v, ^# e3 G, G& _0 P| 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 |
: U$ r; M0 Y* P* Y* x5 Z% \6 i| 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 |4 E1 I! ^1 K/ b( \0 M
| 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 |
+ a4 l, w+ D" Z# o2 h+ ?. N* k| 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 |
7 D! j1 z, |/ s# \: |. Z- F| 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 |, t( ^0 z" S6 }, g
| 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 |
* e' b/ ]1 c: R4 l6 F4 d5 C+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-------------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+
# _1 ]: |0 }, S& D1 f12 rows in set (0.01 sec)
) @7 g9 G' o' f# S8 ?# P+ JMariaDB [nova]> select * from instances where id="69088d55-eb76-4674-98fe-7909ba547674";9 `5 f1 E8 l; W4 p5 K9 |* J o/ M- n
Empty set (0.00 sec)) s: k1 b0 i m) Z
MariaDB [nova]> select id,vmstate,hostname,instance_type_id,uuid from instances;$ @/ |9 q6 A b1 P0 O
ERROR 1054 (42S22): Unknown column 'vmstate' in 'field list'
7 x, R. Y2 J4 e3 A- }6 kMariaDB [nova]> select id,hostname,instance_type_id,uuid from instances;
2 j1 s, J/ Y# w3 V3 s8 U+----+-------------+------------------+--------------------------------------+
* p2 W9 N3 n( B| id | hostname | instance_type_id | uuid |
0 f6 o* X3 r( p" v% C+----+-------------+------------------+--------------------------------------+ f" q6 u! y, K7 E) ?
| 2 | test1 | 3 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 |
# T' J8 s1 H' _" T- W' @| 4 | zhangyj | 3 | 7c6e79e3-2d94-40ba-b45f-087d559f12ee |+ ]: N5 O6 | d' P, ^6 |" _
| 6 | test8subnet | 3 | bfabb27e-cf5a-4409-a464-5162dde24df1 |7 m9 E& i, z& B t$ r4 h# h
| 7 | zhangyj1 | 6 | 075e0dcb-8992-4a92-b1ad-ad09167e391d |: k/ \) [4 p" V; v0 H& A
| 9 | zhangyj1 | 3 | 1ecefb25-d285-4d1b-9257-2960a765605e |; d# c6 _0 k- q6 b A
| 10 | zhangyj | 3 | f3cfa018-51f3-4c00-a549-1cac5a4c4857 |& h6 d. Z. J" a% _& w0 ]* ^
| 13 | zhangyj | 3 | 6269828d-fb8b-474c-81e1-2c13652a5892 |/ X7 x9 C2 G& k+ A& M w: m
| 15 | zhangyj | 3 | e1df84c5-f049-49fc-b7ae-885660ff2238 |
" }' ^9 q0 \6 i* B0 X/ P% y8 P. r* I9 x( ~| 21 | zhangyj | 3 | f8f4dfe7-ada7-4b25-94f4-5c00e414b0c8 |
2 z {. t! j# r* U3 k. `| 24 | zhangyj1 | 3 | bd25efff-f97f-4576-a0ab-f4da6821cfce |# D9 S9 d! {2 ], q3 I. ~
| 25 | zhangyj | 3 | 590e3822-085b-4273-bce1-bf0e7a09b9f7 |
% E/ |6 H+ N9 Q' @, j3 W5 y| 27 | zhangyj | 3 | 347d5d2e-1516-41ef-b247-a42bc72e093c |, Y7 M% ^ q- ~5 i. q2 Y$ ]
+----+-------------+------------------+--------------------------------------+# }* G8 \4 g7 u4 n8 t- v7 W: j
12 rows in set (0.01 sec)
& X; w; _: X% {/ D7 B* C$ v1 HMariaDB [nova]> select * from instances where uuid="69088d55-eb76-4674-98fe-7909ba547674";
& }# ]8 H. ^6 z/ HEmpty set (0.00 sec)
; F8 D4 P8 d9 v' H gMariaDB [nova]> select id,hostname,instance_type_id,uuid,deleted from instances;
6 A1 e3 @1 F0 Y0 w" i+----+-------------+------------------+--------------------------------------+---------+4 l. {. F! L/ ?
| id | hostname | instance_type_id | uuid | deleted |5 f l! t; t. _4 y" D) \
+----+-------------+------------------+--------------------------------------+---------+$ _: W8 \7 g* v0 v# t7 m2 q% r0 j! I
| 2 | test1 | 3 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 | 2 |
9 ]/ R {+ ~: h) n| 4 | zhangyj | 3 | 7c6e79e3-2d94-40ba-b45f-087d559f12ee | 4 |) L W/ S6 ], B% G) W
| 6 | test8subnet | 3 | bfabb27e-cf5a-4409-a464-5162dde24df1 | 6 |; n3 y$ T/ i/ D& K
| 7 | zhangyj1 | 6 | 075e0dcb-8992-4a92-b1ad-ad09167e391d | 7 |
" G4 t% i: c2 t" i2 o- ]| 9 | zhangyj1 | 3 | 1ecefb25-d285-4d1b-9257-2960a765605e | 9 |* H0 A# @, E: C+ A7 H8 A8 y/ J0 U0 M
| 10 | zhangyj | 3 | f3cfa018-51f3-4c00-a549-1cac5a4c4857 | 10 |
) u5 B( k) ]* j2 E9 I| 13 | zhangyj | 3 | 6269828d-fb8b-474c-81e1-2c13652a5892 | 13 |
$ \* y# M' k+ H! E4 `9 r| 15 | zhangyj | 3 | e1df84c5-f049-49fc-b7ae-885660ff2238 | 15 |
3 k: Y" v; e$ T7 _3 t| 21 | zhangyj | 3 | f8f4dfe7-ada7-4b25-94f4-5c00e414b0c8 | 21 |, p) X6 }" X+ i
| 24 | zhangyj1 | 3 | bd25efff-f97f-4576-a0ab-f4da6821cfce | 24 |2 Q, A- ^3 p3 F7 _; [2 j; j4 m
| 25 | zhangyj | 3 | 590e3822-085b-4273-bce1-bf0e7a09b9f7 | 0 |
+ _: Z# k' t1 j| 27 | zhangyj | 3 | 347d5d2e-1516-41ef-b247-a42bc72e093c | 0 |% K" d" J# y$ o% q- p& j
+----+-------------+------------------+--------------------------------------+---------+
+ D/ j; R; q* O2 N' I3 F12 rows in set (0.03 sec)
+ ]. w! Z5 j9 ~) LMariaDB [nova]> select * from instances where display_name='test1';* d: K# X( ~# v# }
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+-----------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+----------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+
0 j, Y4 R; Z, v( M& x$ S| 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 |
$ C& }2 J( P, ?+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+-----------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+----------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+
- c8 I; d5 X, D' o: g w/ 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 |4 ^* ^+ b& r# w1 n3 B. b
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+-----------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+----------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+' L+ l; \% x, B
1 row in set (0.01 sec)7 e$ F' d3 K& O% T
MariaDB [nova]> select id,uuid from instances where display_name='test1';
3 ^2 `# u0 @% F0 g1 ~; L& U+----+--------------------------------------+
/ c9 n; L. V4 v& B+ H9 V b- ]' Y3 i| id | uuid |2 D3 p% Q" Q$ o- [% t/ U
+----+--------------------------------------+# u- k1 S1 l0 _! D
| 2 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 |
0 n8 k5 L# H+ @4 _6 z# Z! ?+----+--------------------------------------+- _1 s; Y" f8 S: g( N& X& g% n+ A) C
1 row in set (0.01 sec)# A3 Q# Z, N% o' H. x5 R+ r9 N
MariaDB [nova]> select id,uuid,display_name from instances where display_name='test1';
- j6 j* O6 ^! m3 p, z+ [# s9 i5 l' \+----+--------------------------------------+--------------+" f& R2 [% U: n8 k
| id | uuid | display_name |
3 W, X0 H) [8 v2 i+----+--------------------------------------+--------------+
9 Q: m+ x3 W6 j$ V' X| 2 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 | test1 |
' j1 Z2 l+ `, u/ ^. Q+----+--------------------------------------+--------------+" o4 O; U9 H2 m* H$ P4 m
1 row in set (0.01 sec)3 {3 w! ?# O' S4 B
$ e" H: N- O7 E \7 b
数据库也无法查询到：
/ g& W$ F: g% A3 @放弃吧，反正也不影响openstack平台使用：
) R# W& @9 ]/ A% J5 ?; @4 D8 w" z
( w5 M, h0 e( F8 A& `另外解锁下我们界面上看到的被锁虚机：4 C" `) P3 U. S0 s {# R
[root@controller1 ~]# openstack server unlock 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2
u0 e8 @1 \' s* B+ q1 N
# _) M/ c3 r6 b/ N7 g$ L2 w' f! N今天的处理就这么多
0 x G; Y- I- E2 F |
|
发表于 2021-9-7 11:29:33