|
|
The image cannot be deleted because it is in use through the backend store outside of Glance. (HTTP 409)
0 e( b5 d2 w O
: T" W7 `; ^; ][root@controller01 ~]# openstack image list |grep jumpserver-devops-image-v.2-2021-11-16
, x) L' p+ L8 t5 g| 1e6e2885-7a62-4ecc-a356-06f95baa01b1 | jumpserver-devops-image-v.2-2021-11-16 |
; A0 a- H! _$ X4 b0 b# U[root@controller01 ~]# openstack image
& I3 P) H, P& Q9 A! s9 @- ^4 Z( F0 H& qdelete list save show ) n0 x: k+ u" z5 S9 f; T m
[root@controller01 ~]# openstack image ( V0 k5 F: r. q
delete list save show 8 w. C( j' k/ m! a! k' t% @$ \
[root@controller01 ~]# openstack image show 1e6e2885-7a62-4ecc-a356-06f95baa01b1
; i% N2 f0 g3 R) P+ ^& s9 v, lERROR: openstack _info
5 t# r7 H+ {; B, \, a' A[root@controller01 ~]# openstack image show jumpserver-devops-image-v.2-2021-11-16
; X5 x. S, Z7 p8 M5 IERROR: openstack 'Controller' object has no attribute 'resource_class'
# q9 l% u* u" m. k
; G. k9 E$ H* s2 T
2 Z: ?9 C& a. [3 Y5 T- j5 N9 e6 t" s% @: [: M: @! \% ?& V8 S
[root@controller01 ~]# glance image-show 1e6e2885-7a62-4ecc-a356-06f95baa01b1 # C# _' A+ N0 w8 ]1 F3 ?+ ?
+---------------------+----------------------------------------------------------------------------------+
2 ]* N# [& X: X" n- c) i| Property | Value |- Q+ r1 Q! X) F M+ r1 f
+---------------------+----------------------------------------------------------------------------------+* M3 J9 V/ T- x1 B
| checksum | None |
' X4 d; s) T5 G7 r% S. u+ {| container_format | bare |
; J: e% p5 E* @" A4 R% E| created_at | 2021-11-16T03:03:33Z |
. u' L1 I4 I! M* k| datastore_name | SATA |: j7 T N# {4 R- h. g! @
| datastore_uuid | 0f5095d9-9383-4f63-b835-2b0e0f57b7b6 |
! l! L# y$ `* F" ^2 j/ m| description | None |
0 e. T3 C$ c+ u, T0 N& J. a| direct_url | rbd://d385bef6-6778-43cc-8755-4e1d5ef5485e/SATA/volume-36abe473-8426-4b2d-8e9b- |
# o! [/ \/ z) t+ Z% f3 q B4 y| | 57fe3a24d38d/snap |# d& Q: V) ~/ H2 l( X
| disk_format | raw |
8 v& P' X" `/ |) u& K| hw_qemu_guest_agent | yes |
l6 b( H+ Y& }: a| id | 1e6e2885-7a62-4ecc-a356-06f95baa01b1 |, @$ r# a! p; ^ [
| min_disk | 50 |
: J8 {8 K3 E# K) V: ]% U8 Z9 h4 ~9 \| min_ram | 1024 |
/ L- h/ } }3 G| name | jumpserver-devops-image-v.2-2021-11-16 |/ }3 |. h1 k% c: ?/ N
| original_image_id | 679a3ad4-7dc3-49bb-9656-bc7d43218184 |
0 f) a' ^/ R' |; {& @, F" r1 v: k| original_image_name | centos7.8 |0 Z6 `6 Y# w) `2 b/ r4 t8 U
| os_arch | x86_64 |- L0 @9 G: U! f5 a
| os_type | linux |) {/ P) j! }. P! ]
| os_variant | linux7.8 |7 Z* ?7 O+ M0 g+ T; S r; s) M
| owner | 6df9e85ed72449adbfb4765467e93b10 |
7 ^* m! l$ I+ O, Q6 x| protected | False |
9 D) \( M! b, E+ D( }: ^$ g; Q7 @| size | 53687091200 |$ @- @' k6 r1 H+ Y, e9 _0 y
| status | active |" v+ W) x+ {1 t7 u* E3 u
| support_hypervisor | kvm |
, X+ H( ~9 F* z# n| tags | [] |
0 l4 ?3 {. z: e; u3 @- {$ }8 S. N& H| updated_at | 2021-11-26T12:30:02Z |8 m- h1 h" g! d
| user_defined | true |+ i8 g/ ~. n$ a( X/ q9 `; k
| user_id | 1e1454d784f945a69d29bef4c246a28d |
& m& d- x* V3 N) L$ A9 w| virtual_size | None |3 p k- }/ R6 V5 ?2 S
| visibility | private |, ~1 V! s! ]$ g6 w5 b
+---------------------+----------------------------------------------------------------------------------+
8 u/ z: j$ |0 {5 l4 I[root@controller01 ~]# rbd ls SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d
) q6 f6 g2 j0 T% A! Y5 S' O- Nrbd: error opening pool SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d: (2) No such file or directory
2 L- ?0 ~; ^* d4 O9 D' a; \[root@controller01 ~]# rbd info SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d ) H# G4 u& L6 a: Z4 r1 Q: D! ~
rbd image 'volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d':$ W* [+ z0 P2 B& ^! D3 f
size 51200 MB in 12800 objects! Z3 o) \7 I" x; ~* ?
order 22 (4096 kB objects)
- O! L6 e0 U$ O7 v. y block_name_prefix: rbd_data.104966b8b45677 H+ n9 c& _" O. [- q
format: 2
8 [% y j. W+ ]8 I% I- p features: layering
% ?# w1 |3 \% l( [: [ flags: / Z2 B$ a$ o p5 E% Q8 N. E; M
[root@controller01 ~]# rbd rm SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d # N4 B1 V$ L& [- T& l6 v
2023-09-18 10:34:48.482820 7f3cfad08d80 -1 librbd: image has snapshots - not removing( |% g. i* R0 s K C! D6 R" _
Removing image: 0% complete...failed.
2 W2 g& c2 {' A; _rbd: image has snapshots - these must be deleted with 'rbd snap purge' before the image can be removed." _$ w+ L5 f* I0 Y5 X! n5 U" E
[root@controller01 ~]# rbd snap purge SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d 0 |8 O4 F' L1 E. z/ F1 D0 Y
Removing all snapshots: 0% complete...failed.5 k4 h+ C: k m# U% h; o
rbd: snapshot 'snap' is protected from removal.
5 J* N. ^1 }3 y3 z[root@controller01 ~]# rbd snap unprotect SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d
% A+ [; f4 T# A+ w* a7 f) Z$ n2 Prbd: snap name was not specified2 h: j8 N6 n+ P0 q* j
[root@controller01 ~]# rbd snap purge SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d , l% J: t) c% A" [4 e4 l, y f9 i' ?
Removing all snapshots: 0% complete...failed.. N% |+ O* X% m1 Z* i
rbd: snapshot 'snap' is protected from removal.
, P7 ]2 }8 A7 U9 A- } M[root@controller01 ~]# rbd snap purge SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d
% S4 \6 n7 Z' W' I+ M! g9 P3 v0 D w4 TRemoving all snapshots: 0% complete...failed.2 T% m4 L) u9 O1 J/ ~: F
rbd: snapshot 'snap' is protected from removal.4 ~4 `7 o: _% Y- s! X
[root@controller01 ~]# rbd rm SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d 6 h/ V, c! x7 F# {5 j* X1 c( `
2023-09-18 10:36:57.416308 7fc7bf2dcd80 -1 librbd: image has snapshots - not removing
+ i# j' m. a+ a# \Removing image: 0% complete...failed.
3 z. J ~1 |+ z2 orbd: image has snapshots - these must be deleted with 'rbd snap purge' before the image can be removed.
- A) G" }4 t: Y" G) W( _[root@controller01 ~]# rbd snap purge SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d ! t# r7 d4 [$ }. T& d$ G
Removing all snapshots: 0% complete...failed.# ^% ^5 }! s/ N$ a4 _# B+ x+ ]
rbd: snapshot 'snap' is protected from removal.0 E' g5 I9 S5 Q1 E2 Y# G! n# A
[root@controller01 ~]# rbd snap list SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d 2 c# t0 |1 [3 _4 v, P/ |4 k
SNAPID NAME SIZE , z7 X3 g6 _, k: U& t- L
14 snap 51200 MB 8 x1 G- C, K7 q! k# C! g
[root@controller01 ~]# rbd snap unprotect SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d
) M* [3 E- U! jrbd: snap name was not specified
) `1 t1 M' c( c0 Z' k[root@controller01 ~]# rbd snap unprotect SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d@snap
2 c+ t. x; L$ a+ L& [ o2023-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'' l# d9 ?8 u9 @* @
2023-09-18 10:38:16.974815 7fb17b7fe700 -1 librbd::SnapshotUnprotectRequest: encountered error: (16) Device or resource busy
5 `8 h: f8 u$ x2023-09-18 10:38:16.974838 7fb17b7fe700 -1 librbd::SnapshotUnprotectRequest: 0x7fb1b03cc980 should_complete_error: ret_val=-16
( ]; ~' n" m! |2023-09-18 10:38:16.975426 7fb17b7fe700 -1 librbd::SnapshotUnprotectRequest: 0x7fb1b03cc980 should_complete_error: ret_val=-16
* m- ?/ c- J- d: A+ u# p, I; I Orbd: unprotecting snap failed: (16) Device or resource busy
/ ~+ h8 t9 [9 h3 h! Z6 f[root@controller01 ~]# rbd snap unprotect SATA/volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d@snap
) s5 O3 J; C9 p2023-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'
) y; r) x9 l u( b+ m; b2023-09-18 10:38:20.532836 7ff6f0deb700 -1 librbd::SnapshotUnprotectRequest: encountered error: (16) Device or resource busy
2 Z3 m9 T$ d9 A% @; Z2023-09-18 10:38:20.532863 7ff6f0deb700 -1 librbd::SnapshotUnprotectRequest: 0x7ff71a5ae9a0 should_complete_error: ret_val=-16 @( w3 |* ~! e" S7 J
2023-09-18 10:38:20.533520 7ff6f0deb700 -1 librbd::SnapshotUnprotectRequest: 0x7ff71a5ae9a0 should_complete_error: ret_val=-16) k6 h0 P, X0 P i2 T( p: W7 |
rbd: unprotecting snap failed: (16) Device or resource busy
9 \; `5 O7 H. ]! U2 | {& I; A查看rbd的孩子信息：
2 a1 D8 k$ G; N% J$ [! Arbd -p SATA children volume-36abe473-8426-4b2d-8e9b-57fe3a24d38d@snap$ k) N+ K& }) H/ q0 {5 `
SATA/volume-03e625a4-75ca-4471-8df3-6cb860dc3360; t! W( C. k1 {& v! B
SATA/volume-08502b39-0575-4f89-9d21-f708cea65228
+ T# z/ v# Y. R: N7 d$ T, @* iSATA/volume-09656839-24e1-4059-8ef5-3435bacb5b60
. y( k y4 r; O3 f6 s: Q: _SATA/volume-0a89143a-d525-4081-8930-a18f5b7c630e1 J5 ~6 N# [& K% R, p( x+ d
SATA/volume-0c2614a7-dec4-4ad6-8561-11c267fab265
, e* G. b1 T `; _2 BSATA/volume-1002cff5-fbf4-4ff6-8201-c151771339ab: @) p% ^) o9 f$ q; `$ a
SATA/volume-1255044c-cdd3-4de0-b698-29d671af46e08 b9 m3 t& }; `- [+ a/ J
SATA/volume-128008ee-83fa-4786-906b-d8bc12313ba4* D: G, {( N6 ?; ^5 B
SATA/volume-13d2eb3a-7565-4af0-9432-60cc5fc38ea6# |5 H1 u6 H8 m. a& a0 y6 g7 @
SATA/volume-1455427d-d831-43f9-a7cc-66ede8b7a9ae2 q3 v6 _: ~2 m+ m* \
SATA/volume-1845f299-d9b2-4ea5-af0c-f5780d09fd81* s* ?% \7 Y6 x: E
SATA/volume-192f787f-0566-43d7-8b9c-7b989619ea48
2 S' H# a' s% _3 Q# Q: U' DSATA/volume-2365120a-18ba-44e9-96c5-6efcc0db3574
' Q. B7 B4 A1 T6 HSATA/volume-276e33f0-3d41-4dc3-ad11-39b1d2314f5d
1 h; V( Y5 z# @SATA/volume-289b83c3-24c1-41e9-b773-b6174c2d895a1 W0 `4 S5 c0 b, p/ V5 |% |/ _
SATA/volume-2b14242c-8a9e-4ec2-86bc-e78bf20cf8fa( Z7 {; i' e$ K1 B5 k# E$ A
SATA/volume-2c89db19-f0b7-4864-bbf4-72c6dc4af115
& A$ G# }. R" z$ K2 ?8 eSATA/volume-2e174c85-3977-4f42-9867-60d6bf9d716e6 V6 Z# b4 _2 j8 b6 A4 C* H+ H
SATA/volume-2e732f91-d2e4-4c46-a62f-ed33a008a2872 M. e) e# I2 G6 T
SATA/volume-2f3ca82d-c208-4253-8581-53bf0c11d504 B( C. }) R2 [; H9 f0 B/ I) s
SATA/volume-31a011dd-a39b-463d-a60b-904c018af283
' B4 h6 `3 @- O! {9 ? ]SATA/volume-340a710f-7ad5-47dd-bd80-afa61ac22aa3
5 |' d, S+ W* `2 h$ F7 O$ bSATA/volume-369bf7da-7948-4963-a887-d47cc21919b1
- x$ D$ s* m" e6 ~: [' eSATA/volume-3a0f59a2-7e48-47c0-bc5c-654fc55b29517 T& h4 M: V# w9 N3 r% b4 u* b3 I
SATA/volume-3b8361f9-a860-41b8-b430-ce5a52433fcd6 i5 q! c0 {2 r" k
SATA/volume-42acbb21-ba7c-4112-9c18-0846b21f526a
5 k/ r" e% k" F4 `SATA/volume-4aa7702e-6c2e-48c1-a4fa-e5c9cb844fc33 S7 l# ]1 G9 @' x" R. _
SATA/volume-4e6bc42a-9ec1-4c25-bf34-acd1618f2668
5 Y) B9 j0 G! D) nSATA/volume-5382ae5a-c63e-482b-9e9a-e6ca3890ef54% Z2 l( A+ R8 F/ q2 w7 |5 _' }
SATA/volume-5be35014-a23d-4c91-a5f1-922464b8c8c2
' D* }; X, |: ^. A1 H. k) oSATA/volume-5d5a980b-29ac-4ce8-919a-4bc8c38a6e99% P. Z; k; W3 P, q- U1 f# z. z
SATA/volume-5e7efeb2-7683-469f-8618-a8aca40d63b98 G* c+ V- ~' S' M' u& J3 y% e1 b
SATA/volume-60ad0f73-8f19-4686-98d4-f92c16d4a890
8 t8 M( j* u. g+ ]; X2 fSATA/volume-6339e354-7242-4fdc-a2cf-eac40bbbf12b6 H0 z# g$ D E( J
SATA/volume-6b569b01-734d-4d5b-9538-69f8e95471a1# G v; Z8 |6 I; D: x3 D- w2 p: m
SATA/volume-6ce2e030-c7ad-4e8b-aaf0-a44834bf378c$ v9 j" {, A7 }1 K6 v* U- w
SATA/volume-74d22fe0-be8d-40d8-b1b5-0a07d7c35491
) b% b- ^* t9 q+ N& n0 y+ w# ESATA/volume-769c181d-05e8-46f9-90fe-35dcfea90ac3$ V* I, Z1 C; N* r
SATA/volume-76ebcff2-a0cf-4705-9177-7a8e8b3452239 b" U, n* k6 I
SATA/volume-822edf5c-7fab-44a2-bda1-c9cb5c04a6cb) D& m8 I0 D$ a- P" U) _) L
SATA/volume-862d806d-3643-4323-bf07-5ebb5a397fe4
1 t( z1 Y! u! m- K. W* n6 X( W M3 @SATA/volume-874b7f86-c5ea-435a-ad2d-746f207bb39c% O& ?; W W& G& x g9 l
SATA/volume-87da9c05-26c5-4b5f-88d8-a881366f7f85, @& g9 r# ~6 \3 ~) ?9 l+ ]" I# a
SATA/volume-8b061aaa-985c-4304-99eb-5ec89eb37e77
4 N( f5 s; L( }SATA/volume-8fff319f-f267-4bcb-92f3-e1b91337116c
: _& T) |' T% L$ B9 x9 ] ?" S7 PSATA/volume-971c27ba-b8a9-4f91-8ab0-df014f4af37f8 D* y- y3 u2 I: U6 p
SATA/volume-9c1646ad-c162-4671-bc5a-727e3fe0224a! \! S8 j. y% u) |0 w) i% u; p
SATA/volume-a11c1c79-4595-4c9a-8264-c7cdab5a87251 C& i+ ?6 S. E; Q
SATA/volume-a79319d7-24af-46cd-93cf-5254f197e2b1
* b! o5 h+ @& Q8 [7 R* v& L( O+ ^SATA/volume-a84d252b-59b8-4c49-a3d1-3298581a20dd
0 K( K! r5 r/ P) W* M3 J- CSATA/volume-afabb05c-220e-4c53-983a-416fdf9c6ef0 f0 n, ]# b8 c; F9 J, U0 j _
SATA/volume-b0a7304b-e8a2-4f35-b147-21f71e85177c) A3 `! @1 G5 }& n
SATA/volume-b557dcfa-623a-4a7f-9bcd-2e66172965eb
) n; T* }" |* K/ }" ~0 gSATA/volume-b71c4975-5c12-4a37-a587-98fd503fbb353 d. ?, B' h3 L$ [: A: k
SATA/volume-c6662572-7d5d-48bf-ac78-9752c76c7f23. P9 v. h# Y$ L% b) p
SATA/volume-cfeb4dc9-39e6-457b-961a-fce016ab5e35/ c N+ u, [3 _, Y5 w9 V+ T
SATA/volume-d1f8d950-28aa-435b-8653-c778edecd6de
+ Y' x! k' {) QSATA/volume-d2faedf9-6912-4faf-869b-32f40cd2d82d
+ }: b" N8 _1 ~8 m: }SATA/volume-d44e9131-a02f-42bc-9bce-71cc88a4fee2
. _, t! Y/ Y( m" B- o" USATA/volume-da14a752-20fc-4e75-8a19-67b7ce88616f/ X0 ], {" V7 U% x7 E" K7 z
SATA/volume-dabd3f00-16ea-4de9-9f1e-db9698fe317b
" H( D' t1 e1 b% x$ MSATA/volume-e7fea8aa-730c-4d51-8ae5-5dbc30b25d55% L% g% b/ ^, `9 l. O
SATA/volume-e947d90c-8c7c-4153-91a3-0192be459501
( y2 f8 ^5 E* e1 n9 X2 B; WSATA/volume-eab7eb4f-542b-4560-8a10-f002e92dcf78# k1 R, S! Z" G m3 }+ v# f
SATA/volume-ebbca357-ccbf-470b-8a25-9f3fbb9ad8d65 b0 n; e1 j* r( Z- x
SATA/volume-ec0ae2a0-d4f8-433e-8c5f-fdf009b60fce+ t4 q/ o" {, t) l6 \, m3 {! T
SATA/volume-eee596b8-71e1-4acd-b241-9d1420a71eee+ z% c) g+ ^+ m
SATA/volume-fad889ce-9ade-4877-863b-8b883597764e
/ T* N4 Z2 T( N, v+ c" s6 o6 |上面的方式还是无法解决：; C L" U/ r% w, W' C; D
! C- t' g7 W3 m* [) }
采取更新数据的方式解决下：1 Z* Y7 D- G. ^0 s$ E4 g
Enter password:: Y: P; D1 B S: a. w/ M
Welcome to the MariaDB monitor. Commands end with ; or \g.' M3 O, a$ f' Q6 t- f
Your MariaDB connection id is 15183281
' B2 P( | |8 z, O! p& a9 z# J6 |Server version: 10.2.24-MariaDB-log MariaDB Server9 V% M( R4 B) M* g
% t6 ], m' \' P5 Q& v! U
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
. C. b A8 M9 Y, y6 N( D
; n3 P" t, m3 H, e4 l# n. @/ P# P* UType 'help;' or '\h' for help. Type '\c' to clear the current input statement., J5 k8 S! A5 [2 C
: C9 w) [0 a3 M% q& o1 mglance@172.24.201.253:glance 11:00:04>show databases;& a% {, Z* D+ |: |) Y, j
+--------------------+
. F0 V2 j# ~* o9 B4 y$ S1 R3 o| Database |3 B |2 q$ n! ? f
+--------------------+1 y0 G) |# K v
| glance |$ B3 r- `# [4 P8 `
| information_schema |! p, }7 ?7 d& K/ @- U
| test |
z l- A! c, g% D+ p+--------------------+
# w ~7 w. M! }5 X- s3 rows in set (0.00 sec)
/ b: i# {9 w% {, I8 V
9 V# ]) O- O5 a8 B$ W. Yglance@172.24.201.253:glance 11:00:09>use glance
6 c, b6 b$ ^$ F; W9 b" D8 H6 a6 w) l YDatabase changed$ F$ {7 Q' W& B3 P
glance@172.24.201.253:glance 11:00:15>select id,name,deleted,status from images;
- ^9 f' }- C) K# M. e+--------------------------------------+----------------------------------------+---------+---------+
, ]/ n7 S* q4 Z| id | name | deleted | status |
& L( i7 [% Z: r6 }- R( L1 C# @9 `+--------------------------------------+----------------------------------------+---------+---------+
' B+ F; F; `5 |/ O% ~0 ?| 059d4ab8-642b-4dff-ab5a-e724dca27a2d | WINSRV_2019_S_64_X_50_X | 1 | deleted |( t% |/ M3 q, d3 ?$ j' p
| 0b989ee4-0d59-4892-96eb-0d35ed5451b7 | CentOS-7.9-devops-LVM-20230913.qcow2 | 0 | active |
/ Q' Y4 {1 _0 g| 1d806e6b-df9e-4320-b267-218aae22ec6d | WINSRV_2019_S_64_X_50_X | 0 | active |
! c9 ]* j7 j r) e! I. Z2 K5 V| 1e6e2885-7a62-4ecc-a356-06f95baa01b1 | jumpserver-devops-image-v.2-2021-11-16 | 0 | active |% e; v# j" s# v9 F" t
| 1f2b90f6-7af5-4c22-9821-9056ad487bac | jumpserver-devops-image | 0 | active |" V, R4 k! q9 l; v
| 3baacc69-a3ba-4564-a8eb-f8df1a1b0abf | CentOS-7.9-devops-LVM-20230913.qcow2 | 1 | deleted |: }6 R5 n- l4 c0 ~( ~: Y9 @6 x
| 45df1377-8433-4813-9c71-e80b96304bf8 | CentOS7-9-devops-LVM-20230913.qcow2 | 1 | deleted |
8 o5 n( P" |9 `, i+ W/ L| 5e673d73-aced-472c-a23c-f64585867438 | CentOS-7.9-devops-LVM-20230913.qcow2-1 | 1 | deleted |, f/ Y- @7 i+ Y$ p* Y% {
| 679a3ad4-7dc3-49bb-9656-bc7d43218184 | centos7.8 | 0 | active |) A! q! ~% Q( Z3 J' [
| 7989459f-e632-4f6b-9ac9-47eaa12af32c | CentOS-7.9-devops-LVM-20230913.qcow2-1 | 1 | deleted |; u% E a8 Z' G
| 7c1c5176-7857-439d-8e2f-2c59dc646ac1 | Centos7_X64_LVM_devops_never_new | 1 | deleted |0 `2 t6 ?1 ]# }& N% l% O
| 975ed234-f9a9-4198-a11b-ffb805d544d9 | Centos7_X64_LVM_devops_never_new | 1 | deleted |3 S! M/ H2 H) C# e3 D8 J" ]
| 97a99e92-6b54-4345-b773-301809758950 | CentOS-7.9-devops-LVM-20230913 | 1 | deleted |
7 F) G$ s( L+ X7 J" p+ O# p| 9d3909fc-860a-4bf6-92dc-7ae191f75263 | CentOS-7.9-devops-LVM-20230913.qcow2 | 1 | deleted |% M/ d, \6 c) ^6 ~( H4 R: L9 l& R, F
| a78109ca-6ab6-4ed4-95da-6b53c1991235 | CentOS-7.9-devops-LVM-20230913.qcow2 | 1 | deleted |
, [1 f8 y& x `) L7 j+ a| acf10e89-5afe-425e-8cd9-ac1009611a6b | CentOS-7.9-devops-LVM-20230913.qcow2 | 1 | deleted |
' R4 ~7 c1 H/ e9 H| d47c87f6-309e-4dd4-bafa-1786c420d55a | hak1jx | 1 | deleted |
i4 U I+ Q7 Z" S w# |- [6 Y| db22ad95-956a-408b-ae2b-e7ba46aad013 | Centos7_X64_LVM_devops_never_new | 1 | deleted |
# ]9 c- J: Y m" Z) ]+ M5 o| e6e2c8ce-ac8f-451a-8f18-c21f753b06d3 | WINSRV_2019_S_64_X_50_X | 1 | deleted |
$ }% M- u2 B0 n2 @& p4 Z: o/ b( T& r- u| f311d110-a2eb-4a09-b5f5-71a581a5512e | jumpserver-devops-image-v.1 | 1 | deleted |% J+ H5 M1 F7 j i* s2 @* T7 o
| f44dad8a-a175-48e5-a272-6716f91b1ce2 | Centos7_X64_LVM_devops_never | 0 | active |
6 v/ B8 Z; @+ w b) Y" `+--------------------------------------+----------------------------------------+---------+---------+1 Q' k+ u; J8 ?, m& v
21 rows in set (0.00 sec)* K: w' v% k4 |' J" r$ q% ~$ C
# y: ^1 S: X2 i' pglance@172.24.201.253:glance 11:00:48>select id,name,deleted,status from images where id="1e6e2885-7a62-4ecc-a356-06f95baa01b1";& N% k4 ^. E9 H# \ p7 z+ C9 C
+--------------------------------------+----------------------------------------+---------+--------+6 C+ Q! P% z( ?
| id | name | deleted | status |
# n7 j. D( y: o! ^3 Q4 U+ N+--------------------------------------+----------------------------------------+---------+--------+
2 n# a% q/ C7 l$ E- L| 1e6e2885-7a62-4ecc-a356-06f95baa01b1 | jumpserver-devops-image-v.2-2021-11-16 | 0 | active |! ^2 D7 T4 i7 d2 Z( Y- `: C6 e( k
+--------------------------------------+----------------------------------------+---------+--------+
! R7 |% y8 Y! j; ^! K/ l. A1 row in set (0.00 sec)2 ^: Z( v: E0 L a2 Y
' |; @. l- }. V( Yglance@172.24.201.253:glance 11:01:55> update glance.images set deleted=" 1 " where id="1e6e2885-7a62-4ecc-a356-06f95baa01b1";
0 |4 Q) c# e+ U1 O* `! B* @Query OK, 1 row affected, 1 warning (0.00 sec)
/ r A# b- `, | l1 IRows matched: 1 Changed: 1 Warnings: 1- `4 |; g4 Y! F/ A( Z y
1 u, E7 e% p& }, t$ h! fglance@172.24.201.253:glance 11:02:26>select id,name,deleted,status from images where id="1e6e2885-7a62-4ecc-a356-06f95baa01b1";
* P5 j3 v3 {7 \; |- P* J5 ~+--------------------------------------+----------------------------------------+---------+--------+
& b) q1 h9 T& || id | name | deleted | status |
1 @+ j' ~$ p( u+--------------------------------------+----------------------------------------+---------+--------+( _" b6 D3 f1 }: M/ s2 e2 z5 q' c
| 1e6e2885-7a62-4ecc-a356-06f95baa01b1 | jumpserver-devops-image-v.2-2021-11-16 | 1 | active |# I% h2 x: Y* Y. s( g1 G
+--------------------------------------+----------------------------------------+---------+--------+* p. u1 Y) Z4 H- G
1 row in set (0.00 sec)
/ Z. P% `, ^7 d, w, i+ C( P3 q) h, H* h" F
glance@172.24.201.253:glance 11:02:31>select id,name,deleted,status from images where id="1e6e2885-7a62-4ecc-a356-06f95baa01b1";
/ p9 ~6 a- f7 p; S+--------------------------------------+----------------------------------------+---------+--------+' }* e9 l) G& E7 W8 T
| id | name | deleted | status |
5 }! @0 Y9 f( f, `: e+--------------------------------------+----------------------------------------+---------+--------+9 `* b3 }# t2 y* w% a/ K
| 1e6e2885-7a62-4ecc-a356-06f95baa01b1 | jumpserver-devops-image-v.2-2021-11-16 | 1 | active |& T' ?$ T' J% g
+--------------------------------------+----------------------------------------+---------+--------+' C! u4 Y) _+ e# R% W, w6 d4 w0 @8 k
1 row in set (0.00 sec)
5 Y" Y2 W1 p, u4 ^$ [9 O& u/ a! ]7 f9 e
glance@172.24.201.253:glance 11:02:51>
# u9 ?. n1 r, f, z) d. ^ [4 X6 d$ G/ N6 [6 u y: ^4 {
再次删除，不在报错。
: w7 E s# l# r/ O问题解决。
/ u% V }! p$ @) A' V7 ]7 B9 w) K* B3 n易陆发现
9 K" I! b' [- x% N7 W( d6 r9 X H
. \3 Y3 e2 j1 N: Q& _ S |
|
发表于 2023-9-18 10:19:07