Advertisement
TheJae

MariaDB Cluster Galera (Primary)

Oct 30th, 2014
336
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 9.85 KB | None | 0 0
  1. 141031 10:24:26 [Note] WSREP: (467a1d82-60a3-11e4-8419-420e1bb83a75, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://30.30.30.30:4567
  2. 141031 10:24:27 [Note] WSREP: (467a1d82-60a3-11e4-8419-420e1bb83a75, 'tcp://0.0.0.0:4567') reconnecting to 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0 (tcp://30.30.30.30:4567), attempt 0
  3. 141031 10:24:31 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, OPERATIONAL, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  4. 141031 10:24:31 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  5. 141031 10:24:32 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  6. 141031 10:24:32 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  7. 141031 10:24:33 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  8. 141031 10:24:33 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  9. 141031 10:24:34 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  10. 141031 10:24:34 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  11. 141031 10:24:35 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  12. 141031 10:24:35 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  13. 141031 10:24:36 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  14. 141031 10:24:36 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  15. 141031 10:24:37 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  16. 141031 10:24:37 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  17. 141031 10:24:38 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  18. 141031 10:24:38 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  19. 141031 10:24:39 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  20. 141031 10:24:39 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  21. 141031 10:24:40 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  22. 141031 10:24:40 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  23. 141031 10:24:41 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,2)) detected inactive node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  24. 141031 10:24:42 [Note] WSREP: view(view_id(NON_PRIM,467a1d82-60a3-11e4-8419-420e1bb83a75,2) memb {
  25.         467a1d82-60a3-11e4-8419-420e1bb83a75,0
  26. } joined {
  27. } left {
  28. } partitioned {
  29.         516e8fc1-60a3-11e4-8fc0-3bde09ed89e0,0
  30. })
  31. 141031 10:24:42 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
  32. 141031 10:24:42 [Note] WSREP: Flow-control interval: [16, 16]
  33. 141031 10:24:42 [Note] WSREP: Received NON-PRIMARY.
  34. 141031 10:24:42 [Note] WSREP: Shifting DONOR/DESYNCED -> OPEN (TO: 0)
  35. 141031 10:24:42 [Note] WSREP: (467a1d82-60a3-11e4-8419-420e1bb83a75, 'tcp://0.0.0.0:4567') turning message relay requesting off
  36. 141031 10:24:42 [Note] WSREP: view(view_id(NON_PRIM,467a1d82-60a3-11e4-8419-420e1bb83a75,3) memb {
  37.         467a1d82-60a3-11e4-8419-420e1bb83a75,0
  38. } joined {
  39. } left {
  40. } partitioned {
  41.         516e8fc1-60a3-11e4-8fc0-3bde09ed89e0,0
  42. })
  43. 141031 10:24:42 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
  44. 141031 10:24:42 [Note] WSREP: Flow-control interval: [16, 16]
  45. 141031 10:24:42 [Note] WSREP: Received NON-PRIMARY.
  46. 141031 10:24:45 [Note] WSREP: (467a1d82-60a3-11e4-8419-420e1bb83a75, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://30.30.30.30:4567
  47. 141031 10:24:46 [Note] WSREP: (467a1d82-60a3-11e4-8419-420e1bb83a75, 'tcp://0.0.0.0:4567') reconnecting to 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0 (tcp://30.30.30.30:4567), attempt 0
  48. 141031 10:24:47 [Note] WSREP: (467a1d82-60a3-11e4-8419-420e1bb83a75, 'tcp://0.0.0.0:4567') cleaning up established 0x7f5d39438200 which is duplicate of 0x7f5d2bfc6180
  49. 141031 10:24:47 [Note] WSREP: (467a1d82-60a3-11e4-8419-420e1bb83a75, 'tcp://0.0.0.0:4567') turning message relay requesting off
  50. 141031 10:24:51 [Note] WSREP: (467a1d82-60a3-11e4-8419-420e1bb83a75, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://30.30.30.30:4567
  51. 141031 10:24:52 [Note] WSREP: (467a1d82-60a3-11e4-8419-420e1bb83a75, 'tcp://0.0.0.0:4567') reconnecting to 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0 (tcp://30.30.30.30:4567), attempt 0
  52. 141031 10:24:52 [Note] WSREP: (467a1d82-60a3-11e4-8419-420e1bb83a75, 'tcp://0.0.0.0:4567') turning message relay requesting off
  53. 141031 10:24:52 [Note] WSREP: (467a1d82-60a3-11e4-8419-420e1bb83a75, 'tcp://0.0.0.0:4567') cleaning up duplicate 0x7f5d39437d80 after established 0x7f5d2bfc6180
  54. 141031 10:24:53 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,3)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  55. 141031 10:24:53 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,3)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  56. 141031 10:24:54 [Note] WSREP: evs::proto(467a1d82-60a3-11e4-8419-420e1bb83a75, GATHER, view_id(REG,467a1d82-60a3-11e4-8419-420e1bb83a75,3)) suspecting node: 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0
  57. 141031 10:24:55 [Note] WSREP: declaring 516e8fc1-60a3-11e4-8fc0-3bde09ed89e0 stable
  58. 141031 10:24:55 [Note] WSREP: re-bootstrapping prim from partitioned components
  59. 141031 10:24:55 [Note] WSREP: view(view_id(PRIM,467a1d82-60a3-11e4-8419-420e1bb83a75,4) memb {
  60.         467a1d82-60a3-11e4-8419-420e1bb83a75,0
  61.         516e8fc1-60a3-11e4-8fc0-3bde09ed89e0,0
  62. } joined {
  63. } left {
  64. } partitioned {
  65. })
  66. 141031 10:24:55 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2
  67. 141031 10:24:55 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 1a3e3474-60a5-11e4-9ccb-eb9dd184bc64
  68. 141031 10:24:55 [Note] WSREP: STATE EXCHANGE: sent state msg: 1a3e3474-60a5-11e4-9ccb-eb9dd184bc64
  69. 141031 10:24:55 [Note] WSREP: STATE EXCHANGE: got state msg: 1a3e3474-60a5-11e4-9ccb-eb9dd184bc64 from 0 (vvalu_master_local)
  70. 141031 10:24:55 [Note] WSREP: STATE EXCHANGE: got state msg: 1a3e3474-60a5-11e4-9ccb-eb9dd184bc64 from 1 (vvalu_china_1)
  71. 141031 10:24:55 [Warning] WSREP: Quorum: No node with complete state:
  72.  
  73.  
  74.         Version      : 3
  75.         Flags        : 0x3
  76.         Protocols    : 0 / 5 / 3
  77.         State        : NON-PRIMARY
  78.         Prim state   : DONOR
  79.         Prim UUID    : 51d731ef-60a3-11e4-8ecd-5a0f37b3d4ad
  80.         Prim  seqno  : 2
  81.         First seqno  : -1
  82.         Last  seqno  : 0
  83.         Prim JOINED  : 1
  84.         State UUID   : 1a3e3474-60a5-11e4-9ccb-eb9dd184bc64
  85.         Group UUID   : 20156cae-60a2-11e4-b7d8-0abd6e366161
  86.         Name         : 'vvalu_master_local'
  87.         Incoming addr: '10.10.10.10:3306'
  88.  
  89.         Version      : 3
  90.         Flags        : 00
  91.         Protocols    : 0 / 5 / 3
  92.         State        : NON-PRIMARY
  93.         Prim state   : JOINER
  94.         Prim UUID    : 51d731ef-60a3-11e4-8ecd-5a0f37b3d4ad
  95.         Prim  seqno  : 2
  96.         First seqno  : -1
  97.         Last  seqno  : 0
  98.         Prim JOINED  : 1
  99.         State UUID   : 1a3e3474-60a5-11e4-9ccb-eb9dd184bc64
  100.         Group UUID   : 20156cae-60a2-11e4-b7d8-0abd6e366161
  101.         Name         : 'vvalu_china_1'
  102.         Incoming addr: '30.30.30.30:3306'
  103.  
  104. 141031 10:24:55 [Note] WSREP: Full re-merge of primary 51d731ef-60a3-11e4-8ecd-5a0f37b3d4ad found: 1 of 1.
  105. 141031 10:24:55 [Note] WSREP: Quorum results:
  106.         version    = 3,
  107.         component  = PRIMARY,
  108.         conf_id    = 2,
  109.         members    = 1/2 (joined/total),
  110.         act_id     = 0,
  111.         last_appl. = 0,
  112.         protocols  = 0/5/3 (gcs/repl/appl),
  113.         group UUID = 20156cae-60a2-11e4-b7d8-0abd6e366161
  114. 141031 10:24:55 [Note] WSREP: Flow-control interval: [23, 23]
  115. 141031 10:24:55 [Note] WSREP: Restored state OPEN -> DONOR/DESYNCED (0)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement