找回密码
 注册
查看: 2377|回复: 1

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

[复制链接]

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
发表于 2021-5-19 15:49:39 | 显示全部楼层 |阅读模式
MariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '71146765-659d-47c9-9682-5e077461f6ba';
. w: u: I' |2 n. B6 h+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
% X  a3 \; {, b+ N, || id                                   | volume_id                            | user_id                          | status    | display_name |* o0 z/ F; T4 k( w8 m% F( r
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
4 q8 V1 N" k% q| 71146765-659d-47c9-9682-5e077461f6ba | ff5717c6-301d-48a3-9833-9b1722557903 | 07ccc7c9772349a582e20f1e0ad5b054 | available | test1snap2   |. q4 k' P6 C3 s0 R
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
; [7 R8 g* T" W2 w& I9 g- R8 a/ d2 K! L) ?
# `( @  F# e9 T/ R
mysql -ucinder -p cinder  -h192.168.6.2334 ^% O. K/ f: }- u/ b7 i& z9 v4 [
Enter password:
& W( F% p% N+ f& _# M- g# o% MReading table information for completion of table and column names% K# {6 c' {/ T1 M: i( n) Z5 O# v9 |
You can turn off this feature to get a quicker startup with -A
1 [8 s" v9 N  K2 H
- P- G- Q7 j* J2 h5 W6 OWelcome to the MariaDB monitor.  Commands end with ; or \g.
, X8 u: a' j4 W7 i' wYour MariaDB connection id is 157266/ n# M& G, q) P- h( _; E; L& w
Server version: 10.1.20-MariaDB MariaDB Server
4 L% d7 ^# Q9 ?
' ~7 N; j, L& \, I6 `Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
4 d& D, b) H0 p$ F+ q3 p: F
. ?, u# B3 y- e* w1 |$ NType 'help;' or '\h' for help. Type '\c' to clear the current input statement.
/ \9 {( \7 I& @$ v6 U# p- T' E* q+ v. U
MariaDB [cinder]> 7 I8 U/ Z; B( u4 i) Q9 m6 ^
MariaDB [cinder]> select id,volume_id,user_id,status,display_name from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';0 j% |# w( j+ t' k: L0 _, C4 y
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+1 q. l0 ^0 ^9 Y# H/ L0 h9 p; G" m
| id                                   | volume_id                            | user_id                          | status    | display_name |, ?& }" s# R: m9 J. z/ ^; L
+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------+
$ N; D& `8 D; V1 g9 R  z/ s  q| 6fdd4a5d-fb65-46bf-80c1-2716c5b4834a | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | 07ccc7c9772349a582e20f1e0ad5b054 | available | test2snap12  |
: F: K% c$ [. p: ?6 r# T- b+--------------------------------------+--------------------------------------+----------------------------------+-----------+--------------++ u) @9 y/ b- X- ~
1 row in set (0.00 sec)- c9 H% W+ m0 E, n, t3 e

- ^0 j7 e0 I/ y  b) EMariaDB [cinder]> select * from volume_glance_metadata where volume_id = '8ac8ded1-2ade-46de-8c2f-75ec9bf194af';& |+ g. y- u* ^
+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+& r7 h1 E! a3 f0 X; a6 l
| created_at          | updated_at | deleted_at | deleted | id | volume_id                            | snapshot_id | key              | value                                |
" C" \  I( g% X2 m4 a+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+
7 g+ h9 m# O7 H0 H! C| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 51 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | container_format | bare                                 |
  B+ D0 h" j+ s* G" e4 J| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 54 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | min_ram          | 0                                    |. V0 Q6 K1 x9 h- s# m
| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 57 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | disk_format      | raw                                  |
: g7 j# L) X5 W" L' L| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 60 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | image_name       | cirros-0.4                           |
) S9 L* D! W2 G2 p1 i| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 63 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | image_id         | 5062aa42-bb5e-4793-964f-b6dcc61d5fc6 |
8 l1 m2 B: Y1 m" ^6 Q| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 66 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | checksum         | 443b7623e27ecf03dc9e01ee93f67afe     |' l* g; P: v5 ?7 C! p3 z+ t$ w* l5 m
| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 69 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | min_disk         | 0                                    |
/ p& W1 i1 r/ ^| 2021-05-18 07:08:10 | NULL       | NULL       |       0 | 72 | 8ac8ded1-2ade-46de-8c2f-75ec9bf194af | NULL        | size             | 12716032                             |2 Z* K8 |" P3 _/ ^, Y7 K4 x& P
+---------------------+------------+------------+---------+----+--------------------------------------+-------------+------------------+--------------------------------------+' e% V; `+ R" V5 x6 j
& A+ G- [( @7 y( [4 ^+ D
8 rows in set (0.00 sec)
4 G% ?$ R8 p, p  ~+ p9 L% V% L9 v3 y; W- @

5 K6 y% K% f& R0 ]& ^MariaDB [cinder]> delete from volume_glance_metadata where id='51';
; c% z: b) x7 JQuery OK, 1 row affected (0.00 sec): W2 x  K. d7 \* q( S" `" Q2 p. |
4 `0 x5 d: m2 d) ]2 T, a% e! x
MariaDB [cinder]> delete from volume_glance_metadata where id='54';! \6 h6 d4 ~5 |3 Y& L
Query OK, 1 row affected (0.00 sec)
0 Y- l+ m% ]/ k* D# u( n7 X$ j# ~/ o5 n1 N; K  \
MariaDB [cinder]> delete from volume_glance_metadata where id='57';8 o+ v# ]. F; ]7 V# o% G
Query OK, 1 row affected (0.00 sec)' [7 }. a1 Z  \- J( y
' n+ [7 `; g( p2 Z2 y( b$ u; E) `
MariaDB [cinder]> delete from volume_glance_metadata where id='60';
) E( P" g" l, nQuery OK, 1 row affected (0.00 sec): `+ k$ k0 ^( K  o

5 N' j1 C$ c3 T$ v  J# E+ `3 g  ?  vMariaDB [cinder]> delete from volume_glance_metadata where id='63';" \. I6 G  k6 j% Q
Query OK, 1 row affected (0.00 sec)
1 g! L! v; m: p9 H
" P; ^4 T# ]  d: X, [4 K2 @MariaDB [cinder]> delete from volume_glance_metadata where id='66';
: x$ R; L* z" c2 r7 P3 q  Y* |! BQuery OK, 1 row affected (0.00 sec)% W% o, P+ O: N3 }- q: r, W0 z0 ~- z
% q4 y) g; n# L2 K; f
MariaDB [cinder]> delete from volume_glance_metadata where id='69';- v) ~1 b5 _/ `* {. V: _& |
Query OK, 1 row affected (0.01 sec)7 B# R& [6 I& B) p' X

) S% Z7 c# j2 sMariaDB [cinder]> delete from volume_glance_metadata where id='72';
) {6 H- P& @% XQuery OK, 1 row affected (0.01 sec)6 I; H0 i, _4 f; j% {

, u  o% u0 Y& v% d
1 O; g- ]+ m. o$ HMariaDB [cinder]> delete from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';. w6 H/ U7 d# j7 N8 [7 [, R. r0 q" r
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`))( a! q' K$ E- [' |6 `
MariaDB [cinder]> delete from snapshots where id= '6fdd4a5d-fb65-46bf-80c1-2716c5b4834a';
3 @- F/ [% \3 R8 h  RERROR 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`))
' s5 X4 y' g2 ~  A4 QMariaDB [cinder]> delete from snapshots where volume_id= '8ac8ded1-2ade-46de-8c2f-75ec9bf194af';% n1 a- F0 B$ E6 L6 h7 m/ S
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`))) E( V9 \, z' n
MariaDB [cinder]>
5 {, F  n: S7 Z+ f$ J6 Z# J2 T& N) S* F( D
8 x7 w' ^  [# H7 z
0 t" C& a) U: Y4 I9 s2 D! u
0 Q& Y4 e# n( |5 F( v/ ]# A

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2021-5-19 17:25:49 | 显示全部楼层
未找到原因,通过界面可以删除。建议不要随便删除数据库数据,否则会导致数据库缺少数据字段。
您需要登录后才可以回帖 登录 | 注册

本版积分规则

返回首页|Archiver|手机版|小黑屋|易陆发现技术论坛 ( 蜀ICP备2026014127号-1 )

GMT+8, 2026-6-12 00:17 , Processed in 0.018665 second(s), 22 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

快速回复 返回顶部 返回列表