|
|
[root@streamcontroller ~]# cinder service-list + O3 u2 v( A, @; e& d6 D% I f
+------------------+-----------------------+------+----------+-------+----------------------------+-----------------+7 {7 \! C6 Z+ |& V3 y- r5 z3 T
| Binary | Host | Zone | Status | State | Updated_at | Disabled Reason |
, Y f! v( `2 M6 m+------------------+-----------------------+------+----------+-------+----------------------------+-----------------+4 I1 i" E R0 g
| cinder-scheduler | streamcontroller | nova | enabled | up | 2025-02-22T05:23:32.000000 | - |2 P" d" L$ \9 n& Y
| cinder-volume | rbd:images@images | nova | enabled | up | 2025-02-22T05:23:32.000000 | - |
, o ?+ K. P, B6 w8 A9 l| cinder-volume | rbd:volumes@volumes | nova | enabled | up | 2025-02-22T05:23:32.000000 | - |
6 W/ S, c2 U, u| cinder-volume | streamcontroller@ceph | nova | disabled | down | 2025-02-22T05:02:19.000000 | - |
1 c/ E4 ]5 X6 V- c) V- e+------------------+-----------------------+------+----------+-------+----------------------------+-----------------+
! \: k$ p r! K H. h' o0 h[root@streamcontroller ~]# mysql -uroot -p: Y5 n" t! e d- j) A
Enter password:
V8 T8 V4 M' g( O$ B+ JWelcome to the MariaDB monitor. Commands end with ; or \g.
; e' O- B& [0 e# } hYour MariaDB connection id is 316) ]- n9 t. G+ t+ ` e7 N4 [
Server version: 10.5.27-MariaDB MariaDB Server
* Q8 b. l3 ]" N1 @) t2 x( m! ^4 R' ~
$ Y- v0 B7 b- }. ICopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.' ? X( R7 K( V7 T3 D, K3 ]
9 Z9 U/ B. C+ d* F2 w) |9 lType 'help;' or '\h' for help. Type '\c' to clear the current input statement.: i# x1 J- f) [
0 z' X( q( i# B- l; w; T
MariaDB [(none)]> user cinder
U. o0 I# S& {5 K/ [, Y& Z -> ;9 J1 l7 P, U7 ~/ B$ X
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
! d% N: {9 ^, R$ F& o# mMariaDB [(none)]> show databases;8 b Y) `9 w* K" m2 t0 N
+--------------------+
0 m. [3 X5 ]% j6 N: p2 B( a| Database |
4 p5 P& Y/ q. }9 g4 T0 o+--------------------+
% L& R% D6 |1 _# E2 T( ^4 o| cinder |9 R" i M" t; k( {, F0 i3 @
| glance |" [# t& d. R7 Y/ ?4 |1 p6 @# O G, Q/ T
| information_schema |
+ s8 ^5 L; R, Q8 O; W| keystone |
& R( v8 @+ T8 Y% z| mysql |
3 \" u/ A4 q/ i. M. V, @$ G( N5 B| neutron |; \* J% Z) z, v9 [* j. m
| nova |
7 C# D% r* C. P+ g$ Q* W| nova_api |
) U& J3 ?3 T2 p2 g) B| nova_cell0 |
( K1 O. S/ W" k3 S| performance_schema |( e+ q: t( q, y' p6 {" \: T. J: ]
| placement |8 e( o; I! _) T+ \8 I- r0 } s
+--------------------+
/ g6 R9 S0 X! B11 rows in set (0.044 sec)
( I" C/ n6 N2 |: |/ J& K, M3 u3 }! G8 g. W3 k
MariaDB [(none)]> use cinder
2 w" c. E) p9 _5 o! ?' K3 RReading table information for completion of table and column names* e2 k0 I% n3 o i4 z0 ^
You can turn off this feature to get a quicker startup with -A
+ {& V! F# h# ?
! k) B: t9 o) u. D8 hDatabase changed& I! y' W' D' E( A L/ D" R; ]' F8 L
MariaDB [cinder]> show tables;' j' ?! l s' y, S4 q2 Z
+----------------------------+8 {+ D# s0 F# v: t4 N' b
| Tables_in_cinder |
5 K6 y; t& s1 s, M+----------------------------+( j! P: k2 ~# r+ g# E4 W5 g9 |
| alembic_version |
" q3 y# y" F, S& V, m$ H| attachment_specs |
x5 `' X" E9 R' S! e/ I1 || backup_metadata |
\# V% f+ A- ~9 D4 q( H: L| backups |
/ F ?, W6 Q: O! X6 Z( Z: v5 \| cgsnapshots |
: }* u- `/ q) L" K| clusters |
1 Z9 |) t1 m4 c/ E; z4 a| consistencygroups |! \$ f. R) W8 Q( v+ j V, z
| default_volume_types |$ y& g4 ^# Z, i; c7 `7 W: a
| driver_initiator_data |, x9 M( J0 \) L* r6 J
| encryption |
& p7 n; ^5 Y/ P1 L7 ]7 E4 g$ }0 b/ M| group_snapshots |" q. {9 c8 }0 ]# i
| group_type_projects |
9 n Y5 ^* m3 x" L; {2 H| group_type_specs |
* T) E, Q2 @! Z/ U \& R; m| group_types |# u H+ Q! e" C- D" y! H* _1 z0 v
| group_volume_type_mapping |& }' B) [" }9 D
| groups |% b( q* X6 e# q4 O" E- y* N R% ^
| image_volume_cache_entries |' g! I$ q# s# K0 Y0 N
| messages | K5 ?! {! V# m/ V2 I
| quality_of_service_specs |# _1 ^, K) V% N0 e9 J
| quota_classes |
) K2 f! Q2 Q* I7 Q| quota_usages |( A" m* ~! B' J$ @
| quotas |
) b4 i: n: E, j/ z& A| reservations |
+ h( i E3 L, i' y/ ~( W6 ^| services |5 j4 l. c0 l" f/ M" a/ l/ h$ F7 a2 k- E
| snapshot_metadata |
8 m/ [3 s3 W# I; u3 G. T! ~| snapshots |
5 w% o$ `* t: c: z- G| transfers |
9 k% |. ~# ~ g' [- g| volume_admin_metadata |
1 V% {. U+ _1 l/ {| volume_attachment |; X6 f+ b* q" U, D1 Q5 F) r1 f+ i
| volume_glance_metadata |& J9 p9 c; D4 M$ m& {8 G
| volume_metadata |6 B! S! x8 g% m+ v# G
| volume_type_extra_specs |9 c7 _4 v& F/ S
| volume_type_projects |
& }. ?# G) p8 f$ ]1 l| volume_types |! O- Q* O: `8 H; z& q
| volumes |: K1 s0 F) V* M0 W) S# l
| workers |
( N! y+ @) f z6 ~+ f( R3 T& j9 ^+----------------------------+
+ B' ^& K3 W4 i36 rows in set (0.001 sec); \. M+ ~7 m8 {
: h J/ `# W* R. r9 G" HMariaDB [cinder]> select * from services;
2 i3 g' A5 @( V7 K5 F3 F+---------------------+---------------------+------------+---------+----+-----------------------+------------------+------------------+--------------+----------+-------------------+-----------------+---------------------+---------------------+------------------------+--------------------+--------+-------------------+--------------+--------------------------------------+: F H' u4 Y' p2 c) G: ?
| 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 |
9 I0 } _" ^: s+---------------------+---------------------+------------+---------+----+-----------------------+------------------+------------------+--------------+----------+-------------------+-----------------+---------------------+---------------------+------------------------+--------------------+--------+-------------------+--------------+--------------------------------------+
1 ?6 M- o0 j( @7 B# [- X8 F4 V| 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 |' `- P2 m! M- }0 h
| 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 |9 G. R {7 T, l1 P
| 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 |
0 O8 ^ A- B% D6 b7 k- h5 `| 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 |6 g% V* ~1 S5 V: l
+---------------------+---------------------+------------+---------+----+-----------------------+------------------+------------------+--------------+----------+-------------------+-----------------+---------------------+---------------------+------------------------+--------------------+--------+-------------------+--------------+--------------------------------------+# a6 P# s4 {" h; G4 C4 {8 T, H
4 rows in set (0.001 sec)
2 j9 K* X j/ `/ Z# t0 N1 b/ A2 x. U0 F" t0 R- R
MariaDB [cinder]> select * from services\G;" L% Z1 |7 b$ J7 @, M% P; [
*************************** 1. row ***************************
- L$ _: w p' D# _3 o! G created_at: 2025-02-21 08:46:15/ O+ c- t* O0 s$ j' ^0 G5 t# u
updated_at: 2025-02-22 05:24:52 W0 N8 k' W2 f. Q% J, E
deleted_at: NULL
( f/ j( y/ l, ], D- b deleted: 0
& \4 P: Q! z6 b8 T9 T# h2 }5 a id: 1: z, Z8 {& B4 z! Y
host: streamcontroller C, H$ @) B% M# w' u9 d+ v
binary: cinder-scheduler, w% z7 J/ G$ M; V
topic: cinder-scheduler; D4 z; Y& |& w1 q" c6 U; H
report_count: 7312
5 r; t O5 J1 @ disabled: 0
0 P0 Q/ V2 g: q& W availability_zone: nova
+ a3 p2 @0 y' w7 J$ w0 o disabled_reason: NULL3 f/ X1 x* r( @+ W' B
modified_at: NULL
( ^# g+ T5 {0 \' z1 t rpc_current_version: 3.12# _( U* E3 h$ B8 ]- C; K
object_current_version: 1.39) i7 g4 v( R$ t/ P: d
replication_status: not-capable0 B1 D+ ~% t; C! G: v: b
frozen: 0
7 y9 K! A( g4 D; {! S+ i active_backend_id: NULL
0 N3 z0 ]0 y7 \6 V2 r% a) L8 ?5 m cluster_name: NULL$ ]4 T3 L' Q0 u$ t
uuid: 25a9a766-4a38-4865-a579-20fc13311a1d$ E) t) ]. H& R/ W2 F* @% J# _
* y+ j/ i" R; ]- q% y
查询相关语句：" l/ N. `+ C, ?# K1 r# j
MariaDB [cinder]> select id,uuid,host,deleted from services;
. j; a2 F) ^5 k1 Y6 N& ?; W+----+--------------------------------------+-----------------------+---------+5 X3 V: }, V! B" s+ ~
| id | uuid | host | deleted |8 b/ s2 B! O# y3 p
+----+--------------------------------------+-----------------------+---------+! R+ H2 E1 N+ _1 r; B3 t# R
| 1 | 25a9a766-4a38-4865-a579-20fc13311a1d | streamcontroller | 0 |
0 [& ?9 Q2 x+ P6 x% i| 2 | 0842668e-c3d1-46e4-a06a-d49220948c49 | streamcontroller@ceph | 0 |
. @9 c$ ~# b8 X' s% I h# D| 3 | 7cb2a139-c176-4195-8f8d-fffc81872145 | rbd:volumes@volumes | 0 |% @2 h7 _3 x. k7 V3 G
| 4 | 14a90401-32ec-482e-94fd-d36e46e8f823 | rbd:images@images | 0 |
/ o: c ?7 T* s; T2 `) s4 `+----+--------------------------------------+-----------------------+---------+) [; E8 h6 ?% M/ X/ p0 n5 Y: ?$ B
4 rows in set (0.001 sec)
8 W; [" W; S6 b6 [9 {9 ?
, k5 u1 ?, K/ k+ a设置状态deleted为1：2 A2 N. v9 U" c% o) x
* X5 s- V, U4 N: Q
MariaDB [cinder]> update cinder.services set deleted='1' where uuid='0842668e-c3d1-46e4-a06a-d49220948c49';: P6 P! T3 T/ z! c% L: \4 ^ q; [
Query OK, 1 row affected (0.001 sec)! a" ]6 F; B5 {' b
Rows matched: 1 Changed: 1 Warnings: 0
/ C; ]$ n, V; F* V3 f5 {4 m/ A
P; r0 ]; F" s) h SMariaDB [cinder]> select id,uuid,host,deleted from services;
! f( O8 ?, V0 e* `' D% M7 o' Y" ]) h9 P+----+--------------------------------------+-----------------------+---------+
& S( {' ]2 a4 m8 x; ^9 O3 || id | uuid | host | deleted |
8 Z5 |( ?+ a: w) Y5 g+----+--------------------------------------+-----------------------+---------+
! e& R+ k* r) J! W| 1 | 25a9a766-4a38-4865-a579-20fc13311a1d | streamcontroller | 0 |
. P( z+ f3 r5 S- q) E8 g| 2 | 0842668e-c3d1-46e4-a06a-d49220948c49 | streamcontroller@ceph | 1 |: T9 m2 Z0 U! [7 ~
| 3 | 7cb2a139-c176-4195-8f8d-fffc81872145 | rbd:volumes@volumes | 0 |5 r$ V* ^% v' Z
| 4 | 14a90401-32ec-482e-94fd-d36e46e8f823 | rbd:images@images | 0 |5 W1 S- S' b5 l* T) D
+----+--------------------------------------+-----------------------+---------+% L, D5 B4 ~9 A8 B& h7 b
4 rows in set (0.001 sec) I2 I, }5 v0 [3 P
! s& x9 L0 s1 `0 a/ q2 ?再次检查状态：
8 `) r- g: {- G( o; ^[root@streamcontroller ~]# cinder service-list
6 ^' X7 l0 i. X2 h) Q) `, Z5 j+------------------+---------------------+------+---------+-------+----------------------------+-----------------+
) b5 j2 n' W4 c5 r| Binary | Host | Zone | Status | State | Updated_at | Disabled Reason |
% Y9 j9 |1 e! h, J( m+------------------+---------------------+------+---------+-------+----------------------------+-----------------+ Q+ [; ~; k; Q
| cinder-scheduler | streamcontroller | nova | enabled | up | 2025-02-22T05:31:32.000000 | - |( t- X+ M8 x$ a/ y
| cinder-volume | rbd:images@images | nova | enabled | up | 2025-02-22T05:31:32.000000 | - |; n' x4 l- }1 c f. n* W
| cinder-volume | rbd:volumes@volumes | nova | enabled | up | 2025-02-22T05:31:32.000000 | - |
6 e3 j7 K5 ^$ x; x- R; N" ?1 J+------------------+---------------------+------+---------+-------+----------------------------+-----------------+
r3 o. f0 h( F! h+ Q+ F( N1 \
) d9 A, U) _% v+ F6 s# j1 `' I) B- L$ F1 r4 j; D
( j; _ _6 H$ P, E- [ |
|
发表于 2025-2-22 13:31:39