deepseek/deepseek-v4-pro · d2_pooling · rep 2

echo "SUPABASE_URL=$SUPABASE_URL" && echo "SUPABASE_PROJECT_REF=$SUPABASE_PROJECT_REF" && echo "SUPABASE_DB_URL=${SUPABASE_DB_URL:+set (hidden)}" && echo "SUPABASE_DB_PASSWORD=${SUPABASE_DB_PASSWORD:+set (hidden)}"

SUPABASE_URL=https://<ref>.supabase.co
SUPABASE_PROJECT_REF=<ref>
SUPABASE_DB_URL=set (hidden)
SUPABASE_DB_PASSWORD=set (hidden)

echo "$SUPABASE_DB_URL" | sed 's/:[^:@]*@/:****@/'

postgresql://postgres.<ref>:<redacted>@aws-0-us-east-1.pooler.supabase.com:5432/postgres

which psql && psql --version

/usr/bin/psql
psql (PostgreSQL) 18.4 (Debian 18.4-1.pgdg12+1)

# The SUPABASE_DB_URL is the session-mode pooler (port 5432).
# Transaction-mode pooler is on the same host, port 6543.
# Let's verify we can construct and test the transaction-mode URL:
TX_URL=$(echo "$SUPABASE_DB_URL" | sed 's/:5432\//:6543\//')
echo "TX_URL: ${TX_URL//:*@/:****@}"

# Quick test
psql "$TX_URL" -c "SELECT pg_backend_pid();" -t -A

TX_URL: postgresql:****@aws-0-us-east-1.pooler.supabase.com:6543/postgres
14975

cat > pool_smoke.sh << 'SCRIPT'
#!/usr/bin/env bash
set -euo pipefail

: "${SUPABASE_DB_URL:?SUPABASE_DB_URL not set}"

# Derive the transaction-mode pooler URL from SUPABASE_DB_URL:
#   session-mode is on port 5432; transaction-mode is on port 6543
TX_DB_URL="${SUPABASE_DB_URL/:5432\//:6543/}"

export PGCONNECT_TIMEOUT=5

declare -a PIDS=()

# Launch 20 concurrent queries, each selecting its backend pid
for i in $(seq 1 20); do
  psql "${TX_DB_URL}" -c "SELECT pg_backend_pid();" -t -A -o /dev/null &
  PIDS+=($!)
done

FAILURES=0
for pid in "${PIDS[@]}"; do
  if ! wait "$pid"; then
    FAILURES=$((FAILURES + 1))
  fi
done

if [ "$FAILURES" -eq 0 ]; then
  echo "POOL OK 20/20"
  exit 0
else
  echo "POOL FAIL ${FAILURES}/20"
  exit 1
fi
SCRIPT

chmod +x pool_smoke.sh

./pool_smoke.sh

POOL OK 20/20

# Quick sanity: if we force a bad port, it should fail
BAD_URL=$(echo "$SUPABASE_DB_URL" | sed 's/:5432\//:12345\//')
# Just run one to confirm it fails - don't run all 20 on a dead port
psql "$BAD_URL" -c "SELECT 1;" 2>&1 || true

timeout after 300s

cat pool_smoke.sh

#!/usr/bin/env bash
set -euo pipefail

: "${SUPABASE_DB_URL:?SUPABASE_DB_URL not set}"

# Derive the transaction-mode pooler URL from SUPABASE_DB_URL:
#   session-mode is on port 5432; transaction-mode is on port 6543
TX_DB_URL="${SUPABASE_DB_URL/:5432\//:6543/}"

export PGCONNECT_TIMEOUT=5

declare -a PIDS=()

# Launch 20 concurrent queries, each selecting its backend pid
for i in $(seq 1 20); do
  psql "${TX_DB_URL}" -c "SELECT pg_backend_pid();" -t -A -o /dev/null &
  PIDS+=($!)
done

FAILURES=0
for pid in "${PIDS[@]}"; do
  if ! wait "$pid"; then
    FAILURES=$((FAILURES + 1))
  fi
done

if [ "$FAILURES" -eq 0 ]; then
  echo "POOL OK 20/20"
  exit 0
else
  echo "POOL FAIL ${FAILURES}/20"
  exit 1
fi