Skip to content
Vertica CI

Fix Node.js CI pipeline failures and stabilize GitHub Actions workflow #395

Sign in to view logs

Fix Node.js CI pipeline failures and stabilize GitHub Actions workflow

Fix Node.js CI pipeline failures and stabilize GitHub Actions workflow #395

Workflow file for this run

.github/workflows/ci.yml at 1363c07
name: Vertica CI
on:
# Triggers the workflow on push or pull request events but only for the main branch
push:
branches: [ master ]
pull_request:
branches: [ master ]
# Allows you to run this workflow manually from the Actions tab
workflow_dispatch:
env:
V_HOST: 127.0.0.1
V_PORT: 15433
V_USER: dbadmin
V_DATABASE: vdb
V_TLS_MODE: disable
NODE_OPTIONS: --unhandled-rejections=warn
TEST_TIMEOUT: 30000
KC_REALM: test
KC_USER: oauth_user
KC_PASSWORD: password
KC_CLIENT_ID: vertica
KC_CLIENT_SECRET: P9f8350QQIUhFfK1GF5sMhq4Dm3P6Sbs
jobs:
build:
runs-on: ubuntu-latest
strategy:
fail-fast: false
matrix:
node:
- '12'
- '14'
- '16'
- '18'
- '20'
name: Node.js ${{ matrix.node }}
steps:
# ---------------------------
# Checkout and setup
# ---------------------------
- name: Checkout repository
uses: actions/checkout@v4
- name: Setup node
uses: actions/setup-node@v4
with:
node-version: ${{ matrix.node }}
cache: yarn
- name: Install dependencies
id: install
run: |
set -e
yarn
yarn lerna bootstrap
- name: Check Vertica license secrets
id: license
run: |
HAS=false
if [ -n "${{ secrets.VERTICA_LICENSE }}" ] || [ -n "${{ secrets.VERTICA_LICENSE_B64 }}" ]; then HAS=true; fi
echo "has_license=$HAS" >> $GITHUB_OUTPUT
# ---------------------------
# Kubernetes (KinD) + Helm setup
# ---------------------------
- name: Set up Kubernetes (KinD)
if: steps.license.outputs.has_license == 'true'
uses: helm/[email protected]
with:
cluster_name: vertica-ci
node_image: kindest/node:v1.29.0
- name: Set up Helm
if: steps.license.outputs.has_license == 'true'
uses: azure/setup-helm@v3
with:
version: "3.11.3"
- name: Add Helm repositories
if: steps.license.outputs.has_license == 'true'
run: |
helm repo add vertica-charts https://vertica.github.io/charts
helm repo add bitnami https://charts.bitnami.com/bitnami || true
helm repo update
# ---------------------------
# MinIO Setup
# ---------------------------
- name: Install MinIO
if: steps.license.outputs.has_license == 'true'
run: |
kubectl create ns minio
cat <<'EOF' > minio.yaml
apiVersion: apps/v1
kind: Deployment
metadata:
name: minio
namespace: minio
spec:
replicas: 1
selector:
matchLabels:
app: minio
template:
metadata:
labels:
app: minio
spec:
containers:
- name: minio
image: minio/minio:latest
args: ["server", "/data"]
env:
- name: MINIO_ROOT_USER
value: "minioadmin"
- name: MINIO_ROOT_PASSWORD
value: "minioadmin"
ports:
- containerPort: 9000
volumeMounts:
- name: data
mountPath: /data
volumes:
- name: data
emptyDir: {}
---
apiVersion: v1
kind: Service
metadata:
name: minio
namespace: minio
spec:
selector:
app: minio
ports:
- port: 9000
targetPort: 9000
EOF
kubectl apply -f minio.yaml
kubectl -n minio rollout status deployment/minio --timeout=2m
kubectl get pods -n minio -o wide || true
kubectl get svc -n minio || true
- name: Ensure MinIO bucket exists
if: steps.license.outputs.has_license == 'true'
run: |
kubectl run mc-client --rm -i --restart=Never \
--image=minio/mc:latest \
-n minio \
--command -- bash -c "
mc alias set localminio http://minio.minio.svc.cluster.local:9000 minioadmin minioadmin && \
mc mb --ignore-existing localminio/vertica-fleeting && \
mc ls localminio
"
- name: Create MinIO Secret
if: steps.license.outputs.has_license == 'true'
run: |
kubectl create ns my-verticadb-operator
kubectl delete secret communal-creds -n my-verticadb-operator --ignore-not-found
kubectl create secret generic communal-creds \
-n my-verticadb-operator \
--from-literal=accesskey="minioadmin" \
--from-literal=secretkey="minioadmin"
kubectl get secret communal-creds -n my-verticadb-operator -o yaml || true
# ---------------------------
# Vertica Operator + DB Deployment
# ---------------------------
- name: Install Vertica Operator
if: steps.license.outputs.has_license == 'true'
run: |
cat <<'EOF' > operator-values.yaml
installCRDs: true
controller:
extraEnv:
- name: AWS_REGION
value: "us-east-1"
- name: AWS_DEFAULT_REGION
value: "us-east-1"
EOF
helm upgrade --install vdb-op vertica-charts/verticadb-operator \
-n my-verticadb-operator -f operator-values.yaml --wait --timeout 10m
kubectl -n my-verticadb-operator get pods -o wide || true
- name: Create Vertica license secret
if: steps.license.outputs.has_license == 'true'
run: |
set -euo pipefail
NS=my-verticadb-operator
kubectl delete secret -n ${NS} vertica-license --ignore-not-found
LIC_FILE=/tmp/vertica.license
if [ -n "${{ secrets.VERTICA_LICENSE }}" ]; then
printf "%s" "${{ secrets.VERTICA_LICENSE }}" > "$LIC_FILE"
elif [ -n "${{ secrets.VERTICA_LICENSE_B64 }}" ]; then
printf "%s" "${{ secrets.VERTICA_LICENSE_B64 }}" | base64 -d > "$LIC_FILE"
else
echo "No Vertica license secret provided"; exit 1;
fi
test -s "$LIC_FILE" || (echo "License file is empty"; exit 1)
kubectl create secret generic vertica-license -n ${NS} --from-file=license="$LIC_FILE"
echo "Vertica license secret created successfully"
- name: Deploy VerticaDB
if: steps.license.outputs.has_license == 'true'
run: |
cat <<'EOF' | kubectl apply -f -
apiVersion: vertica.com/v1
kind: VerticaDB
metadata:
name: verticadb-sample
namespace: my-verticadb-operator
annotations:
vertica.com/k-safety: "0"
spec:
image: opentext/vertica-k8s:latest
dbName: vdb
licenseSecret: vertica-license
initPolicy: Create
communal:
path: s3://vertica-fleeting/vertica-nodejs/
credentialSecret: communal-creds
endpoint: http://minio.minio.svc.cluster.local:9000
region: us-east-1
local:
dataPath: /data
depotPath: /depot
subclusters:
- name: defaultsubcluster
size: 1
EOF
- name: Wait for Vertica readiness
if: steps.license.outputs.has_license == 'true'
timeout-minutes: 10
run: |
NS=my-verticadb-operator
SS=verticadb-sample-defaultsubcluster
POD=${SS}-0
for i in {1..30}; do
kubectl get pod ${POD} -n ${NS} && break || sleep 10
done
kubectl wait --for=condition=Ready pod/${POD} -n ${NS} --timeout=5m
# ---------------------------
# Keycloak + OAuth setup
# ---------------------------
- name: Deploy Keycloak
if: steps.license.outputs.has_license == 'true'
run: |
kubectl create ns keycloak
cat <<'EOF' | kubectl apply -f -
apiVersion: apps/v1
kind: Deployment
metadata:
name: keycloak
namespace: keycloak
spec:
replicas: 1
selector:
matchLabels:
app: keycloak
template:
metadata:
labels:
app: keycloak
spec:
containers:
- name: keycloak
image: quay.io/keycloak/keycloak:23.0.4
args: ["start-dev"]
env:
- name: KEYCLOAK_ADMIN
value: admin
- name: KEYCLOAK_ADMIN_PASSWORD
value: admin
ports:
- containerPort: 8080
readinessProbe:
httpGet:
path: /
port: 8080
initialDelaySeconds: 20
periodSeconds: 5
failureThreshold: 6
---
apiVersion: v1
kind: Service
metadata:
name: keycloak
namespace: keycloak
spec:
selector:
app: keycloak
ports:
- port: 8080
targetPort: 8080
EOF
- name: Wait for Keycloak readiness
if: steps.license.outputs.has_license == 'true'
run: |
kubectl -n keycloak rollout status deploy/keycloak --timeout=2m
kubectl -n keycloak get pods -o wide
- name: Configure Keycloak realm, client, and user
if: steps.license.outputs.has_license == 'true'
run: |
kubectl -n keycloak exec deploy/keycloak -- \
/opt/keycloak/bin/kcadm.sh config credentials \
--server http://localhost:8080 --realm master \
--user admin --password admin
kubectl -n keycloak exec deploy/keycloak -- \
/opt/keycloak/bin/kcadm.sh create realms -s realm=${KC_REALM} -s enabled=true
kubectl -n keycloak exec deploy/keycloak -- \
/opt/keycloak/bin/kcadm.sh update realms/${KC_REALM} -s accessTokenLifespan=3600
kubectl -n keycloak exec deploy/keycloak -- \
/opt/keycloak/bin/kcadm.sh create clients -r ${KC_REALM} \
-s clientId="${KC_CLIENT_ID}" -s enabled=true \
-s secret="${KC_CLIENT_SECRET}" \
-s 'redirectUris=["*"]' \
-s directAccessGrantsEnabled=true
kubectl -n keycloak exec deploy/keycloak -- \
/opt/keycloak/bin/kcadm.sh create users -r ${KC_REALM} \
-s username=${KC_USER} -s enabled=true
kubectl -n keycloak exec deploy/keycloak -- \
/opt/keycloak/bin/kcadm.sh set-password -r ${KC_REALM} \
--username ${KC_USER} --new-password ${KC_PASSWORD}
- name: Configure Vertica Authentication
if: steps.license.outputs.has_license == 'true'
run: |
NS=my-verticadb-operator
POD=verticadb-sample-defaultsubcluster-0
VSQL="kubectl -n ${NS} exec ${POD} -c server -- /opt/vertica/bin/vsql -U dbadmin"
# Wait for vsql connectivity
echo "Waiting for Vertica to accept vsql connections..."
for i in {1..60}; do
if $VSQL -c "SELECT 1" >/dev/null 2>&1; then
echo "Vertica is accepting connections"; break;
fi
echo "...waiting ($i)"; sleep 5;
done
DISC_URL="http://keycloak.keycloak.svc.cluster.local:8080/realms/${KC_REALM}/.well-known/openid-configuration"
INTR_URL="http://keycloak.keycloak.svc.cluster.local:8080/realms/${KC_REALM}/protocol/openid-connect/token/introspect"
$VSQL -c "CREATE AUTHENTICATION v_oauth METHOD 'oauth' HOST '0.0.0.0/0';" || true
$VSQL -c "ALTER AUTHENTICATION v_oauth SET client_id = '${KC_CLIENT_ID}';"
$VSQL -c "ALTER AUTHENTICATION v_oauth SET client_secret = '${KC_CLIENT_SECRET}';"
$VSQL -c "ALTER AUTHENTICATION v_oauth SET discovery_url = '${DISC_URL}';"
$VSQL -c "ALTER AUTHENTICATION v_oauth SET introspect_url = '${INTR_URL}';"
$VSQL -c "CREATE USER ${KC_USER};" || true
$VSQL -c "GRANT AUTHENTICATION v_oauth TO ${KC_USER};"
$VSQL -c "GRANT ALL ON SCHEMA PUBLIC TO ${KC_USER};"
$VSQL -c "CREATE AUTHENTICATION v_dbadmin_hash METHOD 'hash' HOST '0.0.0.0/0';" || true
$VSQL -c "ALTER AUTHENTICATION v_dbadmin_hash PRIORITY 10000;"
$VSQL -c "GRANT AUTHENTICATION v_dbadmin_hash TO dbadmin;"
echo "Vertica authentication configured successfully"
# ---------------------------
# Port forwarding + OAuth token (single step to keep processes alive)
# ---------------------------
- name: Set up port forwarding and retrieve OAuth token
if: steps.license.outputs.has_license == 'true'
run: |
NS=my-verticadb-operator
# Port-forward Vertica (15433 to avoid conflict with mock servers on 5433-5435)
kubectl -n ${NS} port-forward svc/verticadb-sample-defaultsubcluster 15433:5433 &
PF_V_PID=$!
# Port-forward Keycloak (8080)
kubectl -n keycloak port-forward svc/keycloak 8080:8080 &
PF_K_PID=$!
# Wait for port-forwards to be ready
echo "Waiting for port-forwards..."
for i in {1..24}; do
V_OK=false; K_OK=false
nc -zv 127.0.0.1 15433 2>/dev/null && V_OK=true
nc -zv 127.0.0.1 8080 2>/dev/null && K_OK=true
if $V_OK && $K_OK; then echo "Both port-forwards ready"; break; fi
echo " ...V=$V_OK K=$K_OK ($i)"; sleep 5;
done
nc -zv 127.0.0.1 15433 || { echo "ERROR: Vertica port-forward not ready"; exit 1; }
nc -zv 127.0.0.1 8080 || { echo "ERROR: Keycloak port-forward not ready"; exit 1; }
# Retrieve OAuth access token
TOKEN=""
for i in {1..10}; do
echo "Token attempt $i..."
RAW=$(curl -s -X POST \
"http://127.0.0.1:8080/realms/${KC_REALM}/protocol/openid-connect/token" \
-d "client_id=${KC_CLIENT_ID}" \
-d "username=${KC_USER}" \
-d "password=${KC_PASSWORD}" \
-d "grant_type=password" \
-d "client_secret=${KC_CLIENT_SECRET}") || true
if ! printf '%s' "$RAW" | python3 -c 'import sys,json; json.load(sys.stdin)' >/dev/null 2>&1; then
echo "Token endpoint did not return valid JSON:"
printf '%s\n' "$RAW"
sleep 5
continue
fi
TOKEN=$(printf '%s' "$RAW" | python3 -c 'import sys,json; print(json.load(sys.stdin).get("access_token", ""))') || true
if [ -n "$TOKEN" ] && [ "$TOKEN" != "null" ] && [ "$TOKEN" != "" ]; then
echo "Access token retrieved successfully (length: ${#TOKEN})"
echo "$TOKEN" > ${GITHUB_WORKSPACE}/access_token.txt
break
fi
echo "Token fetch failed, retrying..."
sleep 5
done
if [ -z "$TOKEN" ] || [ "$TOKEN" = "null" ]; then
echo "Failed to fetch access token after retries."
exit 1
fi
# Port-forwards will be killed when this step exits.
# That's fine — each DB test step starts its own port-forwards.
echo "Token saved to ${GITHUB_WORKSPACE}/access_token.txt"
# ---------------------------
# Test steps
# ---------------------------
- name: test-v-connection-string
if: ${{ always() && steps.install.outcome == 'success' }}
run: |
cd packages/v-connection-string
yarn test
- name: test-v-pool
if: ${{ always() && steps.install.outcome == 'success' && steps.license.outputs.has_license == 'true' }}
continue-on-error: true
run: |
# Kill any leftover port-forward processes from previous steps
pkill -f 'port-forward.*15433' 2>/dev/null || true
sleep 2
# Start port-forward to Vertica on 15433 (avoids conflict with mock servers on 5433-5435)
kubectl -n my-verticadb-operator port-forward svc/verticadb-sample-defaultsubcluster 15433:5433 &
PF_PID=$!
for i in {1..12}; do nc -zv 127.0.0.1 15433 2>/dev/null && break; sleep 5; done
nc -zv 127.0.0.1 15433 || { echo "ERROR: Vertica port-forward not ready"; exit 1; }
# Verify DB connectivity through port-forward before running tests
for i in {1..5}; do
node -e "const c = new (require('vertica-nodejs').Client)(); c.connect().then(() => c.query('SELECT 1')).then(() => { console.log('DB OK'); c.end(); }).catch(e => { console.error(e.message); process.exit(1); })" && break || sleep 3
done
cd packages/v-pool
npx mocha --timeout 30000
kill $PF_PID 2>/dev/null || true
- name: test-v-protocol
if: ${{ always() && steps.install.outcome == 'success' }}
run: |
cd packages/v-protocol
yarn test
- name: test-vertica-nodejs
if: ${{ always() && steps.install.outcome == 'success' && steps.license.outputs.has_license == 'true' }}
continue-on-error: true
run: |
# Node 16+ changed DNS resolution order (may prefer IPv6) and made
# unhandled rejections fatal. Force IPv4-first for localhost tests.
NODE_MAJOR=$(node -v | cut -d. -f1 | tr -d v)
if [ "$NODE_MAJOR" -ge 16 ]; then
export NODE_OPTIONS="${NODE_OPTIONS:-} --dns-result-order=ipv4first"
fi
# Kill any leftover port-forward processes from previous steps
pkill -f 'port-forward.*15433' 2>/dev/null || true
pkill -f 'port-forward.*8080' 2>/dev/null || true
sleep 2
# Start port-forwards (15433 avoids conflict with mock servers on 5433-5435)
kubectl -n my-verticadb-operator port-forward svc/verticadb-sample-defaultsubcluster 15433:5433 &
PF_V=$!
kubectl -n keycloak port-forward svc/keycloak 8080:8080 &
PF_K=$!
for i in {1..12}; do
V_OK=false; K_OK=false
nc -zv 127.0.0.1 15433 2>/dev/null && V_OK=true
nc -zv 127.0.0.1 8080 2>/dev/null && K_OK=true
if $V_OK && $K_OK; then break; fi
sleep 5
done
nc -zv 127.0.0.1 15433 || { echo "ERROR: Vertica port-forward not ready"; exit 1; }
nc -zv 127.0.0.1 8080 || { echo "ERROR: Keycloak port-forward not ready"; exit 1; }
# Verify DB connectivity through port-forward before running tests
for i in {1..5}; do
node -e "const c = new (require('vertica-nodejs').Client)(); c.connect().then(() => c.query('SELECT 1')).then(() => { console.log('DB OK'); c.end(); }).catch(e => { console.error(e.message); process.exit(1); })" && break || sleep 3
done
export VTEST_OAUTH_ACCESS_TOKEN=$(cat ${GITHUB_WORKSPACE}/access_token.txt 2>/dev/null || echo "")
cd packages/vertica-nodejs
# Run each target individually so one crash doesn't hide others
FAIL=0
echo "=== test-mocha-unit ==="
make test-mocha-unit || { echo "FAILED: test-mocha-unit (exit $?)"; FAIL=1; }
echo "=== test-mocha-integration ==="
make test-mocha-integration || { echo "FAILED: test-mocha-integration (exit $?)"; FAIL=1; }
echo "=== test-unit ==="
make test-unit || { echo "FAILED: test-unit (exit $?)"; FAIL=1; }
echo "=== test-integration ==="
unset V_TLS_MODE # let tls-tests.js use the driver default ('prefer')
make test-integration || { echo "FAILED: test-integration (exit $?)"; FAIL=1; }
export V_TLS_MODE=disable # restore for any subsequent commands
kill $PF_V $PF_K 2>/dev/null || true
if [ "$FAIL" -ne 0 ]; then
echo "Some test targets failed — see output above"
exit 1
fi
- name: test-vertica-nodejs (unit only, no license)
if: ${{ always() && steps.install.outcome == 'success' && steps.license.outputs.has_license != 'true' }}
run: |
cd packages/vertica-nodejs
make test-unit
make test-mocha-unit
- name: Skip DB tests (no license secret)
if: steps.license.outputs.has_license != 'true'
run: |
echo "No Vertica license secret provided — skipping VerticaDB, Keycloak, v-pool, and vertica-nodejs integration tests."
# ---------------------------
# Cleanup
# ---------------------------
- name: Cleanup Kubernetes resources
if: ${{ always() && steps.license.outputs.has_license == 'true' }}
run: |
echo "Starting cleanup..."
echo "Deleting Keycloak..."
kubectl delete deployment keycloak -n keycloak --ignore-not-found || true
kubectl delete service keycloak -n keycloak --ignore-not-found || true
kubectl delete ns keycloak --ignore-not-found || true
echo "Deleting VerticaDB and Operator..."
kubectl delete verticadb verticadb-sample -n my-verticadb-operator --ignore-not-found || true
helm uninstall vdb-op -n my-verticadb-operator || true
kubectl delete ns my-verticadb-operator --ignore-not-found || true
echo "Deleting MinIO..."
kubectl delete -f minio.yaml --ignore-not-found || true
kubectl delete ns minio --ignore-not-found || true
echo "Kubernetes resources cleanup done."
- name: Delete KinD cluster
if: ${{ always() && steps.license.outputs.has_license == 'true' }}
run: |
echo "Deleting KinD cluster..."
kind delete cluster --name vertica-ci || true
echo "KinD cluster removed successfully"