数据查询删除snapshots数据库命令和步骤

admin

MariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '71146765-659d-47c9-9682-5e077461f6ba';
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
* d. ~3 C5 ]! X5 x) c: y. L| id                                   | volume_id                            | user_id                          | status    | display_name |
! G6 z- m; |: @, h6 c+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
| 71146765-659d-47c9-9682-5e077461f6ba | ff5717c6-301d-48a3-9833-9b1722557903 | 07ccc7c9772349a582e20f1e0ad5b054 | available | test1snap2   |
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
9 S! l+ v9 N# ]

. x  b% U- @# j% J$ O' tmysql -ucinder -p cinder  -h192.168.6.233
Enter password:
Reading table information for completion of table and column names
/ H. V8 U7 V0 V" [0 P) m. jYou can turn off this feature to get a quicker startup with -A
& p1 n: S  l; @+ X
* |+ Z0 }4 B) [3 S6 vWelcome to the MariaDB monitor.  Commands end with ; or \g.
) b" R7 f# K' r( q4 G  ]4 i. \Your MariaDB connection id is 157266
Server version: 10.1.20-MariaDB MariaDB Server
1 H& G$ w8 i5 _$ `5 z
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
8 t6 Q/ i. o( w  S. |) Y
MariaDB [cinder]>
+ Y1 w3 \& v& f% \# oMariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';
* V; Q7 K1 C' J3 K+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
0 J1 h2 R1 E  l; m9 _5 d# p9 b| id                                   | volume_id                            | user_id                          | status    | display_name |
2 @6 s; j! b$ R/ Q. n+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
% C3 P  ?* n3 l: S| 6fdd4a5d-fb65-46bf-80c1-2716c5b4834a | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | 07ccc7c9772349a582e20f1e0ad5b054 | available | test2snap12  |
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
  o/ s7 C% a. _2 i1 row in set (0.00 sec)
' K& a6 k/ f7 c- p" L4 K
. t1 b7 R, K1 E& j2 k5 Z# {MariaDB [cinder]> select * from volume_glance_metadata where volume_id = '8ac8ded1-2ade-46de-8c2f-75ec9bf194af';
( ?4 x& Y) c0 L6 |+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+
| created_at          | updated_at | deleted_at | deleted | id | volume_id                            | snapshot_id | key              | value                                |
! ~7 w6 |5 t: Q! T0 E0 T+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+
| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 51 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | container_format | bare                                 |
: f6 u' F- ?1 X( E- L: U2 m| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 54 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | min_ram          | 0                                    |
5 k8 Z/ s& r1 u9 T$ N3 ~1 v7 P| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 57 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | disk_format      | raw                                  |
$ U( A( a) ?9 z8 [+ Q| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 60 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | image_name       | cirros-0.4                           |
2 f$ T. C$ h, V9 @: Z| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 63 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | image_id         | 5062aa42-bb5e-4793-964f-b6dcc61d5fc6 |
| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 66 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | checksum         | 443b7623e27ecf03dc9e01ee93f67afe     |
# f/ ^/ y) S; g. k| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 69 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | min_disk         | 0                                    |
| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 72 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | size             | 12716032                             |
+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+

8 rows in set (0.00 sec)


/ p2 M  W9 C/ y' HMariaDB [cinder]> delete from volume_glance_metadata where id='51';
2 Y7 C3 o( v; NQuery OK, 1 row affected (0.00 sec)
$ ~/ Y: T  t0 s4 T. e+ _( ~& X' l
. r& S' P4 b5 ^( ~0 l3 DMariaDB [cinder]> delete from volume_glance_metadata where id='54';
1 n4 d8 b" G; m: k! O- l" D$ MQuery OK, 1 row affected (0.00 sec)
0 I$ v+ k# M& U: S  X
MariaDB [cinder]> delete from volume_glance_metadata where id='57';
% F0 X* ~0 N! ]; S# ~Query OK, 1 row affected (0.00 sec)

8 }  N! s& Z$ p4 G6 QMariaDB [cinder]> delete from volume_glance_metadata where id='60';
Query OK, 1 row affected (0.00 sec)
: v3 }( o- P5 X! B
' _" g3 ?$ `$ T1 t" x5 Z- tMariaDB [cinder]> delete from volume_glance_metadata where id='63';
( `7 \0 Z0 ]" I, A  G! bQuery OK, 1 row affected (0.00 sec)
0 S4 F* V9 J  _5 D; N
# o1 S2 n$ ?; W; [! D3 {MariaDB [cinder]> delete from volume_glance_metadata where id='66';
Query OK, 1 row affected (0.00 sec)

MariaDB [cinder]> delete from volume_glance_metadata where id='69';
! _, _* z* [! G! @* s: [Query OK, 1 row affected (0.01 sec)
& |2 I9 ~0 q/ O: M. G4 \$ f
MariaDB [cinder]> delete from volume_glance_metadata where id='72';
Query OK, 1 row affected (0.01 sec)

: C7 d7 F- O- S: ]& h
MariaDB [cinder]> delete from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';
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`))
& I* g$ b. e8 bMariaDB [cinder]> delete from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';
; @+ i8 O9 T; hERROR 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`))
MariaDB [cinder]> delete from snapshots where volume_id= '8ac8ded1-2ade-46de-8c2f-75ec9bf194af';
7 H: J3 j  K. n. k: XERROR 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`))
, H% T+ z# @) s0 G( \3 N+ }- O! I2 IMariaDB [cinder]>

  h- |) A) M3 t; J) ^) a/ Z$ h3 {
8 u- w! a8 `4 x3 t
* _9 n7 ~' G# |# I" p
$ U/ l' E( {, ]8 D

admin

未找到原因，通过界面可以删除。建议不要随便删除数据库数据，否则会导致数据库缺少数据字段。