LB修改数据库状态

admin

MySQL [neutron]> update neutron.lbaas_loadbalancers set provisioning_status='ACTIVE'  where id='29bfb879-5aed-4074-b265-a787ebc8fb03';
* U7 C: I5 O7 S# }9 TERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    30751936
Current database: neutron
  f+ |% ~( p( J  D$ F
Query OK, 1 row affected (0.15 sec)
Rows matched: 1  Changed: 1  Warnings: 0
3 V8 d+ W  E6 C' s6 H
MySQL [neutron]> select *  from   lbaas_loadbalancers  where id='29bfb879-5aed-4074-b265-a787ebc8fb03'\G;
*************************** 1. row ***************************
          tenant_id: ba6da1da49c3454383c723891df40064
                 id: 29bfb879-5aed-4074-b265-a787ebc8fb03
               name: ???
        description:  (vTMs: 10.12.12.10, 10.112.12.11; VIP: 10.12.12.19)
4 @! i" R) {9 v7 n8 c% x. N  u        vip_port_id: 2e227fa3-9e3e-4374-980b-0c8ea0eefa93
# T" @  E" E! Z; h& @! N      vip_subnet_id: 1c3ce1e0-2d8c-4ce7-ae13-33e2b62e8edb
! s4 R6 [- o8 e$ J! ^        vip_address: 10.12.12.19
$ s$ X- b5 J5 h     admin_state_up: 1
provisioning_status: ACTIVE
( J6 u  t9 e6 B* Y& J; g   operating_status: ONLINE
          bandwidth: NULL
: R- f* l% w2 d. W! U2 u1 row in set (0.01 sec)
9 x: T7 Q3 G0 N1 W
ERROR: No query specified
6 Y0 p6 \1 d9 ^) k( L) W' ?) X  F
neutron lbaas-loadbalancer-show 29bfb879-5aed-4074-b265-a787ebc8fb03
+---------------------+--------------------------------------------------------------+
| Field               | Value                                                        |
" x9 s% W  Z& C/ D2 R+---------------------+--------------------------------------------------------------+
1 p5 Z+ v8 P. k- T/ s3 L+ ~" p| admin_state_up      | True                                                         |
7 j2 y3 w5 g! P- {3 O  J| bandwidth           |                                                              |
| description         |  (vTMs: ) |
| id                  | 29bfb879-5aed-4074-b265-a787ebc8fb03                         |
6 i* B7 h4 v! w! E7 ~8 |- u| listeners           |                                                              |
| name                | 林业局                                                       |
| operating_status    | ONLINE                                                       |
| provider            | brocade                                                      |
! M8 R% T6 o' c$ x5 v6 s| provisioning_status | ACTIVE                                                       |
. _! [' J2 c$ \" |( e. q! N| tenant_id           | ba6da1da49c3454383c723891df40064                             |
| vip_address         | 10.112.102.149                                               |
1 `0 u- N5 }+ y6 R| vip_port_id         | 2e227fa3-9e3e-4374-980b-0c8ea0eefa93                         |
| vip_subnet_id       | 1c3ce1e0-2d8c-4ce7-ae13-33e2b62e8edb                         |
% j. b8 Y: S& w* i+---------------------+--------------------------------------------------------------+
- W" D" x  u1 }  l[root@BFJD-PSC-SDN-SV1 deployer]# neutron lbaas-loadbalancer-delete 29bfb879-5aed-4074-b265-a787ebc8fb03 --force --debug
* M  Q) ~( A* V5 hDEBUG: keystoneclient.session REQ: curl -g -i -X GET http://-VIP1:35357/v3 -H "Accept: application/json" -H "User-Agent: python-keystoneclient"
* W( j% Y9 K+ e5 K+ V+ G8 g3 O, w' SDEBUG: 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
# d. b- S6 q- f1 o- m% rRESP 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'))
0 m6 A# \# ~# U4 ^DEBUG: 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')
DEBUG: stevedore.extension found extension EntryPoint.parse('gateway = nuage_neutronclient.gateway')
8 J: V9 D9 x8 p6 T1 A4 xDEBUG: stevedore.extension found extension EntryPoint.parse('externalsecuritygroup = nuage_neutronclient.externalsecuritygroup')
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"}]}
! t- Z6 c* D  ~% ^2 NDEBUG: 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"

& V( Z9 y4 u$ U