|
|
[root@streamcontroller ~]# cinder service-list 0 C- K r2 v! R$ N
+------------------+-----------------------+------+----------+-------+----------------------------+-----------------+
+ T) P, ?4 h7 ^; L| Binary | Host | Zone | Status | State | Updated_at | Disabled Reason |+ n! v T) \, }! F7 Q' `/ h
+------------------+-----------------------+------+----------+-------+----------------------------+-----------------+
5 f) O* E& X9 p& [6 p; Q- _| cinder-scheduler | streamcontroller | nova | enabled | up | 2025-02-22T05:23:32.000000 | - |5 O6 W8 e( A: Q+ K8 C' i! H6 P0 s
| cinder-volume | rbd:images@images | nova | enabled | up | 2025-02-22T05:23:32.000000 | - |
) R* p- Y3 s! }8 x7 g; {5 || cinder-volume | rbd:volumes@volumes | nova | enabled | up | 2025-02-22T05:23:32.000000 | - |
* {& U% ` J) U) I. `0 y$ i* }. n| cinder-volume | streamcontroller@ceph | nova | disabled | down | 2025-02-22T05:02:19.000000 | - |$ p- t% S: O4 Y, t
+------------------+-----------------------+------+----------+-------+----------------------------+-----------------+, c- \* j6 C8 x. R
[root@streamcontroller ~]# mysql -uroot -p
1 P) T( ~5 j( g8 J2 IEnter password:
9 U r; {( v# Z! R2 Y' m6 iWelcome to the MariaDB monitor. Commands end with ; or \g.
1 v8 P7 H8 ~8 L. t3 D5 d6 LYour MariaDB connection id is 316: h/ W) w! y6 Q+ P$ u0 \
Server version: 10.5.27-MariaDB MariaDB Server# r" c- }1 a$ ~) w" h; Q o
) [) Z) d3 x% I$ Y# f
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.- `0 r; f8 p2 J% D4 O- ], Z9 @
$ v/ c: |0 Q& gType 'help;' or '\h' for help. Type '\c' to clear the current input statement." H" @7 N/ ~3 W' ~
, } Y3 O* q0 _' w
MariaDB [(none)]> user cinder3 u' {% w- |2 _1 d. h, B, l
-> ;0 _) w$ a) G2 A; ?
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'user cinder' at line 1
/ \: v/ K4 f9 s. J/ T* XMariaDB [(none)]> show databases;$ f- {# j8 g, b8 k; \- z' ]2 S
+--------------------+4 t! z# r7 U2 T- _4 l
| Database |, J5 n+ N0 _- C3 \+ {
+--------------------+
( s$ Z9 l. S9 r| cinder |: d- {9 V! l8 ~: R1 g0 ~0 N% R) b/ A
| glance |! Q+ [9 X7 N4 \1 U
| information_schema |
" ]' h6 D: m$ O: l. z( `9 h9 Y, }% z2 z' _| keystone |1 L# L3 _: O9 f( N9 a
| mysql |
' v9 S4 Q1 m X* D0 I| neutron |
0 A1 q* p7 b7 s' }| nova |. z3 Q. T+ o% O1 V' F
| nova_api |: q6 k7 @+ q" D( X
| nova_cell0 |
1 i$ e) f0 ]: N6 j| performance_schema |
2 Y$ u/ P0 K9 S/ ?/ M+ T+ p| placement |
6 i8 Z# a/ Z# ]# ?7 \5 E+--------------------+# [) t* w) ]1 F- \9 B) `
11 rows in set (0.044 sec)' ?6 j( Z1 I, Z( H% c/ S& t$ w8 |
4 C# u1 `* A/ b# pMariaDB [(none)]> use cinder
. z B, Z8 O- IReading table information for completion of table and column names! {: B' U8 k( Q. g( t
You can turn off this feature to get a quicker startup with -A
1 @! ?- ~9 m. L# ~* k
5 P3 Q u! h0 K; I: n* tDatabase changed( Z- B- k9 ~+ {: H$ y) ~" ~/ D
MariaDB [cinder]> show tables;4 c6 S( O1 X5 u7 y$ L
+----------------------------+6 ? U) S3 D% g1 x
| Tables_in_cinder |, t k$ W' n& r1 m
+----------------------------+* J$ P, f& M! L b1 E/ y
| alembic_version |
7 u, K6 K: U# t& l( z| attachment_specs |: I* P7 l; h3 s+ ]
| backup_metadata |
# m! r0 T2 t @0 W$ }| backups |
Q. i3 t Z3 B6 w| cgsnapshots |
) T* i2 R' k4 G7 v! K; D| clusters |- ^3 J2 x2 F) g8 S8 ~! c+ j4 E
| consistencygroups |
: g; c& u( ]# }3 P9 ]/ V| default_volume_types |" f @: @6 I' [% Q
| driver_initiator_data |
6 N W ~5 H( H( j% d| encryption |0 m1 Q# H& G q" g [1 G4 U
| group_snapshots |
* }+ o$ [, E7 z5 V5 }| group_type_projects |- `3 h1 B8 @* @9 {
| group_type_specs |
8 U4 y% f) \- d" i/ Z| group_types |
( K2 n+ r8 F2 b& k- k6 O| group_volume_type_mapping |/ p: i/ q4 I8 o5 K# |5 r' V# f2 N
| groups | A" }$ q" ]% c% R2 s9 V
| image_volume_cache_entries |
+ m# Y) g5 y3 ]3 _# G| messages |
- l$ `+ V# M3 X% ^/ g7 T| quality_of_service_specs |9 R3 F1 W0 \4 O$ f
| quota_classes |
6 N& V( M3 O: _| quota_usages |) E- h5 F: O4 q9 I+ k
| quotas |
% K" @& Q4 l& U3 s6 [, E$ {' T| reservations |6 @8 s+ \" [6 {0 _3 [1 L
| services |
- H" F, C% z. p: g- B| snapshot_metadata |
3 I6 ?. M* J. N! u) I- x| snapshots |
: v; T: Y8 |+ q- j9 Y, Y| transfers |
# C) F5 _; u! G5 r. W| volume_admin_metadata |
" _' f) `7 l9 D| volume_attachment |/ L+ q' ]/ E. c* w8 Z: x5 ~+ X
| volume_glance_metadata |
' `3 b1 G9 b* g1 T| volume_metadata |" F; @$ l8 E- i( }; z$ |4 q
| volume_type_extra_specs |
F( w, B' M- C( P4 L3 [4 S( \4 `" ?| volume_type_projects |0 L% a7 h" I0 `8 B
| volume_types |5 a, q( K' Z% _: Q3 z
| volumes |9 w* E9 p0 _$ i: h0 b5 h
| workers |5 M" J& ~% ?, x
+----------------------------+- l5 f. s! r" O8 L
36 rows in set (0.001 sec) U: @/ h5 K i F0 j
7 q: r- _% y+ e8 z& x7 d$ I# r
MariaDB [cinder]> select * from services;7 k7 Z# f3 n' {& c
+---------------------+---------------------+------------+---------+----+-----------------------+------------------+------------------+--------------+----------+-------------------+-----------------+---------------------+---------------------+------------------------+--------------------+--------+-------------------+--------------+--------------------------------------+/ r: T n; g) k& b0 }) E1 [9 L: C' K( M
| created_at | updated_at | deleted_at | deleted | id | host | binary | topic | report_count | disabled | availability_zone | disabled_reason | modified_at | rpc_current_version | object_current_version | replication_status | frozen | active_backend_id | cluster_name | uuid |
8 v; j5 @) E; B( x+---------------------+---------------------+------------+---------+----+-----------------------+------------------+------------------+--------------+----------+-------------------+-----------------+---------------------+---------------------+------------------------+--------------------+--------+-------------------+--------------+--------------------------------------+
# F" v& z1 m& C, [9 f| 2025-02-21 08:46:15 | 2025-02-22 05:24:42 | NULL | 0 | 1 | streamcontroller | cinder-scheduler | cinder-scheduler | 7311 | 0 | nova | NULL | NULL | 3.12 | 1.39 | not-capable | 0 | NULL | NULL | 25a9a766-4a38-4865-a579-20fc13311a1d |
) M6 G/ g5 Z" A- n0 {, k3 c4 ^1 \| 2025-02-21 08:54:12 | 2025-02-22 04:21:32 | NULL | 0 | 2 | streamcontroller@ceph | cinder-volume | cinder-volume | 0 | 1 | nova | NULL | 2025-02-22 05:02:19 | 3.18 | 1.39 | not-capable | 0 | NULL | NULL | 0842668e-c3d1-46e4-a06a-d49220948c49 |; B* z) g) V3 d+ F I- Q
| 2025-02-22 05:00:22 | 2025-02-22 05:24:42 | NULL | 0 | 3 | rbd:volumes@volumes | cinder-volume | cinder-volume | 39 | 0 | nova | NULL | NULL | 3.18 | 1.39 | disabled | 0 | NULL | NULL | 7cb2a139-c176-4195-8f8d-fffc81872145 |4 ~+ H0 B, E, w( s
| 2025-02-22 05:00:22 | 2025-02-22 05:24:42 | NULL | 0 | 4 | rbd:images@images | cinder-volume | cinder-volume | 39 | 0 | nova | NULL | NULL | 3.18 | 1.39 | disabled | 0 | NULL | NULL | 14a90401-32ec-482e-94fd-d36e46e8f823 |
2 O. ?0 p1 l6 J# q" L" S, V+---------------------+---------------------+------------+---------+----+-----------------------+------------------+------------------+--------------+----------+-------------------+-----------------+---------------------+---------------------+------------------------+--------------------+--------+-------------------+--------------+--------------------------------------+
6 q7 o7 P1 Q& {0 J8 A$ K# p; A3 L4 rows in set (0.001 sec)
, d6 l+ v" T' _& F3 x' X8 M1 C: I" U/ E4 e3 Y/ R
MariaDB [cinder]> select * from services\G;
* }8 K" a$ e6 z6 A. N' }*************************** 1. row ***************************
9 x3 ~8 \% z; j& r$ M created_at: 2025-02-21 08:46:15* v) r3 h' W- i$ ]
updated_at: 2025-02-22 05:24:52
) N: F, c6 k$ f: `, [/ V deleted_at: NULL
$ r8 d7 i0 P/ e+ j4 ]! K7 `. C deleted: 0
" |$ _1 c% u: T2 [ id: 1
8 ^- N9 e$ h& b2 q host: streamcontroller# f9 n V" R, r, x/ i$ p
binary: cinder-scheduler
: Q) v, o L/ m topic: cinder-scheduler
4 w: }# a$ y- C/ D3 b report_count: 7312( l- a0 L* v* I4 m
disabled: 0
& E- V |' e) q* y; @ availability_zone: nova& D [5 y+ ?; m
disabled_reason: NULL
9 V. d K. q6 m0 |: M modified_at: NULL: g& _4 ^4 S- x
rpc_current_version: 3.126 F5 e3 Z' N# m: V
object_current_version: 1.39
7 v1 r t. l& u replication_status: not-capable ]# D. k/ X/ q3 w( r( s
frozen: 0
& u' E7 I% l8 A4 i7 k active_backend_id: NULL
( f$ n) U4 l: j cluster_name: NULL
9 G( D% v$ p, Z uuid: 25a9a766-4a38-4865-a579-20fc13311a1d2 R8 @: [" W6 v1 y* O4 y3 p
5 `9 y1 S& r+ [4 w4 m
查询相关语句：
* Y6 z- }) V: V( g( xMariaDB [cinder]> select id,uuid,host,deleted from services;
( U% Z% A8 ^3 W' j; x6 }2 c+----+--------------------------------------+-----------------------+---------+* x- G- u( t2 P# b! `0 i
| id | uuid | host | deleted |
$ C7 F; Z" q2 N) |- v- n+----+--------------------------------------+-----------------------+---------+( H0 o2 P4 i4 M8 K1 b# W. V7 r
| 1 | 25a9a766-4a38-4865-a579-20fc13311a1d | streamcontroller | 0 |
B Q( i% q- X( O, I i2 \| 2 | 0842668e-c3d1-46e4-a06a-d49220948c49 | streamcontroller@ceph | 0 |
8 d6 v& S2 k: t- c| 3 | 7cb2a139-c176-4195-8f8d-fffc81872145 | rbd:volumes@volumes | 0 |
3 f$ L7 J' d8 ?, r| 4 | 14a90401-32ec-482e-94fd-d36e46e8f823 | rbd:images@images | 0 |
6 D* X) @* }7 j/ X( w+----+--------------------------------------+-----------------------+---------+
4 y! }' v3 J, h# \4 rows in set (0.001 sec)2 e% B, d; T! R2 l9 u
8 J' G6 K# o' O/ K/ c设置状态deleted为1：
. w j; W! ]5 J; w7 {
$ b5 T, m4 @' B% @: J' Y0 d) bMariaDB [cinder]> update cinder.services set deleted='1' where uuid='0842668e-c3d1-46e4-a06a-d49220948c49';
2 q: h- }! L' E* Y HQuery OK, 1 row affected (0.001 sec)
9 ?; P7 r W3 g+ c/ Q- d+ b* N: NRows matched: 1 Changed: 1 Warnings: 0. M& {8 S' ~7 V+ a' B6 A: b
; m9 `: w) Y1 N7 _1 B6 yMariaDB [cinder]> select id,uuid,host,deleted from services;
) v# H3 p+ z- u v+----+--------------------------------------+-----------------------+---------+
9 c* \2 T' q, G4 l/ w/ M| id | uuid | host | deleted |- Q: }( t# V% E8 p4 U6 J
+----+--------------------------------------+-----------------------+---------+
5 _* Q w' a! `: `| 1 | 25a9a766-4a38-4865-a579-20fc13311a1d | streamcontroller | 0 |2 F0 Q9 e" G, V, V) q% O( S
| 2 | 0842668e-c3d1-46e4-a06a-d49220948c49 | streamcontroller@ceph | 1 |
* ]( m. ~' O) t' || 3 | 7cb2a139-c176-4195-8f8d-fffc81872145 | rbd:volumes@volumes | 0 |
& l6 ^2 r/ d! E2 o) P9 U( d3 Z| 4 | 14a90401-32ec-482e-94fd-d36e46e8f823 | rbd:images@images | 0 |
6 Y3 J6 {- A, n" K8 P& X' B+----+--------------------------------------+-----------------------+---------+
: L% d' C: x- i/ h6 D2 @4 rows in set (0.001 sec)
E: ?& n7 h. h, b. M" k! R( O# |4 G1 f1 y0 a9 M& h* ]
再次检查状态： ] K. N7 g4 e$ j' i
[root@streamcontroller ~]# cinder service-list , Y( B; A3 o! m0 k8 x* L
+------------------+---------------------+------+---------+-------+----------------------------+-----------------+/ `" L( F! U* m- s# \
| Binary | Host | Zone | Status | State | Updated_at | Disabled Reason |
& ^1 s7 I# h! ]0 E: u5 U+------------------+---------------------+------+---------+-------+----------------------------+-----------------+
0 A* m+ X% ^' [6 B| cinder-scheduler | streamcontroller | nova | enabled | up | 2025-02-22T05:31:32.000000 | - |4 \5 m& _$ U, N5 y# J
| cinder-volume | rbd:images@images | nova | enabled | up | 2025-02-22T05:31:32.000000 | - |
# W% _' l. G2 @% L| cinder-volume | rbd:volumes@volumes | nova | enabled | up | 2025-02-22T05:31:32.000000 | - |
7 s8 v4 b$ [- H5 D$ ?5 l+------------------+---------------------+------+---------+-------+----------------------------+-----------------+
" j' c, o- C" d& s4 c7 }; r' o! {0 [; L3 t9 B
4 {2 K2 ~% e$ e4 `
& R. h1 Z2 C) e; k: J, t
|
|
发表于 2025-2-22 13:31:39