- 积分
- 16840
在线时间 小时
最后登录1970-1-1
|
马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。
您需要 登录 才可以下载或查看，没有账号？开始注册
x
mariadb删除glance数据库中镜像文件，使用update set 修改运行状态一次操作记录：
8 U* A; u1 e* B# rMariaDB [glance]> select * from images\G, i) Q# ^* R7 ~
*************************** 1. row ***************************
+ W6 E% Y0 b! n2 z id: 0470245c-ee24-488f-89c9-622fd85e9ade
6 \% F5 K: e& \6 T' K1 z7 R name: centOS7.9-x86-ssd7 N. L; d! o, P# Q. \
size: 3221225472 b5 d& r6 W& Q8 [& O9 Y. E, ?2 y. @
status: deleted k$ E: k' s1 b! |, p( W6 D! Y
created_at: 2022-04-08 12:48:27# F1 N* ~! ]# D$ w. ]$ l
updated_at: 2022-04-15 01:04:25
+ A& F* |5 f5 t, U1 U deleted_at: 2022-04-15 01:04:25
) X* B, \" t( \. ]& B2 [ deleted: 1
% d: Z( p/ s1 A, \. M' h disk_format: raw7 B' P; z/ a; w5 R, {
container_format: bare1 x8 {4 b! x! ~3 o. ?* X
checksum: 6067ba67d340d6849fb08ad2dc1dc7520 w' @1 @% A8 t+ D2 i
owner: 6f0124196ea74eb79fbcf370add3ca7e
" e) I( a$ K `6 L min_disk: 0 a, h5 y2 q0 W; x% {* H [3 W
min_ram: 0. J. [2 h6 Y# q( N5 ^% e1 ?
protected: 0
% e/ z% N, r' D- N2 ^- M7 b h virtual_size: NULL
4 X- {) {3 |% U' T) O4 l9 O/ o& `% O visibility: public4 \% j7 Q4 }; ?+ R* X
*************************** 2. row ***************************8 T9 Z' e: A9 L8 ?' ]1 ]
id: 18804abd-9cba-4a94-8ceb-ba9b12f9fc47: g' }3 m$ x4 k( G$ `
name: RHEL-Server-7.9-hdd-2.4T
1 J0 p9 i4 I- ]6 x: \ size: 3006477312
/ S* S# _2 R, T) x$ {8 A status: active; C$ \+ n5 y. O3 t" H1 F1 p: N
created_at: 2022-04-12 02:44:15, W0 p$ v2 W+ l( c
updated_at: 2022-04-15 01:04:39
7 {9 e. P- p9 J- Z5 L5 _ deleted_at: NULL! z; x6 F; Y" O4 H/ _* D ~
deleted: 0
: t# T' \% ?1 x disk_format: raw, c! }: `% I# u8 x
container_format: bare6 c& x Z* B3 p4 h# w
checksum: 3ddbd59c32a4ec8141018ee9a433c78e
" [ t5 h8 g' N+ S' z, W2 K: f/ c0 ` owner: 6f0124196ea74eb79fbcf370add3ca7e# [, J1 @5 [7 ^. S: G
min_disk: 00 ^; C8 K d; M( s# m7 d
min_ram: 0
5 T+ c2 z$ k( J, y1 q- t% _0 R protected: 0
# }* K. ~- Y2 x2 U' o virtual_size: NULL
3 G* J- i) x5 K& {- |' B visibility: private
4 K3 ?( H( O. T. S5 ^*************************** 3. row ***************************9 j. k- {2 A% ~4 i( A5 v' F( f) Y. k. i
id: b9c335c4-34a8-498c-a735-82567f7ef1869 p8 O( y4 S) T8 i m3 p. z% \
name: rhel-server-7.9-ssd
8 I8 q; {' q9 H- w) }3 l size: 2684354560* ]7 I/ C$ L" O" t
status: deleted
/ _3 f, w+ ?4 A2 C created_at: 2022-04-11 07:22:43
/ d- P& R8 Z) B, d! j updated_at: 2022-04-11 08:02:40
H0 q4 y3 h, h- a7 y deleted_at: 2022-04-11 08:02:40" P4 K; e, x) `! X6 Q. N
deleted: 1* Z, K, I* e( u U" d( K/ U4 v: t
disk_format: raw
& N* H' C$ ^- l* o2 b: T B5 Qcontainer_format: bare
8 p+ I) \ V+ ?' u+ T checksum: 67e20fa3da128b17c3ec01d03e1e293d b9 C6 N2 u# J' d! \% `
owner: 6f0124196ea74eb79fbcf370add3ca7e
- W2 c. n5 _2 u min_disk: 03 f" E0 j# f- V- w) n+ ]! \8 F' x
min_ram: 0/ b# B p; @" E4 x. N& ]
protected: 0
7 V( X: i! X, A! z8 B virtual_size: NULL
6 J! s& @' |7 z9 F, y% l visibility: public
K! ?5 D- ~0 i& E" a- C/ M*************************** 4. row ***************************' f+ R8 Q9 Y. f3 r# d4 ~: N
id: ea333f95-79c3-4ce4-856b-a397cc963d77; {( \0 W% _2 N# d
name: windows_2019_x64-hdd-2.4T
1 [* j0 X, n) V" w size: 12884901888
4 s' O _) T8 }* ~8 y; ^ status: active
# }4 k& S! I% @; k9 i* Z" s created_at: 2022-04-13 01:25:561 B# _3 q: D% T
updated_at: 2022-04-14 03:42:54
$ n$ P$ O a3 A& C3 c. r deleted_at: NULL/ T5 h% o m, M" n
deleted: 0+ ^% g. C. w* d2 x
disk_format: raw; P6 [6 r4 k0 C) x7 Q! f4 l! K
container_format: bare2 u. `( c: s1 L9 u% P
checksum: 2eabbd70218411fdb021c4cdb790b82f2 V1 N+ _8 K5 }+ u# g
owner: 6f0124196ea74eb79fbcf370add3ca7e# ^; e' g5 ]8 ]4 H
min_disk: 0( Y! d9 l* B2 ]0 _: ^- |9 g
min_ram: 0! H: ~4 j; S4 k; v$ o
protected: 03 g" W7 c1 M( \; V6 X0 X" l
virtual_size: NULL- q* _6 f9 U% C) @( g' U
visibility: public
! s( Q( _- |, Z8 f2 @1 _! p/ _*************************** 5. row ***************************
1 f7 K4 h$ y2 z4 L8 \5 }$ H id: fb5fe7ed-ba56-4ae2-a483-af3cc0cce891 q) v& m/ j% H e
name: RHEL-Server-7.9-ssd
( H$ P, b2 F2 Q& V$ ~ size: 3006477312
" U: a9 x( l' y8 F status: active3 R8 A( B" D8 I( e; x7 K2 E) Q( T
created_at: 2022-04-12 02:16:14
4 s8 _& W! P6 z& v2 H updated_at: 2022-04-15 01:04:46
: `7 h$ W8 x/ a# {6 \) Q+ a deleted_at: NULL9 f+ ?% \- r5 s4 ]" G4 b( v
deleted: 0& v1 B2 O2 ?( ~; }( p- J6 E
disk_format: raw
- e" U! ~% b% \! t( z8 W8 \- Acontainer_format: bare9 F3 X; f1 |6 d! T' w5 ~4 U3 x
checksum: 3ddbd59c32a4ec8141018ee9a433c78e, d1 V; G7 z0 I
owner: 6f0124196ea74eb79fbcf370add3ca7e
! Q) `0 ]- q6 ^6 D- X0 x min_disk: 0* P0 J$ {1 n) Z: Y" K4 J+ ~
min_ram: 0
1 l4 X E0 z( }( U protected: 0) L' |: k8 d4 ~* u+ d [( u
virtual_size: NULL
* `/ H$ K5 P) A. }9 R2 d visibility: private
7 T( ]1 |# p( Z# @' T5 rows in set (0.00 sec)
8 d4 j: r- A0 s, N4 ~
. j6 g1 u4 {9 m$ iMariaDB [glance]> update glance.images set deleted='1' where id="fb5fe7ed-ba56-4ae2-a483-af3cc0cce891";/ I) p4 Y; ~. n2 u
Query OK, 1 row affected (0.01 sec)1 y/ ]# _0 B% F3 p3 A: V4 m
Rows matched: 1 Changed: 1 Warnings: 0- K, H0 U! B. w4 s% A( i* @* N
MariaDB [glance]> select * from images\G
( t5 I( K$ l& _1 d# k# r1 ?# K*************************** 1. row ***************************7 ^( j1 O2 j) w( k1 I1 C
id: 0470245c-ee24-488f-89c9-622fd85e9ade
7 W" f2 `# M' N6 A3 u4 ? name: centOS7.9-x86-ssd6 g- ^$ r- p; ~! s" B U
size: 3221225472
* n2 c5 e, g: D5 T. w status: deleted7 B% _ p0 ?( U2 ^
created_at: 2022-04-08 12:48:27' }3 }' y" X. k4 i+ W5 o Z( t
updated_at: 2022-04-15 01:04:25
6 t4 j% D# Z' z1 q% \ deleted_at: 2022-04-15 01:04:25
( V* @; Q# v* F4 p deleted: 1
' b* M9 \4 s/ D disk_format: raw
( N8 O9 E0 O8 q6 `$ |* pcontainer_format: bare% i( a H& m6 {
checksum: 6067ba67d340d6849fb08ad2dc1dc752
3 `# E$ N% m0 k owner: 6f0124196ea74eb79fbcf370add3ca7e
4 b* y" j8 P% D% H; A8 g min_disk: 0
1 O& {, L1 K! @$ j- _. I, K min_ram: 0
* A, A/ p; Y0 [8 t- o8 w protected: 0
& J# a1 z9 d) F% u, R virtual_size: NULL, N- I# q7 w$ |3 s( t6 N
visibility: public
% G6 Q% h; h5 N0 ?*************************** 2. row ***************************
4 Y; d: K- }5 s# J' [/ b id: 18804abd-9cba-4a94-8ceb-ba9b12f9fc47) @, g+ z! j& [0 D+ g
name: RHEL-Server-7.9-hdd-2.4T! ~1 [4 U9 c, }+ S
size: 3006477312
; Y, v$ h/ W) i. q& m# P) ? status: active1 Z2 V. ~" g7 Y( S) o0 I
created_at: 2022-04-12 02:44:15" o. y# |) u6 M5 f) `# S
updated_at: 2022-04-15 01:04:39. C. V( T+ L. i& k6 a1 \- ?
deleted_at: NULL. X7 J- Q5 A9 c( {- o# p2 b4 E- P
deleted: 0# o5 H5 G) ?& ^1 R
disk_format: raw
- \% m+ w2 G J* m, M. S; A5 wcontainer_format: bare
9 G/ x, R9 f6 \6 t. w# i checksum: 3ddbd59c32a4ec8141018ee9a433c78e, e; ~9 o' P, h8 j0 B2 S& u+ d
owner: 6f0124196ea74eb79fbcf370add3ca7e
& \7 Q/ y+ M8 ] min_disk: 0$ H1 R; M) N9 q9 v$ k* g
min_ram: 0
. M8 ~4 ~ V, p/ Q; V" Y protected: 0
' P O; F# d1 c7 G virtual_size: NULL
' d5 U) Q2 g& i" m. S5 u7 j! f visibility: private
% F4 d/ z- o! h: J J% {*************************** 3. row ***************************7 P: d# {+ m3 `9 R( F z
id: b9c335c4-34a8-498c-a735-82567f7ef186
" b& \' s8 ]+ ~ R: U ? name: rhel-server-7.9-ssd* d6 r, a" s) R
size: 2684354560+ x+ V5 l C0 L$ w5 O! M' o: _( k
status: deleted
: p0 @% a. `& u: i$ f created_at: 2022-04-11 07:22:43% F. s& i7 n4 B2 e
updated_at: 2022-04-11 08:02:40
" Y8 F, f, Q v" T j2 p- b# c deleted_at: 2022-04-11 08:02:40/ }8 j/ |% A& Z: ^& H
deleted: 1
. r* N7 R. k9 D5 `2 w: e7 g disk_format: raw) O$ }# ~8 {3 a, _ Y8 d
container_format: bare
: _2 P: J2 q5 g2 x; V$ z: m checksum: 67e20fa3da128b17c3ec01d03e1e293d
& H- r3 x9 {/ }/ E owner: 6f0124196ea74eb79fbcf370add3ca7e: c$ d# C- Y; K' O1 h2 C7 ^ p+ }
min_disk: 0- x7 f6 O' |. |! V
min_ram: 0+ q( n9 o" E) e" s `9 i6 Y
protected: 01 U9 C8 o& u) d& X4 @" W
virtual_size: NULL3 h- A4 B, \5 D1 w4 h
visibility: public
5 u6 D* Z. q6 Y, ~- t*************************** 4. row ***************************# s2 d$ m9 F$ c2 U2 f, @8 T& D
id: ea333f95-79c3-4ce4-856b-a397cc963d777 m7 @' ^7 e3 u1 g& X6 h: v4 z
name: windows_2019_x64-hdd-2.4T: n0 X' K7 N5 p3 k: m
size: 12884901888
0 d% j+ p6 Y3 C( c8 _ status: active
+ w/ r+ f' ^- ^( X% t6 N created_at: 2022-04-13 01:25:56
/ }$ E: |3 Y' D; V updated_at: 2022-04-14 03:42:54
( y) f3 U: s& b( v& D deleted_at: NULL" \% F/ w0 V- B: Z
deleted: 00 |) I& B% B8 \8 e" d. z
disk_format: raw% J1 c z- Z. w8 K
container_format: bare# m6 M5 j& ~6 _, x5 k. a+ |
checksum: 2eabbd70218411fdb021c4cdb790b82f9 l* T9 I, @ l* m! N! e
owner: 6f0124196ea74eb79fbcf370add3ca7e
' g) a+ y- k- M4 n* G min_disk: 0
. P9 ] \. S. A9 X, P. R: q% O/ n) R) z min_ram: 01 |8 V! ~0 d" W& z* S1 S
protected: 0
7 T$ Z; ]6 g6 n f7 R virtual_size: NULL# C+ p8 T* M8 {" i$ L0 @3 d
visibility: public
8 g3 M% A) G9 y- V+ f O*************************** 5. row ***************************: C* X% l( o3 ~$ H- ]( Z8 [
id: fb5fe7ed-ba56-4ae2-a483-af3cc0cce891" L( m& \' z- a8 F _
name: RHEL-Server-7.9-ssd
, K8 Z% X3 t2 B. Q3 E! H size: 3006477312* k! p/ R( {' x) y
status: active7 M# w! N# ]' I) p5 X( N
created_at: 2022-04-12 02:16:140 o) |# n4 b) ~2 [, A
updated_at: 2022-04-15 01:04:465 B6 A9 l3 r/ i- c: y
deleted_at: NULL
* j& u `/ P# Z( v w# ^# ~6 \ deleted: 14 x" w- q/ R: P! O& L
disk_format: raw: i3 P7 Y* h" ~# f$ ^* c9 u
container_format: bare; B A; \9 V2 Y' e& v+ Z5 ]
checksum: 3ddbd59c32a4ec8141018ee9a433c78e
. j' L6 `; R w# u) S) ?# E2 Q* C owner: 6f0124196ea74eb79fbcf370add3ca7e! j5 u* P; ^' D- A" q4 c& j
min_disk: 0
7 ~: T9 l. p3 w" t0 D min_ram: 0
/ c3 h( `+ L* L& k! f protected: 0
+ @$ {7 [; ^- K' F5 }4 l6 i6 o virtual_size: NULL! e0 m% m& Z( K2 P
visibility: private
9 s) k8 t- j+ Y# l1 p5 rows in set (0.00 sec)
- _6 \: ]& H h& `+ f3 wMariaDB [glance]> select id,name,deleted,status from images;) I& ^, l1 M1 _2 E
+--------------------------------------+---------------------------+---------+---------+: x3 F# V" Y: {# j
| id | name | deleted | status |8 D. n3 u; @! e. t! D) B
+--------------------------------------+---------------------------+---------+---------+
. R- s, ]% a( B" `( h. u% t/ D| 0470245c-ee24-488f-89c9-622fd85e9ade | centOS7.9-x86-ssd | 1 | deleted |$ p& P) ^/ k1 A/ @
| 18804abd-9cba-4a94-8ceb-ba9b12f9fc47 | RHEL-Server-7.9-hdd-2.4T | 0 | active |
) d. P( }9 [: d4 ~% M- x| b9c335c4-34a8-498c-a735-82567f7ef186 | rhel-server-7.9-ssd | 1 | deleted |
7 h6 ?$ p5 Y; O! |5 K| ea333f95-79c3-4ce4-856b-a397cc963d77 | windows_2019_x64-hdd-2.4T | 0 | active |, F' D7 S: E. c4 Z7 g* x
| fb5fe7ed-ba56-4ae2-a483-af3cc0cce891 | RHEL-Server-7.9-ssd | 1 | active |' F# u' @. g5 U' J4 j; V& G7 }5 P
+--------------------------------------+---------------------------+---------+---------+
. g# x- y) t8 N9 i! m0 h9 U! P5 rows in set (0.00 sec)
1 m# E" k3 R. U& AMariaDB [glance]> update glance.images set deleted='1' where id="18804abd-9cba-4a94-8ceb-ba9b12f9fc47";) z# U2 q b; T0 I6 e$ Y$ U
Query OK, 1 row affected (0.00 sec)# W0 O8 _8 @5 d, W) B% O
Rows matched: 1 Changed: 1 Warnings: 0
% c$ n7 e6 d* E2 Z4 x4 O/ I6 h1 CMariaDB [glance]> select id,name,deleted,status from images;
& ^# p3 z2 q" y4 e. } L: t# z# L+--------------------------------------+---------------------------+---------+---------+2 Y0 T+ q7 l! M
| id | name | deleted | status |
$ K9 A9 l1 i. ~; k' Z+--------------------------------------+---------------------------+---------+---------+/ ]5 Q9 R' s% h5 f5 A
| 0470245c-ee24-488f-89c9-622fd85e9ade | centOS7.9-x86-ssd | 1 | deleted |+ T5 r( F h+ Y, J2 E2 m7 Y
| 18804abd-9cba-4a94-8ceb-ba9b12f9fc47 | RHEL-Server-7.9-hdd-2.4T | 1 | active |
9 _/ B. @7 Z2 Y0 L: K| b9c335c4-34a8-498c-a735-82567f7ef186 | rhel-server-7.9-ssd | 1 | deleted |
+ [5 b+ `' z: u; [| ea333f95-79c3-4ce4-856b-a397cc963d77 | windows_2019_x64-hdd-2.4T | 0 | active |
, R$ X. s4 Y5 x u: \1 r$ v| fb5fe7ed-ba56-4ae2-a483-af3cc0cce891 | RHEL-Server-7.9-ssd | 1 | active |
4 u& X) U! d8 [+--------------------------------------+---------------------------+---------+---------+- m9 L5 ^% P8 d7 q9 O
5 rows in set (0.01 sec)
M; f! R7 y4 @' p& G. Q
( E& m0 t& c. b1 l
: B$ ?8 C |2 b! `) N4 U# C完成更新数据。切记不要delete数据，因为这些数据库表之间有关联，会导致数据库凌乱。解决办法一般都是update状态。切记切记。
) T8 ~, c+ U B1 N( @' D$ B9 ~* m/ q7 N |
|
/4 
窥视卡
雷达卡
发表于 2022-4-15 09:26:14
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
照妖镜
