API tools faq
paste
Advertisement
TheJae

MariaDB Cluster Galera (Node)

TheJae
Oct 30th, 2014
321
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 13.99 KB | None | 0 0
raw download clone embed print report
  1. 141031  10:24:25 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.10.10.10:4567
  2. 141031  10:24:27 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') reconnecting to 467a1d82-60a3-11e4-8419-420e1bb83a75 (tcp://10.10.10.10:4567), attempt 0
  3. 141031  10:24:28 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, OPERATIONAL, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  4. 141031  10:24:28 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  5. 141031  10:24:29 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  6. 141031  10:24:29 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  7. 141031  10:24:30 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  8. 141031  10:24:30 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  9. 141031  10:24:31 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  10. 141031  10:24:31 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  11. 141031  10:24:32 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  12. 141031  10:24:32 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  13. 141031  10:24:33 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  14. 141031  10:24:33 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  15. 141031  10:24:34 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  16. 141031  10:24:34 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  17. 141031  10:24:35 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  18. 141031  10:24:35 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  19. 141031  10:24:36 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  20. 141031  10:24:36 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  21. 141031  10:24:37 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  22. 141031  10:24:37 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  23. 141031  10:24:38 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) detected inactive node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  24. 141031  10:24:39 [Note] WSREP: view(view_id(NON_PRIM,467a1d82-60a3-11e4-8419-420e1bb83a75,2) memb {
  25.         516e8fc1-60a3-11e4-8fc0-3bde09ed89e0,0
  26. } joined {
  27. } left {
  28. } partitioned {
  29.         467a1d82-60a3-11e4-8419-420e1bb83a75,0
  30. })
  31. 141031  10:24:39 [Note] WSREP: view(view_id(NON_PRIM,516e8fc1-60a3-11e4-8fc0-3bde09ed89e0,3) memb {
  32.         516e8fc1-60a3-11e4-8fc0-3bde09ed89e0,0
  33. } joined {
  34. } left {
  35. } partitioned {
  36.         467a1d82-60a3-11e4-8419-420e1bb83a75,0
  37. })
  38. 141031  10:24:39 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
  39. 141031  10:24:39 [Note] WSREP: Flow-control interval: [16, 16]
  40. 141031  10:24:39 [Note] WSREP: Received NON-PRIMARY.
  41. 141031  10:24:39 [Note] WSREP: Shifting JOINER -> OPEN (TO: 0)
  42. 141031  10:24:39 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
  43. 141031  10:24:39 [Note] WSREP: Flow-control interval: [16, 16]
  44. 141031  10:24:39 [Note] WSREP: Received NON-PRIMARY.
  45. 141031  10:24:47 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') cleaning up duplicate 0x7f5879c38200 after established 0x7f5879c38380
  46. 141031  10:24:48 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') turning message relay requesting off
  47. 141031  10:24:48 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') address 'tcp://30.30.30.30:4567' pointing to uuid 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0 is blacklisted, skipping
  48. 141031  10:24:51 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.10.10.10:4567
  49. 141031  10:24:52 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') reconnecting to 467a1d82-60a3-11e4-8419-420e1bb83a75 (tcp://10.10.10.10:4567), attempt 0
  50. 141031  10:24:52 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') address 'tcp://30.30.30.30:4567' pointing to uuid 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0 is blacklisted, skipping
  51. 141031  10:24:52 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') turning message relay requesting off
  52. 141031  10:24:52 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') cleaning up duplicate 0x7f5879c38200 after established 0x7f5879c37d80
  53. 141031  10:24:52 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') address 'tcp://30.30.30.30:4567' pointing to uuid 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0 is blacklisted, skipping
  54. 141031  10:24:55 [Note] WSREP: declaring 467a1d82-60a3-11e4-8419-420e1bb83a75 stable
  55. 141031  10:24:55 [Note] WSREP: re-bootstrapping prim from partitioned components
  56. 141031  10:24:55 [Note] WSREP: view(view_id(PRIM,467a1d82-60a3-11e4-8419-420e1bb83a75,4) memb {
  57.         467a1d82-60a3-11e4-8419-420e1bb83a75,0
  58.         516e8fc1-60a3-11e4-8fc0-3bde09ed89e0,0
  59. } joined {
  60. } left {
  61. } partitioned {
  62. })
  63. 141031  10:24:55 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2
  64. 141031  10:24:55 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
  65. 141031  10:24:55 [Note] WSREP: STATE EXCHANGE: sent state msg: 1a3e3474-60a5-11e4-9ccb-eb9dd184bc64
  66. 141031  10:24:55 [Note] WSREP: STATE EXCHANGE: got state msg: 1a3e3474-60a5-11e4-9ccb-eb9dd184bc64 from 0 (vvalu_master_local)
  67. 141031  10:24:55 [Note] WSREP: STATE EXCHANGE: got state msg: 1a3e3474-60a5-11e4-9ccb-eb9dd184bc64 from 1 (vvalu_china_1)
  68. 141031  10:24:55 [Warning] WSREP: Quorum: No node with complete state:
  69.  
  70.  
  71.         Version      : 3
  72.         Flags        : 0x3
  73.         Protocols    : 0 / 5 / 3
  74.         State        : NON-PRIMARY
  75.         Prim state   : DONOR
  76.         Prim UUID    : 51d731ef-60a3-11e4-8ecd-5a0f37b3d4ad
  77.         Prim  seqno  : 2
  78.         First seqno  : -1
  79.         Last  seqno  : 0
  80.         Prim JOINED  : 1
  81.         State UUID   : 1a3e3474-60a5-11e4-9ccb-eb9dd184bc64
  82.         Group UUID   : 20156cae-60a2-11e4-b7d8-0abd6e366161
  83.         Name         : 'vvalu_master_local'
  84.         Incoming addr: '10.10.10.10:3306'
  85.  
  86.         Version      : 3
  87.         Flags        : 00
  88.         Protocols    : 0 / 5 / 3
  89.         State        : NON-PRIMARY
  90.         Prim state   : JOINER
  91.         Prim UUID    : 51d731ef-60a3-11e4-8ecd-5a0f37b3d4ad
  92.         Prim  seqno  : 2
  93.         First seqno  : -1
  94.         Last  seqno  : 0
  95.         Prim JOINED  : 1
  96.         State UUID   : 1a3e3474-60a5-11e4-9ccb-eb9dd184bc64
  97.         Group UUID   : 20156cae-60a2-11e4-b7d8-0abd6e366161
  98.         Name         : 'vvalu_china_1'
  99.         Incoming addr: '30.30.30.30:3306'
  100.  
  101. 141031  10:24:55 [Note] WSREP: Full re-merge of primary 51d731ef-60a3-11e4-8ecd-5a0f37b3d4ad found: 1 of 1.
  102. 141031  10:24:55 [Note] WSREP: Quorum results:
  103.         version    = 3,
  104.         component  = PRIMARY,
  105.         conf_id    = 2,
  106.         members    = 1/2 (joined/total),
  107.         act_id     = 0,
  108.         last_appl. = -1,
  109.         protocols  = 0/5/3 (gcs/repl/appl),
  110.         group UUID = 20156cae-60a2-11e4-b7d8-0abd6e366161
  111. 141031  10:24:55 [Note] WSREP: Flow-control interval: [23, 23]
  112. 141031  10:24:55 [Note] WSREP: Restored state OPEN -> JOINER (0)
  113. 141031  10:25:14 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.10.10.10:4567
  114. 141031  10:25:15 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') reconnecting to 467a1d82-60a3-11e4-8419-420e1bb83a75 (tcp://10.10.10.10:4567), attempt 0
  115. 141031  10:25:16 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') address 'tcp://30.30.30.30:4567' pointing to uuid 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0 is blacklisted, skipping
  116. 141031  10:25:16 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') turning message relay requesting off
  117. 141031  10:25:16 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, OPERATIONAL, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,4)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  118. 141031  10:25:17 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,4)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  119. 141031  10:25:17 [Note] WSREP: evs::proto(516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,4)) suspecting node: 467a1d82-60a3-11e4-8419-420e1bb83a75
  120. 141031  10:25:19 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') address 'tcp://30.30.30.30:4567' pointing to uuid 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0 is blacklisted, skipping
  121. 141031  10:25:23 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.10.10.10:4567
  122. 141031  10:25:24 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') reconnecting to 467a1d82-60a3-11e4-8419-420e1bb83a75 (tcp://10.10.10.10:4567), attempt 0
  123. 141031  10:25:25 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') address 'tcp://30.30.30.30:4567' pointing to uuid 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0 is blacklisted, skipping
  124. 141031  10:25:25 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') turning message relay requesting off
  125. 141031  10:25:29 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.10.10.10:4567
  126. 141031  10:25:30 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') reconnecting to 467a1d82-60a3-11e4-8419-420e1bb83a75 (tcp://10.10.10.10:4567), attempt 0
  127. 141031  10:25:30 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') address 'tcp://30.30.30.30:4567' pointing to uuid 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0 is blacklisted, skipping
  128. 141031  10:25:30 [Note] WSREP: (516e8fc1-60a3-11e4-8fc0-3bde09ed89e0, 'tcp://0.0.0.0:4567') turning message relay requesting off
  129. 141031  10:25:30 [Warning] WSREP: subsequent views have same members, prev view view(view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,4) memb {
  130.         467a1d82-60a3-11e4-8419-420e1bb83a75,0
  131.         516e8fc1-60a3-11e4-8fc0-3bde09ed89e0,0
  132. } joined {
  133. } left {
  134. } partitioned {
  135. }) current view view(view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,15) memb {
  136.         467a1d82-60a3-11e4-8419-420e1bb83a75,0
  137.         516e8fc1-60a3-11e4-8fc0-3bde09ed89e0,0
  138. } joined {
  139. } left {
  140. } partitioned {
  141. })
  142. 141031  10:25:30 [Note] WSREP: declaring 467a1d82-60a3-11e4-8419-420e1bb83a75 stable
  143. 141031  10:25:30 [Note] WSREP: Node 467a1d82-60a3-11e4-8419-420e1bb83a75 state prim
  144. 141031  10:25:30 [Note] WSREP: view(view_id(PRIM,467a1d82-60a3-11e4-8419-420e1bb83a75,15) memb {
  145.         467a1d82-60a3-11e4-8419-420e1bb83a75,0
  146.         516e8fc1-60a3-11e4-8fc0-3bde09ed89e0,0
  147. } joined {
  148. } left {
  149. } partitioned {
  150. })
  151. 141031  10:25:30 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2
  152. 141031  10:25:30 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
  153. 141031  10:25:30 [Note] WSREP: STATE EXCHANGE: sent state msg: 2f415ad9-60a5-11e4-9a2f-fa30a26bdc10
  154. 141031  10:25:30 [Note] WSREP: STATE EXCHANGE: got state msg: 2f415ad9-60a5-11e4-9a2f-fa30a26bdc10 from 0 (vvalu_master_local)
  155. 141031  10:25:30 [Note] WSREP: STATE EXCHANGE: got state msg: 2f415ad9-60a5-11e4-9a2f-fa30a26bdc10 from 1 (vvalu_china_1)
  156. 141031  10:25:30 [Note] WSREP: Quorum results:
  157.         version    = 3,
  158.         component  = PRIMARY,
  159.         conf_id    = 3,
  160.         members    = 1/2 (joined/total),
  161.         act_id     = 0,
  162.         last_appl. = 0,
  163.         protocols  = 0/5/3 (gcs/repl/appl),
  164.         group UUID = 20156cae-60a2-11e4-b7d8-0abd6e366161
  165. 141031  10:25:30 [Note] WSREP: Flow-control interval: [23, 23]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!