API tools faq
paste
Advertisement
cyclonebt

percona-xtradb-cluster logs

cyclonebt
Nov 16th, 2017
143
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.79 KB | None | 0 0
raw download clone embed print report
  1. Log file from host 1
  2.  
  3. 2017-11-16T11:00:52.618857Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  4. 2017-11-16T11:00:52.621107Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.19-17-57-log) starting as process 5444 ...
  5. 2017-11-16T11:00:52.624292Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=localhost-bin' to avoid this problem.
  6. 2017-11-16T11:00:52.624617Z 0 [Note] WSREP: Setting wsrep_ready to false
  7. 2017-11-16T11:00:52.624663Z 0 [Note] WSREP: No pre-stored wsrep-start position found. Skipping position initialization. 2017-11-16T11:00:52.624677Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera3/libgalera_smm.so'
  8. 2017-11-16T11:00:52.628385Z 0 [Note] WSREP: wsrep_load(): Galera 3.22(r8678538) by Codership Oy <info@codership.com> loaded successfully.
  9. 2017-11-16T11:00:52.628507Z 0 [Note] WSREP: CRC-32C: using hardware acceleration.
  10. 2017-11-16T11:00:52.629035Z 0 [Note] WSREP: Found saved state: f28ae440-cabb-11e7-976c-17bca5fe1b6b:0, safe_to_bootsrap: 1
  11. 2017-11-16T11:00:52.630719Z 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 192.168.175.141; 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 = 10; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 4; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_count = 0; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 100; 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.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.recovery = 1; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.weight = 1; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 7; socket.checksum = 2; socket.recv_buf_size = 212992;
  12. 2017-11-16T11:00:52.649216Z 0 [Note] WSREP: Assign initial position for certification: 0, protocol version: -1
  13. 2017-11-16T11:00:52.649280Z 0 [Note] WSREP: Preparing to initiate SST/IST
  14. 2017-11-16T11:00:52.649285Z 0 [Note] WSREP: Starting replication
  15. 2017-11-16T11:00:52.649295Z 0 [Note] WSREP: Setting initial position to f28ae440-cabb-11e7-976c-17bca5fe1b6b:0
  16. 2017-11-16T11:00:52.649533Z 0 [Note] WSREP: Using CRC-32C for message checksums.
  17. 2017-11-16T11:00:52.649687Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
  18. 2017-11-16T11:00:52.649812Z 0 [Warning] WSREP: Fail to access the file (/var/lib/mysql//gvwstate.dat) error (No such file or directory). It is possible if node is booting for first time or re-booting after a graceful shutdown
  19. 2017-11-16T11:00:52.649824Z 0 [Note] WSREP: Restoring primary-component from disk failed. Either node is booting for first time or re-booting after a graceful shutdown
  20. 2017-11-16T11:00:52.650024Z 0 [Note] WSREP: GMCast version 0
  21. 2017-11-16T11:00:52.650122Z 0 [Note] WSREP: (698bf28c, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
  22. 2017-11-16T11:00:52.650130Z 0 [Note] WSREP: (698bf28c, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
  23. 2017-11-16T11:00:52.650432Z 0 [Note] WSREP: EVS version 0
  24. 2017-11-16T11:00:52.650560Z 0 [Note] WSREP: gcomm: bootstrapping new group 'pxc-cluster'
  25. 2017-11-16T11:00:52.650592Z 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery
  26. 2017-11-16T11:00:52.650791Z 0 [Note] WSREP: Node 698bf28c state primary
  27. 2017-11-16T11:00:52.650825Z 0 [Note] WSREP: Current view of cluster as seen by this node
  28. view (view_id(PRIM,698bf28c,1)
  29. memb {
  30.         698bf28c,0
  31.         }
  32. joined {
  33.         }
  34. left {
  35.         }
  36. partitioned {
  37.         }
  38. )
  39. 2017-11-16T11:00:52.650833Z 0 [Note] WSREP: Save the discovered primary-component to disk
  40. 2017-11-16T11:00:52.650951Z 0 [Note] WSREP: gcomm: connected
  41. 2017-11-16T11:00:52.651029Z 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
  42. 2017-11-16T11:00:52.651120Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
  43. 2017-11-16T11:00:52.651210Z 0 [Note] WSREP: Waiting for SST/IST to complete.
  44. 2017-11-16T11:00:52.651296Z 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 698c28c6-cabd-11e7-8969-ba05ed21e5ef
  45. 2017-11-16T11:00:52.651326Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 698c28c6-cabd-11e7-8969-ba05ed21e5ef
  46. 2017-11-16T11:00:52.651335Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 698c28c6-cabd-11e7-8969-ba05ed21e5ef from 0 (pxc-cluster-node-1)
  47. 2017-11-16T11:00:52.651343Z 0 [Note] WSREP: Quorum results:
  48.         version    = 4,
  49.         component  = PRIMARY,
  50.         conf_id    = 0,
  51.         members    = 1/1 (primary/total),
  52.         act_id     = 0,
  53.         last_appl. = -1,
  54.         protocols  = 0/7/3 (gcs/repl/appl),
  55.         group UUID = f28ae440-cabb-11e7-976c-17bca5fe1b6b
  56. 2017-11-16T11:00:52.651349Z 0 [Note] WSREP: Flow-control interval: [100, 100]
  57. 2017-11-16T11:00:52.651353Z 0 [Note] WSREP: Trying to continue unpaused monitor
  58. 2017-11-16T11:00:52.651357Z 0 [Note] WSREP: Restored state OPEN -> JOINED (0)
  59. 2017-11-16T11:00:52.651369Z 0 [Note] WSREP: Member 0.0 (pxc-cluster-node-1) synced with group.
  60. 2017-11-16T11:00:52.651374Z 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
  61. 2017-11-16T11:00:52.651616Z 2 [Note] WSREP: New cluster view: global state: f28ae440-cabb-11e7-976c-17bca5fe1b6b:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3
  62. 2017-11-16T11:00:52.651629Z 2 [Note] WSREP: Setting wsrep_ready to true
  63. 2017-11-16T11:00:52.651661Z 0 [Note] WSREP: SST complete, seqno: 0
  64. 2017-11-16T11:00:52.653531Z 0 [Note] InnoDB: PUNCH HOLE support available
  65. 2017-11-16T11:00:52.653553Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  66. 2017-11-16T11:00:52.653558Z 0 [Note] InnoDB: Uses event mutexes
  67. 2017-11-16T11:00:52.653562Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  68. 2017-11-16T11:00:52.653566Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
  69. 2017-11-16T11:00:52.653570Z 0 [Note] InnoDB: Using Linux native AIO
  70. 2017-11-16T11:00:52.653839Z 0 [Note] InnoDB: Number of pools: 1
  71. 2017-11-16T11:00:52.653992Z 0 [Note] InnoDB: Using CPU crc32 instructions
  72. 2017-11-16T11:00:52.655533Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  73. 2017-11-16T11:00:52.660776Z 0 [Note] InnoDB: Completed initialization of buffer pool
  74. 2017-11-16T11:00:52.663070Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  75. 2017-11-16T11:00:52.675225Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
  76. 2017-11-16T11:00:52.675908Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  77. 2017-11-16T11:00:52.700140Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 3932160 bytes
  78. 2017-11-16T11:00:52.706125Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  79. 2017-11-16T11:00:52.706248Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  80. 2017-11-16T11:00:52.731183Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  81. 2017-11-16T11:00:52.732109Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2017-11-16T11:00:52.732123Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  82. 2017-11-16T11:00:52.732454Z 0 [Note] InnoDB: Waiting for purge to start
  83. 2017-11-16T11:00:52.782734Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.19-17 started; log sequence number 2545416
  84. 2017-11-16T11:00:52.783018Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  85. 2017-11-16T11:00:52.783238Z 0 [Note] Plugin 'FEDERATED' is disabled.
  86. 2017-11-16T11:00:52.785527Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171116 11:00:52
  87. 2017-11-16T11:00:52.792690Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
  88. 2017-11-16T11:00:52.792715Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
  89. 2017-11-16T11:00:52.793190Z 0 [Warning] CA certificate ca.pem is self signed.
  90. 2017-11-16T11:00:52.793229Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
  91. 2017-11-16T11:00:52.793310Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  92. 2017-11-16T11:00:52.793357Z 0 [Note] IPv6 is available.
  93. 2017-11-16T11:00:52.793368Z 0 [Note]   - '::' resolves to '::';
  94. 2017-11-16T11:00:52.793392Z 0 [Note] Server socket created on IP: '::'.
  95. 2017-11-16T11:00:52.802933Z 0 [Note] Event Scheduler: Loaded 0 events
  96. 2017-11-16T11:00:52.803688Z 0 [Note] /usr/sbin/mysqld: ready for connections.
  97. Version: '5.7.19-17-57-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Percona XtraDB Cluster (GPL), Release rel17, Revision 35cdc81, WSREP version 29.22, wsrep_29.22
  98. 2017-11-16T11:00:52.803828Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
  99. 2017-11-16T11:00:52.803845Z 0 [Note] Beginning of list of non-natively partitioned tables
  100. 2017-11-16T11:00:52.804351Z 2 [Note] WSREP: Initialized wsrep sidno 2
  101. 2017-11-16T11:00:52.804375Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  102. 2017-11-16T11:00:52.804407Z 2 [Note] WSREP: REPL Protocols: 7 (3, 2)
  103. 2017-11-16T11:00:52.804417Z 2 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3
  104. 2017-11-16T11:00:52.804440Z 0 [Note] WSREP: Service thread queue flushed.
  105. 2017-11-16T11:00:52.804628Z 2 [Note] WSREP: Synchronized with group, ready for connections
  106. 2017-11-16T11:00:52.804638Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  107. 2017-11-16T11:00:52.814564Z 0 [Note] End of list of non-natively partitioned tables
  108.  
  109. There are no entries in the log from the second node being brought up.
  110.  
  111. Log file from host 2
  112.  
  113. 2017-11-16T11:03:01.252059Z mysqld_safe Logging to '/var/log/mysqld.log'.
  114. 2017-11-16T11:03:01.269736Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  115. 2017-11-16T11:03:01.280993Z mysqld_safe Skipping wsrep-recover for 9df5f23e-cabc-11e7-b6e2-030d02b0e16b:0 pair
  116. 2017-11-16T11:03:01.282066Z mysqld_safe Assigning 9df5f23e-cabc-11e7-b6e2-030d02b0e16b:0 to wsrep_start_position
  117. 2017-11-16T11:03:01.520087Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  118. 2017-11-16T11:03:01.522355Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.19-17-57-log) starting as process 4996 ...
  119. 2017-11-16T11:03:01.525233Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=localhost-bin' to avoid this problem.
  120. 2017-11-16T11:03:01.525784Z 0 [Note] WSREP: Setting wsrep_ready to false
  121. 2017-11-16T11:03:01.525818Z 0 [Note] WSREP: No pre-stored wsrep-start position found. Skipping position initialization. 2017-11-16T11:03:01.525828Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera3/libgalera_smm.so'
  122. 2017-11-16T11:03:01.529866Z 0 [Note] WSREP: wsrep_load(): Galera 3.22(r8678538) by Codership Oy <info@codership.com> loaded successfully.
  123. 2017-11-16T11:03:01.529991Z 0 [Note] WSREP: CRC-32C: using hardware acceleration.
  124. 2017-11-16T11:03:01.530582Z 0 [Note] WSREP: Found saved state: 9df5f23e-cabc-11e7-b6e2-030d02b0e16b:0, safe_to_bootsrap: 1
  125. 2017-11-16T11:03:01.532110Z 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 192.168.168.30; 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 = 10; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 4; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_count = 0; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 100; 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.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.recovery = 1; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.weight = 1; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 7; socket.checksum = 2; socket.recv_buf_size = 212992;
  126. 2017-11-16T11:03:01.552006Z 0 [Note] WSREP: Assign initial position for certification: 0, protocol version: -1
  127. 2017-11-16T11:03:01.552065Z 0 [Note] WSREP: Preparing to initiate SST/IST
  128. 2017-11-16T11:03:01.552073Z 0 [Note] WSREP: Starting replication
  129. 2017-11-16T11:03:01.552089Z 0 [Note] WSREP: Setting initial position to 9df5f23e-cabc-11e7-b6e2-030d02b0e16b:0
  130. 2017-11-16T11:03:01.552363Z 0 [Note] WSREP: Using CRC-32C for message checksums.
  131. 2017-11-16T11:03:01.552509Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
  132. 2017-11-16T11:03:01.552636Z 0 [Warning] WSREP: Fail to access the file (/var/lib/mysql//gvwstate.dat) error (No such file or directory). It is possible if node is booting for first time or re-booting after a graceful shutdown
  133. 2017-11-16T11:03:01.552649Z 0 [Note] WSREP: Restoring primary-component from disk failed. Either node is booting for first time or re-booting after a graceful shutdown
  134. 2017-11-16T11:03:01.552848Z 0 [Note] WSREP: GMCast version 0
  135. 2017-11-16T11:03:01.552948Z 0 [Note] WSREP: (b660f527, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
  136. 2017-11-16T11:03:01.552957Z 0 [Note] WSREP: (b660f527, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
  137. 2017-11-16T11:03:01.553290Z 0 [Note] WSREP: EVS version 0
  138. 2017-11-16T11:03:01.553373Z 0 [Note] WSREP: gcomm: connecting to group 'pxc-cluster', peer ''
  139. 2017-11-16T11:03:01.553404Z 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery
  140. 2017-11-16T11:03:01.553626Z 0 [Note] WSREP: Node b660f527 state primary
  141. 2017-11-16T11:03:01.553672Z 0 [Note] WSREP: Current view of cluster as seen by this node
  142. view (view_id(PRIM,b660f527,1)
  143. memb {
  144.         b660f527,0
  145.         }
  146. joined {
  147.         }
  148. left {
  149.         }
  150. partitioned {
  151.         }
  152. )
  153. 2017-11-16T11:03:01.553682Z 0 [Note] WSREP: Save the discovered primary-component to disk
  154. 2017-11-16T11:03:01.553841Z 0 [Note] WSREP: gcomm: connected
  155. 2017-11-16T11:03:01.553945Z 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
  156. 2017-11-16T11:03:01.554193Z 0 [Note] WSREP: Waiting for SST/IST to complete.
  157. 2017-11-16T11:03:01.554200Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
  158. 2017-11-16T11:03:01.554327Z 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: b661342c-cabd-11e7-b6d6-dab2cfc8b8e4
  159. 2017-11-16T11:03:01.554342Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: b661342c-cabd-11e7-b6d6-dab2cfc8b8e4
  160. 2017-11-16T11:03:01.554348Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: b661342c-cabd-11e7-b6d6-dab2cfc8b8e4 from 0 (pxc-cluster-node-1)
  161. 2017-11-16T11:03:01.554355Z 0 [Note] WSREP: Quorum results:
  162.         version    = 4,
  163.         component  = PRIMARY,
  164.         conf_id    = 0,
  165.         members    = 1/1 (primary/total),
  166.         act_id     = 0,
  167.         last_appl. = -1,
  168.         protocols  = 0/7/3 (gcs/repl/appl),
  169.         group UUID = 9df5f23e-cabc-11e7-b6e2-030d02b0e16b
  170. 2017-11-16T11:03:01.554362Z 0 [Note] WSREP: Flow-control interval: [100, 100]
  171. 2017-11-16T11:03:01.554365Z 0 [Note] WSREP: Trying to continue unpaused monitor
  172. 2017-11-16T11:03:01.554369Z 0 [Note] WSREP: Restored state OPEN -> JOINED (0)
  173. 2017-11-16T11:03:01.554380Z 0 [Note] WSREP: Member 0.0 (pxc-cluster-node-1) synced with group.
  174. 2017-11-16T11:03:01.554385Z 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
  175. 2017-11-16T11:03:01.554633Z 2 [Note] WSREP: New cluster view: global state: 9df5f23e-cabc-11e7-b6e2-030d02b0e16b:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3
  176. 2017-11-16T11:03:01.554647Z 2 [Note] WSREP: Setting wsrep_ready to true
  177. 2017-11-16T11:03:01.554684Z 0 [Note] WSREP: SST complete, seqno: 0
  178. 2017-11-16T11:03:01.557304Z 0 [Note] InnoDB: PUNCH HOLE support available
  179. 2017-11-16T11:03:01.557333Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  180. 2017-11-16T11:03:01.557356Z 0 [Note] InnoDB: Uses event mutexes
  181. 2017-11-16T11:03:01.557364Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  182. 2017-11-16T11:03:01.557370Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
  183. 2017-11-16T11:03:01.557377Z 0 [Note] InnoDB: Using Linux native AIO
  184. 2017-11-16T11:03:01.557756Z 0 [Note] InnoDB: Number of pools: 1
  185. 2017-11-16T11:03:01.557878Z 0 [Note] InnoDB: Using CPU crc32 instructions
  186. 2017-11-16T11:03:01.559589Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  187. 2017-11-16T11:03:01.564956Z 0 [Note] InnoDB: Completed initialization of buffer pool
  188. 2017-11-16T11:03:01.567683Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  189. 2017-11-16T11:03:01.579637Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
  190. 2017-11-16T11:03:01.580603Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  191. 2017-11-16T11:03:01.605423Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 3932160 bytes
  192. 2017-11-16T11:03:01.611019Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  193. 2017-11-16T11:03:01.611142Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  194. 2017-11-16T11:03:01.643921Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  195. 2017-11-16T11:03:01.645021Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2017-11-16T11:03:01.645050Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  196. 2017-11-16T11:03:01.645491Z 0 [Note] InnoDB: Waiting for purge to start
  197. 2017-11-16T11:03:01.695857Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.19-17 started; log sequence number 2545435
  198. 2017-11-16T11:03:01.696667Z 0 [Note] Plugin 'FEDERATED' is disabled.
  199. 2017-11-16T11:03:01.699692Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  200. 2017-11-16T11:03:01.706255Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171116 11:03:01
  201. 2017-11-16T11:03:01.720436Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
  202. 2017-11-16T11:03:01.720480Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
  203. 2017-11-16T11:03:01.721185Z 0 [Warning] CA certificate ca.pem is self signed.
  204. 2017-11-16T11:03:01.721243Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
  205. 2017-11-16T11:03:01.721379Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  206. 2017-11-16T11:03:01.721455Z 0 [Note] IPv6 is available.
  207. 2017-11-16T11:03:01.721474Z 0 [Note]   - '::' resolves to '::';
  208. 2017-11-16T11:03:01.721508Z 0 [Note] Server socket created on IP: '::'.
  209. 2017-11-16T11:03:01.734909Z 0 [Note] Event Scheduler: Loaded 0 events
  210. 2017-11-16T11:03:01.735581Z 0 [Note] /usr/sbin/mysqld: ready for connections.
  211. Version: '5.7.19-17-57-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Percona XtraDB Cluster (GPL), Release rel17, Revision 35cdc81, WSREP version 29.22, wsrep_29.22
  212. 2017-11-16T11:03:01.735620Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
  213. 2017-11-16T11:03:01.735627Z 0 [Note] Beginning of list of non-natively partitioned tables
  214. 2017-11-16T11:03:01.736548Z 2 [Note] WSREP: Initialized wsrep sidno 2
  215. 2017-11-16T11:03:01.736581Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  216. 2017-11-16T11:03:01.736624Z 2 [Note] WSREP: REPL Protocols: 7 (3, 2)
  217. 2017-11-16T11:03:01.736640Z 2 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3
  218. 2017-11-16T11:03:01.736672Z 0 [Note] WSREP: Service thread queue flushed.
  219. 2017-11-16T11:03:01.736741Z 2 [Note] WSREP: Synchronized with group, ready for connections
  220. 2017-11-16T11:03:01.736760Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  221. 2017-11-16T11:03:01.767526Z 0 [Note] End of list of non-natively partitioned tables
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!