|
|
MariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '71146765-659d-47c9-9682-5e077461f6ba';
. w: u: I' |2 n. B6 h+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
% X a3 \; {, b+ N, || id | volume_id | user_id | status | display_name |* o0 z/ F; T4 k( w8 m% F( r
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
4 q8 V1 N" k% q| 71146765-659d-47c9-9682-5e077461f6ba | ff5717c6-301d-48a3-9833-9b1722557903 | 07ccc7c9772349a582e20f1e0ad5b054 | available | test1snap2 |. q4 k' P6 C3 s0 R
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
; [7 R8 g* T" W2 w& I9 g- R8 a/ d2 K! L) ?
# `( @ F# e9 T/ R
mysql -ucinder -p cinder -h192.168.6.2334 ^% O. K/ f: }- u/ b7 i& z9 v4 [
Enter password:
& W( F% p% N+ f& _# M- g# o% MReading table information for completion of table and column names% K# {6 c' {/ T1 M: i( n) Z5 O# v9 |
You can turn off this feature to get a quicker startup with -A
1 [8 s" v9 N K2 H
- P- G- Q7 j* J2 h5 W6 OWelcome to the MariaDB monitor. Commands end with ; or \g.
, X8 u: a' j4 W7 i' wYour MariaDB connection id is 157266/ n# M& G, q) P- h( _; E; L& w
Server version: 10.1.20-MariaDB MariaDB Server
4 L% d7 ^# Q9 ?
' ~7 N; j, L& \, I6 `Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
4 d& D, b) H0 p$ F+ q3 p: F
. ?, u# B3 y- e* w1 |$ NType 'help;' or '\h' for help. Type '\c' to clear the current input statement.
/ \9 {( \7 I& @$ v6 U# p- T' E* q+ v. U
MariaDB [cinder]> 7 I8 U/ Z; B( u4 i) Q9 m6 ^
MariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';0 j% |# w( j+ t' k: L0 _, C4 y
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+1 q. l0 ^0 ^9 Y# H/ L0 h9 p; G" m
| id | volume_id | user_id | status | display_name |, ?& }" s# R: m9 J. z/ ^; L
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
$ N; D& `8 D; V1 g9 R z/ s q| 6fdd4a5d-fb65-46bf-80c1-2716c5b4834a | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | 07ccc7c9772349a582e20f1e0ad5b054 | available | test2snap12 |
: F: K% c$ [. p: ?6 r# T- b+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------++ u) @9 y/ b- X- ~
1 row in set (0.00 sec)- c9 H% W+ m0 E, n, t3 e
- ^0 j7 e0 I/ y b) EMariaDB [cinder]> select * from volume_glance_metadata where volume_id = '8ac8ded1-2ade-46de-8c2f-75ec9bf194af';& |+ g. y- u* ^
+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+& r7 h1 E! a3 f0 X; a6 l
| created_at | updated_at | deleted_at | deleted | id | volume_id | snapshot_id | key | value |
" C" \ I( g% X2 m4 a+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+
7 g+ h9 m# O7 H0 H! C| 2021-05-18 07:08:10 | NULL | NULL | 0 | 51 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | container_format | bare |
B+ D0 h" j+ s* G" e4 J| 2021-05-18 07:08:10 | NULL | NULL | 0 | 54 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | min_ram | 0 |. V0 Q6 K1 x9 h- s# m
| 2021-05-18 07:08:10 | NULL | NULL | 0 | 57 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | disk_format | raw |
: g7 j# L) X5 W" L' L| 2021-05-18 07:08:10 | NULL | NULL | 0 | 60 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | image_name | cirros-0.4 |
) S9 L* D! W2 G2 p1 i| 2021-05-18 07:08:10 | NULL | NULL | 0 | 63 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | image_id | 5062aa42-bb5e-4793-964f-b6dcc61d5fc6 |
8 l1 m2 B: Y1 m" ^6 Q| 2021-05-18 07:08:10 | NULL | NULL | 0 | 66 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | checksum | 443b7623e27ecf03dc9e01ee93f67afe |' l* g; P: v5 ?7 C! p3 z+ t$ w* l5 m
| 2021-05-18 07:08:10 | NULL | NULL | 0 | 69 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | min_disk | 0 |
/ p& W1 i1 r/ ^| 2021-05-18 07:08:10 | NULL | NULL | 0 | 72 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL | size | 12716032 |2 Z* K8 |" P3 _/ ^, Y7 K4 x& P
+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+' e% V; `+ R" V5 x6 j
& A+ G- [( @7 y( [4 ^+ D
8 rows in set (0.00 sec)
4 G% ?$ R8 p, p ~+ p9 L% V% L9 v3 y; W- @
5 K6 y% K% f& R0 ]& ^MariaDB [cinder]> delete from volume_glance_metadata where id='51';
; c% z: b) x7 JQuery OK, 1 row affected (0.00 sec): W2 x K. d7 \* q( S" `" Q2 p. |
4 `0 x5 d: m2 d) ]2 T, a% e! x
MariaDB [cinder]> delete from volume_glance_metadata where id='54';! \6 h6 d4 ~5 |3 Y& L
Query OK, 1 row affected (0.00 sec)
0 Y- l+ m% ]/ k* D# u( n7 X$ j# ~/ o5 n1 N; K \
MariaDB [cinder]> delete from volume_glance_metadata where id='57';8 o+ v# ]. F; ]7 V# o% G
Query OK, 1 row affected (0.00 sec)' [7 }. a1 Z \- J( y
' n+ [7 `; g( p2 Z2 y( b$ u; E) `
MariaDB [cinder]> delete from volume_glance_metadata where id='60';
) E( P" g" l, nQuery OK, 1 row affected (0.00 sec): `+ k$ k0 ^( K o
5 N' j1 C$ c3 T$ v J# E+ `3 g ? vMariaDB [cinder]> delete from volume_glance_metadata where id='63';" \. I6 G k6 j% Q
Query OK, 1 row affected (0.00 sec)
1 g! L! v; m: p9 H
" P; ^4 T# ] d: X, [4 K2 @MariaDB [cinder]> delete from volume_glance_metadata where id='66';
: x$ R; L* z" c2 r7 P3 q Y* |! BQuery OK, 1 row affected (0.00 sec)% W% o, P+ O: N3 }- q: r, W0 z0 ~- z
% q4 y) g; n# L2 K; f
MariaDB [cinder]> delete from volume_glance_metadata where id='69';- v) ~1 b5 _/ `* {. V: _& |
Query OK, 1 row affected (0.01 sec)7 B# R& [6 I& B) p' X
) S% Z7 c# j2 sMariaDB [cinder]> delete from volume_glance_metadata where id='72';
) {6 H- P& @% XQuery OK, 1 row affected (0.01 sec)6 I; H0 i, _4 f; j% {
, u o% u0 Y& v% d
1 O; g- ]+ m. o$ HMariaDB [cinder]> delete from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';. w6 H/ U7 d# j7 N8 [7 [, R. r0 q" r
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`))( a! q' K$ E- [' |6 `
MariaDB [cinder]> delete from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';
3 @- F/ [% \3 R8 h RERROR 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`))
' s5 X4 y' g2 ~ A4 QMariaDB [cinder]> delete from snapshots where volume_id= '8ac8ded1-2ade-46de-8c2f-75ec9bf194af';% n1 a- F0 B$ E6 L6 h7 m/ S
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`))) E( V9 \, z' n
MariaDB [cinder]>
5 {, F n: S7 Z+ f$ J6 Z# J2 T& N) S* F( D
8 x7 w' ^ [# H7 z
0 t" C& a) U: Y4 I9 s2 D! u
0 Q& Y4 e# n( |5 F( v/ ]# A
|
|
发表于 2021-5-19 15:49:39