- 积分
- 16840
在线时间 小时
最后登录1970-1-1
|

楼主 |
发表于 2021-10-18 11:12:53
|
显示全部楼层
[root@controller1 _data]# kolla-ansible -i multinode mariadb_recovery) V. q9 U4 r, h$ t: g) {
Attempting to restart mariadb cluster : ansible-playbook -i multinode -e @/etc/kolla/globals.yml -e @/etc/kolla/passwords.yml -e CONFIG_DIR=/etc/kolla -e action=deploy -e common_run=true /usr/share/kolla-ansible/ansible/mariadb_recovery.yml 2 s. f0 c5 v, B; i* h7 u; A) K5 w
/usr/lib/python2.7/site-packages/ansible/parsing/vault/__init__.py:44: CryptographyDeprecationWarning: Python 2 is no longer supported by the Python core team. Support for it is now deprecated in cryptography, and will be removed in the next release.
2 D; |2 y6 [! b+ W; [ f+ B- @ from cryptography.exceptions import InvalidSignature
1 Y) F \; y5 { z/ k[WARNING]: Unable to parse /var/lib/docker/volumes/mariadb/_data/multinode as an inventory source5 k& C( M. Y) o N- q, ^) r
[WARNING]: No inventory was parsed, only implicit localhost is available8 d: ]; b* y+ B# Z1 {5 p3 J5 @
[WARNING]: provided hosts list is empty, only localhost is available. Note that the implicit localhost does not match 'all'6 X" x: J' s/ X; H
[WARNING]: Could not match supplied host pattern, ignoring: mariadb
- j2 i5 `8 z0 b# {4 x# j" g4 D
2 ]0 ~, X% N0 F4 i) b4 T: D& XPLAY [Detect openstack_release variable] **************************************************************************************************************************
2 T X2 X8 w! Jskipping: no hosts matched
/ M) |" }0 J' r) N. }+ s2 {6 zPLAY [Recover mariadb] ********************************************************************************************************************************************% R4 T: E$ p$ P
skipping: no hosts matched5 E' x, p% K' z7 P" I4 g
PLAY RECAP ********************************************************************************************************************************************************
5 I; Z2 t ^+ S9 N& i/ @7 S# F[root@controller1 _data]# cd ! \) c: F* l4 s3 m# K/ D: t) V
[root@controller1 ~]# kolla-ansible -i multinode mariadb_recovery
7 s4 P: O& N. o. _3 DAttempting to restart mariadb cluster : ansible-playbook -i multinode -e @/etc/kolla/globals.yml -e @/etc/kolla/passwords.yml -e CONFIG_DIR=/etc/kolla -e action=deploy -e common_run=true /usr/share/kolla-ansible/ansible/mariadb_recovery.yml
+ }( }' d, q; B/usr/lib/python2.7/site-packages/ansible/parsing/vault/__init__.py:44: CryptographyDeprecationWarning: Python 2 is no longer supported by the Python core team. Support for it is now deprecated in cryptography, and will be removed in the next release.5 W3 Z' A& Y( o, S; v
from cryptography.exceptions import InvalidSignature
* g ^5 r3 e. J, Q9 c" F. U9 [5 L[WARNING]: Invalid characters were found in group names but not replaced, use -vvvv to see details
% z2 D: a5 [: Z( ?% j[WARNING]: Found variable using reserved name: action
6 }: @/ m$ C+ v" R3 A5 H! I
. j( N' s* J' p: m T# z9 w% fPLAY [Detect openstack_release variable] **************************************************************************************************************************
2 E" \( y' a% w5 dTASK [Get current kolla-ansible version number] *******************************************************************************************************************
% k2 [" h4 e6 d" bskipping: [controller1]8 Z& u" u& u9 {" Y
skipping: [controller2]
# U/ J& b% t4 Gskipping: [controller3]
: o e+ Q) }1 k& VTASK [Set openstack_release variable] *****************************************************************************************************************************
5 D5 b. O/ x5 G C, E, |skipping: [controller1]
) h$ I L+ l/ t* q* N! }8 rskipping: [controller2]+ ]( y3 ?# ^& d( R0 _9 O
skipping: [controller3]
: {, T1 j1 |: e: jPLAY [Recover mariadb] ********************************************************************************************************************************************! _ S# q" P# b$ u- }4 g
TASK [Gathering Facts] ********************************************************************************************************************************************: ] G% z0 Z# J7 t6 G" |6 f
ok: [controller1]
" A$ P9 ~- x M D( i( o* G" t% rok: [controller3]; Y0 h1 ^& H9 u7 c3 m& p' s
ok: [controller2], Q1 m# ?& @$ U! \/ _# ^# |; w; G4 A
TASK [common : include] *******************************************************************************************************************************************
' ^% e, n0 X8 N; T4 mskipping: [controller1]2 o9 [& A$ E3 [' g. E
skipping: [controller2]
" m2 P# Z. ]4 ?8 m- B& B4 p/ N: s( B: J: Dskipping: [controller3]# f: N. r- N5 N' s
TASK [common : Registering common role has run] *******************************************************************************************************************
. D$ T5 k% a; L2 n V! g4 nskipping: [controller1]
* x$ o& E6 |- n, oskipping: [controller2]9 a% [1 P) `$ ^/ b
skipping: [controller3]
6 O- t: G3 q+ {# i8 Y0 W" CTASK [mariadb : include] ******************************************************************************************************************************************( s. ]0 S+ V: F* P* m
included: /usr/share/kolla-ansible/ansible/roles/mariadb/tasks/deploy.yml for controller1, controller2, controller3
" y& [- A* p& ]$ x5 k, Z a6 E# |) LTASK [mariadb : include] ******************************************************************************************************************************************
; a% \- c O9 dincluded: /usr/share/kolla-ansible/ansible/roles/mariadb/tasks/config.yml for controller1, controller2, controller32 A" o5 Z( X! u3 O
TASK [mariadb : Ensuring config directories exist] ****************************************************************************************************************
7 }' y) l9 x. q' [6 e" S% R% jok: [controller2] => (item={'value': {u'enabled': True, u'image': u'kolla/centos-binary-mariadb:queens', u'group': u'mariadb', u'volumes': [u'/etc/kolla//mariadb/:/var/lib/kolla/config_files/:ro', u'/etc/localtime:/etc/localtime:ro', u'mariadb:/var/lib/mysql', u'kolla_logs:/var/log/kolla/'], u'container_name': u'mariadb'}, 'key': u'mariadb'})* O. d6 e( \+ U% [& x2 D. ]
ok: [controller3] => (item={'value': {u'enabled': True, u'image': u'kolla/centos-binary-mariadb:queens', u'group': u'mariadb', u'volumes': [u'/etc/kolla//mariadb/:/var/lib/kolla/config_files/:ro', u'/etc/localtime:/etc/localtime:ro', u'mariadb:/var/lib/mysql', u'kolla_logs:/var/log/kolla/'], u'container_name': u'mariadb'}, 'key': u'mariadb'})
" R- b$ I4 C) s% t& @& P/ q6 Aok: [controller1] => (item={'value': {u'enabled': True, u'image': u'kolla/centos-binary-mariadb:queens', u'group': u'mariadb', u'volumes': [u'/etc/kolla//mariadb/:/var/lib/kolla/config_files/:ro', u'/etc/localtime:/etc/localtime:ro', u'mariadb:/var/lib/mysql', u'kolla_logs:/var/log/kolla/'], u'container_name': u'mariadb'}, 'key': u'mariadb'})
, M7 k" W, B8 ETASK [mariadb : Copying over config.json files for services] ******************************************************************************************************
2 v0 D) g/ l) dok: [controller2]
! P. Q/ }# n( z1 q) w. m: O& t2 fok: [controller3]$ Z; `3 B- o( C4 N' b2 [& O2 _
ok: [controller1]
# k! w2 X8 U0 Y" o6 |TASK [mariadb : Copying over galera.cnf] **************************************************************************************************************************
7 _/ T r6 L6 p[WARNING]: _execute_module no longer honors the tmp parameter. Action plugins should set self._connection._shell.tmpdir to share the tmpdir; Y/ z4 A2 a9 q3 s
[WARNING]: _execute_module no longer honors the tmp parameter. Action plugins should set self._connection._shell.tmpdir to share the tmpdir
6 U- |/ g0 w# v$ ~4 m( Y9 L3 }[WARNING]: _execute_module no longer honors the tmp parameter. Action plugins should set self._connection._shell.tmpdir to share the tmpdir' U: c( Q2 c/ _- u0 ^7 b
ok: [controller3]8 g# Q+ |. U6 {7 U7 s* h
ok: [controller2]9 N' ~7 k& l4 h
ok: [controller1]
7 w# k: r+ o6 V1 z/ \$ S& cTASK [mariadb : Copying over wsrep-notify.sh] *********************************************************************************************************************
( E! _ v! K9 `3 b1 E' tok: [controller2] => (item={'value': {u'enabled': True, u'image': u'kolla/centos-binary-mariadb:queens', u'group': u'mariadb', u'volumes': [u'/etc/kolla//mariadb/:/var/lib/kolla/config_files/:ro', u'/etc/localtime:/etc/localtime:ro', u'mariadb:/var/lib/mysql', u'kolla_logs:/var/log/kolla/'], u'container_name': u'mariadb'}, 'key': u'mariadb'})
' X* [3 ~: j3 s; u5 e- T3 h4 ]ok: [controller1] => (item={'value': {u'enabled': True, u'image': u'kolla/centos-binary-mariadb:queens', u'group': u'mariadb', u'volumes': [u'/etc/kolla//mariadb/:/var/lib/kolla/config_files/:ro', u'/etc/localtime:/etc/localtime:ro', u'mariadb:/var/lib/mysql', u'kolla_logs:/var/log/kolla/'], u'container_name': u'mariadb'}, 'key': u'mariadb'})6 a) c0 `7 H' S+ v# R
ok: [controller3] => (item={'value': {u'enabled': True, u'image': u'kolla/centos-binary-mariadb:queens', u'group': u'mariadb', u'volumes': [u'/etc/kolla//mariadb/:/var/lib/kolla/config_files/:ro', u'/etc/localtime:/etc/localtime:ro', u'mariadb:/var/lib/mysql', u'kolla_logs:/var/log/kolla/'], u'container_name': u'mariadb'}, 'key': u'mariadb'})
0 T* t2 x" M' P# F, w4 C0 ~TASK [mariadb : Check mariadb containers] *************************************************************************************************************************
5 k6 B; F8 d& c$ V+ l6 echanged: [controller3] => (item={'value': {u'enabled': True, u'image': u'kolla/centos-binary-mariadb:queens', u'group': u'mariadb', u'volumes': [u'/etc/kolla//mariadb/:/var/lib/kolla/config_files/:ro', u'/etc/localtime:/etc/localtime:ro', u'mariadb:/var/lib/mysql', u'kolla_logs:/var/log/kolla/'], u'container_name': u'mariadb'}, 'key': u'mariadb'})
+ t9 z3 ^- U8 \, Bchanged: [controller1] => (item={'value': {u'enabled': True, u'image': u'kolla/centos-binary-mariadb:queens', u'group': u'mariadb', u'volumes': [u'/etc/kolla//mariadb/:/var/lib/kolla/config_files/:ro', u'/etc/localtime:/etc/localtime:ro', u'mariadb:/var/lib/mysql', u'kolla_logs:/var/log/kolla/'], u'container_name': u'mariadb'}, 'key': u'mariadb'})
; L* ~5 [, R x' Lchanged: [controller2] => (item={'value': {u'enabled': True, u'image': u'kolla/centos-binary-mariadb:queens', u'group': u'mariadb', u'volumes': [u'/etc/kolla//mariadb/:/var/lib/kolla/config_files/:ro', u'/etc/localtime:/etc/localtime:ro', u'mariadb:/var/lib/mysql', u'kolla_logs:/var/log/kolla/'], u'container_name': u'mariadb'}, 'key': u'mariadb'})
- M+ N1 h4 O9 f8 p YTASK [mariadb : include] ******************************************************************************************************************************************4 b/ @' L$ T0 O" s2 H& N3 A
included: /usr/share/kolla-ansible/ansible/roles/mariadb/tasks/bootstrap.yml for controller1, controller2, controller3
6 r% s! d6 E' RTASK [mariadb : set_fact] *****************************************************************************************************************************************4 T: o5 D* m5 a6 u+ n
ok: [controller1]
* y% c7 O/ K8 B% o/ xok: [controller2]
/ w' z3 ~; G; t- a' I9 q+ |: c% ^ok: [controller3]" l; H& h0 }( S/ \4 n
TASK [mariadb : include] ******************************************************************************************************************************************
, k+ e; x4 {9 P/ k2 d4 j* I" rincluded: /usr/share/kolla-ansible/ansible/roles/mariadb/tasks/lookup_cluster.yml for controller1, controller2, controller3) o! `* F, |3 n! g
TASK [mariadb : Cleaning up temp file on localhost] ***************************************************************************************************************: B! o1 [7 L5 L* T. G" l
ok: [controller1 -> localhost]/ k9 e8 C. `( y4 s) g1 A5 w, x
TASK [mariadb : Creating temp file on localhost] ******************************************************************************************************************7 z5 T0 v- P- O9 N! T
ok: [controller1 -> localhost]
2 e6 _+ v8 ]7 O8 ITASK [mariadb : Creating mariadb volume] **************************************************************************************************************************
" x& b. y7 C6 {! ?$ l* p* Jok: [controller1]! z& r# M/ X8 a }3 `2 I$ @
ok: [controller2]
: N% G b7 o( R( ^. qok: [controller3]
b- u7 e7 e3 W6 _TASK [mariadb : Writing hostname of host with existing cluster files to temp file] ********************************************************************************! O. R Q/ P, A7 E3 e
[DEPRECATION WARNING]: Using tests as filters is deprecated. Instead of using `result|changed` use `result is changed`. This feature will be removed in version
+ q+ U: j9 J: L+ N/ {9 O# U2.9. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg.
, d! S: F$ k- S( f: N[DEPRECATION WARNING]: Using tests as filters is deprecated. Instead of using `result|changed` use `result is changed`. This feature will be removed in version 4 g$ e3 T7 L$ I( N- i
2.9. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg.1 x2 A! j/ W: B3 R0 n
[DEPRECATION WARNING]: Using tests as filters is deprecated. Instead of using `result|changed` use `result is changed`. This feature will be removed in version
4 k: b" j9 k* G; w, D+ t- d7 M2.9. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg. x! E3 w! k% C/ l6 `- `
ok: [controller1 -> localhost]" p/ P ]: r$ ~. A, |. f1 H
ok: [controller2 -> localhost]
/ B! u: e1 M2 _' Z& z) dok: [controller3 -> localhost]" c/ W" \ \# x. f( o. O( M
TASK [mariadb : Registering host from temp file] ******************************************************************************************************************' x2 ?1 v6 f" r, q" U* K
ok: [controller1]
, B2 ^% }9 L s( \$ Mok: [controller2]
% A% K8 a$ f3 qok: [controller3]8 ^4 G9 X' ], O) v c
TASK [mariadb : Cleaning up temp file on localhost] ***************************************************************************************************************- m3 U1 y( G) l4 k: X
ok: [controller1 -> localhost]
: x* q& |, N9 `2 OTASK [mariadb : include] ******************************************************************************************************************************************) F* t5 c M8 r. D
skipping: [controller1]
# |0 P& _1 n( qskipping: [controller2]
- W* `7 t7 ~, |8 {skipping: [controller3]
: h5 j% j$ r0 ~* g; K! TTASK [mariadb : include] ******************************************************************************************************************************************
* Q: l o! O4 `. Nincluded: /usr/share/kolla-ansible/ansible/roles/mariadb/tasks/recover_cluster.yml for controller1, controller2, controller3
; o3 B! T# k1 p/ Z' j& zTASK [mariadb : fail] *********************************************************************************************************************************************
5 H# L% j; g3 q) v, Jskipping: [controller1]
9 |9 Q+ |8 O' r* M7 zskipping: [controller2]2 f0 `- _$ r. U' u
skipping: [controller3]: ^, X- Z: }+ p3 S0 B
TASK [mariadb : Cleaning up temp file on mariadb hosts] ***********************************************************************************************************
0 \/ Y# f; h1 D5 g" nok: [controller2]
2 J1 J3 y2 I1 M' I2 `: h! ^ok: [controller1]
" A& K& q3 U; Q2 z% ]7 \ok: [controller3]
% I. e) y7 c4 u1 ATASK [mariadb : Cleaning up temp file on localhost] ***************************************************************************************************************2 l6 i: X F0 h+ H9 U+ [! ]
ok: [controller1 -> localhost] m( n' A% \& U, t
TASK [mariadb : Stop MariaDB containers] **************************************************************************************************************************3 H O1 J$ {3 t# h+ R5 {9 j( [
ok: [controller2]6 |( t" X' M4 o+ q
ok: [controller1]
9 P& N) J- u1 k/ w) T; Wok: [controller3]5 M9 X- g9 l! @1 `
TASK [mariadb : Run MariaDB wsrep recovery] ***********************************************************************************************************************
1 \, K% e8 v0 D; G, rchanged: [controller1]
6 o* U$ l7 B% o: w5 Cchanged: [controller2]
7 p! l W2 G3 j O3 @9 Y% p2 z+ b/ mchanged: [controller3]! Q6 q8 A: F/ w4 l% |- v6 r# L
TASK [mariadb : Copying MariaDB log file to /tmp] *****************************************************************************************************************
/ i4 y8 f6 _$ z0 U9 qchanged: [controller3]8 F# Z8 y# ?1 s6 i. D, O4 y
changed: [controller2]0 I0 g5 V3 ~8 c' P& k
changed: [controller1]4 B( _7 F* D Q1 j N! S9 H
TASK [mariadb : Get MariaDB wsrep recovery seqno] *****************************************************************************************************************8 H( ?) ^- r* r' k+ M! z" V- N2 @, u
changed: [controller2]
' I# O6 y ^' R* ]" Rchanged: [controller1]
+ Y- f8 @* f. D: mchanged: [controller3]
y7 i7 E8 G# m$ s& |6 KTASK [mariadb : Removing MariaDB log file from /tmp] **************************************************************************************************************
( c6 C1 I' w% b/ w- _ok: [controller2]
4 \0 v5 S6 U: C& W1 R1 t# ~ ]- `: xok: [controller1]
% I, C" w. z3 } s; `% bok: [controller3]
6 [+ D* q3 @ CTASK [mariadb : Registering MariaDB seqno variable] ***************************************************************************************************************6 D8 H8 }0 {& A0 a
ok: [controller1]) J' t9 X3 ^; O3 n5 J6 M6 X* _, Q
ok: [controller2]3 T, T: o9 D$ I4 F5 D1 }" _
ok: [controller3]' c: ~( B5 l9 ^+ C
TASK [mariadb : Comparing seqno value on all mariadb hosts] *******************************************************************************************************
, c8 X! Y, I: ? f7 \) Rok: [controller2] => (item=controller1)4 a* n, S# X m( [- J: b/ K
ok: [controller1] => (item=controller1)
% T- U1 D4 e3 H1 {* w# Ook: [controller3] => (item=controller1)
" c4 ~$ |. } T! J b* rok: [controller2] => (item=controller2)( P, [6 Q* O! j6 ~! [) R7 \) _" }
ok: [controller3] => (item=controller2)
" [ G/ M* T( ^ok: [controller1] => (item=controller2)
! x% P0 }# t1 S$ ~* G& Dok: [controller2] => (item=controller3)6 Q* z! b# G) {* A) t
ok: [controller3] => (item=controller3)
" O% K. }7 x4 M; g% M6 R) ]. z$ ?/ Cok: [controller1] => (item=controller3)9 `% {. V/ M& ~
TASK [mariadb : Writing hostname of host with the largest seqno to temp file] *************************************************************************************. T5 V, l$ l' q0 C$ F( B
skipping: [controller3]
6 `5 {4 H$ [: A5 fok: [controller1 -> localhost]9 s- t$ [) S% a
ok: [controller2 -> localhost]0 E8 ?: {8 x! o Q8 l' _; y
TASK [mariadb : Registering mariadb_recover_inventory_name from temp file] ****************************************************************************************
* O3 R; ^! u# m! \# _+ l; ?ok: [controller1]
; {- Y5 C1 G% V& U) n" N+ Z/ Vok: [controller2]2 g% w" i' W0 g: h* M( t* @
ok: [controller3]
3 [% D n7 [1 n' N# ^. t1 U: h$ d0 c/ wTASK [mariadb : set_fact] *****************************************************************************************************************************************& V2 T0 @& J4 P% H/ `
changed: [controller1]
9 }6 u! J' R# Bchanged: [controller2]
1 A* P3 R0 R! {& @+ a+ y' b) |changed: [controller3]
8 b7 [5 @ c- d2 yTASK [mariadb : Copying grastate.dat file from MariaDB container in bootstrap host] *******************************************************************************! N3 Y: Y, H2 x" v
skipping: [controller1]1 }3 ^% Q+ C- g) a
skipping: [controller3]7 u, z( p7 K5 I
ok: [controller2]: D+ R9 W% E7 ]3 D6 O: F3 H
TASK [mariadb : Set grastate.dat file from MariaDB container in bootstrap host] ***********************************************************************************- i+ y7 O4 n: ?& {/ Z, R5 M& D7 v& n
skipping: [controller1] r+ k1 y* `" F7 R8 N! F- U+ _7 A7 @
skipping: [controller3], }4 ?& k. x V1 q9 a
changed: [controller2]
7 A$ J4 b: t: K( c* r' b- RTASK [mariadb : Copying grastate.dat file to mariadb container] ***************************************************************************************************
, v" i0 B! T& E+ l, i. f5 xskipping: [controller1]
3 G3 ]: B: j) I6 @skipping: [controller3]
( p0 B3 j2 f* a' {$ h2 Rok: [controller2]
. _* o0 e8 l# w/ j' u$ ^3 tTASK [mariadb : Starting first MariaDB container] *****************************************************************************************************************
) y' R3 U. J, Qskipping: [controller1]
9 c) v" y/ _4 J" _. s; j+ r- _, qskipping: [controller3]
- e, o: p! B \ f; Z0 M6 Uchanged: [controller2]
& w$ s- m p$ r N. ^TASK [mariadb : Wait for first MariaDB container] *****************************************************************************************************************
V! O0 {8 \0 B4 X; g' Askipping: [controller1]
/ [$ d. a: P% L' I% Bskipping: [controller3], C) {) j: _& G6 m+ V
[DEPRECATION WARNING]: Using tests as filters is deprecated. Instead of using `result|success` use `result is success`. This feature will be removed in version u8 V* \4 e! N4 Z2 R2 r
2.9. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg.9 x% V |- _% u$ x' `
FAILED - RETRYING: Wait for first MariaDB container (10 retries left).
% v% T4 W" @: e% j) wok: [controller2]8 E; ~: Z' p+ G( O
TASK [mariadb : Set first MariaDB container as primary] ***********************************************************************************************************
# ]( t% [' B- o! {$ ^3 q9 pskipping: [controller1]3 i8 B3 ?1 }/ Q4 H
skipping: [controller3]
9 C7 M7 ^) s7 Bchanged: [controller2]
# L! \% D* q# j4 @& B8 O! j. h; cTASK [mariadb : Wait for MariaDB to become operational] ***********************************************************************************************************
( p I1 v- l8 X2 m8 v- \skipping: [controller1], O4 |9 C! z" d8 x" _; w% }
skipping: [controller3]6 d/ L2 T1 S3 V# |/ e# W; C7 H% m
ok: [controller2]
- B# `: r3 a2 X4 \0 a3 E6 KTASK [mariadb : Restart slave MariaDB container] ******************************************************************************************************************' s. y3 U/ N! u& A7 o+ W* j
skipping: [controller2]
: _2 S2 B v# `7 U nchanged: [controller3]
- g; b. w* Q3 x) Hchanged: [controller1]
% O# W, s9 Z; Z: ^0 `/ ]: ETASK [mariadb : Wait for slave MariaDB] ***************************************************************************************************************************
5 q, @; @" I$ askipping: [controller2]
, m5 f# P9 z" @5 E' o9 z9 S+ s[DEPRECATION WARNING]: Using tests as filters is deprecated. Instead of using `result|success` use `result is success`. This feature will be removed in version
, f, S3 h- g# s1 w2.9. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg.
; ?: p; q O p, m* {; f7 [FAILED - RETRYING: Wait for slave MariaDB (10 retries left).
% e M: P$ b+ m7 ~0 w, d4 [[DEPRECATION WARNING]: Using tests as filters is deprecated. Instead of using `result|success` use `result is success`. This feature will be removed in version : c1 C3 B, I$ a$ K) ^1 \. v
2.9. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg.( i- q j x" e% k7 p) ~
FAILED - RETRYING: Wait for slave MariaDB (10 retries left).
( A1 \! s$ A1 q) rok: [controller3]
* A2 q) L3 e% m0 jok: [controller1]
- o, G3 T M/ Q( o/ P- d* ^" M' ?[WARNING]: flush_handlers task does not support when conditional
& N' K. s. B- l o+ W% q, t v2 `/ K8 Y/ |9 B7 {# p: A
RUNNING HANDLER [mariadb : restart slave mariadb] *****************************************************************************************************************! c3 F7 K; X* f5 J! Q; {
skipping: [controller3]" [! r5 \& c: U/ ]/ |7 d! T
skipping: [controller1]
2 \! i6 A" [& u9 x; v4 y" L' pskipping: [controller2]% ]& V7 h! n5 l5 Z' C% b
RUNNING HANDLER [mariadb : restart master mariadb] ****************************************************************************************************************0 K) [8 L- s4 v$ F: t
skipping: [controller3]: ]. s4 `: u7 C) o" R0 }: A
skipping: [controller1]. x$ A9 M, P$ h
skipping: [controller2]
9 o$ _' s+ C+ ~2 Z: QTASK [mariadb : include] ******************************************************************************************************************************************
4 v5 W" T6 R# X5 t Sincluded: /usr/share/kolla-ansible/ansible/roles/mariadb/tasks/register.yml for controller1, controller2, controller32 f/ g$ p! J1 ~; B9 y% B1 N
TASK [mariadb : Creating haproxy mysql user] **********************************************************************************************************************( x& N4 S! ~- ^6 y/ N y
ok: [controller1]& ^( d7 o7 c' c7 c& b
TASK [mariadb : Cleaning up facts] ********************************************************************************************************************************
, c5 r3 f9 e! H# qok: [controller1]
- a1 k+ p- C- \ok: [controller2]1 T7 o$ y3 K) d$ l" F( T
ok: [controller3]% x" w; |3 V6 I$ b& T
TASK [mariadb : include] ******************************************************************************************************************************************6 E, `7 H& K9 i5 \ P' x; j$ v
included: /usr/share/kolla-ansible/ansible/roles/mariadb/tasks/check.yml for controller1, controller2, controller3
5 ?' \; ~1 a4 f* WTASK [mariadb : Waiting for MariaDB service to be ready through VIP] **********************************************************************************************
9 Q7 A! J) e- d% H[DEPRECATION WARNING]: Using tests as filters is deprecated. Instead of using `result|success` use `result is success`. This feature will be removed in version ) u3 I0 k* r- m7 |5 j8 g
2.9. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg., d* g1 T3 Z. d [ {' z
ok: [controller1], g( ` z( ]& D
[DEPRECATION WARNING]: Using tests as filters is deprecated. Instead of using `result|success` use `result is success`. This feature will be removed in version 8 J2 W; l" [5 @" ]
2.9. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg.; U! R7 u2 G0 ^: P0 x
[DEPRECATION WARNING]: Using tests as filters is deprecated. Instead of using `result|success` use `result is success`. This feature will be removed in version 7 v/ H& C1 H# u( `
2.9. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg.
( ?, S7 q6 {, j2 R: ]ok: [controller2]9 v, ~$ J/ w+ W3 p$ [
ok: [controller3], E% Z- z! Z0 u6 _3 f+ P) x, G1 _0 Q
PLAY RECAP ********************************************************************************************************************************************************8 e. F# c, V, H
controller1 : ok=37 changed=6 unreachable=0 failed=0 skipped=15 rescued=0 ignored=0 ! V2 n$ s2 m; U8 |; s; S
controller2 : ok=37 changed=8 unreachable=0 failed=0 skipped=10 rescued=0 ignored=0 h- m- H- ]- S+ m0 f
controller3 : ok=31 changed=6 unreachable=0 failed=0 skipped=16 rescued=0 ignored=0
, |2 R; v( v3 [& Y7 p J# v% z
& a7 R8 r. q; h3 S恢复正常。- f3 z; a; j- t; D- N7 |
$ @( b) ~& L0 m
9 W9 h7 X( o: k2 U有时候通过一些特殊手段可以帮助我们解决一些特别的问题,与其长时间尝试老方法,不如来点新的方式试试或许不一样的效果。6 W3 b% e" ]3 p
/ z) O' _9 Q% ]7 Y3 Q0 H% e9 R. d1 i% v- _
我们首先是因为数据库恢复出问题,无法恢复数据,, 检查数据的库的值,
. l, ?9 O3 z' @1 M" [! Ecat /var/lib/docker/volumes/mariadb/_data/grastate.dat 中seqno值,若该值在所有节点中存在唯一得最大值
+ u- H- |' g3 G7 T7 }( ~% ]然后我们保留这个节点上数据,0 e+ J; [0 ^. I" k# C) x7 B
删除其他节点上的数据文件$ [' y& }! [7 g% W' N
然后通过scp或者rsync同步保留节点的数据文件 (根据个人喜好同步文件,本人建议使用rsync)) f& Y% c. g @" m5 @% ~6 o
然后再执行kolla-ansible数据库mariadb_recovery恢复命令:. M0 b' j# v# u6 h0 C8 V. ]
9 e! k M/ m' b5 w( }
4 a3 \$ c) T) n$ u1 R1 X s
, x; t8 z. r+ n9 S" ?( {' f W
/ v: ]) E$ ^8 \+ d4 o9 G& o差不多就可以完成数据库集群恢复了。
; T+ Z6 b7 B; G7 { |
|