Hi Yan,

Thank you for your suggestions.
I performed the steps that you suggested but it keeps with some different 
errors now.
Please see below:

onapit-vfc-vfc-mariadb-0 0/1 Running 1 15m

It looks like fails to perform the readiness probe:

Events:
Type Reason Age From Message
---- ------ ---- ---- -------
Normal Scheduled 5m31s default-scheduler Successfully assigned 
onap/onapit-vfc-vfc-mariadb-0 to k8s-worker2
Normal Pulling 5m30s kubelet, k8s-worker2 pulling image 
"nexus3.onap.org:10001/busybox"
Normal Pulled 5m28s kubelet, k8s-worker2 Successfully pulled image 
"nexus3.onap.org:10001/busybox"
Normal Created 5m28s kubelet, k8s-worker2 Created container
Normal Started 5m27s kubelet, k8s-worker2 Started container
Normal Pulling 5m11s (x2 over 5m26s) kubelet, k8s-worker2 pulling image 
"nexus3.onap.org:10001/adfinissygroup/k8s-mariadb-galera-centos:v0
02"
Normal Pulled 5m10s (x2 over 5m24s) kubelet, k8s-worker2 Successfully pulled 
image "nexus3.onap.org:10001/adfinissygroup/k8s-mariadb-gale
ra-centos:v002"
Normal Created 5m10s (x2 over 5m24s) kubelet, k8s-worker2 Created container
Normal Started 5m7s (x2 over 5m24s) kubelet, k8s-worker2 Started container
Warning Unhealthy 20s (x28 over 4m49s) kubelet, k8s-worker2 Readiness probe 
failed: ERROR 1045 (28000): Access denied for user 'readinessPro
be'@'localhost' (using password: YES)

>From the logs seems to be missing some tables such as  mysql.proxies_priv;:

2020-04-03 7:57:04 139670137862400 [Note] InnoDB: Restoring possible 
half-written data pages from the doublewrite buffer...
2020-04-03 7:57:04 139670137862400 [Note] InnoDB: 128 rollback segment(s) are 
active.
2020-04-03 7:57:04 139670137862400 [Note] InnoDB: Waiting for purge to start
2020-04-03 7:57:04 139670137862400 [Note] InnoDB: Percona XtraDB 
(http://www.percona.com) 5.6.36-82.0 started; log sequence number 1600709
2020-04-03 7:57:04 139669132015360 [Note] InnoDB: Dumping buffer pool(s) not 
yet started
2020-04-03 7:57:04 139670137862400 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-03 7:57:04 139670137862400 [Note] Recovering after a crash using tc.log
2020-04-03 7:57:04 139670137862400 [Note] Starting crash recovery...
2020-04-03 7:57:04 139670137862400 [Note] Crash recovery finished.
2020-04-03 7:57:04 139670137862400 [Note] Server socket created on IP: 
'0.0.0.0'.
2020-04-03 7:57:04 139670137862400 [ERROR] Missing system table 
mysql.proxies_priv; please run mysql_upgrade to create it
2020-04-03 7:57:05 139670060198656 [Warning] Failed to load slave replication 
state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave
_pos' doesn't exist
2020-04-03 7:57:05 139670137019136 [Note] WSREP: wsrep_notify_cmd is not 
defined, skipping notification.
2020-04-03 7:57:05 139670137019136 [Note] WSREP: REPL Protocols: 7 (3, 2)
2020-04-03 7:57:05 139670137019136 [Note] WSREP: Assign initial position for 
certification: 0, protocol version: 3
2020-04-03 7:57:05 139669873989376 [Note] WSREP: Service thread queue flushed.
2020-04-03 7:57:05 139670137862400 [Note] mysqld: ready for connections.
Version: '10.1.24-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 
MariaDB Server
2020-04-03 7:57:05 139670137019136 [Note] WSREP: GCache history reset: 
old(00000000-0000-0000-0000-000000000000:0) -> new(b5008b85-7580-11ea-b62f-
87af4ff6be2c:0)

Try to run the mysql_upgrade into mariadb pod but not able to execute because 
don't have permissions:
$ kubectl exec -it onapit-vfc-vfc-mariadb-0 -n onap sh

sh-4.2$ mysql_upgrade
Version check failed. Got the following error when calling the 'mysql' command 
line client
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: 
NO)
FATAL ERROR: Upgrade failed
sh-4.2$ mysql_upgrade -u root -psecretpassword
Version check failed. Got the following error when calling the 'mysql' command 
line client
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: 
YES)
FATAL ERROR: Upgrade failed
sh-4.2$

Best Regards,
Paulo

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

View/Reply Online (#20477): https://lists.onap.org/g/onap-discuss/message/20477
Mute This Topic: https://lists.onap.org/mt/72740869/21656
Mute #oom: https://lists.onap.org/mk?hashtag=oom&subid=2740164
Mute #vfc: https://lists.onap.org/mk?hashtag=vfc&subid=2740164
Mute #mariadb: https://lists.onap.org/mk?hashtag=mariadb&subid=2740164
Mute #elalto: https://lists.onap.org/mk?hashtag=elalto&subid=2740164
Group Owner: [email protected]
Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub  
[[email protected]]
-=-=-=-=-=-=-=-=-=-=-=-

Reply via email to