2021-10-26 23:13:50 0 [Note] WSREP: (0746a5a8-8bed, 'tcp://0.0.0.0:4567') turning message relay requesting off

2021-10-29 12:26:02 0 [Note] WSREP: Loading provider /usr/lib/galera/libgalera_smm.so initial position: 14f297ea-1f16-11ec-b897-f70abf8de811:7136480
2021-10-29 12:26:02 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
2021-10-29 12:26:02 0 [Note] WSREP: wsrep_load(): Galera 26.4.9(r819f29cb) by Codership Oy <info@codership.com> loaded successfully.
2021-10-29 12:26:02 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2021-10-29 12:26:02 0 [Note] WSREP: Found saved state: 14f297ea-1f16-11ec-b897-f70abf8de811:-1, safe_to_bootstrap: 0
2021-10-29 12:26:02 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 2
UUID: 14f297ea-1f16-11ec-b897-f70abf8de811
Seqno: -1 - -1
Offset: -1
Synced: 0
2021-10-29 12:26:02 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 14f297ea-1f16-11ec-b897-f70abf8de811, offset: -1
2021-10-29 12:26:02 0 [Note] WSREP: GCache::RingBuffer initial scan...  0.0% (        0/134217752 bytes) complete.
2021-10-29 12:26:03 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete.
2021-10-29 12:26:03 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 7118167-7136480
2021-10-29 12:26:03 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...  0.0% (        0/134188528 bytes) complete.
2021-10-29 12:26:03 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (134188528/134188528 bytes) complete.
2021-10-29 12:26:03 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 0/18314 locked buffers
2021-10-29 12:26:03 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): free space: 29200/134217728
2021-10-29 12:26:03 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = ###ataps-node2--IP-ADDR###; base_port = 4567; 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.inac>
2021-10-29 12:26:03 0 [Note] WSREP: Service thread queue flushed.
2021-10-29 12:26:03 0 [Note] WSREP: ####### Assign initial position for certification: 14f297ea-1f16-11ec-b897-f70abf8de811:7136480, protocol version: -1
2021-10-29 12:26:03 0 [Note] WSREP: Start replication
2021-10-29 12:26:03 0 [Note] WSREP: Connecting with bootstrap option: 0
2021-10-29 12:26:03 0 [Note] WSREP: Setting GCS initial position to 14f297ea-1f16-11ec-b897-f70abf8de811:7136480
2021-10-29 12:26:03 0 [Note] WSREP: protonet asio version 0
2021-10-29 12:26:03 0 [Note] WSREP: Using CRC-32C for message checksums.
2021-10-29 12:26:03 0 [Note] WSREP: backend: asio
2021-10-29 12:26:03 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2021-10-29 12:26:03 0 [Note] WSREP: restore pc from disk successfully
2021-10-29 12:26:03 0 [Note] WSREP: GMCast version 0
2021-10-29 12:26:03 0 [Note] WSREP: (0746a5a8-8bee, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2021-10-29 12:26:03 0 [Note] WSREP: (0746a5a8-8bee, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2021-10-29 12:26:03 0 [Note] WSREP: EVS version 1
2021-10-29 12:26:03 0 [Note] WSREP: gcomm: connecting to group 'AtapsDBCluster', peer 'ataps-node1:,ataps-node2:,ataps-node3:'
2021-10-29 12:26:03 0 [Note] WSREP: (0746a5a8-8bee, 'tcp://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address tcp://127.0.1.1:4567
2021-10-29 12:26:03 0 [Note] WSREP: (0746a5a8-8bee, 'tcp://0.0.0.0:4567') connection established to f4996e99-bbbd tcp://###ataps-node1--IP-ADDR###9:4567
2021-10-29 12:26:03 0 [Note] WSREP: (0746a5a8-8bee, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
2021-10-29 12:26:03 0 [Note] WSREP: (0746a5a8-8bee, 'tcp://0.0.0.0:4567') connection established to 3a343e75-bfbc tcp://###ataps-node3--IP-ADDR###:4567
2021-10-29 12:26:03 0 [Note] WSREP: gcomm: connected
2021-10-29 12:26:03 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2021-10-29 12:26:03 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2021-10-29 12:26:03 0 [Note] WSREP: Opened channel 'AtapsDBCluster'
2021-10-29 12:26:03 1 [Note] WSREP: Starting rollbacker thread 1
2021-10-29 12:26:03 2 [Note] WSREP: Starting applier thread 2
2021-10-29 12:26:04 0 [Note] WSREP: EVS version upgrade 0 -> 1
2021-10-29 12:26:04 0 [Note] WSREP: declaring 3a343e75-bfbc at tcp://###ataps-node3--IP-ADDR###:4567 stable
2021-10-29 12:26:04 0 [Note] WSREP: declaring f4996e99-bbbd at tcp://###ataps-node1--IP-ADDR###9:4567 stable
2021-10-29 12:26:04 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2021-10-29 12:26:04 0 [Note] WSREP: Node 3a343e75-bfbc state prim
2021-10-29 12:26:04 0 [Note] WSREP: view(view_id(PRIM,0746a5a8-8bee,58) memb {
        0746a5a8-8bee,0
        3a343e75-bfbc,0
        f4996e99-bbbd,0
} joined {
} left {
} partitioned {
})
2021-10-29 12:26:04 0 [Note] WSREP: save pc into disk
2021-10-29 12:26:04 0 [Note] WSREP: clear restored view
2021-10-29 12:26:04 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3
2021-10-29 12:26:04 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 3d0b645e-389a-11ec-aa1d-261f1caa6157
2021-10-29 12:26:04 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 3d0b645e-389a-11ec-aa1d-261f1caa6157
2021-10-29 12:26:04 0 [Note] WSREP: STATE EXCHANGE: got state msg: 3d0b645e-389a-11ec-aa1d-261f1caa6157 from 0 (ataps-node2)
2021-10-29 12:26:04 0 [Note] WSREP: STATE EXCHANGE: got state msg: 3d0b645e-389a-11ec-aa1d-261f1caa6157 from 1 (ataps-node3)
2021-10-29 12:26:04 0 [Note] WSREP: STATE EXCHANGE: got state msg: 3d0b645e-389a-11ec-aa1d-261f1caa6157 from 2 (ataps-node1)
2021-10-29 12:26:04 0 [Note] WSREP: Quorum results:
        version    = 6,
        component  = PRIMARY,
        conf_id    = 54,
        members    = 2/3 (joined/total),
        act_id     = 7136481,
        last_appl. = 7136444,
        protocols  = 2/10/4 (gcs/repl/appl),
        vote policy= 0,
        group UUID = 14f297ea-1f16-11ec-b897-f70abf8de811
2021-10-29 12:26:04 0 [Note] WSREP: Flow-control interval: [28, 28]
2021-10-29 12:26:04 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 7136482)
2021-10-29 12:26:04 2 [Note] WSREP: ####### processing CC 7136482, local, ordered
2021-10-29 12:26:04 2 [Note] WSREP: Process first view: 14f297ea-1f16-11ec-b897-f70abf8de811 my uuid: 0746a5a8-3699-11ec-8bee-7e24732f9479
2021-10-29 12:26:04 2 [Note] WSREP: Server ataps-node2 connected to cluster at position 14f297ea-1f16-11ec-b897-f70abf8de811:7136482 with ID 0746a5a8-3699-11ec-8bee-7e24732f9479
2021-10-29 12:26:04 2 [Note] WSREP: Server status change disconnected -> connected
2021-10-29 12:26:04 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-10-29 12:26:04 2 [Note] WSREP: ####### My UUID: 0746a5a8-3699-11ec-8bee-7e24732f9479
2021-10-29 12:26:04 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes
2021-10-29 12:26:04 0 [Note] WSREP: Service thread queue flushed.
2021-10-29 12:26:04 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2021-10-29 12:26:04 2 [Note] WSREP: State transfer required:
        Group state: 14f297ea-1f16-11ec-b897-f70abf8de811:7136482
        Local state: 14f297ea-1f16-11ec-b897-f70abf8de811:7136480
2021-10-29 12:26:04 2 [Note] WSREP: Server status change connected -> joiner
2021-10-29 12:26:04 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-10-29 12:26:04 0 [Note] WSREP: Joiner monitor thread started to monitor
2021-10-29 12:26:04 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '###ataps-node2--IP-ADDR###' --datadir '/var/lib/mysql/' --parent '1938157' --binlog 'bin_logs' --mysqld-args --wsrep_start_position=14f297ea-1f16-11ec-b897-f70abf8de811:7136480,0-1-7135490'
2021-10-29 12:26:04 2 [Note] WSREP: ####### IST uuid:14f297ea-1f16-11ec-b897-f70abf8de811 f: 7136481, l: 7136482, STRv: 3
2021-10-29 12:26:04 2 [Note] WSREP: IST receiver addr using tcp://###ataps-node2--IP-ADDR###:4568
2021-10-29 12:26:04 2 [Note] WSREP: Prepared IST receiver for 7136481-7136482, listening at: tcp://###ataps-node2--IP-ADDR###:4568
2021-10-29 12:26:04 0 [Note] WSREP: Member 0.0 (ataps-node2) requested state transfer from '*any*'. Selected 2.0 (ataps-node1)(SYNCED) as donor.
2021-10-29 12:26:04 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 7136482)
2021-10-29 12:26:04 2 [Note] WSREP: Requesting state transfer: success, donor: 2
2021-10-29 12:26:04 0 [Note] WSREP: 2.0 (ataps-node1): State transfer to 0.0 (ataps-node2) complete.
2021-10-29 12:26:04 0 [Note] WSREP: Member 2.0 (ataps-node1) synced with group.

WSREP_SST: [INFO] Joiner cleanup: rsync PID=1938259, stunnel PID=0 (20211029 12:26:05.439)
WSREP_SST: [INFO] Joiner cleanup done. (20211029 12:26:05.967)
2021-10-29 12:26:05 3 [Note] WSREP: SST received
2021-10-29 12:26:05 3 [Note] WSREP: Server status change joiner -> initializing
2021-10-29 12:26:05 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-10-29 12:26:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-10-29 12:26:05 0 [Note] InnoDB: Number of pools: 1
2021-10-29 12:26:05 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2021-10-29 12:26:05 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2021-10-29 12:26:06 0 [Note] InnoDB: Using Linux native AIO
2021-10-29 12:26:06 0 [Note] InnoDB: Initializing buffer pool, total size = 1073741824, chunk size = 134217728
2021-10-29 12:26:06 0 [Note] InnoDB: Completed initialization of buffer pool
2021-10-29 12:26:06 0 [Note] InnoDB: 128 rollback segments are active.
2021-10-29 12:26:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-10-29 12:26:06 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-10-29 12:26:06 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-10-29 12:26:06 0 [Note] InnoDB: 10.6.4 started; log sequence number 24142254812; transaction id 17232784
2021-10-29 12:26:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-10-29 12:26:06 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2021-10-29 12:26:06 0 [Note] Server socket created on IP: '0.0.0.0'.
2021-10-29 12:26:06 0 [Note] WSREP: wsrep_init_schema_and_SR 0x0
2021-10-29 12:26:06 0 [Note] WSREP: Server initialized
2021-10-29 12:26:06 0 [Note] WSREP: Server status change initializing -> initialized
2021-10-29 12:26:06 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-10-29 12:26:06 3 [Note] WSREP: Server status change initialized -> joined
2021-10-29 12:26:06 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-10-29 12:26:06 3 [Note] WSREP: Recovered position from storage: 14f297ea-1f16-11ec-b897-f70abf8de811:7136480
2021-10-29 12:26:06 0 [Note] /usr/sbin/mariadbd: ready for connections.
Version: '10.6.4-MariaDB-1:10.6.4+maria~focal-log'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
2021-10-29 12:26:06 3 [Note] WSREP: Recovered view from SST:
  id: 14f297ea-1f16-11ec-b897-f70abf8de811:6629256
  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(3):
        0: 0746a5a8-3699-11ec-8bed-7e24732f9479, ataps-node2
        1: 3a343e75-3699-11ec-bfbc-6ace455577e7, ataps-node3
        2: f4996e99-3698-11ec-bbbd-c6e6b10f22e1, ataps-node1

2021-10-29 12:26:06 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-10-29 12:26:06 8 [Note] WSREP: Recovered cluster id 14f297ea-1f16-11ec-b897-f70abf8de811
2021-10-29 12:26:06 3 [Note] WSREP: SST received: 14f297ea-1f16-11ec-b897-f70abf8de811:7136480
2021-10-29 12:26:06 3 [Note] WSREP: SST succeeded for position 14f297ea-1f16-11ec-b897-f70abf8de811:7136480
2021-10-29 12:26:06 0 [Note] WSREP: Joiner monitor thread ended with total time 2 sec
2021-10-29 12:26:06 2 [Note] WSREP: Installed new state from SST: 14f297ea-1f16-11ec-b897-f70abf8de811:7136480
2021-10-29 12:26:06 2 [Note] WSREP: Receiving IST: 2 writesets, seqnos 7136481-7136482
2021-10-29 12:26:06 0 [Note] WSREP: ####### IST applying starts with 7136481
2021-10-29 12:26:06 0 [Note] WSREP: ####### IST current seqno initialized to 7136445
2021-10-29 12:26:06 0 [Note] WSREP: Receiving IST...  0.0% ( 0/38 events) complete.
2021-10-29 12:26:06 0 [Note] WSREP: IST preload starting at 7136445
2021-10-29 12:26:06 0 [Note] WSREP: Service thread queue flushed.
2021-10-29 12:26:06 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:7136444, protocol version: 5
2021-10-29 12:26:06 0 [Note] WSREP: REPL Protocols: 10 (5)
2021-10-29 12:26:06 0 [Note] WSREP: ####### Adjusting cert position: 7136480 -> 7136481
2021-10-29 12:26:06 0 [Note] WSREP: Service thread queue flushed.
2021-10-29 12:26:06 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 7136445
2021-10-29 12:26:06 0 [Note] WSREP: Min available from gcache for CC from ist: 7118168
2021-10-29 12:26:06 2 [Note] WSREP: ================================================

View:
  id: 14f297ea-1f16-11ec-b897-f70abf8de811:7136481
  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: 3a343e75-3699-11ec-bfbc-6ace455577e7, ataps-node3
        1: f4996e99-3698-11ec-bbbd-c6e6b10f22e1, ataps-node1
=================================================
2021-10-29 12:26:06 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-10-29 12:26:06 0 [Note] WSREP: REPL Protocols: 10 (5)
2021-10-29 12:26:06 0 [Note] WSREP: ####### Adjusting cert position: 7136481 -> 7136482
2021-10-29 12:26:06 0 [Note] WSREP: Service thread queue flushed.
2021-10-29 12:26:06 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 7136445
2021-10-29 12:26:06 0 [Note] WSREP: Min available from gcache for CC from ist: 7118168
2021-10-29 12:26:06 0 [Note] WSREP: Receiving IST...100.0% (38/38 events) complete.
2021-10-29 12:26:06 2 [Note] WSREP: ================================================
View:
  id: 14f297ea-1f16-11ec-b897-f70abf8de811:7136482
  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(3):
        0: 0746a5a8-3699-11ec-8bee-7e24732f9479, ataps-node2
        1: 3a343e75-3699-11ec-bfbc-6ace455577e7, ataps-node3
        2: f4996e99-3698-11ec-bbbd-c6e6b10f22e1, ataps-node1
=================================================
2021-10-29 12:26:06 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-10-29 12:26:06 2 [Note] WSREP: Draining apply monitors after IST up to 7136482
2021-10-29 12:26:06 2 [Note] WSREP: IST received: 14f297ea-1f16-11ec-b897-f70abf8de811:7136482
2021-10-29 12:26:06 2 [Note] WSREP: Lowest cert index boundary for CC from sst: 7136445
2021-10-29 12:26:06 2 [Note] WSREP: Min available from gcache for CC from sst: 7118168
2021-10-29 12:26:06 0 [Note] WSREP: 0.0 (ataps-node2): State transfer from 2.0 (ataps-node1) complete.
2021-10-29 12:26:06 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 7136482)
2021-10-29 12:26:06 0 [Note] WSREP: Member 0.0 (ataps-node2) synced with group.
2021-10-29 12:26:06 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 7136482)
2021-10-29 12:26:06 2 [Note] WSREP: Server ataps-node2 synced with group
2021-10-29 12:26:06 2 [Note] WSREP: Server status change joined -> synced
2021-10-29 12:26:06 2 [Note] WSREP: Synchronized with group, ready for connections
2021-10-29 12:26:06 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-10-29 12:26:06 0 [Note] WSREP: (0746a5a8-8bee, 'tcp://0.0.0.0:4567') turning message relay requesting off
2021-10-29 12:26:09 0 [Note] InnoDB: Buffer pool(s) load completed at 211029 12:26:09
2021-10-29 12:26:13 39 [Warning] IP address '172.18.0.17' could not be resolved: Name or service not known
2021-10-29 12:26:23 44 [Warning] IP address '172.18.0.18' could not be resolved: Name or service not known
2021-10-29 12:26:55 118 [Note] Start binlog_dump to slave_server(2), pos(bin_logs.000113, 477438721), using_gtid(1), gtid('0-1-7135491')


2021-10-30 21:34:15 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown