LB修改数据库状态

admin

MySQL [neutron]> update neutron.lbaas_loadbalancers set provisioning_status='ACTIVE'  where id='29bfb879-5aed-4074-b265-a787ebc8fb03';
0 u) d1 n* S) dERROR 2006 (HY000): MySQL server has gone away
# r1 a7 j5 d4 h% mNo connection. Trying to reconnect...
Connection id:    30751936
# V& u' h% Z9 l" A# N6 ^Current database: neutron

( |' h7 H0 w' ]% p9 S  U0 G2 K% T  WQuery OK, 1 row affected (0.15 sec)
+ A& D( U- \6 S2 ARows matched: 1  Changed: 1  Warnings: 0
. F; e0 t9 Z: L& B: I# Z" p
MySQL [neutron]> select *  from   lbaas_loadbalancers  where id='29bfb879-5aed-4074-b265-a787ebc8fb03'\G;
  k3 y5 d, p) G* u. n! D& m" W* S4 U*************************** 1. row ***************************
2 A, j0 j  E6 L9 ?4 j# o/ D4 a7 z8 y          tenant_id: ba6da1da49c3454383c723891df40064
                 id: 29bfb879-5aed-4074-b265-a787ebc8fb03
               name: ???
9 n- B! @5 ^7 g/ X1 {& d' F        description:  (vTMs: 10.12.12.10, 10.112.12.11; VIP: 10.12.12.19)
0 t3 a$ W: n) q* Q, n: W4 |        vip_port_id: 2e227fa3-9e3e-4374-980b-0c8ea0eefa93
      vip_subnet_id: 1c3ce1e0-2d8c-4ce7-ae13-33e2b62e8edb
        vip_address: 10.12.12.19
" O1 y' K- \% Q" L- h5 Q1 v     admin_state_up: 1
/ t1 X. I! T6 U' M2 a: g& aprovisioning_status: ACTIVE
   operating_status: ONLINE
8 b, ^# |& X1 J7 G3 Z          bandwidth: NULL
% b6 M8 r2 l; K- U$ ^/ t; q1 row in set (0.01 sec)
3 s8 f; q6 Q/ R4 \  R
ERROR: No query specified
# B6 R% ~$ }$ h# m, M# S( `$ N
' h  ?2 P* ]: k9 n8 _ neutron lbaas-loadbalancer-show 29bfb879-5aed-4074-b265-a787ebc8fb03
! G. d( L" @" c% j5 P& t7 k* R+---------------------+--------------------------------------------------------------+
, L8 v: Q: W2 ~) b; M| Field               | Value                                                        |
+---------------------+--------------------------------------------------------------+
| admin_state_up      | True                                                         |
| bandwidth           |                                                              |
6 E7 f8 \$ {: O$ U( u& B| description         |  (vTMs: ) |
| id                  | 29bfb879-5aed-4074-b265-a787ebc8fb03                         |
| listeners           |                                                              |
# x/ o  T9 d) _* V/ X| name                | 林业局                                                       |
3 d0 s( \0 P/ I7 U| operating_status    | ONLINE                                                       |
9 s5 o/ f6 `( W/ p! j| provider            | brocade                                                      |
| provisioning_status | ACTIVE                                                       |
: G9 R8 D6 q/ ^. \! D| tenant_id           | ba6da1da49c3454383c723891df40064                             |
0 g3 w, p9 H5 I2 X| vip_address         | 10.112.102.149                                               |
| vip_port_id         | 2e227fa3-9e3e-4374-980b-0c8ea0eefa93                         |
| vip_subnet_id       | 1c3ce1e0-2d8c-4ce7-ae13-33e2b62e8edb                         |
+ U) a) K" Y2 ~: p9 ?+---------------------+--------------------------------------------------------------+
  g- Y1 W  ^- b, y. l) u! _1 ~[root@BFJD-PSC-SDN-SV1 deployer]# neutron lbaas-loadbalancer-delete 29bfb879-5aed-4074-b265-a787ebc8fb03 --force --debug
4 Z+ n, |& ~$ c" ?DEBUG: keystoneclient.session REQ: curl -g -i -X GET http://-VIP1:35357/v3 -H "Accept: application/json" -H "User-Agent: python-keystoneclient"
3 {, B  \8 p8 m8 K9 s5 [- YDEBUG: 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
/ a# D- h# g0 z' w* Y1 ERESP 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"}]}}
DEBUG: neutronclient.neutron.v2_0.lb.v2.loadbalancer.DeleteLoadBalancer run(Namespace(id=u'29bfb879-5aed-4074-b265-a787ebc8fb03', request_format='json'))
$ R' p6 q$ A2 U3 e' K2 h& [* Z, DDEBUG: keystoneclient.auth.identity.v3.base Making authentication request to http://-VIP1:35357/v3/auth/tokens
DEBUG: stevedore.extension found extension EntryPoint.parse('appdesigner = nuage_neutronclient.appdesigner')
DEBUG: stevedore.extension found extension EntryPoint.parse('floatingip = nuage_neutronclient.floatingip')
2 |( w1 {; r7 Z& M8 a! xDEBUG: stevedore.extension found extension EntryPoint.parse('gateway = nuage_neutronclient.gateway')
- e* f  X! c; |& O* z7 SDEBUG: stevedore.extension found extension EntryPoint.parse('externalsecuritygroup = nuage_neutronclient.externalsecuritygroup')
# `+ G' G+ k1 V5 \DEBUG: stevedore.extension found extension EntryPoint.parse('redirecttarget = nuage_neutronclient.redirecttarget')
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"
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
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 H9 e$ _8 ^! EDEBUG: 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"

/ z& o3 K( U) C: U+ d" `$ E2 H  M