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

admin

MariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '71146765-659d-47c9-9682-5e077461f6ba';
8 }0 d4 {0 E1 T2 V0 B; ]+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
| id                                   | volume_id                            | user_id                          | status    | display_name |
3 K" A/ y+ _" a0 V" _. V5 ^; L- M+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
4 }& S- C( W& B& R- q| 71146765-659d-47c9-9682-5e077461f6ba | ff5717c6-301d-48a3-9833-9b1722557903 | 07ccc7c9772349a582e20f1e0ad5b054 | available | test1snap2   |
3 `0 h$ K9 o6 `8 l. \+ J, O3 s+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+


mysql -ucinder -p cinder  -h192.168.6.233
Enter password:
& m5 f5 x5 h( C: v5 dReading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

$ d  {, F* `# z  C: @Welcome to the MariaDB monitor.  Commands end with ; or \g.
/ j6 F% k0 K# mYour MariaDB connection id is 157266
Server version: 10.1.20-MariaDB MariaDB Server
8 i, Z6 @: ^" \6 {9 Z1 Z& X
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
; T! Z9 S: {4 U$ U9 _" V0 |, O
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
( Z2 Y8 A7 f/ O' }! j
MariaDB [cinder]>
MariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
4 O3 p, x) ^6 K- \| id                                   | volume_id                            | user_id                          | status    | display_name |
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
$ X8 V7 s' l% X| 6fdd4a5d-fb65-46bf-80c1-2716c5b4834a | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | 07ccc7c9772349a582e20f1e0ad5b054 | available | test2snap12  |
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
1 row in set (0.00 sec)
5 B- @  S- f" u2 w4 c/ |' L* S
% p+ r0 V- g8 KMariaDB [cinder]> select * from volume_glance_metadata where volume_id = '8ac8ded1-2ade-46de-8c2f-75ec9bf194af';
' `2 B; @# \7 J, @3 ^+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+
| created_at          | updated_at | deleted_at | deleted | id | volume_id                            | snapshot_id | key              | value                                |
! B" |, N- T' x( R$ d+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+
| 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' U8 w3 q3 ]3 U| 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                           |
) K* I% ?! l) h. D4 f  `+ e| 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                             |
+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+

  s" P$ ~1 L7 N9 b5 H; N( c8 rows in set (0.00 sec)
7 q+ I1 V! L: b
# y+ h8 i( S1 [/ ~: A
MariaDB [cinder]> delete from volume_glance_metadata where id='51';
4 Y# L$ Z" n! ~( q* R/ A. \/ LQuery OK, 1 row affected (0.00 sec)
) ^4 S* L7 \; W" y3 X. `2 i2 m  |* e
MariaDB [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';
& l" g0 {3 S4 BQuery OK, 1 row affected (0.00 sec)
+ K( a0 ]5 F8 g& @2 ~. t
MariaDB [cinder]> delete from volume_glance_metadata where id='60';
Query OK, 1 row affected (0.00 sec)

8 y8 C! Z. A3 T' VMariaDB [cinder]> delete from volume_glance_metadata where id='63';
Query OK, 1 row affected (0.00 sec)

2 f; [9 f3 {% c: `MariaDB [cinder]> delete from volume_glance_metadata where id='66';
7 K5 |5 i+ }8 i" E- \3 UQuery 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)
4 J: N2 ~- y0 R5 Q5 x6 |
MariaDB [cinder]> delete from volume_glance_metadata where id='72';
! C5 a- b- A- H- iQuery OK, 1 row affected (0.01 sec)
3 g- x+ l. i+ v7 Z7 O6 @
. g. x3 J# Q9 u9 Z4 X) _5 ]
( q9 _3 t' p! q2 P: R5 a5 XMariaDB [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 id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';
/ H9 ~5 D' {5 r4 g( T9 @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';
* B0 ^( _( o7 k5 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`))
MariaDB [cinder]>

8 Z  `$ t' h1 B7 {! D# C* R& C
0 ~- u. S1 C4 y7 U% ?% T

admin

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