Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-31717

mariadb sst scripts to copy .my-healthcheck.cnf

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.4, 10.11
    • 10.4
    • Galera SST
    • None
    • 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/

      Attachments

        Activity

          People

            danblack Daniel Black
            danblack Daniel Black
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.