|
|
[root@controller1 ~]# openstack server list
1 p$ j( X8 y& ~+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
! l r6 m; \$ d) p/ x* U& Q| ID | Name | Status | Networks | Image | Flavor |* |1 D: u* b' j1 P5 w* b
+--------------------------------------+----------+--------+----------------------+-------------------+----------------+' r/ e2 @8 N- n/ j- f9 _
| 2ec04bca-0a42-4143-80f6-f1d6ac33d685 | test-001 | ACTIVE | TT088=192.168.2.8 | Centos7.9-x86_x64 | type-2c-2g-50g |
( y- C8 L. W. x' U! S| 6fd6dc2d-4965-4854-8a10-142f8570e2b5 | test666 | ERROR | bridge=192.168.0.204 | | type-1c-1g-10g | P- ^* S8 n! e( E3 [
+--------------------------------------+----------+--------+----------------------+-------------------+----------------+
; @7 C/ ^% k o/ s
) G- K2 O- U+ |# w( {; PMariaDB [nova]> select id,host,display_name,uuid,deleted_at,deleted from instances;% } x- |) {8 ?9 Z% G- z1 {
+-----+-----------+-----------------+--------------------------------------+---------------------+---------+
1 j3 a1 c3 E8 g0 a, R5 O% Q| id | host | display_name | uuid | deleted_at | deleted |( \( y& W7 f! M2 `
+-----+-----------+-----------------+--------------------------------------+---------------------+---------+% @+ O# ^. a6 X6 N
| 4 | compute02 | test1 | 938a6433-e275-4d50-ad07-5fc72c89dd48 | 2021-10-12 10:28:17 | 4 |0 ]3 |, o( K! R( G
| 6 | NULL | 常稼笙测试 | a061747f-efb3-4602-9f55-b4f7a489297d | 2021-10-12 10:53:43 | 6 |
7 a4 F2 P0 q3 p" }9 J1 z8 N| 9 | NULL | test1-1 | 72603382-6d2a-408b-af03-888a2fbb5055 | 2021-10-12 10:37:32 | 9 |5 {9 N& { F5 d; {7 [/ f
| 10 | compute03 | test001333 | 0feee582-3d51-4a63-b60a-fe0188ee2cbb | 2021-10-13 12:07:14 | 10 |3 [0 u4 v: V0 r0 ]- ]- {2 w1 N
| 14 | compute02 | changjiasheng | 9fbd748d-c1d9-4a5b-b6ab-bf54adc60ee9 | 2021-10-13 09:39:32 | 14 |
# F7 V# \2 S R# k7 F m& K4 O| 19 | compute03 | zhangyj_newname | 08ed4db0-d7c9-4395-8dd2-bac2c2bcf7b7 | 2021-10-14 01:44:02 | 19 |2 _5 _) {+ C1 q( f" T
| 20 | compute03 | zhangyj | 7fadfc78-3517-47e3-a938-4f3b73b2d84d | 2021-10-14 03:50:40 | 20 |
# \4 ]- s0 A# b( p, P| 23 | compute02 | delTest | f165b3cc-368a-4fd1-b707-45f1d87f7005 | 2021-10-13 12:07:02 | 23 |
8 M. Z) U# N+ h: {. I3 |/ W| 26 | compute03 | haha | 76d021f5-13ab-4575-a1c6-c7857118b4e5 | 2021-10-14 01:53:39 | 26 |2 \, f, l+ g; K
| 28 | NULL | xixi | 1729362e-4671-4656-8e26-5b54ce80baae | 2021-10-13 02:43:39 | 28 |
* h3 [" m2 f; O9 j; v( y| 31 | compute02 | xixi | 678a0a4e-ab32-4fe1-955d-df11dd080795 | 2021-10-13 02:46:17 | 31 |* {, y0 V: l" B. l9 { n) f* c4 Y
| 34 | NULL | xixi | f606f8f6-6fcf-422a-978e-65904f6c105c | 2021-10-13 02:48:45 | 34 |/ g2 S( y" U8 R# f& r- M
| 37 | compute01 | testlon | 779c6e00-b70e-4b2c-bc2e-a3cb6b156437 | 2021-10-14 01:53:43 | 37 |( x# m& q1 [* w2 s
| 38 | compute03 | xixi | 8e1f217f-b3a1-4cc6-a626-14edb6a57c6b | 2021-10-14 01:52:56 | 38 |& K' [' d# u& j7 N2 e) A& Y
| 41 | NULL | 11 | e26a1932-0d5c-44b8-a74f-d6a80513f867 | 2021-10-13 08:20:15 | 41 |
2 Z' F+ z( q/ |, Q; t| 44 | NULL | 22 | 7c9858b2-703c-45d5-837f-be87ee652e81 | 2021-10-13 08:24:28 | 44 |
2 d( B, J4 w6 r0 L6 ]: V| 46 | NULL | 333 | 88b1c1be-dd4b-4ac1-b05a-00c6223f7108 | 2021-10-13 08:32:22 | 46 |+ H6 N3 E7 {/ a4 l+ x; T! j
| 48 | NULL | 44 | 179015fd-b1fa-4c22-9463-60427550df61 | 2021-10-13 12:09:05 | 48 |
$ x3 ]# ?- r( \' j! }| 51 | compute03 | uuuuuuu | c6c4e111-8e61-4141-8765-ac9ca3a9afad | 2021-10-13 08:53:32 | 51 |3 s1 P! d) Q5 @8 }
| 53 | compute03 | AAAAAA | 0ede0305-fd99-479f-a460-8d8f7154cf22 | 2021-10-13 08:42:44 | 53 |' @' B: q$ l/ v5 {
| 54 | compute03 | youjuan | 6221b997-7002-444b-9ba0-fa26aede5c31 | 2021-10-13 08:53:37 | 54 |& _5 f% {' {! K, G Q# a
| 57 | compute03 | meiyoujuan | 502a93c0-8c26-4166-b8aa-4c7e8a8b955f | 2021-10-13 08:53:35 | 57 |
% ^& t8 q/ ~! T; R( w5 @| 60 | compute03 | tianwanggaidihu | 085f6f26-36d3-423f-904d-d0980ba60fea | 2021-10-13 08:53:36 | 60 |8 @6 P0 W1 d1 l4 i, e
| 63 | compute03 | 历史 | 9a20495b-b1ee-430c-ac66-199734cc656b | 2021-10-14 01:54:17 | 63 |
- L2 W9 J% j7 Q. A5 || 66 | compute03 | tianwanggaidihu | bc2abfa4-0dd7-47d4-a4e3-f088053d8314 | 2021-10-14 01:52:10 | 66 |
# {- t* K. z' `2 s) G( m- N9 J| 71 | compute03 | ceshi007 | ad046b89-b971-43e7-af35-8d85e1463133 | 2021-10-14 01:52:15 | 71 |/ D( ~5 `2 A! ~. \# X$ \* z
| 74 | compute03 | ceshi008 | e2010abd-e1a1-4b15-a556-8892feb97678 | 2021-10-14 02:06:02 | 74 |
( K1 V+ g6 e! B% B: w| 77 | NULL | houys-test | a8398a06-5bc3-4e1d-9fef-d3cee1783e8a | 2021-10-14 01:42:47 | 77 |
! m v3 e* P- v| 79 | compute03 | ceshifalse | b74e8b8a-0cba-44cf-b7f5-1fb9a6b0573c | 2021-10-13 09:38:51 | 79 |
$ h+ k3 c/ S! ^* J8 [| 80 | compute03 | ceshiTrue | 7558ea40-ac22-42ab-89e3-78acbe1e3409 | 2021-10-13 09:25:10 | 80 |$ t+ v9 ? D5 i' Q! x; w
| 82 | compute03 | ceshifalse | d90ec898-8e14-4bd1-9800-4d32accaf031 | 2021-10-13 09:50:20 | 82 |5 L0 k, M0 t) L7 P# X6 s
| 84 | compute03 | ceshifalse | e7d91f84-ce0d-4021-acee-e424bf4a5250 | 2021-10-13 10:05:11 | 84 |, y' V# A, O0 E! y1 n; J
| 86 | compute03 | 历史2222 | 4f46ea70-7a74-4c12-bab2-9e2b52138e6b | 2021-10-13 12:07:08 | 86 |5 c2 m. n9 a; N" X& r( h* C1 p
| 89 | compute03 | ceshiTrue | d3309f72-a70a-4dfa-8ca5-4408e37e44db | 2021-10-13 11:21:02 | 89 |
. O+ c3 \' H+ {6 _! _| 92 | NULL | 郭德纲 | 74d2dd02-01ca-425f-aa88-e24433a6562f | 2021-10-13 11:55:51 | 92 |" Y# L& y# H* v8 ~, Q6 B- ~# U: L
| 95 | compute03 | 郭德纲 | c31d70fb-c736-4896-b6d2-340901d558e0 | 2021-10-13 12:06:23 | 95 |
* B4 x, B' U. N( [# [| 98 | NULL | WWWWW | cacfa3a1-27a6-4cfe-91df-085dee4024ca | 2021-10-13 12:05:46 | 98 |! S0 q/ g/ c1 k4 U# C7 [
| 99 | compute03 | 郭麒麟 | d5eeb2c2-1eda-4d62-b6a3-3162569f73e2 | 2021-10-14 01:14:58 | 99 |4 l: F/ B8 q+ E
| 102 | compute03 | ceshifalse | 81d230fc-3fe6-43f3-bf2e-1d2ee6d11e44 | 2021-10-14 01:14:30 | 102 |. l' S$ C+ C! A' l, D- b9 X
| 105 | compute03 | llDelTest | 4e5cc39c-3c07-470b-99c1-96de4ca102a6 | 2021-10-14 01:53:14 | 105 |/ c' Y8 x: D5 ]- ~0 h9 B, a: ~& i
| 108 | NULL | ceshiTrue | e404a911-ba23-4cba-a97f-f53dbc3c3edf | 2021-10-14 01:52:30 | 108 |% D- G. h+ E* P( z P, h" t
| 109 | compute03 | volumes | cde2a84c-7992-4656-87ab-5b5271bd4459 | 2021-10-14 02:05:31 | 109 |, j0 y8 i( T/ N0 ^, e/ w
| 112 | compute03 | ceshiByImage1 | bb76e37d-af1f-4d23-acbc-7a518ccbaf52 | 2021-10-14 03:08:36 | 112 |
3 E+ H9 e8 ?) @9 n& i$ _" j5 o' M| 115 | compute03 | ceshiByImage2 | 268dfd9d-31d4-443c-af6b-ff3af8820c47 | 2021-10-14 03:09:05 | 115 |
_: A6 x% y/ F& e5 U| 117 | NULL | EEEEEEEE | 0fda443a-25de-4c3a-9c0a-3f5e330b1816 | 2021-10-14 03:22:08 | 117 |2 @8 C; @% l9 |1 V8 S5 c. \
| 118 | NULL | guodegang | 6796679e-578b-4240-9be2-ab31b720885d | 2021-10-14 03:22:37 | 118 |5 i7 K- n: ^+ e& `
| 122 | compute02 | changjiasheng | 7c5b782a-841e-40c2-bd90-67bef9499c2f | 2021-10-14 05:32:18 | 122 |
! n& y" q4 o, _) I3 O) c| 123 | compute01 | ChangKuaiZhao | af88e86d-a283-4cc9-82ad-baebda2b3766 | 2021-10-14 05:31:42 | 123 |) ~1 i, h. ~' V: N2 p- m
| 124 | NULL | guoqilin | cf7730d6-c7d4-4791-bba4-6e45f6f6606e | 2021-10-14 03:32:08 | 124 |& a" a3 m5 {" r# F& ?
| 127 | NULL | guofenyang | fb9c68dc-f322-47d5-9642-6a649fb3b827 | 2021-10-14 03:32:35 | 127 |( `8 E9 ~( o u0 p; C, ~
| 129 | NULL | yuqian | 220f1285-5c04-4e61-8135-f3cd9cb19542 | 2021-10-14 03:32:28 | 129 |5 i6 M7 U% q# m& G3 r
| 130 | NULL | qwe | 2f46d807-c37b-4a31-b7ab-ad1d632ffbb6 | 2021-10-14 03:51:04 | 130 |- B3 [% Z6 n+ c" P# Q4 [) P8 m
| 133 | compute03 | t1 | a1b89b81-748b-454e-9e17-2336c9d2a0ea | 2021-10-14 03:45:43 | 133 |
" u- Y# t( m/ `| 136 | compute03 | test2 | 0e5c3d39-670b-4e1c-8a0c-1ccdd1ac7215 | 2021-10-14 05:31:41 | 136 |
: t6 F% V1 s( Z+ M |5 A+ C7 Z1 g/ _' I| 137 | compute01 | guodegang | 0e672211-6960-4f54-86e1-f35eeaa70256 | 2021-10-15 07:29:03 | 137 |5 i3 @# h a+ l. U
| 140 | compute03 | guoqilin | 89fdacf0-17f2-4c32-b106-349dba32788d | 2021-10-14 06:37:22 | 140 |) d5 ? u( |7 M# f7 m l
| 141 | NULL | guofenyang | 204691d5-abb8-49a4-acc0-96c117b31a2b | 2021-10-14 04:33:12 | 141 |+ v5 U) M2 T8 R q; s* N" x
| 142 | NULL | guofenyang | 2301efae-00de-417c-be1a-b4d0c49ae86a | 2021-10-14 05:29:56 | 142 |
& t$ s) z" ~" I& m| 145 | compute03 | guofenyang | 11e0c122-ca0f-4ce9-b7c9-0e40997ce05e | 2021-10-14 06:43:41 | 145 |" H$ H0 y6 }, M% p1 u9 }7 e
| 148 | NULL | lixiaolong | b607f2f5-89fd-4f80-b99d-5a598cac087b | 2021-10-14 06:20:20 | 148 |
1 F$ Z1 U0 e# ]| 150 | NULL | chenglong | 1cca25f3-a523-4882-9e38-5a60f15d21ca | 2021-10-14 06:20:01 | 150 |: ^# F' i' i3 R e0 `" D) S) t2 g
| 153 | NULL | volumes | f8702de5-6ded-41c4-abef-ba52b9cbe04c | 2021-10-14 06:19:59 | 153 |
: p8 @- e! |5 f& w. I3 ]| 155 | NULL | 测试12345 | 5c0d5b37-6a5f-4531-b9e4-b6624e176f5c | 2021-10-14 06:18:54 | 155 |7 X) ]0 D$ d9 n* W' ^; \) v
| 157 | compute02 | volumes | 730fcda4-807c-4c76-b49c-d9e78062ab1c | 2021-10-14 06:31:33 | 157 |$ K1 L( ~, I% e! P9 |
| 159 | compute02 | zhang | a718b56b-2f43-4b16-8eb6-f5b22f1e55f9 | 2021-10-14 07:31:34 | 159 |
5 q0 G8 `# M2 h" t( N# w R. ?| 162 | compute01 | li2 | 401c2417-9255-4043-9d9f-da845bdca6ac | 2021-10-15 02:54:58 | 162 |9 W1 Q" h, ^$ m8 t( r6 p2 X& U) {; d
| 165 | NULL | llDelTest | 4039e626-3341-492a-bc09-81b1d1bdc4df | 2021-10-14 07:32:40 | 165 |
) O. S* Q' M' y| 168 | compute01 | DontDelete | 4f1a3a2e-483e-4cc8-92a7-9d8e11e20de6 | 2021-10-14 08:26:35 | 168 |
7 R0 W+ ^1 c, ~- Z| 171 | compute03 | changjiasheng | 34dc8055-a7ff-4a20-a0b5-2b654c99df43 | 2021-10-14 08:05:09 | 171 |
( w" S: R3 s2 E+ { ? O9 Q" K| 174 | compute03 | test01 | 9cdb63ef-b287-4d28-a97a-033e8fb14e8a | 2021-10-15 07:27:55 | 174 |
* Q- a3 I8 {2 h| 180 | compute03 | ceshi111 | 07b32d54-b59b-445e-b75f-e70a95999979 | 2021-10-15 04:36:14 | 180 |1 G# j3 Z$ P" y* W7 G+ B" K! ^, X
| 183 | compute01 | ceshi1222 | 624e250f-3800-444a-98cd-da2594775b16 | 2021-10-15 07:26:30 | 183 |" I- j9 z) E/ B; @
| 186 | compute03 | ceshi121212 | aba72e5f-9fe4-416a-9e3a-3b47c932bdda | 2021-10-15 04:36:43 | 186 |
1 z& Y2 S, d' v, m1 W% k+ g% p| 188 | compute03 | 1231321321 | ceb64f3a-3720-46c8-ba6d-2b47e636ea16 | 2021-10-15 04:37:31 | 188 |
( o, T( \. s& t2 g| 191 | compute03 | 0000 | eaba831b-5ebd-442f-b21e-350e2a4ebcb9 | 2021-10-15 02:56:41 | 191 |5 N) q+ r4 d5 p$ G: ^ e* @
| 192 | compute01 | testSize | ff41c277-53d5-4890-a9c2-2cf1f4cd5c86 | 2021-10-15 03:14:30 | 192 |( D3 N6 }, c, M- k: l0 |& ~* ]
| 194 | compute01 | ceshi890 | 9166f684-a2ea-4509-9066-d6f982c9581b | 2021-10-15 04:36:31 | 194 |8 U) E' M C( G R) ^0 @( I
| 195 | compute01 | volumes | 88177290-230e-4a27-a0e9-460fe3849432 | 2021-10-15 07:40:33 | 195 |
' r" H6 p6 _: u" \| 198 | compute01 | test666 | 6fd6dc2d-4965-4854-8a10-142f8570e2b5 | NULL | 0 |
. g1 {, ?, k8 n. e" K/ F| 201 | NULL | test1111 | 91833a4a-c04b-4621-a6e7-0fb1f8334a70 | 2021-10-16 10:31:31 | 201 |
. e- t6 y; m$ `% D| 205 | compute02 | ceshi001 | ceb794a4-777d-41a6-ad5b-7052f486781f | 2021-10-16 10:34:33 | 205 |3 n d8 z! L8 j# x
| 207 | compute02 | Changjiasheng | ec71b60c-af2e-4069-ad15-d45e0873b8d7 | 2021-10-16 10:34:21 | 207 |
* ?) d q' M+ a3 r% v9 {| 212 | compute02 | 11111111111 | 10c39053-8bad-4641-88e6-1e50debde3d9 | 2021-10-16 02:16:11 | 212 |
5 W+ ? g' C% p- X" ^3 Q9 C# Q| 214 | compute02 | 2222666 | eb682f3f-c995-4bec-aabd-5589b3f3bcd6 | 2021-10-16 06:03:57 | 214 |
) A* a8 r$ a4 G% j4 M| 216 | compute02 | test-0011 | e67eb438-faae-4d22-be11-4fe2a05c621d | 2021-10-16 06:00:02 | 216 |
# G6 J2 K0 @# q; F6 L| 220 | compute03 | test-1016 | 00f29a7c-cea0-44ec-adb2-7752e3bd9592 | 2021-10-18 02:52:25 | 220 |
2 \2 L- n6 I# l- ~, t: f| 222 | compute02 | test-0022 | cb3e6077-acb0-4c5e-9e79-93659dfacca4 | 2021-10-16 05:35:47 | 222 |, {# b* G5 L9 z/ G4 S5 x' N0 V- ]
| 224 | compute02 | test123 | 726389af-2ac2-4fcf-8d5c-210b5c5082d7 | 2021-10-16 11:49:44 | 224 |
: r, p( u; L% Y$ l ?| 227 | compute02 | test-002 | 6a6c9520-c682-47b9-b5dd-a61dbdd6a6b5 | 2021-10-16 06:11:53 | 227 |0 d6 ^, q" A7 m/ V8 ?$ @! D2 t
| 228 | compute02 | test | c2387d59-3697-4fa3-ade5-4cbb7000b141 | 2021-10-18 03:18:50 | 228 |
4 j( S+ X3 D# b. W# T| 231 | compute02 | vm1 | f0cb8190-ad1d-4965-ad5d-d906c9abbd60 | 2021-10-16 10:31:49 | 231 |
# `; I) M" ?% m( |8 Y| 234 | compute02 | vm1 | e76bbf3b-e4a8-43c5-9703-f7b16772b9b3 | 2021-10-16 14:18:17 | 234 |2 e8 ]+ f+ W8 r& `$ q9 R7 [7 s
| 238 | compute02 | vm1 | b4354ffd-b1ad-46db-89d4-f1d09db103f0 | 2021-10-18 03:19:20 | 238 |6 X/ h% I' W( V* Z# F) y: I
| 242 | compute02 | ceshi111 | a11e853a-01a2-4688-90be-6a12bc64c359 | 2021-10-18 02:53:24 | 242 |) M! K' r( w9 w. K
| 245 | compute03 | lcyTestReName | a7e4e57e-0b16-4b4e-8d7b-81494b0b19d3 | 2021-10-18 03:19:02 | 245 |
/ o( | P: k' n8 Z| 249 | compute02 | test-001 | 2ec04bca-0a42-4143-80f6-f1d6ac33d685 | NULL | 0 |
% E% H% Q" Q6 X* {3 [+-----+-----------+-----------------+--------------------------------------+---------------------+---------+ Z& O/ l" M0 k
96 rows in set (0.00 sec)) }2 u9 o. y8 i+ }& y: {
8 p1 o' e2 P9 m0 \, ?MariaDB [nova]> update nova.instances set deleted='246' where uuid='6fd6dc2d-4965-4854-8a10-142f8570e2b5';+ K( T& _5 A1 e0 y
Query OK, 1 row affected (0.01 sec)$ d) K% e: K: C" C6 M5 m
Rows matched: 1 Changed: 1 Warnings: 0
O( S* U" r, b. I1 Z$ ^0 @4 \7 K# K* v' `3 b: l! H
[root@controller1 ~]# openstack server list
0 ^ { c& _$ a7 O8 u+--------------------------------------+----------+--------+-------------------+-------------------+----------------+
* E2 J2 h2 `0 M$ x7 D2 `| ID | Name | Status | Networks | Image | Flavor |
9 ~( N2 l1 F: ]9 J9 }+ {8 W+--------------------------------------+----------+--------+-------------------+-------------------+----------------+- F0 n; l8 @1 y. B: u1 K* B0 k
| 2ec04bca-0a42-4143-80f6-f1d6ac33d685 | test-001 | ACTIVE | TT088=192.168.2.8 | Centos7.9-x86_x64 | type-2c-2g-50g |+ e. t5 T, Z4 @' g& D8 K
+--------------------------------------+----------+--------+-------------------+-------------------+----------------+
, A. J* e$ D& e1 \: q, ^, C5 r$ p0 w- i1 y
|
|