|
|
楼主 |
发表于 2025-2-10 10:46:49
|
显示全部楼层
- k5 a0 r' r9 L! Y5 e4 `接下来修改nova的数据库
$ H: G! j. e. @3 sMariaDB [nova]> select * from instances where uuid='7c91cb27-ecde-4930-a56a-e8210a3e4176' \G;1 c7 o/ j0 u i% ?# K1 T& C
*************************** 1. row ***************************
$ x$ r" M/ d$ o f; {- G created_at: 2025-02-10 02:43:492 g0 N* Y( n: \' A9 U
updated_at: 2025-02-10 02:44:00- L. r$ C ~4 `/ k! K, `' r
deleted_at: NULL: M8 d) [) u/ w+ g0 A
id: 16515 `* N: L9 V7 h, W
internal_id: NULL5 @7 C1 A8 |% p1 l2 k* l, ]. n: A# E
user_id: 1e1454d784f945a69d29bef4c246a28d% p# M6 Q6 y# x! i
project_id: b7912d3927a241109b7d682b888c197e& L: n, m: B& l( q5 |; w
image_ref: " N7 W/ P0 C( f
kernel_id:
5 A$ n: M( r/ j3 k ramdisk_id: 6 L- L5 B' c7 z! K
launch_index: 0
. C! O8 f) O! w! i# F3 A key_name: NULL; e6 v& p# M1 K/ R W7 l
key_data: NULL2 H3 }3 J. E6 m; P
power_state: 1+ K6 J5 O% u& X$ W
vm_state: active
$ }: e) Y! p/ p& C memory_mb: 4096$ ]7 `4 V- f! u, ?4 I
vcpus: 2
z9 P4 w5 A* I2 M3 J; K hostname: testcinder
) I7 R4 L% H, b5 s host: yz-ksc-kcn017 [4 i* H: L8 \, v& O6 a, e+ V
user_data: 8 r! p5 G4 i$ B. m- g: X4 p" v
reservation_id: r-hgn9w9v06 {2 {1 Y6 ]% N
scheduled_at: NULL8 L% A4 y% \7 a
launched_at: 2025-02-10 02:44:00
6 k& H( ~; C' h terminated_at: NULL& e, R1 T2 u d& h& j6 O
display_name: testcinder
C% {& P% H/ T- h6 ?$ G$ [& s display_description: testcinder9 E) e1 @4 X" E0 m9 W
availability_zone: 智网AZ) q- A9 j2 ]4 Q
locked: 0* f3 ?( N- r5 k( T) b7 F9 i# R
os_type: linux- u, ~2 D7 t5 N9 Z( O
launched_on: yz-ksc-kcn01
5 X& T5 A0 |. P# u4 |( Y+ Y instance_type_id: 5
O" I8 I' A; U3 N7 j8 w+ q vm_mode: NULL. B' i, i9 O6 A
uuid: 7c91cb27-ecde-4930-a56a-e8210a3e4176
7 D2 T# Y8 [! v% ~$ w architecture: NULL* f. E+ k. g7 z& D
root_device_name: /dev/vda$ x% l8 n6 y" K9 F
access_ip_v4: NULL; Y. U' i8 w% Q3 P* f( @$ X
access_ip_v6: NULL/ _* P3 [6 z- T0 l5 O
config_drive: 0 o5 p4 Z& T' m( Q8 W! D
task_state: NULL
9 b* o! U! G* b! }; T" Gdefault_ephemeral_device: NULL2 M4 k! z) |) k Q5 C( S
default_swap_device: NULL `6 h. w- @ U% W* {4 e
progress: 0
4 {2 V. D- g( f5 @ auto_disk_config: 0
. ~5 C/ S# D" E+ t* }: d shutdown_terminate: 0 a0 V$ F' L' c# F& N
disable_terminate: 0
0 g' G& I" ], Y: l1 ]4 p root_gb: 505 o. E8 O( \# B" }1 [
ephemeral_gb: 0
1 g: H1 D1 y% m cell_name: NULL0 z$ h! X) u, g$ R, b
node: yz-ksc-kcn01
; n, f) e" a8 k deleted: 05 B' f0 K6 {: ]: M8 a( X
locked_by: NULL' q- h, X# H5 Y4 k* z1 v
cleaned: 0
. ?! ]) {; f0 u$ B ephemeral_key_uuid: NULL# C8 \9 D0 D; f9 V
is_bare_metal: 0
u8 W5 a# S0 ~+ e3 M% } is_power_vm: 0
! F0 }6 G3 u/ T- H guest_type: kvm0 Q. U' a4 f, M, }
service_type: vm-cloud
; V3 y9 ^, e0 E6 O; i1 row in set (0.00 sec)9 i3 M8 G A) ?5 ?" i
# G4 w2 B3 R+ u. \2 k3 x
ERROR: No query specified0 V+ W# K' t! v* ^, a
4 h3 t4 S/ O$ B/ e* _
MariaDB [nova]> select uuid,root_gb from instances where uuid='7c91cb27-ecde-4930-a56a-e8210a3e4176' \G;
x3 W% h) r& }7 R% Y% u/ j*************************** 1. row ***************************3 L) @2 N$ G& s# d! b
uuid: 7c91cb27-ecde-4930-a56a-e8210a3e4176( l8 `: ~# |( o$ T6 |3 Z6 S
root_gb: 508 U; S7 S: h3 w9 d
1 row in set (0.00 sec)
; b' Y4 g6 {) ^! o1 E
: \. b/ j5 x6 d9 B2 t) z2 Q1 oERROR: No query specified* z6 m* W" {0 c$ e/ I7 p7 m$ \& F
1 h4 a0 l$ {; ]" x, `
MariaDB [nova]> select uuid,root_gb from instances where uuid='7c91cb27-ecde-4930-a56a-e8210a3e4176';* R9 F$ }% s, T& c) y U
+--------------------------------------+---------+$ M6 O( i4 J; B, v/ k7 V
| uuid | root_gb |
, g3 }; i# Y" L2 S5 x# M( a: X+ I+--------------------------------------+---------+2 {( v% W$ m2 E1 R. C0 x; z% o" m
| 7c91cb27-ecde-4930-a56a-e8210a3e4176 | 50 |8 j& r. l/ _2 V# G9 q
+--------------------------------------+---------+
* V& C2 i6 b& ? n0 m1 row in set (0.00 sec)
, j0 M6 c ~3 @$ p$ D, Z( D- V# s2 }, y: n" k3 w6 c/ g/ z! y& V& n4 d
MariaDB [nova]> update nova.instances set root_gb='70' where uuid='7c91cb27-ecde-4930-a56a-e8210a3e4176';) h$ |( n" R: k a! l* T" f3 _
ERROR 2013 (HY000): Lost connection to MySQL server during query
3 X3 T, B- C2 o. JMariaDB [nova]> update nova.instances set root_gb='70' where uuid='7c91cb27-ecde-4930-a56a-e8210a3e4176';
7 F2 J8 ?, U5 o4 m7 CERROR 2006 (HY000): MySQL server has gone away
. H5 c1 x: U; l7 f W# RNo connection. Trying to reconnect...( U. H/ a [( e3 G
Connection id: 93083735
0 p; v2 q/ ?( I1 X1 _/ Y0 V) f2 mCurrent database: nova- c* m! f. ?; o2 d0 K
3 `: l8 B9 `& U9 I2 S# v
Query OK, 1 row affected (0.19 sec)
2 j' x0 l7 e8 X7 y" s4 tRows matched: 1 Changed: 1 Warnings: 0 |
|