|
|
The image cannot be deleted because it is in use through the backend store outside of Glance. (HTTP 409)
( X, U3 H. ?$ c* I( y" q/ ]& l
7 {$ H% s) j" `& D[root@controller01 ~]# openstack image list |grep jumpserver-devops-image-v.2-2021-11-16
[- n Z5 B! A) S4 {" C| 1e6e2885-7a62-4ecc-a356-06f95baa01b1 | jumpserver-devops-image-v.2-2021-11-16 |7 h$ ^% z1 d2 p2 f& B" r" w
[root@controller01 ~]# openstack image - ~, J8 o w' w7 S
delete list save show ) n! g2 i, v( l* T4 y% d1 w
[root@controller01 ~]# openstack image 9 M# ~" l8 q" ]5 R! Z
delete list save show " u& P% U8 m: m9 r
[root@controller01 ~]# openstack image show 1e6e2885-7a62-4ecc-a356-06f95baa01b1 1 x( R8 T+ ^- k1 O3 a0 }
ERROR: openstack _info
+ `" f9 p4 S+ N+ [, A& k[root@controller01 ~]# openstack image show jumpserver-devops-image-v.2-2021-11-16
; S# F3 `2 {, w* t' b& @ERROR: openstack 'Controller' object has no attribute 'resource_class'
$ {& X. @, y1 U, ?& l; ^) W* Z# N& [( r ~2 V/ V! i
6 |- S- d5 I4 m' ?- P7 ^" O
2 T* K0 i+ x. ^0 O& F
[root@controller01 ~]# glance image-show 1e6e2885-7a62-4ecc-a356-06f95baa01b1
2 R) K7 M% r2 G9 x- N. s/ U2 {( B+---------------------+----------------------------------------------------------------------------------+* N- E% U2 R' E/ B
| Property | Value |# D' j2 \2 A) S: {3 n7 X$ k& a. M
+---------------------+----------------------------------------------------------------------------------+; j3 ^3 t; L; O$ n, {
| checksum | None |# ?+ f- V0 N/ f% ?
| container_format | bare |
$ ^% i! A Y n+ |' k- y( a5 A0 E| created_at | 2021-11-16T03:03:33Z |7 F! ^( Q5 l a/ }+ Q
| datastore_name | SATA |! n& y; l. g ~: _
| datastore_uuid | 0f5095d9-9383-4f63-b835-2b0e0f57b7b6 |
& K2 R; v/ J; l- m4 ^| description | None |
. }; p3 f, M8 u0 s& k5 U| direct_url | rbd://d385bef6-6778-43cc-8755-4e1d5ef5485e/SATA/volume-36abe473-8426-4b2d-8e9b- | f$ \% ?* C! e+ |, s* ~
| | 57fe3a24d38d/snap |/ _5 s9 F( W+ o7 d( Q" h
| disk_format | raw |" v" h. L/ e- b# T& b/ d
| hw_qemu_guest_agent | yes |
2 i' z1 _3 y; k, `* u2 |0 x8 W+ H4 N| id | 1e6e2885-7a62-4ecc-a356-06f95baa01b1 |: y$ X# |4 P2 U7 n+ V1 p
| min_disk | 50 |& v5 X) M, \& J/ e
| min_ram | 1024 |; l/ |. E' K. `: t* k2 b
| name | jumpserver-devops-image-v.2-2021-11-16 |
* ~, U; I' g5 `) A) R- ^| original_image_id | 679a3ad4-7dc3-49bb-9656-bc7d43218184 |& T5 L6 w) l4 `/ x! z' Q
| original_image_name | centos7.8 |
7 M& x W% u) m| os_arch | x86_64 |5 X. X9 h! V7 `% U
| os_type | linux |
* x8 K% F0 w o. R; N% y X| os_variant | linux7.8 |
5 |) t' w3 i/ V* E2 S$ E| owner | 6df9e85ed72449adbfb4765467e93b10 |% `+ `# t3 _ z' L- w0 f
| protected | False |
0 @: m5 K$ B- g& j' a| size | 53687091200 |
0 s$ _, b: [" K* w& E: B# ]| status | active |
1 z* g6 j; {6 T# ^% f, ?% Q2 G| support_hypervisor | kvm |
" \6 o. k, ^: k1 n3 h| tags | [] |+ Y+ ^ J! c+ R! N4 k: [( G
| updated_at | 2021-11-26T12:30:02Z |. q" A3 r( r* Y- y: K: ~! a
| user_defined | true |
2 b' S. m2 i, Y| user_id | 1e1454d784f945a69d29bef4c246a28d | T3 v8 y/ |9 ^' q- P- m, U
| virtual_size | None |8 O2 J5 W, y" e- }
| visibility | private |
_1 C- d1 h) z+ F9 `+ S+---------------------+----------------------------------------------------------------------------------+. Q0 I6 n `" ]4 o4 Q
[root@controller01 ~]# rbd ls SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d 6 c" q2 Y" e. t5 p
rbd: error opening pool SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d: (2) No such file or directory& o! X. E* @8 O6 N4 L `
[root@controller01 ~]# rbd info SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d
2 ?, v& n0 M3 z( Orbd image 'volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d':3 E6 ^" x& Y& h2 C: W
size 51200 MB in 12800 objects" X+ z: v6 n3 I
order 22 (4096 kB objects)
) B |; F. h* h5 t& M. H! m+ K block_name_prefix: rbd_data.104966b8b45670 [; W$ s* B# O2 D. t0 D& Q$ V" q; M
format: 27 F0 ~- N0 y/ V' ]# ]0 V/ p D
features: layering
J: J6 ^. v9 n5 I flags: % N6 e. I( u6 ]1 P2 n7 f
[root@controller01 ~]# rbd rm SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d
, o5 v/ V; p, a2023-09-18 10:34:48.482820 7f3cfad08d80 -1 librbd: image has snapshots - not removing5 f' y( r) l/ j! h# C/ c; e. D
Removing image: 0% complete...failed.& y: P) y" x' y3 f1 Z
rbd: image has snapshots - these must be deleted with 'rbd snap purge' before the image can be removed.2 T+ f& z$ Y! @2 L1 w
[root@controller01 ~]# rbd snap purge SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d . V+ Z' b2 m& O8 G0 F
Removing all snapshots: 0% complete...failed.0 z( C2 F7 e2 X/ x
rbd: snapshot 'snap' is protected from removal.* l6 O( Q# |. H" C) d' G( O [& o
[root@controller01 ~]# rbd snap unprotect SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d
1 H* k0 K: R: ~0 H2 S1 krbd: snap name was not specified
7 g# ?) n8 {& b[root@controller01 ~]# rbd snap purge SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d ( b- l* X1 L0 e! U' p) j
Removing all snapshots: 0% complete...failed.
$ q& e- G- k: \4 O5 x5 irbd: snapshot 'snap' is protected from removal.
- `6 O% f$ j% n! X[root@controller01 ~]# rbd snap purge SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d # a) g0 I6 V4 b9 D
Removing all snapshots: 0% complete...failed.: `4 Z: k& \ F2 S5 r6 h/ k
rbd: snapshot 'snap' is protected from removal.
7 P- {) j4 v# l" ^# o6 r+ S[root@controller01 ~]# rbd rm SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d
# M2 |& ], p$ P/ C3 Y5 ]* i2023-09-18 10:36:57.416308 7fc7bf2dcd80 -1 librbd: image has snapshots - not removing
; e+ z5 l; A9 M5 w( c. [Removing image: 0% complete...failed.8 ^2 f( O9 z! z; U
rbd: image has snapshots - these must be deleted with 'rbd snap purge' before the image can be removed.
% {: @- k |$ l- N[root@controller01 ~]# rbd snap purge SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d
# E. u: I6 ~% @: `Removing all snapshots: 0% complete...failed.
' {- t( [3 y3 C7 U8 O" S% Yrbd: snapshot 'snap' is protected from removal.
K" M8 A) I& D; M: d[root@controller01 ~]# rbd snap list SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d 1 H/ c" u9 p" ~
SNAPID NAME SIZE $ o. p% P. I4 s4 [; \
14 snap 51200 MB + }. i+ D! ~$ Y, x0 K) S
[root@controller01 ~]# rbd snap unprotect SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d ; [+ r& M/ a) P w# u
rbd: snap name was not specified+ x- e: O' D' y+ H1 `) ?4 _
[root@controller01 ~]# rbd snap unprotect SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d@snap) U5 C7 b! }8 J5 X6 k, x+ g7 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'
' W0 k5 p3 P2 I( R' u+ @2023-09-18 10:38:16.974815 7fb17b7fe700 -1 librbd::SnapshotUnprotectRequest: encountered error: (16) Device or resource busy
6 U o- N; s/ D" Z2023-09-18 10:38:16.974838 7fb17b7fe700 -1 librbd::SnapshotUnprotectRequest: 0x7fb1b03cc980 should_complete_error: ret_val=-164 p- E% Z) e$ g9 w/ g1 }+ I* u
2023-09-18 10:38:16.975426 7fb17b7fe700 -1 librbd::SnapshotUnprotectRequest: 0x7fb1b03cc980 should_complete_error: ret_val=-160 s0 R" X4 d- [, ?+ u A
rbd: unprotecting snap failed: (16) Device or resource busy
% W9 J* ^) r3 u4 F6 y m$ H. K' j[root@controller01 ~]# rbd snap unprotect SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d@snap! O/ e9 N9 M2 Q$ U% a6 Y. L% q: G" W
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'
2 m7 y# H- C# Q+ B% W" m* g2023-09-18 10:38:20.532836 7ff6f0deb700 -1 librbd::SnapshotUnprotectRequest: encountered error: (16) Device or resource busy R/ Q; ?' p! M, q2 ^ M3 k9 A
2023-09-18 10:38:20.532863 7ff6f0deb700 -1 librbd::SnapshotUnprotectRequest: 0x7ff71a5ae9a0 should_complete_error: ret_val=-161 n& r3 r6 d1 _
2023-09-18 10:38:20.533520 7ff6f0deb700 -1 librbd::SnapshotUnprotectRequest: 0x7ff71a5ae9a0 should_complete_error: ret_val=-16& T$ X" Z# g; }: M% T
rbd: unprotecting snap failed: (16) Device or resource busy( o9 O4 O: t% b1 k
查看rbd的孩子信息：
- \1 i3 Z+ G4 X! h$ O. c+ x* lrbd -p SATA children volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d@snap% _- @2 ~0 |; k7 G5 K3 q
SATA/volume-03e625a4-75ca-4471-8df3-6cb860dc3360
! n! f* s5 E* W& J1 t( g. KSATA/volume-08502b39-0575-4f89-9d21-f708cea65228& L. z, o* ?1 V
SATA/volume-09656839-24e1-4059-8ef5-3435bacb5b60
- R% m% t. k, o/ ~SATA/volume-0a89143a-d525-4081-8930-a18f5b7c630e0 F, }7 D' d* w0 ^. Y
SATA/volume-0c2614a7-dec4-4ad6-8561-11c267fab265
* V ]3 f, r( s8 [# p. [SATA/volume-1002cff5-fbf4-4ff6-8201-c151771339ab
; L: i: _" j& s' v7 t% {SATA/volume-1255044c-cdd3-4de0-b698-29d671af46e0
+ I. H9 A! a, Y; `+ a% U7 s2 NSATA/volume-128008ee-83fa-4786-906b-d8bc12313ba4
' g1 I2 A$ X7 m* u, ySATA/volume-13d2eb3a-7565-4af0-9432-60cc5fc38ea6
1 P$ g; b+ `8 E: p7 \SATA/volume-1455427d-d831-43f9-a7cc-66ede8b7a9ae
- ^$ E3 i% ~8 z8 h# TSATA/volume-1845f299-d9b2-4ea5-af0c-f5780d09fd81* x- S. L' C* ]: b0 f6 h9 M* E9 [6 z ~
SATA/volume-192f787f-0566-43d7-8b9c-7b989619ea481 d* q0 w. G' X0 m( }5 {
SATA/volume-2365120a-18ba-44e9-96c5-6efcc0db3574) Z H4 ]1 o, r X0 }
SATA/volume-276e33f0-3d41-4dc3-ad11-39b1d2314f5d( f% c. v* o' T; \% M( B2 s
SATA/volume-289b83c3-24c1-41e9-b773-b6174c2d895a
8 c+ r# a- o& ~: `6 U6 F' J1 U tSATA/volume-2b14242c-8a9e-4ec2-86bc-e78bf20cf8fa
. |* W3 s3 i- CSATA/volume-2c89db19-f0b7-4864-bbf4-72c6dc4af115
; K- [2 z- K& W7 E% u; PSATA/volume-2e174c85-3977-4f42-9867-60d6bf9d716e
5 s! c' u) P7 w, i0 @SATA/volume-2e732f91-d2e4-4c46-a62f-ed33a008a287. o+ A" s$ V9 q( B. L1 w- S) P4 R
SATA/volume-2f3ca82d-c208-4253-8581-53bf0c11d504
" q. W% ~- V7 S- _& _SATA/volume-31a011dd-a39b-463d-a60b-904c018af283& T9 m! K1 R/ Z0 }% |4 C3 r
SATA/volume-340a710f-7ad5-47dd-bd80-afa61ac22aa3
! U, l. W# R9 u1 R/ ~SATA/volume-369bf7da-7948-4963-a887-d47cc21919b1* i8 R: Z& f2 [, w% S' b
SATA/volume-3a0f59a2-7e48-47c0-bc5c-654fc55b2951+ x0 }0 `) D1 t; n# V% _4 j
SATA/volume-3b8361f9-a860-41b8-b430-ce5a52433fcd
3 B& ?5 K' H1 D: ~SATA/volume-42acbb21-ba7c-4112-9c18-0846b21f526a0 m) o2 V# r; y: t6 b
SATA/volume-4aa7702e-6c2e-48c1-a4fa-e5c9cb844fc3
& a6 Z; U1 }' z1 [" |/ i3 TSATA/volume-4e6bc42a-9ec1-4c25-bf34-acd1618f2668& ]2 f' `# B! H3 P; p, \' T
SATA/volume-5382ae5a-c63e-482b-9e9a-e6ca3890ef54
/ H* O; w4 s" y9 z: z; ]SATA/volume-5be35014-a23d-4c91-a5f1-922464b8c8c2+ w7 {& I0 g! @$ ^$ B& O
SATA/volume-5d5a980b-29ac-4ce8-919a-4bc8c38a6e999 h( C$ Q. E! J. t& q0 e& |
SATA/volume-5e7efeb2-7683-469f-8618-a8aca40d63b9
0 w. g/ V% k8 r4 E7 E, x y, xSATA/volume-60ad0f73-8f19-4686-98d4-f92c16d4a8906 e) \% [# N- U8 o) m
SATA/volume-6339e354-7242-4fdc-a2cf-eac40bbbf12b
- }8 N( Q2 I8 g1 k6 x/ s; ~SATA/volume-6b569b01-734d-4d5b-9538-69f8e95471a10 ^+ r. J$ U$ L& C1 |1 K% d6 \9 n
SATA/volume-6ce2e030-c7ad-4e8b-aaf0-a44834bf378c5 y% t( b0 j, N. [& H- P& |4 C, D
SATA/volume-74d22fe0-be8d-40d8-b1b5-0a07d7c35491' C! A5 C5 c7 k* S1 u% {
SATA/volume-769c181d-05e8-46f9-90fe-35dcfea90ac3
6 r6 R6 A3 F8 _3 b: |5 ^SATA/volume-76ebcff2-a0cf-4705-9177-7a8e8b345223
: o6 @7 S9 l% y, h3 \SATA/volume-822edf5c-7fab-44a2-bda1-c9cb5c04a6cb/ F* I: {( x6 }, u
SATA/volume-862d806d-3643-4323-bf07-5ebb5a397fe4
0 h3 k5 a& Z# v) p0 ? qSATA/volume-874b7f86-c5ea-435a-ad2d-746f207bb39c3 C( F6 A- O6 @0 L- H
SATA/volume-87da9c05-26c5-4b5f-88d8-a881366f7f85% r4 a0 e% F7 s; R1 H
SATA/volume-8b061aaa-985c-4304-99eb-5ec89eb37e772 z& ]1 M, t6 \ N m* }9 r1 ^
SATA/volume-8fff319f-f267-4bcb-92f3-e1b91337116c# D3 i( h8 @" t' C3 T- j3 `5 y
SATA/volume-971c27ba-b8a9-4f91-8ab0-df014f4af37f2 p: {( {# V2 h1 P* Z: [
SATA/volume-9c1646ad-c162-4671-bc5a-727e3fe0224a' O. x2 a) i: l: g" S
SATA/volume-a11c1c79-4595-4c9a-8264-c7cdab5a8725/ _, N2 J" L- R* w n
SATA/volume-a79319d7-24af-46cd-93cf-5254f197e2b1' ]& M" f- m% u6 u
SATA/volume-a84d252b-59b8-4c49-a3d1-3298581a20dd
2 M; Y# m9 r) ?( v& jSATA/volume-afabb05c-220e-4c53-983a-416fdf9c6ef0
6 Q8 v: n$ j: J: q& Y' t8 a3 ASATA/volume-b0a7304b-e8a2-4f35-b147-21f71e85177c6 K6 p0 Z. ^& e, R* J
SATA/volume-b557dcfa-623a-4a7f-9bcd-2e66172965eb
6 l) a$ W) @9 {3 ?& X* |SATA/volume-b71c4975-5c12-4a37-a587-98fd503fbb35
6 \- w& f, }9 c& S& d" v- wSATA/volume-c6662572-7d5d-48bf-ac78-9752c76c7f23
2 W5 [- |% M/ V7 }2 D! ?8 g2 ^SATA/volume-cfeb4dc9-39e6-457b-961a-fce016ab5e35
' f% z- k5 b8 g% ]8 Y b1 H% FSATA/volume-d1f8d950-28aa-435b-8653-c778edecd6de
9 k" E/ F* t: I. \/ m# D0 [' CSATA/volume-d2faedf9-6912-4faf-869b-32f40cd2d82d
$ d4 x. k* D* ^$ `. h" C4 BSATA/volume-d44e9131-a02f-42bc-9bce-71cc88a4fee27 u2 B+ K. v: _; R1 R$ c
SATA/volume-da14a752-20fc-4e75-8a19-67b7ce88616f4 g! L. x* q6 b$ r0 H& B' z& X
SATA/volume-dabd3f00-16ea-4de9-9f1e-db9698fe317b
/ [; b. p: W" @0 E7 |7 l3 l JSATA/volume-e7fea8aa-730c-4d51-8ae5-5dbc30b25d557 ?' L2 X" e( q6 k4 Q: [
SATA/volume-e947d90c-8c7c-4153-91a3-0192be459501
. V3 O- ~2 B M9 O" \. E' } iSATA/volume-eab7eb4f-542b-4560-8a10-f002e92dcf78
3 k$ }0 A' X7 E6 Y9 f5 ESATA/volume-ebbca357-ccbf-470b-8a25-9f3fbb9ad8d6! ]4 J# Z$ {2 w/ _
SATA/volume-ec0ae2a0-d4f8-433e-8c5f-fdf009b60fce
: g; W. l" a) DSATA/volume-eee596b8-71e1-4acd-b241-9d1420a71eee4 v! g5 O5 v. N; r6 L
SATA/volume-fad889ce-9ade-4877-863b-8b883597764e* A' _3 c7 K! H7 X9 n
上面的方式还是无法解决：
b r# }3 J. Y0 B( X8 \
" ]/ K; I3 j6 ]采取更新数据的方式解决下：$ N' a# T. B8 y& E
Enter password:$ x- Y) @& b+ Q% U1 W( I
Welcome to the MariaDB monitor. Commands end with ; or \g.4 b0 p( g5 B& m2 G# R4 f- {
Your MariaDB connection id is 15183281
4 n3 ?' c' X; }Server version: 10.2.24-MariaDB-log MariaDB Server q+ ~& A2 L/ E' K* J) } i
5 r+ F* w7 ~, Z2 a% l6 E' RCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
& U, Q# a s, G* ^# n+ w6 X' U
F* {( |) u5 cType 'help;' or '\h' for help. Type '\c' to clear the current input statement.
6 \1 F* N, ?; r9 l4 M" o; h% a+ R5 b5 p
glance@172.24.201.253:glance 11:00:04>show databases;! R" ^3 I$ A. J7 t( J6 i) a& g
+--------------------+
4 S! X: Q4 f6 Y7 U* K0 d| Database |6 p. l# H, F3 V. Q- o
+--------------------+
% r+ }0 N( @* k; [. @6 G5 T| glance |
2 U2 o: h2 m S| information_schema |5 z2 a# e) a" K% a7 G
| test |
7 X& d. ~( X9 L7 H B* V+--------------------+3 t) N: n( J$ ~8 G9 n
3 rows in set (0.00 sec)
! h" t# K6 Z; t+ N, r
, ?) r- n' Z* S$ q: |6 O* |3 tglance@172.24.201.253:glance 11:00:09>use glance% a* Q$ a+ k' W. f% z6 Y& S
Database changed
$ K Q% ]7 S7 d5 Mglance@172.24.201.253:glance 11:00:15>select id,name,deleted,status from images;. A6 m0 |" u3 H. B% T( l
+--------------------------------------+----------------------------------------+---------+---------+
+ Q# O) {2 h& s8 c4 o3 N: t| id | name | deleted | status |' r& @. N- `# f8 o
+--------------------------------------+----------------------------------------+---------+---------+
. R/ S! R# s1 P; M6 {8 N- q4 y| 059d4ab8-642b-4dff-ab5a-e724dca27a2d | WINSRV_2019_S_64_X_50_X | 1 | deleted |: v. }1 x3 g* s$ }* R. B
| 0b989ee4-0d59-4892-96eb-0d35ed5451b7 | CentOS-7.9-devops-LVM-20230913.qcow2 | 0 | active |
: a& S A4 ?8 o3 ^| 1d806e6b-df9e-4320-b267-218aae22ec6d | WINSRV_2019_S_64_X_50_X | 0 | active |
$ Y, V( o" T8 B8 s- Z+ s| 1e6e2885-7a62-4ecc-a356-06f95baa01b1 | jumpserver-devops-image-v.2-2021-11-16 | 0 | active |
- R" H# e8 W8 L7 }( Z| 1f2b90f6-7af5-4c22-9821-9056ad487bac | jumpserver-devops-image | 0 | active |7 R1 F5 ]4 n5 ^ H0 J$ X% K
| 3baacc69-a3ba-4564-a8eb-f8df1a1b0abf | CentOS-7.9-devops-LVM-20230913.qcow2 | 1 | deleted |
, ^$ Y, ?9 X& q" @; T2 a+ b| 45df1377-8433-4813-9c71-e80b96304bf8 | CentOS7-9-devops-LVM-20230913.qcow2 | 1 | deleted |6 V% T5 m# g" v% \
| 5e673d73-aced-472c-a23c-f64585867438 | CentOS-7.9-devops-LVM-20230913.qcow2-1 | 1 | deleted |) [# U+ _8 z& D! q
| 679a3ad4-7dc3-49bb-9656-bc7d43218184 | centos7.8 | 0 | active |/ b6 H0 @7 j$ n Y3 K- u$ \9 ~
| 7989459f-e632-4f6b-9ac9-47eaa12af32c | CentOS-7.9-devops-LVM-20230913.qcow2-1 | 1 | deleted | T9 c! m* a8 P7 c* b
| 7c1c5176-7857-439d-8e2f-2c59dc646ac1 | Centos7_X64_LVM_devops_never_new | 1 | deleted |
& u! C+ l |7 Z4 c| 975ed234-f9a9-4198-a11b-ffb805d544d9 | Centos7_X64_LVM_devops_never_new | 1 | deleted |
( {4 K+ p3 t2 l* t) a$ l+ o: R| 97a99e92-6b54-4345-b773-301809758950 | CentOS-7.9-devops-LVM-20230913 | 1 | deleted |
) _7 t+ E( w) F# T; `0 e1 M/ g| 9d3909fc-860a-4bf6-92dc-7ae191f75263 | CentOS-7.9-devops-LVM-20230913.qcow2 | 1 | deleted |) g. N- I, s" O5 ^" d- d( x7 T
| a78109ca-6ab6-4ed4-95da-6b53c1991235 | CentOS-7.9-devops-LVM-20230913.qcow2 | 1 | deleted |- e. t v u* h b$ K3 |7 N G
| acf10e89-5afe-425e-8cd9-ac1009611a6b | CentOS-7.9-devops-LVM-20230913.qcow2 | 1 | deleted |
" M0 J$ O9 @4 `+ L, ~" C1 c" |7 ^| d47c87f6-309e-4dd4-bafa-1786c420d55a | hak1jx | 1 | deleted |
5 }/ g7 P# @. A| db22ad95-956a-408b-ae2b-e7ba46aad013 | Centos7_X64_LVM_devops_never_new | 1 | deleted |
! ^) L8 H1 A9 a }2 j" x| e6e2c8ce-ac8f-451a-8f18-c21f753b06d3 | WINSRV_2019_S_64_X_50_X | 1 | deleted |2 E/ K3 g. }1 v5 T8 o8 z/ M* {
| f311d110-a2eb-4a09-b5f5-71a581a5512e | jumpserver-devops-image-v.1 | 1 | deleted |: J. U4 N# f' ~5 d/ h
| f44dad8a-a175-48e5-a272-6716f91b1ce2 | Centos7_X64_LVM_devops_never | 0 | active |
X7 n9 ]; x$ X+--------------------------------------+----------------------------------------+---------+---------+
?2 t& C- P3 c$ l, x21 rows in set (0.00 sec); e- l/ g+ D+ h. [; M+ d
8 c1 C4 q# C3 Z7 P7 i: }
glance@172.24.201.253:glance 11:00:48>select id,name,deleted,status from images where id="1e6e2885-7a62-4ecc-a356-06f95baa01b1";5 H2 O8 z3 L' D, M& W( a
+--------------------------------------+----------------------------------------+---------+--------+
E4 F: }) A2 c# n/ H| id | name | deleted | status |
! [3 c7 G4 O% \& S* a+--------------------------------------+----------------------------------------+---------+--------+* S5 ^0 T% D* J1 M7 u- n' u
| 1e6e2885-7a62-4ecc-a356-06f95baa01b1 | jumpserver-devops-image-v.2-2021-11-16 | 0 | active |
. }6 U) N. _/ D$ n+--------------------------------------+----------------------------------------+---------+--------++ Y, p# k) a6 r/ Y+ R9 @- I) T
1 row in set (0.00 sec)
: X+ Z. {8 @8 p+ n# I2 z( d
& a5 h: f) r4 R$ nglance@172.24.201.253:glance 11:01:55> update glance.images set deleted=" 1 " where id="1e6e2885-7a62-4ecc-a356-06f95baa01b1";9 k1 k, U6 S4 w6 _/ K0 k
Query OK, 1 row affected, 1 warning (0.00 sec)
2 R0 H( |! s: ]9 K6 dRows matched: 1 Changed: 1 Warnings: 1
( U& N# i0 Y0 \2 W0 _
+ S% `) l9 w% e1 J$ S$ m4 aglance@172.24.201.253:glance 11:02:26>select id,name,deleted,status from images where id="1e6e2885-7a62-4ecc-a356-06f95baa01b1";
; o5 K% f0 ], a$ l; x3 `4 s+--------------------------------------+----------------------------------------+---------+--------+
p1 i, d: u! b6 M; i| id | name | deleted | status |: D5 ?+ i# q) U3 E' S3 }, z
+--------------------------------------+----------------------------------------+---------+--------+
3 }4 r; Q9 c: E: g! S3 L+ || 1e6e2885-7a62-4ecc-a356-06f95baa01b1 | jumpserver-devops-image-v.2-2021-11-16 | 1 | active |$ h9 O- C! O4 |: s1 t0 _$ f& X* q
+--------------------------------------+----------------------------------------+---------+--------+/ ?9 K6 q6 ^; M4 i& D, x1 v
1 row in set (0.00 sec)
' I3 w1 H% u, i( h( O
( h+ C, y5 e8 Lglance@172.24.201.253:glance 11:02:31>select id,name,deleted,status from images where id="1e6e2885-7a62-4ecc-a356-06f95baa01b1";" Q6 P" V4 q# r& k3 t$ e
+--------------------------------------+----------------------------------------+---------+--------+
4 M. r1 z- u: e7 A# V1 o& Y+ T| id | name | deleted | status |
+ x0 P7 g$ m, K( u* q% K, f+--------------------------------------+----------------------------------------+---------+--------+
6 `+ L4 A' i" J7 g# A1 x; k9 P% p| 1e6e2885-7a62-4ecc-a356-06f95baa01b1 | jumpserver-devops-image-v.2-2021-11-16 | 1 | active |
( }3 a; N- v) f& D! n+--------------------------------------+----------------------------------------+---------+--------+# B% ~+ A4 N8 O
1 row in set (0.00 sec)
) r% k' s- K* ^; o& \6 K9 w# s s' [& q) u. W8 h
glance@172.24.201.253:glance 11:02:51>( I3 `- x, C* C8 J k- J
( y+ U' L7 F# Z1 A3 \
再次删除，不在报错。
2 v+ h L) X- t* U4 a0 V) d$ b问题解决。0 {4 x" u, P7 Z7 @6 x; g! u: Z# c
易陆发现
$ E7 {. r( |* Y4 g! h/ f: i+ S% a% Q6 q# A
|
|
发表于 2023-9-18 10:19:07