Function connectWithRetry

packages/db/scripts/migrate.ts:134–149

* Open the migration session before taking the advisory lock, retrying * transient connection failures with bounded backoff. The deploy database can * briefly exhaust every non-superuser connection slot at peak (`53300`); the * migration is a single short-lived session, so waiting out a spike tha

()

 * errors (auth, unknown host config, etc.) still fail fast.
 */
async function connectWithRetry(): Promise<void> {
  for (let attempt = 1; ; attempt++) {
    try {
      await client`SELECT 1`
      return
    } catch (error) {
      if (!isTransientConnectError(error) || attempt >= CONNECT_MAX_ATTEMPTS) throw error
      const delayMs = backoffWithJitter(attempt, null, CONNECT_RETRY_BACKOFF)
      console.warn(
        `WARN: database unavailable (${getPostgresErrorCode(error)}); ` +
          `attempt ${attempt}/${CONNECT_MAX_ATTEMPTS}, retrying in ${Math.round(delayMs)}ms.`
      )
      await sleep(delayMs)
    }
  }
}

/**
 * Acquire the cross-process migration lock, failing loudly after the deadline