|
|
[root@streamcontroller ~]# cinder service-list
. E) u2 \3 i- x u$ ]9 {) \8 I+------------------+-----------------------+------+----------+-------+----------------------------+-----------------+
! G+ U/ @6 I& r7 N3 J| Binary | Host | Zone | Status | State | Updated_at | Disabled Reason |
1 v/ @4 s, W2 u: V+------------------+-----------------------+------+----------+-------+----------------------------+-----------------+0 S e! c, h1 k0 R
| cinder-scheduler | streamcontroller | nova | enabled | up | 2025-02-22T05:23:32.000000 | - |
; W, C( s7 ?' a% F| cinder-volume | rbd:images@images | nova | enabled | up | 2025-02-22T05:23:32.000000 | - |
1 h# d1 w: l$ h% T: z| cinder-volume | rbd:volumes@volumes | nova | enabled | up | 2025-02-22T05:23:32.000000 | - |
6 G9 U, f6 A5 X! o* N) g| cinder-volume | streamcontroller@ceph | nova | disabled | down | 2025-02-22T05:02:19.000000 | - |
/ o8 o* u h# s4 @4 j+------------------+-----------------------+------+----------+-------+----------------------------+-----------------+9 }9 ^; t/ k8 k
[root@streamcontroller ~]# mysql -uroot -p- L7 {3 I! h# A2 i. p& d
Enter password: 4 X- S! d8 {, }9 J# q& J1 I$ A8 o
Welcome to the MariaDB monitor. Commands end with ; or \g.: E. i' c* O8 b1 b
Your MariaDB connection id is 316
9 Z' t* ?) `" ~% B% E- S9 `: |5 fServer version: 10.5.27-MariaDB MariaDB Server1 t$ j' O+ J8 V9 x- X5 Z
- u& u& b0 n7 w: \& _/ {! M8 w
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
# s4 H U1 l8 l9 k: S. g# O& n5 l6 l) \: n
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.! {$ [0 M0 V; ~' \
0 _4 I( |0 w1 n) H5 g7 U" W% s" c2 tMariaDB [(none)]> user cinder
" R5 t5 s! u3 Y( H9 L -> ;# Q7 {, F0 v5 G" L+ i6 C
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 15 ^$ a. P' @) L8 e: e
MariaDB [(none)]> show databases;
. B' n/ I; C" q! s; C( Y+--------------------+/ o- P% K6 T4 N4 R3 v" X3 d
| Database |. q' r, {7 [. I# H8 J- ?
+--------------------+
; v/ ?( a! [5 K9 K- D! [| cinder |
1 ]: w% ?: f% Z; |: \; ]| glance |
7 i- G, O [4 X+ y6 J) N| information_schema |
- c1 S% |6 p K, R) v| keystone |
- g2 b1 M! e: V0 }3 y) w0 Z+ `# Y+ f| mysql |. ~! ?$ q; i4 V3 W4 j/ W
| neutron |- q) L# ~( l! F4 y% h; i
| nova |
2 u7 d. @( i9 \7 E! o1 o8 f. K| nova_api |+ P- N9 y) A) y( K. m3 q
| nova_cell0 |
: C1 N7 d; Q9 }; N/ N6 @7 B6 s3 t- y| performance_schema |3 N3 a6 d) d% Y& P$ `" @" o n
| placement |
: b- I( u" L7 m; T" f+--------------------+; B9 c8 F1 `( p7 ^" l$ x
11 rows in set (0.044 sec)
. a4 t* }" g7 H! }$ B# G- n
. `5 ^) ` J3 i) M$ X& RMariaDB [(none)]> use cinder
# {" p6 d' Y- O/ PReading table information for completion of table and column names
* V4 y$ @; X7 H+ [, yYou can turn off this feature to get a quicker startup with -A
2 ~0 F6 r1 r$ a/ k# x
* B( L. w; c6 TDatabase changed
, C5 ^- N, `7 Q; e2 pMariaDB [cinder]> show tables;. g; D# Z5 O+ p3 m, b8 a i7 b0 U7 ]
+----------------------------+( u" }1 A1 h( g6 x
| Tables_in_cinder |
r# A/ j U9 i7 Z+----------------------------+ T2 d: ?4 o' Q( Z( o
| alembic_version |
& E2 L+ {; X" b) J! w| attachment_specs |- f5 z/ J( v9 ]% i3 q' y- X
| backup_metadata |
* s) a. J) [8 U6 r0 o! L; l| backups |( d, m, L1 O3 \
| cgsnapshots |
( L' s9 P$ [9 I- A0 C| clusters |8 n) z" F c2 Q
| consistencygroups |
! L' B+ Y% C. z| default_volume_types |( L4 d6 R( a' d8 S
| driver_initiator_data |; j( j) T2 J! g# r v% n( d
| encryption |
5 K, n0 d# J% Z$ t" n| group_snapshots |3 J9 _6 K4 R! M5 C
| group_type_projects |
' @/ N, `& n$ I! G| group_type_specs | N. J' M4 G# p. v& H7 N9 p. T8 P
| group_types |
: _& `5 W4 F- ?9 x; B' U| group_volume_type_mapping |
5 T5 }2 M- \5 _3 n| groups |8 ~' |! v u' k; q5 E
| image_volume_cache_entries |4 F" R. b. w2 f. L* F( E+ C7 c% S" {
| messages |) o) ?9 G9 {) s& g* S8 H4 C
| quality_of_service_specs |
& v1 O+ r' z( D# y+ V' ] C6 j/ X5 C| quota_classes |
& x+ Z" J; I" a/ O: N c| quota_usages |% e; O, @0 ?! t4 U
| quotas |
4 f: s6 _# O( s* ?| reservations |
) i3 m* q1 Q' n& M% B& E( `( e| services |% a6 y& x4 n j8 x
| snapshot_metadata |
; B" Z* \+ f+ s1 G) K. m5 a| snapshots |( g: E7 b( ]6 q& [/ W! d# i, @, ?$ _
| transfers |
4 v; M& B: E+ H \% r3 R: _) G% p| volume_admin_metadata |
9 U6 Y( m1 \0 J4 F# k| volume_attachment |
+ _! s0 C* G3 l/ I; _2 g: j* j$ Z9 e: Y| volume_glance_metadata |& D. R2 b, `, E
| volume_metadata |
0 p+ z) p% b/ _# u& @/ R7 x| volume_type_extra_specs |
2 j5 ]9 d: C+ y9 X* X+ h- T( q| volume_type_projects |! K6 D; e& f: P2 v
| volume_types |
; f6 H; J+ k: S8 L| volumes |0 a6 J7 i0 O1 U( |2 }5 A, {
| workers |+ ]" Y6 @1 ^! l& h) I
+----------------------------+7 A2 m( w" P* ~+ y
36 rows in set (0.001 sec)7 K6 k, ~! e4 n; z0 F# c1 O+ r
- s: e: \/ Q7 b9 k9 P& s
MariaDB [cinder]> select * from services;$ D/ `1 C6 m5 ~2 ~% J* Q
+---------------------+---------------------+------------+---------+----+-----------------------+------------------+------------------+--------------+----------+-------------------+-----------------+---------------------+---------------------+------------------------+--------------------+--------+-------------------+--------------+--------------------------------------+( B( s" g, q2 K- h
| 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 |0 [! {. ?1 t) S5 s& n
+---------------------+---------------------+------------+---------+----+-----------------------+------------------+------------------+--------------+----------+-------------------+-----------------+---------------------+---------------------+------------------------+--------------------+--------+-------------------+--------------+--------------------------------------+3 z" Q7 x. O, ~* a9 [: ^
| 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 |; {9 l$ m$ T2 x) d
| 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 |
7 B( y% ]8 i" M+ C: r+ [9 U| 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 |
# @1 D$ Z! f0 `+ w# D& t| 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 |! ?. E; Q/ L6 d: k S
+---------------------+---------------------+------------+---------+----+-----------------------+------------------+------------------+--------------+----------+-------------------+-----------------+---------------------+---------------------+------------------------+--------------------+--------+-------------------+--------------+--------------------------------------+. V9 a. o9 U5 u" A: l7 h6 z
4 rows in set (0.001 sec)9 R) Y* ]3 q* c% e& U: H9 T% m$ c: @
; h$ h- x$ n5 C# o. u3 d
MariaDB [cinder]> select * from services\G;; w! f; ~% j, v# A" `3 k4 M8 z Q
*************************** 1. row ***************************
9 W' F! o9 C( P; Z9 ?+ L created_at: 2025-02-21 08:46:15
! b+ H' @. a+ r. _5 e! J8 I updated_at: 2025-02-22 05:24:52/ n' D( |# P6 ?! L+ G' _5 V
deleted_at: NULL$ Q0 F1 g4 @: u# A% Q/ T
deleted: 0! r Z( t7 b# x8 {4 @
id: 11 l* I& y0 f$ P. s1 K( f. n4 j8 s, L
host: streamcontroller, P/ q! j5 Y; c, {: @% r
binary: cinder-scheduler% x. z# `& x m2 S
topic: cinder-scheduler
y3 C4 u3 U- G A0 B. |1 [ report_count: 7312
' x y6 T' n3 o5 C+ Q disabled: 0
6 n5 k7 L, S& i$ M8 f$ g ~" p8 N availability_zone: nova
8 O. y* F/ K* R n: F disabled_reason: NULL
* a+ G/ f4 r g3 I1 \: z, F modified_at: NULL: g6 h" l; n% H0 d9 S
rpc_current_version: 3.12
2 U! V/ M& U- ?object_current_version: 1.39
8 A, B5 W; f7 ^" \8 h' h9 M replication_status: not-capable
1 \8 ~) P5 l' p0 p& _4 v/ b9 Z frozen: 0! }# C- o: I. J( j
active_backend_id: NULL) D7 T7 ?4 I" Y U: E- o* @! u
cluster_name: NULL
6 X: C, T; h: m C uuid: 25a9a766-4a38-4865-a579-20fc13311a1d! q* P9 L. Z7 d# A5 A- S. T" T
' w* m9 v* P) a, y) R查询相关语句：: A3 R7 w6 A. n3 l
MariaDB [cinder]> select id,uuid,host,deleted from services;7 ^" L8 H y; W- }7 j6 k- E0 \# Y0 U
+----+--------------------------------------+-----------------------+---------+
, l) m, G: S* L# J' H& ^| id | uuid | host | deleted |& U4 J6 R& K4 y
+----+--------------------------------------+-----------------------+---------+) e! X: p' U" ~4 i+ p$ C4 F% ~# B
| 1 | 25a9a766-4a38-4865-a579-20fc13311a1d | streamcontroller | 0 |5 A* ]4 _ d' a0 T7 F6 I6 u: j X
| 2 | 0842668e-c3d1-46e4-a06a-d49220948c49 | streamcontroller@ceph | 0 |
0 V2 _; }( N+ v| 3 | 7cb2a139-c176-4195-8f8d-fffc81872145 | rbd:volumes@volumes | 0 |
9 O1 \% r; z. i2 t+ Y( o| 4 | 14a90401-32ec-482e-94fd-d36e46e8f823 | rbd:images@images | 0 |; s: b8 A/ p1 ~* j% d7 H
+----+--------------------------------------+-----------------------+---------+4 P, T; }, { N% q) t
4 rows in set (0.001 sec)
$ S5 R6 ]9 d* n% }
$ C& W1 C, N( r$ ?8 v- k. F设置状态deleted为1：. I1 g' M7 K4 [5 l( L, j
1 a% C$ O$ b+ |; w
MariaDB [cinder]> update cinder.services set deleted='1' where uuid='0842668e-c3d1-46e4-a06a-d49220948c49';
4 L' v3 J" w! I: E+ m% d% UQuery OK, 1 row affected (0.001 sec)! q4 J$ n/ l: m+ B" [
Rows matched: 1 Changed: 1 Warnings: 05 E% B5 v. j# E/ t0 ~/ k
/ b# E2 E% T/ r) ~
MariaDB [cinder]> select id,uuid,host,deleted from services;
# U4 t* ~( Y' x0 m+----+--------------------------------------+-----------------------+---------+
* l: j; w8 C' l }| id | uuid | host | deleted |1 y1 L7 _; L4 _
+----+--------------------------------------+-----------------------+---------+1 m- ]( P- }0 T4 v" r! Q. {7 j
| 1 | 25a9a766-4a38-4865-a579-20fc13311a1d | streamcontroller | 0 |
1 q$ ?/ P8 j3 x& [' g: V9 N, s* B| 2 | 0842668e-c3d1-46e4-a06a-d49220948c49 | streamcontroller@ceph | 1 | M. l+ o8 a- n. h% B0 O
| 3 | 7cb2a139-c176-4195-8f8d-fffc81872145 | rbd:volumes@volumes | 0 |
% D* {" y5 z/ b; F7 U- h3 ~| 4 | 14a90401-32ec-482e-94fd-d36e46e8f823 | rbd:images@images | 0 |
; V" A* ?: y/ J& ^# U3 V+----+--------------------------------------+-----------------------+---------+
# x; z M E, G5 C1 S1 K0 i6 P4 rows in set (0.001 sec); F) `& H* Y) A! x" F$ d! |
/ P0 F: b: f7 H
再次检查状态：
: p) r1 H+ B- R[root@streamcontroller ~]# cinder service-list
$ J- v& f1 h. W( D0 v9 t/ m+------------------+---------------------+------+---------+-------+----------------------------+-----------------+2 }6 h# R7 }: M: P: A) n
| Binary | Host | Zone | Status | State | Updated_at | Disabled Reason |4 c/ w9 \/ J4 a$ E
+------------------+---------------------+------+---------+-------+----------------------------+-----------------+2 R" w. f$ f# _# u3 l- n
| cinder-scheduler | streamcontroller | nova | enabled | up | 2025-02-22T05:31:32.000000 | - |
6 {2 v8 C# o% Z* w7 ~# N% ~, C| cinder-volume | rbd:images@images | nova | enabled | up | 2025-02-22T05:31:32.000000 | - |
4 Z, @# g: t/ H; }9 s4 B| cinder-volume | rbd:volumes@volumes | nova | enabled | up | 2025-02-22T05:31:32.000000 | - |6 m4 E9 L. n+ b/ R
+------------------+---------------------+------+---------+-------+----------------------------+-----------------+
2 q* ^$ d+ K! b* g0 P* t1 y+ L' m. L& j: x% l
4 _! j" m9 P) A( X: n8 r1 \4 {3 B( ]* h; \' V+ y l
|
|
发表于 2025-2-22 13:31:39