CURRENT_TEST: galera.galera_sst_mariabackup_encrypt_with_key_server 2021-04-15 11:43:01 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated 2021-04-15 11:43:01 0 [Note] /home/jan/mysql/10.6/sql/mariadbd (mysqld 10.6.0-MariaDB-debug-log) starting as process 1759545 ... 2021-04-15 11:43:01 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190) 2021-04-15 11:43:01 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000) 2021-04-15 11:43:01 0 [Note] WSREP: Server initial position: 00000000-0000-0000-0000-000000000000:-1 2021-04-15 11:43:01 0 [Note] WSREP: Loading provider /usr/lib/galera/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1 2021-04-15 11:43:01 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so' 2021-04-15 11:43:01 0 [Note] WSREP: wsrep_load(): Galera 26.4.8(r902dd268) by Codership Oy loaded successfully. 2021-04-15 11:43:01 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration. 2021-04-15 11:43:01 0 [Warning] WSREP: Could not open state file for reading: '/dev/shm/13/mysqld.2/data//grastate.dat' 2021-04-15 11:43:01 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1 2021-04-15 11:43:01 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 0 UUID: 00000000-0000-0000-0000-000000000000 Seqno: -1 - -1 Offset: -1 Synced: 0 2021-04-15 11:43:01 0 [Note] WSREP: Skipped GCache ring buffer recovery: could not determine history UUID. 2021-04-15 11:43:01 0 [Note] WSREP: Passing config to GCS: base_dir = /dev/shm/13/mysqld.2/data/; base_host = 127.0.0.1; base_port = 16305; 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 = PT30S; evs.install_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT10S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /dev/shm/13/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 = 128M; 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 = 0; gmcast.versi 2021-04-15 11:43:01 0 [Note] WSREP: SR storage init for: table 2021-04-15 11:43:01 0 [Note] WSREP: wsrep_start_replication 2021-04-15 11:43:01 0 [Note] WSREP: Start replication 2021-04-15 11:43:01 0 [Note] WSREP: Connecting with bootstrap option: 0 2021-04-15 11:43:01 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1 2021-04-15 11:43:01 0 [Note] WSREP: protonet asio version 0 2021-04-15 11:43:01 0 [Note] WSREP: Using CRC-32C for message checksums. 2021-04-15 11:43:01 0 [Note] WSREP: backend: asio 2021-04-15 11:43:01 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2021-04-15 11:43:01 0 [Warning] WSREP: access file(/dev/shm/13/mysqld.2/data//gvwstate.dat) failed(No such file or directory) 2021-04-15 11:43:01 0 [Note] WSREP: restore pc from disk failed 2021-04-15 11:43:01 0 [Note] WSREP: GMCast version 0 2021-04-15 11:43:01 0 [Note] WSREP: (964fa21d-828b, 'tcp://0.0.0.0:16305') listening at tcp://0.0.0.0:16305 2021-04-15 11:43:01 0 [Note] WSREP: (964fa21d-828b, 'tcp://0.0.0.0:16305') multicast: , ttl: 1 2021-04-15 11:43:01 0 [Note] WSREP: EVS version 1 2021-04-15 11:43:01 0 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '127.0.0.1:16302' 2021-04-15 11:43:01 0 [Note] WSREP: (964fa21d-828b, 'tcp://0.0.0.0:16305') connection established to 95755e0e-989a tcp://127.0.0.1:16302 2021-04-15 11:43:01 0 [Note] WSREP: (964fa21d-828b, 'tcp://0.0.0.0:16305') turning message relay requesting on, nonlive peers: 2021-04-15 11:43:02 0 [Note] WSREP: EVS version upgrade 0 -> 1 2021-04-15 11:43:02 0 [Note] WSREP: declaring 95755e0e-989a at tcp://127.0.0.1:16302 stable 2021-04-15 11:43:02 0 [Note] WSREP: PC protocol upgrade 0 -> 1 2021-04-15 11:43:02 0 [Note] WSREP: Node 95755e0e-989a state prim 2021-04-15 11:43:02 0 [Note] WSREP: view(view_id(PRIM,95755e0e-989a,2) memb { 95755e0e-989a,0 964fa21d-828b,0 } joined { } left { } partitioned { }) 2021-04-15 11:43:02 0 [Note] WSREP: save pc into disk 2021-04-15 11:43:02 0 [Note] WSREP: gcomm: connected 2021-04-15 11:43:02 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2021-04-15 11:43:02 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2021-04-15 11:43:02 0 [Note] WSREP: Opened channel 'my_wsrep_cluster' 2021-04-15 11:43:02 1 [Note] WSREP: wsrep system thread 1, 0x7f41480022b8 starting 2021-04-15 11:43:02 1 [Note] WSREP: Starting rollbacker thread 1 2021-04-15 11:43:02 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2 2021-04-15 11:43:02 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2021-04-15 11:43:02 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 969c8147-9dc6-11eb-9639-83607cd9455a 2021-04-15 11:43:02 0 [Note] WSREP: STATE EXCHANGE: got state msg: 969c8147-9dc6-11eb-9639-83607cd9455a from 0 (jan-HP-ZBook-15u-G5) 2021-04-15 11:43:02 0 [Note] WSREP: STATE EXCHANGE: got state msg: 969c8147-9dc6-11eb-9639-83607cd9455a from 1 (jan-HP-ZBook-15u-G5) 2021-04-15 11:43:02 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 = 95783726-9dc6-11eb-9349-8f2afd21bb26 2021-04-15 11:43:02 0 [Note] WSREP: Flow-control interval: [23, 23] 2021-04-15 11:43:02 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 2) 2021-04-15 11:43:02 2 [Note] WSREP: wsrep system thread 2, 0x7f4140000ff8 starting 2021-04-15 11:43:02 2 [Note] WSREP: Starting applier thread 2 2021-04-15 11:43:02 2 [Note] WSREP: ####### processing CC 2, local, ordered 2021-04-15 11:43:02 2 [Note] WSREP: Process first view: 95783726-9dc6-11eb-9349-8f2afd21bb26 my uuid: 964fa21d-9dc6-11eb-828b-d6e68b3f7534 2021-04-15 11:43:02 2 [Note] WSREP: Server jan-HP-ZBook-15u-G5 connected to cluster at position 95783726-9dc6-11eb-9349-8f2afd21bb26:2 with ID 964fa21d-9dc6-11eb-828b-d6e68b3f7534 2021-04-15 11:43:02 2 [Note] WSREP: server jan-HP-ZBook-15u-G5 state change: disconnected -> connected 2021-04-15 11:43:02 2 [Note] WSREP: Server status change disconnected -> connected 2021-04-15 11:43:02 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-04-15 11:43:02 2 [Note] WSREP: ####### My UUID: 964fa21d-9dc6-11eb-828b-d6e68b3f7534 2021-04-15 11:43:02 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes 2021-04-15 11:43:02 0 [Note] WSREP: Service thread queue flushed. 2021-04-15 11:43:02 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2021-04-15 11:43:02 2 [Note] WSREP: State transfer required: Group state: 95783726-9dc6-11eb-9349-8f2afd21bb26:2 Local state: 00000000-0000-0000-0000-000000000000:-1 2021-04-15 11:43:02 2 [Note] WSREP: server jan-HP-ZBook-15u-G5 state change: connected -> joiner 2021-04-15 11:43:02 2 [Note] WSREP: Server status change connected -> joiner 2021-04-15 11:43:02 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2021-04-15 11:43:02 0 [Note] WSREP: Joiner monitor thread started to monitor 2021-04-15 11:43:02 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '127.0.0.2:16307' --datadir '/dev/shm/13/mysqld.2/data/' --defaults-file '/dev/shm/13/my.cnf' --defaults-group-suffix '.2' --parent '1759545' --binlog-index 'mysqld-bin.index' --mysqld-args --defaults-group-suffix=.2 --defaults-file=/dev/shm/13/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 --core-file --loose-debug-sync-timeout=300' WSREP_SST: [INFO] SSL configuration: CA='/home/jan/mysql/10.6/mysql-test/std_data/cacert.pem', CERT='/home/jan/mysql/10.6/mysql-test/std_data/client-cert.pem', KEY='/home/jan/mysql/10.6/mysql-test/std_data/client-key.pem', MODE='VERIFY_CA', encrypt=3 (20210415 11:43:03.336) WSREP_SST: [INFO] Streaming with xbstream (20210415 11:43:04.636) WSREP_SST: [INFO] Using socat as streamer (20210415 11:43:04.676) WSREP_SST: [INFO] Using openssl based encryption with socat: with key and crt (20210415 11:43:04.744) WSREP_SST: [INFO] Decrypting with cert=/home/jan/mysql/10.6/mysql-test/std_data/client-cert.pem, key=/home/jan/mysql/10.6/mysql-test/std_data/client-key.pem, cafile=/home/jan/mysql/10.6/mysql-test/std_data/cacert.pem (20210415 11:43:04.756) 2021-04-15 11:43:05 0 [Note] WSREP: (964fa21d-828b, 'tcp://0.0.0.0:16305') turning message relay requesting off WSREP_SST: [INFO] Evaluating timeout -k 310 300 socat -u openssl-listen:16307,reuseaddr,cert=/home/jan/mysql/10.6/mysql-test/std_data/client-cert.pem,key=/home/jan/mysql/10.6/mysql-test/std_data/client-key.pem,cafile=/home/jan/mysql/10.6/mysql-test/std_data/cacert.pem stdio | mbstream -x; RC=( ${PIPESTATUS[@]} ) (20210415 11:43:05.262) 2021-04-15 11:43:05 2 [Note] WSREP: Prepared SST request: mariabackup|client:5839b1b6398dff4fa6fbdc70b6efc1d3@127.0.0.2:16307/xtrabackup_sst//1 2021-04-15 11:43:05 2 [Note] WSREP: ####### IST uuid:00000000-0000-0000-0000-000000000000 f: 0, l: 2, STRv: 3 2021-04-15 11:43:05 2 [Note] WSREP: IST receiver addr using tcp://127.0.0.1:16306 2021-04-15 11:43:05 2 [Note] WSREP: Prepared IST receiver for 0-2, listening at: tcp://127.0.0.1:16306 2021-04-15 11:43:05 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. 2021-04-15 11:43:05 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 2) 2021-04-15 11:43:05 2 [Note] WSREP: Requesting state transfer: success, donor: 0 2021-04-15 11:43:05 2 [Note] WSREP: Resetting GCache seqno map due to different histories. 2021-04-15 11:43:05 2 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 95783726-9dc6-11eb-9349-8f2afd21bb26:2 2021-04-15 11:43:08 0 [Warning] WSREP: 0.0 (jan-HP-ZBook-15u-G5): State transfer to 1.0 (jan-HP-ZBook-15u-G5) failed: -32 (Broken pipe) 2021-04-15 11:43:08 0 [ERROR] WSREP: /home/jan/mysql/mariadb-galeralib/gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():1170: Will never receive state. Need to abort. 2021-04-15 11:43:08 0 [Note] WSREP: gcomm: terminating thread 2021-04-15 11:43:08 0 [Note] WSREP: gcomm: joining thread 2021-04-15 11:43:08 0 [Note] WSREP: gcomm: closing backend 2021-04-15 11:43:09 0 [Note] WSREP: view(view_id(NON_PRIM,95755e0e-989a,2) memb { 964fa21d-828b,0 } joined { } left { } partitioned { 95755e0e-989a,0 }) 2021-04-15 11:43:09 0 [Note] WSREP: PC protocol downgrade 1 -> 0 2021-04-15 11:43:09 0 [Note] WSREP: view((empty)) 2021-04-15 11:43:09 0 [Note] WSREP: gcomm: closed 2021-04-15 11:43:09 0 [Note] WSREP: /home/jan/mysql/10.6/sql/mariadbd: Terminated. WSREP_SST: [ERROR] Possible timeout in receiving first data from donor in gtid stage: exit codes: 124 0 (20210415 11:48:05.274) WSREP_SST: [ERROR] Cleanup after exit with status:32 (20210415 11:48:05.280)