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).
2017-08-13T09:24:15.078067Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-15-57-log) starting as process 11054 ...
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.
2017-08-13T09:24:15.080707Z 0 [Note] WSREP: No pre-stored wsrep-start position found. Skipping position initialization.
2017-08-13T09:24:15.080724Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera3/libgalera_smm.so'
2017-08-13T09:24:15.084682Z 0 [Note] WSREP: wsrep_load(): Galera 3.20(r7e383f7) by Codership Oy <info@codership.com> loaded successfully.
2017-08-13T09:24:15.084741Z 0 [Note] WSREP: CRC-32C: using hardware acceleration.
2017-08-13T09:24:15.085119Z 0 [Note] WSREP: Found saved state: cc726457-7ffb-11e7-9879-7bb11ba2758a:0, safe_to_bootsrap: 1
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;
2017-08-13T09:24:15.111462Z 0 [Note] WSREP: Assign initial position for certification: 0, protocol version: -1
2017-08-13T09:24:15.111509Z 0 [Note] WSREP: Preparing to initiate SST/IST
2017-08-13T09:24:15.111533Z 0 [Note] WSREP: Starting replication
2017-08-13T09:24:15.111544Z 0 [Note] WSREP: Setting initial position to cc726457-7ffb-11e7-9879-7bb11ba2758a:0
2017-08-13T09:24:15.111780Z 0 [Note] WSREP: Using CRC-32C for message checksums.
2017-08-13T09:24:15.111885Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
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
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
2017-08-13T09:24:15.112693Z 0 [Note] WSREP: GMCast version 0
2017-08-13T09:24:15.112824Z 0 [Note] WSREP: (2cb3a501, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2017-08-13T09:24:15.112833Z 0 [Note] WSREP: (2cb3a501, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2017-08-13T09:24:15.113184Z 0 [Note] WSREP: EVS version 0
2017-08-13T09:24:15.113286Z 0 [Note] WSREP: gcomm: connecting to group 'pxc-cluster', peer ''
2017-08-13T09:24:15.113316Z 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery
2017-08-13T09:24:15.113608Z 0 [Note] WSREP: Node 2cb3a501 state primary
2017-08-13T09:24:15.113648Z 0 [Note] WSREP: Current view of cluster as seen by this node
view (view_id(PRIM,2cb3a501,1)
memb {
	2cb3a501,0
	}
joined {
	}
left {
	}
partitioned {
	}
)
2017-08-13T09:24:15.113655Z 0 [Note] WSREP: Save the discovered primary-component to disk
2017-08-13T09:24:15.113775Z 0 [Note] WSREP: gcomm: connected
2017-08-13T09:24:15.113831Z 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2017-08-13T09:24:15.113917Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2017-08-13T09:24:15.113923Z 0 [Note] WSREP: Waiting for SST/IST to complete.
2017-08-13T09:24:15.114823Z 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 2cb3fe61-8009-11e7-8fa4-17a7867ac69d
2017-08-13T09:24:15.114846Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 2cb3fe61-8009-11e7-8fa4-17a7867ac69d
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)
2017-08-13T09:24:15.114861Z 0 [Note] WSREP: Quorum results:
	version    = 4,
	component  = PRIMARY,
	conf_id    = 0,
	members    = 1/1 (primary/total),
	act_id     = 0,
	last_appl. = -1,
	protocols  = 0/7/3 (gcs/repl/appl),
	group UUID = cc726457-7ffb-11e7-9879-7bb11ba2758a
2017-08-13T09:24:15.114867Z 0 [Note] WSREP: Flow-control interval: [100, 100]
2017-08-13T09:24:15.114871Z 0 [Note] WSREP: Restored state OPEN -> JOINED (0)
2017-08-13T09:24:15.114892Z 0 [Note] WSREP: Member 0.0 (pxc-cluster-node-1) synced with group.
2017-08-13T09:24:15.114898Z 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
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
2017-08-13T09:24:15.114966Z 0 [Note] WSREP: SST complete, seqno: 0
2017-08-13T09:24:15.117606Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-08-13T09:24:15.117627Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-08-13T09:24:15.117632Z 0 [Note] InnoDB: Uses event mutexes
2017-08-13T09:24:15.117635Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-08-13T09:24:15.117639Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-08-13T09:24:15.117642Z 0 [Note] InnoDB: Using Linux native AIO
2017-08-13T09:24:15.118002Z 0 [Note] InnoDB: Number of pools: 1
2017-08-13T09:24:15.118211Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-08-13T09:24:15.120127Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-08-13T09:24:15.127996Z 0 [Note] InnoDB: Completed initialization of buffer pool
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().
2017-08-13T09:24:15.146260Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2017-08-13T09:24:15.147033Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-08-13T09:24:15.161126Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 3932160 bytes
2017-08-13T09:24:15.168579Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-08-13T09:24:15.168658Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-08-13T09:24:15.207318Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-08-13T09:24:15.208704Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-08-13T09:24:15.208718Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-08-13T09:24:15.209161Z 0 [Note] InnoDB: Waiting for purge to start
2017-08-13T09:24:15.259427Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.18-15 started; log sequence number 2541466
2017-08-13T09:24:15.259685Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-08-13T09:24:15.259975Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-08-13T09:24:15.262659Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170813  2:24:15
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.
2017-08-13T09:24:15.271923Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2017-08-13T09:24:15.272716Z 0 [Warning] CA certificate ca.pem is self signed.
2017-08-13T09:24:15.272795Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2017-08-13T09:24:15.272899Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2017-08-13T09:24:15.272937Z 0 [Note] IPv6 is available.
2017-08-13T09:24:15.272947Z 0 [Note]   - '::' resolves to '::';
2017-08-13T09:24:15.272971Z 0 [Note] Server socket created on IP: '::'.
2017-08-13T09:24:15.282069Z 0 [Note] Event Scheduler: Loaded 0 events
2017-08-13T09:24:15.282586Z 0 [Note] /usr/sbin/mysqld: ready for connections.
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
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.
2017-08-13T09:24:15.282603Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-08-13T09:24:15.283116Z 1 [Note] WSREP: Initialized wsrep sidno 2
2017-08-13T09:24:15.283146Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2017-08-13T09:24:15.283178Z 1 [Note] WSREP: REPL Protocols: 7 (3, 2)
2017-08-13T09:24:15.283188Z 1 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3
2017-08-13T09:24:15.283205Z 0 [Note] WSREP: Service thread queue flushed.
2017-08-13T09:24:15.283275Z 1 [Note] WSREP: Synchronized with group, ready for connections
2017-08-13T09:24:15.283280Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2017-08-13T09:24:15.296504Z 0 [Note] End of list of non-natively partitioned tables
2017-08-13T09:24:16.650050Z 12 [Note] Access denied for user 'root'@'localhost' (using password: NO)