|
|
错误：无法执行 删除卷快照: ceshikz00011 i9 r3 [9 U% k: @9 i( h$ i" A# q1 y
7 U! Y0 W3 L. i$ O* t1 [5 G6 ?) W% ?& {
$ ~4 w9 D( l$ n: K: k, I/ X( v; t" l' ?/ I- z& L
' V% K9 P" ]+ `) \0 a
adminrbd:vms@vms#vmsceshikz00011ceshikz000112GiB
; G6 Q0 B+ P& _& h; b2 ?; x& f; y, G" W- j
" {$ u0 U8 J7 h# O2 i
7 K4 N8 p7 n0 o+ a& A* e. y删除时出错ceshi00011
9 l: g5 S1 V3 w0 g( t删除卷快照
- s# I% H, V7 \9 R) o4 [( q正在显示 1 项9 C/ M$ q4 F+ [* g
0 b; {' M/ W m( C% e" v* d' Y
登录数据库：: f3 f+ B* ?6 _, f
查询数据库数据：
( s( q J/ a8 c# [8 c' j+ _1 {# K
- Q) v# e* @. t9 ]4 Z1 A$ O+ }MariaDB [cinder]> select id,deleted,status,display_name from snapshots where id='977dc3f0-11be-403c-b50c-a3826655d319'; * x W4 q l/ ~! E6 U# _
+--------------------------------------+---------+----------------+--------------+
: {. q& |7 |* U3 I| id | deleted | status | display_name |9 @4 z2 i* j @; U
+--------------------------------------+---------+----------------+--------------+1 U# H- m. W, Z0 Y" k1 h
| 977dc3f0-11be-403c-b50c-a3826655d319 | 0 | error_deleting | ceshikz00011 |! p( |* V `" I8 x
+--------------------------------------+---------+----------------+--------------+
$ m+ ]6 p5 ^% X7 H5 L" u" r& |8 f1 row in set (0.00 sec)
( ^( s) k" l3 ^5 y; h) Z6 r4 v! D( ?. z' O7 z3 b
更新数据删除为1：" E. s% P6 ^7 L$ `1 B
2 M9 q$ V& o: U
MariaDB [cinder]> update cinder.snapshots set deleted="1" where id='977dc3f0-11be-403c-b50c-a3826655d319';
; t: ^; _0 c5 i* LQuery OK, 1 row affected (0.01 sec)
, l% z7 Z9 [4 t/ q, ^Rows matched: 1 Changed: 1 Warnings: 07 @2 h+ s ^" R/ _, D v) ?# n& n
& O/ Q7 m3 Z l( Q5 V4 X) M" L7 G, }0 s: X2 ^5 k
' A5 P, _3 J) W/ l9 s( x0 k: _2 G" m0 h8 q7 R0 d1 T0 P5 @9 X
MariaDB [cinder]> select id,deleted,status,display_name from snapshots where id='977dc3f0-11be-403c-b50c-a3826655d319'; . l$ Z6 w: y7 v1 Y4 y7 C R( o
+--------------------------------------+---------+----------------+--------------+2 c3 c& h2 g+ A/ g/ y* q, h
| id | deleted | status | display_name |' }; \2 U2 _8 [+ A3 ~
+--------------------------------------+---------+----------------+--------------+
1 B) W! I% p) O7 j Z| 977dc3f0-11be-403c-b50c-a3826655d319 | 1 | error_deleting | ceshikz00011 |% W4 e) V/ Y/ \
+--------------------------------------+---------+----------------+--------------+0 l3 x& p. `' r5 L9 E
1 row in set (0.00 sec): U) |1 Y& |, k* I3 G
* o) q9 F6 j6 }( f
5 C7 n% B+ i4 Y. G- l- _2 S$ l; a& [) a; Y
! l8 C8 h9 d, @. t7 r: V3 o
MariaDB [cinder]> select id,deleted,status,display_name from snapshots ; 5 X! B9 w- o7 W
+--------------------------------------+---------+----------------+--------------+ ^. ]$ _6 k/ c- H) P
| id | deleted | status | display_name |
3 d7 U6 p: A A! d+--------------------------------------+---------+----------------+--------------++ u1 Y) `% p' c
| 977dc3f0-11be-403c-b50c-a3826655d319 | 1 | error_deleting | ceshikz00011 |: T3 w/ b R: y7 S3 E& e; M" {! ]
| 9bd29587-a126-45bc-a445-c83fa8b5de98 | 1 | deleted | qianc |2 q, N' W# {2 m% y. R
+--------------------------------------+---------+----------------+--------------+& I3 e( k6 n q9 ~0 @
2 rows in set (0.00 sec)
7 g5 h3 C% {- h8 q5 G& V( k5 ]( M& ?! N, o8 @2 l
/ ]. C2 B# E! b$ Q+ X1 }
MariaDB [cinder]> update cinder.snapshots set status="deleted" where id='977dc3f0-11be-403c-b50c-a3826655d319';
( B! a9 Z2 j3 E v; `9 IQuery OK, 1 row affected (0.01 sec)
. v* O8 \4 k h( i$ RRows matched: 1 Changed: 1 Warnings: 00 Y( |0 R3 z9 ~4 ^9 B6 r
MariaDB [cinder]> select id,deleted,status,display_name from snapshots ;
! @. ^# q6 J1 m+--------------------------------------+---------+---------+--------------+) |% E- J% y; p7 Z: f# N
| id | deleted | status | display_name |% n3 v k* w7 M& `4 B
+--------------------------------------+---------+---------+--------------+2 ]- U/ n1 ?' N8 P
| 977dc3f0-11be-403c-b50c-a3826655d319 | 1 | deleted | ceshikz00011 |
% y* g; k0 w1 i' i# F; O| 9bd29587-a126-45bc-a445-c83fa8b5de98 | 1 | deleted | qianc |
" d0 ~# ^* z' w. m+--------------------------------------+---------+---------+--------------+; \" X4 u1 x+ k
2 rows in set (0.00 sec)
; {; {& o3 a2 L" x, a% a4 B+ m& A% N2 S: E! e) H+ L3 o. p
. G+ a4 {. s1 |# y# S3 C0 p9 \, r
4 B& @ f h" ^" n/ q: b; M! ` |
|
发表于 2021-10-20 10:39:08