|
|
错误:无法执行 删除卷快照: ceshikz00011: g, b) K2 u& X% H" ]" g$ j" E( J! T
# {- |2 i& j" O# c, R B) s( S# H4 f
: D& w6 v9 r; C0 @3 V
% G0 r9 U) s$ @8 P8 G6 N# H
) B7 D; w2 @( _: qadminrbd:vms@vms#vmsceshikz00011ceshikz000112GiB
; H* i# f; I( ?( b$ i/ l, ~! ` ~6 ]) l( ^
5 N( q: l% h! j4 z( j6 U3 {# S
* x# l+ _3 L3 e o) Z/ l& Y
删除时出错ceshi00011
' I0 o( a9 r" R3 F. k删除卷快照
+ Y( I" s1 K6 Y; |0 w, F正在显示 1 项- @/ ] ]) c5 w" A) I7 K
) r1 a$ x# ?* ^; H$ T# @' z0 Z& R
登录数据库:
% H- @7 }$ M4 A查询数据库数据:& m# N' J: E/ {
7 V1 h- M! `1 @) c% H; R: N* C; T b( I- a* \
MariaDB [cinder]> select id,deleted,status,display_name from snapshots where id='977dc3f0-11be-403c-b50c-a3826655d319'; ! o" c. Y" u4 O8 B# |$ ~
+--------------------------------------+---------+----------------+--------------+
* R% |# ~9 }' z. L4 c' v- N| id | deleted | status | display_name |, ^& G% {7 @; J# i: v; f
+--------------------------------------+---------+----------------+--------------+
f4 y8 d( |4 b( T) _1 b! ?| 977dc3f0-11be-403c-b50c-a3826655d319 | 0 | error_deleting | ceshikz00011 |
, v' A! s4 l. Z. F+--------------------------------------+---------+----------------+--------------+
$ r3 s, e, H8 [1 p% H O9 P1 row in set (0.00 sec); z# k, s; U6 p6 e* Q C
5 b6 S' N' k0 h% S" m& \! T9 u" J
更新数据删除为1:* J' B& W- A8 M1 U, d
t4 b6 ^* P' H- d0 X% G8 o$ r
MariaDB [cinder]> update cinder.snapshots set deleted="1" where id='977dc3f0-11be-403c-b50c-a3826655d319';
& s \. r& ~- nQuery OK, 1 row affected (0.01 sec)
+ g, W' x9 i4 n& l. `8 WRows matched: 1 Changed: 1 Warnings: 0
( [* F# @9 j. T9 s
2 K w: y, n6 x/ |6 R0 B5 {0 ~# n5 \$ S2 l8 D! P H/ h/ H
+ S, S" X( Z- F! d
* }5 `+ q; }$ g" ?" m0 P) t" ?2 p9 GMariaDB [cinder]> select id,deleted,status,display_name from snapshots where id='977dc3f0-11be-403c-b50c-a3826655d319';
, J) S0 S3 B' S$ U) U9 M$ |% U+--------------------------------------+---------+----------------+--------------+/ j2 k) l6 `8 z: l
| id | deleted | status | display_name |
; Z7 z; Q1 C S9 ^8 N! [+--------------------------------------+---------+----------------+--------------+
/ V! Q0 O, r4 Q5 w8 k! x| 977dc3f0-11be-403c-b50c-a3826655d319 | 1 | error_deleting | ceshikz00011 |
2 d4 ] w9 d6 K+ K7 I+--------------------------------------+---------+----------------+--------------+1 j7 A4 f9 H3 A% }! f0 \" a% K
1 row in set (0.00 sec)2 y1 R8 K, x1 h1 @9 K* e4 a
" P2 z y8 ]6 Q
8 H' \4 `% B7 ]3 o( i6 x+ |3 g6 Y: k4 y2 S8 G! U4 x
) C1 D0 G& {/ T7 |! s5 E+ k' Q2 g
MariaDB [cinder]> select id,deleted,status,display_name from snapshots ; ) \7 T$ f( A5 L/ I$ D
+--------------------------------------+---------+----------------+--------------++ } l# W5 o% ]3 ~8 I. C u
| id | deleted | status | display_name |
9 |5 G* ]5 A6 R& ?/ B* h' I, h+--------------------------------------+---------+----------------+--------------+( i6 T0 `* k# B0 Q
| 977dc3f0-11be-403c-b50c-a3826655d319 | 1 | error_deleting | ceshikz00011 |9 x; g% w* G- L8 T9 T: t
| 9bd29587-a126-45bc-a445-c83fa8b5de98 | 1 | deleted | qianc |
3 x# i; y# I* K! w# `+--------------------------------------+---------+----------------+--------------+
7 k4 ]/ Q5 k$ J) g J2 rows in set (0.00 sec)/ Y; d3 N7 p7 C
" Y4 h; M3 C: d O ~7 H
& L5 ~$ O2 o" f' CMariaDB [cinder]> update cinder.snapshots set status="deleted" where id='977dc3f0-11be-403c-b50c-a3826655d319';
+ z, w9 B. q( bQuery OK, 1 row affected (0.01 sec)5 d) h! ^, ]: C# p$ _
Rows matched: 1 Changed: 1 Warnings: 0
/ b. E5 F, _7 GMariaDB [cinder]> select id,deleted,status,display_name from snapshots ;
- b% \/ L) N8 P1 @+--------------------------------------+---------+---------+--------------+7 v( c2 {- C* q% N. w
| id | deleted | status | display_name |
9 \& ?; m, V k, ?" Q1 C+--------------------------------------+---------+---------+--------------+
. z% V+ w C5 Y K! z% H/ p| 977dc3f0-11be-403c-b50c-a3826655d319 | 1 | deleted | ceshikz00011 |! @, s0 Q* @( z2 [! _
| 9bd29587-a126-45bc-a445-c83fa8b5de98 | 1 | deleted | qianc |
/ v* n4 ~# q9 N+--------------------------------------+---------+---------+--------------+
' d& _+ A0 g8 @: I5 y5 f2 rows in set (0.00 sec): _3 L# m: {" E" S$ G' l y- `; i
- i5 J+ f8 `# Z2 P$ N3 a K* J
/ ` ?4 z' B; L% X% |2 l5 Y3 S, I+ l1 Z
|
|