Initial test for exporter metrics

jmckulk · andrewlecuyer · commit 75be991eb193 · 2022-03-29T09:31:03.000-05:00
Checks that the exporter sidecar is running and the metrics endpoint is
available from inside the container. This test also checks that the
ccp_monitoring user is available in the database
diff --git a/testing/kuttl/e2e/exporter/00--cluster.yaml b/testing/kuttl/e2e/exporter/00--cluster.yaml
@@ -0,0 +1,28 @@
+apiVersion: postgres-operator.crunchydata.com/v1beta1
+kind: PostgresCluster
+metadata:
+  name: exporter
+spec:
+  postgresVersion: ${KUTTL_PG_VERSION}
+  instances:
+    - name: instance1
+      dataVolumeClaimSpec:
+        accessModes:
+        - "ReadWriteOnce"
+        resources:
+          requests:
+            storage: 1Gi
+  backups:
+    pgbackrest:
+      repos:
+      - name: repo1
+        volume:
+          volumeClaimSpec:
+            accessModes:
+            - "ReadWriteOnce"
+            resources:
+              requests:
+                storage: 1Gi
+  monitoring:
+    pgmonitor:
+      exporter: {}
diff --git a/testing/kuttl/e2e/exporter/00-assert.yaml b/testing/kuttl/e2e/exporter/00-assert.yaml
@@ -0,0 +1,24 @@
+apiVersion: postgres-operator.crunchydata.com/v1beta1
+kind: PostgresCluster
+metadata:
+  name: exporter
+status:
+  instances:
+    - name: instance1
+      readyReplicas: 1
+      replicas: 1
+      updatedReplicas: 1
+---
+apiVersion: batch/v1
+kind: Job
+metadata:
+  labels:
+    postgres-operator.crunchydata.com/cluster: exporter
+    postgres-operator.crunchydata.com/pgbackrest-backup: replica-create
+status:
+  succeeded: 1
+---
+apiVersion: v1
+kind: Service
+metadata:
+  name: exporter-primary
diff --git a/testing/kuttl/e2e/exporter/01--check-exporter.yaml b/testing/kuttl/e2e/exporter/01--check-exporter.yaml
@@ -0,0 +1,21 @@
+---
+apiVersion: kuttl.dev/v1beta1
+kind: TestStep
+commands:
+  # Ensure that the metrics endpoint is available from inside the exporter container
+  - script: |
+      name=$(kubectl -n ${NAMESPACE} get pods --no-headers -o custom-columns="name:{metadata.name}" \
+        --selector='postgres-operator.crunchydata.com/cluster=exporter,postgres-operator.crunchydata.com/instance-set=instance1')
+      kubectl -n ${NAMESPACE} exec $name -it -c exporter -- curl http://localhost:9187/metrics
+  # Ensure that the ccp_monitoring user exits in the database
+  - script: |
+      name=$(kubectl -n ${NAMESPACE} get pods --no-headers -o custom-columns="name:{metadata.name}" \
+        --selector='postgres-operator.crunchydata.com/cluster=exporter,postgres-operator.crunchydata.com/instance-set=instance1')
+      kubectl -n ${NAMESPACE} exec $name -it -c database -- \
+        psql -c "DO \$\$
+        DECLARE
+          result boolean;
+        BEGIN
+          SELECT 1 from pg_roles where rolname='ccp_monitoring' INTO result;
+          ASSERT result = 't', 'ccp_monitor not found';
+        END \$\$;"
