|
|
错误：无法执行 删除卷快照: ceshikz00011
- K! _$ f; |0 o4 l- k- c
! _5 r. y1 |5 S* w9 a( p8 ^. o3 E4 a r4 u
+ c3 h% y: ?+ t3 f6 r2 ?
6 A6 C7 p9 l k4 a
a. S+ G5 \; @! qadminrbd:vms@vms#vmsceshikz00011ceshikz000112GiB
$ q8 e/ F" z9 ?1 M$ I* ]( }& f" f$ r. y# Z" \
5 T8 w" a2 e% i5 f9 D- K; | W0 l
5 ?5 i; `9 b8 ^: {" [1 Y
删除时出错ceshi00011
0 U% ~! N7 U+ ~4 `/ e* X2 u4 g4 J删除卷快照
# c) A# z0 I& _, w# @. t& L4 e; S正在显示 1 项& M% J& U# U! A, h/ p; H7 {
; T8 b' B, V, {7 v7 W
登录数据库：
. ?/ I( v* a, s1 B4 F% R1 f查询数据库数据：, p3 x; }5 K# e2 O a5 C
0 ~% U1 E; K* g7 u1 G0 ?3 p: t9 ~ V/ }- M% Z; ]# |- ]: I0 i8 Y* j( Q. x
MariaDB [cinder]> select id,deleted,status,display_name from snapshots where id='977dc3f0-11be-403c-b50c-a3826655d319'; # z* [ x3 u+ @$ e8 E, L
+--------------------------------------+---------+----------------+--------------+
) M* Y1 w& ]: t1 ^" d5 o| id | deleted | status | display_name |
- H5 R1 r! Z1 E! O$ h* t+--------------------------------------+---------+----------------+--------------+
" `' @( M$ e( }7 @" B1 I Y0 _| 977dc3f0-11be-403c-b50c-a3826655d319 | 0 | error_deleting | ceshikz00011 |
' o9 }% `& [% N8 h+--------------------------------------+---------+----------------+--------------+
! @' g H- i( }8 S1 row in set (0.00 sec)
- q4 l! j Q/ t% b
4 {+ a2 \; x+ U, b0 [; Q8 ?/ Y8 ]更新数据删除为1：
# U! T0 \( j& t. C, k3 Q- X7 ~3 Q0 J6 [7 R) E9 n; j6 o
MariaDB [cinder]> update cinder.snapshots set deleted="1" where id='977dc3f0-11be-403c-b50c-a3826655d319';
2 G9 F; M, z$ ~4 f& c' [3 D8 ~- AQuery OK, 1 row affected (0.01 sec)7 G& \& ?( v' }3 _+ O3 q
Rows matched: 1 Changed: 1 Warnings: 0
5 w8 N; {5 P6 k: c; X. ?
: \' q# I& O u( @: O9 c) s7 Z& v
& z, W; \7 b5 k/ x( ^$ m
# ]+ E6 o& ^, T+ d$ k4 G9 Q7 g
MariaDB [cinder]> select id,deleted,status,display_name from snapshots where id='977dc3f0-11be-403c-b50c-a3826655d319';
) ~% ^4 a0 i) [" O( D2 ]+--------------------------------------+---------+----------------+--------------+
; h ]: h+ _/ G; o5 |8 q3 J| id | deleted | status | display_name |4 L( L% r2 H& e$ R1 w
+--------------------------------------+---------+----------------+--------------+
* c" O5 j7 j1 w$ C# W6 ]| 977dc3f0-11be-403c-b50c-a3826655d319 | 1 | error_deleting | ceshikz00011 |
8 {: B3 ?- ~1 Z( f& x+--------------------------------------+---------+----------------+--------------+
! J; B. L0 o) k; D# T1 row in set (0.00 sec)) K7 y( g8 J( {4 T
( \. m( C) z. E6 R" W1 s. M5 R
8 f8 A+ Z6 `! o( Z$ J( f
5 z- G" ]) w) D( A
/ P* m6 V9 ]. A# @: @* M, H. aMariaDB [cinder]> select id,deleted,status,display_name from snapshots ;
- y1 G. D' b% R: Q1 J+--------------------------------------+---------+----------------+--------------+! c6 L# K8 G% n' m
| id | deleted | status | display_name |
; E1 N( _8 S* h3 Q/ ^6 J* U, a# y+--------------------------------------+---------+----------------+--------------+& H5 l; v) [" s/ _
| 977dc3f0-11be-403c-b50c-a3826655d319 | 1 | error_deleting | ceshikz00011 |
- X8 e( l& X- B. M$ \1 N| 9bd29587-a126-45bc-a445-c83fa8b5de98 | 1 | deleted | qianc |" z1 P8 V8 c# }; t2 K
+--------------------------------------+---------+----------------+--------------+
% V5 S$ n( v4 \0 y2 rows in set (0.00 sec)
! L# Y/ H- M* R# ]
3 y" w' p H* ]* T" U* a9 m
' ` o3 S6 l* p2 l) C- w0 J6 \MariaDB [cinder]> update cinder.snapshots set status="deleted" where id='977dc3f0-11be-403c-b50c-a3826655d319';( S. `0 p8 @5 [/ F$ V- M
Query OK, 1 row affected (0.01 sec)! ~3 C$ D, H. j) W8 Z* C
Rows matched: 1 Changed: 1 Warnings: 0
+ N/ t. v" v% A4 bMariaDB [cinder]> select id,deleted,status,display_name from snapshots ; ! U6 j8 F% w: k: ~. @5 R
+--------------------------------------+---------+---------+--------------+
: n$ {. R9 ~" C) Y! m# C1 o| id | deleted | status | display_name |. S3 B& E( w* s, Y3 m* _# F! R
+--------------------------------------+---------+---------+--------------+4 q9 ?$ F# Z1 y$ K/ C
| 977dc3f0-11be-403c-b50c-a3826655d319 | 1 | deleted | ceshikz00011 |6 h3 W2 A9 I7 O/ T( Y4 i
| 9bd29587-a126-45bc-a445-c83fa8b5de98 | 1 | deleted | qianc |5 p' D" L& G h$ l4 Y( Q
+--------------------------------------+---------+---------+--------------+- C ^* Q2 f$ E6 S. Q0 A
2 rows in set (0.00 sec)
0 M/ t. d) r1 R6 o9 m8 G& r3 l
7 g; ]5 Y* w Z, v9 v/ _ Z- l5 K8 |0 R1 R/ @
2 ^: Z5 |0 J" Y7 J2 Z/ M: y |
|
发表于 2021-10-20 10:39:08