CURRENT_TEST: galera_3nodes.galera_ipv6_xtrabackup-v2 2017-08-17T00:04:57.200988Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-08-17T00:04:57.201060Z 0 [Warning] WSREP: Option --wsrep-causal-reads is deprecated. Please start using --wsrep-sync-wait. 2017-08-17T00:04:57.202082Z 0 [Warning] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory. 2017-08-17T00:04:57.202090Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2017-08-17T00:04:57.202114Z 0 [Note] /home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/bin/mysqld (mysqld 5.7.18-16-29.22-debug-log) starting as process 3052 ... 2017-08-17T00:04:57.204488Z 0 [Note] WSREP: Setting wsrep_ready to false 2017-08-17T00:04:57.204500Z 0 [Note] WSREP: No pre-stored wsrep-start position found. Skipping position initialization. 2017-08-17T00:04:57.204503Z 0 [Note] WSREP: wsrep_load(): loading provider library '/home/kennt/dev/pxc/build-bin/lib/libgalera_smm.so' 2017-08-17T00:04:57.215050Z 0 [Note] WSREP: wsrep_load(): Galera 3.22(r51f128c) by Codership Oy loaded successfully. 2017-08-17T00:04:57.215168Z 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2017-08-17T00:04:57.215689Z 0 [Warning] WSREP: Could not open state file for reading: '/home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/var/mysqld.1/data//grastate.dat' 2017-08-17T00:04:57.215705Z 0 [Warning] WSREP: No persistent state found. Bootstraping with default state 2017-08-17T00:04:57.215792Z 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootsrap: 1 2017-08-17T00:04:57.232165Z 0 [Note] WSREP: Passing config to GCS: base_dir = /home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/var/mysqld.1/data/; base_host = [::1]; base_port = 13001; cert.log_conflicts = no; dbug = ; 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 = /home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/var/mysqld.1/data/; gcache.keep_pages_count = 0; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/var/mysqld.1/data//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.listen_addr = tcp://[::]:13001; gmcast.segment = 0; gmcast.version = 0; ist.recv_addr = [::1]:13002; 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; signal = ; socket.checksum = 2; socket.recv_buf_size = 212992; 2017-08-17T00:04:57.246016Z 0 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 00000000-0000-0000-0000-000000000000:-1 2017-08-17T00:04:57.246060Z 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 2017-08-17T00:04:57.246082Z 0 [Note] WSREP: Preparing to initiate SST/IST 2017-08-17T00:04:57.246089Z 0 [Note] WSREP: Starting replication 2017-08-17T00:04:57.246101Z 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 2017-08-17T00:04:57.246338Z 0 [Note] WSREP: Using CRC-32C for message checksums. 2017-08-17T00:04:57.246456Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2017-08-17T00:04:57.246621Z 0 [Warning] WSREP: Fail to access the file (/home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/var/mysqld.1/data//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-17T00:04:57.246633Z 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-17T00:04:57.247345Z 0 [Note] WSREP: GMCast version 0 2017-08-17T00:04:57.247476Z 0 [Note] WSREP: (b44ebdf3, 'tcp://[::]:13001') listening at tcp://[::]:13001 2017-08-17T00:04:57.247484Z 0 [Note] WSREP: (b44ebdf3, 'tcp://[::]:13001') multicast: , ttl: 1 2017-08-17T00:04:57.247870Z 0 [Note] WSREP: EVS version 0 2017-08-17T00:04:57.247980Z 0 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '' 2017-08-17T00:04:57.248014Z 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery 2017-08-17T00:04:57.248392Z 0 [Note] WSREP: Node b44ebdf3 state primary 2017-08-17T00:04:57.248458Z 0 [Note] WSREP: Current view of cluster as seen by this node view (view_id(PRIM,b44ebdf3,1) memb { b44ebdf3,0 } joined { } left { } partitioned { } ) 2017-08-17T00:04:57.248469Z 0 [Note] WSREP: Save the discovered primary-component to disk 2017-08-17T00:04:57.248594Z 0 [Note] WSREP: gcomm: connected 2017-08-17T00:04:57.248642Z 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2017-08-17T00:04:57.248703Z 0 [Note] WSREP: Waiting for SST/IST to complete. 2017-08-17T00:04:57.249033Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 2017-08-17T00:04:57.249642Z 0 [Note] WSREP: Starting new group from scratch: b44f26e8-82df-11e7-9da1-a700f41fc764 2017-08-17T00:04:57.249992Z 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: b44f327f-82df-11e7-965a-8b0a0b1ca705 2017-08-17T00:04:57.250042Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: b44f327f-82df-11e7-965a-8b0a0b1ca705 2017-08-17T00:04:57.250053Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: b44f327f-82df-11e7-965a-8b0a0b1ca705 from 0 (ubuntu) 2017-08-17T00:04:57.250061Z 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 = b44f26e8-82df-11e7-9da1-a700f41fc764 2017-08-17T00:04:57.250074Z 0 [Note] WSREP: Flow-control interval: [100, 100] 2017-08-17T00:04:57.250077Z 0 [Note] WSREP: Trying to continue unpaused monitor 2017-08-17T00:04:57.250080Z 0 [Note] WSREP: Restored state OPEN -> JOINED (0) 2017-08-17T00:04:57.250160Z 1 [Note] WSREP: New cluster view: global state: b44f26e8-82df-11e7-9da1-a700f41fc764:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3 2017-08-17T00:04:57.250180Z 0 [Note] WSREP: SST complete, seqno: 0 2017-08-17T00:04:57.251845Z 0 [Note] InnoDB: PUNCH HOLE support available 2017-08-17T00:04:57.251865Z 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-08-17T00:04:57.251869Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-08-17T00:04:57.251872Z 0 [Note] InnoDB: Uses event mutexes 2017-08-17T00:04:57.251875Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-08-17T00:04:57.251878Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-08-17T00:04:57.251880Z 0 [Note] InnoDB: Using Linux native AIO 2017-08-17T00:04:57.252209Z 0 [Note] InnoDB: Number of pools: 1 2017-08-17T00:04:57.252319Z 0 [Note] InnoDB: Using CPU crc32 instructions 2017-08-17T00:04:57.253484Z 0 [Note] InnoDB: Initializing buffer pool, total size = 24M, instances = 1, chunk size = 24M 2017-08-17T00:04:57.258249Z 0 [Note] WSREP: Member 0.0 (ubuntu) synced with group. 2017-08-17T00:04:57.258278Z 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) 2017-08-17T00:04:57.264996Z 0 [Note] InnoDB: Completed initialization of buffer pool 2017-08-17T00:04:57.265694Z 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-17T00:04:57.276844Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /run/shm/var_auto_VwCt/mysqld.1/data/xb_doublewrite 2017-08-17T00:04:57.278725Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2017-08-17T00:04:57.281097Z 0 [Warning] InnoDB: Failed to set O_DIRECT on file/run/shm/var_auto_VwCt/mysqld.1/data/xb_doublewrite;create: Invalid argument, continuing anyway. O_DIRECT is known to result in 'Invalid argument' on Linux on tmpfs, see MySQL Bug#26662. 2017-08-17T00:04:57.282504Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /run/shm/var_auto_VwCt/mysqld.1/data/xb_doublewrite, size 3932160 bytes 2017-08-17T00:04:57.333350Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-08-17T00:04:57.333402Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-08-17T00:04:57.338891Z 0 [Note] WSREP: (b44ebdf3, 'tcp://[::]:13001') connection established to b45c7d23 tcp://[::1]:13009 2017-08-17T00:04:57.339335Z 0 [Note] WSREP: (b44ebdf3, 'tcp://[::]:13001') turning message relay requesting on, nonlive peers: 2017-08-17T00:04:57.341128Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-08-17T00:04:57.350703Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2017-08-17T00:04:57.350721Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2017-08-17T00:04:57.352381Z 0 [Note] InnoDB: Waiting for purge to start 2017-08-17T00:04:57.359045Z 0 [Note] WSREP: (b44ebdf3, 'tcp://[::]:13001') connection established to b45f8b19 tcp://[::1]:13005 2017-08-17T00:04:57.403452Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.18-rel16 started; log sequence number 1356050 2017-08-17T00:04:57.405087Z 0 [Note] InnoDB: Loading buffer pool(s) from /run/shm/var_auto_VwCt/mysqld.1/data/ib_buffer_pool 2017-08-17T00:04:57.406165Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-08-17T00:04:57.410925Z 0 [Warning] unknown variable 'loose-mysqlx-port=13009' 2017-08-17T00:04:57.410942Z 0 [Warning] unknown variable 'loose-mysqlx-socket=/tmp/j7cnAm3i96/mysqlx.1.sock' 2017-08-17T00:04:57.411989Z 0 [Note] Salting uuid generator variables, current_pid: 3052, server_start_time: 1502928297, bytes_sent: 0, 2017-08-17T00:04:57.412046Z 0 [Note] Generated uuid: 'b467f9e7-82df-11e7-94a3-000c29a42175', server_start_time: 859061630423853461, bytes_sent: 55843424 2017-08-17T00:04:57.412087Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: b467f9e7-82df-11e7-94a3-000c29a42175. 2017-08-17T00:04:57.412573Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170817 3:04:57 2017-08-17T00:04:57.414766Z 0 [Note] Skipping generation of SSL certificates as options related to SSL are specified. 2017-08-17T00:04:57.419758Z 0 [Warning] CA certificate /home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/std_data/cacert.pem is self signed. 2017-08-17T00:04:57.419799Z 0 [Note] Skipping generation of RSA key pair as --sha256_password_auto_generate_rsa_keys is set to OFF. 2017-08-17T00:04:57.419824Z 0 [Note] RSA private key file not found: /home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/var/mysqld.1/data//private_key.pem. Some authentication plugins will not work. 2017-08-17T00:04:57.419831Z 0 [Note] RSA public key file not found: /home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/var/mysqld.1/data//public_key.pem. Some authentication plugins will not work. 2017-08-17T00:04:57.419838Z 0 [Note] Server hostname (bind-address): '*'; port: 13000 2017-08-17T00:04:57.419862Z 0 [Note] IPv6 is available. 2017-08-17T00:04:57.419867Z 0 [Note] - '::' resolves to '::'; 2017-08-17T00:04:57.419901Z 0 [Note] Server socket created on IP: '::'. 2017-08-17T00:04:57.450627Z 0 [Note] Event Scheduler: Loaded 0 events 2017-08-17T00:04:57.451121Z 0 [Note] /home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/bin/mysqld: ready for connections. Version: '5.7.18-16-29.22-debug-log' socket: '/tmp/j7cnAm3i96/mysqld.1.sock' port: 13000 Percona XtraDB Cluster binary (GPL) 5.7.18-29.22, Revision 1b62d4c-debug - UNIV_DEBUG ON, wsrep_29.22 2017-08-17T00:04:57.451135Z 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-17T00:04:57.451139Z 0 [Note] Beginning of list of non-natively partitioned tables 2017-08-17T00:04:57.451168Z 1 [Note] WSREP: Initialized wsrep sidno 2 2017-08-17T00:04:57.451184Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2017-08-17T00:04:57.451207Z 1 [Note] WSREP: REPL Protocols: 7 (3, 2) 2017-08-17T00:04:57.451225Z 1 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3 2017-08-17T00:04:57.451246Z 0 [Note] WSREP: Service thread queue flushed. 2017-08-17T00:04:57.451291Z 1 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> b44f26e8-82df-11e7-9da1-a700f41fc764:0 2017-08-17T00:04:57.451384Z 1 [Note] WSREP: Synchronized with group, ready for connections 2017-08-17T00:04:57.451389Z 1 [Note] WSREP: This node is synced, setting wsrep_ready to true 2017-08-17T00:04:57.451392Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2017-08-17T00:04:57.487879Z 0 [Note] End of list of non-natively partitioned tables 2017-08-17T00:04:57.843538Z 0 [Note] WSREP: declaring b45c7d23 at tcp://[::1]:13009 stable 2017-08-17T00:04:57.844423Z 0 [Note] WSREP: Node b44ebdf3 state primary 2017-08-17T00:04:57.845121Z 0 [Note] WSREP: Current view of cluster as seen by this node view (view_id(PRIM,b44ebdf3,2) memb { b44ebdf3,0 b45c7d23,0 } joined { } left { } partitioned { } ) 2017-08-17T00:04:57.845151Z 0 [Note] WSREP: Save the discovered primary-component to disk 2017-08-17T00:04:57.845423Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 2017-08-17T00:04:57.845864Z 0 [Note] WSREP: forgetting b45f8b19 (tcp://[::1]:13005) 2017-08-17T00:04:57.846015Z 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: b4aa1b65-82df-11e7-9e5f-e61456f6e72d 2017-08-17T00:04:57.847175Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: b4aa1b65-82df-11e7-9e5f-e61456f6e72d 2017-08-17T00:04:57.847665Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: b4aa1b65-82df-11e7-9e5f-e61456f6e72d from 0 (ubuntu) 2017-08-17T00:04:58.341883Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: b4aa1b65-82df-11e7-9e5f-e61456f6e72d from 1 (ubuntu) 2017-08-17T00:04:58.341908Z 0 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 1, members = 1/2 (primary/total), act_id = 0, last_appl. = 0, protocols = 0/7/3 (gcs/repl/appl), group UUID = b44f26e8-82df-11e7-9da1-a700f41fc764 2017-08-17T00:04:58.341919Z 0 [Note] WSREP: Flow-control interval: [141, 141] 2017-08-17T00:04:58.341925Z 0 [Note] WSREP: Trying to continue unpaused monitor 2017-08-17T00:04:58.342151Z 1 [Note] WSREP: New cluster view: global state: b44f26e8-82df-11e7-9da1-a700f41fc764:0, view# 2: Primary, number of nodes: 2, my index: 0, protocol version 3 2017-08-17T00:04:58.342168Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2017-08-17T00:04:58.342187Z 1 [Note] WSREP: REPL Protocols: 7 (3, 2) 2017-08-17T00:04:58.342202Z 1 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3 2017-08-17T00:04:58.342226Z 0 [Note] WSREP: Service thread queue flushed. 2017-08-17T00:04:58.800486Z 0 [Note] WSREP: Member 1.0 (ubuntu) requested state transfer from '*any*'. Selected 0.0 (ubuntu)(SYNCED) as donor. 2017-08-17T00:04:58.800497Z 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 0) 2017-08-17T00:04:58.800536Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2017-08-17T00:04:58.800706Z 0 [Note] WSREP: Initiating SST/IST transfer on DONOR side (wsrep_sst_xtrabackup-v2 --role 'donor' --address '[::1]:13011/xtrabackup_sst//1' --socket '/tmp/j7cnAm3i96/mysqld.1.sock' --datadir '/home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/var/mysqld.1/data/' --defaults-file '/home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/var/my.cnf' --defaults-group-suffix '.1' '' --gtid 'b44f26e8-82df-11e7-9da1-a700f41fc764:0') 2017-08-17T00:04:58.800955Z 1 [Note] WSREP: DONOR thread signaled with 0 2017-08-17T00:05:00.751461Z 0 [Note] WSREP: (b44ebdf3, 'tcp://[::]:13001') turning message relay requesting off 2017-08-17T00:05:00.751492Z 0 [Note] WSREP: cleaning up b45f8b19 (tcp://[::1]:13005) 2017-08-17T00:05:01.864146Z 0 [Note] WSREP: (b44ebdf3, 'tcp://[::]:13001') connection established to b45f8b19 tcp://[::1]:13005 2017-08-17T00:05:01.864950Z 0 [Note] WSREP: (b44ebdf3, 'tcp://[::]:13001') turning message relay requesting on, nonlive peers: 2017-08-17T00:05:05.255599Z 0 [Note] WSREP: (b44ebdf3, 'tcp://[::]:13001') turning message relay requesting off 2017-08-17T00:05:07.849421Z 0 [Note] WSREP: Current view of cluster as seen by this node view (view_id(NON_PRIM,b44ebdf3,2) memb { b44ebdf3,0 } joined { } left { } partitioned { b45c7d23,0 } ) 2017-08-17T00:05:07.849495Z 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2017-08-17T00:05:07.849512Z 0 [Note] WSREP: Flow-control interval: [100, 100] 2017-08-17T00:05:07.849518Z 0 [Note] WSREP: Trying to continue unpaused monitor 2017-08-17T00:05:07.849531Z 0 [Note] WSREP: Received NON-PRIMARY. 2017-08-17T00:05:07.849536Z 0 [Note] WSREP: Shifting DONOR/DESYNCED -> OPEN (TO: 0) 2017-08-17T00:05:07.849596Z 1 [Note] WSREP: New cluster view: global state: b44f26e8-82df-11e7-9da1-a700f41fc764:0, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 2017-08-17T00:05:07.849604Z 1 [Note] WSREP: Setting wsrep_ready to false 2017-08-17T00:05:07.849614Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2017-08-17T00:05:07.849752Z 0 [Note] WSREP: declaring b45f8b19 at tcp://[::1]:13005 stable 2017-08-17T00:05:07.851409Z 0 [Note] WSREP: Current view of cluster as seen by this node view (view_id(NON_PRIM,b44ebdf3,3) memb { b44ebdf3,0 b45f8b19,0 } joined { } left { } partitioned { b45c7d23,0 } ) 2017-08-17T00:05:07.851462Z 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 2 2017-08-17T00:05:07.851474Z 0 [Note] WSREP: Flow-control interval: [141, 141] 2017-08-17T00:05:07.851478Z 0 [Note] WSREP: Trying to continue unpaused monitor 2017-08-17T00:05:07.851481Z 0 [Note] WSREP: Received NON-PRIMARY. 2017-08-17T00:05:07.851508Z 1 [Note] WSREP: New cluster view: global state: b44f26e8-82df-11e7-9da1-a700f41fc764:0, view# -1: non-Primary, number of nodes: 2, my index: 0, protocol version 3 2017-08-17T00:05:07.851513Z 1 [Note] WSREP: Setting wsrep_ready to false 2017-08-17T00:05:07.851517Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2017-08-17T00:05:07.854642Z 0 [Note] WSREP: declaring b45c7d23 at tcp://[::1]:13009 stable 2017-08-17T00:05:07.854658Z 0 [Note] WSREP: declaring b45f8b19 at tcp://[::1]:13005 stable 2017-08-17T00:05:07.855618Z 0 [Note] WSREP: re-bootstrapping prim from partitioned components 2017-08-17T00:05:07.856410Z 0 [Note] WSREP: Current view of cluster as seen by this node view (view_id(PRIM,b44ebdf3,4) memb { b44ebdf3,0 b45c7d23,0 b45f8b19,0 } joined { } left { } partitioned { } ) 2017-08-17T00:05:07.856434Z 0 [Note] WSREP: Save the discovered primary-component to disk 2017-08-17T00:05:07.856580Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3 2017-08-17T00:05:07.857200Z 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: baa1b019-82df-11e7-b10b-d2457c370cbf 2017-08-17T00:05:07.857907Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: baa1b019-82df-11e7-b10b-d2457c370cbf 2017-08-17T00:05:07.858656Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: baa1b019-82df-11e7-b10b-d2457c370cbf from 0 (ubuntu) 2017-08-17T00:05:07.858688Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: baa1b019-82df-11e7-b10b-d2457c370cbf from 1 (ubuntu) 2017-08-17T00:05:07.876753Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: baa1b019-82df-11e7-b10b-d2457c370cbf from 2 (ubuntu) 2017-08-17T00:05:07.876793Z 0 [Warning] WSREP: Quorum: No node with complete state: Version : 4 Flags : 0x3 Protocols : 0 / 7 / 3 State : NON-PRIMARY Desync count : 1 Prim state : DONOR Prim UUID : b4aa1b65-82df-11e7-9e5f-e61456f6e72d Prim seqno : 2 First seqno : -1 Last seqno : 0 Prim JOINED : 1 State UUID : baa1b019-82df-11e7-b10b-d2457c370cbf Group UUID : b44f26e8-82df-11e7-9da1-a700f41fc764 Name : 'ubuntu' Incoming addr: '[::1]:13000' Version : 4 Flags : 00 Protocols : 0 / 7 / 3 State : NON-PRIMARY Desync count : 0 Prim state : JOINER Prim UUID : b4aa1b65-82df-11e7-9e5f-e61456f6e72d Prim seqno : 2 First seqno : -1 Last seqno : 0 Prim JOINED : 1 State UUID : baa1b019-82df-11e7-b10b-d2457c370cbf Group UUID : b44f26e8-82df-11e7-9da1-a700f41fc764 Name : 'ubuntu' Incoming addr: '[::1]:13008' Version : 4 Flags : 00 Protocols : 0 / 7 / 3 State : NON-PRIMARY Desync count : 0 Prim state : NON-PRIMARY Prim UUID : 00000000-0000-0000-0000-000000000000 Prim seqno : -1 First seqno : -1 Last seqno : -1 Prim JOINED : 0 State UUID : baa1b019-82df-11e7-b10b-d2457c370cbf Group UUID : 00000000-0000-0000-0000-000000000000 Name : 'ubuntu' Incoming addr: '[::1]:13004' 2017-08-17T00:05:07.876810Z 0 [Note] WSREP: Full re-merge of primary b4aa1b65-82df-11e7-9e5f-e61456f6e72d found: 1 of 1. 2017-08-17T00:05:07.876821Z 0 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 2, members = 1/3 (primary/total), act_id = 0, last_appl. = 0, protocols = 0/7/3 (gcs/repl/appl), group UUID = b44f26e8-82df-11e7-9da1-a700f41fc764 2017-08-17T00:05:07.876831Z 0 [Note] WSREP: Flow-control interval: [173, 173] 2017-08-17T00:05:07.876836Z 0 [Note] WSREP: Trying to continue unpaused monitor 2017-08-17T00:05:07.876842Z 0 [Note] WSREP: Restored state OPEN -> DONOR/DESYNCED (0) 2017-08-17T00:05:07.876909Z 1 [Note] WSREP: New cluster view: global state: b44f26e8-82df-11e7-9da1-a700f41fc764:0, view# 3: Primary, number of nodes: 3, my index: 0, protocol version 3 2017-08-17T00:05:07.876921Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2017-08-17T00:05:07.876936Z 1 [Note] WSREP: REPL Protocols: 7 (3, 2) 2017-08-17T00:05:07.876950Z 1 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3 2017-08-17T00:05:07.876971Z 0 [Note] WSREP: Service thread queue flushed. 2017-08-17T00:05:08.342256Z 0 [Warning] WSREP: Member 2.0 (ubuntu) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable 2017-08-17T00:05:09.261864Z WSREP_SST: [INFO] Streaming the backup to joiner at [::1] 13011 2017-08-17T00:05:09.343520Z 0 [Warning] WSREP: Member 2.0 (ubuntu) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable 2017-08-17T00:05:10.344296Z 0 [Warning] WSREP: Member 2.0 (ubuntu) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable 2017-08-17T00:05:10.580885Z 8 [Note] Aborted connection 8 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets) 2017-08-17T00:05:10.582570Z WSREP_SST: [ERROR] ******************* FATAL ERROR ********************** 2017-08-17T00:05:10.583820Z WSREP_SST: [ERROR] xtrabackup finished with error: 1. Check /home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/var/mysqld.1/data//innobackup.backup.log --------------- innobackup.backup.log (START) -------------------- 170817 03:05:09 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;host=localhost;port=13000;mysql_socket=/tmp/j7cnAm3i96/mysqld.1.sock' as 'root' (using password: NO). 170817 03:05:09 version_check Connected to MySQL server 170817 03:05:09 version_check Executing a version check against the server... DBD::mysql::db selectrow_array failed: WSREP has not yet prepared node for application use at - line 902. DBD::mysql::db selectrow_array failed: WSREP has not yet prepared node for application use at - line 907. Can't use an undefined value as an ARRAY reference at - line 799. 170817 03:05:09 Connecting to MySQL server host: localhost, user: root, password: set, port: 13000, socket: /tmp/j7cnAm3i96/mysqld.1.sock Using server version 5.7.18-16-29.22-debug-log xtrabackup version 2.4.8 based on MySQL server 5.7.13 Linux (x86_64) (revision id: 97330f7) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/var/mysqld.1/data xtrabackup: open files limit requested 1024, set to 100000 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 5242880 InnoDB: Number of pools: 1 170817 03:05:09 >> log scanned up to (1356242) xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 2 for mysql/plugin, old maximum was 0 xtrabackup: Starting 4 threads for parallel data files transfer 170817 03:05:09 [04] Streaming ./ibdata1 170817 03:05:09 [03] Streaming ./mysql/plugin.ibd 170817 03:05:09 [03] ...done 170817 03:05:09 [03] Streaming ./mysql/help_category.ibd 170817 03:05:09 [01] Streaming ./mysql/help_topic.ibd 170817 03:05:09 [02] Streaming ./mysql/servers.ibd 170817 03:05:09 [03] ...done 170817 03:05:09 [02] ...done 170817 03:05:09 [03] Streaming ./mysql/help_relation.ibd 170817 03:05:09 [02] Streaming ./mysql/help_keyword.ibd 170817 03:05:09 [03] ...done 170817 03:05:09 [02] ...done 170817 03:05:09 [03] Streaming ./mysql/time_zone_name.ibd 170817 03:05:09 [03] ...done 170817 03:05:09 [03] Streaming ./mysql/time_zone.ibd 170817 03:05:09 [03] ...done 170817 03:05:09 [03] Streaming ./mysql/time_zone_transition.ibd 170817 03:05:09 [03] ...done 170817 03:05:09 [03] Streaming ./mysql/time_zone_transition_type.ibd 170817 03:05:09 [02] Streaming ./mysql/time_zone_leap_second.ibd 170817 03:05:09 [03] ...done 170817 03:05:09 [02] ...done 170817 03:05:09 [03] Streaming ./mysql/innodb_table_stats.ibd 170817 03:05:09 [03] ...done 170817 03:05:09 [03] Streaming ./mysql/innodb_index_stats.ibd 170817 03:05:09 [03] ...done 170817 03:05:09 [03] Streaming ./mysql/slave_relay_log_info.ibd 170817 03:05:09 [03] ...done 170817 03:05:09 [03] Streaming ./mysql/slave_master_info.ibd 170817 03:05:09 [03] ...done 170817 03:05:09 [03] Streaming ./mysql/slave_worker_info.ibd 170817 03:05:09 [03] ...done 170817 03:05:09 [03] Streaming ./mysql/gtid_executed.ibd 170817 03:05:09 [03] ...done 170817 03:05:09 [03] Streaming ./mysql/server_cost.ibd 170817 03:05:09 [02] Streaming ./mysql/engine_cost.ibd 170817 03:05:09 [02] ...done 170817 03:05:09 [02] Streaming ./sys/sys_config.ibd 170817 03:05:09 [02] ...done 170817 03:05:09 [03] ...done 170817 03:05:09 [01] ...done 170817 03:05:09 [04] ...done 170817 03:05:10 >> log scanned up to (1356242) 170817 03:05:10 Executing LOCK TABLES FOR BACKUP... Error: failed to execute query LOCK TABLES FOR BACKUP: WSREP has not yet prepared node for application use --------------- innobackup.backup.log (END) ---------------------- 2017-08-17T00:05:10.585575Z WSREP_SST: [ERROR] ****************************************************** 2017-08-17T00:05:10.587391Z WSREP_SST: [ERROR] Cleanup after exit with status:22 2017-08-17T00:05:10.606095Z 0 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'donor' --address '[::1]:13011/xtrabackup_sst//1' --socket '/tmp/j7cnAm3i96/mysqld.1.sock' --datadir '/home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/var/mysqld.1/data/' --defaults-file '/home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/var/my.cnf' --defaults-group-suffix '.1' '' --gtid 'b44f26e8-82df-11e7-9da1-a700f41fc764:0': 22 (Invalid argument) 2017-08-17T00:05:10.606399Z 0 [Note] WSREP: declaring b45f8b19 at tcp://[::1]:13005 stable 2017-08-17T00:05:10.606431Z 0 [Note] WSREP: forgetting b45c7d23 (tcp://[::1]:13009) 2017-08-17T00:05:10.607584Z 0 [Note] WSREP: Node b44ebdf3 state primary 2017-08-17T00:05:10.608001Z 0 [Note] WSREP: Current view of cluster as seen by this node view (view_id(PRIM,b44ebdf3,5) memb { b44ebdf3,0 b45f8b19,0 } joined { } left { } partitioned { b45c7d23,0 } ) 2017-08-17T00:05:10.608018Z 0 [Note] WSREP: Save the discovered primary-component to disk 2017-08-17T00:05:10.608129Z 0 [Note] WSREP: forgetting b45c7d23 (tcp://[::1]:13009) 2017-08-17T00:05:10.608145Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 2017-08-17T00:05:10.608568Z 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: bc458b31-82df-11e7-a590-4b0e6797abad 2017-08-17T00:05:10.608931Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: bc458b31-82df-11e7-a590-4b0e6797abad 2017-08-17T00:05:10.609463Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: bc458b31-82df-11e7-a590-4b0e6797abad from 0 (ubuntu) 2017-08-17T00:05:10.609483Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: bc458b31-82df-11e7-a590-4b0e6797abad from 1 (ubuntu) 2017-08-17T00:05:10.609491Z 0 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 3, members = 1/2 (primary/total), act_id = 0, last_appl. = 0, protocols = 0/7/3 (gcs/repl/appl), group UUID = b44f26e8-82df-11e7-9da1-a700f41fc764 2017-08-17T00:05:10.609497Z 0 [Note] WSREP: Flow-control interval: [141, 141] 2017-08-17T00:05:10.609501Z 0 [Note] WSREP: Trying to continue unpaused monitor 2017-08-17T00:05:10.609609Z 1 [Note] WSREP: New cluster view: global state: b44f26e8-82df-11e7-9da1-a700f41fc764:0, view# 4: Primary, number of nodes: 2, my index: 0, protocol version 3 2017-08-17T00:05:10.609620Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2017-08-17T00:05:10.609630Z 1 [Note] WSREP: REPL Protocols: 7 (3, 2) 2017-08-17T00:05:10.609642Z 1 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3 2017-08-17T00:05:10.609660Z 0 [Note] WSREP: Service thread queue flushed. 2017-08-17T00:05:10.609843Z 0 [Warning] WSREP: Could not find peer: b45c7d23-82df-11e7-a735-873b4a0af717 2017-08-17T00:05:10.609854Z 0 [Warning] WSREP: 0.0 (ubuntu): State transfer to -1.-1 (left the group) failed: -22 (Invalid argument) 2017-08-17T00:05:10.609860Z 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 0) 2017-08-17T00:05:10.610202Z 0 [Note] WSREP: Member 0.0 (ubuntu) synced with group. 2017-08-17T00:05:10.610211Z 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) 2017-08-17T00:05:10.610236Z 1 [Note] WSREP: Synchronized with group, ready for connections 2017-08-17T00:05:10.610244Z 1 [Note] WSREP: This node is synced, setting wsrep_ready to true 2017-08-17T00:05:10.610248Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2017-08-17T00:05:10.616262Z 0 [ERROR] WSREP: Command did not run: wsrep_sst_xtrabackup-v2 --role 'donor' --address '[::1]:13011/xtrabackup_sst//1' --socket '/tmp/j7cnAm3i96/mysqld.1.sock' --datadir '/home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/var/mysqld.1/data/' --defaults-file '/home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/var/my.cnf' --defaults-group-suffix '.1' '' --gtid 'b44f26e8-82df-11e7-9da1-a700f41fc764:0' 2017-08-17T00:05:10.616520Z 0 [Warning] WSREP: Protocol violation. JOIN message sender 0.0 (ubuntu) is not in state transfer (SYNCED). Message ignored. 2017-08-17T00:05:11.345768Z 0 [Note] WSREP: Member 1.0 (ubuntu) requested state transfer from '*any*'. Selected 0.0 (ubuntu)(SYNCED) as donor. 2017-08-17T00:05:11.345791Z 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 0) 2017-08-17T00:05:11.345850Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2017-08-17T00:05:11.346118Z 0 [Note] WSREP: Initiating SST/IST transfer on DONOR side (wsrep_sst_xtrabackup-v2 --role 'donor' --address '[::1]:13007/xtrabackup_sst//1' --socket '/tmp/j7cnAm3i96/mysqld.1.sock' --datadir '/home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/var/mysqld.1/data/' --defaults-file '/home/kennt/dev/pxc/build/usr/local/Percona-XtraDB-Cluster-5.7.18-rel16-29.22-debug.1.Linux.x86_64/mysql-test/var/my.cnf' --defaults-group-suffix '.1' '' --gtid 'b44f26e8-82df-11e7-9da1-a700f41fc764:0') 2017-08-17T00:05:11.347493Z 1 [Note] WSREP: DONOR thread signaled with 0 2017-08-17T00:05:15.768228Z 0 [Note] WSREP: cleaning up b45c7d23 (tcp://[::1]:13009) 2017-08-17T00:05:21.832498Z WSREP_SST: [INFO] Streaming the backup to joiner at [::1] 13007 2017-08-17T00:05:23.569497Z 0 [Note] WSREP: 0.0 (ubuntu): State transfer to 1.0 (ubuntu) complete. 2017-08-17T00:05:23.569515Z 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 0) 2017-08-17T00:05:23.570036Z 0 [Note] WSREP: Member 0.0 (ubuntu) synced with group. 2017-08-17T00:05:23.570050Z 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) 2017-08-17T00:05:23.570081Z 1 [Note] WSREP: Synchronized with group, ready for connections 2017-08-17T00:05:23.570098Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2017-08-17T00:05:26.869636Z 0 [Note] WSREP: 1.0 (ubuntu): State transfer from 0.0 (ubuntu) complete. 2017-08-17T00:05:26.869946Z 0 [Note] WSREP: Member 1.0 (ubuntu) synced with group. safe_process[3051]: Child process: 3052, killed by signal: 9