2020-02-06 12:00:00 0 [Note] Using unique option prefix 'core' is error-prone and can break in the future. Please use the full name 'core-file' instead. 2020-02-06 12:00:00 0 [Note] /home/stepan/ment/10.5/sql/mysqld (mysqld 10.5.1-MariaDB-debug-log) starting as process 13985 ... 2020-02-06 12:00:00 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4186) 2020-02-06 12:00:00 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000) 2020-02-06 12:00:00 0 [Note] WSREP: Loading provider /usr/lib/libgalera_enterprise_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1 wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib/libgalera_enterprise_smm.so' wsrep loader: [INFO] wsrep_load(): Galera 26.4.4(r4774) by Codership Oy loaded successfully. 2020-02-06 12:00:00 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2020-02-06 12:00:00 0 [Warning] WSREP: Could not open state file for reading: '/home/stepan/rqg/var/node2/data//grastate.dat' 2020-02-06 12:00:00 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1 2020-02-06 12:00:00 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 0 UUID: 00000000-0000-0000-0000-000000000000 Seqno: -1 - -1 Offset: -1 Synced: 0 2020-02-06 12:00:00 0 [Note] WSREP: Skipped GCache ring buffer recovery: could not determine history UUID. 2020-02-06 12:00:00 0 [Note] WSREP: Passing config to GCS: base_dir = /home/stepan/rqg/var/node2/data/; base_host = 192.168.106.31; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; 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 = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.debug = 0; gcache.dir = /home/stepan/rqg/var/node2/data/; gcache.keep_pages_size = 0; gcache.keep_plaintext_size = 128M; 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.s 2020-02-06 12:00:00 0 [Note] WSREP: Start replication 2020-02-06 12:00:00 0 [Note] WSREP: Connecting with bootstrap option: 0 2020-02-06 12:00:00 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1 2020-02-06 12:00:00 0 [Note] WSREP: protonet asio version 0 2020-02-06 12:00:00 0 [Note] WSREP: Using CRC-32C for message checksums. 2020-02-06 12:00:00 0 [Note] WSREP: backend: asio 2020-02-06 12:00:00 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2020-02-06 12:00:00 0 [Warning] WSREP: access file(/home/stepan/rqg/var/node2/data//gvwstate.dat) failed(No such file or directory) 2020-02-06 12:00:00 0 [Note] WSREP: restore pc from disk failed 2020-02-06 12:00:00 0 [Note] WSREP: GMCast version 0 2020-02-06 12:00:00 0 [Note] WSREP: (7026dfc8-9b76, 'tcp://127.0.0.1:4802') listening at tcp://127.0.0.1:4802 2020-02-06 12:00:00 0 [Note] WSREP: (7026dfc8-9b76, 'tcp://127.0.0.1:4802') multicast: , ttl: 1 2020-02-06 12:00:00 0 [Note] WSREP: EVS version 1 2020-02-06 12:00:00 0 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '127.0.0.1:4800' 2020-02-06 12:00:00 0 [Note] WSREP: (7026dfc8-9b76, 'tcp://127.0.0.1:4802') connection established to 6747ff9c-a2d2 tcp://127.0.0.1:4800 2020-02-06 12:00:00 0 [Note] WSREP: (7026dfc8-9b76, 'tcp://127.0.0.1:4802') turning message relay requesting on, nonlive peers: tcp://127.0.0.1:4801 2020-02-06 12:00:00 0 [Note] WSREP: (7026dfc8-9b76, 'tcp://127.0.0.1:4802') connection established to 67bcc51c-bea9 tcp://127.0.0.1:4801 2020-02-06 12:00:01 0 [Note] WSREP: EVS version upgrade 0 -> 1 2020-02-06 12:00:01 0 [Note] WSREP: declaring 6747ff9c-a2d2 at tcp://127.0.0.1:4800 stable 2020-02-06 12:00:01 0 [Note] WSREP: declaring 67bcc51c-bea9 at tcp://127.0.0.1:4801 stable 2020-02-06 12:00:01 0 [Note] WSREP: PC protocol upgrade 0 -> 1 2020-02-06 12:00:01 0 [Note] WSREP: Node 6747ff9c-a2d2 state prim 2020-02-06 12:00:01 0 [Note] WSREP: view(view_id(PRIM,6747ff9c-a2d2,3) memb { 6747ff9c-a2d2,0 67bcc51c-bea9,0 7026dfc8-9b76,0 } joined { } left { } partitioned { }) 2020-02-06 12:00:01 0 [Note] WSREP: save pc into disk 2020-02-06 12:00:01 0 [Note] WSREP: gcomm: connected 2020-02-06 12:00:01 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2020-02-06 12:00:01 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2020-02-06 12:00:01 0 [Note] WSREP: Opened channel 'my_wsrep_cluster' 2020-02-06 12:00:01 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3 2020-02-06 12:00:01 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2020-02-06 12:00:01 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 707438cc-48c7-11ea-8c1c-0738eee515dd 2020-02-06 12:00:01 0 [Note] WSREP: STATE EXCHANGE: got state msg: 707438cc-48c7-11ea-8c1c-0738eee515dd from 0 (cnt7glr11.localdomain) 2020-02-06 12:00:01 0 [Note] WSREP: STATE EXCHANGE: got state msg: 707438cc-48c7-11ea-8c1c-0738eee515dd from 1 (cnt7glr11.localdomain) 2020-02-06 12:00:01 0 [Note] WSREP: STATE EXCHANGE: got state msg: 707438cc-48c7-11ea-8c1c-0738eee515dd from 2 (cnt7glr11.localdomain) 2020-02-06 12:00:01 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 2, members = 2/3 (joined/total), act_id = 2, last_appl. = 0, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 674921f6-48c7-11ea-b9a9-4a0630e482fa 2020-02-06 12:00:01 0 [Note] WSREP: Flow-control interval: [28, 28] 2020-02-06 12:00:01 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 3) 2020-02-06 12:00:01 1 [Note] WSREP: Starting rollbacker thread 1 2020-02-06 12:00:01 2 [Note] WSREP: Starting applier thread 2 2020-02-06 12:00:01 2 [Note] WSREP: ####### processing CC 3, local, ordered 2020-02-06 12:00:01 2 [Note] WSREP: Process first view: 674921f6-48c7-11ea-b9a9-4a0630e482fa my uuid: 7026dfc8-48c7-11ea-9b76-a2081454d67c 2020-02-06 12:00:01 2 [Note] WSREP: Server cnt7glr11.localdomain connected to cluster at position 674921f6-48c7-11ea-b9a9-4a0630e482fa:3 with ID 7026dfc8-48c7-11ea-9b76-a2081454d67c 2020-02-06 12:00:01 2 [Note] WSREP: Server status change disconnected -> connected 2020-02-06 12:00:01 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-02-06 12:00:01 2 [Note] WSREP: ####### My UUID: 7026dfc8-48c7-11ea-9b76-a2081454d67c 2020-02-06 12:00:01 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes 2020-02-06 12:00:01 0 [Note] WSREP: Service thread queue flushed. 2020-02-06 12:00:01 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2020-02-06 12:00:01 2 [Note] WSREP: State transfer required: Group state: 674921f6-48c7-11ea-b9a9-4a0630e482fa:3 Local state: 00000000-0000-0000-0000-000000000000:-1 2020-02-06 12:00:01 2 [Note] WSREP: Server status change connected -> joiner 2020-02-06 12:00:01 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-02-06 12:00:01 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '192.168.106.31' --datadir '/home/stepan/rqg/var/node2/data/' --parent '13985' --mysqld-args --no-defaults --basedir=/home/stepan/ment/10.5 --lc-messages-dir=/home/stepan/ment/10.5/sql/share --character-sets-dir=/home/stepan/ment/10.5/sql/share/charsets --tmpdir=/home/stepan/rqg/var/node2/tmp --core-file --datadir=/home/stepan/rqg/var/node2/data --max-allowed-packet=128Mb --port=19302 --socket=/home/stepan/rqg/var/node2/mysql.sock --pid-file=/home/stepan/rqg/var/node2/mysql.pid --general-log --general-log-file=/home/stepan/rqg/var/node2/mysql.log --wsrep_on=ON --wsrep_sst_method=rsync --innodb_autoinc_lock_mode=2 --default-storage-engine=InnoDB --binlog-format=row --wsrep_cluster_address=gcomm://127.0.0.1:4800?gmcast.listen_addr=tcp://127.0.0.1:4802 --wsrep-provider=/usr/lib/libgalera_enterprise_smm.so --wsrep_sst_method=rsync --core --general-log --general-log-file=queries.log --log-output=file --wsrep-debug=none --wsrep-sync-wait=15 --wsrep_retry_a 2020-02-06 12:00:01 2 [Note] WSREP: Prepared SST request: rsync|192.168.106.31:4444/rsync_sst 2020-02-06 12:00:01 2 [Note] WSREP: App waits SST: 1 2020-02-06 12:00:01 2 [Note] WSREP: ####### IST uuid:00000000-0000-0000-0000-000000000000 f: 0, l: 3, STRv: 3 2020-02-06 12:00:01 2 [Note] WSREP: IST receiver addr using tcp://192.168.106.31:4803 2020-02-06 12:00:01 2 [Note] WSREP: Prepared IST receiver for 0-3, listening at: tcp://192.168.106.31:4803 2020-02-06 12:00:01 0 [Note] WSREP: Member 2.0 (cnt7glr11.localdomain) requested state transfer from '*any*'. Selected 0.0 (cnt7glr11.localdomain)(SYNCED) as donor. 2020-02-06 12:00:01 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 3) 2020-02-06 12:00:01 2 [Note] WSREP: Requesting state transfer: success, donor: 0 2020-02-06 12:00:01 2 [Note] WSREP: Resetting GCache seqno map due to different histories. 2020-02-06 12:00:01 2 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 674921f6-48c7-11ea-b9a9-4a0630e482fa:3 2020-02-06 12:00:04 0 [Note] WSREP: (7026dfc8-9b76, 'tcp://127.0.0.1:4802') turning message relay requesting off 2020-02-06 12:00:12 0 [Note] WSREP: 0.0 (cnt7glr11.localdomain): State transfer to 2.0 (cnt7glr11.localdomain) complete. 2020-02-06 12:00:12 0 [Note] WSREP: Member 0.0 (cnt7glr11.localdomain) synced with group. WSREP_SST: [INFO] Joiner cleanup. rsync PID: 14133 (20200206 12:00:13.012) WSREP_SST: [INFO] Joiner cleanup done. (20200206 12:00:13.519) 2020-02-06 12:00:13 3 [Note] WSREP: SST received 2020-02-06 12:00:13 3 [Note] WSREP: Server status change joiner -> initializing 2020-02-06 12:00:13 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-02-06 12:00:13 0 [Note] InnoDB: Using Linux native AIO 2020-02-06 12:00:13 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2020-02-06 12:00:13 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-02-06 12:00:13 0 [Note] InnoDB: Uses event mutexes 2020-02-06 12:00:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2020-02-06 12:00:13 0 [Note] InnoDB: Number of pools: 1 2020-02-06 12:00:13 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-02-06 12:00:13 0 [Note] mysqld: O_TMPFILE is not supported on /home/stepan/rqg/var/node2/tmp (disabling future attempts) 2020-02-06 12:00:13 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-02-06 12:00:13 0 [Note] InnoDB: Completed initialization of buffer pool 2020-02-06 12:00:13 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-02-06 12:00:13 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=98258 2020-02-06 12:00:13 0 [Note] InnoDB: Starting final batch to recover 4 pages from redo log. 2020-02-06 12:00:14 0 [Note] InnoDB: 128 rollback segments are active. 2020-02-06 12:00:14 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-02-06 12:00:14 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-02-06 12:00:14 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-02-06 12:00:14 0 [Note] InnoDB: 10.5.1 started; log sequence number 98426; transaction id 102 2020-02-06 12:00:14 0 [Note] InnoDB: Loading buffer pool(s) from /home/stepan/rqg/var/node2/data/ib_buffer_pool 2020-02-06 12:00:14 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-02-06 12:00:14 0 [Note] Zerofilling moved table: './mysql/plugin' 2020-02-06 12:00:14 0 [Note] InnoDB: Buffer pool(s) load completed at 200206 12:00:14 2020-02-06 12:00:14 0 [Note] Zerofilling moved table: './mysql/servers' 2020-02-06 12:00:14 0 [Note] Server socket created on IP: '::'. 2020-02-06 12:00:14 0 [Note] Zerofilling moved table: './mysql/db' 2020-02-06 12:00:14 0 [Note] Zerofilling moved table: './mysql/proxies_priv' 2020-02-06 12:00:14 0 [Note] Zerofilling moved table: './mysql/roles_mapping' 2020-02-06 12:00:14 0 [Note] Zerofilling moved table: './mysql/global_priv' 2020-02-06 12:00:14 0 [Note] Zerofilling moved table: './mysql/time_zone_leap_second' 2020-02-06 12:00:14 0 [Note] Zerofilling moved table: './mysql/time_zone_name' 2020-02-06 12:00:14 0 [Note] Zerofilling moved table: './mysql/time_zone' 2020-02-06 12:00:14 0 [Note] Zerofilling moved table: './mysql/time_zone_transition_type' 2020-02-06 12:00:14 0 [Note] Zerofilling moved table: './mysql/time_zone_transition' 2020-02-06 12:00:14 0 [Note] Zerofilling moved table: './mysql/tables_priv' 2020-02-06 12:00:14 0 [Note] Zerofilling moved table: './mysql/columns_priv' 2020-02-06 12:00:14 0 [Note] Zerofilling moved table: './mysql/procs_priv' 2020-02-06 12:00:14 0 [Note] Zerofilling moved table: './mysql/func' 2020-02-06 12:00:14 0 [Note] Zerofilling moved table: './mysql/event' 2020-02-06 12:00:14 0 [Note] WSREP: wsrep_init_schema_and_SR 0x0 2020-02-06 12:00:14 0 [Note] WSREP: Server initialized 2020-02-06 12:00:14 0 [Note] WSREP: Server status change initializing -> initialized 2020-02-06 12:00:14 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-02-06 12:00:14 3 [Note] WSREP: Server status change initialized -> joined 2020-02-06 12:00:14 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-02-06 12:00:14 3 [Note] WSREP: Recovered position from storage: 674921f6-48c7-11ea-b9a9-4a0630e482fa:3 2020-02-06 12:00:14 3 [Note] WSREP: Recovered view from SST: id: 674921f6-48c7-11ea-b9a9-4a0630e482fa:3 status: primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 2 members(3): 0: 6747ff9c-48c7-11ea-a2d2-6ee13cc9cdf6, cnt7glr11.localdomain 1: 67bcc51c-48c7-11ea-bea9-f3446d571687, cnt7glr11.localdomain 2: 7026dfc8-48c7-11ea-9b76-a2081454d67c, cnt7glr11.localdomain 2020-02-06 12:00:14 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-02-06 12:00:14 6 [Note] WSREP: Recovered cluster id 674921f6-48c7-11ea-b9a9-4a0630e482fa 2020-02-06 12:00:14 0 [Note] Reading of all Master_info entries succeeded 2020-02-06 12:00:14 0 [Note] Added new Master_info '' to hash table 2020-02-06 12:00:14 0 [Note] /home/stepan/ment/10.5/sql/mysqld: ready for connections. Version: '10.5.1-MariaDB-debug-log' socket: '/home/stepan/rqg/var/node2/mysql.sock' port: 19302 Source distribution 2020-02-06 12:00:14 3 [Note] WSREP: SST received: 674921f6-48c7-11ea-b9a9-4a0630e482fa:3 2020-02-06 12:00:14 2 [Note] WSREP: Installed new state from SST: 674921f6-48c7-11ea-b9a9-4a0630e482fa:3 2020-02-06 12:00:14 2 [Note] WSREP: Cert. index preload up to 3 2020-02-06 12:00:14 0 [Note] WSREP: ####### IST applying starts with 4 2020-02-06 12:00:14 0 [Note] WSREP: ####### IST current seqno initialized to 3 2020-02-06 12:00:14 0 [Note] WSREP: Receiving IST... 0.0% (0/1 events) complete. 2020-02-06 12:00:14 0 [Note] WSREP: IST preload starting at 3 2020-02-06 12:00:14 0 [Note] WSREP: REPL Protocols: 10 (5) 2020-02-06 12:00:14 0 [Note] WSREP: Service thread queue flushed. 2020-02-06 12:00:14 0 [Note] WSREP: ####### Assign initial position for certification: 674921f6-48c7-11ea-b9a9-4a0630e482fa:2, protocol version: 5 2020-02-06 12:00:14 0 [Note] WSREP: REPL Protocols: 10 (5) 2020-02-06 12:00:14 0 [Note] WSREP: ####### Adjusting cert position: 2 -> 3 2020-02-06 12:00:14 0 [Note] WSREP: Service thread queue flushed. 2020-02-06 12:00:14 0 [Note] WSREP: Lowest cert indnex boundary for CC from preload: 3 2020-02-06 12:00:14 0 [Note] WSREP: Min available from gcache for CC from preload: 3 2020-02-06 12:00:14 0 [Note] WSREP: Receiving IST...100.0% (1/1 events) complete. 2020-02-06 12:00:14 2 [Note] WSREP: IST received: 674921f6-48c7-11ea-b9a9-4a0630e482fa:3 2020-02-06 12:00:14 2 [Note] WSREP: Lowest cert indnex boundary for CC from sst: 3 2020-02-06 12:00:14 2 [Note] WSREP: Min available from gcache for CC from sst: 3 2020-02-06 12:00:14 0 [Note] WSREP: 2.0 (cnt7glr11.localdomain): State transfer from 0.0 (cnt7glr11.localdomain) complete. 2020-02-06 12:00:14 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 3) 2020-02-06 12:00:14 0 [Note] WSREP: Member 2.0 (cnt7glr11.localdomain) synced with group. 2020-02-06 12:00:14 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3) 2020-02-06 12:00:14 2 [Note] WSREP: Server cnt7glr11.localdomain synced with group 2020-02-06 12:00:14 2 [Note] WSREP: Server status change joined -> synced 2020-02-06 12:00:14 2 [Note] WSREP: Synchronized with group, ready for connections 2020-02-06 12:00:14 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-02-06 12:01:40 2 [ERROR] Slave SQL: Could not execute Write_rows_v1 event on table test.table10000_innodb_int; Duplicate entry '0' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 272, Internal MariaDB error code: 1062 2020-02-06 12:01:40 2 [Warning] WSREP: Event 3 Write_rows_v1 apply failed: 121, seqno 240 2020-02-06 12:01:40 0 [Note] WSREP: Member 2(cnt7glr11.localdomain) initiates vote on 674921f6-48c7-11ea-b9a9-4a0630e482fa:240,fdcab7194c6d731e: Duplicate entry '0' for key 'PRIMARY', Error_code: 1062; 2020-02-06 12:01:40 0 [Note] WSREP: Votes over 674921f6-48c7-11ea-b9a9-4a0630e482fa:240: fdcab7194c6d731e: 1/3 Waiting for more votes. 2020-02-06 12:01:40 0 [Note] WSREP: Member 1(cnt7glr11.localdomain) initiates vote on 674921f6-48c7-11ea-b9a9-4a0630e482fa:240,fdcab7194c6d731e: Duplicate entry '0' for key 'PRIMARY', Error_code: 1062; 2020-02-06 12:01:40 0 [Note] WSREP: Votes over 674921f6-48c7-11ea-b9a9-4a0630e482fa:240: fdcab7194c6d731e: 2/3 Winner: fdcab7194c6d731e 2020-02-06 12:01:40 0 [Note] WSREP: declaring 67bcc51c-bea9 at tcp://127.0.0.1:4801 stable 2020-02-06 12:01:40 0 [Note] WSREP: forgetting 6747ff9c-a2d2 (tcp://127.0.0.1:4800) 2020-02-06 12:01:40 0 [Note] WSREP: Node 67bcc51c-bea9 state prim 2020-02-06 12:01:40 0 [Note] WSREP: view(view_id(PRIM,67bcc51c-bea9,4) memb { 67bcc51c-bea9,0 7026dfc8-9b76,0 } joined { } left { } partitioned { 6747ff9c-a2d2,0 }) 2020-02-06 12:01:40 0 [Note] WSREP: save pc into disk 2020-02-06 12:01:40 0 [Note] WSREP: forgetting 6747ff9c-a2d2 (tcp://127.0.0.1:4800) 2020-02-06 12:01:40 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2 2020-02-06 12:01:40 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2020-02-06 12:01:40 0 [Note] WSREP: STATE EXCHANGE: sent state msg: abdbe031-48c7-11ea-8475-828fefa02a10 2020-02-06 12:01:40 0 [Note] WSREP: STATE EXCHANGE: got state msg: abdbe031-48c7-11ea-8475-828fefa02a10 from 0 (cnt7glr11.localdomain) 2020-02-06 12:01:40 0 [Note] WSREP: STATE EXCHANGE: got state msg: abdbe031-48c7-11ea-8475-828fefa02a10 from 1 (cnt7glr11.localdomain) 2020-02-06 12:01:40 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 3, members = 2/2 (joined/total), act_id = 240, last_appl. = 187, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 674921f6-48c7-11ea-b9a9-4a0630e482fa 2020-02-06 12:01:40 0 [Note] WSREP: Flow-control interval: [23, 23] 2020-02-06 12:01:40 2 [Note] WSREP: ####### processing CC 241, local, ordered 2020-02-06 12:01:40 2 [Note] WSREP: ####### My UUID: 7026dfc8-48c7-11ea-9b76-a2081454d67c 2020-02-06 12:01:40 2 [Note] WSREP: Skipping cert index reset 2020-02-06 12:01:40 2 [Note] WSREP: REPL Protocols: 10 (5) 2020-02-06 12:01:40 2 [Note] WSREP: ####### Adjusting cert position: 240 -> 241 2020-02-06 12:01:40 0 [Note] WSREP: Service thread queue flushed. 2020-02-06 12:01:40 2 [Note] WSREP: ================================================ View: id: 674921f6-48c7-11ea-b9a9-4a0630e482fa:241 status: primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 1 members(2): 0: 67bcc51c-48c7-11ea-bea9-f3446d571687, cnt7glr11.localdomain 1: 7026dfc8-48c7-11ea-9b76-a2081454d67c, cnt7glr11.localdomain ================================================= 2020-02-06 12:01:40 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-02-06 12:01:40 2 [Note] WSREP: Lowest cert indnex boundary for CC from group: 188 2020-02-06 12:01:40 2 [Note] WSREP: Min available from gcache for CC from group: 3 2020-02-06 12:01:46 0 [Note] WSREP: cleaning up 6747ff9c-a2d2 (tcp://127.0.0.1:4800) 2020-02-06 12:06:20 0 [Note] WSREP: forgetting 67bcc51c-bea9 (tcp://127.0.0.1:4801) 2020-02-06 12:06:20 0 [Note] WSREP: Node 7026dfc8-9b76 state prim 2020-02-06 12:06:20 0 [Note] WSREP: view(view_id(PRIM,7026dfc8-9b76,5) memb { 7026dfc8-9b76,0 } joined { } left { } partitioned { 67bcc51c-bea9,0 }) 2020-02-06 12:06:20 0 [Note] WSREP: save pc into disk 2020-02-06 12:06:20 0 [Note] WSREP: forgetting 67bcc51c-bea9 (tcp://127.0.0.1:4801) 2020-02-06 12:06:20 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 2020-02-06 12:06:20 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 52be5195-48c8-11ea-ab33-8723b90aec6a 2020-02-06 12:06:20 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 52be5195-48c8-11ea-ab33-8723b90aec6a 2020-02-06 12:06:20 0 [Note] WSREP: STATE EXCHANGE: got state msg: 52be5195-48c8-11ea-ab33-8723b90aec6a from 0 (cnt7glr11.localdomain) 2020-02-06 12:06:20 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 4, members = 1/1 (joined/total), act_id = 241, last_appl. = 187, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 674921f6-48c7-11ea-b9a9-4a0630e482fa 2020-02-06 12:06:20 0 [Note] WSREP: Flow-control interval: [16, 16] 2020-02-06 12:06:20 2 [Note] WSREP: ####### processing CC 242, local, ordered 2020-02-06 12:06:20 2 [Note] WSREP: ####### My UUID: 7026dfc8-48c7-11ea-9b76-a2081454d67c 2020-02-06 12:06:20 2 [Note] WSREP: Skipping cert index reset 2020-02-06 12:06:20 2 [Note] WSREP: REPL Protocols: 10 (5) 2020-02-06 12:06:20 2 [Note] WSREP: ####### Adjusting cert position: 241 -> 242 2020-02-06 12:06:20 0 [Note] WSREP: Service thread queue flushed. 2020-02-06 12:06:20 2 [Note] WSREP: ================================================ View: id: 674921f6-48c7-11ea-b9a9-4a0630e482fa:242 status: primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 0 members(1): 0: 7026dfc8-48c7-11ea-9b76-a2081454d67c, cnt7glr11.localdomain ================================================= 2020-02-06 12:06:20 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-02-06 12:06:20 2 [Note] WSREP: Lowest cert indnex boundary for CC from group: 188 2020-02-06 12:06:20 2 [Note] WSREP: Min available from gcache for CC from group: 3 2020-02-06 12:06:21 0 [Note] /home/stepan/ment/10.5/sql/mysqld (initiated by: [stepan] @ localhost [127.0.0.1]): Normal shutdown 2020-02-06 12:06:21 0 [Note] WSREP: Shutdown replication 2020-02-06 12:06:21 0 [Note] WSREP: Server status change synced -> disconnecting 2020-02-06 12:06:21 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-02-06 12:06:21 0 [Note] WSREP: Closing send monitor... 2020-02-06 12:06:21 0 [Note] WSREP: Closed send monitor. 2020-02-06 12:06:21 0 [Note] WSREP: gcomm: terminating thread 2020-02-06 12:06:21 0 [Note] WSREP: gcomm: joining thread 2020-02-06 12:06:21 0 [Note] WSREP: gcomm: closing backend 2020-02-06 12:06:21 0 [Note] WSREP: PC protocol downgrade 1 -> 0 2020-02-06 12:06:21 0 [Note] WSREP: view((empty)) 2020-02-06 12:06:21 0 [Note] WSREP: gcomm: closed 2020-02-06 12:06:21 0 [Note] WSREP: New SELF-LEAVE. 2020-02-06 12:06:21 0 [Note] WSREP: Flow-control interval: [0, 0] 2020-02-06 12:06:21 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2020-02-06 12:06:21 0 [Note] WSREP: Shifting SYNCED -> CLOSED (TO: 242) 2020-02-06 12:06:21 0 [Note] WSREP: RECV thread exiting 0: Success 2020-02-06 12:06:21 2 [Note] WSREP: ================================================ View: id: 674921f6-48c7-11ea-b9a9-4a0630e482fa:-1 status: non-primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: yes own_index: -1 members(0): ================================================= 2020-02-06 12:06:21 2 [Note] WSREP: Non-primary view 2020-02-06 12:06:21 2 [Note] WSREP: Server status change disconnecting -> disconnected 2020-02-06 12:06:21 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-02-06 12:06:21 0 [Note] WSREP: recv_thread() joined. 2020-02-06 12:06:21 0 [Note] WSREP: Closing replication queue. 2020-02-06 12:06:21 0 [Note] WSREP: Closing slave action queue. 2020-02-06 12:06:21 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-02-06 12:06:21 2 [Note] WSREP: Applier thread exiting ret: 0 thd: 2 2020-02-06 12:06:21 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-02-06 12:06:21 1 [Note] WSREP: rollbacker thread exiting 1 2020-02-06 12:06:21 1 [Warning] Aborted connection 1 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-02-06 12:06:21 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-02-06 12:06:21 0 [Note] WSREP: dtor state: CLOSED 2020-02-06 12:06:21 0 [Note] WSREP: MemPool(TrxHandleSlave): hit ratio: 0.708861, misses: 69, in use: 53, in pool: 16 2020-02-06 12:06:21 0 [Note] WSREP: mon: entered 237 oooe fraction 0 oool fraction 0 2020-02-06 12:06:21 0 [Note] WSREP: mon: entered 237 oooe fraction 0 oool fraction 0 2020-02-06 12:06:21 0 [Note] WSREP: mon: entered 251 oooe fraction 0 oool fraction 0.00398406 2020-02-06 12:06:21 0 [Note] WSREP: cert index usage at exit 330 2020-02-06 12:06:21 0 [Note] WSREP: cert trx map usage at exit 53 2020-02-06 12:06:21 0 [Note] WSREP: deps set usage at exit 0 2020-02-06 12:06:21 0 [Note] WSREP: avg deps dist 12.2025 2020-02-06 12:06:21 0 [Note] WSREP: avg cert interval 0.0759494 2020-02-06 12:06:21 0 [Note] WSREP: cert index size 330 2020-02-06 12:06:21 0 [Note] WSREP: Service thread queue flushed. 2020-02-06 12:06:21 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0 2020-02-06 12:06:21 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0 2020-02-06 12:06:21 0 [Note] WSREP: trx map: conn query map: 2020-02-06 12:06:21 0 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 242) 2020-02-06 12:06:21 0 [Note] WSREP: Flushing memory map to disk... 2020-02-06 12:06:21 0 [Note] InnoDB: FTS optimize thread exiting. 2020-02-06 12:06:21 0 [Note] InnoDB: Starting shutdown... 2020-02-06 12:06:21 0 [Note] InnoDB: Dumping buffer pool(s) to /home/stepan/rqg/var/node2/data/ib_buffer_pool 2020-02-06 12:06:21 0 [Note] InnoDB: Buffer pool(s) dump completed at 200206 12:06:21 2020-02-06 12:06:22 0 [Note] InnoDB: Shutdown completed; log sequence number 16271656; transaction id 914 2020-02-06 12:06:22 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-02-06 12:06:22 0 [Note] /home/stepan/ment/10.5/sql/mysqld: Shutdown complete