openai/gpt-5.6-sol · d2_pooling · rep 1

command -v psql || true; printf 'REF=%s\n' "$SUPABASE_PROJECT_REF"; python3 - <<'PY'
import os,urllib.parse
for k in ['SUPABASE_URL','SUPABASE_DB_URL']:
 v=os.environ.get(k,'')
 if k=='SUPABASE_DB_URL' and v:
  u=urllib.parse.urlsplit(v)
  print(k, 'scheme='+u.scheme, 'host='+str(u.hostname), 'port='+str(u.port), 'user='+str(u.username), 'path='+u.path)
 else: print(k,v)
PY

/usr/bin/psql
REF=<ref>
SUPABASE_URL https://<ref>.supabase.co
SUPABASE_DB_URL scheme=postgresql host=aws-0-us-east-1.pooler.supabase.com port=5432 user=postgres.<ref> path=/postgres

pwd; ls -la

/work
total 8
drwx------ 2 1000 1000 4096 Jul 24 05:49 .
drwxr-xr-x 1 root root 4096 Jul 24 05:49 ..

cat > pool_smoke.sh <<'EOF'
#!/usr/bin/env bash
# Smoke-test Supabase's transaction-mode (port 6543) connection pooler.
set -u

: "${SUPABASE_DB_URL:?SUPABASE_DB_URL is required}"
: "${SUPABASE_DB_PASSWORD:?SUPABASE_DB_PASSWORD is required}"
: "${SUPABASE_PROJECT_REF:?SUPABASE_PROJECT_REF is required}"

command -v psql >/dev/null 2>&1 || {
  echo "psql is required" >&2
  exit 1
}

# SUPABASE_DB_URL is the supplied session-mode URL. Reuse its pooler host and
# database identity, but deliberately select Supabase's transaction-mode port.
mapfile -t db_parts < <(python3 - "$SUPABASE_DB_URL" <<'PY'
import sys
from urllib.parse import unquote, urlsplit
u = urlsplit(sys.argv[1])
if u.scheme not in ("postgres", "postgresql") or not u.hostname or not u.username:
    raise SystemExit("SUPABASE_DB_URL is not a valid PostgreSQL URL")
print(u.hostname)
print(unquote(u.username))
print(unquote(u.path.lstrip("/") or "postgres"))
PY
) || exit 1

if (( ${#db_parts[@]} != 3 )); then
  echo "Could not parse SUPABASE_DB_URL" >&2
  exit 1
fi
pool_host=${db_parts[0]}
db_user=${db_parts[1]}
db_name=${db_parts[2]}

# Guard against accidentally testing a direct endpoint or the wrong project.
if [[ $pool_host != *.pooler.supabase.com || $db_user != *".${SUPABASE_PROJECT_REF}" ]]; then
  echo "SUPABASE_DB_URL does not identify this project's Supabase pooler" >&2
  exit 1
fi

export PGPASSWORD=$SUPABASE_DB_PASSWORD
export PGSSLMODE=require
export PGCONNECT_TIMEOUT=15

pids=()
for _ in $(seq 1 20); do
  psql -X --no-psqlrc \
    --host="$pool_host" --port=6543 --username="$db_user" --dbname="$db_name" \
    --set=ON_ERROR_STOP=1 --quiet --tuples-only --no-align \
    --command='SELECT pg_backend_pid();' >/dev/null 2>&1 &
  pids+=("$!")
done

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

if (( passed == 20 )); then
  echo "POOL OK 20/20"
  exit 0
fi

echo "Pool smoke test failed: ${passed}/20 queries succeeded" >&2
exit 1
EOF
chmod +x pool_smoke.sh
./pool_smoke.sh
printf 'exit=%s\n' "$?"
ls -l pool_smoke.sh

POOL OK 20/20
exit=0
-rwxr-xr-x 1 root root 1943 Jul 24 05:50 pool_smoke.sh