- 积分
- 16840
在线时间 小时
最后登录1970-1-1
|
马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。
您需要 登录 才可以下载或查看，没有账号？开始注册
x
[root@controller1 ~]# openstack compute service list ( _% |% q; S. {" o: e
+----+------------------+-------------+----------+---------+-------+----------------------------+; y |' a3 W9 f+ |; t$ _( E
| ID | Binary | Host | Zone | Status | State | Updated At |
: \3 P( T' d3 q0 p+----+------------------+-------------+----------+---------+-------+----------------------------+
3 m+ ]6 A) k& }" t) N| 19 | nova-scheduler | controller2 | internal | enabled | down | 2021-09-07T02:31:45.000000 |( O% H% g- u+ R5 A% G
| 22 | nova-scheduler | controller3 | internal | enabled | down | 2021-09-07T02:31:52.000000 |: O0 B' D: ?0 b8 o, p' N' D
| 23 | nova-scheduler | controller1 | internal | enabled | down | 2021-09-07T02:31:49.000000 |
8 f3 n( D( \9 C) I- t| 24 | nova-conductor | controller3 | internal | enabled | up | 2021-09-07T02:54:26.000000 |0 C7 U, Q! n& U* J7 h
| 28 | nova-conductor | controller1 | internal | enabled | up | 2021-09-07T02:54:25.000000 |/ \( a* G% A$ O3 {7 O
| 33 | nova-conductor | controller2 | internal | enabled | up | 2021-09-07T02:54:25.000000 |0 v" ^7 h1 R! `+ U
| 34 | nova-consoleauth | controller2 | internal | enabled | down | 2021-09-07T02:31:40.000000 |
* i0 W! Q7 g- r, l; w6 {6 `" n) q| 36 | nova-consoleauth | controller1 | internal | enabled | up | 2021-09-07T02:54:25.000000 |+ E; F- N9 m$ b8 W
| 38 | nova-consoleauth | controller3 | internal | enabled | down | 2021-09-07T02:31:42.000000 |
7 _! ^, c- x, V# M| 42 | nova-compute | compute02 | nova | enabled | up | 2021-09-07T02:54:21.000000 |
; d% E+ u0 s9 \7 k5 B- D| 43 | nova-compute | compute03 | nova | enabled | up | 2021-09-07T02:54:17.000000 |
+ s. u- J9 s$ B+ B* g/ [| 45 | nova-compute | compute01 | nova | enabled | up | 2021-09-07T02:54:22.000000 |! F: `; i% ~# n& Z/ b# Z/ ?
+----+------------------+-------------+----------+---------+-------+----------------------------+, ~& T4 T8 o! J
! S }" {3 @ A/ l' M4 U3 A, [6 L删除虚机命令：8 k9 x: d, k' e9 \
[root@controller1 ~]# openstack server delete 69088d55-eb76-4674-98fe-7909ba5476746 f5 O6 ]# e3 t0 P( [9 B
No server with a name or ID of '69088d55-eb76-4674-98fe-7909ba547674' exists., ] f0 ?: \9 i) r
无法删除，头疼：. \) F/ o: c* y
[root@controller1 ~]# openstack server list
+ y% _- _4 ]4 m* j, Y* m6 m+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+* n7 Z' k! Q7 j' z0 o9 Y; j' r
| ID | Name | Status | Networks | Image | Flavor |
# j: Q2 [; r" ~5 a5 v9 D+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+/ W D; y+ P7 e# J/ D) x
| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |
9 y. @* m' y+ z6 H1 [| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |
7 H' I$ J% @. c# x| 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 |
# L }+ i/ t- ~9 S3 Y| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |
6 t5 }! d1 k! c, |, y+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
1 e) {( w6 E2 u* J/ @/ P( T8 @0 f3 \6 y; n# m! B
2 `) h5 ?2 }% Z' H, ^3 O0 P" X
[root@controller1 ~]# openstack server delete 69088d55-eb76-4674-98fe-7909ba547674! `) Q. d+ U4 K @) U4 s
No server with a name or ID of '69088d55-eb76-4674-98fe-7909ba547674' exists./ f1 Z) X; K4 W
[root@controller1 ~]#
+ K2 ]% v0 r& S+ k% ~+ N( `7 L4 @还是删不掉：
t% n0 L3 ]( s. O M[root@controller1 ~]# openstack server list
2 ?4 Y' ^6 a4 T" v7 P( _; c+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------++ [8 }+ m$ S7 m# ]
| ID | Name | Status | Networks | Image | Flavor |
; \2 P$ r; Q, l5 R0 v8 A+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+$ _" A: s( Z2 ^ }* r
| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |1 B: C1 C- _6 ~5 w# W' j
| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |. |0 d# i# b' k2 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 |. t' Q; [; a( Q) O* @9 m0 h. B
| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |
- ~0 U/ U9 Q, t, L' a+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+6 Z: P8 H! {2 y; Y: _* `) z
[root@controller1 ~]# openstack server list 6 Z. E7 d! U `) ` ]8 r C1 a+ R
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+. v2 P* F3 i$ b& s& r9 p
| ID | Name | Status | Networks | Image | Flavor |! i) [; b' t. e5 I" t5 O
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+" c- v8 |4 Z/ K+ a8 g
| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |6 b9 ]4 H9 ] ^1 r/ S# O% k
| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |3 R) B/ O, k0 u" T) k$ 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 |
" C! F$ H# Y# F0 k| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |; A$ V/ [8 H* ?) \2 H
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+
$ @: d" O; ?* V# j& F
, _+ u: m* Y1 m[root@controller1 ~]# openstack server ! A$ E) r3 [: A8 v. f3 B
add dump list reboot resize resume ssh unlock unshelve ) C( ]% b- s% o' @. ]
backup event lock rebuild resize_confirm set start unpause
( |3 Q P+ x* d7 hcreate group migrate remove resize_revert shelve stop unrescue : j2 g) H: U# S1 |1 g+ c
delete image pause rescue restore show suspend unset 2 ` E. t& E& D% H0 _* C+ Z: p3 x
[root@controller1 ~]# openstack server 2 J' z4 p T+ L$ `
add dump list reboot resize resume ssh unlock unshelve 3 v* l4 Q" w6 K5 l) k0 r- Y e
backup event lock rebuild resize_confirm set start unpause
9 i; L& T) q% T3 g6 {, vcreate group migrate remove resize_revert shelve stop unrescue
+ W& M# X( r# D$ e2 d2 e# wdelete image pause rescue restore show suspend unset ( `0 ^) s6 o& A1 t+ k+ b& ~
% u5 \; H' Y( k& m; x也无法show：
' ~9 N+ Z' ^/ P* X[root@controller1 ~]# openstack server show 69088d55-eb76-4674-98fe-7909ba547674) n; e" Q1 V6 U3 I6 v6 X* B, r
No server with a name or ID of '69088d55-eb76-4674-98fe-7909ba547674' exists.
2 Y. G1 v5 k/ H! D# i9 T2 |[root@controller1 ~]# openstack server list
. `5 P% o$ @- G* t/ f+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+6 p$ Z0 q6 p1 m! ~% `
| ID | Name | Status | Networks | Image | Flavor |
! V( L/ g+ g- ~+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+1 W8 w. ?7 f. G4 q
| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |9 T" X o% }% m& U" @+ J% ~3 I$ T
| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |7 v3 b& ^# U4 ~. o
| 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 | test1 | ACTIVE | bridge=192.168.0.206, 192.168.0.233; zhangyj_network=192.168.1.20 | | type-1c-1g-10g |
+ e( l6 L# |" A" a| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |5 A1 o6 ^8 e: M8 ~" {
+--------------------------------------+----------+--------+-------------------------------------------------------------------+-------------------+----------------+* K9 d6 K; B+ \, J9 o. W
$ l- x9 i$ B# K5 ?上面的有问题，只能去数据库查看了：, Q {% W& Q7 M a0 Q
( z; G. {7 U9 `7 w) P0 H
4 S7 V' z4 R J/ j( v0 O, h[root@controller1 ~]# openstack server list
! V/ O9 o1 a& ]9 a" U5 N+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
% s6 X; [ }# V! `| ID | Name | Status | Networks | Image | Flavor |) O: B$ c# w' @/ i
+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
. z# _! A0 m4 Q* Q+ t4 G* G| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |5 u8 [5 L5 b* D
| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |
* Z) I. @' U8 V| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |/ [; A A! d3 y( i( |! ^
+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
0 p" r% G, l* g" u6 d[root@controller1 ~]# openstack server delete test1 - o& j' u8 t; h9 Z9 o1 M
No server with a name or ID of 'test1' exists.! K$ L( [- _+ u* y* a
[root@controller1 ~]#
1 y& r9 Y! x' E, k- D
5 T3 Q4 o& n) E) t7 q% A[root@controller1 ~]# openstack server list & \6 C, c A- l: x1 h1 }
+--------------------------------------+----------+--------+----------------------+-------------------+----------------++ Z" S2 `2 F5 y+ T
| ID | Name | Status | Networks | Image | Flavor |
# O4 @' {$ d* z8 ~. }+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
" K# D" J9 Z F* C! G1 L| 347d5d2e-1516-41ef-b247-a42bc72e093c | zhangyj2 | ACTIVE | bridge=192.168.0.201 | Centos7.9-x86_x64 | type-1c-1g-10g |
: S! `$ K& h: @# _! v- X| 590e3822-085b-4273-bce1-bf0e7a09b9f7 | zhangyj1 | ACTIVE | bridge=192.168.0.223 | Centos7.9-x86_x64 | type-1c-1g-10g |
9 Y$ @' X' ]/ ~5 R0 C' {| 69088d55-eb76-4674-98fe-7909ba547674 | test1 | BUILD | | | type-1c-1g-10g |
6 ^5 P+ H7 _+ r( W( K+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
6 g& X8 z* G4 P5 M[root@controller1 ~]# mysql -u root -pdxFxylGX6K65rDh8hu2TWhWTKcIkZVZM6fEvmuW7 -h 192.168.6.233$ Z) i0 | @8 u" U" ~
Welcome to the MariaDB monitor. Commands end with ; or \g.
8 l7 ^+ M! {9 j% O- G1 HYour MariaDB connection id is 16695554 I4 E& D( J2 c( ^1 y1 Q
Server version: 10.1.20-MariaDB MariaDB Server8 [. t7 y/ M s% [+ ~/ w
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.% [( _$ [+ L! i4 }6 r4 b( q
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.; o' ^4 A0 W$ w
MariaDB [(none)]> use nova
, S# ^6 [6 j( c1 C2 rReading table information for completion of table and column names
' t3 J N% \" _( I% v' rYou can turn off this feature to get a quicker startup with -A9 q" W6 W- X. p
Database changed
6 N6 ?2 @. X: ~0 K: bMariaDB [nova]> select * from in3 I1 [- h: N8 D& ?
Display all 219 possibilities? (y or n)6 g; S- n$ O* i$ {2 h5 l- _$ G
in_use instance_groups.created_at instance_types.root_gb" y/ Z. }( S( S) L# |: F, X4 B
information_schema instance_groups.deleted instance_types.rxtx_factor
4 s8 x+ |" z, z' Ainjected instance_groups.deleted_at instance_types.swap- s9 x2 N7 J4 _9 T+ ^3 M/ e9 N
instance_actions instance_groups.id instance_types.updated_at
( d1 p2 n; t6 cinstance_actions.action instance_groups.name instance_types.vcpu_weight
- G, G. k9 h& Y# Qinstance_actions.created_at instance_groups.project_id instance_types.vcpus* Q( _: G* v4 P
instance_actions.deleted instance_groups.updated_at instance_uuid
5 Z/ c4 ~' Z* T Ainstance_actions.deleted_at instance_groups.user_id instances& N; y! K1 i. Q) R2 A+ l9 s
instance_actions.finish_time instance_groups.uuid instances.access_ip_v49 w* C7 v* _3 e
instance_actions.id instance_id instances.access_ip_v6
; p5 V, g4 A e5 linstance_actions.instance_uuid instance_id_mappings instances.architecture6 c, N b7 Z7 D5 l
instance_actions.message instance_id_mappings.created_at instances.auto_disk_config& Y" k( H/ Q1 u) v% Y) E
instance_actions.project_id instance_id_mappings.deleted instances.availability_zone0 ]: Y, S$ i/ ~2 ?2 m0 M
instance_actions.request_id instance_id_mappings.deleted_at instances.cell_name
) a0 Q4 L# B' x5 i8 j! a5 Oinstance_actions.start_time instance_id_mappings.id instances.cleaned
4 m: X. r" ~: P! T5 {. Iinstance_actions.updated_at instance_id_mappings.updated_at instances.config_drive( y/ |% g' M7 y' H5 ~2 S
instance_actions.user_id instance_id_mappings.uuid instances.created_at
/ z- v( e1 Z/ dinstance_actions_events instance_info_caches instances.default_ephemeral_device5 E; `7 U# F% g) E' Z- G. p
instance_actions_events.action_id instance_info_caches.created_at instances.default_swap_device
. @; K$ h! X7 p4 rinstance_actions_events.created_at instance_info_caches.deleted instances.deleted
. d, M4 m0 t$ |( ?8 C/ j: Finstance_actions_events.deleted instance_info_caches.deleted_at instances.deleted_at/ M8 e% j6 B, p2 ^$ b+ A+ y
instance_actions_events.deleted_at instance_info_caches.id instances.disable_terminate; j; K: R4 U1 p. Q" O6 I v
instance_actions_events.details instance_info_caches.instance_uuid instances.display_description
; t; J. S2 r; H0 a# h" M( D8 j Ninstance_actions_events.event instance_info_caches.network_info instances.display_name
' ]7 I: L* J Y- @6 K& `6 {8 |instance_actions_events.finish_time instance_info_caches.updated_at instances.ephemeral_gb% J1 b$ f2 |4 n% u" o
instance_actions_events.host instance_metadata instances.ephemeral_key_uuid, \3 i0 H: G" Q8 s& c
instance_actions_events.id instance_metadata.created_at instances.host
/ C* Y% @5 b( A8 x1 x* w( U0 y" dinstance_actions_events.result instance_metadata.deleted instances.hostname
" F9 \ W$ `& ]& y0 [) D" winstance_actions_events.start_time instance_metadata.deleted_at instances.id
# b2 C/ q8 A& g! `( Pinstance_actions_events.traceback instance_metadata.id instances.image_ref
3 H$ {; d# P, G8 N! F6 ninstance_actions_events.updated_at instance_metadata.instance_uuid instances.instance_type_id
4 Q$ ?% D( Y; `1 a- A' IMariaDB [nova]> select * from instance
* F0 u5 }0 `+ I4 {" IDisplay all 203 possibilities? (y or n)# f( c: M4 B ?9 k0 p# S; J
MariaDB [nova]> select * from instance;8 @% l6 h7 C8 [% }$ h% Z4 @
ERROR 1146 (42S02): Table 'nova.instance' doesn't exist
& z: | D/ q7 C- u1 ` k; NMariaDB [nova]> select * from instance;, R/ `2 v4 V, b, L
ERROR 1146 (42S02): Table 'nova.instance' doesn't exist0 [: y9 [! ]. E5 x8 S; M' L
MariaDB [nova]> select * from instance;$ n# s4 z3 E$ v1 R' X1 C
Display all 203 possibilities? (y or n)" B1 S/ B8 \/ Y; g3 |+ ?; k
instance_actions instance_group_policy.updated_at instance_types.disabled
! M [2 M. \' dinstance_actions.action instance_groups instance_types.ephemeral_gb
; z! z4 X- T/ r. f- A) Finstance_actions.created_at instance_groups.created_at instance_types.flavorid$ R# B! ]# E+ u. c) [! M, E1 @- |5 h
instance_actions.deleted instance_groups.deleted instance_types.id7 g4 K2 e, V$ ~) K+ [
instance_actions.deleted_at instance_groups.deleted_at instance_types.is_public
: b# Y+ M. R% C u' Xinstance_actions.finish_time instance_groups.id instance_types.memory_mb
0 T: V% e& U: p0 _0 \& Y: Linstance_actions.id instance_groups.name instance_types.name
* a* X, k9 e* g/ [- {' Sinstance_actions.instance_uuid instance_groups.project_id instance_types.root_gb
$ y. j3 ?: |, {& R4 P1 F1 oinstance_actions.message instance_groups.updated_at instance_types.rxtx_factor
4 R+ m) u2 [2 v# v% Pinstance_actions.project_id instance_groups.user_id instance_types.swap
' ?" ~8 `3 k. Z# Kinstance_actions.request_id instance_groups.uuid instance_types.updated_at& W: |# Q/ X) p3 ^8 Z4 q
instance_actions.start_time instance_id instance_types.vcpu_weight. m$ [( {: b/ w% d1 g1 n( b4 J
instance_actions.updated_at instance_id_mappings instance_types.vcpus
7 U: ~% N. C4 v% D2 t) t9 Finstance_actions.user_id instance_id_mappings.created_at instance_uuid+ R: g( Z- y! ?( |$ c
instance_actions_events instance_id_mappings.deleted instances
4 G C+ o5 F% u O8 m, einstance_actions_events.action_id instance_id_mappings.deleted_at instances.access_ip_v41 V( b* N# }, w- b6 V5 l; O8 g
instance_actions_events.created_at instance_id_mappings.id instances.access_ip_v6( s* f8 o( t4 `1 _" a/ d
instance_actions_events.deleted instance_id_mappings.updated_at instances.architecture
- }( u6 L, q3 l& q) I8 Minstance_actions_events.deleted_at instance_id_mappings.uuid instances.auto_disk_config/ u: N- z& B4 e2 h
instance_actions_events.details instance_info_caches instances.availability_zone i: R2 X! ]/ X Y
instance_actions_events.event instance_info_caches.created_at instances.cell_name9 Q$ H$ n% Z# \- ^
instance_actions_events.finish_time instance_info_caches.deleted instances.cleaned
) L J4 V3 h' f" O% w0 `instance_actions_events.host instance_info_caches.deleted_at instances.config_drive8 K j7 U% Z7 b8 f5 F; M
instance_actions_events.id instance_info_caches.id instances.created_at, F1 G" u6 q+ f8 E
instance_actions_events.result instance_info_caches.instance_uuid instances.default_ephemeral_device
( u) s# }" n% F1 w. |9 p8 x! Dinstance_actions_events.start_time instance_info_caches.network_info instances.default_swap_device
" M2 g+ {1 x' t# z0 [0 Q) Oinstance_actions_events.traceback instance_info_caches.updated_at instances.deleted7 z3 _ A5 k0 L l( i6 I. n3 N! \
instance_actions_events.updated_at instance_metadata instances.deleted_at
. n& {, M0 R# }1 d) b& Qinstance_extra instance_metadata.created_at instances.disable_terminate9 X; g8 s/ K- d+ W. Q/ j
instance_extra.created_at instance_metadata.deleted instances.display_description
% e5 L' A4 H% V$ X1 k) zinstance_extra.deleted instance_metadata.deleted_at instances.display_name
8 G4 T5 x% @% K* }4 X# pMariaDB [nova]> select * from instances;2 g/ u' \2 E1 U
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-------------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+' w3 O9 r2 b) A |. U
| 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 {) Z0 J' h! f; ^4 U+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-------------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+6 `6 R+ b( S9 H( _& z
| 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 | t W x& O: v# Z$ @
| 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 |/ q; l! R+ r8 ^6 _. @3 Z
| 2021-08-25 08:10:10 | 2021-08-25 08:37:55 | 2021-08-25 08:37:56 | 6 | NULL | b1ffbc1f84cf42c99a8e59fdaf7f1cf5 | 92a5a26fc14d418d881ade0ccbcffc59 | | | | 0 | NULL | NULL | 0 | deleted | 1024 | 1 | test8subnet | compute01 | NULL | r-xi06wdxe | 2021-08-25 08:10:46 | 2021-08-25 08:37:55 | test8subnet | NULL | nova | 0 | NULL | compute01 | 3 | NULL | bfabb27e-cf5a-4409-a464-5162dde24df1 | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 1 | 0 | 0 | 10 | 0 | NULL | compute01 | 6 | NULL | 1 | NULL |
9 h" \2 F: k7 h5 S. m9 s {. o| 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 t3 |) c' `3 D' W0 o| 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 |
( s8 \% a: Y6 Q9 U| 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 |
6 e3 Y) n8 p0 ]6 S, D. W2 Q| 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 | G! X) m; u7 t( B
| 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 |9 g \( q9 \" }% c( f; o
| 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 |
, z- V) d& J4 M6 g- c| 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 |
" R* l3 K" ^! Y* g0 j| 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 |: H" W5 p& V t' s
| 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 |+ _" G9 _! h; J/ m
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-------------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+5 h) O) J3 T0 z# ~, \# P' ~
12 rows in set (0.01 sec)0 f0 P0 p6 n0 r9 R
MariaDB [nova]> select * from instances where id="69088d55-eb76-4674-98fe-7909ba547674";0 U' G$ f; n S4 |4 u
Empty set (0.00 sec)
) Q% j( [7 G! y/ uMariaDB [nova]> select id,vmstate,hostname,instance_type_id,uuid from instances;) z, I j1 U! ^* B3 V$ F9 E
ERROR 1054 (42S22): Unknown column 'vmstate' in 'field list'4 G4 n% B& w9 a% W+ _4 E3 P& K% W, {
MariaDB [nova]> select id,hostname,instance_type_id,uuid from instances;
% q! Q6 v; V5 Q5 W5 L; l+ Z# {+----+-------------+------------------+--------------------------------------+
) |) Q: G/ o9 z: b" g5 d, a. ]2 D| id | hostname | instance_type_id | uuid |
/ I( m1 E; B+ x! ?. e+----+-------------+------------------+--------------------------------------+2 ]- a+ r m2 S5 S5 w8 n
| 2 | test1 | 3 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 |
9 u1 e- W2 b; ?! n- r| 4 | zhangyj | 3 | 7c6e79e3-2d94-40ba-b45f-087d559f12ee | L2 U9 i1 |4 o4 U% ~9 N
| 6 | test8subnet | 3 | bfabb27e-cf5a-4409-a464-5162dde24df1 |
" S0 O4 C# F4 {& Q8 S$ y- M9 H| 7 | zhangyj1 | 6 | 075e0dcb-8992-4a92-b1ad-ad09167e391d |
5 `% X7 R' b( P8 V: z* U9 J| 9 | zhangyj1 | 3 | 1ecefb25-d285-4d1b-9257-2960a765605e |8 d, e% P2 r- o, V$ Y; I! \
| 10 | zhangyj | 3 | f3cfa018-51f3-4c00-a549-1cac5a4c4857 |3 \! }* f) G1 L' \/ u5 O
| 13 | zhangyj | 3 | 6269828d-fb8b-474c-81e1-2c13652a5892 |+ K, ^! p) C6 _1 F1 r& u
| 15 | zhangyj | 3 | e1df84c5-f049-49fc-b7ae-885660ff2238 |: } _# c. g/ X( w0 [4 P7 o- g5 j
| 21 | zhangyj | 3 | f8f4dfe7-ada7-4b25-94f4-5c00e414b0c8 |
! T1 c* ]; P" E6 j| 24 | zhangyj1 | 3 | bd25efff-f97f-4576-a0ab-f4da6821cfce |
2 t+ J+ u- E/ Y| 25 | zhangyj | 3 | 590e3822-085b-4273-bce1-bf0e7a09b9f7 |
0 n% e4 e0 s1 |: K) c| 27 | zhangyj | 3 | 347d5d2e-1516-41ef-b247-a42bc72e093c |% `6 Q% y5 p8 S7 D6 C2 B
+----+-------------+------------------+--------------------------------------+
0 m: j, w4 n: f9 f12 rows in set (0.01 sec)
) X) k N6 E: jMariaDB [nova]> select * from instances where uuid="69088d55-eb76-4674-98fe-7909ba547674";
7 n: C2 ?) W; f Z, sEmpty set (0.00 sec)
& u% Z" ~( L# U. C lMariaDB [nova]> select id,hostname,instance_type_id,uuid,deleted from instances;
7 {7 F. k: p9 m7 b7 z+----+-------------+------------------+--------------------------------------+---------+. ^9 \8 L9 Q& G$ q/ @9 _- q* n- _
| id | hostname | instance_type_id | uuid | deleted |- j3 P5 D: C& I6 V
+----+-------------+------------------+--------------------------------------+---------+; ~: }6 J" K8 X" q/ {, j" q
| 2 | test1 | 3 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 | 2 |+ b% S$ a% X$ } L
| 4 | zhangyj | 3 | 7c6e79e3-2d94-40ba-b45f-087d559f12ee | 4 |4 ^7 f2 J, @! p
| 6 | test8subnet | 3 | bfabb27e-cf5a-4409-a464-5162dde24df1 | 6 |
5 X+ j$ b( a- E1 K4 [3 ^1 q \| 7 | zhangyj1 | 6 | 075e0dcb-8992-4a92-b1ad-ad09167e391d | 7 |
3 T7 R: N) `& s) l| 9 | zhangyj1 | 3 | 1ecefb25-d285-4d1b-9257-2960a765605e | 9 |6 K( h' C: |1 r+ m; D- v, {, l
| 10 | zhangyj | 3 | f3cfa018-51f3-4c00-a549-1cac5a4c4857 | 10 |+ n2 h( l: u" |/ N8 A' f
| 13 | zhangyj | 3 | 6269828d-fb8b-474c-81e1-2c13652a5892 | 13 |
8 h% F$ o3 s5 }0 L| 15 | zhangyj | 3 | e1df84c5-f049-49fc-b7ae-885660ff2238 | 15 |
& e, l, j0 D/ ^: u$ i9 A| 21 | zhangyj | 3 | f8f4dfe7-ada7-4b25-94f4-5c00e414b0c8 | 21 |
' `, [9 ~, F) i5 C) ]) ^' j| 24 | zhangyj1 | 3 | bd25efff-f97f-4576-a0ab-f4da6821cfce | 24 |) G# C2 b, L8 Z, c6 a
| 25 | zhangyj | 3 | 590e3822-085b-4273-bce1-bf0e7a09b9f7 | 0 |
, m8 H0 @4 o3 v9 `" A| 27 | zhangyj | 3 | 347d5d2e-1516-41ef-b247-a42bc72e093c | 0 |
3 J K7 T( n% Z* Y U8 Y! Y* X- e0 A+----+-------------+------------------+--------------------------------------+---------+
4 p9 x5 P" m; A" A9 l% N12 rows in set (0.03 sec)
" g. C4 H0 e! @9 lMariaDB [nova]> select * from instances where display_name='test1'; q7 }( s& n# V4 j
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+-----------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+----------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+
1 X1 V% I# i! L; g| 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 |* B1 S" w' J+ l2 p
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+-----------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+----------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+. h3 X; A! r' ~ N3 @9 t
| 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 |- h7 D' N6 t! ~9 x4 E
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+-----------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+----------+-----------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-----------+---------+-----------+---------+--------------------+
+ N) F7 F5 J: z) S0 t1 row in set (0.01 sec)9 L5 Z* c/ ?: d
MariaDB [nova]> select id,uuid from instances where display_name='test1';
; I9 u6 a' Y5 k. b R+----+--------------------------------------+* \% t$ O+ c! _" w7 F
| id | uuid |
7 s1 X! Q% ?3 R) w' X& }9 a% p% c+----+--------------------------------------+
, H# y( K! Q- T. b$ z2 L! U| 2 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 |
+ u: a& i1 ^) Y. T8 y- L+----+--------------------------------------+
/ z# ?% |) @5 C1 row in set (0.01 sec)
* U& ~5 r c: I! N k, LMariaDB [nova]> select id,uuid,display_name from instances where display_name='test1';1 d6 x; `3 R7 x0 s
+----+--------------------------------------+--------------+
! U# C4 Z Y+ }- q# s4 _| id | uuid | display_name |
1 Y( A0 m" u+ P6 [* d0 h+----+--------------------------------------+--------------+" Y# K! @. [5 j0 z1 J
| 2 | 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2 | test1 |3 H3 p& t- H6 w" {; w3 X
+----+--------------------------------------+--------------+
& [6 k+ W( P1 L/ F. s1 row in set (0.01 sec)
: w6 j" U1 s7 A2 b$ d" {" p2 S8 P; j
数据库也无法查询到：% F7 }+ i Z. n
放弃吧，反正也不影响openstack平台使用：: G/ @4 L/ l; e9 ?0 t7 l! ^
5 t: ]! u0 R+ p8 w0 _0 V
% [8 E6 L! ]2 ]; R! K另外解锁下我们界面上看到的被锁虚机：, P+ k8 [: z. z7 o, w, X" O
[root@controller1 ~]# openstack server unlock 7b01d71a-40d4-45fa-bf5c-97e676b2b9a2. w- f: ?7 `7 G7 w+ W( Z/ l
9 m# a' T$ e) s" N- J. w今天的处理就这么多
; L9 M( u: ^% H! D- r6 p |
|
/4 
窥视卡
雷达卡
发表于 2021-9-7 11:29:33
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
照妖镜
楼主
