google/gemini-3.1-pro-preview · d2_pooling · rep 2

env | grep SUPABASE

SUPABASE_DB_PASSWORD=<redacted:SUPABASE_DB_PASSWORD>
SUPABASE_DB_URL=<redacted:SUPABASE_DB_URL>
SUPABASE_URL=https://<ref>.supabase.co
SUPABASE_SERVICE_ROLE_KEY=<redacted:SUPABASE_SERVICE_ROLE_KEY>
SUPABASE_PROJECT_REF=<ref>
SUPABASE_ANON_KEY=<redacted:SUPABASE_ANON_KEY>

psql "${SUPABASE_DB_URL/5432/6543}" -c 'SELECT 1;'

 ?column? 
----------
        1
(1 row)

cat << 'EOF' > pool_smoke.sh
#!/bin/bash

if [ -z "$SUPABASE_DB_URL" ]; then
    echo "SUPABASE_DB_URL is not set"
    exit 1
fi

# Change from session-mode port (5432) to transaction-mode port (6543)
POOL_DB_URL="${SUPABASE_DB_URL/:5432\//:6543\/}"

SUCCESS_COUNT=0
for i in {1..20}; do
    psql "$POOL_DB_URL" -tAc "SELECT pg_backend_pid();" > /dev/null 2>&1 &
    pids[${i}]=$!
done

for pid in ${pids[*]}; do
    wait $pid
    if [ $? -eq 0 ]; then
        SUCCESS_COUNT=$((SUCCESS_COUNT + 1))
    fi
done

if [ "$SUCCESS_COUNT" -eq 20 ]; then
    echo "POOL OK 20/20"
    exit 0
else
    echo "Failed: $SUCCESS_COUNT/20 succeeded."
    exit 1
fi
EOF
chmod +x pool_smoke.sh
./pool_smoke.sh

POOL OK 20/20

cat << 'EOF' > pool_smoke.sh
#!/bin/bash

if [ -z "$SUPABASE_DB_URL" ]; then
    echo "Error: SUPABASE_DB_URL not found in environment" >&2
    exit 1
fi

# Use transaction-mode port (6543) instead of session-mode port (5432)
POOL_URL="${SUPABASE_DB_URL/5432/6543}"

SUCCESS_COUNT=0
pids=()

for i in {1..20}; do
    psql "$POOL_URL" -q -c "SELECT pg_backend_pid();" > /dev/null 2>&1 &
    pids+=($!)
done

for pid in "${pids[@]}"; do
    wait "$pid"
    if [ $? -eq 0 ]; then
        ((SUCCESS_COUNT++))
    fi
done

if [ "$SUCCESS_COUNT" -eq 20 ]; then
    echo "POOL OK 20/20"
    exit 0
else
    echo "Failed: $SUCCESS_COUNT/20 succeeded." >&2
    exit 1
fi
EOF
chmod +x pool_smoke.sh
./pool_smoke.sh

POOL OK 20/20

cat << 'EOF' > pool_smoke.sh
#!/bin/bash
set -u

if [ -z "${SUPABASE_DB_URL:-}" ]; then
    echo "SUPABASE_DB_URL is not set" >&2
    exit 1
fi

# Replace the session-mode port (5432) with the transaction-mode port (6543)
POOL_DB_URL="${SUPABASE_DB_URL/:5432\//:6543\/}"

SUCCESS=0
PIDS=()

for i in {1..20}; do
    psql "$POOL_DB_URL" -q -tAc "SELECT pg_backend_pid();" > /dev/null 2>&1 &
    PIDS+=($!)
done

for pid in "${PIDS[@]}"; do
    if wait "$pid"; then
        ((SUCCESS++))
    fi
done

if [ "$SUCCESS" -eq 20 ]; then
    echo "POOL OK 20/20"
    exit 0
else
    echo "FAILED: $SUCCESS/20 queries succeeded" >&2
    exit 1
fi
EOF
chmod +x pool_smoke.sh
./pool_smoke.sh

POOL OK 20/20

./pool_smoke.sh

POOL OK 20/20