By type
[38;5;6mmariadb [38;5;5m06:55:21.10 [0m
[38;5;6mmariadb [38;5;5m06:55:21.12 [0m[1mWelcome to the Bitnami mariadb-galera container[0m
[38;5;6mmariadb [38;5;5m06:55:21.15 [0mSubscribe to project updates by watching [1mhttps://github.com/bitnami/bitnami-docker-mariadb-galera[0m
[38;5;6mmariadb [38;5;5m06:55:21.17 [0mSubmit issues and feature requests at [1mhttps://github.com/bitnami/bitnami-docker-mariadb-galera/issues[0m
[38;5;6mmariadb [38;5;5m06:55:21.20 [0m
[38;5;6mmariadb [38;5;5m06:55:21.22 [0m[38;5;2mINFO [0m ==> ** Starting MariaDB setup **
[38;5;6mmariadb [38;5;5m06:55:21.47 [0m[38;5;2mINFO [0m ==> Validating settings in MYSQL_*/MARIADB_* env vars
[38;5;6mmariadb [38;5;5m06:55:21.57 [0m[38;5;5mDEBUG[0m ==> Set Galera cluster address to gcomm://mariadb-galera-headless.onap.svc.cluster.local
[38;5;6mmariadb [38;5;5m06:55:21.70 [0m[38;5;2mINFO [0m ==> Initializing mariadb database
[38;5;6mmariadb [38;5;5m06:55:21.74 [0m[38;5;5mDEBUG[0m ==> Ensuring expected directories/files exist
[38;5;6mmariadb [38;5;5m06:55:22.05 [0m[38;5;2mINFO [0m ==> Updating 'my.cnf' with custom configuration
[38;5;6mmariadb [38;5;5m06:55:22.22 [0m[38;5;2mINFO [0m ==> Setting user option
[38;5;6mmariadb [38;5;5m06:55:22.27 [0m[38;5;5mDEBUG[0m ==> Setting user to 'my-user' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:55:22.44 [0m[38;5;2mINFO [0m ==> Setting wsrep_node_name option
[38;5;6mmariadb [38;5;5m06:55:22.48 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_node_name to 'onap-mariadb-galera-1' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:55:22.56 [0m[38;5;2mINFO [0m ==> Setting wsrep_node_address option
[38;5;6mmariadb [38;5;5m06:55:22.65 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_node_address to '10.233.72.5' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:55:22.79 [0m[38;5;5mDEBUG[0m ==> Set Galera cluster address to gcomm://mariadb-galera-headless.onap.svc.cluster.local
[38;5;6mmariadb [38;5;5m06:55:22.82 [0m[38;5;2mINFO [0m ==> Setting wsrep_cluster_address option
[38;5;6mmariadb [38;5;5m06:55:22.86 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_cluster_address to 'gcomm://mariadb-galera-headless.onap.svc.cluster.local' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:55:22.97 [0m[38;5;2mINFO [0m ==> Setting wsrep_sst_auth option
[38;5;6mmariadb [38;5;5m06:55:23.00 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_sst_auth to 'mariabackup:psw26pAr' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:55:23.08 [0m[38;5;2mINFO [0m ==> Persisted data detected. Restoring
[38;5;6mmariadb [38;5;5m06:55:23.17 [0m[38;5;2mINFO [0m ==> ** MariaDB setup finished! **
[38;5;6mmariadb [38;5;5m06:55:23.71 [0m[38;5;2mINFO [0m ==> ** Starting MariaDB **
[38;5;6mmariadb [38;5;5m06:55:23.74 [0m[38;5;2mINFO [0m ==> Setting previous boot
2022-03-20 6:55:24 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated
2022-03-20 6:55:24 0 [Warning] WSREP: --wsrep-causal-reads=ON takes precedence over --wsrep-sync-wait=0. WSREP_SYNC_WAIT_BEFORE_READ is on
2022-03-20 6:55:24 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (server 10.6.5-MariaDB-log) starting as process 1 ...
2022-03-20 6:55:24 0 [Note] WSREP: Loading provider /opt/bitnami/mariadb/lib/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
2022-03-20 6:55:24 0 [Note] WSREP: wsrep_load(): loading provider library '/opt/bitnami/mariadb/lib/libgalera_smm.so'
2022-03-20 6:55:24 0 [Note] WSREP: wsrep_load(): Galera 4.9(rXXXX) by Codership Oy loaded successfully.
2022-03-20 6:55:24 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2022-03-20 6:55:24 0 [Note] WSREP: Found saved state: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113, safe_to_bootstrap: 0
2022-03-20 6:55:24 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 2
UUID: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd
Seqno: 2976 - 3113
Offset: 6241752
Synced: 1
2022-03-20 6:55:24 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd, offset: 6241752
2022-03-20 6:55:24 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/134217752 bytes) complete.
2022-03-20 6:55:24 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete.
2022-03-20 6:55:24 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 2976-3113
2022-03-20 6:55:24 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/103408 bytes) complete.
2022-03-20 6:55:24 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (103408/103408 bytes) complete.
2022-03-20 6:55:24 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 16/154 locked buffers
2022-03-20 6:55:24 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): free space: 134118288/134217728
2022-03-20 6:55:24 0 [Note] WSREP: Passing config to GCS: base_dir = /bitnami/mariadb/data/; base_host = 10.233.72.5; 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.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 = /bitnami/mariadb/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.version = 0; pc.announce_timeout = PT3S; p
2022-03-20 6:55:24 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:55:24 0 [Note] WSREP: ####### Assign initial position for certification: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113, protocol version: -1
2022-03-20 6:55:24 0 [Note] WSREP: Start replication
2022-03-20 6:55:24 0 [Note] WSREP: Connecting with bootstrap option: 0
2022-03-20 6:55:24 0 [Note] WSREP: Setting GCS initial position to 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113
2022-03-20 6:55:24 0 [Note] WSREP: protonet asio version 0
2022-03-20 6:55:24 0 [Note] WSREP: Using CRC-32C for message checksums.
2022-03-20 6:55:24 0 [Note] WSREP: backend: asio
2022-03-20 6:55:24 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2022-03-20 6:55:24 0 [Warning] WSREP: access file(/bitnami/mariadb/data//gvwstate.dat) failed(No such file or directory)
2022-03-20 6:55:24 0 [Note] WSREP: restore pc from disk failed
2022-03-20 6:55:24 0 [Note] WSREP: GMCast version 0
2022-03-20 6:55:25 0 [Note] WSREP: (b7e9c0dd-936c, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2022-03-20 6:55:25 0 [Note] WSREP: (b7e9c0dd-936c, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2022-03-20 6:55:25 0 [Note] WSREP: EVS version 1
2022-03-20 6:55:25 0 [Note] WSREP: gcomm: connecting to group 'galera', peer 'mariadb-galera-headless.onap.svc.cluster.local:'
2022-03-20 6:55:25 0 [Note] WSREP: (b7e9c0dd-936c, 'tcp://0.0.0.0:4567') connection established to 4e600f64-ae49 tcp://10.233.71.169:4567
2022-03-20 6:55:25 0 [Note] WSREP: (b7e9c0dd-936c, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.233.70.148:4567
2022-03-20 6:55:25 0 [Note] WSREP: (b7e9c0dd-936c, 'tcp://0.0.0.0:4567') connection established to 33816075-aea3 tcp://10.233.70.148:4567
2022-03-20 6:55:25 0 [Note] WSREP: EVS version upgrade 0 -> 1
2022-03-20 6:55:25 0 [Note] WSREP: declaring 33816075-aea3 at tcp://10.233.70.148:4567 stable
2022-03-20 6:55:25 0 [Note] WSREP: declaring 4e600f64-ae49 at tcp://10.233.71.169:4567 stable
2022-03-20 6:55:25 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2022-03-20 6:55:26 0 [Note] WSREP: Node 33816075-aea3 state prim
2022-03-20 6:55:26 0 [Note] WSREP: view(view_id(PRIM,33816075-aea3,41) memb {
33816075-aea3,0
4e600f64-ae49,0
b7e9c0dd-936c,0
} joined {
} left {
} partitioned {
})
2022-03-20 6:55:26 0 [Note] WSREP: save pc into disk
2022-03-20 6:55:27 0 [Note] WSREP: gcomm: connected
2022-03-20 6:55:27 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2022-03-20 6:55:27 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2022-03-20 6:55:27 0 [Note] WSREP: Opened channel 'galera'
2022-03-20 6:55:27 1 [Note] WSREP: Starting rollbacker thread 1
2022-03-20 6:55:27 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3
2022-03-20 6:55:27 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2022-03-20 6:55:27 0 [Note] WSREP: STATE EXCHANGE: sent state msg: b8d76599-a81a-11ec-91a3-766896e1e3ea
2022-03-20 6:55:27 0 [Note] WSREP: STATE EXCHANGE: got state msg: b8d76599-a81a-11ec-91a3-766896e1e3ea from 0 (onap-mariadb-galera-0)
2022-03-20 6:55:27 0 [Note] WSREP: STATE EXCHANGE: got state msg: b8d76599-a81a-11ec-91a3-766896e1e3ea from 1 (onap-mariadb-galera-2)
2022-03-20 6:55:27 2 [Note] WSREP: Starting applier thread 2
2022-03-20 6:55:27 0 [Note] WSREP: STATE EXCHANGE: got state msg: b8d76599-a81a-11ec-91a3-766896e1e3ea from 2 (onap-mariadb-galera-1)
2022-03-20 6:55:27 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 40,
members = 2/3 (joined/total),
act_id = 3114,
last_appl. = 2975,
protocols = 2/10/4 (gcs/repl/appl),
vote policy= 0,
group UUID = 2991f091-a80a-11ec-adf1-7a3e34aaf7bd
2022-03-20 6:55:27 0 [Note] WSREP: Flow-control interval: [28, 28]
2022-03-20 6:55:27 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 3115)
2022-03-20 6:55:27 2 [Note] WSREP: ####### processing CC 3115, local, ordered
2022-03-20 6:55:27 2 [Note] WSREP: Process first view: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd my uuid: b7e9c0dd-a81a-11ec-936c-8ae303a9d2f3
2022-03-20 6:55:27 2 [Note] WSREP: Server onap-mariadb-galera-1 connected to cluster at position 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3115 with ID b7e9c0dd-a81a-11ec-936c-8ae303a9d2f3
2022-03-20 6:55:27 2 [Note] WSREP: Server status change disconnected -> connected
2022-03-20 6:55:27 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:55:27 2 [Note] WSREP: ####### My UUID: b7e9c0dd-a81a-11ec-936c-8ae303a9d2f3
2022-03-20 6:55:27 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes
2022-03-20 6:55:27 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:55:27 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2022-03-20 6:55:27 2 [Note] WSREP: State transfer required:
Group state: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3115
Local state: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113
2022-03-20 6:55:27 2 [Note] WSREP: Server status change connected -> joiner
2022-03-20 6:55:27 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:55:27 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '10.233.72.5' --datadir '/bitnami/mariadb/data/' --defaults-file '/opt/bitnami/mariadb/conf/my.cnf' --parent '1' --binlog 'mysql-bin' --mysqld-args --defaults-file=/opt/bitnami/mariadb/conf/my.cnf --basedir=/opt/bitnami/mariadb --datadir=/bitnami/mariadb/data --socket=/opt/bitnami/mariadb/tmp/mysql.sock --pid-file=/opt/bitnami/mariadb/tmp/mysqld.pid'
2022-03-20 6:55:27 0 [Note] WSREP: Joiner monitor thread started to monitor
WSREP_SST: [INFO] SSL configuration: CA='', CERT='', KEY='', MODE='DISABLED', encrypt='0' (20220320 06:55:28.051)
2022-03-20 6:55:28 0 [Note] WSREP: (b7e9c0dd-936c, 'tcp://0.0.0.0:4567') turning message relay requesting off
WSREP_SST: [INFO] Streaming with mbstream (20220320 06:55:28.968)
WSREP_SST: [INFO] Using socat as streamer (20220320 06:55:28.994)
WSREP_SST: [INFO] Evaluating timeout -k 310 300 socat -u TCP-LISTEN:4444,reuseaddr stdio | '/opt/bitnami/mariadb//bin/mbstream' -x; RC=( ${PIPESTATUS[@]} ) (20220320 06:55:29.631)
2022-03-20 6:55:30 2 [Note] WSREP: ####### IST uuid:2991f091-a80a-11ec-adf1-7a3e34aaf7bd f: 3114, l: 3115, STRv: 3
2022-03-20 6:55:30 2 [Note] WSREP: IST receiver addr using tcp://10.233.72.5:4568
2022-03-20 6:55:30 2 [Note] WSREP: Prepared IST receiver for 3114-3115, listening at: tcp://10.233.72.5:4568
2022-03-20 6:55:30 0 [Note] WSREP: Member 2.0 (onap-mariadb-galera-1) requested state transfer from '*any*'. Selected 1.0 (onap-mariadb-galera-2)(SYNCED) as donor.
2022-03-20 6:55:30 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 3115)
2022-03-20 6:55:30 2 [Note] WSREP: Requesting state transfer: success, donor: 1
2022-03-20 6:55:32 0 [Note] WSREP: 1.0 (onap-mariadb-galera-2): State transfer to 2.0 (onap-mariadb-galera-1) complete.
2022-03-20 6:55:32 0 [Note] WSREP: Member 1.0 (onap-mariadb-galera-2) synced with group.
WSREP_SST: [INFO] 'xtrabackup_ist' received from donor: Running IST (20220320 06:55:32.183)
WSREP_SST: [INFO] Galera co-ords from recovery: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113 0 (20220320 06:55:32.222)
WSREP_SST: [INFO] Total time on joiner: 0 seconds (20220320 06:55:32.269)
WSREP_SST: [INFO] Removing the sst_in_progress file (20220320 06:55:32.288)
WSREP_SST: [INFO] Cleaning up temporary directories (20220320 06:55:32.379)
2022-03-20 6:55:32 3 [Note] WSREP: SST received
2022-03-20 6:55:32 3 [Note] WSREP: Server status change joiner -> initializing
2022-03-20 6:55:32 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:55:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-20 6:55:32 0 [Note] InnoDB: Number of pools: 1
2022-03-20 6:55:32 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-20 6:55:32 0 [Note] InnoDB: Using Linux native AIO
2022-03-20 6:55:32 0 [Note] InnoDB: Initializing buffer pool, total size = 2147483648, chunk size = 134217728
2022-03-20 6:55:32 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-20 6:55:33 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 134217728 bytes
2022-03-20 6:55:36 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2022-03-20 6:55:36 0 [Note] InnoDB: New log file created, LSN=33928020
2022-03-20 6:55:37 0 [Note] InnoDB: 128 rollback segments are active.
2022-03-20 6:55:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-03-20 6:55:42 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-03-20 6:56:11 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-03-20 6:56:11 0 [Note] InnoDB: 10.6.5 started; log sequence number 0; transaction id 7423
2022-03-20 6:56:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-20 6:56:11 0 [Note] InnoDB: Loading buffer pool(s) from /bitnami/mariadb/data/ib_buffer_pool
2022-03-20 6:56:11 0 [Warning] 'innodb-log-files-in-group' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2022-03-20 6:56:11 0 [Warning] 'innodb-file-format' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
/opt/bitnami/mariadb/sbin/mysqld, Version: 10.6.5-MariaDB-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /opt/bitnami/mariadb/tmp/mysql.sock
Time Id Command Argument
2022-03-20 6:56:11 0 [Note] InnoDB: Buffer pool(s) load completed at 220320 6:56:11
2022-03-20 6:56:11 0 [Note] Server socket created on IP: '0.0.0.0'.
2022-03-20 6:56:11 0 [Warning] 'proxies_priv' entry '@% root@onap-mariadb-galera-0' ignored in --skip-name-resolve mode.
2022-03-20 6:56:12 0 [Note] WSREP: wsrep_init_schema_and_SR 0x0
2022-03-20 6:56:13 0 [Note] WSREP: Server initialized
2022-03-20 6:56:13 0 [Note] WSREP: Server status change initializing -> initialized
2022-03-20 6:56:13 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:56:13 3 [Note] WSREP: Server status change initialized -> joined
2022-03-20 6:56:13 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:56:13 3 [Note] WSREP: Recovered position from storage: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113
2022-03-20 6:56:13 7 [Note] WSREP: Starting applier thread 7
2022-03-20 6:56:13 6 [Note] WSREP: Starting applier thread 6
2022-03-20 6:56:13 8 [Note] WSREP: Starting applier thread 8
2022-03-20 6:56:13 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: ready for connections.
Version: '10.6.5-MariaDB-log' socket: '/opt/bitnami/mariadb/tmp/mysql.sock' port: 3306 Source distribution
2022-03-20 6:56:13 3 [Note] WSREP: Recovered view from SST:
id: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113
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: 33816075-a80a-11ec-aea3-aea6c9ff5092, onap-mariadb-galera-0
1: 4e600f64-a810-11ec-ae49-22874bf67cb3, onap-mariadb-galera-2
2: 55d66db0-a81a-11ec-9f8c-b3c3dcdbf38f, onap-mariadb-galera-1
2022-03-20 6:56:13 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:56:13 11 [Note] WSREP: Recovered cluster id 2991f091-a80a-11ec-adf1-7a3e34aaf7bd
2022-03-20 6:56:13 3 [Note] WSREP: SST received: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113
2022-03-20 6:56:13 3 [Note] WSREP: SST succeeded for position 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113
2022-03-20 6:56:13 2 [Note] WSREP: Installed new state from SST: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113
2022-03-20 6:56:13 0 [Note] WSREP: Joiner monitor thread ended with total time 46 sec
2022-03-20 6:56:13 2 [Note] WSREP: Receiving IST: 2 writesets, seqnos 3114-3115
2022-03-20 6:56:13 0 [Note] WSREP: ####### IST applying starts with 3114
2022-03-20 6:56:13 0 [Note] WSREP: ####### IST current seqno initialized to 2976
2022-03-20 6:56:13 0 [Note] WSREP: Receiving IST... 0.0% ( 0/140 events) complete.
2022-03-20 6:56:13 0 [Note] WSREP: IST preload starting at 2976
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:2975, protocol version: 5
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3096 -> 3097
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3097 -> 3098
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3098 -> 3099
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3099 -> 3100
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3100 -> 3101
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3101 -> 3102
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3102 -> 3103
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3103 -> 3104
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3104 -> 3105
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3105 -> 3106
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3106 -> 3107
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3107 -> 3108
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3108 -> 3109
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3109 -> 3110
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3110 -> 3111
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3111 -> 3112
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3112 -> 3113
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3113 -> 3114
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from ist: 2976
2022-03-20 6:56:13 7 [Note] WSREP: ================================================
View:
id: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3114
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: 33816075-a80a-11ec-aea3-aea6c9ff5092, onap-mariadb-galera-0
1: 4e600f64-a810-11ec-ae49-22874bf67cb3, onap-mariadb-galera-2
=================================================
2022-03-20 6:56:13 7 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3114 -> 3115
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from ist: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Receiving IST...100.0% (140/140 events) complete.
2022-03-20 6:56:13 8 [Note] WSREP: ================================================
View:
id: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3115
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: 33816075-a80a-11ec-aea3-aea6c9ff5092, onap-mariadb-galera-0
1: 4e600f64-a810-11ec-ae49-22874bf67cb3, onap-mariadb-galera-2
2: b7e9c0dd-a81a-11ec-936c-8ae303a9d2f3, onap-mariadb-galera-1
=================================================
2022-03-20 6:56:13 8 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:56:13 2 [Note] WSREP: Draining apply monitors after IST up to 3115
2022-03-20 6:56:13 2 [Note] WSREP: IST received: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3115
2022-03-20 6:56:13 2 [Note] WSREP: Lowest cert index boundary for CC from sst: 2976
2022-03-20 6:56:13 2 [Note] WSREP: Min available from gcache for CC from sst: 2976
2022-03-20 6:56:13 0 [Note] WSREP: 2.0 (onap-mariadb-galera-1): State transfer from 1.0 (onap-mariadb-galera-2) complete.
2022-03-20 6:56:13 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 3115)
2022-03-20 6:56:13 0 [Note] WSREP: Member 2.0 (onap-mariadb-galera-1) synced with group.
2022-03-20 6:56:13 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3115)
2022-03-20 6:56:13 8 [Note] WSREP: Server onap-mariadb-galera-1 synced with group
2022-03-20 6:56:13 8 [Note] WSREP: Server status change joined -> synced
2022-03-20 6:56:13 8 [Note] WSREP: Synchronized with group, ready for connections
2022-03-20 6:56:13 8 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
# Time: 220320 6:56:15
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 12 Schema: QC_hit: No
# Query_time: 0.003420 Lock_time: 0.003181 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759375;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 12 Schema: QC_hit: No
# Query_time: 0.009347 Lock_time: 0.009072 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759375;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 13 Schema: QC_hit: No
# Query_time: 0.014928 Lock_time: 0.014707 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759375;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 13 Schema: QC_hit: No
# Query_time: 0.001200 Lock_time: 0.001040 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759375;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220320 6:56:25
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 17 Schema: QC_hit: No
# Query_time: 0.014564 Lock_time: 0.014057 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759385;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 18 Schema: QC_hit: No
# Query_time: 0.008677 Lock_time: 0.008231 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759385;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 17 Schema: QC_hit: No
# Query_time: 0.006266 Lock_time: 0.005666 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759385;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 18 Schema: QC_hit: No
# Query_time: 0.007637 Lock_time: 0.006909 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759385;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220320 6:56:31
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 21 Schema: QC_hit: No
# Query_time: 0.000737 Lock_time: 0.000359 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759391;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 21 Schema: QC_hit: No
# Query_time: 0.000608 Lock_time: 0.000396 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759391;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220320 6:56:34
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 22 Schema: QC_hit: No
# Query_time: 0.011252 Lock_time: 0.010969 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759394;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 22 Schema: QC_hit: No
# Query_time: 0.000724 Lock_time: 0.000483 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759394;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220320 6:56:35
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 23 Schema: QC_hit: No
# Query_time: 0.000497 Lock_time: 0.000298 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759395;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 23 Schema: QC_hit: No
# Query_time: 0.000240 Lock_time: 0.000159 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759395;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220320 6:56:45
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 27 Schema: QC_hit: No
# Query_time: 0.000571 Lock_time: 0.000327 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759405;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 27 Schema: QC_hit: No
# Query_time: 0.000525 Lock_time: 0.000326 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759405;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 26 Schema: QC_hit: No
# Query_time: 0.000517 Lock_time: 0.000291 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759405;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 26 Schema: QC_hit: No
# Query_time: 0.000244 Lock_time: 0.000165 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759405;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220320 6:56:55
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 30 Schema: QC_hit: No
# Query_time: 0.000540 Lock_time: 0.000317 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759415;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 30 Schema: QC_hit: No
# Query_time: 0.000823 Lock_time: 0.000272 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759415;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 31 Schema: QC_hit: No
# Query_time: 0.006941 Lock_time: 0.006849 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759415;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 31 Schema: QC_hit: No
# Query_time: 0.001071 Lock_time: 0.000861 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759415;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220320 6:57:01
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 34 Schema: QC_hit: No
# Query_time: 0.002690 Lock_time: 0.002414 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759421;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 34 Schema: QC_hit: No
# Query_time: 0.005796 Lock_time: 0.005421 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759421;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220320 6:57:05
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 36 Schema: QC_hit: No
# Query_time: 0.001067 Lock_time: 0.000860 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759425;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 35 Schema: QC_hit: No
# Query_time: 0.009159 Lock_time: 0.008942 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759425;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 36 Schema: QC_hit: No
# Query_time: 0.005104 Lock_time: 0.004888 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759425;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 35 Schema: QC_hit: No
# Query_time: 0.002905 Lock_time: 0.002665 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759425;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
2022-03-20 6:57:05 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (initiated by: unknown): Normal shutdown
2022-03-20 6:57:05 0 [Note] WSREP: Shutdown replication
2022-03-20 6:57:05 0 [Note] WSREP: Server status change synced -> disconnecting
2022-03-20 6:57:05 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:57:05 0 [Note] WSREP: Closing send monitor...
2022-03-20 6:57:05 0 [Note] WSREP: Closed send monitor.
2022-03-20 6:57:05 0 [Note] WSREP: gcomm: terminating thread
2022-03-20 6:57:05 0 [Note] WSREP: gcomm: joining thread
2022-03-20 6:57:05 0 [Note] WSREP: gcomm: closing backend
2022-03-20 6:57:06 0 [Note] WSREP: view(view_id(NON_PRIM,33816075-aea3,41) memb {
b7e9c0dd-936c,0
} joined {
} left {
} partitioned {
33816075-aea3,0
4e600f64-ae49,0
})
2022-03-20 6:57:06 0 [Note] WSREP: PC protocol downgrade 1 -> 0
2022-03-20 6:57:06 0 [Note] WSREP: view((empty))
2022-03-20 6:57:06 0 [Note] WSREP: gcomm: closed
2022-03-20 6:57:06 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
2022-03-20 6:57:06 0 [Note] WSREP: Flow-control interval: [16, 16]
2022-03-20 6:57:06 0 [Note] WSREP: Received NON-PRIMARY.
2022-03-20 6:57:06 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 3115)
2022-03-20 6:57:06 0 [Note] WSREP: New SELF-LEAVE.
2022-03-20 6:57:06 0 [Note] WSREP: Flow-control interval: [0, 0]
2022-03-20 6:57:06 0 [Note] WSREP: Received SELF-LEAVE. Closing connection.
2022-03-20 6:57:06 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 3115)
2022-03-20 6:57:06 0 [Note] WSREP: RECV thread exiting 0: Success
2022-03-20 6:57:06 0 [Note] WSREP: recv_thread() joined.
2022-03-20 6:57:06 0 [Note] WSREP: Closing replication queue.
2022-03-20 6:57:06 0 [Note] WSREP: Closing slave action queue.
2022-03-20 6:57:06 8 [Note] WSREP: ================================================
View:
id: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3115
status: non-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: b7e9c0dd-a81a-11ec-936c-8ae303a9d2f3, onap-mariadb-galera-1
=================================================
2022-03-20 6:57:06 8 [Note] WSREP: Non-primary view
2022-03-20 6:57:06 8 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:57:06 8 [Note] WSREP: ================================================
View:
id: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3115
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):
=================================================
2022-03-20 6:57:06 8 [Note] WSREP: Non-primary view
2022-03-20 6:57:06 8 [Note] WSREP: Server status change disconnecting -> disconnected
2022-03-20 6:57:06 8 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:57:06 8 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:57:06 2 [Note] WSREP: Applier thread exiting ret: 6 thd: 2
2022-03-20 6:57:06 7 [Note] WSREP: Applier thread exiting ret: 6 thd: 7
2022-03-20 6:57:06 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2022-03-20 6:57:06 7 [Warning] Aborted connection 7 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2022-03-20 6:57:06 6 [Note] WSREP: Applier thread exiting ret: 6 thd: 6
2022-03-20 6:57:06 6 [Warning] Aborted connection 6 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2022-03-20 6:57:06 8 [Note] WSREP: Applier thread exiting ret: 0 thd: 8
2022-03-20 6:57:06 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2022-03-20 6:57:06 1 [Note] WSREP: rollbacker thread exiting 1
2022-03-20 6:57:06 1 [Warning] Aborted connection 1 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2022-03-20 6:57:06 0 [Note] WSREP: dtor state: CLOSED
2022-03-20 6:57:06 0 [Note] WSREP: MemPool(TrxHandleSlave): hit ratio: 0, misses: 121, in use: 121, in pool: 0
2022-03-20 6:57:06 0 [Note] WSREP: mon: entered 2 oooe fraction 0 oool fraction 0
2022-03-20 6:57:06 0 [Note] WSREP: mon: entered 2 oooe fraction 0 oool fraction 0
2022-03-20 6:57:06 0 [Note] WSREP: mon: entered 5 oooe fraction 0 oool fraction 0.2
2022-03-20 6:57:06 0 [Note] WSREP: cert index usage at exit 552
2022-03-20 6:57:06 0 [Note] WSREP: cert trx map usage at exit 121
2022-03-20 6:57:06 0 [Note] WSREP: deps set usage at exit 0
2022-03-20 6:57:06 0 [Note] WSREP: avg deps dist 39.4215
2022-03-20 6:57:06 0 [Note] WSREP: avg cert interval 3036
2022-03-20 6:57:06 0 [Note] WSREP: cert index size 552
2022-03-20 6:57:06 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:57:06 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0
2022-03-20 6:57:06 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0
2022-03-20 6:57:06 0 [Note] WSREP: Flushing memory map to disk...
2022-03-20 6:57:06 0 [Note] InnoDB: FTS optimize thread exiting.
2022-03-20 6:57:06 0 [Note] InnoDB: Starting shutdown...
2022-03-20 6:57:06 0 [Note] InnoDB: Dumping buffer pool(s) to /bitnami/mariadb/data/ib_buffer_pool
2022-03-20 6:57:06 0 [Note] InnoDB: Buffer pool(s) dump completed at 220320 6:57:06
2022-03-20 6:57:06 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2022-03-20 6:57:06 0 [Note] InnoDB: Shutdown completed; log sequence number 33930468; transaction id 7432
2022-03-20 6:57:06 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: Shutdown complete
[38;5;6mmariadb [38;5;5m06:55:21.10 [0m
[38;5;6mmariadb [38;5;5m06:55:21.12 [0m[1mWelcome to the Bitnami mariadb-galera container[0m
[38;5;6mmariadb [38;5;5m06:55:21.15 [0mSubscribe to project updates by watching [1mhttps://github.com/bitnami/bitnami-docker-mariadb-galera[0m
[38;5;6mmariadb [38;5;5m06:55:21.17 [0mSubmit issues and feature requests at [1mhttps://github.com/bitnami/bitnami-docker-mariadb-galera/issues[0m
[38;5;6mmariadb [38;5;5m06:55:21.20 [0m
[38;5;6mmariadb [38;5;5m06:55:21.22 [0m[38;5;2mINFO [0m ==> ** Starting MariaDB setup **
[38;5;6mmariadb [38;5;5m06:55:21.47 [0m[38;5;2mINFO [0m ==> Validating settings in MYSQL_*/MARIADB_* env vars
[38;5;6mmariadb [38;5;5m06:55:21.57 [0m[38;5;5mDEBUG[0m ==> Set Galera cluster address to gcomm://mariadb-galera-headless.onap.svc.cluster.local
[38;5;6mmariadb [38;5;5m06:55:21.70 [0m[38;5;2mINFO [0m ==> Initializing mariadb database
[38;5;6mmariadb [38;5;5m06:55:21.74 [0m[38;5;5mDEBUG[0m ==> Ensuring expected directories/files exist
[38;5;6mmariadb [38;5;5m06:55:22.05 [0m[38;5;2mINFO [0m ==> Updating 'my.cnf' with custom configuration
[38;5;6mmariadb [38;5;5m06:55:22.22 [0m[38;5;2mINFO [0m ==> Setting user option
[38;5;6mmariadb [38;5;5m06:55:22.27 [0m[38;5;5mDEBUG[0m ==> Setting user to 'my-user' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:55:22.44 [0m[38;5;2mINFO [0m ==> Setting wsrep_node_name option
[38;5;6mmariadb [38;5;5m06:55:22.48 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_node_name to 'onap-mariadb-galera-1' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:55:22.56 [0m[38;5;2mINFO [0m ==> Setting wsrep_node_address option
[38;5;6mmariadb [38;5;5m06:55:22.65 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_node_address to '10.233.72.5' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:55:22.79 [0m[38;5;5mDEBUG[0m ==> Set Galera cluster address to gcomm://mariadb-galera-headless.onap.svc.cluster.local
[38;5;6mmariadb [38;5;5m06:55:22.82 [0m[38;5;2mINFO [0m ==> Setting wsrep_cluster_address option
[38;5;6mmariadb [38;5;5m06:55:22.86 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_cluster_address to 'gcomm://mariadb-galera-headless.onap.svc.cluster.local' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:55:22.97 [0m[38;5;2mINFO [0m ==> Setting wsrep_sst_auth option
[38;5;6mmariadb [38;5;5m06:55:23.00 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_sst_auth to 'mariabackup:psw26pAr' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:55:23.08 [0m[38;5;2mINFO [0m ==> Persisted data detected. Restoring
[38;5;6mmariadb [38;5;5m06:55:23.17 [0m[38;5;2mINFO [0m ==> ** MariaDB setup finished! **
[38;5;6mmariadb [38;5;5m06:55:23.71 [0m[38;5;2mINFO [0m ==> ** Starting MariaDB **
[38;5;6mmariadb [38;5;5m06:55:23.74 [0m[38;5;2mINFO [0m ==> Setting previous boot
2022-03-20 6:55:24 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated
2022-03-20 6:55:24 0 [Warning] WSREP: --wsrep-causal-reads=ON takes precedence over --wsrep-sync-wait=0. WSREP_SYNC_WAIT_BEFORE_READ is on
2022-03-20 6:55:24 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (server 10.6.5-MariaDB-log) starting as process 1 ...
2022-03-20 6:55:24 0 [Note] WSREP: Loading provider /opt/bitnami/mariadb/lib/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
2022-03-20 6:55:24 0 [Note] WSREP: wsrep_load(): loading provider library '/opt/bitnami/mariadb/lib/libgalera_smm.so'
2022-03-20 6:55:24 0 [Note] WSREP: wsrep_load(): Galera 4.9(rXXXX) by Codership Oy loaded successfully.
2022-03-20 6:55:24 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2022-03-20 6:55:24 0 [Note] WSREP: Found saved state: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113, safe_to_bootstrap: 0
2022-03-20 6:55:24 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 2
UUID: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd
Seqno: 2976 - 3113
Offset: 6241752
Synced: 1
2022-03-20 6:55:24 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd, offset: 6241752
2022-03-20 6:55:24 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/134217752 bytes) complete.
2022-03-20 6:55:24 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete.
2022-03-20 6:55:24 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 2976-3113
2022-03-20 6:55:24 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/103408 bytes) complete.
2022-03-20 6:55:24 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (103408/103408 bytes) complete.
2022-03-20 6:55:24 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 16/154 locked buffers
2022-03-20 6:55:24 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): free space: 134118288/134217728
2022-03-20 6:55:24 0 [Note] WSREP: Passing config to GCS: base_dir = /bitnami/mariadb/data/; base_host = 10.233.72.5; 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.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 = /bitnami/mariadb/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.version = 0; pc.announce_timeout = PT3S; p
2022-03-20 6:55:24 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:55:24 0 [Note] WSREP: ####### Assign initial position for certification: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113, protocol version: -1
2022-03-20 6:55:24 0 [Note] WSREP: Start replication
2022-03-20 6:55:24 0 [Note] WSREP: Connecting with bootstrap option: 0
2022-03-20 6:55:24 0 [Note] WSREP: Setting GCS initial position to 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113
2022-03-20 6:55:24 0 [Note] WSREP: protonet asio version 0
2022-03-20 6:55:24 0 [Note] WSREP: Using CRC-32C for message checksums.
2022-03-20 6:55:24 0 [Note] WSREP: backend: asio
2022-03-20 6:55:24 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2022-03-20 6:55:24 0 [Warning] WSREP: access file(/bitnami/mariadb/data//gvwstate.dat) failed(No such file or directory)
2022-03-20 6:55:24 0 [Note] WSREP: restore pc from disk failed
2022-03-20 6:55:24 0 [Note] WSREP: GMCast version 0
2022-03-20 6:55:25 0 [Note] WSREP: (b7e9c0dd-936c, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2022-03-20 6:55:25 0 [Note] WSREP: (b7e9c0dd-936c, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2022-03-20 6:55:25 0 [Note] WSREP: EVS version 1
2022-03-20 6:55:25 0 [Note] WSREP: gcomm: connecting to group 'galera', peer 'mariadb-galera-headless.onap.svc.cluster.local:'
2022-03-20 6:55:25 0 [Note] WSREP: (b7e9c0dd-936c, 'tcp://0.0.0.0:4567') connection established to 4e600f64-ae49 tcp://10.233.71.169:4567
2022-03-20 6:55:25 0 [Note] WSREP: (b7e9c0dd-936c, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.233.70.148:4567
2022-03-20 6:55:25 0 [Note] WSREP: (b7e9c0dd-936c, 'tcp://0.0.0.0:4567') connection established to 33816075-aea3 tcp://10.233.70.148:4567
2022-03-20 6:55:25 0 [Note] WSREP: EVS version upgrade 0 -> 1
2022-03-20 6:55:25 0 [Note] WSREP: declaring 33816075-aea3 at tcp://10.233.70.148:4567 stable
2022-03-20 6:55:25 0 [Note] WSREP: declaring 4e600f64-ae49 at tcp://10.233.71.169:4567 stable
2022-03-20 6:55:25 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2022-03-20 6:55:26 0 [Note] WSREP: Node 33816075-aea3 state prim
2022-03-20 6:55:26 0 [Note] WSREP: view(view_id(PRIM,33816075-aea3,41) memb {
33816075-aea3,0
4e600f64-ae49,0
b7e9c0dd-936c,0
} joined {
} left {
} partitioned {
})
2022-03-20 6:55:26 0 [Note] WSREP: save pc into disk
2022-03-20 6:55:27 0 [Note] WSREP: gcomm: connected
2022-03-20 6:55:27 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2022-03-20 6:55:27 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2022-03-20 6:55:27 0 [Note] WSREP: Opened channel 'galera'
2022-03-20 6:55:27 1 [Note] WSREP: Starting rollbacker thread 1
2022-03-20 6:55:27 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3
2022-03-20 6:55:27 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2022-03-20 6:55:27 0 [Note] WSREP: STATE EXCHANGE: sent state msg: b8d76599-a81a-11ec-91a3-766896e1e3ea
2022-03-20 6:55:27 0 [Note] WSREP: STATE EXCHANGE: got state msg: b8d76599-a81a-11ec-91a3-766896e1e3ea from 0 (onap-mariadb-galera-0)
2022-03-20 6:55:27 0 [Note] WSREP: STATE EXCHANGE: got state msg: b8d76599-a81a-11ec-91a3-766896e1e3ea from 1 (onap-mariadb-galera-2)
2022-03-20 6:55:27 2 [Note] WSREP: Starting applier thread 2
2022-03-20 6:55:27 0 [Note] WSREP: STATE EXCHANGE: got state msg: b8d76599-a81a-11ec-91a3-766896e1e3ea from 2 (onap-mariadb-galera-1)
2022-03-20 6:55:27 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 40,
members = 2/3 (joined/total),
act_id = 3114,
last_appl. = 2975,
protocols = 2/10/4 (gcs/repl/appl),
vote policy= 0,
group UUID = 2991f091-a80a-11ec-adf1-7a3e34aaf7bd
2022-03-20 6:55:27 0 [Note] WSREP: Flow-control interval: [28, 28]
2022-03-20 6:55:27 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 3115)
2022-03-20 6:55:27 2 [Note] WSREP: ####### processing CC 3115, local, ordered
2022-03-20 6:55:27 2 [Note] WSREP: Process first view: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd my uuid: b7e9c0dd-a81a-11ec-936c-8ae303a9d2f3
2022-03-20 6:55:27 2 [Note] WSREP: Server onap-mariadb-galera-1 connected to cluster at position 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3115 with ID b7e9c0dd-a81a-11ec-936c-8ae303a9d2f3
2022-03-20 6:55:27 2 [Note] WSREP: Server status change disconnected -> connected
2022-03-20 6:55:27 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:55:27 2 [Note] WSREP: ####### My UUID: b7e9c0dd-a81a-11ec-936c-8ae303a9d2f3
2022-03-20 6:55:27 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes
2022-03-20 6:55:27 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:55:27 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2022-03-20 6:55:27 2 [Note] WSREP: State transfer required:
Group state: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3115
Local state: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113
2022-03-20 6:55:27 2 [Note] WSREP: Server status change connected -> joiner
2022-03-20 6:55:27 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:55:27 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '10.233.72.5' --datadir '/bitnami/mariadb/data/' --defaults-file '/opt/bitnami/mariadb/conf/my.cnf' --parent '1' --binlog 'mysql-bin' --mysqld-args --defaults-file=/opt/bitnami/mariadb/conf/my.cnf --basedir=/opt/bitnami/mariadb --datadir=/bitnami/mariadb/data --socket=/opt/bitnami/mariadb/tmp/mysql.sock --pid-file=/opt/bitnami/mariadb/tmp/mysqld.pid'
2022-03-20 6:55:27 0 [Note] WSREP: Joiner monitor thread started to monitor
WSREP_SST: [INFO] SSL configuration: CA='', CERT='', KEY='', MODE='DISABLED', encrypt='0' (20220320 06:55:28.051)
2022-03-20 6:55:28 0 [Note] WSREP: (b7e9c0dd-936c, 'tcp://0.0.0.0:4567') turning message relay requesting off
WSREP_SST: [INFO] Streaming with mbstream (20220320 06:55:28.968)
WSREP_SST: [INFO] Using socat as streamer (20220320 06:55:28.994)
WSREP_SST: [INFO] Evaluating timeout -k 310 300 socat -u TCP-LISTEN:4444,reuseaddr stdio | '/opt/bitnami/mariadb//bin/mbstream' -x; RC=( ${PIPESTATUS[@]} ) (20220320 06:55:29.631)
2022-03-20 6:55:30 2 [Note] WSREP: ####### IST uuid:2991f091-a80a-11ec-adf1-7a3e34aaf7bd f: 3114, l: 3115, STRv: 3
2022-03-20 6:55:30 2 [Note] WSREP: IST receiver addr using tcp://10.233.72.5:4568
2022-03-20 6:55:30 2 [Note] WSREP: Prepared IST receiver for 3114-3115, listening at: tcp://10.233.72.5:4568
2022-03-20 6:55:30 0 [Note] WSREP: Member 2.0 (onap-mariadb-galera-1) requested state transfer from '*any*'. Selected 1.0 (onap-mariadb-galera-2)(SYNCED) as donor.
2022-03-20 6:55:30 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 3115)
2022-03-20 6:55:30 2 [Note] WSREP: Requesting state transfer: success, donor: 1
2022-03-20 6:55:32 0 [Note] WSREP: 1.0 (onap-mariadb-galera-2): State transfer to 2.0 (onap-mariadb-galera-1) complete.
2022-03-20 6:55:32 0 [Note] WSREP: Member 1.0 (onap-mariadb-galera-2) synced with group.
WSREP_SST: [INFO] 'xtrabackup_ist' received from donor: Running IST (20220320 06:55:32.183)
WSREP_SST: [INFO] Galera co-ords from recovery: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113 0 (20220320 06:55:32.222)
WSREP_SST: [INFO] Total time on joiner: 0 seconds (20220320 06:55:32.269)
WSREP_SST: [INFO] Removing the sst_in_progress file (20220320 06:55:32.288)
WSREP_SST: [INFO] Cleaning up temporary directories (20220320 06:55:32.379)
2022-03-20 6:55:32 3 [Note] WSREP: SST received
2022-03-20 6:55:32 3 [Note] WSREP: Server status change joiner -> initializing
2022-03-20 6:55:32 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:55:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-20 6:55:32 0 [Note] InnoDB: Number of pools: 1
2022-03-20 6:55:32 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-20 6:55:32 0 [Note] InnoDB: Using Linux native AIO
2022-03-20 6:55:32 0 [Note] InnoDB: Initializing buffer pool, total size = 2147483648, chunk size = 134217728
2022-03-20 6:55:32 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-20 6:55:33 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 134217728 bytes
2022-03-20 6:55:36 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2022-03-20 6:55:36 0 [Note] InnoDB: New log file created, LSN=33928020
2022-03-20 6:55:37 0 [Note] InnoDB: 128 rollback segments are active.
2022-03-20 6:55:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-03-20 6:55:42 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-03-20 6:56:11 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-03-20 6:56:11 0 [Note] InnoDB: 10.6.5 started; log sequence number 0; transaction id 7423
2022-03-20 6:56:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-20 6:56:11 0 [Note] InnoDB: Loading buffer pool(s) from /bitnami/mariadb/data/ib_buffer_pool
2022-03-20 6:56:11 0 [Warning] 'innodb-log-files-in-group' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2022-03-20 6:56:11 0 [Warning] 'innodb-file-format' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
/opt/bitnami/mariadb/sbin/mysqld, Version: 10.6.5-MariaDB-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /opt/bitnami/mariadb/tmp/mysql.sock
Time Id Command Argument
2022-03-20 6:56:11 0 [Note] InnoDB: Buffer pool(s) load completed at 220320 6:56:11
2022-03-20 6:56:11 0 [Note] Server socket created on IP: '0.0.0.0'.
2022-03-20 6:56:11 0 [Warning] 'proxies_priv' entry '@% root@onap-mariadb-galera-0' ignored in --skip-name-resolve mode.
2022-03-20 6:56:12 0 [Note] WSREP: wsrep_init_schema_and_SR 0x0
2022-03-20 6:56:13 0 [Note] WSREP: Server initialized
2022-03-20 6:56:13 0 [Note] WSREP: Server status change initializing -> initialized
2022-03-20 6:56:13 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:56:13 3 [Note] WSREP: Server status change initialized -> joined
2022-03-20 6:56:13 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:56:13 3 [Note] WSREP: Recovered position from storage: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113
2022-03-20 6:56:13 7 [Note] WSREP: Starting applier thread 7
2022-03-20 6:56:13 6 [Note] WSREP: Starting applier thread 6
2022-03-20 6:56:13 8 [Note] WSREP: Starting applier thread 8
2022-03-20 6:56:13 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: ready for connections.
Version: '10.6.5-MariaDB-log' socket: '/opt/bitnami/mariadb/tmp/mysql.sock' port: 3306 Source distribution
2022-03-20 6:56:13 3 [Note] WSREP: Recovered view from SST:
id: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113
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: 33816075-a80a-11ec-aea3-aea6c9ff5092, onap-mariadb-galera-0
1: 4e600f64-a810-11ec-ae49-22874bf67cb3, onap-mariadb-galera-2
2: 55d66db0-a81a-11ec-9f8c-b3c3dcdbf38f, onap-mariadb-galera-1
2022-03-20 6:56:13 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:56:13 11 [Note] WSREP: Recovered cluster id 2991f091-a80a-11ec-adf1-7a3e34aaf7bd
2022-03-20 6:56:13 3 [Note] WSREP: SST received: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113
2022-03-20 6:56:13 3 [Note] WSREP: SST succeeded for position 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113
2022-03-20 6:56:13 2 [Note] WSREP: Installed new state from SST: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3113
2022-03-20 6:56:13 0 [Note] WSREP: Joiner monitor thread ended with total time 46 sec
2022-03-20 6:56:13 2 [Note] WSREP: Receiving IST: 2 writesets, seqnos 3114-3115
2022-03-20 6:56:13 0 [Note] WSREP: ####### IST applying starts with 3114
2022-03-20 6:56:13 0 [Note] WSREP: ####### IST current seqno initialized to 2976
2022-03-20 6:56:13 0 [Note] WSREP: Receiving IST... 0.0% ( 0/140 events) complete.
2022-03-20 6:56:13 0 [Note] WSREP: IST preload starting at 2976
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:2975, protocol version: 5
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3096 -> 3097
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3097 -> 3098
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3098 -> 3099
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3099 -> 3100
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3100 -> 3101
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3101 -> 3102
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3102 -> 3103
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3103 -> 3104
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3104 -> 3105
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3105 -> 3106
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3106 -> 3107
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3107 -> 3108
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3108 -> 3109
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3109 -> 3110
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3110 -> 3111
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3111 -> 3112
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3112 -> 3113
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from preload: 2976
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3113 -> 3114
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from ist: 2976
2022-03-20 6:56:13 7 [Note] WSREP: ================================================
View:
id: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3114
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: 33816075-a80a-11ec-aea3-aea6c9ff5092, onap-mariadb-galera-0
1: 4e600f64-a810-11ec-ae49-22874bf67cb3, onap-mariadb-galera-2
=================================================
2022-03-20 6:56:13 7 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:56:13 0 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-20 6:56:13 0 [Note] WSREP: ####### Adjusting cert position: 3114 -> 3115
2022-03-20 6:56:13 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:56:13 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Min available from gcache for CC from ist: 2976
2022-03-20 6:56:13 0 [Note] WSREP: Receiving IST...100.0% (140/140 events) complete.
2022-03-20 6:56:13 8 [Note] WSREP: ================================================
View:
id: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3115
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: 33816075-a80a-11ec-aea3-aea6c9ff5092, onap-mariadb-galera-0
1: 4e600f64-a810-11ec-ae49-22874bf67cb3, onap-mariadb-galera-2
2: b7e9c0dd-a81a-11ec-936c-8ae303a9d2f3, onap-mariadb-galera-1
=================================================
2022-03-20 6:56:13 8 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:56:13 2 [Note] WSREP: Draining apply monitors after IST up to 3115
2022-03-20 6:56:13 2 [Note] WSREP: IST received: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3115
2022-03-20 6:56:13 2 [Note] WSREP: Lowest cert index boundary for CC from sst: 2976
2022-03-20 6:56:13 2 [Note] WSREP: Min available from gcache for CC from sst: 2976
2022-03-20 6:56:13 0 [Note] WSREP: 2.0 (onap-mariadb-galera-1): State transfer from 1.0 (onap-mariadb-galera-2) complete.
2022-03-20 6:56:13 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 3115)
2022-03-20 6:56:13 0 [Note] WSREP: Member 2.0 (onap-mariadb-galera-1) synced with group.
2022-03-20 6:56:13 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3115)
2022-03-20 6:56:13 8 [Note] WSREP: Server onap-mariadb-galera-1 synced with group
2022-03-20 6:56:13 8 [Note] WSREP: Server status change joined -> synced
2022-03-20 6:56:13 8 [Note] WSREP: Synchronized with group, ready for connections
2022-03-20 6:56:13 8 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
# Time: 220320 6:56:15
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 12 Schema: QC_hit: No
# Query_time: 0.003420 Lock_time: 0.003181 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759375;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 12 Schema: QC_hit: No
# Query_time: 0.009347 Lock_time: 0.009072 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759375;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 13 Schema: QC_hit: No
# Query_time: 0.014928 Lock_time: 0.014707 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759375;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 13 Schema: QC_hit: No
# Query_time: 0.001200 Lock_time: 0.001040 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759375;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220320 6:56:25
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 17 Schema: QC_hit: No
# Query_time: 0.014564 Lock_time: 0.014057 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759385;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 18 Schema: QC_hit: No
# Query_time: 0.008677 Lock_time: 0.008231 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759385;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 17 Schema: QC_hit: No
# Query_time: 0.006266 Lock_time: 0.005666 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759385;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 18 Schema: QC_hit: No
# Query_time: 0.007637 Lock_time: 0.006909 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759385;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220320 6:56:31
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 21 Schema: QC_hit: No
# Query_time: 0.000737 Lock_time: 0.000359 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759391;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 21 Schema: QC_hit: No
# Query_time: 0.000608 Lock_time: 0.000396 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759391;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220320 6:56:34
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 22 Schema: QC_hit: No
# Query_time: 0.011252 Lock_time: 0.010969 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759394;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 22 Schema: QC_hit: No
# Query_time: 0.000724 Lock_time: 0.000483 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759394;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220320 6:56:35
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 23 Schema: QC_hit: No
# Query_time: 0.000497 Lock_time: 0.000298 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759395;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 23 Schema: QC_hit: No
# Query_time: 0.000240 Lock_time: 0.000159 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759395;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220320 6:56:45
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 27 Schema: QC_hit: No
# Query_time: 0.000571 Lock_time: 0.000327 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759405;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 27 Schema: QC_hit: No
# Query_time: 0.000525 Lock_time: 0.000326 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759405;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 26 Schema: QC_hit: No
# Query_time: 0.000517 Lock_time: 0.000291 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759405;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 26 Schema: QC_hit: No
# Query_time: 0.000244 Lock_time: 0.000165 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759405;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220320 6:56:55
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 30 Schema: QC_hit: No
# Query_time: 0.000540 Lock_time: 0.000317 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759415;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 30 Schema: QC_hit: No
# Query_time: 0.000823 Lock_time: 0.000272 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759415;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 31 Schema: QC_hit: No
# Query_time: 0.006941 Lock_time: 0.006849 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759415;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 31 Schema: QC_hit: No
# Query_time: 0.001071 Lock_time: 0.000861 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759415;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220320 6:57:01
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 34 Schema: QC_hit: No
# Query_time: 0.002690 Lock_time: 0.002414 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759421;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 34 Schema: QC_hit: No
# Query_time: 0.005796 Lock_time: 0.005421 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759421;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220320 6:57:05
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 36 Schema: QC_hit: No
# Query_time: 0.001067 Lock_time: 0.000860 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759425;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 35 Schema: QC_hit: No
# Query_time: 0.009159 Lock_time: 0.008942 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647759425;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 36 Schema: QC_hit: No
# Query_time: 0.005104 Lock_time: 0.004888 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759425;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 35 Schema: QC_hit: No
# Query_time: 0.002905 Lock_time: 0.002665 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647759425;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
2022-03-20 6:57:05 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (initiated by: unknown): Normal shutdown
2022-03-20 6:57:05 0 [Note] WSREP: Shutdown replication
2022-03-20 6:57:05 0 [Note] WSREP: Server status change synced -> disconnecting
2022-03-20 6:57:05 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:57:05 0 [Note] WSREP: Closing send monitor...
2022-03-20 6:57:05 0 [Note] WSREP: Closed send monitor.
2022-03-20 6:57:05 0 [Note] WSREP: gcomm: terminating thread
2022-03-20 6:57:05 0 [Note] WSREP: gcomm: joining thread
2022-03-20 6:57:05 0 [Note] WSREP: gcomm: closing backend
2022-03-20 6:57:06 0 [Note] WSREP: view(view_id(NON_PRIM,33816075-aea3,41) memb {
b7e9c0dd-936c,0
} joined {
} left {
} partitioned {
33816075-aea3,0
4e600f64-ae49,0
})
2022-03-20 6:57:06 0 [Note] WSREP: PC protocol downgrade 1 -> 0
2022-03-20 6:57:06 0 [Note] WSREP: view((empty))
2022-03-20 6:57:06 0 [Note] WSREP: gcomm: closed
2022-03-20 6:57:06 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
2022-03-20 6:57:06 0 [Note] WSREP: Flow-control interval: [16, 16]
2022-03-20 6:57:06 0 [Note] WSREP: Received NON-PRIMARY.
2022-03-20 6:57:06 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 3115)
2022-03-20 6:57:06 0 [Note] WSREP: New SELF-LEAVE.
2022-03-20 6:57:06 0 [Note] WSREP: Flow-control interval: [0, 0]
2022-03-20 6:57:06 0 [Note] WSREP: Received SELF-LEAVE. Closing connection.
2022-03-20 6:57:06 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 3115)
2022-03-20 6:57:06 0 [Note] WSREP: RECV thread exiting 0: Success
2022-03-20 6:57:06 0 [Note] WSREP: recv_thread() joined.
2022-03-20 6:57:06 0 [Note] WSREP: Closing replication queue.
2022-03-20 6:57:06 0 [Note] WSREP: Closing slave action queue.
2022-03-20 6:57:06 8 [Note] WSREP: ================================================
View:
id: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3115
status: non-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: b7e9c0dd-a81a-11ec-936c-8ae303a9d2f3, onap-mariadb-galera-1
=================================================
2022-03-20 6:57:06 8 [Note] WSREP: Non-primary view
2022-03-20 6:57:06 8 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:57:06 8 [Note] WSREP: ================================================
View:
id: 2991f091-a80a-11ec-adf1-7a3e34aaf7bd:3115
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):
=================================================
2022-03-20 6:57:06 8 [Note] WSREP: Non-primary view
2022-03-20 6:57:06 8 [Note] WSREP: Server status change disconnecting -> disconnected
2022-03-20 6:57:06 8 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:57:06 8 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-20 6:57:06 2 [Note] WSREP: Applier thread exiting ret: 6 thd: 2
2022-03-20 6:57:06 7 [Note] WSREP: Applier thread exiting ret: 6 thd: 7
2022-03-20 6:57:06 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2022-03-20 6:57:06 7 [Warning] Aborted connection 7 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2022-03-20 6:57:06 6 [Note] WSREP: Applier thread exiting ret: 6 thd: 6
2022-03-20 6:57:06 6 [Warning] Aborted connection 6 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2022-03-20 6:57:06 8 [Note] WSREP: Applier thread exiting ret: 0 thd: 8
2022-03-20 6:57:06 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2022-03-20 6:57:06 1 [Note] WSREP: rollbacker thread exiting 1
2022-03-20 6:57:06 1 [Warning] Aborted connection 1 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2022-03-20 6:57:06 0 [Note] WSREP: dtor state: CLOSED
2022-03-20 6:57:06 0 [Note] WSREP: MemPool(TrxHandleSlave): hit ratio: 0, misses: 121, in use: 121, in pool: 0
2022-03-20 6:57:06 0 [Note] WSREP: mon: entered 2 oooe fraction 0 oool fraction 0
2022-03-20 6:57:06 0 [Note] WSREP: mon: entered 2 oooe fraction 0 oool fraction 0
2022-03-20 6:57:06 0 [Note] WSREP: mon: entered 5 oooe fraction 0 oool fraction 0.2
2022-03-20 6:57:06 0 [Note] WSREP: cert index usage at exit 552
2022-03-20 6:57:06 0 [Note] WSREP: cert trx map usage at exit 121
2022-03-20 6:57:06 0 [Note] WSREP: deps set usage at exit 0
2022-03-20 6:57:06 0 [Note] WSREP: avg deps dist 39.4215
2022-03-20 6:57:06 0 [Note] WSREP: avg cert interval 3036
2022-03-20 6:57:06 0 [Note] WSREP: cert index size 552
2022-03-20 6:57:06 0 [Note] WSREP: Service thread queue flushed.
2022-03-20 6:57:06 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0
2022-03-20 6:57:06 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0
2022-03-20 6:57:06 0 [Note] WSREP: Flushing memory map to disk...
2022-03-20 6:57:06 0 [Note] InnoDB: FTS optimize thread exiting.
2022-03-20 6:57:06 0 [Note] InnoDB: Starting shutdown...
2022-03-20 6:57:06 0 [Note] InnoDB: Dumping buffer pool(s) to /bitnami/mariadb/data/ib_buffer_pool
2022-03-20 6:57:06 0 [Note] InnoDB: Buffer pool(s) dump completed at 220320 6:57:06
2022-03-20 6:57:06 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2022-03-20 6:57:06 0 [Note] InnoDB: Shutdown completed; log sequence number 33930468; transaction id 7432
2022-03-20 6:57:06 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: Shutdown complete