|
|
mariadb删除glance数据库中镜像文件，使用update set 修改运行状态一次操作记录：
5 n+ I# r/ d6 Y" ?! C' CMariaDB [glance]> select * from images\G
* J3 ^* c- }$ J*************************** 1. row ***************************4 \: ]$ ] f, ^ b- |4 L
id: 0470245c-ee24-488f-89c9-622fd85e9ade
+ B {: K7 P0 E7 u) ] name: centOS7.9-x86-ssd5 C6 b3 h# J- p9 a3 D7 u ^% G
size: 3221225472' V5 M9 H/ R7 A2 r
status: deleted9 ~/ ?) N/ ~* z5 K0 Y: r' J. _7 M
created_at: 2022-04-08 12:48:27: ~: S3 r) N8 }- ^
updated_at: 2022-04-15 01:04:25: b$ _* J5 t7 d8 p! L
deleted_at: 2022-04-15 01:04:254 w* r& e x, h, X6 J( @4 f0 Z
deleted: 1
, S j4 e1 H9 H$ Q! [- N disk_format: raw
0 Q$ L$ a: v$ \- R5 r8 o* Qcontainer_format: bare- p& r B% }: ` e+ r0 v! d; T
checksum: 6067ba67d340d6849fb08ad2dc1dc752
2 `( k/ l2 A3 m% k6 ^ owner: 6f0124196ea74eb79fbcf370add3ca7e
2 z& r' U( y- ~# e min_disk: 00 R) c5 r1 i1 Z/ c7 K
min_ram: 0
) U5 @& Y4 f; v$ I! F protected: 0
3 ?. k: q9 _$ a" k& T, S3 x virtual_size: NULL) [ ?. Q" |+ q( ~! r
visibility: public: V: F' L2 j8 ]( D: n
*************************** 2. row ***************************& L" _' b7 C7 d& a
id: 18804abd-9cba-4a94-8ceb-ba9b12f9fc47
* @' s" P( j/ |( H name: RHEL-Server-7.9-hdd-2.4T- m9 [/ m! G( u8 k5 ?! s5 y
size: 3006477312
# r }* C, i5 v, B+ Z: { status: active, q1 r7 C( J7 D
created_at: 2022-04-12 02:44:15
. y! z' s) F" T. b4 c" D& H% h o updated_at: 2022-04-15 01:04:39
: v' E" T% W o) A0 I4 i% m0 A deleted_at: NULL
' b% S. F( m6 x& k y. i deleted: 0& d( h6 j3 `0 Y& a/ m. z" ?: T) F
disk_format: raw
/ k: P/ T+ @3 d: Gcontainer_format: bare
. {* s7 x! D; P( p( \7 {0 v checksum: 3ddbd59c32a4ec8141018ee9a433c78e
' \7 }5 Q1 T/ f, g( D3 \. u owner: 6f0124196ea74eb79fbcf370add3ca7e! ^( _* n$ y- D% {2 `9 l
min_disk: 0
( Z+ ?, @0 ]) R7 a8 T# g min_ram: 0
. p4 R5 O8 o1 n0 g protected: 0) I9 A) `4 R5 o: i
virtual_size: NULL
7 `/ r4 Y: q+ a, Z# Y2 f: T visibility: private
: M* x: I. }/ } |" R! [*************************** 3. row ***************************+ b% T# R8 r$ b Z* L
id: b9c335c4-34a8-498c-a735-82567f7ef186
m4 ]7 Q% f4 [. d- w; q5 T name: rhel-server-7.9-ssd
7 h, K$ K" E; R* e, H1 {/ @4 v size: 2684354560& |4 k8 P% e6 l* f0 K! W/ J4 O, N
status: deleted4 q5 ]( r" n; {, H% d* n
created_at: 2022-04-11 07:22:43
3 ^$ r2 L8 e4 U( N, c updated_at: 2022-04-11 08:02:40' P9 \6 f) S: P9 O7 \0 W
deleted_at: 2022-04-11 08:02:40: k" u$ l. L8 d, p& k; z
deleted: 11 [4 y$ }. l$ `) z
disk_format: raw6 y3 F+ g+ @) F: I" g- \9 e1 y
container_format: bare4 e! T: o# w5 a* }
checksum: 67e20fa3da128b17c3ec01d03e1e293d+ T# [7 C, v+ c% I! c) b1 b
owner: 6f0124196ea74eb79fbcf370add3ca7e
& v; u4 t% C5 y2 P9 y* ]/ n min_disk: 03 O& o3 o# y x* E3 r
min_ram: 0
' [& d& L- c. y6 i. ? protected: 0
" k6 |6 c; S3 \+ J, u' m virtual_size: NULL
$ k% {4 O5 G# H3 `. ?4 o- l visibility: public
3 N# o" ?7 p+ `4 f: l2 y R*************************** 4. row ***************************
8 s8 x O3 k2 n( H1 C, _0 Q id: ea333f95-79c3-4ce4-856b-a397cc963d77) z5 K8 ]# @# A# |) T& B
name: windows_2019_x64-hdd-2.4T+ y. M6 _* k/ w8 G, r' d$ T
size: 12884901888+ z6 B& ~+ ] u5 `6 \8 m
status: active
) n+ M9 N7 V; ]7 x- x created_at: 2022-04-13 01:25:56
) I' a6 |( z+ P$ Y0 f) L; V updated_at: 2022-04-14 03:42:54$ I6 p: J/ k, J# f/ H K) e: D, V; d
deleted_at: NULL
0 F6 n% \, V# q+ D7 k deleted: 0
- j2 O5 r7 Z0 y4 z2 I disk_format: raw) H; ?1 x$ }% r1 A% ?; R& T
container_format: bare9 e2 S B1 y4 W
checksum: 2eabbd70218411fdb021c4cdb790b82f; |* G/ c! m t1 ]: ~! z. |
owner: 6f0124196ea74eb79fbcf370add3ca7e
% B4 s; D' U% m0 X/ O min_disk: 00 M0 D: O7 A: ~7 i; ~9 E- o
min_ram: 0
2 j- Q9 O$ P3 \' B1 H6 p5 y( k protected: 0
5 y8 w5 }. K+ S virtual_size: NULL. f& m( Z8 l6 G2 L8 g; ^. x
visibility: public
2 L/ q* F4 [/ r! m& i% W$ m*************************** 5. row ***************************
# P, j1 b0 P. f" q" a id: fb5fe7ed-ba56-4ae2-a483-af3cc0cce891. o7 S* ]) D0 S" e% L+ D
name: RHEL-Server-7.9-ssd2 }* n, {+ _* z! o
size: 3006477312" M3 C" V; Y6 n; [/ p) B- `" G' m
status: active
4 l% l5 S* d6 M1 f& O; y- F created_at: 2022-04-12 02:16:14
0 s5 m+ R8 N$ q& |- E updated_at: 2022-04-15 01:04:461 Z3 o! S& o% F2 s2 u6 {3 U4 G$ X
deleted_at: NULL
" J# d' F% e6 g0 o deleted: 0. M" M( Y! V! r. I" W$ A+ L- q
disk_format: raw9 R& l4 ?2 t5 E7 u: R+ F9 D
container_format: bare
" p+ ?3 o' ~% _; K" H' T! v checksum: 3ddbd59c32a4ec8141018ee9a433c78e
: W$ c, y' s6 f8 x owner: 6f0124196ea74eb79fbcf370add3ca7e1 t z; p+ H! _0 p+ F- |5 D5 \4 n* B
min_disk: 0
+ N& P. g4 e, v7 d min_ram: 0
8 z& F) c9 V& o3 a6 R protected: 0
& p0 F* Y; y V: m) a virtual_size: NULL. P* H/ V& n9 [: g$ ~4 g( A p
visibility: private
! \5 p" B2 g" f2 F5 rows in set (0.00 sec)
. } X* ?' |! t5 z$ t) \
5 v/ r W; p+ R) ]7 `MariaDB [glance]> update glance.images set deleted='1' where id="fb5fe7ed-ba56-4ae2-a483-af3cc0cce891";
& j5 _, k3 m/ x8 o& [, TQuery OK, 1 row affected (0.01 sec)
+ D: k) n _- I( P+ P0 N( URows matched: 1 Changed: 1 Warnings: 07 {7 ^$ V: i! F5 I3 b: ^. Y8 l3 y
MariaDB [glance]> select * from images\G
/ H& ]' h; T; ]+ `. K*************************** 1. row ***************************/ J. Z6 h9 ~5 c4 V4 l3 q
id: 0470245c-ee24-488f-89c9-622fd85e9ade, m8 q9 M3 `1 Z- h. K5 D6 V
name: centOS7.9-x86-ssd
& M9 M& R! }' V; o4 Z- O7 m b size: 3221225472
D/ J8 W5 p% h5 ^, r- r" }6 c status: deleted
/ T5 Y7 ?) K* n/ l created_at: 2022-04-08 12:48:27
' ~& j# h$ r+ \/ w updated_at: 2022-04-15 01:04:25- f! r: u1 y% O+ M# F- y
deleted_at: 2022-04-15 01:04:25
7 R8 v: n( V% Q2 S8 z& b! a6 f deleted: 1
& _$ [3 n. I" F; A disk_format: raw
% y( u, y5 z7 {6 }# Hcontainer_format: bare3 k' c7 e. v5 @
checksum: 6067ba67d340d6849fb08ad2dc1dc752
5 X7 X8 g. }, o% L5 Y owner: 6f0124196ea74eb79fbcf370add3ca7e
: a4 Z, L& U" ? min_disk: 0
5 j+ b0 w& F! y( x) { min_ram: 0
2 I: W( w/ O! f: n2 D) n/ T protected: 0( X, M5 }6 N% n+ v+ J3 T$ D1 L! F
virtual_size: NULL
0 {+ D( a3 A# |3 N6 g0 ] visibility: public
0 K! g: H) S1 W2 d- [+ `* H*************************** 2. row ***************************
4 d- e1 o- Q- _( k- g2 u id: 18804abd-9cba-4a94-8ceb-ba9b12f9fc472 W; _! t ~+ B# M
name: RHEL-Server-7.9-hdd-2.4T
+ J2 }3 T; e0 C5 w size: 3006477312
: x, ]- K" ~6 o: M9 g& P$ `) `; v status: active# J" @( J9 B( }( j, ^& F
created_at: 2022-04-12 02:44:15: \ A6 L' O: J. K: ^8 @& @
updated_at: 2022-04-15 01:04:39' \( H! [# x6 k0 C
deleted_at: NULL2 |) N/ k8 ~4 w
deleted: 0
( P: C1 U4 ?! `, t7 v9 t7 u# P0 p disk_format: raw
! X, }5 h' T/ I+ \& T7 J ]container_format: bare
7 F6 C0 J* V$ d1 M checksum: 3ddbd59c32a4ec8141018ee9a433c78e
- \! k* y! i: k# I owner: 6f0124196ea74eb79fbcf370add3ca7e- x m- @1 {% n- _% ~8 \
min_disk: 0
' l+ ~1 p9 X$ n2 O* M" X7 L min_ram: 0
+ U% I. l6 x! x, L; O& o protected: 0
2 ?. S" p3 I! O" }) m; \% y+ Y virtual_size: NULL
l) j- M& s7 f5 A# v: e visibility: private
9 }9 i, V8 Y7 n& K*************************** 3. row ***************************: v3 c$ G- }2 g, X4 N# w
id: b9c335c4-34a8-498c-a735-82567f7ef186& t& X: H3 w+ k
name: rhel-server-7.9-ssd
3 C) J* Q+ z9 } }; o size: 2684354560
' ~# u f9 H8 W3 o$ j status: deleted5 Q$ C& R; ?' {2 s- O
created_at: 2022-04-11 07:22:43
. B& ]7 E4 H; o updated_at: 2022-04-11 08:02:40
. t8 I0 O B9 K0 E3 _' o0 S8 J deleted_at: 2022-04-11 08:02:40. l# [7 L$ G; @7 o
deleted: 1
5 r, M2 a+ b# H8 y2 O+ Q( @ w* w disk_format: raw' O8 j* X5 q: J; k+ V3 a! j% \
container_format: bare+ ~; t% @4 e8 u4 {9 u5 x
checksum: 67e20fa3da128b17c3ec01d03e1e293d4 P4 d3 \( k9 @! g. j2 _
owner: 6f0124196ea74eb79fbcf370add3ca7e F8 G% z" e3 l! i4 \ a" ~6 D6 Z
min_disk: 0
! Y6 \6 m) h# w$ C min_ram: 0% x b0 E; R* I% m" ]( \5 D
protected: 0
4 P4 I# t; H. C; p3 C: [$ k virtual_size: NULL( o/ t! j' O' J9 `( u4 n
visibility: public8 R, o3 q( A/ o: q7 f
*************************** 4. row ***************************
- D& ]- N) V9 e1 s6 W id: ea333f95-79c3-4ce4-856b-a397cc963d77- T; i9 g' P8 J
name: windows_2019_x64-hdd-2.4T
# f& s: p& j$ R# s: p size: 128849018887 B6 }5 {( z; Z! R3 h' U! C8 j
status: active
6 F) ^: ~; |% b' R1 ]/ u created_at: 2022-04-13 01:25:56
* x9 u& p5 t8 o4 Z1 t$ A+ e updated_at: 2022-04-14 03:42:54
) |; h7 f3 L9 O" o deleted_at: NULL. ^- m+ r7 k5 p7 q9 F* n
deleted: 0. l D' k( ^) E4 ]" o
disk_format: raw/ ?, G9 [; ?5 s- z$ i- E/ [
container_format: bare# A% x8 q( O2 M; u4 i
checksum: 2eabbd70218411fdb021c4cdb790b82f# [% x9 r: I1 z: n
owner: 6f0124196ea74eb79fbcf370add3ca7e
( f0 U2 g! c. M9 j3 Q D! } min_disk: 0
9 O+ S. y# B) s8 X2 y, T6 N min_ram: 0 L3 q3 B; H( D2 e+ O4 M
protected: 0
d6 L3 M6 h6 ]+ _ virtual_size: NULL
( A# k( I# _5 r visibility: public
! f" J7 t. C P1 d% ~: ?*************************** 5. row ***************************
1 s8 @2 S; O: v& S2 n; } id: fb5fe7ed-ba56-4ae2-a483-af3cc0cce891
- p+ u) L4 t* I9 e: |" G# S name: RHEL-Server-7.9-ssd
2 t6 n" [; s5 V9 H3 i size: 3006477312
6 l$ B5 [- P% t/ B/ i status: active
1 h* m3 d7 O/ V/ W5 S7 M created_at: 2022-04-12 02:16:14
) h" O5 [4 B8 i; B( @% Z ], U updated_at: 2022-04-15 01:04:46
) I; o8 N, Y' b1 B, M- g0 B2 w deleted_at: NULL6 Y: I4 X* v7 k3 n1 k
deleted: 1
. s* H H& ~7 _. h* l7 y8 d* A disk_format: raw5 U- D+ G. O* n2 ?# U
container_format: bare
: G4 A: w$ U, ] checksum: 3ddbd59c32a4ec8141018ee9a433c78e
# E* I' a C2 x+ U6 [ owner: 6f0124196ea74eb79fbcf370add3ca7e- L g2 A" |9 e0 U
min_disk: 0
" b: S; n, {- v1 g7 s min_ram: 0
, z( C5 l: s/ i1 Y" y protected: 0
( F* j- Z+ ~+ n virtual_size: NULL* M. q* A8 y6 b t( p' a
visibility: private
$ \; v4 k# [7 E5 B& Y5 rows in set (0.00 sec)3 c: [2 f# e; _+ N9 F, ~0 Y, K
MariaDB [glance]> select id,name,deleted,status from images;0 N4 L: h$ g& t4 C3 v
+--------------------------------------+---------------------------+---------+---------+% Z1 P7 Q2 I, Z
| id | name | deleted | status |
2 ^* Q! h! a _; X& l- _& _+--------------------------------------+---------------------------+---------+---------+4 e( R' e" r: b' T" e4 Q) @2 ?4 ?
| 0470245c-ee24-488f-89c9-622fd85e9ade | centOS7.9-x86-ssd | 1 | deleted |& x/ U6 J1 \5 j) S* G) f8 U
| 18804abd-9cba-4a94-8ceb-ba9b12f9fc47 | RHEL-Server-7.9-hdd-2.4T | 0 | active |
0 T" L" B( H8 s0 t1 q/ X9 d| b9c335c4-34a8-498c-a735-82567f7ef186 | rhel-server-7.9-ssd | 1 | deleted |( I4 K! A( b/ ~+ H O/ \0 D8 T/ Q1 p: W
| ea333f95-79c3-4ce4-856b-a397cc963d77 | windows_2019_x64-hdd-2.4T | 0 | active |
. g9 a% o/ N! V0 K7 R( H& t| fb5fe7ed-ba56-4ae2-a483-af3cc0cce891 | RHEL-Server-7.9-ssd | 1 | active |- c" Y9 i4 E% e0 Z+ U
+--------------------------------------+---------------------------+---------+---------+% \ N/ b! \8 G# |
5 rows in set (0.00 sec)1 h' i7 C {- I A
MariaDB [glance]> update glance.images set deleted='1' where id="18804abd-9cba-4a94-8ceb-ba9b12f9fc47";4 X4 A, }+ k. m6 V8 w7 ?6 }
Query OK, 1 row affected (0.00 sec)7 E9 F9 I8 c) E( B
Rows matched: 1 Changed: 1 Warnings: 0: @0 X; P5 k, z- S" R
MariaDB [glance]> select id,name,deleted,status from images;
; E' M; f8 s8 r) O) q8 \+--------------------------------------+---------------------------+---------+---------+
. [- d0 }" k2 t4 e% w9 U| id | name | deleted | status |) F( j9 L. G& n% ]
+--------------------------------------+---------------------------+---------+---------+
4 ~. d8 P# k0 |9 l `- y+ S| 0470245c-ee24-488f-89c9-622fd85e9ade | centOS7.9-x86-ssd | 1 | deleted |
/ q' r7 r' B% Q6 i% A0 I| 18804abd-9cba-4a94-8ceb-ba9b12f9fc47 | RHEL-Server-7.9-hdd-2.4T | 1 | active |
6 a/ v+ U A" W8 G- l4 t" }3 C/ ?/ T| b9c335c4-34a8-498c-a735-82567f7ef186 | rhel-server-7.9-ssd | 1 | deleted | V8 Q) Z1 e. `; F' S: H
| ea333f95-79c3-4ce4-856b-a397cc963d77 | windows_2019_x64-hdd-2.4T | 0 | active |
- e: w9 G" {: s1 a& Q; U| fb5fe7ed-ba56-4ae2-a483-af3cc0cce891 | RHEL-Server-7.9-ssd | 1 | active |' o S0 w( t2 R7 I. b
+--------------------------------------+---------------------------+---------+---------+5 e- t4 J+ x/ `2 D# a0 o0 T1 A
5 rows in set (0.01 sec). P2 t, A5 {5 T
1 h( @, G* E& z1 P
7 q8 f/ i0 H5 Z完成更新数据。切记不要delete数据，因为这些数据库表之间有关联，会导致数据库凌乱。解决办法一般都是update状态。切记切记。
6 w- m" P' W0 e: ^- M |
|
发表于 2022-4-15 09:26:14