API tools faq
paste
Advertisement
Guest User

Node #2

a guest
Jun 24th, 2015
67
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.48 KB | None | 0 0
raw download clone embed print report
  1. 700101 00:15:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  2. 700101 00:15:46 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.naUjej' --pid-file='/var/lib/mysql/buildroot-recover.pid'
  3. 700101 00:15:49 mysqld_safe WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1
  4. 700101 0:15:49 [Note] WSREP: wsrep_start_position var submitted: '00000000-0000-0000-0000-000000000000:-1'
  5. 700101 0:15:49 [Note] InnoDB: Using mutexes to ref count buffer pool pages
  6. 700101 0:15:49 [Note] InnoDB: The InnoDB memory heap is disabled
  7. 700101 0:15:49 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  8. 700101 0:15:49 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  9. 700101 0:15:49 [Note] InnoDB: Compressed tables use zlib 1.2.8
  10. 700101 0:15:49 [Note] InnoDB: Using Linux native AIO
  11. 700101 0:15:49 [Note] InnoDB: Not using CPU crc32 instructions
  12. 700101 0:15:49 [Note] InnoDB: Initializing buffer pool, size = 64.0M
  13. 700101 0:15:49 [Note] InnoDB: Completed initialization of buffer pool
  14. 700101 0:15:49 [Note] InnoDB: Highest supported file format is Barracuda.
  15. 700101 0:15:50 [Note] InnoDB: 128 rollback segment(s) are active.
  16. 700101 0:15:50 [Note] InnoDB: Waiting for purge to start
  17. 700101 0:15:50 [Note] InnoDB: 5.6.23 started; log sequence number 1616885
  18. 700101 0:15:50 [ERROR] Failed to create a socket for IPv6 '::': errno: 97.
  19. 700101 0:15:50 [Note] Server socket created on IP: '0.0.0.0'.
  20. 700101 0:15:50 [Note] Event Scheduler: Loaded 0 events
  21. 700101 0:15:50 [Note] WSREP: Read nil XID from storage engines, skipping position init
  22. 700101 0:15:50 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/libgalera_smm.so'
  23. 700101 0:15:50 [Note] WSREP: wsrep_load(): Galera 3.10(r8182fa6) by Codership Oy <info@codership.com> loaded successfully.
  24. 700101 0:15:50 [Note] WSREP: CRC-32C: using "slicing-by-8" algorithm.
  25. 700101 0:15:50 [Warning] WSREP: Could not open saved state file for reading: /var/lib/mysql//grastate.dat
  26. 700101 0:15:50 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1
  27. 700101 0:15:50 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 192.168.1.80; base_port = 4567; cert.log_conflicts = no; 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 = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 2147483647; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo
  28. 700101 0:15:50 [Note] WSREP: Service thread queue flushed.
  29. 700101 0:15:50 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
  30. 700101 0:15:50 [Note] WSREP: Start replication
  31. 700101 0:15:50 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
  32. 700101 0:15:50 [Note] WSREP: protonet asio version 0
  33. 700101 0:15:50 [Note] WSREP: Using CRC-32C for message checksums.
  34. 700101 0:15:50 [Note] WSREP: backend: asio
  35. 700101 0:15:50 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
  36. 700101 0:15:50 [Note] WSREP: restore pc from disk failed
  37. 700101 0:15:50 [Note] WSREP: GMCast version 0
  38. 700101 0:15:50 [Note] WSREP: (4a39a45a, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
  39. 700101 0:15:50 [Note] WSREP: (4a39a45a, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
  40. 700101 0:15:50 [Note] WSREP: EVS version 0
  41. 700101 0:15:50 [Note] WSREP: gcomm: connecting to group 'test', peer '192.168.1.77:'
  42. 700101 0:15:50 [Note] WSREP: (4a39a45a, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
  43. 700101 0:15:51 [Note] WSREP: declaring a91ab0d8 at tcp://192.168.1.77:4567 stable
  44. 700101 0:15:51 [Note] WSREP: Node a91ab0d8 state prim
  45. 700101 0:15:51 [Note] WSREP: view(view_id(PRIM,4a39a45a,2) memb {
  46. 4a39a45a,0
  47. a91ab0d8,0
  48. } joined {
  49. } left {
  50. } partitioned {
  51. })
  52. 700101 0:15:51 [Note] WSREP: save pc into disk
  53. 700101 0:15:51 [Note] WSREP: gcomm: connected
  54. 700101 0:15:51 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
  55. 700101 0:15:51 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
  56. 700101 0:15:51 [Note] WSREP: Opened channel 'test'
  57. 700101 0:15:51 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2
  58. 700101 0:15:51 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 4ad7a31c-1dd4-11b2-bd65-a3e5cd5050d7
  59. 700101 0:15:51 [Note] WSREP: STATE EXCHANGE: sent state msg: 4ad7a31c-1dd4-11b2-bd65-a3e5cd5050d7
  60. 700101 0:15:51 [Note] WSREP: STATE EXCHANGE: got state msg: 4ad7a31c-1dd4-11b2-bd65-a3e5cd5050d7 from 1 (buildroot)
  61. 700101 0:15:51 [Note] WSREP: STATE EXCHANGE: got state msg: 4ad7a31c-1dd4-11b2-bd65-a3e5cd5050d7 from 0 (buildroot)
  62. 700101 0:15:51 [Note] WSREP: Quorum results:
  63. version = 3,
  64. component = PRIMARY,
  65. conf_id = 1,
  66. members = 1/2 (joined/total),
  67. act_id = 0,
  68. last_appl. = -1,
  69. protocols = 0/7/3 (gcs/repl/appl),
  70. group UUID = a920abdc-1dd2-11b2-ad88-b7f97a213e56
  71. 700101 0:15:51 [Note] WSREP: Flow-control interval: [23, 23]
  72. 700101 0:15:51 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 0)
  73. 700101 0:15:51 [Note] WSREP: State transfer required:
  74. Group state: a920abdc-1dd2-11b2-ad88-b7f97a213e56:0
  75. Local state: 00000000-0000-0000-0000-000000000000:-1
  76. 700101 0:15:51 [Note] WSREP: New cluster view: global state: a920abdc-1dd2-11b2-ad88-b7f97a213e56:0, view# 2: Primary, number of nodes: 2, my index: 0, protocol version 3
  77. 700101 0:15:51 [Warning] WSREP: Gap in state sequence. Need state transfer.
  78. 700101 0:15:51 [Note] Reading of all Master_info entries succeded
  79. 700101 0:15:51 [Note] Added new Master_info '' to hash table
  80. 700101 0:15:51 [Note] /usr/bin/mysqld: ready for connections.
  81. Version: '10.0.17-MariaDB-wsrep-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution, wsrep_25.10.r4144
  82. 700101 0:15:53 [Note] WSREP: Prepared SST request: mysqldump|192.168.1.80:3306
  83. 700101 0:15:53 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  84. 700101 0:15:53 [Note] WSREP: REPL Protocols: 7 (3, 2)
  85. 700101 0:15:53 [Note] WSREP: Service thread queue flushed.
  86. 700101 0:15:53 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3
  87. 700101 0:15:53 [Note] WSREP: Service thread queue flushed.
  88. 700101 0:15:53 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (a920abdc-1dd2-11b2-ad88-b7f97a213e56): 1 (Operation not permitted)
  89. at galera/src/replicator_str.cpp:prepare_for_IST():456. IST will be unavailable.
  90. 700101 0:15:53 [Note] WSREP: Member 0.0 (buildroot) requested state transfer from '*any*'. Selected 1.0 (buildroot)(SYNCED) as donor.
  91. 700101 0:15:53 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 0)
  92. 700101 0:15:53 [Note] WSREP: Requesting state transfer: success, donor: 1
  93. 700101 0:15:54 [Note] WSREP: (4a39a45a, 'tcp://0.0.0.0:4567') turning message relay requesting off
  94. 700101 0:15:58 [Warning] WSREP: 1.0 (buildroot): State transfer to 0.0 (buildroot) failed: -22 (Invalid argument)
  95. 700101 0:15:58 [ERROR] WSREP: gcs/src/gcs_group.cpp:int gcs_group_handle_join_msg(gcs_group_t*, const gcs_recv_msg_t*)():731: Will never receive state. Need to abort.
  96. 700101 0:15:58 [Note] WSREP: gcomm: terminating thread
  97. 700101 0:15:58 [Note] WSREP: gcomm: joining thread
  98. 700101 0:15:58 [Note] WSREP: gcomm: closing backend
  99. 700101 0:15:59 [Note] WSREP: view(view_id(NON_PRIM,4a39a45a,2) memb {
  100. 4a39a45a,0
  101. } joined {
  102. } left {
  103. } partitioned {
  104. a91ab0d8,0
  105. })
  106. 700101 0:15:59 [Note] WSREP: view((empty))
  107. 700101 0:15:59 [Note] WSREP: gcomm: closed
  108. 700101 0:15:59 [Note] WSREP: /usr/bin/mysqld: Terminated.
  109. Aborted
  110. 700101 00:15:59 mysqld_safe Number of processes running now: 0
  111. 700101 00:15:59 mysqld_safe WSREP: not restarting wsrep node automatically
  112. 700101 00:15:59 mysqld_safe mysqld from pid file /tmp/mysql.pid ended
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!