|
|
MariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '71146765-659d-47c9-9682-5e077461f6ba';$ `$ G, W! S0 W+ C- N- B) v
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
6 U5 X' D* G3 E0 P0 L3 a4 r! i| id | volume_id | user_id | status | display_name |
( C3 K/ n: g: h, ?+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
9 @/ ^: ^1 e' l: D2 E| 71146765-659d-47c9-9682-5e077461f6ba | ff5717c6-301d-48a3-9833-9b1722557903 | 07ccc7c9772349a582e20f1e0ad5b054 | available | test1snap2 |9 F2 J {" ?- x0 N- D6 A
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
7 A) b% U- i6 O" c# j0 G# I' J
0 N1 w1 b$ _ c4 E9 q! M/ E! @. [: \# D% U. O7 I
mysql -ucinder -p cinder -h192.168.6.233
& ~: a) C* }* j4 w1 V9 o h6 BEnter password: $ `& q3 u% o' _( a9 q
Reading table information for completion of table and column names
: |; R. t5 e9 y& A+ d+ c- NYou can turn off this feature to get a quicker startup with -A
* H5 y& H/ r# m0 U3 v/ F; ^! f+ g9 b9 ?" E) S- ]& \
Welcome to the MariaDB monitor. Commands end with ; or \g.5 m: g! [7 e6 `6 W- e
Your MariaDB connection id is 157266
, N, A5 h# _0 w9 K" M( v. [0 K u0 o" pServer version: 10.1.20-MariaDB MariaDB Server
# ]% L( d) l1 P! \' W& ]& p! q+ k" c" u( x
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
p7 i0 u- B+ Y# y# a R
+ J# p: a6 u) S' Y/ q5 iType 'help;' or '\h' for help. Type '\c' to clear the current input statement.( ]1 _2 i4 B. V$ K+ e4 x* u4 V6 l) ~
% I4 ~: i/ Q% R4 j+ R( CMariaDB [cinder]>
/ z8 h8 e% V6 ~, ZMariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';
: O2 C, c$ H' ] k- r+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
. f! H' H. y6 ~) j! r% @| id | volume_id | user_id | status | display_name |
- ?3 o' A' S: R3 E4 w0 _# t$ ~6 _+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
9 @1 J" `& P1 t2 k0 Q. K| 6fdd4a5d-fb65-46bf-80c1-2716c5b4834a | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | 07ccc7c9772349a582e20f1e0ad5b054 | available | test2snap12 |- B0 j [7 N5 y2 A# x
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
, Y! B6 H* v$ F; U4 ^1 row in set (0.00 sec)
8 M# n; K* i: O4 g/ o$ N5 J$ b! v( v9 k8 I! P9 h
MariaDB [cinder]> select * from volume_glance_metadata where volume_id = '8ac8ded1-2ade-46de-8c2f-75ec9bf194af';
& O5 F+ [5 d/ Q+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+
" q) O. Z% }- G# t| created_at | updated_at | deleted_at | deleted | id | volume_id | snapshot_id | key | value |" @7 j- T8 o7 \7 s# g2 Q
+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+8 ]+ e% _: F6 [7 _; i
| 2021-05-18 07:08:10 | NULL | NULL | 0 | 51 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | container_format | bare |
: D% F0 `9 k% t- ]9 @6 j| 2021-05-18 07:08:10 | NULL | NULL | 0 | 54 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | min_ram | 0 |2 [6 H2 I+ d) f1 F4 ~
| 2021-05-18 07:08:10 | NULL | NULL | 0 | 57 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | disk_format | raw |5 g2 O4 L# R6 v1 E6 e" l
| 2021-05-18 07:08:10 | NULL | NULL | 0 | 60 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | image_name | cirros-0.4 |! z5 V5 E, |9 E* ]& a
| 2021-05-18 07:08:10 | NULL | NULL | 0 | 63 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | image_id | 5062aa42-bb5e-4793-964f-b6dcc61d5fc6 |+ A. L8 Z7 E. A! q
| 2021-05-18 07:08:10 | NULL | NULL | 0 | 66 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | checksum | 443b7623e27ecf03dc9e01ee93f67afe | `7 o4 Y4 z& O& ^0 i& v% X& Q
| 2021-05-18 07:08:10 | NULL | NULL | 0 | 69 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | min_disk | 0 |' F+ E1 Z2 ~4 S3 n
| 2021-05-18 07:08:10 | NULL | NULL | 0 | 72 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | size | 12716032 |
# F+ \; o7 U5 X) {+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+2 i, |+ }* n" N0 J, K
0 C. Z: o: b- s' D
8 rows in set (0.00 sec)
! T' `4 ~5 e% S1 b
6 D- e8 r, q% q7 j: k: o
H+ D: y1 L7 d" A z7 TMariaDB [cinder]> delete from volume_glance_metadata where id='51';
0 C( h4 H0 b6 s _, ?, M# M0 }Query OK, 1 row affected (0.00 sec)3 o3 T1 |( x; e& h
: M# b; ]6 }+ V- i0 s a, M7 GMariaDB [cinder]> delete from volume_glance_metadata where id='54';
$ g5 S2 G1 p' h5 Y. OQuery OK, 1 row affected (0.00 sec)
: h, Q1 z! A' W0 D7 B/ u- V) E- e
MariaDB [cinder]> delete from volume_glance_metadata where id='57';
+ u5 t; a3 B! }Query OK, 1 row affected (0.00 sec)2 y2 e# l* C2 \2 F3 a
9 W: R* r# T% ~6 c, T; U6 xMariaDB [cinder]> delete from volume_glance_metadata where id='60';! N. c |- _* \; Q! O! f3 N7 D' L$ R
Query OK, 1 row affected (0.00 sec)
( @. N+ V0 \. T6 {; K$ f
9 D, k$ E5 N- _MariaDB [cinder]> delete from volume_glance_metadata where id='63';
7 N* w3 @& x; f/ kQuery OK, 1 row affected (0.00 sec)( J2 X3 r! z, \: A& A4 ?
5 w8 f+ w( n, Q& \4 i) _& @MariaDB [cinder]> delete from volume_glance_metadata where id='66';
8 B$ y: O6 N$ d ?& e8 IQuery OK, 1 row affected (0.00 sec)
) ~% B0 y( F8 B* I# E p( t$ m3 f# J0 i, ~, h& ?3 Q' _' U7 _+ P) y
MariaDB [cinder]> delete from volume_glance_metadata where id='69';6 H- h( n* I& Z& N; h2 F. k
Query OK, 1 row affected (0.01 sec)
% l J# V6 j& u/ P+ M- }+ Y
3 s; u* t% V* V- yMariaDB [cinder]> delete from volume_glance_metadata where id='72'; I, {8 X \6 K5 h' N: B2 Z& B; w2 [' E
Query OK, 1 row affected (0.01 sec)
i% \% H4 g+ L0 F8 t% _1 ~# `2 g% @! F) i c# s: C
8 q3 `- L2 Z8 ~1 m8 \7 UMariaDB [cinder]> delete from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';2 A0 u7 E8 l* e2 O, \
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`cinder`.`volume_glance_metadata`, CONSTRAINT `volume_glance_metadata_ibfk_2` FOREIGN KEY (`snapshot_id`) REFERENCES `snapshots` (`id`))
" ?3 X, g0 T2 s9 S- mMariaDB [cinder]> delete from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';, X: [5 `7 c8 j8 a
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`cinder`.`volume_glance_metadata`, CONSTRAINT `volume_glance_metadata_ibfk_2` FOREIGN KEY (`snapshot_id`) REFERENCES `snapshots` (`id`))- z: S6 u5 ^5 ]; ]! O' Z
MariaDB [cinder]> delete from snapshots where volume_id= '8ac8ded1-2ade-46de-8c2f-75ec9bf194af';
$ |; M& B4 t3 ~5 m# O3 I& ZERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`cinder`.`volume_glance_metadata`, CONSTRAINT `volume_glance_metadata_ibfk_2` FOREIGN KEY (`snapshot_id`) REFERENCES `snapshots` (`id`))
- U) a _3 F0 }" J! \MariaDB [cinder]> 1 H5 U# U5 S' s7 p$ x
0 q: z4 A8 y' G `5 w" B! }% l. J# ?" v5 }
$ D/ a5 N. Z+ @6 d* m
7 w- {3 ]) w1 O0 K
|
|
发表于 2021-5-19 15:49:39