找回密码
 注册
查看: 3941|回复: 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';
9 d) {  f. R& h$ U/ qERROR 2006 (HY000): MySQL server has gone away
5 m$ c* p+ }  Y, g* JNo connection. Trying to reconnect...# c$ e- U. j0 F: @
Connection id:    30751936
' w% F$ b3 w" Z9 |Current database: neutron4 ]* [% r" ?- R7 g
3 ]! A, w$ j! w3 \& [
Query OK, 1 row affected (0.15 sec)
( ~, g1 l2 B+ P$ Z& V) ?# x0 \Rows matched: 1  Changed: 1  Warnings: 0. z4 F, ^4 D0 X: I; R3 `2 x) a

4 k+ L: O" R4 V, D' V6 D, iMySQL [neutron]> select *  from   lbaas_loadbalancers  where id='29bfb879-5aed-4074-b265-a787ebc8fb03'\G;, g8 D3 s- i1 q: Z
*************************** 1. row ***************************" _' B( X' [- e& W+ J% [1 z
          tenant_id: ba6da1da49c3454383c723891df40064
$ O* k2 O- f# i, k  c+ J! a$ Z                 id: 29bfb879-5aed-4074-b265-a787ebc8fb03
. S2 t% K9 z1 A  {0 @6 V               name: ???$ S6 g4 t: e* N3 l( D8 e$ I) E
        description:  (vTMs: 10.12.12.10, 10.112.12.11; VIP: 10.12.12.19)! }0 g6 M) _2 m6 N
        vip_port_id: 2e227fa3-9e3e-4374-980b-0c8ea0eefa93
( @1 _+ u% N0 X! g" D% r$ v      vip_subnet_id: 1c3ce1e0-2d8c-4ce7-ae13-33e2b62e8edb+ U: v) k" O4 C( d+ u7 J. Z4 S' {
        vip_address: 10.12.12.19, R- a, \- \, s: j1 \2 L! b
     admin_state_up: 1" d/ V2 I# U3 U
provisioning_status: ACTIVE
: P% v, C+ `  f   operating_status: ONLINE) a  v( Y3 [& L( ~" q* |
          bandwidth: NULL) ]. A3 e" s8 R* v9 w* u! A* q
1 row in set (0.01 sec)/ q$ p5 y$ U: F& @. D. B' f

4 B  `+ s) z- X1 ~ERROR: No query specified
1 T7 _( ^7 Z- X, m+ x5 [
" D; O# t8 {2 { neutron lbaas-loadbalancer-show 29bfb879-5aed-4074-b265-a787ebc8fb03
( S( D2 D) G: g' y% l% W& i+---------------------+--------------------------------------------------------------+- R9 G7 b5 N3 _) @8 p& f
| Field               | Value                                                        |
7 D! v2 f5 i8 A# h" ?0 W) P+---------------------+--------------------------------------------------------------+
. e2 n7 q+ q6 ~( g5 T| admin_state_up      | True                                                         |8 g+ Q( W) H( p3 Y$ {: P2 s
| bandwidth           |                                                              |% C& Y, V* C, m0 g: v; u
| description         |  (vTMs: ) |5 e, q5 R3 x: O
| id                  | 29bfb879-5aed-4074-b265-a787ebc8fb03                         |+ b. Y4 Z  N  {8 I: S& `/ \7 ]
| listeners           |                                                              |
% [9 X$ _- e0 c2 F4 s| name                | 林业局                                                       |" V- ^% h7 H' t
| operating_status    | ONLINE                                                       |
% l, s! N) R4 a$ W* |8 C/ _0 G| provider            | brocade                                                      |
& N/ Z% _2 {9 {. j# g. C$ P, k* V| provisioning_status | ACTIVE                                                       |& ~! ^/ A+ k1 p* i( d
| tenant_id           | ba6da1da49c3454383c723891df40064                             |9 O# q* Q% O$ n7 E
| vip_address         | 10.112.102.149                                               |
; u5 |! {2 t) ]( f: }% x: `| vip_port_id         | 2e227fa3-9e3e-4374-980b-0c8ea0eefa93                         |8 ?9 {8 i6 E# [- d+ R5 f! W  F  [2 A
| vip_subnet_id       | 1c3ce1e0-2d8c-4ce7-ae13-33e2b62e8edb                         |
0 E" d8 X( @6 m) y+---------------------+--------------------------------------------------------------+
1 k. o1 K( D8 B. }; \* n) d[root@BFJD-PSC-SDN-SV1 deployer]# neutron lbaas-loadbalancer-delete 29bfb879-5aed-4074-b265-a787ebc8fb03 --force --debug
/ i5 Y3 [# I& @, U5 {DEBUG: keystoneclient.session REQ: curl -g -i -X GET http://-VIP1:35357/v3 -H "Accept: application/json" -H "User-Agent: python-keystoneclient"
4 \% c, Z; V# i6 d( v) K7 \. T; I9 |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 & e, X/ u) K$ R
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"}]}}5 {0 f! i% W# p# H6 O
DEBUG: neutronclient.neutron.v2_0.lb.v2.loadbalancer.DeleteLoadBalancer run(Namespace(id=u'29bfb879-5aed-4074-b265-a787ebc8fb03', request_format='json'))  u' f9 d* p/ }
DEBUG: keystoneclient.auth.identity.v3.base Making authentication request to http://-VIP1:35357/v3/auth/tokens
. \) r6 C$ h4 c0 UDEBUG: stevedore.extension found extension EntryPoint.parse('appdesigner = nuage_neutronclient.appdesigner')
8 x: n1 [* c" Y' T. jDEBUG: stevedore.extension found extension EntryPoint.parse('floatingip = nuage_neutronclient.floatingip')
1 w' N! x" [' _, g4 I. c/ B  D6 qDEBUG: stevedore.extension found extension EntryPoint.parse('gateway = nuage_neutronclient.gateway')
; C' a% j* l1 Q9 `' Q7 e6 zDEBUG: stevedore.extension found extension EntryPoint.parse('externalsecuritygroup = nuage_neutronclient.externalsecuritygroup'); ~' \% q) X" r
DEBUG: stevedore.extension found extension EntryPoint.parse('redirecttarget = nuage_neutronclient.redirecttarget')
& M0 M+ b* {$ EDEBUG: 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"
  s% ~: p7 U: T5 n8 _; @1 l; eDEBUG: 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( A! G$ z/ @+ L  ?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"}]}
" D! D8 a+ \. |; w4 @5 KDEBUG: 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"
" k( Z1 _; d2 T& |5 l" X& G9 |4 z3 C0 w. Y
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

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

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

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