|
|
mariadb删除glance数据库中镜像文件，使用update set 修改运行状态一次操作记录：: S: c0 P. W0 ]9 H$ O$ J
MariaDB [glance]> select * from images\G
" {3 J' H* u1 S$ f; ]; N: ]*************************** 1. row ***************************
; G' i. c2 k. s, c id: 0470245c-ee24-488f-89c9-622fd85e9ade
( x: q( E& I8 N! @0 k7 n name: centOS7.9-x86-ssd0 k2 N# `4 V& m0 A% Q1 ^
size: 3221225472
2 V$ J) u I+ h) H status: deleted$ }& F. H/ l- \9 F
created_at: 2022-04-08 12:48:27
( V- |, j0 Z1 K/ w9 n: i3 E; b: y updated_at: 2022-04-15 01:04:25% k9 t/ L; T) ~" \* r
deleted_at: 2022-04-15 01:04:25
% V: F( X. I: y- x7 |* A! p deleted: 16 {' N8 O$ o* ~# S8 M+ Q+ q
disk_format: raw
5 a' Q! u: f5 }( X( Econtainer_format: bare! S6 ?1 t! u/ I9 C+ X
checksum: 6067ba67d340d6849fb08ad2dc1dc752
9 [4 A+ a; e1 b3 K9 j owner: 6f0124196ea74eb79fbcf370add3ca7e
0 X8 {& i: |) X4 @+ ^$ U( n* e( @1 M min_disk: 0& t" m: k5 d4 Y: m+ N
min_ram: 0
7 U: q9 v `, Q8 ?: C) t7 M protected: 0
7 Z% W F8 l( L virtual_size: NULL: j) B1 I; B5 O( O
visibility: public; b/ {2 t9 r5 c
*************************** 2. row ***************************
1 w$ T% K4 a! d2 v" b4 j7 s id: 18804abd-9cba-4a94-8ceb-ba9b12f9fc471 d& l* [4 I C/ F0 z
name: RHEL-Server-7.9-hdd-2.4T4 P& g$ w4 T- ^
size: 3006477312
- W- ^+ E+ z O status: active1 @$ ]5 a- G* u8 k* @) a2 r
created_at: 2022-04-12 02:44:15* o* K) H- }- K3 t. W" X5 ^1 X
updated_at: 2022-04-15 01:04:39
7 F' i7 W7 B$ p: w4 `0 G* ^1 F deleted_at: NULL+ o. s8 k0 _$ i5 X7 P5 z: ~# Y
deleted: 0
1 ]8 I5 j/ P+ x- i2 X disk_format: raw2 M% F/ K5 @# a$ a5 }
container_format: bare% [' L$ ^/ u6 L7 y
checksum: 3ddbd59c32a4ec8141018ee9a433c78e
) w, f- {* E; ]$ F" T( E& Z) e' E owner: 6f0124196ea74eb79fbcf370add3ca7e% |' g+ s9 |4 h: Y7 e8 G" d. j' ~
min_disk: 0
V0 [& N$ H: I2 {+ l min_ram: 0
1 S$ L0 y& X" o# B' R9 B+ C3 [3 f0 R protected: 0( O9 O; @% \# p5 L
virtual_size: NULL U# M. x. d5 r# Z! R
visibility: private
+ N: r e# S* P4 o+ ~# x' T*************************** 3. row ***************************
! Z W4 E: h( A3 I1 n2 v id: b9c335c4-34a8-498c-a735-82567f7ef186! u4 Y1 S8 m! |
name: rhel-server-7.9-ssd
! D5 b2 h( y6 \& U4 q size: 2684354560
7 }* m, ^; L+ Q8 t9 ? status: deleted/ n; X& t9 [1 r- R1 n
created_at: 2022-04-11 07:22:43
" c' ?3 y1 i" ~& k0 U/ i, i updated_at: 2022-04-11 08:02:40
* n- e/ x0 Z5 P8 K# O8 w6 M- N$ E. Y deleted_at: 2022-04-11 08:02:40+ B( C7 v0 R7 s- a
deleted: 19 x0 `. n9 y9 q: I: u1 n3 i
disk_format: raw
& M' U' h8 K( Z5 s$ c0 Acontainer_format: bare
0 K% ~. W) r: [ s1 C2 Q checksum: 67e20fa3da128b17c3ec01d03e1e293d
( L' o; d7 y' E" o# y" b owner: 6f0124196ea74eb79fbcf370add3ca7e4 u) {+ d/ V7 x! Q
min_disk: 0
$ }+ Q8 }7 y: K3 r* B- ` min_ram: 0
# \, g- G6 j( `1 T+ K; P protected: 0/ V, q/ p5 l( _" ~4 w
virtual_size: NULL: @0 l0 ~; B5 y/ K
visibility: public
3 D1 P, [9 [# L$ j- \ x$ i*************************** 4. row ***************************
& s# t( i6 k* `- z! p id: ea333f95-79c3-4ce4-856b-a397cc963d77
: R" q. u+ F; y. j name: windows_2019_x64-hdd-2.4T" `; s9 }; U4 z$ ^
size: 12884901888
( y! Y% {% c4 k# S status: active' t5 ], e4 n8 k& o+ I! F% y
created_at: 2022-04-13 01:25:56
8 R0 r* e# z' ]& s updated_at: 2022-04-14 03:42:54
2 k: s, `$ ]7 ]2 @% s# _ deleted_at: NULL. y* L5 R3 J N' i6 V
deleted: 0
7 m5 \, e0 G5 ?8 {3 b disk_format: raw
3 S, M! n @8 ~4 [9 M2 ?, }! lcontainer_format: bare
5 R4 W7 O5 e& }: N. h checksum: 2eabbd70218411fdb021c4cdb790b82f: j! _: j8 S% _3 O
owner: 6f0124196ea74eb79fbcf370add3ca7e
: H+ k" m0 H5 R0 @9 Y min_disk: 0
0 x& |; P, w/ s min_ram: 08 h# Q0 R# o% M1 m
protected: 03 O! P: U U* C3 q3 X
virtual_size: NULL S/ E: x5 A8 Y `
visibility: public! A, ?4 ?! H/ R( f
*************************** 5. row **************************** W; o' u7 ]5 `4 c0 o
id: fb5fe7ed-ba56-4ae2-a483-af3cc0cce891
& H' t: z# c. C; e- g1 l name: RHEL-Server-7.9-ssd
! q9 k, _4 L) O* y$ s( t4 g+ J size: 30064773123 t4 \/ T _7 S, [0 X6 Z
status: active1 @2 @- c3 t v5 l# b
created_at: 2022-04-12 02:16:144 E& h1 v0 z' U9 u3 {5 H% Z" T7 e
updated_at: 2022-04-15 01:04:46
4 D8 X( A( z& r deleted_at: NULL
+ |( @" ^0 k) W8 @, V deleted: 0: V4 B/ s1 ?( Y# `
disk_format: raw
+ a9 ] w) o( g8 E! m. econtainer_format: bare( f: |$ ?$ I. X% h6 D
checksum: 3ddbd59c32a4ec8141018ee9a433c78e
$ b. P* p$ R7 r% P owner: 6f0124196ea74eb79fbcf370add3ca7e
" G$ S" i5 F! d5 M' c min_disk: 05 q# J$ w8 o9 j1 V; z3 P. O" ^+ \
min_ram: 0
0 n/ w0 l0 y' ` protected: 0% R9 x8 \; S3 L4 p% E. a- w! t0 ]3 V
virtual_size: NULL1 i x+ h; O( p
visibility: private6 k! u( a( f0 ?# s! C8 k
5 rows in set (0.00 sec)1 r/ R4 u: C& I" `
& ^# o, o! O# X r
MariaDB [glance]> update glance.images set deleted='1' where id="fb5fe7ed-ba56-4ae2-a483-af3cc0cce891";: t6 M0 M# v3 ?- c
Query OK, 1 row affected (0.01 sec)- [' Y+ K* L2 q) D
Rows matched: 1 Changed: 1 Warnings: 0
) x9 U5 A5 _( k8 UMariaDB [glance]> select * from images\G
0 r9 W6 [0 g! J! h*************************** 1. row ***************************) O0 S* y: w+ E" {
id: 0470245c-ee24-488f-89c9-622fd85e9ade$ v7 ?" M5 G$ I7 Q* G. m M
name: centOS7.9-x86-ssd7 q+ C0 k0 ]5 _4 E4 c( P
size: 3221225472
* ]2 g0 H& r s5 @' d7 F6 v status: deleted
# y% r5 _# v$ K+ z7 t" G4 a% ?( U) n created_at: 2022-04-08 12:48:27" }+ {3 z4 _" U+ U; l
updated_at: 2022-04-15 01:04:255 i. v, x5 W- z( i9 `
deleted_at: 2022-04-15 01:04:25" o% r: k _. R: i
deleted: 1" m+ i! M5 R3 m$ G t J/ ^
disk_format: raw
* w# p+ {) {6 A3 G; E! \/ u+ [; b" ccontainer_format: bare5 c; E" p* ^. L4 j0 {
checksum: 6067ba67d340d6849fb08ad2dc1dc752
0 a$ X S+ @4 K owner: 6f0124196ea74eb79fbcf370add3ca7e
4 O4 Z2 g% Q# `; f* q" q! S4 Q, q min_disk: 0" `- P6 {+ B1 k: t; `" T( m
min_ram: 0
7 y9 R; m! d- o/ F. Y protected: 01 k" n5 I. Y9 E
virtual_size: NULL
; w" Q. b+ @0 A# F8 h6 q visibility: public
* Z# N" T e! q" P+ ^, p*************************** 2. row ***************************9 o) u. S* y& r. C
id: 18804abd-9cba-4a94-8ceb-ba9b12f9fc47
( D: _# ^/ F/ s* u0 s' w' J) Y$ r6 G name: RHEL-Server-7.9-hdd-2.4T
7 A a! K9 }2 K" p size: 3006477312# X' ^* K6 E; f- O5 a- M
status: active
( k" g+ R/ W0 d3 d8 K# T created_at: 2022-04-12 02:44:15: W `5 `, e; s$ V* H" V
updated_at: 2022-04-15 01:04:39
) t# H* m% h" `! o+ Z; _" P; s& M deleted_at: NULL! d/ A( J! X- {
deleted: 0
% O, l% K3 ]; g d7 q E disk_format: raw/ l9 c+ U. O+ V4 @
container_format: bare
# O/ p/ q ]; c+ T: V7 x$ R checksum: 3ddbd59c32a4ec8141018ee9a433c78e
2 U! J" \ i: M, ~1 ` owner: 6f0124196ea74eb79fbcf370add3ca7e. v' z# H+ Q" S, ?
min_disk: 0
7 u# S6 |- K i; M' j; \7 u min_ram: 0
/ Q; D8 h4 L$ N' N0 F; i protected: 0
3 o# i0 N; j& @7 F; B0 G% N3 H virtual_size: NULL
$ ]3 E6 {5 c, C. O! G: ^ j visibility: private
6 y# L/ ^& a. \& N" _; u4 j+ r*************************** 3. row ***************************
: F# D) e8 e' G' g$ S id: b9c335c4-34a8-498c-a735-82567f7ef186# Z0 _. A! D$ ~+ c4 |# ]; F
name: rhel-server-7.9-ssd
' _9 @ I8 j* Z4 _2 N- \ size: 2684354560
6 ^! `* L+ M0 m status: deleted* H$ Y, R. T I: F4 u. p1 m+ f0 h$ L x) g& O
created_at: 2022-04-11 07:22:43
3 ?1 T v- B; K# ?$ X updated_at: 2022-04-11 08:02:40
/ ~# p; R! ]1 Q, ~9 G7 |3 u deleted_at: 2022-04-11 08:02:40
1 W9 M: B& v8 ?% U0 |; _6 Y" C deleted: 1# w" _; g4 U4 H& S
disk_format: raw
4 [( d- ~- u* N Z8 S6 r7 Lcontainer_format: bare
1 L) t: G5 p$ t2 m checksum: 67e20fa3da128b17c3ec01d03e1e293d' j. w8 J- A$ l1 f8 K. j
owner: 6f0124196ea74eb79fbcf370add3ca7e$ z5 [4 L# g7 d" k: S1 ]" F
min_disk: 0
; u8 [; @' v- v) N min_ram: 0) Y: s- [7 ] F
protected: 0
, s2 M0 L8 I! z% @' s+ y- s) u k virtual_size: NULL; [% I: o* M3 ]) ^! g& p
visibility: public4 p+ _1 T6 P$ w( B A" p. N
*************************** 4. row ***************************
( C5 ~4 {' z2 j5 B- \7 p/ ~ id: ea333f95-79c3-4ce4-856b-a397cc963d77
! h: _) v( D, q" R name: windows_2019_x64-hdd-2.4T
, d: Y( F% ~1 G8 c; L; R size: 12884901888
7 U2 ]0 f# d) u2 b: Z status: active
/ a- q2 _, R, k created_at: 2022-04-13 01:25:569 F9 L i4 `3 S
updated_at: 2022-04-14 03:42:54
7 P; [ F* @6 h3 @1 z; e deleted_at: NULL! K2 |0 Y: c7 x5 l7 R9 r
deleted: 0& \! J0 U7 z" H; v# Q" t
disk_format: raw
5 z/ @6 n% \4 q7 X3 U! d8 @container_format: bare
. m d8 U0 P$ s: |+ G+ J s( { checksum: 2eabbd70218411fdb021c4cdb790b82f' u: x$ O0 W7 M- P, `! ]
owner: 6f0124196ea74eb79fbcf370add3ca7e
/ H E) C7 [; B2 M min_disk: 0, e0 u% B' l/ ]
min_ram: 0
# v, D+ ?. ?0 d! L9 o! m protected: 0) `/ O. |2 A, y* b1 G) j) J' c& Z7 u
virtual_size: NULL% c; F7 @0 C) _5 U4 N
visibility: public1 G' p. g c, f% V) u0 ?
*************************** 5. row ***************************
/ i" i' z8 z: n* T4 O2 m5 u id: fb5fe7ed-ba56-4ae2-a483-af3cc0cce891
6 @6 I9 t. K) w0 @ name: RHEL-Server-7.9-ssd0 v) t$ \( Q8 i
size: 3006477312
# n$ ^' K$ q# v$ W2 X status: active, d1 g9 }4 d/ @" b/ w* x1 n
created_at: 2022-04-12 02:16:14
6 ?! [5 u! W c$ j1 I- J3 U3 e updated_at: 2022-04-15 01:04:46
% r% n( h8 J1 Q- a9 a0 x deleted_at: NULL
: h3 A# W9 r: y; i4 x3 s deleted: 14 U$ @ k1 b- l& D
disk_format: raw
" ~: b/ P' @+ ycontainer_format: bare
: N$ i' s$ b% g2 B' v checksum: 3ddbd59c32a4ec8141018ee9a433c78e5 ]7 Q0 }3 g7 Z
owner: 6f0124196ea74eb79fbcf370add3ca7e7 a, K# n" \0 z3 o
min_disk: 0
% G: d. i% k" C/ j- A min_ram: 0
( `/ q6 H9 h# u2 p- _0 k2 J) R9 v protected: 0
5 P! Z" y# m) i8 d H7 t ~ virtual_size: NULL& P, w/ u7 `. q/ D L* K7 y Y3 E
visibility: private
) G1 O0 D7 ^, p' S5 rows in set (0.00 sec)
. v" m: N2 G3 K) iMariaDB [glance]> select id,name,deleted,status from images;
! g# w! ~$ |( j, d1 L- V$ [2 N, R0 D+--------------------------------------+---------------------------+---------+---------+
' n) H% k6 C% Z& x4 _| id | name | deleted | status |
/ t9 g* v J Q$ m* g! ?* w, n+--------------------------------------+---------------------------+---------+---------+6 a$ Y7 f( u6 K. z# n4 e- e
| 0470245c-ee24-488f-89c9-622fd85e9ade | centOS7.9-x86-ssd | 1 | deleted |+ Z. x6 o& s$ ~% J; ~# |0 ?
| 18804abd-9cba-4a94-8ceb-ba9b12f9fc47 | RHEL-Server-7.9-hdd-2.4T | 0 | active |! _$ w, N3 c1 J/ R; k. R0 W
| b9c335c4-34a8-498c-a735-82567f7ef186 | rhel-server-7.9-ssd | 1 | deleted |
. j) L" d) O* a' ?| ea333f95-79c3-4ce4-856b-a397cc963d77 | windows_2019_x64-hdd-2.4T | 0 | active |& X$ W$ ^% E5 Y" U, Z
| fb5fe7ed-ba56-4ae2-a483-af3cc0cce891 | RHEL-Server-7.9-ssd | 1 | active |) C; Z9 I3 g8 r* a8 q
+--------------------------------------+---------------------------+---------+---------+
7 v2 d; B+ P q. g5 rows in set (0.00 sec)5 J# C& @+ B6 P' \8 x
MariaDB [glance]> update glance.images set deleted='1' where id="18804abd-9cba-4a94-8ceb-ba9b12f9fc47";$ B! Z- F9 Z* l! h& A
Query OK, 1 row affected (0.00 sec)
4 u6 q+ }! c- `: m! |Rows matched: 1 Changed: 1 Warnings: 0- [# Q" O3 [- G! W- P( ]
MariaDB [glance]> select id,name,deleted,status from images;
3 i1 v8 m5 R! E& ^- a( Q! v+--------------------------------------+---------------------------+---------+---------+! u6 _9 q- n5 v |
| id | name | deleted | status |9 x* _4 @+ X1 t1 @
+--------------------------------------+---------------------------+---------+---------+9 F0 B* G* s7 Y2 ^* L: }4 R
| 0470245c-ee24-488f-89c9-622fd85e9ade | centOS7.9-x86-ssd | 1 | deleted |
+ R% ~0 h1 F) q1 w5 Y| 18804abd-9cba-4a94-8ceb-ba9b12f9fc47 | RHEL-Server-7.9-hdd-2.4T | 1 | active |
8 M: A$ u @6 t| b9c335c4-34a8-498c-a735-82567f7ef186 | rhel-server-7.9-ssd | 1 | deleted |
: o; Q$ f- ?) p+ }; ~3 ?| ea333f95-79c3-4ce4-856b-a397cc963d77 | windows_2019_x64-hdd-2.4T | 0 | active |
5 {7 ], h, S8 C0 p! b" P9 F| fb5fe7ed-ba56-4ae2-a483-af3cc0cce891 | RHEL-Server-7.9-ssd | 1 | active |/ ^# B# E2 n, X( A# Y
+--------------------------------------+---------------------------+---------+---------+
: D/ O; j: n' y0 D4 u5 rows in set (0.01 sec)
4 H! ^7 O- a' {9 e' ?; M' g+ h9 W" b# }% T1 ?. g. ~9 C
0 T* s" I6 D1 K1 Y完成更新数据。切记不要delete数据，因为这些数据库表之间有关联，会导致数据库凌乱。解决办法一般都是update状态。切记切记。
' O& s) S' z/ ^4 |+ a. q |
|
发表于 2022-4-15 09:26:14