API tools faq
paste
Advertisement
sdjason

Untitled

sdjason
Feb 15th, 2019
30
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 45.68 KB | None | 0 0
raw download clone embed print report
  1. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: Read nil XID from storage engines, skipping position init
  2. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so'
  3. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: wsrep_load(): Galera 25.3.25(r3836) by Codership Oy <info@codership.com> loaded successfully.
  4. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: CRC-32C: using hardware acceleration.
  5. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 0
  6. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.102.9.32; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 2G; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 2G; gcache.recover = no; gcache.size = 2G; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 0.8; gcs.fc_limit = 80; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.
  7. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: GCache history reset: 6e73cc2c-4a23-11e8-8a1c-dad50e2e7640:0 -> 00000000-0000-0000-0000-000000000000:-1
  8. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
  9. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: wsrep_sst_grab()
  10. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: Start replication
  11. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
  12. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: protonet asio version 0
  13. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: Using CRC-32C for message checksums.
  14. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: backend: asio
  15. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: gcomm thread scheduling priority set to other:0
  16. 2019-02-15 15:49:14 140696895580352 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
  17. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: restore pc from disk failed
  18. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: GMCast version 0
  19. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: (276e0ca9, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
  20. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: (276e0ca9, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
  21. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: EVS version 0
  22. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: gcomm: connecting to group 'Foreman_NP', peer '10.101.9.27:,10.102.9.32:,10.101.9.79:'
  23. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: (276e0ca9, 'tcp://0.0.0.0:4567') connection established to 276e0ca9 tcp://10.102.9.32:4567
  24. 2019-02-15 15:49:14 140696895580352 [Warning] WSREP: (276e0ca9, 'tcp://0.0.0.0:4567') address 'tcp://10.102.9.32:4567' points to own listening address, blacklisting
  25. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: (276e0ca9, 'tcp://0.0.0.0:4567') connection established to 76849070 tcp://10.101.9.27:4567
  26. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: (276e0ca9, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
  27. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: (276e0ca9, 'tcp://0.0.0.0:4567') connection established to 521c7c8c tcp://10.101.9.79:4567
  28. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: declaring 521c7c8c at tcp://10.101.9.79:4567 stable
  29. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: declaring 76849070 at tcp://10.101.9.27:4567 stable
  30. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: Node 521c7c8c state prim
  31. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: view(view_id(PRIM,276e0ca9,28) memb {
  32. 276e0ca9,0
  33. 521c7c8c,0
  34. 76849070,0
  35. } joined {
  36. } left {
  37. } partitioned {
  38. })
  39. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: save pc into disk
  40. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: gcomm: connected
  41. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
  42. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
  43. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: Opened channel 'Foreman_NP'
  44. 2019-02-15 15:49:14 140696895580352 [Note] WSREP: Waiting for SST to complete.
  45. 2019-02-15 15:49:14 140693699798784 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3
  46. 2019-02-15 15:49:14 140693699798784 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 27ba9ffe-3163-11e9-9b62-36bc5df7905c
  47. 2019-02-15 15:49:14 140693699798784 [Note] WSREP: STATE EXCHANGE: sent state msg: 27ba9ffe-3163-11e9-9b62-36bc5df7905c
  48. 2019-02-15 15:49:14 140693699798784 [Note] WSREP: STATE EXCHANGE: got state msg: 27ba9ffe-3163-11e9-9b62-36bc5df7905c from 0 (fmndbnph1)
  49. 2019-02-15 15:49:14 140693699798784 [Note] WSREP: STATE EXCHANGE: got state msg: 27ba9ffe-3163-11e9-9b62-36bc5df7905c from 1 (fmndbnpw2)
  50. 2019-02-15 15:49:14 140693699798784 [Note] WSREP: STATE EXCHANGE: got state msg: 27ba9ffe-3163-11e9-9b62-36bc5df7905c from 2 (fmndbnpw1)
  51. 2019-02-15 15:49:14 140693699798784 [Note] WSREP: Quorum results:
  52. version = 4,
  53. component = PRIMARY,
  54. conf_id = 24,
  55. members = 2/3 (joined/total),
  56. act_id = 16869344,
  57. last_appl. = -1,
  58. protocols = 0/9/3 (gcs/repl/appl),
  59. group UUID = 6e73cc2c-4a23-11e8-8a1c-dad50e2e7640
  60. 2019-02-15 15:49:14 140693699798784 [Note] WSREP: Flow-control interval: [111, 139]
  61. 2019-02-15 15:49:14 140693699798784 [Note] WSREP: Trying to continue unpaused monitor
  62. 2019-02-15 15:49:14 140693699798784 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 16869344)
  63. 2019-02-15 15:49:14 140695951685376 [Note] WSREP: State transfer required:
  64. Group state: 6e73cc2c-4a23-11e8-8a1c-dad50e2e7640:16869344
  65. Local state: 00000000-0000-0000-0000-000000000000:-1
  66. 2019-02-15 15:49:14 140695951685376 [Note] WSREP: New cluster view: global state: 6e73cc2c-4a23-11e8-8a1c-dad50e2e7640:16869344, view# 25: Primary, number of nodes: 3, my index: 0, protocol version 3
  67. 2019-02-15 15:49:14 140695951685376 [Warning] WSREP: Gap in state sequence. Need state transfer.
  68. 2019-02-15 15:49:14 140693691406080 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '10.102.9.32' --datadir '/var/lib/mysql/' --parent '29827' --binlog '/var/log/mysql/mysql-bin' '''
  69. WSREP_SST: [INFO] Streaming with xbstream (20190215 15:49:15.104)
  70. WSREP_SST: [INFO] Using socat as streamer (20190215 15:49:15.106)
  71. WSREP_SST: [INFO] Stale sst_in_progress file: /var/lib/mysql//sst_in_progress (20190215 15:49:15.109)
  72. WSREP_SST: [INFO] Evaluating timeout -k 110 100 socat -u TCP-LISTEN:4444,reuseaddr stdio | mbstream -x; RC=( ${PIPESTATUS[@]} ) (20190215 15:49:15.134)
  73. 2019-02-15 15:49:15 140695951685376 [Note] WSREP: Prepared SST request: mariabackup|10.102.9.32:4444/xtrabackup_sst//1
  74. 2019-02-15 15:49:15 140695951685376 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  75. 2019-02-15 15:49:15 140695951685376 [Note] WSREP: REPL Protocols: 9 (4, 2)
  76. 2019-02-15 15:49:15 140695951685376 [Note] WSREP: Assign initial position for certification: 16869344, protocol version: 4
  77. 2019-02-15 15:49:15 140695960348416 [Note] WSREP: Service thread queue flushed.
  78. 2019-02-15 15:49:15 140695951685376 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (6e73cc2c-4a23-11e8-8a1c-dad50e2e7640): 1 (Operation not permitted)
  79. at galera/src/replicator_str.cpp:prepare_for_IST():482. IST will be unavailable.
  80. 2019-02-15 15:49:15 140693699798784 [Note] WSREP: Member 0.0 (fmndbnph1) requested state transfer from '*any*'. Selected 1.0 (fmndbnpw2)(SYNCED) as donor.
  81. 2019-02-15 15:49:15 140693699798784 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 16869350)
  82. 2019-02-15 15:49:15 140695951685376 [Note] WSREP: Requesting state transfer: success, donor: 1
  83. 2019-02-15 15:49:15 140695951685376 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 6e73cc2c-4a23-11e8-8a1c-dad50e2e7640:16869344
  84. *** Error in `/usr/sbin/mysqld': free(): invalid pointer: 0x00007ff5c0001198 ***
  85. ======= Backtrace: =========
  86. /lib64/libc.so.6(+0x81489)[0x7ff68a6c2489]
  87. /usr/lib64/galera/libgalera_smm.so(_ZN6gcache8MemStore11seqno_resetEv+0x5f)[0x7ff654de29af]
  88. /usr/lib64/galera/libgalera_smm.so(_ZN6gcache6GCache11seqno_resetERKN2gu4UUIDEl+0x6e8)[0x7ff654dcde68]
  89. /usr/lib64/galera/libgalera_smm.so(_ZN6galera13ReplicatorSMM22request_state_transferEPvRK10wsrep_uuidlPKvl+0xc0)[0x7ff654f0e4a0]
  90. /usr/lib64/galera/libgalera_smm.so(_ZN6galera13ReplicatorSMM19process_conf_changeEPvRK15wsrep_view_infoiNS_10Replicator5StateEl+0x7d6)[0x7ff654f03de6]
  91. /usr/lib64/galera/libgalera_smm.so(_ZN6galera15GcsActionSource8dispatchEPvRK10gcs_actionRb+0x50c)[0x7ff654ede3ac]
  92. /usr/lib64/galera/libgalera_smm.so(_ZN6galera15GcsActionSource7processEPvRb+0x4c)[0x7ff654edf74c]
  93. /usr/lib64/galera/libgalera_smm.so(_ZN6galera13ReplicatorSMM10async_recvEPv+0x6b)[0x7ff654f0318b]
  94. /usr/lib64/galera/libgalera_smm.so(galera_recv+0x18)[0x7ff654f11178]
  95. /usr/sbin/mysqld(+0x615e24)[0x5591ec06fe24]
  96. /usr/sbin/mysqld(start_wsrep_THD+0x432)[0x5591ec05f6d2]
  97. /lib64/libpthread.so.0(+0x7dd5)[0x7ff68c39bdd5]
  98. /lib64/libc.so.6(clone+0x6d)[0x7ff68a73eead]
  99. ======= Memory map: ========
  100. 5591eba5a000-5591ecb76000 r-xp 00000000 fd:02 8596308 /usr/sbin/mysqld
  101. 5591ecd76000-5591ece4f000 r--p 0111c000 fd:02 8596308 /usr/sbin/mysqld
  102. 5591ece4f000-5591ecf06000 rw-p 011f5000 fd:02 8596308 /usr/sbin/mysqld
  103. 5591ecf06000-5591ed79a000 rw-p 00000000 00:00 0
  104. 5591eecf0000-5591eeea4000 rw-p 00000000 00:00 0 [heap]
  105. 7ff5b0000000-7ff5b0021000 rw-p 00000000 00:00 0
  106. 7ff5b0021000-7ff5b4000000 ---p 00000000 00:00 0
  107. 7ff5b8000000-7ff5b8021000 rw-p 00000000 00:00 0
  108. 7ff5b8021000-7ff5bc000000 ---p 00000000 00:00 0
  109. 7ff5bc000000-7ff5bc021000 rw-p 00000000 00:00 0
  110. 7ff5bc021000-7ff5c0000000 ---p 00000000 00:00 0
  111. 7ff5c0000000-7ff5c0021000 rw-p 00000000 00:00 0
  112. 7ff5c0021000-7ff5c4000000 ---p 00000000 00:00 0
  113. 7ff5c4000000-7ff5c4021000 rw-p 00000000 00:00 0
  114. 7ff5c4021000-7ff5c8000000 ---p 00000000 00:00 0
  115. 7ff5c8000000-7ff5c8021000 rw-p 00000000 00:00 0
  116. 7ff5c8021000-7ff5cc000000 ---p 00000000 00:00 0
  117. 7ff5ccff9000-7ff5ccffa000 ---p 00000000 00:00 0
  118. 7ff5ccffa000-7ff5cd7fa000 rw-p 00000000 00:00 0
  119. 7ff5cd7fa000-7ff5cd7fb000 ---p 00000000 00:00 0
  120. 7ff5cd7fb000-7ff5cdffb000 rw-p 00000000 00:00 0
  121. 7ff5cdffb000-7ff5cdffc000 ---p 00000000 00:00 0
  122. 7ff5cdffc000-7ff5cffff000 rw-p 00000000 00:00 0
  123. 7ff5cffff000-7ff650000000 rw-s 00000000 fd:06 246083 /var/lib/mysql/galera.cache
  124. 7ff650000000-7ff650021000 rw-p 00000000 00:00 0
  125. 7ff650021000-7ff654000000 ---p 00000000 00:00 0
  126. 7ff654311000-7ff65434a000 rw-p 00000000 00:00 0
  127. 7ff65434a000-7ff65434b000 ---p 00000000 00:00 0
  128. 7ff65434b000-7ff65438c000 rw-p 00000000 00:00 0
  129. 7ff65438c000-7ff65438d000 ---p 00000000 00:00 0
  130. 7ff65438d000-7ff6543ce000 rw-p 00000000 00:00 0
  131. 7ff6543ce000-7ff6543cf000 ---p 00000000 00:00 0
  132. 7ff6543cf000-7ff654d12000 rw-p 00000000 00:00 0
  133. 7ff654d12000-7ff654f6c000 r-xp 00000000 fd:02 16916272 /usr/lib64/galera/libgalera_smm.so
  134. 7ff654f6c000-7ff65516b000 ---p 0025a000 fd:02 16916272 /usr/lib64/galera/libgalera_smm.so
  135. 7ff65516b000-7ff655172000 r--p 00259000 fd:02 16916272 /usr/lib64/galera/libgalera_smm.so
  136. 7ff655172000-7ff655176000 rw-p 00260000 fd:02 16916272 /usr/lib64/galera/libgalera_smm.so
  137. 7ff655176000-7ff655178000 rw-p 00000000 00:00 0
  138. 7ff655178000-7ff655179000 ---p 00000000 00:00 0
  139. 7ff655179000-7ff6559fa000 rw-p 00000000 00:00 0
  140. 7ff6559fa000-7ff655a06000 r-xp 00000000 fd:02 8492545 /usr/lib64/libnss_files-2.17.so
  141. 7ff655a06000-7ff655c05000 ---p 0000c000 fd:02 8492545 /usr/lib64/libnss_files-2.17.so
  142. 7ff655c05000-7ff655c06000 r--p 0000b000 fd:02 8492545 /usr/lib64/libnss_files-2.17.so
  143. 7ff655c06000-7ff655c07000 rw-p 0000c000 fd:02 8492545 /usr/lib64/libnss_files-2.17.so
  144. 7ff655c07000-7ff687ae1000 rw-p 00000000 00:00 0
  145. 7ff687ae1000-7ff687ae4000 r-xp 00000000 fd:02 8453969 /usr/lib64/libkeyutils.so.1.5
  146. 7ff687ae4000-7ff687ce3000 ---p 00003000 fd:02 8453969 /usr/lib64/libkeyutils.so.1.5
  147. 7ff687ce3000-7ff687ce4000 r--p 00002000 fd:02 8453969 /usr/lib64/libkeyutils.so.1.5
  148. 7ff687ce4000-7ff687ce5000 rw-p 00003000 fd:02 8453969 /usr/lib64/libkeyutils.so.1.5
  149. 7ff687ce5000-7ff687cf3000 r-xp 00000000 fd:02 8433622 /usr/lib64/libkrb5support.so.0.1
  150. 7ff687cf3000-7ff687ef3000 ---p 0000e000 fd:02 8433622 /usr/lib64/libkrb5support.so.0.1
  151. 7ff687ef3000-7ff687ef4000 r--p 0000e000 fd:02 8433622 /usr/lib64/libkrb5support.so.0.1
  152. 7ff687ef4000-7ff687ef5000 rw-p 0000f000 fd:02 8433622 /usr/lib64/libkrb5support.so.0.1
  153. 7ff687ef5000-7ff687f04000 r-xp 00000000 fd:02 8453652 /usr/lib64/libbz2.so.1.0.6
  154. 7ff687f04000-7ff688103000 ---p 0000f000 fd:02 8453652 /usr/lib64/libbz2.so.1.0.6
  155. 7ff688103000-7ff688104000 r--p 0000e000 fd:02 8453652 /usr/lib64/libbz2.so.1.0.6
  156. 7ff688104000-7ff688105000 rw-p 0000f000 fd:02 8453652 /usr/lib64/libbz2.so.1.0.6
  157. 7ff688105000-7ff68811c000 r-xp 00000000 fd:02 8462049 /usr/lib64/libelf-0.172.so
  158. 7ff68811c000-7ff68831b000 ---p 00017000 fd:02 8462049 /usr/lib64/libelf-0.172.so
  159. 7ff68831b000-7ff68831c000 r--p 00016000 fd:02 8462049 /usr/lib64/libelf-0.172.so
  160. 7ff68831c000-7ff68831d000 rw-p 00017000 fd:02 8462049 /usr/lib64/libelf-0.172.so
  161. 7ff68831d000-7ff68837d000 r-xp 00000000 fd:02 8433630 /usr/lib64/libpcre.so.1.2.0
  162. 7ff68837d000-7ff68857d000 ---p 00060000 fd:02 8433630 /usr/lib64/libpcre.so.1.2.0
  163. 7ff68857d000-7ff68857e000 r--p 00060000 fd:02 8433630 /usr/lib64/libpcre.so.1.2.0
  164. 7ff68857e000-7ff68857f000 rw-p 00061000 fd:02 8433630 /usr/lib64/libpcre.so.1.2.0
  165. 7ff68857f000-7ff688583000 r-xp 00000000 fd:02 8453925 /usr/lib64/libattr.so.1.1.0
  166. 7ff688583000-7ff688782000 ---p 00004000 fd:02 8453925 /usr/lib64/libattr.so.1.1.0
  167. 7ff688782000-7ff688783000 r--p 00003000 fd:02 8453925 /usr/lib64/libattr.so.1.1.0
  168. 7ff688783000-7ff688784000 rw-p 00004000 fd:02 8453925 /usr/lib64/libattr.so.1.1.0
  169. 7ff688784000-7ff6887b5000 r-xp 00000000 fd:02 8389790 /usr/lib64/libk5crypto.so.3.1
  170. 7ff6887b5000-7ff6889b4000 ---p 00031000 fd:02 8389790 /usr/lib64/libk5crypto.so.3.1
  171. 7ff6889b4000-7ff6889b6000 r--p 00030000 fd:02 8389790 /usr/lib64/libk5crypto.so.3.1
  172. 7ff6889b6000-7ff6889b7000 rw-p 00032000 fd:02 8389790 /usr/lib64/libk5crypto.so.3.1
  173. 7ff6889b7000-7ff6889ba000 r-xp 00000000 fd:02 8433570 /usr/lib64/libcom_err.so.2.1
  174. 7ff6889ba000-7ff688bb9000 ---p 00003000 fd:02 8433570 /usr/lib64/libcom_err.so.2.1
  175. 7ff688bb9000-7ff688bba000 r--p 00002000 fd:02 8433570 /usr/lib64/libcom_err.so.2.1
  176. 7ff688bba000-7ff688bbb000 rw-p 00003000 fd:02 8433570 /usr/lib64/libcom_err.so.2.1
  177. 7ff688bbb000-7ff688c94000 r-xp 00000000 fd:02 8433619 /usr/lib64/libkrb5.so.3.3
  178. 7ff688c94000-7ff688e93000 ---p 000d9000 fd:02 8433619 /usr/lib64/libkrb5.so.3.3
  179. 7ff688e93000-7ff688ea1000 r--p 000d8000 fd:02 8433619 /usr/lib64/libkrb5.so.3.3
  180. 7ff688ea1000-7ff688ea4000 rw-p 000e6000 fd:02 8433619 /usr/lib64/libkrb5.so.3.3
  181. 7ff688ea4000-7ff688eee000 r-xp 00000000 fd:02 8389785 /usr/lib64/libgssapi_krb5.so.2.2
  182. 7ff688eee000-7ff6890ee000 ---p 0004a000 fd:02 8389785 /usr/lib64/libgssapi_krb5.so.2.2
  183. 7ff6890ee000-7ff6890ef000 r--p 0004a000 fd:02 8389785 /usr/lib64/libgssapi_krb5.so.2.2
  184. 7ff6890ef000-7ff6890f1000 rw-p 0004b000 fd:02 8389785 /usr/lib64/libgssapi_krb5.so.2.2
  185. 7ff6890f1000-7ff689106000 r-xp 00000000 fd:02 8697129 /usr/lib64/libgcc_s-4.8.5-20150702.so.1
  186. 7ff689106000-7ff689305000 ---p 00015000 fd:02 8697129 /usr/lib64/libgcc_s-4.8.5-20150702.so.1
  187. 7ff689305000-7ff689306000 r--p 00014000 fd:02 8697129 /usr/lib64/libgcc_s-4.8.5-20150702.so.1
  188. 7ff689306000-7ff689307000 rw-p 00015000 fd:02 8697129 /usr/lib64/libgcc_s-4.8.5-20150702.so.1
  189. 7ff689307000-7ff689353000 r-xp 00000000 fd:02 8722170 /usr/lib64/libdw-0.172.so
  190. 7ff689353000-7ff689553000 ---p 0004c000 fd:02 8722170 /usr/lib64/libdw-0.172.so
  191. 7ff689553000-7ff689555000 r--p 0004c000 fd:02 8722170 /usr/lib64/libdw-0.172.so
  192. 7ff689555000-7ff689556000 rw-p 0004e000 fd:02 8722170 /usr/lib64/libdw-0.172.so
  193. 7ff689556000-7ff68956c000 r-xp 00000000 fd:02 8492590 /usr/lib64/libresolv-2.17.so
  194. 7ff68956c000-7ff68976b000 ---p 00016000 fd:02 8492590 /usr/lib64/libresolv-2.17.so
  195. 7ff68976b000-7ff68976c000 r--p 00015000 fd:02 8492590 /usr/lib64/libresolv-2.17.so
  196. 7ff68976c000-7ff68976d000 rw-p 00016000 fd:02 8492590 /usr/lib64/libresolv-2.17.so
  197. 7ff68976d000-7ff68976f000 rw-p 00000000 00:00 0
  198. 7ff68976f000-7ff689773000 r-xp 00000000 fd:02 8453909 /usr/lib64/libgpg-error.so.0.10.0
  199. 7ff689773000-7ff689972000 ---p 00004000 fd:02 8453909 /usr/lib64/libgpg-error.so.0.10.0
  200. 7ff689972000-7ff689973000 r--p 00003000 fd:02 8453909 /usr/lib64/libgpg-error.so.0.10.0
  201. 7ff689973000-7ff689974000 rw-p 00004000 fd:02 8453909 /usr/lib64/libgpg-error.so.0.10.0
  202. 7ff689974000-7ff6899f1000 r-xp 00000000 fd:02 8453918 /usr/lib64/libgcrypt.so.11.8.2
  203. 7ff6899f1000-7ff689bf0000 ---p 0007d000 fd:02 8453918 /usr/lib64/libgcrypt.so.11.8.2
  204. 7ff689bf0000-7ff689bf1000 r--p 0007c000 fd:02 8453918 /usr/lib64/libgcrypt.so.11.8.2
  205. 7ff689bf1000-7ff689bf4000 rw-p 0007d000 fd:02 8453918 /usr/lib64/libgcrypt.so.11.8.2
  206. 7ff689bf4000-7ff689bf5000 rw-p 00000000 00:00 0
  207. 7ff689bf5000-7ff689c09000 r-xp 00000000 fd:02 8454910 /usr/lib64/liblz4.so.1.7.5
  208. 7ff689c09000-7ff689e08000 ---p 00014000 fd:02 8454910 /usr/lib64/liblz4.so.1.7.5
  209. 7ff689e08000-7ff689e09000 r--p 00013000 fd:02 8454910 /usr/lib64/liblz4.so.1.7.5
  210. 7ff689e09000-7ff689e0a000 rw-p 00014000 fd:02 8454910 /usr/lib64/liblz4.so.1.7.5
  211. 7ff689e0a000-7ff689e2e000 r-xp 00000000 fd:02 8393725 /usr/lib64/libselinux.so.1
  212. 7ff689e2e000-7ff68a02d000 ---p 00024000 fd:02 8393725 /usr/lib64/libselinux.so.1
  213. 7ff68a02d000-7ff68a02e000 r--p 00023000 fd:02 8393725 /usr/lib64/libselinux.so.1
  214. 7ff68a02e000-7ff68a02f000 rw-p 00024000 fd:02 8393725 /usr/lib64/libselinux.so.1
  215. 7ff68a02f000-7ff68a031000 rw-p 00000000 00:00 0
  216. 7ff68a031000-7ff68a038000 r-xp 00000000 fd:02 8492595 /usr/lib64/librt-2.17.so
  217. 7ff68a038000-7ff68a237000 ---p 00007000 fd:02 8492595 /usr/lib64/librt-2.17.so
  218. 7ff68a237000-7ff68a238000 r--p 00006000 fd:02 8492595 /usr/lib64/librt-2.17.so
  219. 7ff68a238000-7ff68a239000 rw-p 00007000 fd:02 8492595 /usr/lib64/librt-2.17.so
  220. 7ff68a239000-7ff68a23d000 r-xp 00000000 fd:02 8453928 /usr/lib64/libcap.so.2.22
  221. 7ff68a23d000-7ff68a43c000 ---p 00004000 fd:02 8453928 /usr/lib64/libcap.so.2.22
  222. 7ff68a43c000-7ff68a43d000 r--p 00003000 fd:02 8453928 /usr/lib64/libcap.so.2.22
  223. 7ff68a43d000-7ff68a43e000 rw-p 00004000 fd:02 8453928 /usr/lib64/libcap.so.2.22
  224. 7ff68a43e000-7ff68a440000 r-xp 00000000 fd:02 8389736 /usr/lib64/libfreebl3.so
  225. 7ff68a440000-7ff68a63f000 ---p 00002000 fd:02 8389736 /usr/lib64/libfreebl3.so
  226. 7ff68a63f000-7ff68a640000 r--p 00001000 fd:02 8389736 /usr/lib64/libfreebl3.so
  227. 7ff68a640000-7ff68a641000 rw-p 00002000 fd:02 8389736 /usr/lib64/libfreebl3.so
  228. 7ff68a641000-7ff68a803000 r-xp 00000000 fd:02 8455220 /usr/lib64/libc-2.17.so
  229. 7ff68a803000-7ff68aa03000 ---p 001c2000 fd:02 8455220 /usr/lib64/libc-2.17.so
  230. 7ff68aa03000-7ff68aa07000 r--p 001c2000 fd:02 8455220 /usr/lib64/libc-2.17.so
  231. 7ff68aa07000-7ff68aa09000 rw-p 001c6000 fd:02 8455220 /usr/lib64/libc-2.17.so
  232. 7ff68aa09000-7ff68aa0e000 rw-p 00000000 00:00 0
  233. 7ff68aa0e000-7ff68ab0f000 r-xp 00000000 fd:02 8465982 /usr/lib64/libm-2.17.so
  234. 7ff68ab0f000-7ff68ad0e000 ---p 00101000 fd:02 8465982 /usr/lib64/libm-2.17.so
  235. 7ff68ad0e000-7ff68ad0f000 r--p 00100000 fd:02 8465982 /usr/lib64/libm-2.17.so
  236. 7ff68ad0f000-7ff68ad10000 rw-p 00101000 fd:02 8465982 /usr/lib64/libm-2.17.so
  237. 7ff68ad10000-7ff68adf9000 r-xp 00000000 fd:02 8433576 /usr/lib64/libstdc++.so.6.0.19
  238. 7ff68adf9000-7ff68aff8000 ---p 000e9000 fd:02 8433576 /usr/lib64/libstdc++.so.6.0.19
  239. 7ff68aff8000-7ff68b000000 r--p 000e8000 fd:02 8433576 /usr/lib64/libstdc++.so.6.0.19
  240. 7ff68b000000-7ff68b002000 rw-p 000f0000 fd:02 8433576 /usr/lib64/libstdc++.so.6.0.19
  241. 7ff68b002000-7ff68b017000 rw-p 00000000 00:00 0
  242. 7ff68b017000-7ff68b019000 r-xp 00000000 fd:02 8465949 /usr/lib64/libdl-2.17.so
  243. 7ff68b019000-7ff68b219000 ---p 00002000 fd:02 8465949 /usr/lib64/libdl-2.17.so
  244. 7ff68b219000-7ff68b21a000 r--p 00002000 fd:02 8465949 /usr/lib64/libdl-2.17.so
  245. 7ff68b21a000-7ff68b21b000 rw-p 00003000 fd:02 8465949 /usr/lib64/libdl-2.17.so
  246. 7ff68b21b000-7ff68b44f000 r-xp 00000000 fd:02 8455160 /usr/lib64/libcrypto.so.1.0.2k
  247. 7ff68b44f000-7ff68b64f000 ---p 00234000 fd:02 8455160 /usr/lib64/libcrypto.so.1.0.2k
  248. 7ff68b64f000-7ff68b66b000 r--p 00234000 fd:02 8455160 /usr/lib64/libcrypto.so.1.0.2k
  249. 7ff68b66b000-7ff68b678000 rw-p 00250000 fd:02 8455160 /usr/lib64/libcrypto.so.1.0.2k
  250. 7ff68b678000-7ff68b67c000 rw-p 00000000 00:00 0
  251. 7ff68b67c000-7ff68b6e3000 r-xp 00000000 fd:02 8455168 /usr/lib64/libssl.so.1.0.2k
  252. 7ff68b6e3000-7ff68b8e3000 ---p 00067000 fd:02 8455168 /usr/lib64/libssl.so.1.0.2k
  253. 7ff68b8e3000-7ff68b8e7000 r--p 00067000 fd:02 8455168 /usr/lib64/libssl.so.1.0.2k
  254. 7ff68b8e7000-7ff68b8ee000 rw-p 0006b000 fd:02 8455168 /usr/lib64/libssl.so.1.0.2k
  255. 7ff68b8ee000-7ff68b91d000 r-xp 00000000 fd:02 8389774 /usr/lib64/libsystemd.so.0.6.0
  256. 7ff68b91d000-7ff68bb1d000 ---p 0002f000 fd:02 8389774 /usr/lib64/libsystemd.so.0.6.0
  257. 7ff68bb1d000-7ff68bb1e000 r--p 0002f000 fd:02 8389774 /usr/lib64/libsystemd.so.0.6.0
  258. 7ff68bb1e000-7ff68bb1f000 rw-p 00030000 fd:02 8389774 /usr/lib64/libsystemd.so.0.6.0
  259. 7ff68bb1f000-7ff68bb27000 r-xp 00000000 fd:02 8465417 /usr/lib64/libcrypt-2.17.so
  260. 7ff68bb27000-7ff68bd26000 ---p 00008000 fd:02 8465417 /usr/lib64/libcrypt-2.17.so
  261. 7ff68bd26000-7ff68bd27000 r--p 00007000 fd:02 8465417 /usr/lib64/libcrypt-2.17.so
  262. 7ff68bd27000-7ff68bd28000 rw-p 00008000 fd:02 8465417 /usr/lib64/libcrypt-2.17.so
  263. 7ff68bd28000-7ff68bd56000 rw-p 00000000 00:00 0
  264. 7ff68bd56000-7ff68bd6b000 r-xp 00000000 fd:02 8433568 /usr/lib64/libz.so.1.2.7
  265. 7ff68bd6b000-7ff68bf6a000 ---p 00015000 fd:02 8433568 /usr/lib64/libz.so.1.2.7
  266. 7ff68bf6a000-7ff68bf6b000 r--p 00014000 fd:02 8433568 /usr/lib64/libz.so.1.2.7
  267. 7ff68bf6b000-7ff68bf6c000 rw-p 00015000 fd:02 8433568 /usr/lib64/libz.so.1.2.7
  268. 7ff68bf6c000-7ff68bf6d000 r-xp 00000000 fd:02 8653327 /usr/lib64/libaio.so.1.0.1
  269. 7ff68bf6d000-7ff68c16c000 ---p 00001000 fd:02 8653327 /usr/lib64/libaio.so.1.0.1
  270. 7ff68c16c000-7ff68c16d000 r--p 00000000 fd:02 8653327 /usr/lib64/libaio.so.1.0.1
  271. 7ff68c16d000-7ff68c16e000 rw-p 00001000 fd:02 8653327 /usr/lib64/libaio.so.1.0.1
  272. 7ff68c16e000-7ff68c193000 r-xp 00000000 fd:02 8453504 /usr/lib64/liblzma.so.5.2.2
  273. 7ff68c193000-7ff68c392000 ---p 00025000 fd:02 8453504 /usr/lib64/liblzma.so.5.2.2
  274. 7ff68c392000-7ff68c393000 r--p 00024000 fd:02 8453504 /usr/lib64/liblzma.so.5.2.2
  275. 7ff68c393000-7ff68c394000 rw-p 00025000 fd:02 8453504 /usr/lib64/liblzma.so.5.2.2
  276. 7ff68c394000-7ff68c3ab000 r-xp 00000000 fd:02 8492585 /usr/lib64/libpthread-2.17.so
  277. 7ff68c3ab000-7ff68c5aa000 ---p 00017000 fd:02 8492585 /usr/lib64/libpthread-2.17.so
  278. 7ff68c5aa000-7ff68c5ab000 r--p 00016000 fd:02 8492585 /usr/lib64/libpthread-2.17.so
  279. 7ff68c5ab000-7ff68c5ac000 rw-p 00017000 fd:02 8492585 /usr/lib64/libpthread-2.17.so
  280. 7ff68c5ac000-7ff68c5b0000 rw-p 00000000 00:00 0
  281. 7ff68c5b0000-7ff68c5d2000 r-xp 00000000 fd:02 8455174 /usr/lib64/ld-2.17.so
  282. 7ff68c5d7000-7ff68c7c6000 rw-p 00000000 00:00 0
  283. 7ff68c7cd000-7ff68c7d1000 rw-p 00000000 00:00 0
  284. 7ff68c7d1000-7ff68c7d2000 r--p 00021000 fd:02 8455174 /usr/lib64/ld-2.17.so
  285. 7ff68c7d2000-7ff68c7d3000 rw-p 00022000 fd:02 8455174 /usr/lib64/ld-2.17.so
  286. 7ff68c7d3000-7ff68c7d4000 rw-p 00000000 00:00 0
  287. 7ffe134b2000-7ffe134d3000 rw-p 00000000 00:00 0 [stack]
  288. 7ffe13567000-7ffe13569000 r-xp 00000000 00:00 0 [vdso]
  289. ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall]
  290. 190215 15:49:15 [ERROR] mysqld got signal 6 ;
  291. This could be because you hit a bug. It is also possible that this binary
  292. or one of the libraries it was linked against is corrupt, improperly built,
  293. or misconfigured. This error can also be caused by malfunctioning hardware.
  294.  
  295. To report this bug, see https://mariadb.com/kb/en/reporting-bugs
  296.  
  297. We will try our best to scrape up some info that will hopefully help
  298. diagnose the problem, but since we have already crashed,
  299. something is definitely wrong and this may fail.
  300.  
  301. Server version: 10.2.21-MariaDB-log
  302. key_buffer_size=0
  303. read_buffer_size=8388608
  304. max_used_connections=0
  305. max_threads=65537
  306. thread_count=2
  307. It is possible that mysqld could use up to
  308. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1073809379 K bytes of memory
  309. Hope that's ok; if not, decrease some variables in the equation.
  310.  
  311. Thread pointer: 0x7ff5b80009a8
  312. Attempting backtrace. You can use the following information to find out
  313. where mysqld died. If you see no messages after this, something went
  314. terribly wrong...
  315. stack_bottom = 0x7ff65438a910 thread_stack 0x40000
  316. /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5591ec641dbe]
  317. mysys/stacktrace.c:268(my_print_stacktrace)[0x5591ec0c8ec5]
  318. sigaction.c:0(__restore_rt)[0x7ff68c3a35d0]
  319. WSREP_SST: [INFO] WARNING: Stale temporary SST directory: /var/lib/mysql//.sst from previous state transfer. Removing (20190215 15:49:15.590)
  320. WSREP_SST: [INFO] Proceeding with SST (20190215 15:49:15.597)
  321. WSREP_SST: [INFO] Evaluating socat -u TCP-LISTEN:4444,reuseaddr stdio | mbstream -x; RC=( ${PIPESTATUS[@]} ) (20190215 15:49:15.598)
  322. WSREP_SST: [INFO] Cleaning the existing datadir and innodb-data/log directories (20190215 15:49:15.599)
  323. removed ‘/var/lib/mysql/aria_log_control’
  324. removed ‘/var/lib/mysql/aria_log.00000001’
  325. removed ‘/var/lib/mysql/ibdata1’
  326. removed ‘/var/lib/mysql/ib_logfile1’
  327. removed ‘/var/lib/mysql/mysql.sock’
  328. WSREP_SST: [INFO] Cleaning the binlog directory /var/log/mysql as well (20190215 15:49:15.612)
  329. WSREP_SST: [INFO] Waiting for SST streaming to complete! (20190215 15:49:15.616)
  330. :0(__GI_raise)[0x7ff68a677207]
  331. :0(__GI_abort)[0x7ff68a6788f8]
  332. :0(__libc_message)[0x7ff68a6b9d27]
  333. malloc.c:0(_int_free)[0x7ff68a6c2489]
  334. src/gcache_mem_store.cpp:72(gcache::MemStore::seqno_reset())[0x7ff654de29af]
  335. bits/stl_tree.h:860(std::_Rb_tree<long, std::pair<long const, void const*>, std::_Select1st<std::pair<long const, void const*> >, std::less<long>, std::allocator<std::pair<long const, void const*> > >::clear())[0x7ff654dcde68]
  336. src/replicator_str.cpp:692(galera::ReplicatorSMM::request_state_transfer(void*, wsrep_uuid const&, long, void const*, long))[0x7ff654f0e4a0]
  337. src/replicator_smm.cpp:1483(galera::ReplicatorSMM::process_conf_change(void*, wsrep_view_info const&, int, galera::Replicator::State, long))[0x7ff654f03de6]
  338. src/gcs_action_source.cpp:140(galera::GcsActionSource::dispatch(void*, gcs_action const&, bool&))[0x7ff654ede3ac]
  339. src/gcs_action_source.cpp:28(~Release)[0x7ff654edf74c]
  340. src/replicator_smm.cpp:362(galera::ReplicatorSMM::async_recv(void*))[0x7ff654f0318b]
  341. src/wsrep_provider.cpp:271(galera_recv)[0x7ff654f11178]
  342. /usr/sbin/mysqld(+0x615e24)[0x5591ec06fe24]
  343. sql/wsrep_thd.cc:366(wsrep_replication_process(THD*))[0x5591ec05f6d2]
  344. pthread_create.c:0(start_thread)[0x7ff68c39bdd5]
  345. /lib64/libc.so.6(clone+0x6d)[0x7ff68a73eead]
  346.  
  347. Trying to get some variables.
  348. Some pointers may be invalid and cause the dump to abort.
  349. Query (0x0):
  350. Connection ID (thread ID): 2
  351. Status: NOT_KILLED
  352.  
  353. Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on
  354.  
  355. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  356. information that should help you find out what is causing the crash.
  357. Terminated
  358. WSREP_SST: [ERROR] Removing /var/lib/mysql//.sst/xtrabackup_galera_info file due to signal (20190215 15:49:15.998)
  359. WSREP_SST: [ERROR] Parent mysqld process (PID:29827) terminated unexpectedly. (20190215 15:49:16.001)
  360. WSREP_SST: [ERROR] Removing /var/lib/mysql//.sst/xtrabackup_galera_info file due to signal (20190215 15:49:16.002)
  361. WSREP_SST: [ERROR] Cleanup after exit with status:32 (20190215 15:49:16.004)
  362. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: Read nil XID from storage engines, skipping position init
  363. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so'
  364. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: wsrep_load(): Galera 25.3.25(r3836) by Codership Oy <info@codership.com> loaded successfully.
  365. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: CRC-32C: using hardware acceleration.
  366. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 0
  367. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.102.9.32; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 2G; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 2G; gcache.recover = no; gcache.size = 2G; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 0.8; gcs.fc_limit = 80; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.
  368. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: GCache history reset: 6e73cc2c-4a23-11e8-8a1c-dad50e2e7640:0 -> 00000000-0000-0000-0000-000000000000:-1
  369. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
  370. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: wsrep_sst_grab()
  371. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: Start replication
  372. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
  373. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: protonet asio version 0
  374. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: Using CRC-32C for message checksums.
  375. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: backend: asio
  376. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: gcomm thread scheduling priority set to other:0
  377. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: restore pc from disk successfully
  378. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: GMCast version 0
  379. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: (276e0ca9, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
  380. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: (276e0ca9, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
  381. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: EVS version 0
  382. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: gcomm: connecting to group 'Foreman_NP', peer '10.101.9.27:,10.102.9.32:,10.101.9.79:'
  383. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: (276e0ca9, 'tcp://0.0.0.0:4567') connection established to 276e0ca9 tcp://10.102.9.32:4567
  384. 2019-02-15 15:49:25 139925979179200 [Warning] WSREP: (276e0ca9, 'tcp://0.0.0.0:4567') address 'tcp://10.102.9.32:4567' points to own listening address, blacklisting
  385. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: (276e0ca9, 'tcp://0.0.0.0:4567') connection established to 76849070 tcp://10.101.9.27:4567
  386. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: (276e0ca9, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
  387. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: (276e0ca9, 'tcp://0.0.0.0:4567') connection established to 521c7c8c tcp://10.101.9.79:4567
  388. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: declaring 521c7c8c at tcp://10.101.9.79:4567 stable
  389. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: declaring 76849070 at tcp://10.101.9.27:4567 stable
  390. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: Node 521c7c8c state prim
  391. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: view(view_id(PRIM,276e0ca9,30) memb {
  392. 276e0ca9,0
  393. 521c7c8c,0
  394. 76849070,0
  395. } joined {
  396. } left {
  397. } partitioned {
  398. })
  399. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: save pc into disk
  400. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: clear restored view
  401. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: gcomm: connected
  402. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
  403. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
  404. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: Opened channel 'Foreman_NP'
  405. 2019-02-15 15:49:25 139922786739968 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3
  406. 2019-02-15 15:49:25 139925979179200 [Note] WSREP: Waiting for SST to complete.
  407. 2019-02-15 15:49:25 139922786739968 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 2e1cb0b6-3163-11e9-bfec-0370c6345d60
  408. 2019-02-15 15:49:25 139922786739968 [Note] WSREP: STATE EXCHANGE: sent state msg: 2e1cb0b6-3163-11e9-bfec-0370c6345d60
  409. 2019-02-15 15:49:25 139922786739968 [Note] WSREP: STATE EXCHANGE: got state msg: 2e1cb0b6-3163-11e9-bfec-0370c6345d60 from 0 (fmndbnph1)
  410. 2019-02-15 15:49:25 139922786739968 [Note] WSREP: STATE EXCHANGE: got state msg: 2e1cb0b6-3163-11e9-bfec-0370c6345d60 from 1 (fmndbnpw2)
  411. 2019-02-15 15:49:25 139922786739968 [Note] WSREP: STATE EXCHANGE: got state msg: 2e1cb0b6-3163-11e9-bfec-0370c6345d60 from 2 (fmndbnpw1)
  412. 2019-02-15 15:49:25 139922786739968 [Note] WSREP: Quorum results:
  413. version = 4,
  414. component = PRIMARY,
  415. conf_id = 26,
  416. members = 2/3 (joined/total),
  417. act_id = 16869352,
  418. last_appl. = -1,
  419. protocols = 0/9/3 (gcs/repl/appl),
  420. group UUID = 6e73cc2c-4a23-11e8-8a1c-dad50e2e7640
  421. 2019-02-15 15:49:25 139922786739968 [Note] WSREP: Flow-control interval: [111, 139]
  422. 2019-02-15 15:49:25 139922786739968 [Note] WSREP: Trying to continue unpaused monitor
  423. 2019-02-15 15:49:25 139922786739968 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 16869352)
  424. 2019-02-15 15:49:25 139925001713408 [Note] WSREP: State transfer required:
  425. Group state: 6e73cc2c-4a23-11e8-8a1c-dad50e2e7640:16869352
  426. Local state: 00000000-0000-0000-0000-000000000000:-1
  427. 2019-02-15 15:49:25 139925001713408 [Note] WSREP: New cluster view: global state: 6e73cc2c-4a23-11e8-8a1c-dad50e2e7640:16869352, view# 27: Primary, number of nodes: 3, my index: 0, protocol version 3
  428. 2019-02-15 15:49:25 139925001713408 [Warning] WSREP: Gap in state sequence. Need state transfer.
  429. 2019-02-15 15:49:25 139922778113792 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '10.102.9.32' --datadir '/var/lib/mysql/' --parent '30485' --binlog '/var/log/mysql/mysql-bin' '''
  430. 2019-02-15 15:49:25 139922786739968 [Warning] WSREP: Could not find peer:
  431. 2019-02-15 15:49:25 139922786739968 [Warning] WSREP: 1.0 (fmndbnpw2): State transfer to -1.-1 (left the group) failed: -22 (Invalid argument)
  432. 2019-02-15 15:49:25 139922786739968 [Note] WSREP: Member 1.0 (fmndbnpw2) synced with group.
  433. WSREP_SST: [INFO] Streaming with xbstream (20190215 15:49:25.810)
  434. WSREP_SST: [INFO] Using socat as streamer (20190215 15:49:25.812)
  435. WSREP_SST: [INFO] Stale sst_in_progress file: /var/lib/mysql//sst_in_progress (20190215 15:49:25.815)
  436. WSREP_SST: [INFO] Evaluating timeout -k 110 100 socat -u TCP-LISTEN:4444,reuseaddr stdio | mbstream -x; RC=( ${PIPESTATUS[@]} ) (20190215 15:49:25.842)
  437. 2019-02-15 15:49:26 139925001713408 [Note] WSREP: Prepared SST request: mariabackup|10.102.9.32:4444/xtrabackup_sst//1
  438. 2019-02-15 15:49:26 139925001713408 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  439. 2019-02-15 15:49:26 139925001713408 [Note] WSREP: REPL Protocols: 9 (4, 2)
  440. 2019-02-15 15:49:26 139925001713408 [Note] WSREP: Assign initial position for certification: 16869352, protocol version: 4
  441. 2019-02-15 15:49:26 139925043947264 [Note] WSREP: Service thread queue flushed.
  442. 2019-02-15 15:49:26 139925001713408 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (6e73cc2c-4a23-11e8-8a1c-dad50e2e7640): 1 (Operation not permitted)
  443. at galera/src/replicator_str.cpp:prepare_for_IST():482. IST will be unavailable.
  444. 2019-02-15 15:49:26 139922786739968 [Note] WSREP: Member 0.0 (fmndbnph1) requested state transfer from '*any*'. Selected 1.0 (fmndbnpw2)(SYNCED) as donor.
  445. 2019-02-15 15:49:26 139922786739968 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 16869352)
  446. 2019-02-15 15:49:26 139925001713408 [Note] WSREP: Requesting state transfer: success, donor: 1
  447. 2019-02-15 15:49:26 139925001713408 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 6e73cc2c-4a23-11e8-8a1c-dad50e2e7640:16869352
  448. WSREP_SST: [INFO] WARNING: Stale temporary SST directory: /var/lib/mysql//.sst from previous state transfer. Removing (20190215 15:49:26.305)
  449. WSREP_SST: [INFO] Proceeding with SST (20190215 15:49:26.309)
  450. WSREP_SST: [INFO] Evaluating socat -u TCP-LISTEN:4444,reuseaddr stdio | mbstream -x; RC=( ${PIPESTATUS[@]} ) (20190215 15:49:26.309)
  451. WSREP_SST: [INFO] Cleaning the existing datadir and innodb-data/log directories (20190215 15:49:26.310)
  452. removed ‘/var/lib/mysql/ib_logfile1’
  453. removed ‘/var/lib/mysql/aria_log_control’
  454. removed ‘/var/lib/mysql/aria_log.00000001’
  455. removed ‘/var/lib/mysql/ibdata1’
  456. removed ‘/var/lib/mysql/mysql.sock’
  457. WSREP_SST: [INFO] Cleaning the binlog directory /var/log/mysql as well (20190215 15:49:26.322)
  458. WSREP_SST: [INFO] Waiting for SST streaming to complete! (20190215 15:49:26.326)
  459. 2019-02-15 15:49:28 139925010376448 [Note] WSREP: (276e0ca9, 'tcp://0.0.0.0:4567') connection to peer 276e0ca9 with addr tcp://10.102.9.32:4567 timed out, no messages seen in PT3S
  460. 2019-02-15 15:49:28 139925010376448 [Note] WSREP: (276e0ca9, 'tcp://0.0.0.0:4567') turning message relay requesting off
  461. 2019-02-15 15:49:43 139922786739968 [Note] WSREP: 1.0 (fmndbnpw2): State transfer to 0.0 (fmndbnph1) complete.
  462. 2019-02-15 15:49:43 139922786739968 [Note] WSREP: Member 1.0 (fmndbnpw2) synced with group.
  463. WSREP_SST: [INFO] Preparing the backup at /var/lib/mysql//.sst (20190215 15:49:43.626)
  464. WSREP_SST: [INFO] Evaluating mariabackup --innobackupex --apply-log $rebuildcmd ${DATA} &>${DATA}/innobackup.prepare.log (20190215 15:49:43.627)
  465. WSREP_SST: [INFO] Moving the backup to /var/lib/mysql/ (20190215 15:49:44.851)
  466. WSREP_SST: [INFO] Evaluating mariabackup --innobackupex --move-back --force-non-empty-directories ${DATA} &>${DATA}/innobackup.move.log (20190215 15:49:44.853)
  467. WSREP_SST: [INFO] Move successful, removing /var/lib/mysql//.sst (20190215 15:49:44.876)
  468. WSREP_SST: [INFO] Galera co-ords from recovery: 6e73cc2c-4a23-11e8-8a1c-dad50e2e7640:16869358 (20190215 15:49:44.880)
  469. WSREP_SST: [INFO] Total time on joiner: 0 seconds (20190215 15:49:44.882)
  470. WSREP_SST: [INFO] Removing the sst_in_progress file (20190215 15:49:44.884)
  471. 2019-02-15 15:49:44 139925979179200 [Note] WSREP: SST complete, seqno: 16869358
  472. 2019-02-15 15:49:44 139925979179200 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  473. 2019-02-15 15:49:44 139925979179200 [Note] InnoDB: Uses event mutexes
  474. 2019-02-15 15:49:44 139925979179200 [Note] InnoDB: Compressed tables use zlib 1.2.7
  475. 2019-02-15 15:49:44 139925979179200 [Note] InnoDB: Using Linux native AIO
  476. 2019-02-15 15:49:44 139925979179200 [Note] InnoDB: Number of pools: 1
  477. 2019-02-15 15:49:44 139925979179200 [Note] InnoDB: Using SSE2 crc32 instructions
  478. 2019-02-15 15:49:44 139925979179200 [Note] InnoDB: Initializing buffer pool, total size = 4.5G, instances = 12, chunk size = 128M
  479. 2019-02-15 15:49:45 139925979179200 [Note] InnoDB: Completed initialization of buffer pool
  480. 2019-02-15 15:49:45 139916884170496 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  481. 2019-02-15 15:49:45 139925979179200 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes
  482. 2019-02-15 15:49:45 139925979179200 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes
  483. 2019-02-15 15:49:45 139925979179200 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
  484. 2019-02-15 15:49:45 139925979179200 [Note] InnoDB: New log files created, LSN=28635769369
  485. 2019-02-15 15:49:45 139925979179200 [Note] InnoDB: Highest supported file format is Barracuda.
  486. 2019-02-15 15:49:45 139925979179200 [Note] InnoDB: 128 out of 128 rollback segments are active.
  487. 2019-02-15 15:49:45 139925979179200 [Note] InnoDB: Creating shared tablespace for temporary tables
  488. 2019-02-15 15:49:45 139925979179200 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  489. 2019-02-15 15:49:45 139925979179200 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  490. 2019-02-15 15:49:45 139925979179200 [Note] InnoDB: Waiting for purge to start
  491. 2019-02-15 15:49:45 139925979179200 [Note] InnoDB: 5.7.24 started; log sequence number 28635769868
  492. 2019-02-15 15:49:45 139916823078656 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  493. 2019-02-15 15:49:45 139925979179200 [Note] Plugin 'FEEDBACK' is disabled.
  494. 2019-02-15 15:49:45 139922724853504 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
  495. 2019-02-15 15:49:45 139922724853504 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
  496. 2019-02-15 15:49:45 139925979179200 [Note] Server socket created on IP: '0.0.0.0'.
  497. 2019-02-15 15:49:45 139925979179200 [Note] WSREP: Signalling provider to continue.
  498. 2019-02-15 15:49:45 139925979179200 [Note] WSREP: SST received: 6e73cc2c-4a23-11e8-8a1c-dad50e2e7640:16869358
  499. 2019-02-15 15:49:45 139922786739968 [Note] WSREP: 0.0 (fmndbnph1): State transfer from 1.0 (fmndbnpw2) complete.
  500. 2019-02-15 15:49:45 139922786739968 [Note] WSREP: Shifting JOINER -> JOINED (TO: 16869365)
  501. 2019-02-15 15:49:45 139925979179200 [Note] Reading of all Master_info entries succeded
  502. 2019-02-15 15:49:45 139925979179200 [Note] Added new Master_info '' to hash table
  503. 2019-02-15 15:49:45 139925979179200 [Note] /usr/sbin/mysqld: ready for connections.
  504. Version: '10.2.21-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
  505. 2019-02-15 15:49:45 139922786739968 [Note] WSREP: Member 0.0 (fmndbnph1) synced with group.
  506. 2019-02-15 15:49:45 139922786739968 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 16869365)
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!