易陆发现互联网技术论坛

 找回密码
 开始注册
查看: 3946|回复: 0
收起左侧

LB修改数据库状态

[复制链接]
发表于 2019-2-15 06:28:00 | 显示全部楼层 |阅读模式

马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。

您需要 登录 才可以下载或查看,没有账号?开始注册

x
MySQL [neutron]> update neutron.lbaas_loadbalancers set provisioning_status='ACTIVE'  where id='29bfb879-5aed-4074-b265-a787ebc8fb03'; # o/ N2 ^  N: o* A/ ^
ERROR 2006 (HY000): MySQL server has gone away
. m# G5 l5 j2 G% b# M- KNo connection. Trying to reconnect...1 ]- k+ X- K; B
Connection id:    30751936' v2 W2 |" ^' r: c
Current database: neutron
/ j: B3 t  [8 u3 p' s1 C- d# d9 X( p
Query OK, 1 row affected (0.15 sec), K" L' }3 ?6 n, Y" M
Rows matched: 1  Changed: 1  Warnings: 0$ L4 Q& A7 F) M5 R* {5 m& e6 l1 u& r
) U( P/ b' _% L9 {9 j  |: u- {
MySQL [neutron]> select *  from   lbaas_loadbalancers  where id='29bfb879-5aed-4074-b265-a787ebc8fb03'\G;. P- M  q) j/ U6 ~# f. Y8 |( K
*************************** 1. row ***************************2 Q- O( W' u9 Y3 V* X( ~9 G! D
          tenant_id: ba6da1da49c3454383c723891df40064
2 L& y* u7 Z* \4 F8 P7 s; V$ B                 id: 29bfb879-5aed-4074-b265-a787ebc8fb03+ f4 a1 I/ x9 y& d0 t) `9 L$ R
               name: ???
3 ?, l" X' C: A. ]+ V" z        description:  (vTMs: 10.12.12.10, 10.112.12.11; VIP: 10.12.12.19)
" J0 ?& R4 h; `# W3 q        vip_port_id: 2e227fa3-9e3e-4374-980b-0c8ea0eefa93, x0 f; ~3 s. y9 N! E7 u: g
      vip_subnet_id: 1c3ce1e0-2d8c-4ce7-ae13-33e2b62e8edb
% W8 z: j6 k& W* \" R; @: ^        vip_address: 10.12.12.19" a2 ]5 _& E3 w6 t/ y# F) F
     admin_state_up: 1  W/ U' ?- U( Y( B4 J
provisioning_status: ACTIVE% x  ?5 Q& k! t' ?
   operating_status: ONLINE1 D. b. [. b; X4 t% z: m1 t
          bandwidth: NULL
/ h! {2 H" O$ h+ ?3 W  M6 [1 row in set (0.01 sec)9 \5 i2 L* h/ Z# t2 V4 O* p2 a. G
9 J- u6 s1 ^9 S
ERROR: No query specified8 O7 h! O: n$ r( G- Q) j
$ X& k7 T) d! U4 e# _. F
neutron lbaas-loadbalancer-show 29bfb879-5aed-4074-b265-a787ebc8fb03
9 W/ u0 }! }+ B) R+---------------------+--------------------------------------------------------------+
8 r  u1 l/ u; x4 J| Field               | Value                                                        |
1 K; d. S+ G% N+---------------------+--------------------------------------------------------------+" u: Z% i* o) M
| admin_state_up      | True                                                         |  p; K+ `% y. O4 [* E5 F
| bandwidth           |                                                              |
1 p9 I0 Q+ ^( m/ H$ e( |5 O4 I8 `| description         |  (vTMs: ) |
, K* B& B+ V, A8 u6 f| id                  | 29bfb879-5aed-4074-b265-a787ebc8fb03                         |, e' x( [" g; K, X
| listeners           |                                                              |
" ?2 w7 |5 o5 H. o! g3 A- W! u: ~| name                | 林业局                                                       |9 j  k) a. A6 g& |5 N
| operating_status    | ONLINE                                                       |
9 Z# L# g& _* [' V  R8 f2 c| provider            | brocade                                                      |
/ `8 V; l5 q1 V: @0 t) O# a| provisioning_status | ACTIVE                                                       |1 x$ ~7 l& e5 t" e, [* f
| tenant_id           | ba6da1da49c3454383c723891df40064                             |
4 N# h* w. F) V$ z| vip_address         | 10.112.102.149                                               |
# ~" H& K" k. _; M. f# X$ H" e| vip_port_id         | 2e227fa3-9e3e-4374-980b-0c8ea0eefa93                         |, r: ~7 F+ T4 ~1 r& c3 C: U
| vip_subnet_id       | 1c3ce1e0-2d8c-4ce7-ae13-33e2b62e8edb                         |- [" }* N' i, T5 Z! h/ O
+---------------------+--------------------------------------------------------------+
4 D4 r2 S) I4 K+ q( ^  E[root@BFJD-PSC-SDN-SV1 deployer]# neutron lbaas-loadbalancer-delete 29bfb879-5aed-4074-b265-a787ebc8fb03 --force --debug
2 \& n: J# l3 h/ H" K& PDEBUG: keystoneclient.session REQ: curl -g -i -X GET http://-VIP1:35357/v3 -H "Accept: application/json" -H "User-Agent: python-keystoneclient"2 h6 Y! |/ C, U- c- p
DEBUG: keystoneclient.session RESP: [200] content-length: 261 vary: X-Auth-Token keep-alive: timeout=5, max=100 server: Apache/2.4.6 (CentOS) mod_wsgi/3.4 Python/2.7.5 connection: Keep-Alive date: Thu, 14 Feb 2019 01:36:28 GMT content-type: application/json x-openstack-request-id: req-b9a313c0-8b09-43a0-aa16-b12f9a78db44 * J! t* J- Q3 r0 E1 f
RESP BODY: {"version": {"status": "stable", "updated": "2015-03-30T00:00:00Z", "media-types": [{"base": "application/json", "type": "application/vnd.openstack.identity-v3+json"}], "id": "v3.4", "links": [{"href": "http://-VIP1:35357/v3/", "rel": "self"}]}}" f# s5 ?2 r+ I& @6 X
DEBUG: neutronclient.neutron.v2_0.lb.v2.loadbalancer.DeleteLoadBalancer run(Namespace(id=u'29bfb879-5aed-4074-b265-a787ebc8fb03', request_format='json'))
8 @$ D! t# q- v0 A" G, V; E2 XDEBUG: keystoneclient.auth.identity.v3.base Making authentication request to http://-VIP1:35357/v3/auth/tokens$ o: ^2 W/ K7 I9 n$ e& ^
DEBUG: stevedore.extension found extension EntryPoint.parse('appdesigner = nuage_neutronclient.appdesigner')0 [7 U9 N2 p" b% o
DEBUG: stevedore.extension found extension EntryPoint.parse('floatingip = nuage_neutronclient.floatingip'), \; f$ G  P" ~7 m" X+ j
DEBUG: stevedore.extension found extension EntryPoint.parse('gateway = nuage_neutronclient.gateway')0 C& m3 P) K% {- G2 I
DEBUG: stevedore.extension found extension EntryPoint.parse('externalsecuritygroup = nuage_neutronclient.externalsecuritygroup'): i* _- ]9 s1 M3 q
DEBUG: stevedore.extension found extension EntryPoint.parse('redirecttarget = nuage_neutronclient.redirecttarget')% J  t0 @2 X$ n# j! I5 `& {
DEBUG: keystoneclient.session REQ: curl -g -i -X GET http://-VIP:9696/v2.0/lbaas/loadbalancers.json?fields=id&id=29bfb879-5aed-4074-b265-a787ebc8fb03 -H "User-Agent: python-neutronclient" -H "Accept: application/json" -H "X-Auth-Token: {SHA1}d90dcd34ce218ec34550461c343d210dee1dc7ea"3 L6 z6 w5 J4 n6 N
DEBUG: keystoneclient.session RESP: [200] date: Thu, 14 Feb 2019 01:36:28 GMT content-length: 467 content-type: application/json; charset=UTF-8 x-openstack-request-id: req-5edfbce3-bae3-435b-a47f-c42bc7886adf 4 P: z8 h0 [9 n- ?+ r$ R- C
RESP BODY: {"loadbalancers": [{"description": " (vTMs: 10.112.102.150, 10.112.102.151; VIP: 10.112.102.149)", "provisioning_status": "ACTIVE", "admin_state_up": true, "bandwidth": null, "id": "29bfb879-5aed-4074-b265-a787ebc8fb03", "listeners": [], "vip_port_id": "2e227fa3-9e3e-4374-980b-0c8ea0eefa93", "vip_address": "10.112.102.149", "vip_subnet_id": "1c3ce1e0-2d8c-4ce7-ae13-33e2b62e8edb", "provider": "brocade", "operating_status": "ONLINE", "name": "\u6797\u4e1a\u5c40"}]}" ^2 g$ G6 {. S: I$ J; M+ W
DEBUG: keystoneclient.session REQ: curl -g -i -X DELETE http://-VIP:9696/v2.0/lbaas/loadbalancers/29bfb879-5aed-4074-b265-a787ebc8fb03.json -H "User-Agent: python-neutronclient" -H "Accept: application/json" -H "X-Auth-Token: {SHA1}d90dcd34ce218ec34550461c343d210dee1dc7ea"% i) Q& g& J* ~- k, C

" E( i; e& Q2 \4 o
您需要登录后才可以回帖 登录 | 开始注册

本版积分规则

关闭

站长推荐上一条 /4 下一条

北京云银创陇科技有限公司以云计算运维,代码开发

QQ|返回首页|Archiver|小黑屋|易陆发现技术论坛 点击这里给我发消息

GMT+8, 2026-4-10 16:25 , Processed in 0.039199 second(s), 21 queries .

Powered by Discuz! X3.4 Licensed

© 2012-2025 Discuz! Team.

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