Hi Team,

we deployed the Dublin version of ONAP, we are facing the errors in 
mariadb-galera is in running state but not ready from over 17h...

[cid:1862ebe6-999f-41f4-9c30-d337c7128821]

Describe mariadb pod, it is giving below error.

[cid:fd02f0b8-faa6-42db-aa8a-084cb5273588]

PFA for the logs.

Please help us in this issue.


Thanks & Regards,
Thamlur Raju


============================================================================================================================
 Disclaimer: This message and the information contained herein is proprietary 
and confidential and subject to the Tech Mahindra policy statement, you may 
review the policy at http://www.techmahindra.com/Disclaimer.html externally 
http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra. 
============================================================================================================================

-=-=-=-=-=-=-=-=-=-=-=-
Links: You receive all messages sent to this group.

View/Reply Online (#19708): https://lists.onap.org/g/onap-discuss/message/19708
Mute This Topic: https://lists.onap.org/mt/69377239/21656
Group Owner: [email protected]
Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub  
[[email protected]]
-=-=-=-=-=-=-=-=-=-=-=-

root@onap-k8s-1:/home/ubuntu# kubectl logs -n onap 
dev-mariadb-galera-mariadb-galera-0
+ CONTAINER_SCRIPTS_DIR=/usr/share/container-scripts/mysql
+ EXTRA_DEFAULTS_FILE=/etc/my.cnf.d/galera.cnf
+ '[' -z onap ']'
+ echo 'Galera: Finding peers'
Galera: Finding peers
++ hostname -f
++ cut -d. -f2
+ K8S_SVC_NAME=mariadb-galera
+ echo 'Using service name: mariadb-galera'
+ cp /usr/share/container-scripts/mysql/galera.cnf /etc/my.cnf.d/galera.cnf
+ /usr/bin/peer-finder 
-on-start=/usr/share/container-scripts/mysql/configure-galera.sh 
-service=mariadb-galera
Using service name: mariadb-galera
2020/01/01 14:56:01 Peer list updated
was []
now [dev-mariadb-galera-mariadb-galera-0.mariadb-galera.onap.svc.cluster.local]
2020/01/01 14:56:01 execing: 
/usr/share/container-scripts/mysql/configure-galera.sh with stdin: 
dev-mariadb-galera-mariadb-galera-0.mariadb-galera.onap.svc.cluster.local
2020/01/01 14:56:01
2020/01/01 14:56:02 Peer finder exiting
+ '[' '!' -d /var/lib/mysql/mysql ']'
+ exec mysqld
2020-01-01 14:56:03 139807760627968 [Note] mysqld (mysqld 10.1.24-MariaDB) 
starting as process 1 ...
2020-01-01 14:56:03 139807760627968 [Note] WSREP: Read nil XID from storage 
engines, skipping position init
2020-01-01 14:56:03 139807760627968 [Note] WSREP: wsrep_load(): loading 
provider library '/usr/lib64/galera/libgalera_smm.so'
2020-01-01 14:56:03 139807760627968 [Note] WSREP: wsrep_load(): Galera 
25.3.20(r3703) by Codership Oy <[email protected]> loaded successfully.
2020-01-01 14:56:03 139807760627968 [Note] WSREP: CRC-32C: using hardware 
acceleration.
2020-01-01 14:56:03 139807760627968 [Note] WSREP: Found saved state: 
10a2b68a-2ca6-11ea-b2dc-ef07cd1923ee:0, safe_to_bootsrap: 1
2020-01-01 14:56:04 139807760627968 [Note] WSREP: Passing config to GCS: 
base_dir = /var/lib/mysql/; base_host = 
dev-mariadb-galera-mariadb-galera-0.mariadb-galera.onap.svc.cluster.local; 
base_port = 4567; cert.log_conflicts = no; 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 = 
/var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = 
/var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.recover = no; 
gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 
1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; 
gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; 
gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; 
gmcast.versi
2020-01-01 14:56:04 139807760627968 [Note] WSREP: Assign initial position for 
certification: 0, protocol version: -1
2020-01-01 14:56:04 139807760627968 [Note] WSREP: wsrep_sst_grab()
2020-01-01 14:56:04 139807760627968 [Note] WSREP: Start replication
2020-01-01 14:56:04 139807760627968 [Note] WSREP: Setting initial position to 
10a2b68a-2ca6-11ea-b2dc-ef07cd1923ee:0
2020-01-01 14:56:04 139807760627968 [Note] WSREP: protonet asio version 0
2020-01-01 14:56:04 139807760627968 [Note] WSREP: Using CRC-32C for message 
checksums.
2020-01-01 14:56:04 139807760627968 [Note] WSREP: backend: asio
2020-01-01 14:56:04 139807760627968 [Note] WSREP: gcomm thread scheduling 
priority set to other:0
2020-01-01 14:56:05 139807760627968 [Warning] WSREP: access 
file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2020-01-01 14:56:05 139807760627968 [Note] WSREP: restore pc from disk failed
2020-01-01 14:56:05 139807760627968 [Note] WSREP: GMCast version 0
2020-01-01 14:56:05 139807760627968 [Note] WSREP: (d5c7b3a6, 
'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2020-01-01 14:56:05 139807760627968 [Note] WSREP: (d5c7b3a6, 
'tcp://0.0.0.0:4567') multicast: , ttl: 1
2020-01-01 14:56:05 139807760627968 [Note] WSREP: EVS version 0
2020-01-01 14:56:05 139807760627968 [Note] WSREP: gcomm: connecting to group 
'mariadb-galera', peer ''
2020-01-01 14:56:05 139807760627968 [Note] WSREP: start_prim is enabled, turn 
off pc_recovery
2020-01-01 14:56:05 139807760627968 [Note] WSREP: Node d5c7b3a6 state prim
2020-01-01 14:56:05 139807760627968 [Note] WSREP: view(view_id(PRIM,d5c7b3a6,1) 
memb {
        d5c7b3a6,0
} joined {
} left {
} partitioned {
})
2020-01-01 14:56:05 139807760627968 [Note] WSREP: save pc into disk
2020-01-01 14:56:05 139807760627968 [Note] WSREP: gcomm: connected
2020-01-01 14:56:05 139807760627968 [Note] WSREP: Changing maximum packet size 
to 64500, resulting msg size: 32636
2020-01-01 14:56:05 139807760627968 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 
0)
2020-01-01 14:56:05 139807760627968 [Note] WSREP: Opened channel 
'mariadb-galera'
2020-01-01 14:56:05 139807760627968 [Note] WSREP: Waiting for SST to complete.
2020-01-01 14:56:05 139807439185664 [Note] WSREP: New COMPONENT: primary = yes, 
bootstrap = no, my_idx = 0, memb_num = 1
2020-01-01 14:56:05 139807439185664 [Note] WSREP: STATE_EXCHANGE: sent state 
UUID: d5d7f6d7-2ca6-11ea-b177-7ab5320ae61b
2020-01-01 14:56:05 139807439185664 [Note] WSREP: STATE EXCHANGE: sent state 
msg: d5d7f6d7-2ca6-11ea-b177-7ab5320ae61b
2020-01-01 14:56:05 139807439185664 [Note] WSREP: STATE EXCHANGE: got state 
msg: d5d7f6d7-2ca6-11ea-b177-7ab5320ae61b from 0 
(dev-mariadb-galera-mariadb-galera-0)
2020-01-01 14:56:05 139807439185664 [Note] WSREP: Quorum results:
        version    = 4,
        component  = PRIMARY,
        conf_id    = 0,
        members    = 1/1 (joined/total),
        act_id     = 0,
        last_appl. = -1,
        protocols  = 0/7/3 (gcs/repl/appl),
        group UUID = 10a2b68a-2ca6-11ea-b2dc-ef07cd1923ee
2020-01-01 14:56:05 139807439185664 [Note] WSREP: Flow-control interval: [16, 
16]
2020-01-01 14:56:05 139807439185664 [Note] WSREP: Restored state OPEN -> JOINED 
(0)
2020-01-01 14:56:05 139807439185664 [Note] WSREP: Member 0.0 
(dev-mariadb-galera-mariadb-galera-0) synced with group.
2020-01-01 14:56:05 139807439185664 [Note] WSREP: Shifting JOINED -> SYNCED 
(TO: 0)
2020-01-01 14:56:05 139807759260416 [Note] WSREP: New cluster view: global 
state: 10a2b68a-2ca6-11ea-b2dc-ef07cd1923ee:0, view# 1: Primary, number of 
nodes: 1, my index: 0, protocol version 3
2020-01-01 14:56:05 139807760627968 [Note] WSREP: SST complete, seqno: 0
2020-01-01 14:56:06 139807760627968 [Note] InnoDB: 
innodb_empty_free_list_algorithm has been changed to legacy because of small 
buffer pool size. In order to use backoff, increase buffer pool at least up to 
20MB.

2020-01-01 14:56:06 139807760627968 [Note] InnoDB: Using mutexes to ref count 
buffer pool pages
2020-01-01 14:56:06 139807760627968 [Note] InnoDB: The InnoDB memory heap is 
disabled
2020-01-01 14:56:06 139807760627968 [Note] InnoDB: Mutexes and rw_locks use GCC 
atomic builtins
2020-01-01 14:56:06 139807760627968 [Note] InnoDB: GCC builtin 
__atomic_thread_fence() is used for memory barrier
2020-01-01 14:56:06 139807760627968 [Note] InnoDB: Compressed tables use zlib 
1.2.7
2020-01-01 14:56:06 139807760627968 [Note] InnoDB: Using Linux native AIO
2020-01-01 14:56:06 139807760627968 [Note] InnoDB: Using SSE crc32 instructions
2020-01-01 14:56:06 139807760627968 [Note] InnoDB: Initializing buffer pool, 
size = 128.0M
2020-01-01 14:56:06 139807760627968 [Note] InnoDB: Completed initialization of 
buffer pool
2020-01-01 14:56:09 139807760627968 [Note] InnoDB: Highest supported file 
format is Barracuda.
2020-01-01 14:56:10 139807760627968 [Note] InnoDB: 128 rollback segment(s) are 
active.
2020-01-01 14:56:10 139807760627968 [Note] InnoDB: Waiting for purge to start
2020-01-01 14:56:10 139807760627968 [Note] InnoDB:  Percona XtraDB 
(http://www.percona.com) 5.6.36-82.0 started; log sequence number 1616999
2020-01-01 14:56:10 139807760627968 [Note] Plugin 'FEEDBACK' is disabled.
2020-01-01 14:56:10 139806755518208 [Note] InnoDB: Dumping buffer pool(s) not 
yet started
2020-01-01 14:56:11 139807760627968 [Note] Server socket created on IP: 
'0.0.0.0'.
2020-01-01 14:56:12 139807759260416 [Note] WSREP: wsrep_notify_cmd is not 
defined, skipping notification.
2020-01-01 14:56:12 139807759260416 [Note] WSREP: REPL Protocols: 7 (3, 2)
2020-01-01 14:56:12 139807759260416 [Note] WSREP: Assign initial position for 
certification: 0, protocol version: 3
2020-01-01 14:56:13 139807497905920 [Note] WSREP: Service thread queue flushed.
2020-01-01 14:56:13 139807759260416 [Note] WSREP: Synchronized with group, 
ready for connections
2020-01-01 14:56:13 139807759260416 [Note] WSREP: wsrep_notify_cmd is not 
defined, skipping notification.
2020-01-01 14:56:13 139807760627968 [Note] mysqld: ready for connections.
Version: '10.1.24-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  
MariaDB Server
2020-01-02  3:31:56 139807447578368 [Warning] WSREP: last inactive check more 
than PT1.5S ago (PT1.68365S), skipping check
root@onap-k8s-1:/home/ubuntu#

Reply via email to