CURRENT_TEST: galera.galera_sst_mariabackup 2020-04-07 9:37:49 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated 2020-04-07 9:37:49 0 [Note] /home/jan/mysql/10.5/sql/mariadbd (mysqld 10.5.3-MariaDB-debug-log) starting as process 276508 ... 2020-04-07 9:37:49 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190) 2020-04-07 9:37:49 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000) 2020-04-07 9:37:49 0 [Note] WSREP: Server initial position: 00000000-0000-0000-0000-000000000000:-1 2020-04-07 9:37:49 0 [Note] WSREP: Loading provider /usr/lib/libgalera_4_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1 wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib/libgalera_4_smm.so' wsrep loader: [INFO] wsrep_load(): Galera 4.4(rXXXX) by Codership Oy loaded successfully. 2020-04-07 9:37:49 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2020-04-07 9:37:49 0 [Warning] WSREP: Could not open state file for reading: '/home/jan/mysql/10.5/mysql-test/var/mysqld.2/data//grastate.dat' 2020-04-07 9:37:49 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1 2020-04-07 9:37:49 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 0 UUID: 00000000-0000-0000-0000-000000000000 Seqno: -1 - -1 Offset: -1 Synced: 0 2020-04-07 9:37:49 0 [Note] WSREP: Skipped GCache ring buffer recovery: could not determine history UUID. 2020-04-07 9:37:49 0 [Note] WSREP: Passing config to GCS: base_dir = /home/jan/mysql/10.5/mysql-test/var/mysqld.2/data/; base_host = 127.0.0.1; base_port = 16005; cert.log_conflicts = no; cert.optimistic_pa = yes; 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 = /home/jan/mysql/10.5/mysql-test/var/mysqld.2/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 1; gcomm.thread_prio = ; 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 = 2020-04-07 9:37:49 0 [Note] WSREP: SR storage init for: table 2020-04-07 9:37:49 0 [Note] WSREP: wsrep_start_replication 2020-04-07 9:37:49 0 [Note] WSREP: Start replication 2020-04-07 9:37:49 0 [Note] WSREP: Connecting with bootstrap option: 0 2020-04-07 9:37:49 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1 2020-04-07 9:37:49 0 [Note] WSREP: protonet asio version 0 2020-04-07 9:37:49 0 [Note] WSREP: Using CRC-32C for message checksums. 2020-04-07 9:37:49 0 [Note] WSREP: backend: asio 2020-04-07 9:37:49 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2020-04-07 9:37:49 0 [Warning] WSREP: access file(/home/jan/mysql/10.5/mysql-test/var/mysqld.2/data//gvwstate.dat) failed(No such file or directory) 2020-04-07 9:37:49 0 [Note] WSREP: restore pc from disk failed 2020-04-07 9:37:49 0 [Note] WSREP: GMCast version 0 2020-04-07 9:37:49 0 [Note] WSREP: (4cbb2de5-9df3, 'tcp://0.0.0.0:16005') listening at tcp://0.0.0.0:16005 2020-04-07 9:37:49 0 [Note] WSREP: (4cbb2de5-9df3, 'tcp://0.0.0.0:16005') multicast: , ttl: 1 2020-04-07 9:37:49 0 [Note] WSREP: EVS version 1 2020-04-07 9:37:49 0 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '127.0.0.1:16002' 2020-04-07 9:37:49 0 [Note] WSREP: (4cbb2de5-9df3, 'tcp://0.0.0.0:16005') connection established to 4c42a1cb-9fb7 tcp://127.0.0.1:16002 2020-04-07 9:37:49 0 [Note] WSREP: (4cbb2de5-9df3, 'tcp://0.0.0.0:16005') turning message relay requesting on, nonlive peers: 2020-04-07 9:37:50 0 [Note] WSREP: EVS version upgrade 0 -> 1 2020-04-07 9:37:50 0 [Note] WSREP: declaring 4c42a1cb-9fb7 at tcp://127.0.0.1:16002 stable 2020-04-07 9:37:50 0 [Note] WSREP: PC protocol upgrade 0 -> 1 2020-04-07 9:37:50 0 [Note] WSREP: Node 4c42a1cb-9fb7 state prim 2020-04-07 9:37:50 0 [Note] WSREP: view(view_id(PRIM,4c42a1cb-9fb7,2) memb { 4c42a1cb-9fb7,0 4cbb2de5-9df3,0 } joined { } left { } partitioned { }) 2020-04-07 9:37:50 0 [Note] WSREP: save pc into disk 2020-04-07 9:37:50 0 [Note] WSREP: gcomm: connected 2020-04-07 9:37:50 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2020-04-07 9:37:50 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2020-04-07 9:37:50 0 [Note] WSREP: Opened channel 'my_wsrep_cluster' 2020-04-07 9:37:50 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2 2020-04-07 9:37:50 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2020-04-07 9:37:50 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 4d09db1a-789a-11ea-a1be-c7f3b9f4d36b 2020-04-07 9:37:50 0 [Note] WSREP: STATE EXCHANGE: got state msg: 4d09db1a-789a-11ea-a1be-c7f3b9f4d36b from 0 (jan-HP-ZBook-15u-G5) 2020-04-07 9:37:50 0 [Note] WSREP: STATE EXCHANGE: got state msg: 4d09db1a-789a-11ea-a1be-c7f3b9f4d36b from 1 (jan-HP-ZBook-15u-G5) 2020-04-07 9:37:50 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 1, members = 1/2 (joined/total), act_id = 1, last_appl. = 0, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 4c4367d9-789a-11ea-8ce1-0bae0a7aa4dc 2020-04-07 9:37:50 1 [Note] WSREP: wsrep system thread 1, 0x7fd868002078 starting 2020-04-07 9:37:50 1 [Note] WSREP: Starting rollbacker thread 1 2020-04-07 9:37:50 2 [Note] WSREP: wsrep system thread 2, 0x7fd860000db8 starting 2020-04-07 9:37:50 2 [Note] WSREP: Starting applier thread 2 2020-04-07 9:37:50 0 [Note] WSREP: Created page /home/jan/mysql/10.5/mysql-test/var/mysqld.2/data/gcache.page.000000 of size 134217728 bytes 2020-04-07 9:37:50 0 [Note] WSREP: Flow-control interval: [23, 23] 2020-04-07 9:37:50 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 2) 2020-04-07 9:37:50 2 [Note] WSREP: ####### processing CC 2, local, ordered 2020-04-07 9:37:50 2 [Note] WSREP: Process first view: 4c4367d9-789a-11ea-8ce1-0bae0a7aa4dc my uuid: 4cbb2de5-789a-11ea-9df3-2a63dcaf8385 2020-04-07 9:37:50 2 [Note] WSREP: Server jan-HP-ZBook-15u-G5 connected to cluster at position 4c4367d9-789a-11ea-8ce1-0bae0a7aa4dc:2 with ID 4cbb2de5-789a-11ea-9df3-2a63dcaf8385 2020-04-07 9:37:50 2 [Note] [Debug] WSREP: server jan-HP-ZBook-15u-G5 state change: disconnected -> connected 2020-04-07 9:37:50 2 [Note] WSREP: Server status change disconnected -> connected 2020-04-07 9:37:50 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-04-07 9:37:50 2 [Note] WSREP: ####### My UUID: 4cbb2de5-789a-11ea-9df3-2a63dcaf8385 2020-04-07 9:37:50 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes 2020-04-07 9:37:50 0 [Note] WSREP: Service thread queue flushed. 2020-04-07 9:37:50 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2020-04-07 9:37:50 2 [Note] WSREP: State transfer required: Group state: 4c4367d9-789a-11ea-8ce1-0bae0a7aa4dc:2 Local state: 00000000-0000-0000-0000-000000000000:-1 2020-04-07 9:37:50 2 [Note] [Debug] WSREP: server jan-HP-ZBook-15u-G5 state change: connected -> joiner 2020-04-07 9:37:50 2 [Note] WSREP: Server status change connected -> joiner 2020-04-07 9:37:50 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-04-07 9:37:50 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '127.0.0.2:16007' --datadir '/home/jan/mysql/10.5/mysql-test/var/mysqld.2/data/' --defaults-file '/home/jan/mysql/10.5/mysql-test/var/my.cnf' --defaults-group-suffix '.2' --parent '276508' --binlog-index 'mysqld-bin.index' --mysqld-args --defaults-group-suffix=.2 --defaults-file=/home/jan/mysql/10.5/mysql-test/var/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --enable-gdb --core-file --loose-debug-sync-timeout=300' 2020-04-07 9:37:50 0 [Note] WSREP: Joiner monitor thread started to monitor WSREP_SST: [INFO] Streaming with xbstream (20200407 09:37:50.949) WSREP_SST: [INFO] Using netcat as streamer (20200407 09:37:50.951) WSREP_SST: [INFO] Evaluating timeout -k 110 100 nc -dl 16007 | mbstream -x; RC=( ${PIPESTATUS[@]} ) (20200407 09:37:50.976) 2020-04-07 9:37:51 2 [Note] WSREP: Prepared SST request: mariabackup|127.0.0.2:16007/xtrabackup_sst//1 2020-04-07 9:37:51 2 [Note] WSREP: ####### IST uuid:00000000-0000-0000-0000-000000000000 f: 0, l: 2, STRv: 3 2020-04-07 9:37:51 2 [Note] WSREP: IST receiver addr using tcp://127.0.0.1:16006 2020-04-07 9:37:51 2 [Note] WSREP: Prepared IST receiver for 0-2, listening at: tcp://127.0.0.1:16006 2020-04-07 9:37:51 0 [Note] WSREP: Member 1.0 (jan-HP-ZBook-15u-G5) requested state transfer from '*any*'. Selected 0.0 (jan-HP-ZBook-15u-G5)(SYNCED) as donor. 2020-04-07 9:37:51 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 2) 2020-04-07 9:37:51 2 [Note] WSREP: Requesting state transfer: success, donor: 0 2020-04-07 9:37:51 2 [Note] WSREP: Resetting GCache seqno map due to different histories. 2020-04-07 9:37:51 2 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 4c4367d9-789a-11ea-8ce1-0bae0a7aa4dc:2 2020-04-07 9:37:52 0 [Note] WSREP: (4cbb2de5-9df3, 'tcp://0.0.0.0:16005') turning message relay requesting off 2020-04-07 9:38:20 0 [Note] WSREP: Joiner waited 30 sec, extending systemd startup timeout as SSTis not completed 2020-04-07 9:38:50 0 [Note] WSREP: Joiner waited 60 sec, extending systemd startup timeout as SSTis not completed 2020-04-07 9:39:20 0 [Note] WSREP: Joiner waited 90 sec, extending systemd startup timeout as SSTis not completed WSREP_SST: [ERROR] Possible timeout in receving first data from donor in gtid stage (20200407 09:39:30.986) WSREP_SST: [ERROR] Cleanup after exit with status:32 (20200407 09:39:30.994) 2020-04-07 9:39:31 0 [ERROR] WSREP: Process completed with error: wsrep_sst_mariabackup --role 'joiner' --address '127.0.0.2:16007' --datadir '/home/jan/mysql/10.5/mysql-test/var/mysqld.2/data/' --defaults-file '/home/jan/mysql/10.5/mysql-test/var/my.cnf' --defaults-group-suffix '.2' --parent '276508' --binlog-index 'mysqld-bin.index' --mysqld-args --defaults-group-suffix=.2 --defaults-file=/home/jan/mysql/10.5/mysql-test/var/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --enable-gdb --core-file --loose-debug-sync-timeout=300: 32 (Broken pipe) 2020-04-07 9:39:31 0 [ERROR] WSREP: Failed to read uuid:seqno and wsrep_gtid_domain_id from joiner script. 2020-04-07 9:39:31 3 [Note] WSREP: SST received 2020-04-07 9:39:31 3 [Note] WSREP: SST received: 00000000-0000-0000-0000-000000000000:-1 2020-04-07 9:39:31 0 [Note] WSREP: Joiner monitor thread ended with total time 101 sec 2020-04-07 9:39:31 2 [ERROR] WSREP: Application received wrong state: Received: 00000000-0000-0000-0000-000000000000 Required: 4c4367d9-789a-11ea-8ce1-0bae0a7aa4dc 2020-04-07 9:39:31 2 [ERROR] WSREP: Application state transfer failed. This is unrecoverable condition, restart required. 2020-04-07 9:39:31 2 [Note] WSREP: ReplicatorSMM::abort() 2020-04-07 9:39:31 2 [Note] WSREP: Closing send monitor... 2020-04-07 9:39:31 2 [Note] WSREP: Closed send monitor. 2020-04-07 9:39:31 2 [Note] WSREP: gcomm: terminating thread 2020-04-07 9:39:31 2 [Note] WSREP: gcomm: joining thread 2020-04-07 9:39:31 2 [Note] WSREP: gcomm: closing backend 2020-04-07 9:39:32 2 [Note] WSREP: view(view_id(NON_PRIM,4c42a1cb-9fb7,2) memb { 4cbb2de5-9df3,0 } joined { } left { } partitioned { 4c42a1cb-9fb7,0 }) 2020-04-07 9:39:32 2 [Note] WSREP: PC protocol downgrade 1 -> 0 2020-04-07 9:39:32 2 [Note] WSREP: view((empty)) 2020-04-07 9:39:32 2 [Note] WSREP: gcomm: closed 2020-04-07 9:39:32 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2020-04-07 9:39:32 0 [Note] WSREP: Flow-control interval: [16, 16] 2020-04-07 9:39:32 0 [Note] WSREP: Received NON-PRIMARY. 2020-04-07 9:39:32 0 [Note] WSREP: Shifting JOINER -> OPEN (TO: 2) 2020-04-07 9:39:32 0 [Note] WSREP: New SELF-LEAVE. 2020-04-07 9:39:32 0 [Note] WSREP: Flow-control interval: [0, 0] 2020-04-07 9:39:32 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2020-04-07 9:39:32 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: -1) 2020-04-07 9:39:32 0 [Note] WSREP: RECV thread exiting 0: Success 2020-04-07 9:39:32 2 [Note] WSREP: recv_thread() joined. 2020-04-07 9:39:32 2 [Note] WSREP: Closing replication queue. 2020-04-07 9:39:32 2 [Note] WSREP: Closing slave action queue. 2020-04-07 9:39:32 2 [Note] WSREP: /home/jan/mysql/10.5/sql/mariadbd: Terminated.