|
|
错误：无法执行 删除卷快照: ceshikz00011
- m0 B2 ^5 c' v$ O5 J/ l
s6 {, }3 O. q' E) I! N* @( d& |( `3 O3 M3 G1 |
/ O7 O9 y: o4 l; {! w9 P
+ D( c2 W% s, F# v o
0 P6 k& n- Q1 m4 k, z% ^0 Qadminrbd:vms@vms#vmsceshikz00011ceshikz000112GiB" n3 f) y2 ^) n, z3 Y
# ?) Q2 [! t' ]! K
- r) `8 G, A+ u& h' ~
( V; D* I+ p$ G删除时出错ceshi00011
2 d" ~2 t, x- P* ]# c) [删除卷快照
& v# ?2 {8 H) V7 {6 M* U% M. Q正在显示 1 项. H- t$ @4 Q# j9 B* W$ u( C ]& o7 U
* _/ Y2 N2 D+ i登录数据库：
* y# e1 ^5 K/ L7 O: u查询数据库数据：
, z0 z8 C5 p5 F3 k2 D/ J+ k5 Q5 r) j# p4 h6 [
; |+ b- Z6 y/ U, H+ c# P) VMariaDB [cinder]> select id,deleted,status,display_name from snapshots where id='977dc3f0-11be-403c-b50c-a3826655d319'; % T6 V/ Z( j7 r+ V4 {- n: J# H
+--------------------------------------+---------+----------------+--------------+7 B/ W/ D% ?5 N6 ]1 E9 f
| id | deleted | status | display_name |0 Z* h* ~$ Q7 f
+--------------------------------------+---------+----------------+--------------+
/ x* m0 @) ~# J% B2 [% Y| 977dc3f0-11be-403c-b50c-a3826655d319 | 0 | error_deleting | ceshikz00011 |$ ~+ Y+ _( {: \7 P2 K
+--------------------------------------+---------+----------------+--------------+
9 w. O8 u0 L6 A! f5 Z- z1 row in set (0.00 sec)3 W t4 o$ j4 y* d1 w( J
& @' ]/ l# T- ] l2 C
更新数据删除为1：# b, n ~+ |( Z$ h
4 P( [# [1 h" ?" `/ n1 N2 V
MariaDB [cinder]> update cinder.snapshots set deleted="1" where id='977dc3f0-11be-403c-b50c-a3826655d319';
/ X, p! n0 K0 Q" q( wQuery OK, 1 row affected (0.01 sec)5 E. v! O3 z+ ?- d; ~% ?
Rows matched: 1 Changed: 1 Warnings: 02 |( y4 N) _* ~
5 J3 x% R* y+ X7 t) I5 ~
: D4 `" L- {6 A, t8 P* N& E: X
) Z9 c! W {3 r. E6 s
. c9 Y" H* Y3 [. v0 c4 y3 NMariaDB [cinder]> select id,deleted,status,display_name from snapshots where id='977dc3f0-11be-403c-b50c-a3826655d319';
4 w8 q! S3 U# c& c% P+--------------------------------------+---------+----------------+--------------+! Y8 M& U% N* A
| id | deleted | status | display_name |! c" ^5 r+ M! b# J
+--------------------------------------+---------+----------------+--------------+. ]: X0 O5 j+ }8 f7 H+ J
| 977dc3f0-11be-403c-b50c-a3826655d319 | 1 | error_deleting | ceshikz00011 |
9 R/ x# ~6 o& [1 o+--------------------------------------+---------+----------------+--------------+( H" [. D$ p$ n8 h
1 row in set (0.00 sec)' k, g; D$ }0 \* p X% v
1 D. ?& l- d0 G2 L; n
. l2 r9 @2 S7 t! p& R
) E. J# q5 w! l% n1 t- v, x8 M3 e' Z' N$ I% ^1 ~
MariaDB [cinder]> select id,deleted,status,display_name from snapshots ;
# W- y5 i7 E) c$ l" v& Q3 _+--------------------------------------+---------+----------------+--------------++ w" t4 A: Z7 | |- Q9 f
| id | deleted | status | display_name |2 M- e$ f6 M( \" ?; _" o
+--------------------------------------+---------+----------------+--------------+. z* i+ Q3 T0 _ h- p
| 977dc3f0-11be-403c-b50c-a3826655d319 | 1 | error_deleting | ceshikz00011 |7 H1 Q. L$ i' J3 y- H( X0 v9 s
| 9bd29587-a126-45bc-a445-c83fa8b5de98 | 1 | deleted | qianc |
& }( F' q8 J ]+ {) R q+--------------------------------------+---------+----------------+--------------+' J: p' f" u3 R0 f, n% d8 z
2 rows in set (0.00 sec)
; T+ R3 z/ K- p* t# U4 O
4 J5 x4 f: s% r0 t( F5 U& N
, b5 [7 d% \# f7 ZMariaDB [cinder]> update cinder.snapshots set status="deleted" where id='977dc3f0-11be-403c-b50c-a3826655d319';
7 S: t. R' E1 ~6 B# q. b# HQuery OK, 1 row affected (0.01 sec); A0 B9 o: a. L# @/ c8 _: {
Rows matched: 1 Changed: 1 Warnings: 0
: _, L. `5 C% R8 e1 f% f( k9 [MariaDB [cinder]> select id,deleted,status,display_name from snapshots ;
3 D/ s/ O5 B' _; z5 X3 ]; J+--------------------------------------+---------+---------+--------------+
0 D/ H% B7 U4 k4 V3 `| id | deleted | status | display_name |4 @, K* G' d, z/ Z1 f
+--------------------------------------+---------+---------+--------------+4 o$ w3 O4 J+ O1 H/ K
| 977dc3f0-11be-403c-b50c-a3826655d319 | 1 | deleted | ceshikz00011 |2 k. L! J& I& ?
| 9bd29587-a126-45bc-a445-c83fa8b5de98 | 1 | deleted | qianc |5 Q1 H4 [7 i) k/ T! _/ J
+--------------------------------------+---------+---------+--------------+
( M' I2 @: C% q9 R' A9 D6 y2 rows in set (0.00 sec)4 Z6 K2 N$ T' L, a8 O6 V5 w$ ?
3 b# q7 ~6 h( l: M2 s- b: L5 q
, k$ `& q1 V5 \# Z8 c# Z3 V. g2 b0 \
|
|
发表于 2021-10-20 10:39:08