|
|
mariadb删除glance数据库中镜像文件，使用update set 修改运行状态一次操作记录：
2 t( h" K3 U9 O- a# ?9 [MariaDB [glance]> select * from images\G; D8 x% B$ K( S" D, ?: S1 G
*************************** 1. row **************************** L3 V$ y: w' e
id: 0470245c-ee24-488f-89c9-622fd85e9ade
, v. s- { j1 W D2 X name: centOS7.9-x86-ssd
8 D" Z0 H$ @# r% _. t" [ size: 3221225472
! ~' ] q! y' |) b+ b, E status: deleted f, ?2 ]% T2 e+ Z4 _
created_at: 2022-04-08 12:48:277 n8 V4 i1 T. B4 w3 K) _+ L
updated_at: 2022-04-15 01:04:25% b, Z0 d) L1 s& F5 Q3 s1 _* M
deleted_at: 2022-04-15 01:04:255 k- X! v5 n9 ^( s
deleted: 15 b* \+ y$ t/ o
disk_format: raw
7 Z) A1 d# f, Vcontainer_format: bare& [. P R# V; {6 `
checksum: 6067ba67d340d6849fb08ad2dc1dc7524 @7 o9 K: \7 b' W
owner: 6f0124196ea74eb79fbcf370add3ca7e
1 e0 C, k X9 v# Q0 w min_disk: 0; [# x, K5 l1 j/ K/ I
min_ram: 0
4 \* V- t5 W& K4 r protected: 0) |/ U: x9 m9 a, h% E1 S0 ~9 u
virtual_size: NULL0 l/ r3 s6 p6 W+ X" @; F
visibility: public; [" o' J9 ~* L! j2 h2 J
*************************** 2. row ***************************
2 `9 D$ R6 V! R5 x# F2 q id: 18804abd-9cba-4a94-8ceb-ba9b12f9fc47
- b: w3 ?7 p u0 N/ L, a6 p0 i name: RHEL-Server-7.9-hdd-2.4T' j- ]& I4 h& N/ }3 ]
size: 3006477312
. ^3 a" f9 T8 m) n$ o status: active
) D0 N4 O. A5 ?* [! [ created_at: 2022-04-12 02:44:15) d7 V+ l. Y2 {5 X9 Z! Q
updated_at: 2022-04-15 01:04:393 x( u. c0 Q0 W- u6 J
deleted_at: NULL
" m7 m( M5 d1 {3 o5 Q deleted: 0; R0 H. Z% K* @% N0 r; ~& I
disk_format: raw
9 G; S3 J& ~- c. hcontainer_format: bare
( @! T- \ I& _ checksum: 3ddbd59c32a4ec8141018ee9a433c78e2 h6 m) c; d# X% H" ?0 Y% q
owner: 6f0124196ea74eb79fbcf370add3ca7e
$ p, J5 J: G/ e% R min_disk: 02 B. n+ L$ t! T) t
min_ram: 0, O$ i& G+ F( L7 Y& Y
protected: 05 D- m, e) S0 e
virtual_size: NULL* m7 U9 z, Y; s' l4 O
visibility: private) O/ x7 H# K" [, L( W1 J, F6 w
*************************** 3. row ***************************
: a8 d/ C3 U& S4 J8 s8 C id: b9c335c4-34a8-498c-a735-82567f7ef186& \3 M' t4 l/ V
name: rhel-server-7.9-ssd
: h7 Y2 z7 K4 F6 O size: 26843545609 N N" Z. [* U) c |, G
status: deleted( P: ?8 L# x* t0 H
created_at: 2022-04-11 07:22:43, c( q) B/ i( p! ?7 I, \
updated_at: 2022-04-11 08:02:40* c: n- i# A" w
deleted_at: 2022-04-11 08:02:406 g% U0 i5 G, @! C4 h
deleted: 1
! O* R! S/ J8 A0 e9 V disk_format: raw# ~8 p$ |) l9 t( b; ~
container_format: bare
. q8 f( M& a$ P. M checksum: 67e20fa3da128b17c3ec01d03e1e293d
) @2 p; U0 g6 Y- }% U3 b owner: 6f0124196ea74eb79fbcf370add3ca7e- [ l; u8 t* v+ D- e, `% }& |
min_disk: 0
: f- S0 ^& f9 D; m( _1 I$ p! B min_ram: 0# C5 ~6 N$ R, I" N, S( F- w
protected: 0
9 C. Y R/ n- y( [2 S virtual_size: NULL) T8 [5 b5 b/ p$ C1 g( t7 S
visibility: public& [0 M( W, E5 l- J3 l8 N
*************************** 4. row ***************************/ h1 Y2 L2 j5 z. ?0 j
id: ea333f95-79c3-4ce4-856b-a397cc963d77
$ H9 j( E: x; [& H* R7 | name: windows_2019_x64-hdd-2.4T$ _: L h6 g: G; T' ?
size: 12884901888
, L @' I! {4 \& D0 B& } status: active9 X: I* N# I1 \, f
created_at: 2022-04-13 01:25:56
- {( B4 d. z& a6 V( v7 _ updated_at: 2022-04-14 03:42:54
6 q1 P' \( A* F R) J deleted_at: NULL
) z7 d" z* q. ^' f: ?6 O1 B( x: m deleted: 09 O/ M0 ~$ N& A* z' j) b% ^9 \
disk_format: raw
0 w+ h8 g2 A1 U1 u% o& Ycontainer_format: bare; l. |" u8 W" h) |
checksum: 2eabbd70218411fdb021c4cdb790b82f' e( T8 d6 k( q7 N
owner: 6f0124196ea74eb79fbcf370add3ca7e+ w, D+ i# v0 e1 W. J$ }+ |
min_disk: 0
Z7 ? p: g/ @# E* }: F5 w/ ? min_ram: 0
% ]: K, N7 y, w* V protected: 0
+ U# d2 y- o3 o1 x* q2 h) W virtual_size: NULL4 l! w( x* ]! D
visibility: public. R- H, ?: V) r+ c) B3 f$ F3 O
*************************** 5. row ***************************
- ^: G2 {4 d/ t2 s id: fb5fe7ed-ba56-4ae2-a483-af3cc0cce891+ e2 z3 }, H. u6 v- ]; ?" `
name: RHEL-Server-7.9-ssd
: J$ R: C- U) A# w* S! O size: 3006477312
; x# I: T& B5 h* I; }8 n, b3 A status: active- K7 v. c2 H/ Y3 J7 X
created_at: 2022-04-12 02:16:14
* F* ?4 ?* P: z$ R0 J6 ?# e! X updated_at: 2022-04-15 01:04:46$ `. J9 p1 j" v* ^6 c8 T7 i1 y" b
deleted_at: NULL a1 p- x- _9 K- r
deleted: 0
! q" K7 S& t1 J1 i2 I- c disk_format: raw$ ~* ], z5 S" X* j _# d5 M& w/ [
container_format: bare3 l8 o( s: ~; }& @. R
checksum: 3ddbd59c32a4ec8141018ee9a433c78e6 n3 N6 Y4 U7 w+ S# l9 n
owner: 6f0124196ea74eb79fbcf370add3ca7e
* M: D% f9 `( Z! u& R M0 | min_disk: 0
% }6 y) p$ h$ i. Z& z8 O8 t- O min_ram: 02 m) P/ D7 a: W$ U
protected: 0
2 o: q7 {: S0 a D1 }$ W0 d* g" b virtual_size: NULL) J$ g) C" S( C0 @+ H
visibility: private
" z* {8 Y0 Z9 ^, J5 rows in set (0.00 sec)
% a9 @1 p5 T8 I# K. G1 M& e6 K$ G6 P Q
MariaDB [glance]> update glance.images set deleted='1' where id="fb5fe7ed-ba56-4ae2-a483-af3cc0cce891";' G: @+ G6 X+ Z- y; E
Query OK, 1 row affected (0.01 sec)
1 I% K$ W/ s# J) Q- W+ P6 IRows matched: 1 Changed: 1 Warnings: 0
0 ?9 `' ^0 \1 nMariaDB [glance]> select * from images\G
9 C& E! M! O; Z% n$ o*************************** 1. row **************************** K6 a5 D+ t0 `3 `
id: 0470245c-ee24-488f-89c9-622fd85e9ade
' S' y3 k0 ~* ]) Y+ ]& m name: centOS7.9-x86-ssd/ Z; {0 k2 i- S0 w9 @5 Z
size: 3221225472
. t4 w' a" `& ?" K status: deleted
* `& u" Y& N' N/ j9 F4 |* H created_at: 2022-04-08 12:48:27, t2 s `& m3 z$ ]/ m/ {+ E
updated_at: 2022-04-15 01:04:258 C1 I. O5 f* R2 h9 o
deleted_at: 2022-04-15 01:04:25
% e( i; U+ S: L0 [# [: u deleted: 1/ X( k& ?1 L( }
disk_format: raw
& A7 H9 b: Q# T! l9 l0 Lcontainer_format: bare
& g/ t" X. U- v% G2 _1 g r checksum: 6067ba67d340d6849fb08ad2dc1dc752. J U7 a. Z' U
owner: 6f0124196ea74eb79fbcf370add3ca7e* d* k2 B0 w( K7 ]* R" a
min_disk: 0
2 K' i0 g7 \, z min_ram: 04 B5 _$ l5 R0 p: C& y. n( Q
protected: 0$ x; p9 l% _- o: G; F: T
virtual_size: NULL
6 Z3 X+ b& A$ M5 n+ @" U9 R visibility: public
4 D8 o7 G8 t. r( ~; `. z; n*************************** 2. row ***************************% ?" A9 }# r/ B3 b- Y8 ^
id: 18804abd-9cba-4a94-8ceb-ba9b12f9fc478 T' B) t7 X. E# |7 @
name: RHEL-Server-7.9-hdd-2.4T* i1 J% Z! H3 C) W3 m
size: 3006477312
3 j8 h3 l. W' w status: active
5 q, g9 z2 w" K$ ?& V$ W9 z% b( G created_at: 2022-04-12 02:44:15
: x7 N* H3 |7 w0 k updated_at: 2022-04-15 01:04:397 }& x. H) ?1 g7 r" F% }& l
deleted_at: NULL
+ Y3 J1 G. k& ]- Y( h deleted: 0% Y/ F8 ~3 {& X. z0 e
disk_format: raw
8 f# h* K7 b N; I& Hcontainer_format: bare
. ?2 O( W; [6 `( v$ \ checksum: 3ddbd59c32a4ec8141018ee9a433c78e- o3 M' J* S- v N& y, v& R4 k6 |7 E
owner: 6f0124196ea74eb79fbcf370add3ca7e. C( L% q5 C3 D4 Q' J* o- B, |
min_disk: 0
. h7 L8 v$ d t! R3 S0 Y min_ram: 0
$ ]& ]3 a8 e) d6 d protected: 03 _6 @* {- Z* |3 Z I
virtual_size: NULL
( z# h6 Z N1 ~ visibility: private* x/ o7 w% n8 }
*************************** 3. row ***************************) p7 }: _9 ?" u: ~& w$ s+ \; l
id: b9c335c4-34a8-498c-a735-82567f7ef186
; v' o, F) ~) \' i1 v name: rhel-server-7.9-ssd
E8 W+ D- t6 R. v! B* H0 ^" |* w) v' P7 } size: 2684354560
2 u; `- M& r( H' @! y- z status: deleted6 I+ k' R* |4 m) k' }
created_at: 2022-04-11 07:22:43
6 E2 B, c3 C o+ {* M updated_at: 2022-04-11 08:02:40
; Z' z3 c. M9 l) \* n: d$ x deleted_at: 2022-04-11 08:02:40
, j, |4 V& C- V( \/ r j+ G$ ~* i$ F: Q deleted: 1
' m9 Y& G3 H; a" B( S; h/ o" T disk_format: raw
+ B9 j5 h3 X/ l: n2 h6 scontainer_format: bare
) M% i9 u0 i. } checksum: 67e20fa3da128b17c3ec01d03e1e293d
Z% _ q$ P, e9 ^- [6 J2 B owner: 6f0124196ea74eb79fbcf370add3ca7e1 N4 X5 L; N: s9 h2 p1 }
min_disk: 03 X0 R! ^( B( m- ]; ~
min_ram: 0
' a7 x9 b- T- i protected: 06 K3 t! X" y0 O- k) o- d
virtual_size: NULL; Z7 \% w) y5 A- H
visibility: public
$ p5 }* G; [- Q0 N*************************** 4. row ***************************
, I9 s# Q/ @. ]* t0 F4 n: q v id: ea333f95-79c3-4ce4-856b-a397cc963d77
6 c& g" D1 A R/ e9 |' [! \4 N8 O name: windows_2019_x64-hdd-2.4T* Q( X% W' v/ y9 p
size: 12884901888! h* n0 c5 d( X
status: active
* {! n1 D. B: j/ ] created_at: 2022-04-13 01:25:56. U( V' p/ o& Q
updated_at: 2022-04-14 03:42:54
# ~/ g/ z/ @" h& A! j" i( L deleted_at: NULL
/ W! g7 Q: M" a8 b, H deleted: 0" Q. v, p- p- O" K/ z
disk_format: raw
; q' X: |7 T9 P0 r* n2 Zcontainer_format: bare/ B% a& s( N7 L6 ~" j; E
checksum: 2eabbd70218411fdb021c4cdb790b82f) s4 T, ?+ V% T+ c& ]( j" f* {( a- {! F1 X
owner: 6f0124196ea74eb79fbcf370add3ca7e
3 U, r( x3 H7 K2 }7 i5 w8 e# G8 X min_disk: 0/ q" m5 {1 D$ A2 L3 w2 j5 m
min_ram: 0- j. j+ k ~% [
protected: 0
: t' g' v' T' W7 H* |, K; y. _3 B virtual_size: NULL3 L% B% @4 p& d& S0 ], c* ^2 ]
visibility: public
9 O; r0 y1 P. j: H*************************** 5. row ***************************
# V+ L$ c, v, P id: fb5fe7ed-ba56-4ae2-a483-af3cc0cce891
/ M8 ]1 v4 c5 H: G* i name: RHEL-Server-7.9-ssd. |4 i; F% d4 L* o
size: 3006477312
) r# f) a. }9 b Q( W% O status: active
- G; B+ A6 ~5 i* u created_at: 2022-04-12 02:16:14* z9 l1 V @) s$ v5 A. s7 Q
updated_at: 2022-04-15 01:04:46
2 y' ?0 ^/ p2 y/ C* n7 G% C4 j+ V) P; N deleted_at: NULL# g5 p) y( ? c7 W6 T! e* ~( |1 M$ D
deleted: 18 A- n7 Z \, |* b4 f$ ^, Z ?
disk_format: raw) j8 p N% V; q" N& L0 E" m0 W
container_format: bare
, m6 E8 Z! h' X8 n8 s checksum: 3ddbd59c32a4ec8141018ee9a433c78e
* v8 j9 u' U/ r* ]1 @: I owner: 6f0124196ea74eb79fbcf370add3ca7e5 d$ t/ E/ o! K# A+ \$ e& K& c
min_disk: 04 h0 h5 d2 X* `* |0 H7 m
min_ram: 0
7 \: G i" w F protected: 0- D) S8 T% ?# L8 r) k2 ^& Q
virtual_size: NULL9 C! h. A- p2 f
visibility: private
3 Q1 X S% @, w! i q+ m* E. b5 rows in set (0.00 sec), ]$ A& ?. r* g( E- s" c
MariaDB [glance]> select id,name,deleted,status from images;
$ o8 o# }+ D# z6 S* A8 S2 u0 u+--------------------------------------+---------------------------+---------+---------+ d4 F2 @; z# x3 n
| id | name | deleted | status |
S, l7 l( I) a+--------------------------------------+---------------------------+---------+---------+0 p$ T0 P7 m" i* r4 q3 R4 V
| 0470245c-ee24-488f-89c9-622fd85e9ade | centOS7.9-x86-ssd | 1 | deleted |
, h7 P- ?2 \. w| 18804abd-9cba-4a94-8ceb-ba9b12f9fc47 | RHEL-Server-7.9-hdd-2.4T | 0 | active |
3 F2 w: [. G2 v' S* g| b9c335c4-34a8-498c-a735-82567f7ef186 | rhel-server-7.9-ssd | 1 | deleted |
' A. ]) e: J+ r* G7 z| ea333f95-79c3-4ce4-856b-a397cc963d77 | windows_2019_x64-hdd-2.4T | 0 | active |/ j' g# I1 f$ o, J5 r& @; Z: b
| fb5fe7ed-ba56-4ae2-a483-af3cc0cce891 | RHEL-Server-7.9-ssd | 1 | active |6 x4 e+ L# g5 y% v3 ~
+--------------------------------------+---------------------------+---------+---------+
/ v* Y. H' [3 M5 rows in set (0.00 sec)
+ _( q7 q- ]6 SMariaDB [glance]> update glance.images set deleted='1' where id="18804abd-9cba-4a94-8ceb-ba9b12f9fc47";1 [% t" p, Z$ a$ Z( x4 u
Query OK, 1 row affected (0.00 sec)
2 W, s$ ?% c/ n0 b: N9 w* _1 x3 jRows matched: 1 Changed: 1 Warnings: 0$ p' _9 i: I9 b2 v
MariaDB [glance]> select id,name,deleted,status from images;9 H: H( S( `9 K5 T. N0 \
+--------------------------------------+---------------------------+---------+---------+
}) v) L, b4 o/ a, b7 z# W| id | name | deleted | status |
& k D9 c! r* I$ T7 U: \( V* n+--------------------------------------+---------------------------+---------+---------+6 O7 R" r& P" K2 ?8 W2 X
| 0470245c-ee24-488f-89c9-622fd85e9ade | centOS7.9-x86-ssd | 1 | deleted |
; ^& k4 j+ J$ n0 C7 q- N0 h| 18804abd-9cba-4a94-8ceb-ba9b12f9fc47 | RHEL-Server-7.9-hdd-2.4T | 1 | active |
- f. H/ K" a. E) C4 w9 v! k4 ^| b9c335c4-34a8-498c-a735-82567f7ef186 | rhel-server-7.9-ssd | 1 | deleted |
+ ] h3 Y7 X( [$ Y| ea333f95-79c3-4ce4-856b-a397cc963d77 | windows_2019_x64-hdd-2.4T | 0 | active |
% A4 e* r+ }6 r. M0 s ^ F| fb5fe7ed-ba56-4ae2-a483-af3cc0cce891 | RHEL-Server-7.9-ssd | 1 | active |
4 ]% @; y o9 \' u/ n0 M+--------------------------------------+---------------------------+---------+---------+
! Z9 E( K1 p; Y, D5 rows in set (0.01 sec)
7 X3 J& _. h9 D! H' \% ^0 I1 q4 B! J. }. Q# G3 b
0 W( n4 w+ |! z/ F6 p# J完成更新数据。切记不要delete数据，因为这些数据库表之间有关联，会导致数据库凌乱。解决办法一般都是update状态。切记切记。3 f! d; V! g5 m
|
|
发表于 2022-4-15 09:26:14