找回密码
 注册
查看: 3940|回复: 0

LB修改数据库状态

[复制链接]

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
发表于 2019-2-15 06:28:00 | 显示全部楼层 |阅读模式
MySQL [neutron]> update neutron.lbaas_loadbalancers set provisioning_status='ACTIVE'  where id='29bfb879-5aed-4074-b265-a787ebc8fb03'; - `' X, h4 p6 h# ~$ j
ERROR 2006 (HY000): MySQL server has gone away
& S$ j' G. i/ s+ ^1 i; i  i1 p- t7 @No connection. Trying to reconnect...
7 v! b3 A6 a4 @4 sConnection id:    30751936
6 {9 Q- C, b+ n5 a! p! ICurrent database: neutron8 o1 `, |- R; @5 W7 m% q9 `/ t

& \( j0 K! N' L7 qQuery OK, 1 row affected (0.15 sec), I- E8 o1 Q- t; W9 F
Rows matched: 1  Changed: 1  Warnings: 0
5 B1 b$ H, N. ]$ a$ w3 ?
1 t) ?6 v6 U' ~( d9 XMySQL [neutron]> select *  from   lbaas_loadbalancers  where id='29bfb879-5aed-4074-b265-a787ebc8fb03'\G;. d6 z6 H6 Q' H+ e2 S! u
*************************** 1. row ***************************4 V& w7 |% I3 q8 [
          tenant_id: ba6da1da49c3454383c723891df40064% s+ U5 S- M2 S
                 id: 29bfb879-5aed-4074-b265-a787ebc8fb037 g% U2 K% @# X& N2 c2 j
               name: ???9 Y+ U. r3 s9 p
        description:  (vTMs: 10.12.12.10, 10.112.12.11; VIP: 10.12.12.19)( V' I$ V6 i" m8 u0 ]2 ~% [
        vip_port_id: 2e227fa3-9e3e-4374-980b-0c8ea0eefa932 _  R2 b5 `+ |: c6 w
      vip_subnet_id: 1c3ce1e0-2d8c-4ce7-ae13-33e2b62e8edb
, V# Y* o% _& g3 C, }' l5 h        vip_address: 10.12.12.19$ |" N3 x: U, P3 r- r
     admin_state_up: 1
! h+ T# l  J' t& q1 p# P; y; ~) r+ Aprovisioning_status: ACTIVE3 Y- A) z4 \  A7 V1 Z2 Z
   operating_status: ONLINE- m' |$ U' e& C5 s
          bandwidth: NULL, U! ]( [( j: C4 [
1 row in set (0.01 sec)
- n  i  R3 Q: b& n+ U9 r1 {. c2 S( Z; }
ERROR: No query specified$ w, r2 s  T, _- w& w/ b# Y
% e" X/ K  B7 O+ y* S3 H
neutron lbaas-loadbalancer-show 29bfb879-5aed-4074-b265-a787ebc8fb03/ p1 T' m5 i& i% x2 A
+---------------------+--------------------------------------------------------------+
2 d3 T  f3 {. [  ~, h+ J6 S| Field               | Value                                                        |
2 s+ @0 i, u! Q& k( U+---------------------+--------------------------------------------------------------+' I+ G2 {8 B4 p0 f" k7 w
| admin_state_up      | True                                                         |
9 J2 V% a- |# W| bandwidth           |                                                              |
- Z6 i: Q. E, @- d  ^+ F| description         |  (vTMs: ) |# I# C# G0 a7 `$ I8 T
| id                  | 29bfb879-5aed-4074-b265-a787ebc8fb03                         |7 L5 D$ F& n& F1 Y$ I, F1 X
| listeners           |                                                              |
2 s2 d7 C4 |9 z+ j| name                | 林业局                                                       |
! P% v  m& \6 e, M8 @  Y6 K| operating_status    | ONLINE                                                       |
* Q, H. j5 m% |5 d3 ]| provider            | brocade                                                      |% _1 i" W7 S6 Q% @
| provisioning_status | ACTIVE                                                       |
( a- }8 s0 `( Z2 I) k| tenant_id           | ba6da1da49c3454383c723891df40064                             |; t8 L/ B6 d% u* w3 _1 G2 G
| vip_address         | 10.112.102.149                                               |+ ~7 g, i5 P* j% m; J! d6 g* R
| vip_port_id         | 2e227fa3-9e3e-4374-980b-0c8ea0eefa93                         |
% B$ a1 _/ y( a| vip_subnet_id       | 1c3ce1e0-2d8c-4ce7-ae13-33e2b62e8edb                         |
& W' v. L. o  N& g9 F6 M+---------------------+--------------------------------------------------------------+
5 g( D7 g3 f" b+ |' i5 m[root@BFJD-PSC-SDN-SV1 deployer]# neutron lbaas-loadbalancer-delete 29bfb879-5aed-4074-b265-a787ebc8fb03 --force --debug
8 ?- ]- `9 x# b# {0 C5 ]8 }2 W7 J0 {DEBUG: keystoneclient.session REQ: curl -g -i -X GET http://-VIP1:35357/v3 -H "Accept: application/json" -H "User-Agent: python-keystoneclient"! N& P" S5 f. q4 y
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 ; P- {- {; Z3 Z! H
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"}]}}
. E( z1 e7 \+ P# \DEBUG: neutronclient.neutron.v2_0.lb.v2.loadbalancer.DeleteLoadBalancer run(Namespace(id=u'29bfb879-5aed-4074-b265-a787ebc8fb03', request_format='json'))7 t# V* m0 g& y  e  r9 I) B9 Z. w
DEBUG: keystoneclient.auth.identity.v3.base Making authentication request to http://-VIP1:35357/v3/auth/tokens
- W, J( n5 _5 A2 oDEBUG: stevedore.extension found extension EntryPoint.parse('appdesigner = nuage_neutronclient.appdesigner')
- S# j* X  S. p3 q7 P0 i6 IDEBUG: stevedore.extension found extension EntryPoint.parse('floatingip = nuage_neutronclient.floatingip')
, m" j/ A) ]& G) ^DEBUG: stevedore.extension found extension EntryPoint.parse('gateway = nuage_neutronclient.gateway')) M  R; R% z9 ]; |: |
DEBUG: stevedore.extension found extension EntryPoint.parse('externalsecuritygroup = nuage_neutronclient.externalsecuritygroup')! e% w# I8 ~6 @
DEBUG: stevedore.extension found extension EntryPoint.parse('redirecttarget = nuage_neutronclient.redirecttarget')
' |3 ?4 u- j7 o/ D# Q# U, x1 iDEBUG: 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") v3 k9 w  O, S6 V% N9 ]: Z0 x
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 ! C% `$ ^- k! L0 P& i
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"}]}1 e5 H( m, B  W" u" O4 i
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"
; ]( w( b  F4 L0 B
4 x2 ~  }9 a' E
您需要登录后才可以回帖 登录 | 注册

本版积分规则

返回首页|Archiver|手机版|小黑屋|易陆发现技术论坛 ( 蜀ICP备2026014127号-1 )

GMT+8, 2026-6-12 02:23 , Processed in 0.017629 second(s), 22 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

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