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

admin

MariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '71146765-659d-47c9-9682-5e077461f6ba';
. Y  t4 U' \) S4 h% R4 X7 ]+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
| id                                   | volume_id                            | user_id                          | status    | display_name |
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
6 t6 i% b* F# g) R| 71146765-659d-47c9-9682-5e077461f6ba | ff5717c6-301d-48a3-9833-9b1722557903 | 07ccc7c9772349a582e20f1e0ad5b054 | available | test1snap2   |
9 K$ L  n0 w1 t7 c% I, p+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
# x( ~* ^' ^" W9 G' ^
$ {9 d& f4 ?. v; ^9 U, j, K
mysql -ucinder -p cinder  -h192.168.6.233
Enter password:
9 O4 H7 K3 b1 ^) DReading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 157266
( S+ H8 ^$ ]0 @+ H4 v4 YServer version: 10.1.20-MariaDB MariaDB Server
& ^/ G3 o; o; ~$ c1 Z& \5 V
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

, x' r, E; q3 i6 K. y' I: YType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [cinder]>
MariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';
. o! p) y6 B' S( M, \+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
| id                                   | volume_id                            | user_id                          | status    | display_name |
1 y2 [4 C) ?9 i) S: z3 l) |. A+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
| 6fdd4a5d-fb65-46bf-80c1-2716c5b4834a | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | 07ccc7c9772349a582e20f1e0ad5b054 | available | test2snap12  |
! f! K- M% \/ ^( g+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
9 H: x6 l  Q1 {. V( u1 row in set (0.00 sec)
. U5 Q9 I) \8 p7 @, c
MariaDB [cinder]> select * from volume_glance_metadata where volume_id = '8ac8ded1-2ade-46de-8c2f-75ec9bf194af';
+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+
| created_at          | updated_at | deleted_at | deleted | id | volume_id                            | snapshot_id | key              | value                                |
+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+
) ]9 O4 }  Z! j, ~- G| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 51 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | container_format | bare                                 |
| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 54 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | min_ram          | 0                                    |
) L* c7 o3 Z6 c9 R6 G| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 57 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | disk_format      | raw                                  |
| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 60 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | image_name       | cirros-0.4                           |
4 t. _/ n+ X- C  B| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 63 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | image_id         | 5062aa42-bb5e-4793-964f-b6dcc61d5fc6 |
: t$ }. r& O* T, E/ z! Q| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 66 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | checksum         | 443b7623e27ecf03dc9e01ee93f67afe     |
| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 69 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | min_disk         | 0                                    |
' j* ]0 c& q7 [, F4 [/ N| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 72 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | size             | 12716032                             |
+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+
- }& B: [, |5 j4 U6 u; e; O
0 [: t( D: v9 V+ q+ c' @0 u8 rows in set (0.00 sec)

. `- \% v! _* f  x
  G( M6 d- @" N* n; d, k/ x" J7 C' YMariaDB [cinder]> delete from volume_glance_metadata where id='51';
1 E! ?0 N9 e3 w; i6 ?Query OK, 1 row affected (0.00 sec)

MariaDB [cinder]> delete from volume_glance_metadata where id='54';
. s, y* k; x5 D( H7 N  [, HQuery OK, 1 row affected (0.00 sec)

( t5 d6 R1 {! w. q$ ^MariaDB [cinder]> delete from volume_glance_metadata where id='57';
Query OK, 1 row affected (0.00 sec)

; b5 S% ~+ C& V7 h( r0 l1 Z6 xMariaDB [cinder]> delete from volume_glance_metadata where id='60';
+ ?7 t/ H9 Z4 L7 }Query OK, 1 row affected (0.00 sec)

MariaDB [cinder]> delete from volume_glance_metadata where id='63';
Query OK, 1 row affected (0.00 sec)

MariaDB [cinder]> delete from volume_glance_metadata where id='66';
3 G% f' E6 K8 e  ?9 Z& RQuery OK, 1 row affected (0.00 sec)
: u4 I, ^/ B) _8 Y, h' H6 A) i. f. O
6 a" C4 b6 d4 z% C! \  MMariaDB [cinder]> delete from volume_glance_metadata where id='69';
- T* E% G, o2 I  r: w0 q5 ~! [Query OK, 1 row affected (0.01 sec)

MariaDB [cinder]> delete from volume_glance_metadata where id='72';
Query OK, 1 row affected (0.01 sec)
4 b3 ~2 f1 f) o$ C8 u
5 C0 O, j+ N& `* {
4 b5 K& Z: p$ |4 ]MariaDB [cinder]> delete from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';
- U' K* y8 }& u5 r( v8 IERROR 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 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`))
MariaDB [cinder]> delete from snapshots where volume_id= '8ac8ded1-2ade-46de-8c2f-75ec9bf194af';
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`))
MariaDB [cinder]>



1 V7 P0 E  j  _$ D+ y( ]. x7 \

admin

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