|
|
The image cannot be deleted because it is in use through the backend store outside of Glance. (HTTP 409)% O2 M/ e9 ?* M% F
S! J5 g5 {/ `/ H6 Z% [) I[root@controller01 ~]# openstack image list |grep jumpserver-devops-image-v.2-2021-11-16 - `1 N2 K1 e( p8 @
| 1e6e2885-7a62-4ecc-a356-06f95baa01b1 | jumpserver-devops-image-v.2-2021-11-16 |& ^5 A, d3 k" _9 P
[root@controller01 ~]# openstack image
) m+ B6 O- l: q! j% l* Jdelete list save show ! a) P. c2 a @! J) C
[root@controller01 ~]# openstack image
. j" A3 ?- y/ ^' G! U, [" x& `delete list save show
, D) G3 x" u: w[root@controller01 ~]# openstack image show 1e6e2885-7a62-4ecc-a356-06f95baa01b1 3 w8 b. ~- `0 P. u! M- K
ERROR: openstack _info
. t9 B0 y' h! v* Q- @[root@controller01 ~]# openstack image show jumpserver-devops-image-v.2-2021-11-16
) S* z+ V0 v6 bERROR: openstack 'Controller' object has no attribute 'resource_class') D8 k' I/ a% P& E" n4 l
; O7 R. b, S: t: |* p
- F9 {( L2 q: d; A9 A
- O$ M2 I( t- N6 X[root@controller01 ~]# glance image-show 1e6e2885-7a62-4ecc-a356-06f95baa01b1
2 W2 l/ m! c( ~/ T. x* K" x+---------------------+----------------------------------------------------------------------------------+# o( k, F) B+ }0 |* d( G5 q/ a2 ^
| Property | Value |: f9 `9 H+ r. n* p- v' {7 j9 I& f
+---------------------+----------------------------------------------------------------------------------+
& J5 A1 w0 T% c| checksum | None |
& N+ `+ W2 F$ Q/ M; _1 k3 q9 Y| container_format | bare |% Q/ N) m4 D# b) [, i# w
| created_at | 2021-11-16T03:03:33Z |8 x9 v+ H$ d0 V: h7 M. ~' J
| datastore_name | SATA |4 ^6 V# J8 R% _6 e' G
| datastore_uuid | 0f5095d9-9383-4f63-b835-2b0e0f57b7b6 |2 [7 P0 D8 [$ S" W
| description | None |
$ M [9 i( T! Z$ {7 v| direct_url | rbd://d385bef6-6778-43cc-8755-4e1d5ef5485e/SATA/volume-36abe473-8426-4b2d-8e9b- |
3 [, P8 r& Q7 T8 p% F| | 57fe3a24d38d/snap |9 A2 E. \9 @4 R8 O
| disk_format | raw |
' j! A- S1 s) L, ]8 \; P| hw_qemu_guest_agent | yes |
5 `8 q4 q; c: a) r* s| id | 1e6e2885-7a62-4ecc-a356-06f95baa01b1 |# j5 Z, _ s2 l
| min_disk | 50 |
5 l" e% n: `5 X# E| min_ram | 1024 |2 B4 Q2 h2 l: `' o- H$ T
| name | jumpserver-devops-image-v.2-2021-11-16 |
: V+ ~$ q/ p) f+ h| original_image_id | 679a3ad4-7dc3-49bb-9656-bc7d43218184 |$ H& T: f+ X# n1 e( c S4 { `
| original_image_name | centos7.8 |
5 V0 N7 w/ v; v| os_arch | x86_64 |* J/ |& ^6 s: Y- V4 [& ~, i
| os_type | linux |6 N* d& N v: Z, f$ W; [
| os_variant | linux7.8 |
2 e# R, g/ ?5 E3 V2 S V' a| owner | 6df9e85ed72449adbfb4765467e93b10 |, Q4 P& ^& U9 L v$ F5 r1 p
| protected | False |" P/ H1 x; a/ S, w9 T
| size | 53687091200 |( P' t+ B6 Y$ \# z
| status | active |
" {. [9 b6 y& V% G' ~4 Z$ X* l( }| support_hypervisor | kvm |
G* _; b% U7 G8 p, J| tags | [] |
5 u3 [7 W. f+ T' d$ H* x: K! P| updated_at | 2021-11-26T12:30:02Z |
5 R: S7 q6 f! l) b| user_defined | true |! i+ N4 i( H& i9 {+ p2 }7 Y
| user_id | 1e1454d784f945a69d29bef4c246a28d |) j' j& z( P4 t) M" P& u2 {
| virtual_size | None |
1 u8 u9 O/ R2 W; z4 m| visibility | private |
; f4 ?# f3 a0 P* E2 b8 Y. g+---------------------+----------------------------------------------------------------------------------+9 k5 e: k1 H. \4 Z4 [" w. k' _$ j
[root@controller01 ~]# rbd ls SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d
+ ^6 s" \$ O8 jrbd: error opening pool SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d: (2) No such file or directory
' P+ C% ^; ^ @! g/ `4 M[root@controller01 ~]# rbd info SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d
# s' Z3 ], t3 ~0 Frbd image 'volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d':5 P; D0 k* T/ q5 L
size 51200 MB in 12800 objects
% `8 ?, @0 w+ s9 u+ B order 22 (4096 kB objects)$ l8 V$ F+ A# N* H6 A
block_name_prefix: rbd_data.104966b8b4567
: ^! {7 ?# W( C format: 2' c( f# i+ H, R
features: layering4 e- C; h; M2 W4 Q$ o) l
flags: 1 \% [5 G5 o' ~
[root@controller01 ~]# rbd rm SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d
6 _3 A1 o9 F2 {& u2023-09-18 10:34:48.482820 7f3cfad08d80 -1 librbd: image has snapshots - not removing
3 w- Q/ \. `& d) W4 g! ORemoving image: 0% complete...failed.9 j$ o6 O8 o% c. a
rbd: image has snapshots - these must be deleted with 'rbd snap purge' before the image can be removed.4 w( \# [! e1 b R5 A
[root@controller01 ~]# rbd snap purge SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d * u# T$ g8 ?1 \" c3 {3 l
Removing all snapshots: 0% complete...failed.
! O3 D- i* e) K# F; wrbd: snapshot 'snap' is protected from removal.
: ?4 |6 A1 @1 C% l* P- q- ~+ h! N[root@controller01 ~]# rbd snap unprotect SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d * N! Z8 Z1 H) o) |( X( T/ L
rbd: snap name was not specified# G7 B; x6 p% T3 V h2 W9 ~$ Y
[root@controller01 ~]# rbd snap purge SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d
5 P, L% ]1 t9 ~& M& r D0 D3 L4 _Removing all snapshots: 0% complete...failed.
% q3 ]! Z, v6 H9 i* p7 [rbd: snapshot 'snap' is protected from removal.
4 s. X7 t% t) t; h- t s5 r[root@controller01 ~]# rbd snap purge SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d
. q, M( {/ ~$ xRemoving all snapshots: 0% complete...failed.
$ P( C7 t* u1 ~( yrbd: snapshot 'snap' is protected from removal.
8 Y# p& q3 E) f* H) l: }[root@controller01 ~]# rbd rm SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d
$ ~; Q3 I+ p' y+ n; }8 C% p$ B2023-09-18 10:36:57.416308 7fc7bf2dcd80 -1 librbd: image has snapshots - not removing
2 z4 h5 P- ], l' N3 GRemoving image: 0% complete...failed.* e) |$ t' l7 m$ U& |
rbd: image has snapshots - these must be deleted with 'rbd snap purge' before the image can be removed./ r# Q6 `& E0 j: y2 G# d$ O
[root@controller01 ~]# rbd snap purge SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d ) B- k' @: ~3 p: t- u& x, H
Removing all snapshots: 0% complete...failed.& D! P) Q+ O8 r0 T+ y6 G
rbd: snapshot 'snap' is protected from removal.
7 u. i) p9 L+ m' O) ~% i[root@controller01 ~]# rbd snap list SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d 7 l' i# b2 m. x, O7 d8 s9 @
SNAPID NAME SIZE
" \1 n/ x4 C! g 14 snap 51200 MB , A+ \; I% @! y" ^
[root@controller01 ~]# rbd snap unprotect SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d 6 r, d1 S+ E9 D0 [7 e6 C( T
rbd: snap name was not specified% H8 O' J# p- y; S4 m
[root@controller01 ~]# rbd snap unprotect SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d@snap& k6 v3 W/ O- U( n
2023-09-18 10:38:16.974787 7fb17b7fe700 -1 librbd::SnapshotUnprotectRequest: cannot unprotect: at least 68 child(ren) [1085316f00e36,108683bdae241,108ef27e412b1,1090a41788b94,1092240c05ac8,1093a9f75897,1096a6b620819,1098514d4cd0d,109ac4c7707d8,109ca387999f4,109ee25a9f5fb,10a2d61953473,10a8741ccef4d,10ac95ac948a1,10ae4c882a47,10afc61d14bb8,10b1779a2fd01,10b5630d7c19d,10bad3dcbb3b0,10bc534068393,10be064b1ee1f,10c167550f8c9,10c31dd36b05,10c522d492134,10c887ab50fba,10ccd40588dca,10eb9ec20dbd,10f105039263e,10f2879263b65,10fc76220b0e5,1128827be96e,14d445e3d9270,14d68593800d6,14d803ea4fa42,43a1522441394,43be0349cba28,43c07754a890,43c28503ae770,43c52d08ab9c,43cc15218d773,43cf145c91345,43d1b67ac83cb,43d4265f52ab4,43d662cd114a5,43d8d23dce7f1,43dc34c1d0a2,43ded5e5e8292,43e2f52100bf,43e6e129baa59,43e9554bb641a,43eb91cd475fb,43ec810bd7bd3,43fc1d13350e,43fdc589f187c,43ffd26d4a2e9,44105c537dfe,4412c6e9dde82,4414738eb7218,4418c47b74943,441e614770978,44204317e0414,4422262f58e73,442466a1612a9,b38f1cb5b897,b3b03023a98a,b4b215948e8f,b4c7426816c,e09e36f6cb96] in pool 'SATA'0 f B% m) ^0 n, K! B4 A) D
2023-09-18 10:38:16.974815 7fb17b7fe700 -1 librbd::SnapshotUnprotectRequest: encountered error: (16) Device or resource busy
6 f6 P1 N: y: h3 [2023-09-18 10:38:16.974838 7fb17b7fe700 -1 librbd::SnapshotUnprotectRequest: 0x7fb1b03cc980 should_complete_error: ret_val=-166 B4 K( h6 w4 x5 h& O* m% d
2023-09-18 10:38:16.975426 7fb17b7fe700 -1 librbd::SnapshotUnprotectRequest: 0x7fb1b03cc980 should_complete_error: ret_val=-162 q A( w( ?6 Z$ v0 v$ K
rbd: unprotecting snap failed: (16) Device or resource busy; R" g* U7 ~# V- o
[root@controller01 ~]# rbd snap unprotect SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d@snap
* O. a0 u' Y, R7 `1 C% |2023-09-18 10:38:20.532807 7ff6f0deb700 -1 librbd::SnapshotUnprotectRequest: cannot unprotect: at least 68 child(ren) [1085316f00e36,108683bdae241,108ef27e412b1,1090a41788b94,1092240c05ac8,1093a9f75897,1096a6b620819,1098514d4cd0d,109ac4c7707d8,109ca387999f4,109ee25a9f5fb,10a2d61953473,10a8741ccef4d,10ac95ac948a1,10ae4c882a47,10afc61d14bb8,10b1779a2fd01,10b5630d7c19d,10bad3dcbb3b0,10bc534068393,10be064b1ee1f,10c167550f8c9,10c31dd36b05,10c522d492134,10c887ab50fba,10ccd40588dca,10eb9ec20dbd,10f105039263e,10f2879263b65,10fc76220b0e5,1128827be96e,14d445e3d9270,14d68593800d6,14d803ea4fa42,43a1522441394,43be0349cba28,43c07754a890,43c28503ae770,43c52d08ab9c,43cc15218d773,43cf145c91345,43d1b67ac83cb,43d4265f52ab4,43d662cd114a5,43d8d23dce7f1,43dc34c1d0a2,43ded5e5e8292,43e2f52100bf,43e6e129baa59,43e9554bb641a,43eb91cd475fb,43ec810bd7bd3,43fc1d13350e,43fdc589f187c,43ffd26d4a2e9,44105c537dfe,4412c6e9dde82,4414738eb7218,4418c47b74943,441e614770978,44204317e0414,4422262f58e73,442466a1612a9,b38f1cb5b897,b3b03023a98a,b4b215948e8f,b4c7426816c,e09e36f6cb96] in pool 'SATA'' p/ u) d9 ^ P! ^
2023-09-18 10:38:20.532836 7ff6f0deb700 -1 librbd::SnapshotUnprotectRequest: encountered error: (16) Device or resource busy
8 }+ K: G9 T3 e. X+ Y# b' D' k2023-09-18 10:38:20.532863 7ff6f0deb700 -1 librbd::SnapshotUnprotectRequest: 0x7ff71a5ae9a0 should_complete_error: ret_val=-16/ ^7 v" u; s }$ B7 S1 }
2023-09-18 10:38:20.533520 7ff6f0deb700 -1 librbd::SnapshotUnprotectRequest: 0x7ff71a5ae9a0 should_complete_error: ret_val=-16! @9 ~2 c# i8 ^$ p& ?8 d
rbd: unprotecting snap failed: (16) Device or resource busy0 Y. D- q x( ^5 c
查看rbd的孩子信息:. u5 b6 Y& @7 y% E: C0 X
rbd -p SATA children volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d@snap" Q. X; J' g3 n& N
SATA/volume-03e625a4-75ca-4471-8df3-6cb860dc3360
$ U6 i3 V& h" o/ e7 qSATA/volume-08502b39-0575-4f89-9d21-f708cea65228
% v9 }, r/ u7 k+ K x4 u4 k& j: @SATA/volume-09656839-24e1-4059-8ef5-3435bacb5b60: ?% d- a2 ~ \) o9 @& r# ^
SATA/volume-0a89143a-d525-4081-8930-a18f5b7c630e
7 \5 H7 n' H t# o1 l6 v2 uSATA/volume-0c2614a7-dec4-4ad6-8561-11c267fab265# }& H6 a7 L. ]( N5 `8 _: j& t# P
SATA/volume-1002cff5-fbf4-4ff6-8201-c151771339ab- j, j* d& i1 O/ W7 Y5 I, q
SATA/volume-1255044c-cdd3-4de0-b698-29d671af46e07 W8 _; _. @ `" _7 G
SATA/volume-128008ee-83fa-4786-906b-d8bc12313ba40 X5 W5 B1 s7 R4 q7 p8 A: @
SATA/volume-13d2eb3a-7565-4af0-9432-60cc5fc38ea6
) M# R4 p: P: q$ ]3 L3 p* {6 ^% wSATA/volume-1455427d-d831-43f9-a7cc-66ede8b7a9ae0 M- c& N O7 z. S: M6 a- S
SATA/volume-1845f299-d9b2-4ea5-af0c-f5780d09fd81: S9 o% L& x* o6 v h6 \1 c
SATA/volume-192f787f-0566-43d7-8b9c-7b989619ea48
2 U( D2 R! z; I1 e2 N6 Q# cSATA/volume-2365120a-18ba-44e9-96c5-6efcc0db3574
/ y! w7 B6 L8 J* T' YSATA/volume-276e33f0-3d41-4dc3-ad11-39b1d2314f5d
R E% n4 [& M U7 |/ `* SSATA/volume-289b83c3-24c1-41e9-b773-b6174c2d895a4 B& b1 ? Z2 f
SATA/volume-2b14242c-8a9e-4ec2-86bc-e78bf20cf8fa
1 j. U2 g H% Q, e1 h# mSATA/volume-2c89db19-f0b7-4864-bbf4-72c6dc4af115
+ j& R' j# I' q/ d1 k! S: KSATA/volume-2e174c85-3977-4f42-9867-60d6bf9d716e) O' }: x& S* J$ u
SATA/volume-2e732f91-d2e4-4c46-a62f-ed33a008a287
) g; G5 H1 h% ?8 I! t4 C8 h2 {SATA/volume-2f3ca82d-c208-4253-8581-53bf0c11d504! ?% v' s, u2 ?& @+ Z' K: [, V1 c
SATA/volume-31a011dd-a39b-463d-a60b-904c018af283
$ h7 Q* B; w' b# x! i/ C; x" {SATA/volume-340a710f-7ad5-47dd-bd80-afa61ac22aa3
9 T% S4 O+ g$ l: v% J4 [3 }! mSATA/volume-369bf7da-7948-4963-a887-d47cc21919b1! e+ r0 i7 m0 [5 ]8 m
SATA/volume-3a0f59a2-7e48-47c0-bc5c-654fc55b29516 @" R% B6 ^! \) T. Q7 k1 b$ A
SATA/volume-3b8361f9-a860-41b8-b430-ce5a52433fcd
0 M) `* {( l0 o+ {( TSATA/volume-42acbb21-ba7c-4112-9c18-0846b21f526a
; X* x( w$ q, k9 S% SSATA/volume-4aa7702e-6c2e-48c1-a4fa-e5c9cb844fc3; ^. a; p, z. {5 m I$ j
SATA/volume-4e6bc42a-9ec1-4c25-bf34-acd1618f26686 n" r Q5 D# f
SATA/volume-5382ae5a-c63e-482b-9e9a-e6ca3890ef54
1 c' y$ Z/ B; }SATA/volume-5be35014-a23d-4c91-a5f1-922464b8c8c2
' V" K9 |+ Y3 y, r( C6 YSATA/volume-5d5a980b-29ac-4ce8-919a-4bc8c38a6e99# E: \4 F7 d, M! o- W
SATA/volume-5e7efeb2-7683-469f-8618-a8aca40d63b91 P1 v8 k1 P! {6 _0 I
SATA/volume-60ad0f73-8f19-4686-98d4-f92c16d4a890. ?0 m" p/ w1 M
SATA/volume-6339e354-7242-4fdc-a2cf-eac40bbbf12b7 E6 ~; [3 g0 y* G5 z1 X5 e4 N
SATA/volume-6b569b01-734d-4d5b-9538-69f8e95471a1
2 ?* ~! L# b1 e! ZSATA/volume-6ce2e030-c7ad-4e8b-aaf0-a44834bf378c$ S+ c) E0 v3 |( `9 V
SATA/volume-74d22fe0-be8d-40d8-b1b5-0a07d7c35491, ]: N6 F. b' u" o' l8 F
SATA/volume-769c181d-05e8-46f9-90fe-35dcfea90ac3
, ~" E$ _& f& N; N( G# S9 _) W7 KSATA/volume-76ebcff2-a0cf-4705-9177-7a8e8b345223( p0 ^- m% h' m2 b! v% Q- P
SATA/volume-822edf5c-7fab-44a2-bda1-c9cb5c04a6cb
+ f: r4 g' c2 J( ~# ~ gSATA/volume-862d806d-3643-4323-bf07-5ebb5a397fe4' ~* r2 L* j. H, S' J% p
SATA/volume-874b7f86-c5ea-435a-ad2d-746f207bb39c
& Y! d1 ]1 O3 p' hSATA/volume-87da9c05-26c5-4b5f-88d8-a881366f7f85" r' X( P( A/ ]2 j! k$ ?" k% w+ U
SATA/volume-8b061aaa-985c-4304-99eb-5ec89eb37e77
+ |/ g$ M* N5 r/ |9 t; z, k2 rSATA/volume-8fff319f-f267-4bcb-92f3-e1b91337116c- p; ~8 J7 q, g8 b; l
SATA/volume-971c27ba-b8a9-4f91-8ab0-df014f4af37f
; e' u+ L1 ~8 ]9 C- }SATA/volume-9c1646ad-c162-4671-bc5a-727e3fe0224a
5 j$ R; ?# b7 N7 x! L, Q0 t% n1 _SATA/volume-a11c1c79-4595-4c9a-8264-c7cdab5a8725
& @% J7 }/ k# v2 ySATA/volume-a79319d7-24af-46cd-93cf-5254f197e2b1$ @' ]2 a( D) v& U5 f
SATA/volume-a84d252b-59b8-4c49-a3d1-3298581a20dd! [8 G# N9 A5 s' r' x
SATA/volume-afabb05c-220e-4c53-983a-416fdf9c6ef0
, a. @' O4 b& V) pSATA/volume-b0a7304b-e8a2-4f35-b147-21f71e85177c9 v( v. _: H7 j. B- V
SATA/volume-b557dcfa-623a-4a7f-9bcd-2e66172965eb
. T0 `. q f: k V6 B5 @" RSATA/volume-b71c4975-5c12-4a37-a587-98fd503fbb35; M) N- l* p. D
SATA/volume-c6662572-7d5d-48bf-ac78-9752c76c7f23
8 z# p) x2 |: N/ A9 e6 PSATA/volume-cfeb4dc9-39e6-457b-961a-fce016ab5e35
9 I1 t/ Y a1 HSATA/volume-d1f8d950-28aa-435b-8653-c778edecd6de
% A- N+ S* C+ }9 hSATA/volume-d2faedf9-6912-4faf-869b-32f40cd2d82d
$ Y W; S( s/ }" W3 X' Q; h% ~ wSATA/volume-d44e9131-a02f-42bc-9bce-71cc88a4fee21 g! Y8 v# z+ X( O4 B. C5 D
SATA/volume-da14a752-20fc-4e75-8a19-67b7ce88616f
+ j, ]% _: k! X9 xSATA/volume-dabd3f00-16ea-4de9-9f1e-db9698fe317b
( c7 r+ z8 ?* o( d! CSATA/volume-e7fea8aa-730c-4d51-8ae5-5dbc30b25d55# C- [+ b) j* `
SATA/volume-e947d90c-8c7c-4153-91a3-0192be459501# ]3 y {* ?# [7 k9 H
SATA/volume-eab7eb4f-542b-4560-8a10-f002e92dcf781 T% e8 R/ u2 g5 n" R
SATA/volume-ebbca357-ccbf-470b-8a25-9f3fbb9ad8d6
9 _ L" O* E: M1 ~+ tSATA/volume-ec0ae2a0-d4f8-433e-8c5f-fdf009b60fce
; c, z5 ~0 x$ cSATA/volume-eee596b8-71e1-4acd-b241-9d1420a71eee$ W6 o/ K% @: t- i" u% q% t# V
SATA/volume-fad889ce-9ade-4877-863b-8b883597764e
# P, C- o' j3 T/ p# A上面的方式还是无法解决:* `8 V; N& {. _! e( G+ n
9 @+ [0 a( Y) @: ~- J7 N& P! n
采取更新数据的方式解决下: U( }! `2 B( V7 L0 w& u+ c
Enter password:9 L5 x* q+ L2 }
Welcome to the MariaDB monitor. Commands end with ; or \g.
! j7 `! ?6 S" A' \: D5 AYour MariaDB connection id is 15183281) J, [& w0 |5 `. ^3 ~2 `
Server version: 10.2.24-MariaDB-log MariaDB Server3 m3 Y6 X: h0 n' [) I' I& x
5 Z7 ?% u; o+ Z: O( s/ cCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
7 u1 ]/ H0 R. x( } h
# K7 H+ i- g" E! y0 fType 'help;' or '\h' for help. Type '\c' to clear the current input statement.
! e6 f4 U$ O( u4 T- h
9 z( Z, H8 [3 `, L; _* H' ]+ `glance@172.24.201.253:glance 11:00:04>show databases;5 g9 I* R& a: @6 b. _
+--------------------+& h+ e" l0 U2 H a4 T+ b
| Database |
( ^8 }, L) \: V0 q$ w+--------------------++ [+ a& s4 A7 E) T- Z% p
| glance |! N' f z5 D7 z) W( d% V. n
| information_schema |
2 Z" c, Z! `" A! W; E! k9 y5 U0 U| test |& k/ ?) o2 Q7 D D* n O+ ~" d& ]
+--------------------+
' ]2 j' T H( m1 T5 N$ [7 v5 ?5 `3 rows in set (0.00 sec)4 v' N' S1 R1 E2 U6 Y: Y5 N1 H3 A
: m, J5 Z! {/ f" z* m1 ^: d
glance@172.24.201.253:glance 11:00:09>use glance. C3 Z I) Z1 M! V
Database changed
) a/ n& S6 t, T, Z+ D3 i& {6 tglance@172.24.201.253:glance 11:00:15>select id,name,deleted,status from images;0 ^7 p/ G, |' P& k7 @
+--------------------------------------+----------------------------------------+---------+---------+
# L4 U! [. T" C1 U% a| id | name | deleted | status |/ ^3 f: O5 a2 T% V
+--------------------------------------+----------------------------------------+---------+---------+( s! L: Y; Z& P+ v
| 059d4ab8-642b-4dff-ab5a-e724dca27a2d | WINSRV_2019_S_64_X_50_X | 1 | deleted |
( M* h' d8 a# _! b0 \| 0b989ee4-0d59-4892-96eb-0d35ed5451b7 | CentOS-7.9-devops-LVM-20230913.qcow2 | 0 | active |
8 e, J- U( V9 s& A( k| 1d806e6b-df9e-4320-b267-218aae22ec6d | WINSRV_2019_S_64_X_50_X | 0 | active |
2 q a& Y9 F( |. F$ j2 a| 1e6e2885-7a62-4ecc-a356-06f95baa01b1 | jumpserver-devops-image-v.2-2021-11-16 | 0 | active |
" t- `: }1 [! h" R$ x| 1f2b90f6-7af5-4c22-9821-9056ad487bac | jumpserver-devops-image | 0 | active |
* P! E! _+ T3 }- D! u F m| 3baacc69-a3ba-4564-a8eb-f8df1a1b0abf | CentOS-7.9-devops-LVM-20230913.qcow2 | 1 | deleted |: Y9 h/ t/ M) i- Q* b" S$ Q% y
| 45df1377-8433-4813-9c71-e80b96304bf8 | CentOS7-9-devops-LVM-20230913.qcow2 | 1 | deleted |
' P& Q. c9 s6 ?3 y3 A- T| 5e673d73-aced-472c-a23c-f64585867438 | CentOS-7.9-devops-LVM-20230913.qcow2-1 | 1 | deleted |1 b& F0 l1 x* L, F' P8 ]& v$ }
| 679a3ad4-7dc3-49bb-9656-bc7d43218184 | centos7.8 | 0 | active |4 w) ?3 y" r7 o2 L0 b; ]
| 7989459f-e632-4f6b-9ac9-47eaa12af32c | CentOS-7.9-devops-LVM-20230913.qcow2-1 | 1 | deleted |1 O' P D- D/ B8 N* C: P
| 7c1c5176-7857-439d-8e2f-2c59dc646ac1 | Centos7_X64_LVM_devops_never_new | 1 | deleted |. E2 `1 {# @7 b9 [0 q% m3 r
| 975ed234-f9a9-4198-a11b-ffb805d544d9 | Centos7_X64_LVM_devops_never_new | 1 | deleted |
3 Z6 a. q7 s! o2 {! a| 97a99e92-6b54-4345-b773-301809758950 | CentOS-7.9-devops-LVM-20230913 | 1 | deleted |$ M3 s# ^/ A8 Q6 o4 t
| 9d3909fc-860a-4bf6-92dc-7ae191f75263 | CentOS-7.9-devops-LVM-20230913.qcow2 | 1 | deleted |1 z. ~5 I$ v8 W
| a78109ca-6ab6-4ed4-95da-6b53c1991235 | CentOS-7.9-devops-LVM-20230913.qcow2 | 1 | deleted |
( l+ } \& h3 l; W7 q& }| acf10e89-5afe-425e-8cd9-ac1009611a6b | CentOS-7.9-devops-LVM-20230913.qcow2 | 1 | deleted |
. C8 ]3 b* Q A% N& \| d47c87f6-309e-4dd4-bafa-1786c420d55a | hak1jx | 1 | deleted |
; K/ K T3 }% D# o+ n0 d; p) }| db22ad95-956a-408b-ae2b-e7ba46aad013 | Centos7_X64_LVM_devops_never_new | 1 | deleted |+ H: d/ U- \9 H; v3 H; Q# [
| e6e2c8ce-ac8f-451a-8f18-c21f753b06d3 | WINSRV_2019_S_64_X_50_X | 1 | deleted |
6 {3 R4 B5 p% C| f311d110-a2eb-4a09-b5f5-71a581a5512e | jumpserver-devops-image-v.1 | 1 | deleted |
5 R3 {; S9 C) G2 T1 k' j" T| f44dad8a-a175-48e5-a272-6716f91b1ce2 | Centos7_X64_LVM_devops_never | 0 | active |$ B% l/ h, i% b' s% X0 Q. L
+--------------------------------------+----------------------------------------+---------+---------+
7 U0 p$ |9 \, e% M) u- C: c21 rows in set (0.00 sec)8 B, x; ]* t6 a( r* }* D! ^: ^1 G% g# G
. M- `2 A6 W: F1 V, z5 }$ j" {glance@172.24.201.253:glance 11:00:48>select id,name,deleted,status from images where id="1e6e2885-7a62-4ecc-a356-06f95baa01b1";
5 ^) x" v! s4 p5 {! Y7 _* E+--------------------------------------+----------------------------------------+---------+--------+
$ ? a& K& n1 J| id | name | deleted | status |
$ }' B! R" a; W+--------------------------------------+----------------------------------------+---------+--------+
5 h, I$ k- ~+ _( s) r) G. z| 1e6e2885-7a62-4ecc-a356-06f95baa01b1 | jumpserver-devops-image-v.2-2021-11-16 | 0 | active |; B, H3 ^% u+ {
+--------------------------------------+----------------------------------------+---------+--------+1 U# k0 Q8 d4 M7 D/ }: N/ T
1 row in set (0.00 sec)0 Q9 B7 L, `% i/ P5 [4 P3 W5 T
) U; B8 {. L+ V/ ? m0 t8 j4 f; Lglance@172.24.201.253:glance 11:01:55> update glance.images set deleted=" 1 " where id="1e6e2885-7a62-4ecc-a356-06f95baa01b1";# |6 r: c l6 E7 O3 U
Query OK, 1 row affected, 1 warning (0.00 sec)
7 U' j* @! l; `; L+ ~: K/ eRows matched: 1 Changed: 1 Warnings: 1( f- o" b; f' y1 T: O. _
! T6 l3 m% n6 U; q i# G$ \" {
glance@172.24.201.253:glance 11:02:26>select id,name,deleted,status from images where id="1e6e2885-7a62-4ecc-a356-06f95baa01b1";
b& f* H# F& g% V0 [+--------------------------------------+----------------------------------------+---------+--------+9 r: l; J% U4 y3 Z
| id | name | deleted | status |* A0 s3 G( W8 _& t/ _; j! C$ K# D1 |
+--------------------------------------+----------------------------------------+---------+--------+
6 N2 Z# v& P; O, X4 m| 1e6e2885-7a62-4ecc-a356-06f95baa01b1 | jumpserver-devops-image-v.2-2021-11-16 | 1 | active |
5 @# L5 h/ \$ Z5 B1 T3 h+--------------------------------------+----------------------------------------+---------+--------+
; u! w' X# ^ b1 row in set (0.00 sec)
. \/ h4 @$ j+ d: W/ B7 q% K6 ?: P3 [2 \ ?" t r- w: f
glance@172.24.201.253:glance 11:02:31>select id,name,deleted,status from images where id="1e6e2885-7a62-4ecc-a356-06f95baa01b1";
1 ]1 k9 F$ P% b+ G1 ^0 N+--------------------------------------+----------------------------------------+---------+--------+% N n u8 Z7 O7 m9 [- q4 Y
| id | name | deleted | status |4 m" W6 _8 y0 p) z/ X
+--------------------------------------+----------------------------------------+---------+--------+) N1 G( N2 N2 x4 D& } B
| 1e6e2885-7a62-4ecc-a356-06f95baa01b1 | jumpserver-devops-image-v.2-2021-11-16 | 1 | active |8 N2 S1 k. v1 C4 S
+--------------------------------------+----------------------------------------+---------+--------+- N3 L, Q: ]5 e& m( W% |
1 row in set (0.00 sec)
; }1 ^5 E% ?5 l" b2 F
% n: R; ] e6 y" hglance@172.24.201.253:glance 11:02:51>
( j% k: w1 V% |7 J- v2 ~* E" R# S, d; Y
再次删除,不在报错。& O& O l: R& U0 n$ c" k
问题解决。
- l. A4 {( @4 m9 L: y, a. R0 q易陆发现9 x# d4 O: S ~
1 Z" Z! G2 _' k( b2 i! |2 A
|
|