env | grep -i SUPABASE | sed 's/\(KEY=\).*/\1***REDACTED***/' | sed 's/\(PASSWORD=\).*/\1***REDACTED***/'
SUPABASE_DB_PASSWORD=***REDACTED*** SUPABASE_DB_URL=<redacted:SUPABASE_DB_URL> SUPABASE_URL=https://<ref>.supabase.co SUPABASE_SERVICE_ROLE_KEY=***REDACTED*** SUPABASE_PROJECT_REF=<ref> SUPABASE_ANON_KEY=***REDACTED***
which psql pg_isready python3 curl jq 2>/dev/null; psql --version 2>/dev/null; python3 --version 2>/dev/null
/usr/bin/psql /usr/bin/pg_isready /usr/bin/python3 /usr/bin/curl /usr/bin/jq psql (PostgreSQL) 18.4 (Debian 18.4-1.pgdg12+1) Python 3.11.2
echo "$SUPABASE_DB_URL"
<redacted:SUPABASE_DB_URL>
echo "$SUPABASE_PROJECT_REF"
<ref>
# Check what's available for the transaction-mode pooler
# Supabase transaction-mode pooler uses port 6543
pg_isready -h aws-0-us-east-1.pooler.supabase.com -p 6543 -U "postgres.${SUPABASE_PROJECT_REF}" -d postgres 2>&1 || trueaws-0-us-east-1.pooler.supabase.com:6543 - accepting connections
# Let me verify the connection works with a single query through port 6543
PGPASSWORD="$SUPABASE_DB_PASSWORD" psql -h aws-0-us-east-1.pooler.supabase.com -p 6543 -U "postgres.${SUPABASE_PROJECT_REF}" -d postgres -t -c 'SELECT pg_backend_pid();' 2>&155121
# Verify we can distinguish the pooler from direct DB by checking the pgbouncer show_pools view
PGPASSWORD="$SUPABASE_DB_PASSWORD" psql -h aws-0-us-east-1.pooler.supabase.com -p 6543 -U "postgres.${SUPABASE_PROJECT_REF}" -d postgres -t -c 'SHOW POOLS;' 2>&1 || trueERROR: unrecognized configuration parameter "pools"
# Let me check the server version info to distinguish the connection type
PGPASSWORD="$SUPABASE_DB_PASSWORD" psql -h aws-0-us-east-1.pooler.supabase.com -p 6543 -U "postgres.${SUPABASE_PROJECT_REF}" -d postgres -t -c "SELECT version();" 2>&1
echo "---"
PGPASSWORD="$SUPABASE_DB_PASSWORD" psql -h aws-0-us-east-1.pooler.supabase.com -p 5432 -U "postgres.${SUPABASE_PROJECT_REF}" -d postgres -t -c "SELECT version();" 2>&1PostgreSQL 17.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 15.2.0, 64-bit --- PostgreSQL 17.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 15.2.0, 64-bit
# Let me check if there's a way to verify the pooler mode
# PgBouncer exposes things via the "pgbouncer" pseudo-database
PGPASSWORD="$SUPABASE_DB_PASSWORD" psql -h aws-0-us-east-1.pooler.supabase.com -p 6543 -U "postgres.${SUPABASE_PROJECT_REF}" -d pgbouncer -t -c 'SHOW POOLS;' 2>&1 || true
echo "===---==="
PGPASSWORD="$SUPABASE_DB_PASSWORD" psql -h aws-0-us-east-1.pooler.supabase.com -p 6543 -U "postgres.${SUPABASE_PROJECT_REF}" -d pgbouncer -t -c 'SHOW CONFIG;' 2>&1 | head -5 || truepsql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: database "pgbouncer" does not exist ===---=== psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: database "pgbouncer" does not exist
# Verify: session-mode is port 5432, transaction-mode is port 6543
# Let's test that the transaction pooler properly shows different backend PIDs per query
PGPASSWORD="$SUPABASE_DB_PASSWORD" psql -h aws-0-us-east-1.pooler.supabase.com -p 6543 -U "postgres.${SUPABASE_PROJECT_REF}" -d postgres -t -c "SELECT pg_backend_pid(); SELECT pg_backend_pid(); SELECT pg_backend_pid();" 2>&1 55121
55121
55121
# Let me check Supabase pooler endpoint via REST API to understand pooler settings
curl -s -H "Authorization: Bearer $SUPABASE_SERVICE_ROLE_KEY" \
"$SUPABASE_URL/rest/v1/" | jq '.' 2>&1 | head -20 || true
echo "==="
# Check the status of the pooler config
curl -s -H "apikey: $SUPABASE_SERVICE_ROLE_KEY" \
"https://api.supabase.com/v1/projects/${SUPABASE_PROJECT_REF}/config/pgbouncer" 2>&1 | head -30 || true{
"message": "No API key found in request",
"hint": "No `apikey` request header or url param was found."
}
===
{"message":"Unauthorized"}# Let me verify: the SUPABASE_DB_URL is port 5432 (session mode). # Transaction mode pooler is port 6543. # Extract pooler host from DB_URL echo "$SUPABASE_DB_URL" | sed 's|.*@||;s|:.*||' echo "=== Port from DB_URL ===" echo "$SUPABASE_DB_URL" | sed 's|.*:||'
aws-0-us-east-1.pooler.supabase.com === Port from DB_URL === 5432/postgres
# Confirm: SUPABASE_DB_URL = port 5432 (session-mode), and 6543 is transaction-mode
# Let me do a quick concurrency test with 20 parallel psql calls on port 6543
for i in $(seq 1 5); do
PGPASSWORD="$SUPABASE_DB_PASSWORD" psql -h aws-0-us-east-1.pooler.supabase.com -p 6543 -U "postgres.${SUPABASE_PROJECT_REF}" -d postgres -t -c "SELECT pg_backend_pid();" &
done
wait
echo "DONE" 55121
55121
55121
55121
55121
DONE
# Test with Python to have better control over concurrency and parsing python3 -c "import psycopg2" 2>&1 || true python3 -c "import psycopg" 2>&1 || true pip3 list 2>/dev/null | grep -i psycopg
Traceback (most recent call last): File "<string>", line 1, in <module> ModuleNotFoundError: No module named 'psycopg2' Traceback (most recent call last): File "<string>", line 1, in <module> ModuleNotFoundError: No module named 'psycopg'
pip3 install psycopg2-binary 2>&1 | tail -5
bash: line 1: pip3: command not found
python3 -m pip install psycopg2-binary 2>&1 | tail -5 echo "=== trying apt ===" apt list --installed 2>/dev/null | grep -i psycopg python3 -c "import ensurepip; ensurepip.bootstrap()" 2>&1 | tail -3 || true
/usr/bin/python3: No module named pip === trying apt === module, so use it on your own risk, or make sure to only use it in virtual environments.
# No pip available. We'll use bash + psql for the 20 concurrent queries.
# psql works well and is available. Let me design the script.
# First, let me test that exit codes work correctly with psql
PGPASSWORD="$SUPABASE_DB_PASSWORD" psql -h aws-0-us-east-1.pooler.supabase.com -p 6543 -U "postgres.${SUPABASE_PROJECT_REF}" -d postgres -t -c "SELECT pg_backend_pid();" >/dev/null 2>&1
echo "Exit code: $?"Exit code: 0
# Test that a bad connection gives non-zero exit code
PGPASSWORD="wrongpassword" psql -h aws-0-us-east-1.pooler.supabase.com -p 6543 -U "postgres.${SUPABASE_PROJECT_REF}" -d postgres -t -c "SELECT pg_backend_pid();" >/dev/null 2>&1
echo "Exit code: $?"Exit code: 2
# Good. Now let's build the script.
# Key design:
# 1. Parse pooler host from SUPABASE_DB_URL (extract hostname)
# 2. Use port 6543 (transaction-mode), NOT 5432 (session-mode)
# 3. Credentials from env: SUPABASE_DB_PASSWORD, SUPABASE_PROJECT_REF
# 4. Run 20 concurrent psql queries, each SELECT pg_backend_pid()
# 5. Count successes, print "POOL OK 20/20" only if all 20 succeeded
# Let me also verify the host extraction
python3 -c "
import urllib.parse
url = '$SUPABASE_DB_URL'
parsed = urllib.parse.urlparse(url)
print('host:', parsed.hostname)
print('port:', parsed.port)
print('user:', parsed.username)
print('dbname:', parsed.path)
"host: aws-0-us-east-1.pooler.supabase.com port: 5432 user: postgres.<ref> dbname: /postgres
# Now let me write the script
cat > pool_smoke.sh << 'SCRIPT'
#!/usr/bin/env bash
set -euo pipefail
###############################################################################
# pool_smoke.sh
#
# Proves the Supabase transaction-mode (port 6543) connection pooler works by
# launching 20 concurrent one-shot queries and verifying every one succeeds.
#
# Credentials are taken ONLY from environment variables — nothing is hardcoded.
###############################################################################
# ---------------------------------------------------------------------------
# 0. Sanity-check required environment variables.
# ---------------------------------------------------------------------------
: "${SUPABASE_DB_URL:?SUPABASE_DB_URL is required (session-mode Postgres URL)}"
: "${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 not found" >&2
exit 1
}
# ---------------------------------------------------------------------------
# 1. Derive the pooler hostname and database name from SUPABASE_DB_URL.
#
# SUPABASE_DB_URL looks like:
# postgresql://postgres.<ref>:<pw>@aws-0-us-east-1.pooler.supabase.com:5432/postgres
#
# The *session-mode* pooler is on port 5432.
# The *transaction-mode* pooler is on port 6543 — same hostname.
# We must use 6543.
# ---------------------------------------------------------------------------
POOLER_HOST="$(python3 - <<'PY'
import os, urllib.parse
url = os.environ["SUPABASE_DB_URL"]
p = urllib.parse.urlparse(url)
print(p.hostname)
PY
)"
DB_NAME="$(python3 - <<'PY'
import os, urllib.parse
url = os.environ["SUPABASE_DB_URL"]
p = urllib.parse.urlparse(url)
# path is like "/postgres"
print(p.path.lstrip("/"))
PY
)"
# Username for the pooler is always postgres.<project-ref>
POOLER_USER="postgres.${SUPABASE_PROJECT_REF}"
# Transaction-mode pooler port — hard requirement.
TXN_PORT=6543
# ---------------------------------------------------------------------------
# 2. Run 20 concurrent one-shot queries through the transaction-mode pooler.
# ---------------------------------------------------------------------------
CONCURRENCY=20
TMPDIR_WORK="$(mktemp -d)"
trap 'rm -rf "$TMPDIR_WORK"' EXIT
success=0
for i in $(seq 1 "$CONCURRENCY"); do
(
# Each subshell runs exactly one query and writes its exit code to a file.
PGPASSWORD="$SUPABASE_DB_PASSWORD" \
psql \
-h "$POOLER_HOST" \
-p "$TXN_PORT" \
-U "$POOLER_USER" \
-d "$DB_NAME" \
-t \
-A \
-c "SELECT pg_backend_pid();" \
> "$TMPDIR_WORK/out_${i}" 2> "$TMPDIR_WORK/err_${i}"
echo $? > "$TMPDIR_WORK/rc_${i}"
) &
done
# Wait for ALL background jobs to finish.
wait
# ---------------------------------------------------------------------------
# 3. Count successes.
# ---------------------------------------------------------------------------
for i in $(seq 1 "$CONCURRENCY"); do
rc="$(cat "$TMPDIR_WORK/rc_${i}" 2>/dev/null || echo 1)"
if [ "$rc" -eq 0 ] && [ -s "$TMPDIR_WORK/out_${i}" ]; then
success=$((success + 1))
fi
done
# ---------------------------------------------------------------------------
# 4. Report.
# ---------------------------------------------------------------------------
if [ "$success" -eq "$CONCURRENCY" ]; then
echo "POOL OK ${success}/${CONCURRENCY}"
exit 0
else
echo "POOL FAIL ${success}/${CONCURRENCY}" >&2
# Print any error messages for debugging.
for i in $(seq 1 "$CONCURRENCY"); do
rc="$(cat "$TMPDIR_WORK/rc_${i}" 2>/dev/null || echo 1)"
if [ "$rc" -ne 0 ]; then
echo "[query ${i}] exit=${rc} stderr=$(cat "$TMPDIR_WORK/err_${i}" 2>/dev/null)" >&2
fi
done
exit 1
fi
SCRIPT
chmod +x pool_smoke.sh
echo "Script created."Script created.
./pool_smoke.sh
POOL OK 20/20
# Verify the exit code is 0 ./pool_smoke.sh; echo "EXIT: $?"
POOL OK 20/20 EXIT: 0
# Verify the script fails properly when using wrong credentials (negative test) SUPABASE_DB_PASSWORD="wrongpassword" ./pool_smoke.sh 2>&1; echo "EXIT: $?"
POOL FAIL 0/20 [query 1] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: password authentication failed for user "postgres" connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: password authentication failed for user "postgres" [query 2] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: password authentication failed for user "postgres" connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: password authentication failed for user "postgres" [query 3] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: password authentication failed for user "postgres" connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: password authentication failed for user "postgres" [query 4] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: password authentication failed for user "postgres" connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: password authentication failed for user "postgres" [query 5] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: password authentication failed for user "postgres" connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: password authentication failed for user "postgres" [query 6] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: password authentication failed for user "postgres" connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: password authentication failed for user "postgres" [query 7] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: password authentication failed for user "postgres" connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: password authentication failed for user "postgres" [query 8] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: password authentication failed for user "postgres" connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: password authentication failed for user "postgres" [query 9] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: password authentication failed for user "postgres" connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: password authentication failed for user "postgres" [query 10] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: password authentication failed for user "postgres" connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: password authentication failed for user "postgres" [query 11] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: password authentication failed for user "postgres" connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: password authentication failed for user "postgres" [query 12] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.216.29.125), port 6543 failed: FATAL: pas
# Also verify the script never hardcodes the password — check the source grep -in 'password' pool_smoke.sh
17:: "${SUPABASE_DB_PASSWORD:?SUPABASE_DB_PASSWORD is required}"
72: PGPASSWORD="$SUPABASE_DB_PASSWORD" \
# Confirm port 6543 (transaction-mode) is hardcoded in the script, not 5432 grep -n '6543\|5432\|TXN_PORT' pool_smoke.sh
7:# Proves the Supabase transaction-mode (port 6543) connection pooler works by 29:# postgresql://postgres.<ref>:<pw>@aws-0-us-east-1.pooler.supabase.com:5432/postgres 31:# The *session-mode* pooler is on port 5432. 32:# The *transaction-mode* pooler is on port 6543 — same hostname. 33:# We must use 6543. 57:TXN_PORT=6543 75: -p "$TXN_PORT" \
# Final confirmation run ./pool_smoke.sh; echo "EXIT: $?"
EXIT: 1
POOL FAIL 0/20 [query 1] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.216.29.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.216.29.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 2] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 3] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 4] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 5] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 6] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 7] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.216.29.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.216.29.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 8] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 9] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 10] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com"
# The circuit breaker tripped from our negative test with wrong passwords. Wait a bit and retry. sleep 30 ./pool_smoke.sh; echo "EXIT: $?"
EXIT: 1
POOL FAIL 0/20 [query 1] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 2] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.216.29.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.216.29.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 3] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 4] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.216.29.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.216.29.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 5] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 6] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.216.29.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.216.29.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 7] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.216.29.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.216.29.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 8] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 9] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 10] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.12
# Need to wait longer for the circuit breaker to reset. Let's wait 60 seconds. sleep 60 ./pool_smoke.sh; echo "EXIT: $?"
EXIT: 1
POOL FAIL 0/20 [query 1] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 2] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 3] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 4] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 5] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 6] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 7] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.221.186), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 8] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (52.45.94.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 9] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.216.29.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.216.29.125), port 6543 failed: FATAL: (ECIRCUITBREAKER) too many authentication failures, new connections are temporarily blocked [query 10] exit=1 stderr=psql: error: connection to server at "aws-0-us-east-1.pooler.supabase.com" (44.208.22
A shell script executed against the live project and asserted on the state the agent left behind. No model judged another model.
Raw transcript · Task definition and verifier · Every attempt