- 积分
- 16840
在线时间 小时
最后登录1970-1-1
|
马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。
您需要 登录 才可以下载或查看，没有账号？开始注册
x
mariadb删除glance数据库中镜像文件，使用update set 修改运行状态一次操作记录：
; m8 p @& l& _, gMariaDB [glance]> select * from images\G+ }4 a j/ n$ m' v! c) v. V8 {
*************************** 1. row ***************************; N9 b4 e$ W c" P9 y" M* D
id: 0470245c-ee24-488f-89c9-622fd85e9ade$ t$ M. L/ W/ N5 m9 m$ n
name: centOS7.9-x86-ssd) z9 ?8 b, N3 s% c5 J& o) H
size: 3221225472$ Y8 R8 _% v, C# f5 F! }
status: deleted
" h) ?6 x: e) z7 B' {# i3 M! I+ N created_at: 2022-04-08 12:48:27
9 l' z4 j N; }; M1 x updated_at: 2022-04-15 01:04:25' }$ a3 {# H# h& s/ B& C9 X
deleted_at: 2022-04-15 01:04:25
9 F0 I, p9 p" f# @. i deleted: 1
9 p8 n- O; N1 ]3 J* g disk_format: raw
* k4 U- o& t: p3 l* r8 y+ p1 Lcontainer_format: bare2 w" S; n4 C& x9 o, e0 K6 O" G- `
checksum: 6067ba67d340d6849fb08ad2dc1dc752
# N6 B9 i9 n# H& Y2 A3 @ owner: 6f0124196ea74eb79fbcf370add3ca7e# ^* ? I4 `( w' h
min_disk: 09 Q) y! b8 D' f$ I
min_ram: 0
5 U* N# ?# K, J$ A$ L protected: 0. U7 z* ^5 E5 Y$ t* Z
virtual_size: NULL
' m1 P4 F% B1 J( p7 V2 q visibility: public
; N, q2 k" y" x( W*************************** 2. row ***************************9 @8 W9 |8 \! f4 ^5 R6 }8 f
id: 18804abd-9cba-4a94-8ceb-ba9b12f9fc47- v' w1 X( a4 n& n
name: RHEL-Server-7.9-hdd-2.4T
. s: j k! r( @: p size: 3006477312& d. ]7 I* T, I2 U) r+ q6 m& x9 Q
status: active
" y v+ r1 y- O/ P created_at: 2022-04-12 02:44:15& j; E! B, u% Q% H
updated_at: 2022-04-15 01:04:39" M! X2 u) w. N" S4 o
deleted_at: NULL1 q& b& H0 s! u5 ?" d" q! k, A4 j6 A
deleted: 03 e$ v2 i! k8 e3 k& f- ?+ c/ t3 k- R
disk_format: raw. z1 b' H/ X3 ^! I$ n
container_format: bare- C/ b, S; {" Z# K
checksum: 3ddbd59c32a4ec8141018ee9a433c78e* L4 z+ R1 v, w2 u: n' @
owner: 6f0124196ea74eb79fbcf370add3ca7e% o! i q! M( ^; F8 A
min_disk: 0( ` d6 }1 j) N: h; h
min_ram: 0' U' f4 u. `! _
protected: 02 X0 |, q7 M6 Q* q" ?
virtual_size: NULL3 M7 |2 J$ J& ~* M4 F2 N/ h8 o
visibility: private
7 M/ i! j9 A( H" K*************************** 3. row *************************** b+ a8 k) E |, q$ ~: y. ?
id: b9c335c4-34a8-498c-a735-82567f7ef186
. J4 g& Y* o# M6 K! A/ D6 Z name: rhel-server-7.9-ssd+ C$ F; W3 E) x. T6 R% F
size: 2684354560
5 Q l$ |& @/ \1 S2 a: P status: deleted
6 ?) E4 C x* @ created_at: 2022-04-11 07:22:43
9 g( s/ {# A( @' h updated_at: 2022-04-11 08:02:40
+ c/ C% ~$ Z* }( `" ]6 H( D7 O deleted_at: 2022-04-11 08:02:40% o S0 k5 Y+ w( @5 L! Z0 ~4 |$ [
deleted: 1 R* X) {# X. X7 E0 U* p
disk_format: raw$ [" U* c: T5 i2 }' P% y
container_format: bare5 Q# x% N5 W* v s
checksum: 67e20fa3da128b17c3ec01d03e1e293d# E; F& }! R8 |8 ~
owner: 6f0124196ea74eb79fbcf370add3ca7e
" m! @9 Z3 `8 L, h8 g0 f0 g9 ` min_disk: 0- A$ o8 f: N$ m
min_ram: 0
5 I" W c: o/ r protected: 0
. k! a' A: u* K1 K- h virtual_size: NULL
( M" P- _. |! ~6 U5 D visibility: public- u6 D* H) k, l! G* l! q' ?
*************************** 4. row ***************************. {9 s0 T% }6 Q9 E9 `) ^- ~* n
id: ea333f95-79c3-4ce4-856b-a397cc963d77
) {# ]# B4 F5 |9 }- E# m name: windows_2019_x64-hdd-2.4T" @0 d1 z0 G& m: Z& u7 G! r* y& U
size: 128849018886 m2 V& j, B! v) n( B* [. M! `
status: active
6 X5 G% J r1 o! q! g& S8 L created_at: 2022-04-13 01:25:56
b* W- W& j7 N6 c9 L updated_at: 2022-04-14 03:42:540 s2 z& n: t8 s# D, t
deleted_at: NULL
0 b4 H6 p: N4 o9 K: [1 Q+ j- ? deleted: 0; E, Z% ?) K! e9 e6 M
disk_format: raw4 J* e1 h% T3 I0 d( c
container_format: bare* _& V- Y8 y7 j. }- b' _5 c2 d. F
checksum: 2eabbd70218411fdb021c4cdb790b82f
4 |; W7 {( v. n a/ v owner: 6f0124196ea74eb79fbcf370add3ca7e. j& E) w) F: S
min_disk: 09 D% p g4 c' R, a; Q6 Q% E4 i; g
min_ram: 0% q. F0 g/ ~7 n( U, p- M" s
protected: 08 G9 l: o6 A2 e& r: t
virtual_size: NULL6 u: N5 S; ?* ~2 y* R* ~+ l
visibility: public0 X) M% d4 P7 B4 D) T
*************************** 5. row ***************************5 u$ `$ s; [) b) v
id: fb5fe7ed-ba56-4ae2-a483-af3cc0cce891
8 l; u* i$ d6 y, E name: RHEL-Server-7.9-ssd
; m. I1 \2 m9 e& | size: 3006477312$ G, a& ]/ G/ |9 b# J. l
status: active
$ }0 p9 M% h1 w* `- g created_at: 2022-04-12 02:16:14
9 A5 b# L! R( o* G updated_at: 2022-04-15 01:04:46( ]1 h+ m" N5 k
deleted_at: NULL1 L4 {% t5 h8 v7 @! J% q/ T0 l
deleted: 03 I- [3 K8 N- F+ F
disk_format: raw
% l b, ?8 T V7 N# |# o9 Pcontainer_format: bare/ r$ _) R: f7 q& e5 w3 l) o' t
checksum: 3ddbd59c32a4ec8141018ee9a433c78e
+ e* {9 q! B# G' Z0 e* M X owner: 6f0124196ea74eb79fbcf370add3ca7e8 }; F$ e0 Y) K7 _
min_disk: 06 ]8 a V$ r& m* `! e
min_ram: 0
I' ]8 b* {1 Z) U8 Y" ~( ` protected: 0
. h( R3 S8 a7 H0 C& k! m" s9 T virtual_size: NULL+ J. v0 | ` ?1 D* B8 {1 m9 L7 e
visibility: private" S' z) M! J" }6 L
5 rows in set (0.00 sec)
3 h* m# }% z8 x" W8 N1 Y( X+ Y6 W5 E9 w1 P) B. O' V
MariaDB [glance]> update glance.images set deleted='1' where id="fb5fe7ed-ba56-4ae2-a483-af3cc0cce891";
0 c9 ^3 N0 ^' i7 LQuery OK, 1 row affected (0.01 sec)$ D! X( [2 I3 V7 ^8 b# B
Rows matched: 1 Changed: 1 Warnings: 03 {# P! M: m+ \& j' A
MariaDB [glance]> select * from images\G
7 c9 m2 a' `+ ]" e c*************************** 1. row ***************************7 u+ g D8 I- a
id: 0470245c-ee24-488f-89c9-622fd85e9ade
2 N( E" n1 w1 Q/ I8 `5 d3 k) I8 H name: centOS7.9-x86-ssd
+ S& G5 |) n( z8 W4 E size: 3221225472
4 q1 X- \( \7 h status: deleted, u0 R4 n0 V% m
created_at: 2022-04-08 12:48:27
( s2 t% d2 R5 z+ M' } updated_at: 2022-04-15 01:04:25. B3 ]+ Y5 {- y4 @
deleted_at: 2022-04-15 01:04:25
5 z3 v5 P+ }3 C! \ deleted: 1, R, t4 b! |, a$ } S
disk_format: raw3 B1 \9 Q6 S3 t6 Z+ s/ `
container_format: bare4 R. j; \* l! V, ?2 V" R2 u
checksum: 6067ba67d340d6849fb08ad2dc1dc752' _6 @' E. S( x I$ k* \4 {
owner: 6f0124196ea74eb79fbcf370add3ca7e
8 D: p+ L- @# @" H2 z3 Z2 Z min_disk: 0" D6 k1 k( o+ y0 E
min_ram: 04 U- U' [9 S- R7 |/ O9 V
protected: 0$ S- v1 C5 U3 e" U! @
virtual_size: NULL
& r! a, N: J1 O2 r, U visibility: public
2 v. l& ?. s/ P& H" v! n8 f2 }! w*************************** 2. row ***************************3 q5 x( h1 j9 T1 @
id: 18804abd-9cba-4a94-8ceb-ba9b12f9fc47! i9 }; F4 y* Z7 h% i$ t2 {
name: RHEL-Server-7.9-hdd-2.4T s& s) r& F6 k
size: 3006477312
* ]7 `$ B; r: D3 c: V" o3 y! K status: active( C" r& I h' a* C
created_at: 2022-04-12 02:44:15
" X5 S; X9 C9 b/ _7 S' y updated_at: 2022-04-15 01:04:39! E) j; W; Z# |
deleted_at: NULL6 Q/ D- T6 r$ _( ~' ~
deleted: 09 I& f$ D# {! |7 x) B# G
disk_format: raw
) S9 n7 R! S) V) d1 M- Ocontainer_format: bare
& O+ j# }) Y, E* N/ ~ checksum: 3ddbd59c32a4ec8141018ee9a433c78e
; e, ~7 b* X3 _9 e) a owner: 6f0124196ea74eb79fbcf370add3ca7e3 D1 y5 Z3 s `/ U# ^# ~: i
min_disk: 01 @1 I0 ?) D3 o& e. K3 A
min_ram: 0
" z4 o& `2 ~4 E: S; ?7 a protected: 0; m" |. t6 M1 s: j/ X! Q
virtual_size: NULL
) e+ o4 q j" e; j- f+ d) t* R visibility: private/ w1 B1 R3 Q; Z& S/ N" a3 m# t
*************************** 3. row ***************************
7 r0 W$ l9 j! s: h, C: E- M& ` id: b9c335c4-34a8-498c-a735-82567f7ef186
3 O5 }7 s8 K9 e& s name: rhel-server-7.9-ssd
0 n- ~3 Z1 ?9 \ size: 2684354560* X# ?6 }, l: N) H( d/ u
status: deleted# z2 w7 _& K% u4 J A) t7 f1 @
created_at: 2022-04-11 07:22:43
# c. M3 X& F% n updated_at: 2022-04-11 08:02:40; ^' p( J0 y! y, @' d c1 u
deleted_at: 2022-04-11 08:02:40
! i: J+ q. s0 ?/ o. _2 j* b deleted: 19 `! ^. _; C! e! e1 |0 r9 @, d
disk_format: raw
9 y! S# T/ V( r; A' Pcontainer_format: bare
+ C' O. a/ t$ B' D$ ]6 R checksum: 67e20fa3da128b17c3ec01d03e1e293d% S% r: _/ c$ y4 l" w; G, r4 B! G
owner: 6f0124196ea74eb79fbcf370add3ca7e
* l2 J/ F: D( \/ u0 X8 p+ p min_disk: 0+ s/ b, N( b; M9 K; M1 C/ W) ~" S
min_ram: 0
# W) L B" E: C! p% y, x0 n protected: 0
8 ?& h- S' z8 b' ?% }1 o! S virtual_size: NULL0 j6 j' S/ S9 [0 H
visibility: public
# y+ R8 e- Q; {! m) `. F7 Q*************************** 4. row ***************************
4 p, ?+ ?! Y% n, q! V id: ea333f95-79c3-4ce4-856b-a397cc963d77
$ ^9 t+ P+ Y$ K" r name: windows_2019_x64-hdd-2.4T
& G/ K8 n" J$ h& s2 c size: 12884901888
, v/ j' j; q7 T+ n status: active
) k0 j, }8 `! y/ l created_at: 2022-04-13 01:25:56! S, W9 J0 x9 _ A6 K( q- t- \
updated_at: 2022-04-14 03:42:54
. G8 V+ b9 c4 a R deleted_at: NULL
6 e1 x/ |0 m) a2 E( I" X. F deleted: 0 D, ~: P; v% F
disk_format: raw
, K' h8 j i; }' A* y. ?* @container_format: bare/ H' | N G; _ C# F/ f3 f
checksum: 2eabbd70218411fdb021c4cdb790b82f g; i2 w j8 H
owner: 6f0124196ea74eb79fbcf370add3ca7e
3 g% H. S Z$ F% K4 K& u! K( z" M min_disk: 04 q9 y" G: x& |+ S! C
min_ram: 0& `, c' \& Q( j( t
protected: 0
! g9 p+ I; E' A2 b virtual_size: NULL& p* T" |& ^( V+ O+ e% K
visibility: public
8 x# {0 }, Q9 ?4 l3 |*************************** 5. row ***************************+ P5 l' R9 O' Y3 ]; ]" C
id: fb5fe7ed-ba56-4ae2-a483-af3cc0cce891
) W8 C5 ?" q" t# ` name: RHEL-Server-7.9-ssd
$ b2 H. H/ s9 u size: 3006477312" A# n9 x* @9 i, u9 w9 n- [6 l
status: active4 D7 p+ S, i, { t
created_at: 2022-04-12 02:16:14
( W c3 k7 Q9 X7 [7 y/ i5 Y8 ? updated_at: 2022-04-15 01:04:46/ M# b; H$ ]. `, j5 c9 O
deleted_at: NULL% Q y# f& p& `8 M
deleted: 1
7 }5 V& W) T; q2 C# M3 d* }8 [ disk_format: raw3 W/ o) G" x \" I* F% B
container_format: bare4 ~1 | W, I# |- F' g! c
checksum: 3ddbd59c32a4ec8141018ee9a433c78e
: J, p) j1 c+ M6 l( G: a e0 F owner: 6f0124196ea74eb79fbcf370add3ca7e+ d1 l5 e1 }" C. }. ]9 D
min_disk: 0
" x0 `, ?& e7 B, w5 u. G, ? min_ram: 0% I2 u. { S ~# b% g
protected: 02 I- ]: q( s* h1 d5 X$ F
virtual_size: NULL: M) |, _- | W9 C
visibility: private
* v* Q% a! {- ~) k5 rows in set (0.00 sec); P' X, l. L0 K1 s1 o/ P8 b4 `
MariaDB [glance]> select id,name,deleted,status from images;& a% I* U, u4 {3 C* l+ q/ T2 e
+--------------------------------------+---------------------------+---------+---------+
9 q' n3 i; X3 o9 g( M3 Q5 a| id | name | deleted | status |' X9 c5 ^9 ?1 p1 |* @4 J7 a
+--------------------------------------+---------------------------+---------+---------+" d8 j: n: b+ P5 d
| 0470245c-ee24-488f-89c9-622fd85e9ade | centOS7.9-x86-ssd | 1 | deleted |* e, w3 p5 ?% P
| 18804abd-9cba-4a94-8ceb-ba9b12f9fc47 | RHEL-Server-7.9-hdd-2.4T | 0 | active |
8 b6 s- ^+ H+ a+ I5 ~8 E| b9c335c4-34a8-498c-a735-82567f7ef186 | rhel-server-7.9-ssd | 1 | deleted |7 r, }3 t: n% V3 `0 ^$ i
| ea333f95-79c3-4ce4-856b-a397cc963d77 | windows_2019_x64-hdd-2.4T | 0 | active | s' @/ q4 O1 g: }. j8 J
| fb5fe7ed-ba56-4ae2-a483-af3cc0cce891 | RHEL-Server-7.9-ssd | 1 | active |
: j: Q: Y2 P: Y) C+--------------------------------------+---------------------------+---------+---------+" C! b# l, C4 H" N1 y
5 rows in set (0.00 sec)
' ^7 U8 R( a; W" |) p( ^8 J$ nMariaDB [glance]> update glance.images set deleted='1' where id="18804abd-9cba-4a94-8ceb-ba9b12f9fc47";
p/ i$ T8 ? w( G' zQuery OK, 1 row affected (0.00 sec)
4 Z' {; L6 m6 |$ hRows matched: 1 Changed: 1 Warnings: 0 i! b/ Z' a1 b* I5 s! D3 F
MariaDB [glance]> select id,name,deleted,status from images;
1 M! s A+ w+ T h% z( V7 `) L5 k9 H+--------------------------------------+---------------------------+---------+---------+/ Y- J2 v, _ P$ n
| id | name | deleted | status |
- Q% j: l( f& I: ~( U H( V+--------------------------------------+---------------------------+---------+---------+; o/ w0 V/ X% h# _0 y: h. I
| 0470245c-ee24-488f-89c9-622fd85e9ade | centOS7.9-x86-ssd | 1 | deleted |
' c, C" o" [' X" g| 18804abd-9cba-4a94-8ceb-ba9b12f9fc47 | RHEL-Server-7.9-hdd-2.4T | 1 | active |% k- T/ C2 i+ x, s8 }# j6 E
| b9c335c4-34a8-498c-a735-82567f7ef186 | rhel-server-7.9-ssd | 1 | deleted |
' r( k! b. D, v$ `+ O. U: w| ea333f95-79c3-4ce4-856b-a397cc963d77 | windows_2019_x64-hdd-2.4T | 0 | active |# I# \/ }+ u* a5 B
| fb5fe7ed-ba56-4ae2-a483-af3cc0cce891 | RHEL-Server-7.9-ssd | 1 | active |
/ a2 i5 j; ?4 c$ l+--------------------------------------+---------------------------+---------+---------++ Z+ P n0 v0 g$ w# ]$ ^
5 rows in set (0.01 sec)
( ]$ T* O% M9 e& A( h6 t' B( f
* }! ]4 B- d$ H% E, t! T4 l5 _* C0 C$ h# M C, F
完成更新数据。切记不要delete数据，因为这些数据库表之间有关联，会导致数据库凌乱。解决办法一般都是update状态。切记切记。* S1 ]# b7 T0 L* ~/ D7 A
|
|
/4 
窥视卡
雷达卡
发表于 2022-4-15 09:26:14
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
照妖镜
