Advertisement
Guest User

Untitled

a guest
Mar 21st, 2016
21
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.08 KB | None | 0 0
  1. 2016-03-18 15:56:12 2904 [Note] /usr/sbin/mysqld: Normal shutdown
  2.  
  3. 2016-03-18 15:56:12 2904 [Note] WSREP: Stop replication
  4. 2016-03-18 15:56:12 2904 [Note] WSREP: Closing send monitor...
  5. 2016-03-18 15:56:12 2904 [Note] WSREP: Closed send monitor.
  6. 2016-03-18 15:56:12 2904 [Note] WSREP: gcomm: terminating thread
  7. 2016-03-18 15:56:12 2904 [Note] WSREP: gcomm: joining thread
  8. 2016-03-18 15:56:12 2904 [Note] WSREP: gcomm: closing backend
  9. 2016-03-18 15:56:13 2904 [Note] WSREP: (503f2a17, 'tcp://0.0.0.0:4567') address 'tcp://10.1.0.7:4567' pointing to uuid 503f2a17 is blacklisted, skipping
  10. 2016-03-18 15:56:17 2904 [Note] WSREP: evs::proto(503f2a17, LEAVING, view_id(REG,000ecfeb,1148)) suspecting node: 43259ec8
  11. 2016-03-18 15:56:17 2904 [Note] WSREP: evs::proto(503f2a17, LEAVING, view_id(REG,000ecfeb,1148)) suspected node without join message, declaring inactive
  12. 2016-03-18 15:56:19 2904 [Note] WSREP: view(view_id(NON_PRIM,000ecfeb,1148) memb {
  13. 503f2a17,1
  14. } joined {
  15. } left {
  16. } partitioned {
  17. 000ecfeb,1
  18. 43259ec8,2
  19. 53db0fe7,2
  20. e148d044,1
  21. })
  22. 2016-03-18 15:56:19 2904 [Note] WSREP: view((empty))
  23. 2016-03-18 15:56:19 2904 [Note] WSREP: gcomm: closed
  24. 2016-03-18 15:56:19 2904 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
  25. 2016-03-18 15:56:19 2904 [Note] WSREP: Flow-control interval: [16, 16]
  26. 2016-03-18 15:56:19 2904 [Note] WSREP: Received NON-PRIMARY.
  27. 2016-03-18 15:56:19 2904 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 81636269)
  28. 2016-03-18 15:56:19 2904 [Note] WSREP: Received self-leave message.
  29. 2016-03-18 15:56:19 2904 [Note] WSREP: Flow-control interval: [0, 0]
  30. 2016-03-18 15:56:19 2904 [Note] WSREP: Received SELF-LEAVE. Closing connection.
  31. 2016-03-18 15:56:19 2904 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 81636269)
  32. 2016-03-18 15:56:19 2904 [Note] WSREP: New cluster view: global state: ee9fde7c-fe20-11e4-aa76-8beb5059c427:81636269, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3
  33. 2016-03-18 15:56:19 2904 [Note] WSREP: RECV thread exiting 0: Success
  34. 2016-03-18 15:56:19 2904 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  35. 2016-03-18 15:56:19 2904 [Note] WSREP: New cluster view: global state: ee9fde7c-fe20-11e4-aa76-8beb5059c427:81636269, view# -1: non-Primary, number of nodes: 0, my index: -1, protocol version 3
  36. 2016-03-18 15:56:19 2904 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  37. 2016-03-18 15:56:19 2904 [Note] WSREP: applier thread exiting (code:0)
  38. 2016-03-18 15:56:19 2904 [Note] WSREP: recv_thread() joined.
  39. 2016-03-18 15:56:19 2904 [Note] WSREP: Closing replication queue.
  40. 2016-03-18 15:56:19 2904 [Note] WSREP: Closing slave action queue.
  41. 2016-03-18 15:56:19 2904 [Note] WSREP: applier thread exiting (code:6)
  42. 2016-03-18 15:56:19 2904 [Note] WSREP: applier thread exiting (code:6)
  43. 2016-03-18 15:56:19 2904 [Note] WSREP: applier thread exiting (code:6)
  44. 2016-03-18 15:56:19 2904 [Note] WSREP: applier thread exiting (code:6)
  45. 2016-03-18 15:56:19 2904 [Note] WSREP: applier thread exiting (code:6)
  46. 2016-03-18 15:56:19 2904 [Note] WSREP: applier thread exiting (code:6)
  47. 2016-03-18 15:56:19 2904 [Note] WSREP: applier thread exiting (code:6)
  48. 2016-03-18 15:56:21 2904 [Note] WSREP: rollbacker thread exiting
  49. 2016-03-18 15:56:21 2904 [Note] Giving 0 client threads a chance to die gracefully
  50. 2016-03-18 15:56:21 2904 [Note] Event Scheduler: Purging the queue. 0 events
  51. 2016-03-18 15:56:21 2904 [Note] Shutting down slave threads
  52. 2016-03-18 15:56:21 2904 [Note] Forcefully disconnecting 0 remaining clients
  53. 2016-03-18 15:56:21 2904 [Note] WSREP: dtor state: CLOSED
  54. 2016-03-18 15:56:21 2904 [Note] WSREP: mon: entered 2759091 oooe fraction 0 oool fraction 0.000198979
  55. 2016-03-18 15:56:22 2904 [Note] WSREP: mon: entered 2759091 oooe fraction 0.21796 oool fraction 0.000198979
  56. 2016-03-18 15:56:22 2904 [Note] WSREP: mon: entered 2794859 oooe fraction 0 oool fraction 1.46698e-05
  57. 2016-03-18 15:56:22 2904 [Note] WSREP: cert index usage at exit 0
  58. 2016-03-18 15:56:22 2904 [Note] WSREP: cert trx map usage at exit 237
  59. 2016-03-18 15:56:22 2904 [Note] WSREP: deps set usage at exit 0
  60. 2016-03-18 15:56:22 2904 [Note] WSREP: avg deps dist 34.3691
  61. 2016-03-18 15:56:22 2904 [Note] WSREP: avg cert interval 1.83538
  62. 2016-03-18 15:56:22 2904 [Note] WSREP: cert index size 173
  63. 2016-03-18 15:56:22 2904 [Note] WSREP: Service thread queue flushed.
  64. 2016-03-18 15:56:22 2904 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0
  65. 2016-03-18 15:56:22 2904 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0.99966, misses: 394, in use: 0, in pool: 394
  66. 2016-03-18 15:56:22 2904 [Note] WSREP: MemPool(SlaveTrxHandle): hit ratio: 0.999571, misses: 688, in use: 0, in pool: 688
  67. 2016-03-18 15:56:22 2904 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 81636269)
  68. 2016-03-18 15:56:22 2904 [Note] WSREP: Flushing memory map to disk...
  69. 2016-03-18 15:56:22 2904 [Note] Binlog end
  70. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'partition'
  71. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
  72. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  73. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  74. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  75. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  76. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  77. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  78. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  79. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  80. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  81. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  82. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  83. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  84. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  85. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  86. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  87. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_METRICS'
  88. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  89. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  90. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  91. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  92. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  93. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  94. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_CMPMEM'
  95. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  96. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_CMP'
  97. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  98. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_LOCKS'
  99. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'INNODB_TRX'
  100. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'XTRADB_RSEG'
  101. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
  102. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
  103. 2016-03-18 15:56:22 2904 [Note] Shutting down plugin 'InnoDB'
  104. 2016-03-18 15:56:22 2904 [Note] InnoDB: FTS optimize thread exiting.
  105. 2016-03-18 15:56:22 2904 [Note] InnoDB: Starting shutdown...
  106. 2016-03-18 15:56:23 2904 [Note] InnoDB: Shutdown completed; log sequence number 101002810118
  107. 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'BLACKHOLE'
  108. 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'ARCHIVE'
  109. 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  110. 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'MRG_MYISAM'
  111. 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'MyISAM'
  112. 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'MEMORY'
  113. 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'CSV'
  114. 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'sha256_password'
  115. 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'mysql_old_password'
  116. 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'mysql_native_password'
  117. 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'wsrep'
  118. 2016-03-18 15:56:23 2904 [Note] Shutting down plugin 'binlog'
  119. 2016-03-18 15:56:23 2904 [Note] /usr/sbin/mysqld: Shutdown complete
  120.  
  121. 160318 15:56:24 mysqld_safe mysqld from pid file /run/mysqld/mysql.pid ended
  122. 160318 15:56:40 mysqld_safe Starting mysqld daemon with databases from /mnt/ssd/mysql
  123. 160318 15:56:40 mysqld_safe Skipping wsrep-recover for ee9fde7c-fe20-11e4-aa76-8beb5059c427:78871482 pair
  124. 160318 15:56:40 mysqld_safe Assigning ee9fde7c-fe20-11e4-aa76-8beb5059c427:78871482 to wsrep_start_position
  125. 2016-03-18 15:56:40 0 [Note] WSREP: wsrep_start_position var submitted: 'ee9fde7c-fe20-11e4-aa76-8beb5059c427:78871482'
  126. 2016-03-18 15:56:40 17547 [Note] WSREP: Read nil XID from storage engines, skipping position init
  127. 2016-03-18 15:56:40 17547 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/libgalera_smm.so'
  128. 2016-03-18 15:56:40 17547 [Note] WSREP: wsrep_load(): Galera 3.9(r93aca2d) by Codership Oy <info@codership.com> loaded successfully.
  129. 2016-03-18 15:56:40 17547 [Note] WSREP: CRC-32C: using hardware acceleration.
  130. 2016-03-18 15:56:40 17547 [Note] WSREP: Found saved state: ee9fde7c-fe20-11e4-aa76-8beb5059c427:78871482
  131. 2016-03-18 15:56:41 17547 [Note] WSREP: Passing config to GCS: base_dir = /mnt/ssd/mysql/; base_host = 10.1.0.7; 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 = /mnt/ssd/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /mnt/ssd/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 = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 1; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.
  132. 2016-03-18 15:56:41 17547 [Note] WSREP: Service thread queue flushed.
  133. 2016-03-18 15:56:41 17547 [Note] WSREP: Assign initial position for certification: 78871482, protocol version: -1
  134. 2016-03-18 15:56:41 17547 [Note] WSREP: wsrep_sst_grab()
  135. 2016-03-18 15:56:41 17547 [Note] WSREP: Start replication
  136. 2016-03-18 15:56:41 17547 [Note] WSREP: Setting initial position to ee9fde7c-fe20-11e4-aa76-8beb5059c427:78871482
  137. 2016-03-18 15:56:41 17547 [Note] WSREP: protonet asio version 0
  138. 2016-03-18 15:56:41 17547 [Note] WSREP: Using CRC-32C for message checksums.
  139. 2016-03-18 15:56:41 17547 [Note] WSREP: backend: asio
  140. 2016-03-18 15:56:41 17547 [Warning] WSREP: access file(/mnt/ssd/mysql//gvwstate.dat) failed(No such file or directory)
  141. 2016-03-18 15:56:41 17547 [Note] WSREP: restore pc from disk failed
  142. 2016-03-18 15:56:41 17547 [Note] WSREP: GMCast version 0
  143. 2016-03-18 15:56:41 17547 [Note] WSREP: (9f79f8cb, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
  144. 2016-03-18 15:56:41 17547 [Note] WSREP: (9f79f8cb, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
  145. 2016-03-18 15:56:41 17547 [Note] WSREP: EVS version 0
  146. 2016-03-18 15:56:41 17547 [Note] WSREP: gcomm: connecting to group 'pams-database', peer '10.1.0.5:,10.1.0.6:,10.1.0.7:,10.5.0.4:,10.5.0.5:'
  147. 2016-03-18 15:56:41 17547 [Warning] WSREP: (9f79f8cb, 'tcp://0.0.0.0:4567') address 'tcp://10.1.0.7:4567' points to own listening address, blacklisting
  148. 2016-03-18 15:56:41 17547 [Note] WSREP: (9f79f8cb, 'tcp://0.0.0.0:4567') address 'tcp://10.1.0.7:4567' pointing to uuid 9f79f8cb is blacklisted, skipping
  149. 2016-03-18 15:56:41 17547 [Note] WSREP: (9f79f8cb, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
  150. 2016-03-18 15:56:41 17547 [Note] WSREP: (9f79f8cb, 'tcp://0.0.0.0:4567') address 'tcp://10.1.0.7:4567' pointing to uuid 9f79f8cb is blacklisted, skipping
  151. 2016-03-18 15:56:43 17547 [Note] WSREP: declaring 000ecfeb at tcp://10.1.0.6:4567 stable
  152. 2016-03-18 15:56:43 17547 [Note] WSREP: declaring 43259ec8 at tcp://10.5.0.5:4567 stable
  153. 2016-03-18 15:56:43 17547 [Note] WSREP: declaring 53db0fe7 at tcp://10.5.0.4:4567 stable
  154. 2016-03-18 15:56:43 17547 [Note] WSREP: declaring e148d044 at tcp://10.1.0.5:4567 stable
  155. 2016-03-18 15:56:44 17547 [Note] WSREP: view(view_id(NON_PRIM,000ecfeb,1152) memb {
  156. 000ecfeb,1
  157. 43259ec8,2
  158. 53db0fe7,2
  159. 9f79f8cb,1
  160. e148d044,1
  161. } joined {
  162. } left {
  163. } partitioned {
  164. 503f2a17,1
  165. })
  166. 2016-03-18 15:56:45 17547 [Note] WSREP: (9f79f8cb, 'tcp://0.0.0.0:4567') turning message relay requesting off
  167. 2016-03-18 15:57:11 17547 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out)
  168. at gcomm/src/pc.cpp:connect():162
  169. 2016-03-18 15:57:11 17547 [ERROR] WSREP: gcs/src/gcs_core.cpp:long int gcs_core_open(gcs_core_t*, const char*, const char*, bool)():206: Failed to open backend connection: -110 (Connection timed out)
  170. 2016-03-18 15:57:11 17547 [ERROR] WSREP: gcs/src/gcs.cpp:long int gcs_open(gcs_conn_t*, const char*, const char*, bool)():1379: Failed to open channel 'pams-database' at 'gcomm://10.1.0.5,10.1.0.6,10.1.0.7,10.5.0.4,10.5.0.5': -110 (Connection timed out)
  171. 2016-03-18 15:57:11 17547 [ERROR] WSREP: gcs connect failed: Connection timed out
  172. 2016-03-18 15:57:11 17547 [ERROR] WSREP: wsrep::connect() failed: 7
  173. 2016-03-18 15:57:11 17547 [ERROR] Aborting
  174.  
  175. 2016-03-18 15:57:11 17547 [Note] WSREP: Service disconnected.
  176. 2016-03-18 15:57:12 17547 [Note] WSREP: Some threads may fail to exit.
  177. 2016-03-18 15:57:12 17547 [Note] Binlog end
  178. 2016-03-18 15:57:12 17547 [Note] /usr/sbin/mysqld: Shutdown complete
  179.  
  180. 160318 15:57:12 mysqld_safe mysqld from pid file /run/mysqld/mysql.pid ended
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement