LB修改数据库状态

admin

MySQL [neutron]> update neutron.lbaas_loadbalancers set provisioning_status='ACTIVE'  where id='29bfb879-5aed-4074-b265-a787ebc8fb03';
+ T! D5 [5 G/ K' w3 q+ S/ a" H) }( hERROR 2006 (HY000): MySQL server has gone away
5 W' n% [3 J4 ^No connection. Trying to reconnect...
Connection id:    30751936
Current database: neutron

Query OK, 1 row affected (0.15 sec)
5 D6 g6 M& O1 V" w  g4 s9 aRows matched: 1  Changed: 1  Warnings: 0
& T' U& K2 n' {; I8 Q; C2 |
2 X8 ~4 i0 U: i. fMySQL [neutron]> select *  from   lbaas_loadbalancers  where id='29bfb879-5aed-4074-b265-a787ebc8fb03'\G;
- i' N' n9 o* l( J% V*************************** 1. row ***************************
          tenant_id: ba6da1da49c3454383c723891df40064
; ]2 k: A  d+ M$ P( C4 M7 G+ ~                 id: 29bfb879-5aed-4074-b265-a787ebc8fb03
9 D1 Q5 t9 r; k; w5 \               name: ???
0 v5 F  ]# y+ a        description:  (vTMs: 10.12.12.10, 10.112.12.11; VIP: 10.12.12.19)
        vip_port_id: 2e227fa3-9e3e-4374-980b-0c8ea0eefa93
      vip_subnet_id: 1c3ce1e0-2d8c-4ce7-ae13-33e2b62e8edb
        vip_address: 10.12.12.19
     admin_state_up: 1
# }% S" Q* S. q% t$ o6 X% b6 T4 ^provisioning_status: ACTIVE
   operating_status: ONLINE
2 |9 p; P6 C. M: A3 X# \          bandwidth: NULL
+ p% ?! b6 Q6 a$ G; I% P) `3 p1 row in set (0.01 sec)

+ J) v$ O5 x$ u1 i) RERROR: No query specified

# D3 q! J3 w2 {+ c neutron lbaas-loadbalancer-show 29bfb879-5aed-4074-b265-a787ebc8fb03
" e5 [& p, t" X" q/ T' T5 z+---------------------+--------------------------------------------------------------+
| Field               | Value                                                        |
+---------------------+--------------------------------------------------------------+
| admin_state_up      | True                                                         |
4 L$ O' q  Y" s) j| bandwidth           |                                                              |
) k8 `  i- }& g4 p) m$ `| description         |  (vTMs: ) |
| id                  | 29bfb879-5aed-4074-b265-a787ebc8fb03                         |
' W7 C  u: k1 ~  u& I7 J| listeners           |                                                              |
, f# |, [3 f1 i: t+ d" j| name                | 林业局                                                       |
| operating_status    | ONLINE                                                       |
| provider            | brocade                                                      |
| provisioning_status | ACTIVE                                                       |
| tenant_id           | ba6da1da49c3454383c723891df40064                             |
| vip_address         | 10.112.102.149                                               |
| vip_port_id         | 2e227fa3-9e3e-4374-980b-0c8ea0eefa93                         |
& f/ M7 I% T' N$ Z4 n+ g, V| vip_subnet_id       | 1c3ce1e0-2d8c-4ce7-ae13-33e2b62e8edb                         |
+---------------------+--------------------------------------------------------------+
[root@BFJD-PSC-SDN-SV1 deployer]# neutron lbaas-loadbalancer-delete 29bfb879-5aed-4074-b265-a787ebc8fb03 --force --debug
9 g! l2 _3 c8 ]9 `( GDEBUG: keystoneclient.session REQ: curl -g -i -X GET http://-VIP1:35357/v3 -H "Accept: application/json" -H "User-Agent: python-keystoneclient"
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
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"}]}}
/ p4 {6 W+ N% j2 f  M* j9 n" G. CDEBUG: neutronclient.neutron.v2_0.lb.v2.loadbalancer.DeleteLoadBalancer run(Namespace(id=u'29bfb879-5aed-4074-b265-a787ebc8fb03', request_format='json'))
DEBUG: keystoneclient.auth.identity.v3.base Making authentication request to http://-VIP1:35357/v3/auth/tokens
6 _* e' H7 O$ H* FDEBUG: stevedore.extension found extension EntryPoint.parse('appdesigner = nuage_neutronclient.appdesigner')
; e: s3 b% ]; ZDEBUG: stevedore.extension found extension EntryPoint.parse('floatingip = nuage_neutronclient.floatingip')
DEBUG: stevedore.extension found extension EntryPoint.parse('gateway = nuage_neutronclient.gateway')
DEBUG: 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"
6 e. ]% F, C0 J! @7 J& A- K5 }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
" \$ F* y% @; H# n& y" w9 ~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"}]}
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"
0 a9 x8 r, q  ]3 n. D0 p
3 @2 e: X# ~( I3 V- e$ q