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

admin

MariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '71146765-659d-47c9-9682-5e077461f6ba';
9 j7 G$ q) I4 p+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
6 V# k! U! O* L| id                                   | volume_id                            | user_id                          | status    | display_name |
5 K! [6 P9 M6 W+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
| 71146765-659d-47c9-9682-5e077461f6ba | ff5717c6-301d-48a3-9833-9b1722557903 | 07ccc7c9772349a582e20f1e0ad5b054 | available | test1snap2   |
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
! S" S- N) _# ^- O% X

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

3 m+ r6 S! P+ N4 y. e! B% z# {Welcome to the MariaDB monitor.  Commands end with ; or \g.
. e  e" j) ~8 e; S/ c- {/ ZYour MariaDB connection id is 157266
0 _2 q; @! X/ q" u3 D' OServer version: 10.1.20-MariaDB MariaDB Server
# ^, F1 a0 C& R# K/ O
4 w6 p+ s4 U4 c2 i, P5 LCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
$ M- I) H$ u$ a  a; ]
1 g, j, N% s8 [9 r& I2 e& C" yType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

' U( z/ E* B/ r9 SMariaDB [cinder]>
MariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
| id                                   | volume_id                            | user_id                          | status    | display_name |
% W6 a) k. `' G7 d+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
, u4 h& X  p& v4 k. ?/ s| 6fdd4a5d-fb65-46bf-80c1-2716c5b4834a | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | 07ccc7c9772349a582e20f1e0ad5b054 | available | test2snap12  |
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
1 row in set (0.00 sec)
. I( o- y  u8 X: x# p3 V
MariaDB [cinder]> select * from volume_glance_metadata where volume_id = '8ac8ded1-2ade-46de-8c2f-75ec9bf194af';
, {  u5 Q- M7 ~% a' x1 m! d9 w+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+
: o7 \& F  I/ f2 U* L| created_at          | updated_at | deleted_at | deleted | id | volume_id                            | snapshot_id | key              | value                                |
+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+
| 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                                    |
) s! M# D# {( z0 R. j% _6 R7 c& e| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 57 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | disk_format      | raw                                  |
! F7 E" {- M  f1 e| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 60 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | image_name       | cirros-0.4                           |
# e3 d" K) ?- Z8 V3 _. [. f3 b& y! G* _| 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     |
; O  E* g3 u# g' o0 R9 Q| 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)


! \. e' o) p" ^' lMariaDB [cinder]> delete from volume_glance_metadata where id='51';
Query OK, 1 row affected (0.00 sec)

MariaDB [cinder]> delete from volume_glance_metadata where id='54';
# d7 ], N; T0 S$ a# OQuery OK, 1 row affected (0.00 sec)

5 F' g6 t3 @1 Q4 n5 R+ S% E/ pMariaDB [cinder]> delete from volume_glance_metadata where id='57';
8 y9 ~; [3 ]* X2 K4 }2 c7 ~: g2 AQuery OK, 1 row affected (0.00 sec)

MariaDB [cinder]> delete from volume_glance_metadata where id='60';
$ l2 N$ v% R9 h, B2 W5 z+ ZQuery OK, 1 row affected (0.00 sec)
) \0 u; o, h! W5 F4 @  B$ I5 W
MariaDB [cinder]> delete from volume_glance_metadata where id='63';
Query OK, 1 row affected (0.00 sec)

# L& h2 B! }5 TMariaDB [cinder]> delete from volume_glance_metadata where id='66';
Query OK, 1 row affected (0.00 sec)
( Q, D$ Z2 U8 K( o. C4 @! m+ j
MariaDB [cinder]> delete from volume_glance_metadata where id='69';
% m4 v! F% a/ B3 H2 q7 ^6 p; l. WQuery OK, 1 row affected (0.01 sec)

MariaDB [cinder]> delete from volume_glance_metadata where id='72';
7 T7 j2 z0 Z/ f; \6 \! ~) AQuery OK, 1 row affected (0.01 sec)


MariaDB [cinder]> delete from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';
7 E% C, X+ ~+ T8 ^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`))
: u* p/ [; L6 @1 ?) y+ |MariaDB [cinder]> delete from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';
% J9 l0 v2 l" Z& S7 BERROR 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`))
0 d! ^2 ?3 F% \$ b4 L/ u3 VMariaDB [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]>


- K" J0 M- a# a' N3 U4 ?8 Y% k

admin

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