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

admin

MariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '71146765-659d-47c9-9682-5e077461f6ba';
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
| id                                   | volume_id                            | user_id                          | status    | display_name |
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
, W$ B( g$ Y; b% H+ s& v2 a: ?| 71146765-659d-47c9-9682-5e077461f6ba | ff5717c6-301d-48a3-9833-9b1722557903 | 07ccc7c9772349a582e20f1e0ad5b054 | available | test1snap2   |
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+


mysql -ucinder -p cinder  -h192.168.6.233
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
6 ~9 i  o. t6 V- y/ G
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 157266
) U, y. P: f$ p9 i3 G+ k) ZServer version: 10.1.20-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
  R. l7 l. W5 I8 X1 b
0 D8 S% J! `7 K; |- F) dType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [cinder]>
* x6 A2 Z: J! F/ C3 C& T; @MariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';
0 q  h% k* R8 ^, c, @. F+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
' r4 g1 ?2 H" a; e- |; r9 f6 \5 {| id                                   | volume_id                            | user_id                          | status    | display_name |
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
/ u" B" Y1 O" }: s: Q, T+ z| 6fdd4a5d-fb65-46bf-80c1-2716c5b4834a | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | 07ccc7c9772349a582e20f1e0ad5b054 | available | test2snap12  |
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
1 row in set (0.00 sec)

MariaDB [cinder]> select * from volume_glance_metadata where volume_id = '8ac8ded1-2ade-46de-8c2f-75ec9bf194af';
+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+
. u7 Y0 y- J4 J- O| created_at          | updated_at | deleted_at | deleted | id | volume_id                            | snapshot_id | key              | value                                |
+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+
8 A, G) \7 F- p0 {# D2 `9 h| 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                                    |
% B$ }) U$ o9 T' _$ W| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 57 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | disk_format      | raw                                  |
5 \) C' A& F( V. ^! H| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 60 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | image_name       | cirros-0.4                           |
| 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     |
| 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                             |
/ d5 h; v3 w& ?' R; Q* p/ R- D. l9 u+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+

8 rows in set (0.00 sec)
% P6 x& D4 g: W

MariaDB [cinder]> delete from volume_glance_metadata where id='51';
Query OK, 1 row affected (0.00 sec)
7 t; R" M! K' |/ h7 k# @/ l1 W
! G9 q7 R- J" ^  OMariaDB [cinder]> delete from volume_glance_metadata where id='54';
Query OK, 1 row affected (0.00 sec)

MariaDB [cinder]> delete from volume_glance_metadata where id='57';
# E+ k5 N' S9 ]7 W9 n! QQuery OK, 1 row affected (0.00 sec)
, |' {1 L# P3 j' a
MariaDB [cinder]> delete from volume_glance_metadata where id='60';
* ~: E6 D8 J: n4 \" p! r9 bQuery OK, 1 row affected (0.00 sec)

  X4 u- q) p- E6 o. h" M5 ZMariaDB [cinder]> delete from volume_glance_metadata where id='63';
' p6 K) R5 ~. Y# _  mQuery OK, 1 row affected (0.00 sec)

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';
Query OK, 1 row affected (0.01 sec)
# X+ N; e+ v! a9 e! Y8 H4 ~
MariaDB [cinder]> delete from volume_glance_metadata where id='72';
Query OK, 1 row affected (0.01 sec)

, [' A3 ?9 ~$ P: N1 G
4 x1 B0 h$ E% p, EMariaDB [cinder]> delete from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';
1 c; P* H* M, g  U) lERROR 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`))
, j2 r; \7 }3 G5 p" i& x4 N' tMariaDB [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`))
8 [9 a$ P- T  [5 C: b* G+ o( {5 W' uMariaDB [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]>


0 X, Z* c% F2 Z, `$ B7 \
! ?* Z8 v; L% g3 @' @" U

admin

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