By type
[38;5;6mmariadb [38;5;5m06:27:58.87 [0m
[38;5;6mmariadb [38;5;5m06:27:58.89 [0m[1mWelcome to the Bitnami mariadb-galera container[0m
[38;5;6mmariadb [38;5;5m06:27:58.91 [0mSubscribe to project updates by watching [1mhttps://github.com/bitnami/bitnami-docker-mariadb-galera[0m
[38;5;6mmariadb [38;5;5m06:27:58.93 [0mSubmit issues and feature requests at [1mhttps://github.com/bitnami/bitnami-docker-mariadb-galera/issues[0m
[38;5;6mmariadb [38;5;5m06:27:58.95 [0m
[38;5;6mmariadb [38;5;5m06:27:58.99 [0m[38;5;2mINFO [0m ==> ** Starting MariaDB setup **
[38;5;6mmariadb [38;5;5m06:27:59.09 [0m[38;5;2mINFO [0m ==> Validating settings in MYSQL_*/MARIADB_* env vars
[38;5;6mmariadb [38;5;5m06:27:59.39 [0m[38;5;2mINFO [0m ==> Initializing mariadb database
[38;5;6mmariadb [38;5;5m06:27:59.41 [0m[38;5;5mDEBUG[0m ==> Ensuring expected directories/files exist
[38;5;6mmariadb [38;5;5m06:27:59.53 [0m[38;5;2mINFO [0m ==> Updating 'my.cnf' with custom configuration
[38;5;6mmariadb [38;5;5m06:27:59.57 [0m[38;5;2mINFO [0m ==> Setting user option
[38;5;6mmariadb [38;5;5m06:27:59.58 [0m[38;5;5mDEBUG[0m ==> Setting user to 'sdnctl' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:27:59.82 [0m[38;5;2mINFO [0m ==> Setting wsrep_node_name option
[38;5;6mmariadb [38;5;5m06:27:59.84 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_node_name to 'onap-cds-db-0' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:27:59.88 [0m[38;5;2mINFO [0m ==> Setting wsrep_node_address option
[38;5;6mmariadb [38;5;5m06:27:59.90 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_node_address to '10.233.69.148' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:28:00.40 [0m[38;5;2mINFO [0m ==> Setting wsrep_sst_auth option
[38;5;6mmariadb [38;5;5m06:28:00.44 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_sst_auth to 'mariabackup:NjJ3sjd3' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:28:01.09 [0m[38;5;2mINFO [0m ==> Persisted data detected. Restoring
[38;5;6mmariadb [38;5;5m06:28:01.37 [0m[38;5;2mINFO [0m ==> ** MariaDB setup finished! **
[38;5;6mmariadb [38;5;5m06:28:01.61 [0m[38;5;2mINFO [0m ==> ** Starting MariaDB **
[38;5;6mmariadb [38;5;5m06:28:01.64 [0m[38;5;2mINFO [0m ==> Setting previous boot
2022-04-19 6:28:01 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (mysqld 10.5.8-MariaDB-log) starting as process 1 ...
2022-04-19 6:28:01 0 [Note] WSREP: Loading provider /opt/bitnami/mariadb/lib/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
2022-04-19 6:28:01 0 [Note] WSREP: wsrep_load(): loading provider library '/opt/bitnami/mariadb/lib/libgalera_smm.so'
2022-04-19 6:28:01 0 [Note] WSREP: wsrep_load(): Galera 4.7(rXXXX) by Codership Oy loaded successfully.
2022-04-19 6:28:01 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2022-04-19 6:28:01 0 [Note] WSREP: Found saved state: 5a13ca11-bf99-11ec-907b-8a0b3bb3ad57:15, safe_to_bootstrap: 1
2022-04-19 6:28:01 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 2
UUID: 5a13ca11-bf99-11ec-907b-8a0b3bb3ad57
Seqno: 1 - 15
Offset: 1280
Synced: 1
2022-04-19 6:28:01 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 5a13ca11-bf99-11ec-907b-8a0b3bb3ad57, offset: 1280
2022-04-19 6:28:01 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/134217752 bytes) complete.
2022-04-19 6:28:01 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete.
2022-04-19 6:28:01 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 1-15
2022-04-19 6:28:01 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/7024 bytes) complete.
2022-04-19 6:28:01 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (7024/7024 bytes) complete.
2022-04-19 6:28:01 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 0/15 locked buffers
2022-04-19 6:28:01 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): free space: 134210704/134217728
2022-04-19 6:28:01 0 [Note] WSREP: Passing config to GCS: base_dir = /bitnami/mariadb/data/; base_host = 10.233.69.148; 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;
2022-04-19 6:28:01 0 [Note] WSREP: Service thread queue flushed.
2022-04-19 6:28:01 0 [Note] WSREP: ####### Assign initial position for certification: 5a13ca11-bf99-11ec-907b-8a0b3bb3ad57:15, protocol version: -1
2022-04-19 6:28:01 0 [Note] WSREP: Start replication
2022-04-19 6:28:01 0 [Note] WSREP: Connecting with bootstrap option: 1
2022-04-19 6:28:01 0 [Note] WSREP: Setting GCS initial position to 5a13ca11-bf99-11ec-907b-8a0b3bb3ad57:15
2022-04-19 6:28:01 0 [Note] WSREP: protonet asio version 0
2022-04-19 6:28:01 0 [Note] WSREP: Using CRC-32C for message checksums.
2022-04-19 6:28:01 0 [Note] WSREP: backend: asio
2022-04-19 6:28:01 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2022-04-19 6:28:01 0 [Warning] WSREP: access file(/bitnami/mariadb/data//gvwstate.dat) failed(No such file or directory)
2022-04-19 6:28:01 0 [Note] WSREP: restore pc from disk failed
2022-04-19 6:28:01 0 [Note] WSREP: GMCast version 0
2022-04-19 6:28:01 0 [Note] WSREP: (dcf5c85f-9557, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2022-04-19 6:28:01 0 [Note] WSREP: (dcf5c85f-9557, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2022-04-19 6:28:01 0 [Note] WSREP: EVS version 1
2022-04-19 6:28:01 0 [Note] WSREP: gcomm: bootstrapping new group 'galera'
2022-04-19 6:28:01 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery
2022-04-19 6:28:01 0 [Note] WSREP: EVS version upgrade 0 -> 1
2022-04-19 6:28:01 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2022-04-19 6:28:01 0 [Note] WSREP: Node dcf5c85f-9557 state prim
2022-04-19 6:28:01 0 [Note] WSREP: view(view_id(PRIM,dcf5c85f-9557,1) memb {
dcf5c85f-9557,0
} joined {
} left {
} partitioned {
})
2022-04-19 6:28:01 0 [Note] WSREP: save pc into disk
2022-04-19 6:28:01 0 [Note] WSREP: gcomm: connected
2022-04-19 6:28:01 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2022-04-19 6:28:01 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2022-04-19 6:28:01 0 [Note] WSREP: Opened channel 'galera'
2022-04-19 6:28:01 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2022-04-19 6:28:01 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: dcf82f63-bfa9-11ec-8e49-5becbd57eab5
2022-04-19 6:28:01 0 [Note] WSREP: STATE EXCHANGE: sent state msg: dcf82f63-bfa9-11ec-8e49-5becbd57eab5
2022-04-19 6:28:01 0 [Note] WSREP: STATE EXCHANGE: got state msg: dcf82f63-bfa9-11ec-8e49-5becbd57eab5 from 0 (onap-cds-db-0)
2022-04-19 6:28:01 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 0,
members = 1/1 (joined/total),
act_id = 15,
last_appl. = 15,
protocols = 2/10/4 (gcs/repl/appl),
vote policy= 0,
group UUID = 5a13ca11-bf99-11ec-907b-8a0b3bb3ad57
2022-04-19 6:28:01 0 [Note] WSREP: Flow-control interval: [16, 16]
2022-04-19 6:28:01 0 [Note] WSREP: Restored state OPEN -> JOINED (16)
2022-04-19 6:28:01 0 [Note] WSREP: Member 0.0 (onap-cds-db-0) synced with group.
2022-04-19 6:28:01 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 16)
2022-04-19 6:28:01 1 [Note] WSREP: Starting rollbacker thread 1
2022-04-19 6:28:01 2 [Note] WSREP: Starting applier thread 2
2022-04-19 6:28:01 2 [Note] WSREP: ####### processing CC 16, local, ordered
2022-04-19 6:28:01 2 [Note] WSREP: Process first view: 5a13ca11-bf99-11ec-907b-8a0b3bb3ad57 my uuid: dcf5c85f-bfa9-11ec-9557-0eb767e7e871
2022-04-19 6:28:01 2 [Note] WSREP: Server onap-cds-db-0 connected to cluster at position 5a13ca11-bf99-11ec-907b-8a0b3bb3ad57:16 with ID dcf5c85f-bfa9-11ec-9557-0eb767e7e871
2022-04-19 6:28:01 2 [Note] WSREP: Server status change disconnected -> connected
2022-04-19 6:28:01 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-19 6:28:01 2 [Note] WSREP: ####### My UUID: dcf5c85f-bfa9-11ec-9557-0eb767e7e871
2022-04-19 6:28:01 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: no
2022-04-19 6:28:01 0 [Note] WSREP: Service thread queue flushed.
2022-04-19 6:28:01 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2022-04-19 6:28:01 2 [Note] WSREP: REPL Protocols: 10 (5)
2022-04-19 6:28:01 2 [Note] WSREP: ####### Adjusting cert position: -1 -> 16
2022-04-19 6:28:01 0 [Note] WSREP: Service thread queue flushed.
2022-04-19 6:28:01 2 [Note] WSREP: ================================================
View:
id: 5a13ca11-bf99-11ec-907b-8a0b3bb3ad57:16
status: primary
protocol_version: 4
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
final: no
own_index: 0
members(1):
0: dcf5c85f-bfa9-11ec-9557-0eb767e7e871, onap-cds-db-0
=================================================
2022-04-19 6:28:01 2 [Note] WSREP: Server status change connected -> joiner
2022-04-19 6:28:01 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-19 6:28:01 2 [Note] WSREP: Server status change joiner -> initializing
2022-04-19 6:28:01 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-19 6:28:01 0 [Warning] The parameter innodb_file_format is deprecated and has no effect. It may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/
2022-04-19 6:28:01 0 [Warning] The parameter innodb_log_files_in_group is deprecated and has no effect.
2022-04-19 6:28:01 0 [Note] InnoDB: Using Linux native AIO
2022-04-19 6:28:01 0 [Note] InnoDB: Uses event mutexes
2022-04-19 6:28:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-04-19 6:28:01 0 [Note] InnoDB: Number of pools: 1
2022-04-19 6:28:01 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-04-19 6:28:01 0 [Note] mysqld: O_TMPFILE is not supported on /opt/bitnami/mariadb/tmp (disabling future attempts)
2022-04-19 6:28:02 0 [Note] InnoDB: Initializing buffer pool, total size = 2147483648, chunk size = 134217728
2022-04-19 6:28:02 0 [Note] InnoDB: Completed initialization of buffer pool
2022-04-19 6:28:02 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-04-19 6:28:02 0 [Note] InnoDB: 128 rollback segments are active.
2022-04-19 6:28:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-04-19 6:28:02 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-04-19 6:28:08 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-04-19 6:28:08 0 [Note] InnoDB: 10.5.8 started; log sequence number 75232; transaction id 60
2022-04-19 6:28:08 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-04-19 6:28:08 0 [Note] InnoDB: Loading buffer pool(s) from /bitnami/mariadb/data/ib_buffer_pool
/opt/bitnami/mariadb/sbin/mysqld, Version: 10.5.8-MariaDB-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /opt/bitnami/mariadb/tmp/mysql.sock
Time Id Command Argument
2022-04-19 6:28:09 0 [Note] Server socket created on IP: '0.0.0.0'.
2022-04-19 6:28:09 0 [Note] InnoDB: Buffer pool(s) load completed at 220419 6:28:09
2022-04-19 6:28:09 0 [Warning] 'proxies_priv' entry '@% root@onap-cds-db-0' ignored in --skip-name-resolve mode.
2022-04-19 6:28:09 0 [Note] WSREP: wsrep_init_schema_and_SR 0x0
2022-04-19 6:28:09 0 [Note] WSREP: Server initialized
2022-04-19 6:28:09 0 [Note] WSREP: Server status change initializing -> initialized
2022-04-19 6:28:09 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-19 6:28:09 2 [Note] WSREP: Bootstrapping a new cluster, setting initial position to 00000000-0000-0000-0000-000000000000:-1
2022-04-19 6:28:09 7 [Note] WSREP: Starting applier thread 7
2022-04-19 6:28:09 8 [Note] WSREP: Starting applier thread 8
2022-04-19 6:28:09 6 [Note] WSREP: Starting applier thread 6
2022-04-19 6:28:09 5 [Note] WSREP: Recovered cluster id 5a13ca11-bf99-11ec-907b-8a0b3bb3ad57
2022-04-19 6:28:09 0 [Note] Reading of all Master_info entries succeeded
2022-04-19 6:28:09 0 [Note] Added new Master_info '' to hash table
2022-04-19 6:28:09 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: ready for connections.
Version: '10.5.8-MariaDB-log' socket: '/opt/bitnami/mariadb/tmp/mysql.sock' port: 3306 Source distribution
2022-04-19 6:28:09 2 [Note] WSREP: Server status change initialized -> joined
2022-04-19 6:28:09 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-19 6:28:09 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-19 6:28:09 2 [Note] WSREP: Lowest cert index boundary for CC from group: 16
2022-04-19 6:28:09 2 [Note] WSREP: Min available from gcache for CC from group: 1
2022-04-19 6:28:09 2 [Note] WSREP: Server onap-cds-db-0 synced with group
2022-04-19 6:28:09 2 [Note] WSREP: Server status change joined -> synced
2022-04-19 6:28:09 2 [Note] WSREP: Synchronized with group, ready for connections
2022-04-19 6:28:09 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
# Time: 220419 6:28:14
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 11 Schema: QC_hit: No
# Query_time: 0.000400 Lock_time: 0.000168 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650349694;
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: 11 Schema: QC_hit: No
# Query_time: 0.000122 Lock_time: 0.000063 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650349694;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220419 6:28:15
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 12 Schema: QC_hit: No
# Query_time: 0.000357 Lock_time: 0.000159 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650349695;
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: 12 Schema: QC_hit: No
# Query_time: 0.000143 Lock_time: 0.000075 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650349695;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220419 6:28:24
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 15 Schema: QC_hit: No
# Query_time: 0.000382 Lock_time: 0.000218 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650349704;
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: 16 Schema: QC_hit: No
# Query_time: 0.000267 Lock_time: 0.000166 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650349704;
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: 16 Schema: QC_hit: No
# Query_time: 0.000235 Lock_time: 0.000125 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650349704;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220419 6:28:25
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 15 Schema: QC_hit: No
# Query_time: 0.000405 Lock_time: 0.000196 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650349705;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220419 6:28:34
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 19 Schema: QC_hit: No
# Query_time: 0.000254 Lock_time: 0.000137 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650349714;
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: 20 Schema: QC_hit: No
# Query_time: 0.000209 Lock_time: 0.000098 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650349714;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220419 6:28:35
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 20 Schema: QC_hit: No
# Query_time: 0.000293 Lock_time: 0.000132 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650349715;
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: 19 Schema: QC_hit: No
# Query_time: 0.000243 Lock_time: 0.000121 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650349715;
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: 22 Schema: QC_hit: No
# Query_time: 0.000382 Lock_time: 0.000116 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650349715;
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.001037 Lock_time: 0.000601 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650349715;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220419 6:28:44
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 24 Schema: QC_hit: No
# Query_time: 0.000244 Lock_time: 0.000110 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650349724;
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: 25 Schema: QC_hit: No
# Query_time: 0.011506 Lock_time: 0.007614 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650349724;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220419 6:28:45
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 24 Schema: QC_hit: No
# Query_time: 0.001048 Lock_time: 0.000485 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650349725;
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: 25 Schema: QC_hit: No
# Query_time: 0.000312 Lock_time: 0.000152 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650349725;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220419 6:28:54
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 28 Schema: QC_hit: No
# Query_time: 0.000242 Lock_time: 0.000122 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650349734;
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: 28 Schema: QC_hit: No
# Query_time: 0.000168 Lock_time: 0.000108 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650349734;
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: 29 Schema: QC_hit: No
# Query_time: 0.000237 Lock_time: 0.000134 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650349734;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220419 6:28:55
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 29 Schema: QC_hit: No
# Query_time: 0.001055 Lock_time: 0.000371 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650349735;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220419 6:29:04
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 32 Schema: QC_hit: No
# Query_time: 0.035056 Lock_time: 0.034907 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650349744;
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: 33 Schema: QC_hit: No
# Query_time: 0.000289 Lock_time: 0.000133 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650349744;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220419 6:29:05
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 32 Schema: QC_hit: No
# Query_time: 0.000330 Lock_time: 0.000174 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650349745;
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: 33 Schema: QC_hit: No
# Query_time: 0.003861 Lock_time: 0.001497 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650349745;
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.000566 Lock_time: 0.000223 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650349745;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220419 6:29:06
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 35 Schema: QC_hit: No
# Query_time: 0.001469 Lock_time: 0.000721 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650349746;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220419 6:29:14
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 37 Schema: QC_hit: No
# Query_time: 0.000990 Lock_time: 0.000515 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650349754;
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: 38 Schema: QC_hit: No
# Query_time: 0.000246 Lock_time: 0.000116 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1650349754;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220419 6:29:15
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 38 Schema: QC_hit: No
# Query_time: 0.001349 Lock_time: 0.000587 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650349755;
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: 37 Schema: QC_hit: No
# Query_time: 0.000645 Lock_time: 0.000308 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1650349755;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
2022-04-19 6:29:16 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (initiated by: unknown): Normal shutdown
2022-04-19 6:29:16 0 [Note] WSREP: Shutdown replication
2022-04-19 6:29:16 0 [Note] WSREP: Server status change synced -> disconnecting
2022-04-19 6:29:16 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-19 6:29:16 0 [Note] WSREP: Closing send monitor...
2022-04-19 6:29:16 0 [Note] WSREP: Closed send monitor.
2022-04-19 6:29:16 0 [Note] WSREP: gcomm: terminating thread
2022-04-19 6:29:16 0 [Note] WSREP: gcomm: joining thread
2022-04-19 6:29:16 0 [Note] WSREP: gcomm: closing backend
2022-04-19 6:29:16 0 [Note] WSREP: PC protocol downgrade 1 -> 0
2022-04-19 6:29:16 0 [Note] WSREP: view((empty))
2022-04-19 6:29:16 0 [Note] WSREP: gcomm: closed
2022-04-19 6:29:16 0 [Note] WSREP: New SELF-LEAVE.
2022-04-19 6:29:16 0 [Note] WSREP: Flow-control interval: [0, 0]
2022-04-19 6:29:16 0 [Note] WSREP: Received SELF-LEAVE. Closing connection.
2022-04-19 6:29:16 0 [Note] WSREP: Shifting SYNCED -> CLOSED (TO: 16)
2022-04-19 6:29:16 0 [Note] WSREP: RECV thread exiting 0: Success
2022-04-19 6:29:16 0 [Note] WSREP: recv_thread() joined.
2022-04-19 6:29:16 0 [Note] WSREP: Closing replication queue.
2022-04-19 6:29:16 0 [Note] WSREP: Closing slave action queue.
2022-04-19 6:29:16 2 [Note] WSREP: ================================================
View:
id: 5a13ca11-bf99-11ec-907b-8a0b3bb3ad57:16
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-04-19 6:29:16 2 [Note] WSREP: Non-primary view
2022-04-19 6:29:16 2 [Note] WSREP: Server status change disconnecting -> disconnected
2022-04-19 6:29:16 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-19 6:29:16 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-04-19 6:29:16 2 [Note] WSREP: Applier thread exiting ret: 0 thd: 2
2022-04-19 6:29:16 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2022-04-19 6:29:16 6 [Note] WSREP: Applier thread exiting ret: 6 thd: 6
2022-04-19 6:29:16 6 [Warning] Aborted connection 6 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2022-04-19 6:29:16 7 [Note] WSREP: Applier thread exiting ret: 6 thd: 7
2022-04-19 6:29:16 7 [Warning] Aborted connection 7 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2022-04-19 6:29:16 8 [Note] WSREP: Applier thread exiting ret: 6 thd: 8
2022-04-19 6:29:16 1 [Note] WSREP: rollbacker thread exiting 1
2022-04-19 6:29:16 1 [Warning] Aborted connection 1 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2022-04-19 6:29:16 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2022-04-19 6:29:16 0 [Note] Event Scheduler: Purging the queue. 0 events
2022-04-19 6:29:16 0 [Note] WSREP: dtor state: CLOSED
2022-04-19 6:29:16 0 [Note] WSREP: MemPool(TrxHandleSlave): hit ratio: 0, misses: 0, in use: 0, in pool: 0
2022-04-19 6:29:16 0 [Note] WSREP: apply mon: entered 0
2022-04-19 6:29:16 0 [Note] WSREP: apply mon: entered 0
2022-04-19 6:29:16 0 [Note] WSREP: mon: entered 3 oooe fraction 0 oool fraction 0
2022-04-19 6:29:16 0 [Note] WSREP: cert index usage at exit 0
2022-04-19 6:29:16 0 [Note] WSREP: cert trx map usage at exit 0
2022-04-19 6:29:16 0 [Note] WSREP: deps set usage at exit 0
2022-04-19 6:29:16 0 [Note] WSREP: avg deps dist 0
2022-04-19 6:29:16 0 [Note] WSREP: avg cert interval 0
2022-04-19 6:29:16 0 [Note] WSREP: cert index size 0
2022-04-19 6:29:16 0 [Note] WSREP: Service thread queue flushed.
2022-04-19 6:29:16 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0
2022-04-19 6:29:16 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0
2022-04-19 6:29:16 0 [Note] WSREP: Flushing memory map to disk...
2022-04-19 6:29:16 0 [Note] InnoDB: FTS optimize thread exiting.
2022-04-19 6:29:16 0 [Note] InnoDB: Starting shutdown...
2022-04-19 6:29:16 0 [Note] InnoDB: Dumping buffer pool(s) to /bitnami/mariadb/data/ib_buffer_pool
2022-04-19 6:29:16 0 [Note] InnoDB: Buffer pool(s) dump completed at 220419 6:29:16
2022-04-19 6:29:18 0 [Note] InnoDB: Shutdown completed; log sequence number 80045; transaction id 75
2022-04-19 6:29:18 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-04-19 6:29:18 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: Shutdown complete