[MDEV-31717] mariadb sst scripts to copy .my-healthcheck.cnf Created: 2023-07-17  Updated: 2024-01-17

Status: Open
Project: MariaDB Server
Component/s: Galera SST
Affects Version/s: 10.4, 10.11
Fix Version/s: 10.4

Type: Bug Priority: Minor
Reporter: Daniel Black Assignee: Daniel Black
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Docker official Images



 Description   

The docker official images of MariaDB create a .my-healthcheck.cnf file in the datadir so k8s/container services can perform a healthcheck against the current running instances.

Since the mariadb operator now supports galera, it would be good if it works correctly during sst scripts,. The liveness/readiness probes are a waiting feature, but simple enough to implement.

As the test https://github.com/MariaDB/mariadb.org-tools/tree/master/daniel/galera-sst-test shows it starts failing healthcheck tests after being a SST joiner.

donor_1    | 2023-07-17  0:53:18 0 [Note] WSREP: Service thread queue flushed.
donor_1    | 2023-07-17  0:53:18 2 [Note] WSREP: ================================================
donor_1    | View:
donor_1    |   id: 2c827540-243c-11ee-9aeb-fa5ebf8c6181:4
donor_1    |   status: primary
donor_1    |   protocol_version: 4
donor_1    |   capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
donor_1    |   final: no
donor_1    |   own_index: 0
donor_1    |   members(2):
donor_1    | 	0: 2c8223b7-243c-11ee-a47c-922634af51d8, b99d1bda4744
donor_1    | 	1: 3ea2ff70-243c-11ee-ac34-3fa95804b9c5, 3d2cf822b9cb
donor_1    | =================================================
donor_1    | 2023-07-17  0:53:18 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
joiner_1   | 2023-07-17  0:53:18 2 [Note] WSREP: ================================================
joiner_1   | View:
joiner_1   |   id: 2c827540-243c-11ee-9aeb-fa5ebf8c6181:4
joiner_1   |   status: primary
joiner_1   |   protocol_version: 4
joiner_1   |   capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
joiner_1   |   final: no
joiner_1   |   own_index: 1
joiner_1   |   members(2):
joiner_1   | 	0: 2c8223b7-243c-11ee-a47c-922634af51d8, b99d1bda4744
joiner_1   | 	1: 3ea2ff70-243c-11ee-ac34-3fa95804b9c5, 3d2cf822b9cb
joiner_1   | =================================================
joiner_1   | 2023-07-17  0:53:18 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
joiner_1   | 2023-07-17  0:53:18 2 [Note] WSREP: Lowest cert index boundary for CC from group: 4
joiner_1   | 2023-07-17  0:53:18 2 [Note] WSREP: Min available from gcache for CC from group: 2
donor_1    | 2023-07-17  0:53:18 2 [Note] WSREP: Lowest cert index boundary for CC from group: 4
donor_1    | 2023-07-17  0:53:18 2 [Note] WSREP: Min available from gcache for CC from group: 1
galera-sst-test_joiner2_1 exited with code 139
donor_1    | 2023-07-17  0:53:20 0 [Note] WSREP: (2c8223b7-a47c, 'tcp://0.0.0.0:4567') turning message relay requesting off
joiner_1   | 2023-07-17  0:53:21 0 [Note] WSREP: (3ea2ff70-ac34, 'tcp://0.0.0.0:4567') turning message relay requesting off
donor_1    | 2023-07-17  0:53:23 0 [Note] WSREP:  cleaning up 51570245-b9fd (tcp://10.89.16.68:4567)
joiner_1   | 2023-07-17  0:53:24 0 [Note] WSREP:  cleaning up 51570245-b9fd (tcp://10.89.16.68:4567)
joiner_1   | 2023-07-17  0:53:42 14 [Warning] Access denied for user 'root'@'::1' (using password: NO)
joiner_1   | 2023-07-17  0:54:13 15 [Warning] Access denied for user 'root'@'::1' (using password: NO)
joiner_1   | 2023-07-17  0:54:44 16 [Warning] Access denied for user 'root'@'::1' (using password: NO)
joiner_1   | 2023-07-17  0:55:15 17 [Warning] Access denied for user 'root'@'::1' (using password: NO)
joiner_1   | 2023-07-17  0:55:46 18 [Warning] Access denied for user 'root'@'::1' (using password: NO)

ref: https://mariadb.com/kb/en/using-healthcheck-sh-script/


Generated at Thu Feb 08 10:25:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.