API tools faq
paste
Advertisement
Guest User

mysql cluster log

a guest
May 31st, 2013
100
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.29 KB | None | 0 0
raw download clone embed print report
  1. ==============
  2. 130531 06:52:09 mysqld_safe WSREP: Running position recovery with --log_error=/tmp/tmp.9ATpaiMoCA
  3. 130531 06:52:17 mysqld_safe WSREP: Recovered position f0fe6b94-c6c2-11e2-0800-0c60b3fcd81a:1627070
  4. 130531 6:52:17 [Note] WSREP: wsrep_start_position var submitted: 'f0fe6b94-c6c2-11e2-0800-0c60b3fcd81a:1627070'
  5. 130531 6:52:17 [Note] WSREP: Read nil XID from storage engines, skipping position init
  6. 130531 6:52:17 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/libgalera_smm.so'
  7. 130531 6:52:17 [Note] WSREP: wsrep_load(): Galera 2.3(r143) by Codership Oy <info@codership.com> loaded succesfully.
  8. 130531 6:52:17 [Note] WSREP: Found saved state: f0fe6b94-c6c2-11e2-0800-0c60b3fcd81a:-1
  9. 130531 6:52:17 [Note] WSREP: Reusing existing '/var/lib/galeracache//galera.cache'.
  10. 130531 6:52:17 [Note] WSREP: Passing config to GCS: base_host = 192.168.180.23; base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/lib/galeracache/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/galeracache//galera.cache; gcache.page_size = 128M; gcache.size = 32768M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; 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; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
  11. 130531 6:52:17 [Note] WSREP: Assign initial position for certification: 1627070, protocol version: -1
  12. 130531 6:52:17 [Note] WSREP: wsrep_sst_grab()
  13. 130531 6:52:17 [Note] WSREP: Start replication
  14. 130531 6:52:17 [Note] WSREP: Setting initial position to f0fe6b94-c6c2-11e2-0800-0c60b3fcd81a:1627070
  15. 130531 6:52:17 [Note] WSREP: protonet asio version 0
  16. 130531 6:52:17 [Note] WSREP: backend: asio
  17. 130531 6:52:17 [Note] WSREP: GMCast version 0
  18. 130531 6:52:17 [Note] WSREP: (de912f1f-c9ad-11e2-0800-818eb2531880, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
  19. 130531 6:52:17 [Note] WSREP: (de912f1f-c9ad-11e2-0800-818eb2531880, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
  20. 130531 6:52:17 [Note] WSREP: EVS version 0
  21. 130531 6:52:17 [Note] WSREP: PC version 0
  22. 130531 6:52:17 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '192.168.180.23:,192.168.180.22:,192.168.180.21:'
  23. 130531 6:52:17 [Warning] WSREP: (de912f1f-c9ad-11e2-0800-818eb2531880, 'tcp://0.0.0.0:4567') address 'tcp://192.168.180.23:4567' points to own listening address, blacklisting
  24. 130531 6:52:17 [Note] WSREP: (de912f1f-c9ad-11e2-0800-818eb2531880, 'tcp://0.0.0.0:4567') address 'tcp://192.168.180.23:4567' pointing to uuid de912f1f-c9ad-11e2-0800-818eb2531880 is blacklisted, skipping
  25. 130531 6:52:17 [Note] WSREP: (de912f1f-c9ad-11e2-0800-818eb2531880, 'tcp://0.0.0.0:4567') address 'tcp://192.168.180.23:4567' pointing to uuid de912f1f-c9ad-11e2-0800-818eb2531880 is blacklisted, skipping
  26. 130531 6:52:17 [Note] WSREP: (de912f1f-c9ad-11e2-0800-818eb2531880, 'tcp://0.0.0.0:4567') address 'tcp://192.168.180.23:4567' pointing to uuid de912f1f-c9ad-11e2-0800-818eb2531880 is blacklisted, skipping
  27. 130531 6:52:17 [Note] WSREP: (de912f1f-c9ad-11e2-0800-818eb2531880, 'tcp://0.0.0.0:4567') address 'tcp://192.168.180.23:4567' pointing to uuid de912f1f-c9ad-11e2-0800-818eb2531880 is blacklisted, skipping
  28. 130531 6:52:18 [Note] WSREP: declaring 6e5d0803-c844-11e2-0800-a0b6144affef stable
  29. 130531 6:52:18 [Note] WSREP: declaring da76e93f-c99a-11e2-0800-4b62acbea34a stable
  30. 130531 6:52:18 [Note] WSREP: view(view_id(PRIM,6e5d0803-c844-11e2-0800-a0b6144affef,79) memb {
  31. 6e5d0803-c844-11e2-0800-a0b6144affef,
  32. da76e93f-c99a-11e2-0800-4b62acbea34a,
  33. de912f1f-c9ad-11e2-0800-818eb2531880,
  34. } joined {
  35. } left {
  36. } partitioned {
  37. })
  38. 130531 6:52:18 [Note] WSREP: gcomm: connected
  39. 130531 6:52:18 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
  40. 130531 6:52:18 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
  41. 130531 6:52:18 [Note] WSREP: Opened channel 'my_wsrep_cluster'
  42. 130531 6:52:18 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3
  43. 130531 6:52:18 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
  44. 130531 6:52:18 [Note] WSREP: Waiting for SST to complete.
  45. 130531 6:52:18 [Note] WSREP: STATE EXCHANGE: sent state msg: e29b9cdb-c9ad-11e2-0800-441948218afd
  46. 130531 6:52:18 [Note] WSREP: STATE EXCHANGE: got state msg: e29b9cdb-c9ad-11e2-0800-441948218afd from 0 (db-node1.lactalis.pyco.be)
  47. 130531 6:52:18 [Note] WSREP: STATE EXCHANGE: got state msg: e29b9cdb-c9ad-11e2-0800-441948218afd from 1 (db-node2.lactalis.pyco.be)
  48. 130531 6:52:18 [Note] WSREP: STATE EXCHANGE: got state msg: e29b9cdb-c9ad-11e2-0800-441948218afd from 2 (db-node3.lactalis.pyco.be)
  49. 130531 6:52:18 [Note] WSREP: Quorum results:
  50. version = 2,
  51. component = PRIMARY,
  52. conf_id = 52,
  53. members = 2/3 (joined/total),
  54. act_id = 1652523,
  55. last_appl. = -1,
  56. protocols = 0/4/2 (gcs/repl/appl),
  57. group UUID = f0fe6b94-c6c2-11e2-0800-0c60b3fcd81a
  58. 130531 6:52:18 [Note] WSREP: Flow-control interval: [28, 28]
  59. 130531 6:52:18 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 1652523)
  60. 130531 6:52:18 [Note] WSREP: State transfer required:
  61. Group state: f0fe6b94-c6c2-11e2-0800-0c60b3fcd81a:1652523
  62. Local state: f0fe6b94-c6c2-11e2-0800-0c60b3fcd81a:1627070
  63. 130531 6:52:18 [Note] WSREP: New cluster view: global state: f0fe6b94-c6c2-11e2-0800-0c60b3fcd81a:1652523, view# 53: Primary, number of nodes: 3, my index: 2, protocol version 2
  64. 130531 6:52:18 [Warning] WSREP: Gap in state sequence. Need state transfer.
  65. 130531 6:52:20 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '192.168.180.23' --auth 'root:YuYx03s12832jfn' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '29353''
  66. 130531 6:52:20 [Note] WSREP: Prepared SST request: rsync|192.168.180.23:4444/rsync_sst
  67. 130531 6:52:20 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  68. 130531 6:52:20 [Note] WSREP: Assign initial position for certification: 1652523, protocol version: 2
  69. 130531 6:52:20 [Note] WSREP: Prepared IST receiver, listening at: tcp://192.168.180.23:4568
  70. 130531 6:52:20 [Note] WSREP: Node 2 (db-node3.lactalis.pyco.be) requested state transfer from '*any*'. Selected 0 (db-node1.lactalis.pyco.be)(SYNCED) as donor.
  71. 130531 6:52:20 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 1652530)
  72. 130531 6:52:20 [Note] WSREP: Requesting state transfer: success, donor: 0
  73. WSREP_SST: [INFO] Joiner cleanup. (20130531 06:52:21.673)
  74. done.
  75. 130531 6:52:22 [Note] WSREP: SST complete, seqno: 1627070
  76. 130531 6:52:22 [Note] Plugin 'FEDERATED' is disabled.
  77. 130531 6:52:22 InnoDB: The InnoDB memory heap is disabled
  78. 130531 6:52:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  79. 130531 6:52:22 InnoDB: Compressed tables use zlib 1.2.3
  80. 130531 6:52:22 InnoDB: Using Linux native AIO
  81. 130531 6:52:22 InnoDB: Initializing buffer pool, size = 5.8G
  82. 130531 6:52:22 InnoDB: Completed initialization of buffer pool
  83. 130531 6:52:22 InnoDB: highest supported file format is Barracuda.
  84. 130531 6:52:24 InnoDB: Waiting for the background threads to start
  85. 130531 6:52:25 Percona XtraDB (http://www.percona.com) 1.1.8-rel29.1 started; log sequence number 38650929616
  86. 130531 6:52:25 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  87. 130531 6:52:25 [Note] - '0.0.0.0' resolves to '0.0.0.0';
  88. 130531 6:52:25 [Note] Server socket created on IP: '0.0.0.0'.
  89. 130531 6:52:25 [Warning] 'proxies_priv' entry '@ root@db-node1.lactalis.pyco.be' ignored in --skip-name-resolve mode.
  90. 130531 6:52:25 [Note] Event Scheduler: Loaded 0 events
  91. 130531 6:52:25 [Note] WSREP: Signalling provider to continue.
  92. 130531 6:52:25 [Note] WSREP: SST received: f0fe6b94-c6c2-11e2-0800-0c60b3fcd81a:1627070
  93. 130531 6:52:25 [Note] /usr/sbin/mysqld: ready for connections.
  94. Version: '5.5.29' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona XtraDB Cluster (GPL), wsrep_23.7.2.r3843
  95. 130531 6:52:25 [Note] WSREP: Receiving IST: 25453 writesets, seqnos 1627070-1652523
  96. 130531 6:52:25 [ERROR] Slave SQL: Could not execute Write_rows event on table lactalis.cache_form; Duplicate entry 'form_state_form-PaA6VmuybNJfBvpWgLZIUioIWof-MdUKx71sI1_VHkI' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 418, Error_code: 1062
  97. 130531 6:52:25 [Warning] WSREP: RBR event 2 Write_rows apply warning: 121, 1627071
  98. 130531 6:52:25 [ERROR] WSREP: receiving IST failed, node restart required: Failed to apply app buffer: \"¨Q, seqno: 1627071, status: WSREP_FATAL
  99. at galera/src/replicator_smm.cpp:apply_wscoll():49
  100. at galera/src/replicator_smm.cpp:apply_trx_ws():116
  101. 130531 6:52:25 [Note] WSREP: Closing send monitor...
  102. 130531 6:52:25 [Note] WSREP: Closed send monitor.
  103. 130531 6:52:25 [Note] WSREP: gcomm: terminating thread
  104. 130531 6:52:25 [Note] WSREP: gcomm: joining thread
  105. 130531 6:52:25 [Note] WSREP: gcomm: closing backend
  106. 130531 6:52:25 [Note] WSREP: view(view_id(NON_PRIM,6e5d0803-c844-11e2-0800-a0b6144affef,79) memb {
  107. de912f1f-c9ad-11e2-0800-818eb2531880,
  108. } joined {
  109. } left {
  110. } partitioned {
  111. 6e5d0803-c844-11e2-0800-a0b6144affef,
  112. da76e93f-c99a-11e2-0800-4b62acbea34a,
  113. })
  114. 130531 6:52:25 [Note] WSREP: view((empty))
  115. 130531 6:52:25 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
  116. 130531 6:52:25 [Note] WSREP: gcomm: closed
  117. 130531 6:52:25 [Note] WSREP: Flow-control interval: [16, 16]
  118. 130531 6:52:25 [Note] WSREP: Received NON-PRIMARY.
  119. 130531 6:52:25 [Note] WSREP: Shifting JOINER -> OPEN (TO: 1652542)
  120. 130531 6:52:25 [Note] WSREP: Received self-leave message.
  121. 130531 6:52:25 [Note] WSREP: Flow-control interval: [0, 0]
  122. 130531 6:52:25 [Note] WSREP: Received SELF-LEAVE. Closing connection.
  123. 130531 6:52:25 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 1652542)
  124. 130531 6:52:25 [Note] WSREP: RECV thread exiting 0: Success
  125. 130531 6:52:25 [Note] WSREP: recv_thread() joined.
  126. 130531 6:52:25 [Note] WSREP: Closing slave action queue.
  127. 130531 6:52:25 [Note] WSREP: /usr/sbin/mysqld: Terminated.
  128. 130531 06:52:25 mysqld_safe Number of processes running now: 0
  129. 130531 06:52:25 mysqld_safe WSREP: not restarting wsrep node automatically
  130. 130531 06:52:25 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
  131.  
  132. ===========
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!