Advertisement
Guest User

Untitled

a guest
Aug 13th, 2017
516
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 2017-08-13T09:24:15.075210Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  2. 2017-08-13T09:24:15.078067Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-15-57-log) starting as process 11054 ...
  3. 2017-08-13T09:24:15.080487Z 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=db02-bin' to avoid this problem.
  4. 2017-08-13T09:24:15.080707Z 0 [Note] WSREP: No pre-stored wsrep-start position found. Skipping position initialization.
  5. 2017-08-13T09:24:15.080724Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera3/libgalera_smm.so'
  6. 2017-08-13T09:24:15.084682Z 0 [Note] WSREP: wsrep_load(): Galera 3.20(r7e383f7) by Codership Oy <info@codership.com> loaded successfully.
  7. 2017-08-13T09:24:15.084741Z 0 [Note] WSREP: CRC-32C: using hardware acceleration.
  8. 2017-08-13T09:24:15.085119Z 0 [Note] WSREP: Found saved state: cc726457-7ffb-11e7-9879-7bb11ba2758a:0, safe_to_bootsrap: 1
  9. 2017-08-13T09:24:15.086375Z 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.136.35.15; 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;
  10. 2017-08-13T09:24:15.111462Z 0 [Note] WSREP: Assign initial position for certification: 0, protocol version: -1
  11. 2017-08-13T09:24:15.111509Z 0 [Note] WSREP: Preparing to initiate SST/IST
  12. 2017-08-13T09:24:15.111533Z 0 [Note] WSREP: Starting replication
  13. 2017-08-13T09:24:15.111544Z 0 [Note] WSREP: Setting initial position to cc726457-7ffb-11e7-9879-7bb11ba2758a:0
  14. 2017-08-13T09:24:15.111780Z 0 [Note] WSREP: Using CRC-32C for message checksums.
  15. 2017-08-13T09:24:15.111885Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
  16. 2017-08-13T09:24:15.112063Z 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
  17. 2017-08-13T09:24:15.112077Z 0 [Note] WSREP: Restoring primary-component from disk failed. Either node is booting for first time or re-booting after a graceful shutdown
  18. 2017-08-13T09:24:15.112693Z 0 [Note] WSREP: GMCast version 0
  19. 2017-08-13T09:24:15.112824Z 0 [Note] WSREP: (2cb3a501, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
  20. 2017-08-13T09:24:15.112833Z 0 [Note] WSREP: (2cb3a501, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
  21. 2017-08-13T09:24:15.113184Z 0 [Note] WSREP: EVS version 0
  22. 2017-08-13T09:24:15.113286Z 0 [Note] WSREP: gcomm: connecting to group 'pxc-cluster', peer ''
  23. 2017-08-13T09:24:15.113316Z 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery
  24. 2017-08-13T09:24:15.113608Z 0 [Note] WSREP: Node 2cb3a501 state primary
  25. 2017-08-13T09:24:15.113648Z 0 [Note] WSREP: Current view of cluster as seen by this node
  26. view (view_id(PRIM,2cb3a501,1)
  27. memb {
  28. 2cb3a501,0
  29. }
  30. joined {
  31. }
  32. left {
  33. }
  34. partitioned {
  35. }
  36. )
  37. 2017-08-13T09:24:15.113655Z 0 [Note] WSREP: Save the discovered primary-component to disk
  38. 2017-08-13T09:24:15.113775Z 0 [Note] WSREP: gcomm: connected
  39. 2017-08-13T09:24:15.113831Z 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
  40. 2017-08-13T09:24:15.113917Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
  41. 2017-08-13T09:24:15.113923Z 0 [Note] WSREP: Waiting for SST/IST to complete.
  42. 2017-08-13T09:24:15.114823Z 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 2cb3fe61-8009-11e7-8fa4-17a7867ac69d
  43. 2017-08-13T09:24:15.114846Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 2cb3fe61-8009-11e7-8fa4-17a7867ac69d
  44. 2017-08-13T09:24:15.114853Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 2cb3fe61-8009-11e7-8fa4-17a7867ac69d from 0 (pxc-cluster-node-1)
  45. 2017-08-13T09:24:15.114861Z 0 [Note] WSREP: Quorum results:
  46. version = 4,
  47. component = PRIMARY,
  48. conf_id = 0,
  49. members = 1/1 (primary/total),
  50. act_id = 0,
  51. last_appl. = -1,
  52. protocols = 0/7/3 (gcs/repl/appl),
  53. group UUID = cc726457-7ffb-11e7-9879-7bb11ba2758a
  54. 2017-08-13T09:24:15.114867Z 0 [Note] WSREP: Flow-control interval: [100, 100]
  55. 2017-08-13T09:24:15.114871Z 0 [Note] WSREP: Restored state OPEN -> JOINED (0)
  56. 2017-08-13T09:24:15.114892Z 0 [Note] WSREP: Member 0.0 (pxc-cluster-node-1) synced with group.
  57. 2017-08-13T09:24:15.114898Z 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
  58. 2017-08-13T09:24:15.114942Z 1 [Note] WSREP: New cluster view: global state: cc726457-7ffb-11e7-9879-7bb11ba2758a:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3
  59. 2017-08-13T09:24:15.114966Z 0 [Note] WSREP: SST complete, seqno: 0
  60. 2017-08-13T09:24:15.117606Z 0 [Note] InnoDB: PUNCH HOLE support available
  61. 2017-08-13T09:24:15.117627Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  62. 2017-08-13T09:24:15.117632Z 0 [Note] InnoDB: Uses event mutexes
  63. 2017-08-13T09:24:15.117635Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  64. 2017-08-13T09:24:15.117639Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
  65. 2017-08-13T09:24:15.117642Z 0 [Note] InnoDB: Using Linux native AIO
  66. 2017-08-13T09:24:15.118002Z 0 [Note] InnoDB: Number of pools: 1
  67. 2017-08-13T09:24:15.118211Z 0 [Note] InnoDB: Using CPU crc32 instructions
  68. 2017-08-13T09:24:15.120127Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  69. 2017-08-13T09:24:15.127996Z 0 [Note] InnoDB: Completed initialization of buffer pool
  70. 2017-08-13T09:24:15.132009Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
  71. 2017-08-13T09:24:15.146260Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
  72. 2017-08-13T09:24:15.147033Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  73. 2017-08-13T09:24:15.161126Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 3932160 bytes
  74. 2017-08-13T09:24:15.168579Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  75. 2017-08-13T09:24:15.168658Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  76. 2017-08-13T09:24:15.207318Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
  77. 2017-08-13T09:24:15.208704Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  78. 2017-08-13T09:24:15.208718Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  79. 2017-08-13T09:24:15.209161Z 0 [Note] InnoDB: Waiting for purge to start
  80. 2017-08-13T09:24:15.259427Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.18-15 started; log sequence number 2541466
  81. 2017-08-13T09:24:15.259685Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
  82. 2017-08-13T09:24:15.259975Z 0 [Note] Plugin 'FEDERATED' is disabled.
  83. 2017-08-13T09:24:15.262659Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170813 2:24:15
  84. 2017-08-13T09:24:15.271905Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
  85. 2017-08-13T09:24:15.271923Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
  86. 2017-08-13T09:24:15.272716Z 0 [Warning] CA certificate ca.pem is self signed.
  87. 2017-08-13T09:24:15.272795Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
  88. 2017-08-13T09:24:15.272899Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
  89. 2017-08-13T09:24:15.272937Z 0 [Note] IPv6 is available.
  90. 2017-08-13T09:24:15.272947Z 0 [Note] - '::' resolves to '::';
  91. 2017-08-13T09:24:15.272971Z 0 [Note] Server socket created on IP: '::'.
  92. 2017-08-13T09:24:15.282069Z 0 [Note] Event Scheduler: Loaded 0 events
  93. 2017-08-13T09:24:15.282586Z 0 [Note] /usr/sbin/mysqld: ready for connections.
  94. Version: '5.7.18-15-57-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Percona XtraDB Cluster (GPL), Release rel15, Revision 7693d6e, WSREP version 29.20, wsrep_29.20
  95. 2017-08-13T09:24:15.282600Z 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.
  96. 2017-08-13T09:24:15.282603Z 0 [Note] Beginning of list of non-natively partitioned tables
  97. 2017-08-13T09:24:15.283116Z 1 [Note] WSREP: Initialized wsrep sidno 2
  98. 2017-08-13T09:24:15.283146Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  99. 2017-08-13T09:24:15.283178Z 1 [Note] WSREP: REPL Protocols: 7 (3, 2)
  100. 2017-08-13T09:24:15.283188Z 1 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3
  101. 2017-08-13T09:24:15.283205Z 0 [Note] WSREP: Service thread queue flushed.
  102. 2017-08-13T09:24:15.283275Z 1 [Note] WSREP: Synchronized with group, ready for connections
  103. 2017-08-13T09:24:15.283280Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  104. 2017-08-13T09:24:15.296504Z 0 [Note] End of list of non-natively partitioned tables
  105. 2017-08-13T09:24:16.650050Z 12 [Note] Access denied for user 'root'@'localhost' (using password: NO)
Advertisement
RAW Paste Data Copied
Advertisement