|
|
MariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '71146765-659d-47c9-9682-5e077461f6ba';
# s$ {- f0 V4 g! y+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
& h0 j$ [+ v m| id | volume_id | user_id | status | display_name |
: y0 g! B% |6 e+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
# T* F4 O$ x2 ^- t1 n| 71146765-659d-47c9-9682-5e077461f6ba | ff5717c6-301d-48a3-9833-9b1722557903 | 07ccc7c9772349a582e20f1e0ad5b054 | available | test1snap2 |7 \' h% v a8 X
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
- T- T- ^6 u" T7 y9 {; l+ @) {! L" ^0 f( F1 X
+ C) O" s' J4 ]+ B3 s; n% s
mysql -ucinder -p cinder -h192.168.6.233) }* G3 h5 k D
Enter password:
# |9 t' a1 G+ A# k5 j" wReading table information for completion of table and column names1 K; D/ z k9 h: ^/ r# G! u5 u
You can turn off this feature to get a quicker startup with -A
- P, T L" a6 F4 E4 \5 m ]$ [
7 p% Z P" w; S) pWelcome to the MariaDB monitor. Commands end with ; or \g.
/ S6 A9 T9 u# g/ k7 u/ IYour MariaDB connection id is 157266
5 j& q! G4 Q; M MServer version: 10.1.20-MariaDB MariaDB Server
4 d) Y/ k1 |. A) M, b
4 T7 N1 g. F5 p8 H0 B8 UCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
, N, S, W, `8 D4 t2 W7 J0 Q0 W7 Z8 _) A! P0 d- F
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.6 _1 m7 g3 V$ s
$ Q1 r, D( I9 ^- v8 ~7 }; Z
MariaDB [cinder]>
3 r% Z" P9 y% _' ]. p, [2 jMariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';4 m; n1 Y I, k% E9 `
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+" r- V9 x: a' ^5 Z. u5 K2 g( z2 {* [( `
| id | volume_id | user_id | status | display_name |
! D( y' B+ u- g4 I) Z$ }0 c+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+. {; S- `3 G; b3 b
| 6fdd4a5d-fb65-46bf-80c1-2716c5b4834a | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | 07ccc7c9772349a582e20f1e0ad5b054 | available | test2snap12 |0 _; V* R1 K! B7 m0 B; B
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
! d0 ?& {) g; z: U1 row in set (0.00 sec)
- ]6 F. y/ e; H! v9 Z2 B
5 k8 V( l5 O- i- k6 ?MariaDB [cinder]> select * from volume_glance_metadata where volume_id = '8ac8ded1-2ade-46de-8c2f-75ec9bf194af';1 e. W( G& O2 `& ^' j7 c
+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+
: p% s8 F( h* G| created_at | updated_at | deleted_at | deleted | id | volume_id | snapshot_id | key | value |
- l4 n5 J2 B6 J' L+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+
% U8 d* V8 s, B9 P( R| 2021-05-18 07:08:10 | NULL | NULL | 0 | 51 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | container_format | bare |* I) R6 x5 s2 C8 f7 t
| 2021-05-18 07:08:10 | NULL | NULL | 0 | 54 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | min_ram | 0 |
- t3 A' _! U% ?& {| 2021-05-18 07:08:10 | NULL | NULL | 0 | 57 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | disk_format | raw |8 \& c0 ^! I7 x3 {+ N/ D1 Z
| 2021-05-18 07:08:10 | NULL | NULL | 0 | 60 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | image_name | cirros-0.4 |0 ?, B, ~" b {$ X% Q
| 2021-05-18 07:08:10 | NULL | NULL | 0 | 63 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | image_id | 5062aa42-bb5e-4793-964f-b6dcc61d5fc6 |. V1 B8 ?+ }& [1 Q. G! h4 i
| 2021-05-18 07:08:10 | NULL | NULL | 0 | 66 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | checksum | 443b7623e27ecf03dc9e01ee93f67afe |
& ^/ O# L) \8 D| 2021-05-18 07:08:10 | NULL | NULL | 0 | 69 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | min_disk | 0 |# d7 k N; o6 g: g$ b$ Z1 `
| 2021-05-18 07:08:10 | NULL | NULL | 0 | 72 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | size | 12716032 |
; J0 b9 D6 |) `8 I+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+1 T( M" _# i& u S# \ v7 n2 B
, E. x s; y8 `5 Y9 c( W
8 rows in set (0.00 sec)6 M. ?$ G8 V# O9 }
" I, i+ \+ ]5 z: O" i# \8 ~
# [* h `+ n: G% P( F: U4 q2 ZMariaDB [cinder]> delete from volume_glance_metadata where id='51';
2 c0 q" m- x' C0 Q! NQuery OK, 1 row affected (0.00 sec)) [) B+ q3 O1 \4 Z l$ e- C- h2 q
; T. R7 h/ L& m' H* A. c: s) uMariaDB [cinder]> delete from volume_glance_metadata where id='54';
! E* w( c9 h C( V5 z! TQuery OK, 1 row affected (0.00 sec); L* }9 b! z, i% Q% v
3 L% N. |' j$ H9 A) m! x- G
MariaDB [cinder]> delete from volume_glance_metadata where id='57';
) }( L3 c- `$ X% ^Query OK, 1 row affected (0.00 sec)
2 j2 w4 W3 j; q6 }/ z% X! Q t. l' k# U$ f
MariaDB [cinder]> delete from volume_glance_metadata where id='60';
! c& N6 ]( v" \; x- w4 DQuery OK, 1 row affected (0.00 sec)
/ n$ _ W W3 l* M/ B" f% _4 o* M2 w" a. y
MariaDB [cinder]> delete from volume_glance_metadata where id='63';! k, B0 D! K4 r# g& v; G
Query OK, 1 row affected (0.00 sec)
* g" F) r$ I0 r7 f3 S
+ Z8 j- U9 y1 `1 X( q& _ \MariaDB [cinder]> delete from volume_glance_metadata where id='66';
. Q& l) B. o) @0 r# D9 wQuery OK, 1 row affected (0.00 sec)- Z% Q5 @/ o) Q$ J' E+ G: r
+ ]5 ^: N2 F& D5 d/ \# G1 V* A
MariaDB [cinder]> delete from volume_glance_metadata where id='69';+ d0 w$ E+ A; } J: R$ ~) l
Query OK, 1 row affected (0.01 sec)8 H. |& d9 b @. b: B, Z7 t6 `+ l
/ E- v% ?9 u5 b' G1 x( S9 c, _
MariaDB [cinder]> delete from volume_glance_metadata where id='72';
" G1 O9 I, w1 o. C6 z; kQuery OK, 1 row affected (0.01 sec)
: Y/ M# U# e2 k3 I. B7 S
$ p! o$ r1 z8 A- ^" k
5 Z! |/ x( {( N; [& S: LMariaDB [cinder]> delete from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';
+ {8 R ~4 c9 b2 P9 G; w$ R$ YERROR 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`))" N# a, c# d5 k- c- `# a" G% R
MariaDB [cinder]> delete from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';7 g0 D2 V7 f' t) X
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`))
2 v- v( I* p2 H/ \MariaDB [cinder]> delete from snapshots where volume_id= '8ac8ded1-2ade-46de-8c2f-75ec9bf194af';) K) m% B3 D5 h+ ~3 b& ?' m3 D' U
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`))' [+ ], H3 f! y' T; k# M
MariaDB [cinder]> ; d9 Z( g1 N. b* z# n2 `
- v9 u0 h6 | L6 U/ R7 I6 \8 S
& R |% V+ ^3 M5 J$ Z6 b0 y$ D7 [6 V( f) o8 E- ]1 @/ ?8 n
1 E: D9 \5 u/ I) c1 ^. I$ ` |
|
发表于 2021-5-19 15:49:39