Jul 8, 2025 · Jul 8, 2025 · Jul 8, 2025
diff --git a/coderd/database/db_test.go b/coderd/database/db_test.go
 func testSQLDB(t testing.TB) *sql.DB {
 t.Helper()

 if !dbtestutil.WillUsePostgres() {
 t.Skip("this test requires postgres")
 }

 connection, err := dbtestutil.Open(t)
 require.NoError(t, err)

diff --git a/coderd/database/dbtestutil/postgres.go b/coderd/database/dbtestutil/postgres.go
 }

 var dbErr error
 // Retry up to3 seconds for temporary errors.
 // Retry up to10 seconds for temporary errors.
 ctx, cancel := context.WithTimeout(context.Background(), 10*time.Second)
 defer cancel()
 for r := retry.New(10*time.Millisecond, 500*time.Millisecond); r.Wait(ctx); {
 if !containsAnySubstring(errString, retryableErrSubstrings) {
 break
 }
 t.Logf("failed to connect to postgres, retrying: %s", errString)
 t.Logf("%sfailed to connect to postgres, retrying: %s", time.Now().Format(time.StampMilli), errString)
 }

 // After the loop dbErr is the last connection error (if any).
Original file line number	Diff line number	Diff line change
Expand Up		@@ -85,6 +85,10 @@ func TestNestedInTx(t *testing.T) {
		func testSQLDB(t testing.TB) *sql.DB {
		t.Helper()

		if !dbtestutil.WillUsePostgres() {
		t.Skip("this test requires postgres")
		}

		connection, err := dbtestutil.Open(t)
		require.NoError(t, err)

Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -81,7 +81,7 @@ func initDefaultConnection(t TBSubset) error {
		}

		var dbErr error
		// Retry up to3 seconds for temporary errors.
		// Retry up to10 seconds for temporary errors.
		ctx, cancel := context.WithTimeout(context.Background(), 10*time.Second)
		defer cancel()
		for r := retry.New(10time.Millisecond, 500time.Millisecond); r.Wait(ctx); {
Expand All		@@ -93,7 +93,7 @@ func initDefaultConnection(t TBSubset) error {
		if !containsAnySubstring(errString, retryableErrSubstrings) {
		break
		}
		t.Logf("failed to connect to postgres, retrying: %s", errString)
		t.Logf("%sfailed to connect to postgres, retrying: %s", time.Now().Format(time.StampMilli), errString)
Copy link ContributorAuthor spikecurtisJul 8, 2025 Choose a reason for hiding this comment The reason will be displayed to describe this comment to others.Learn more. added this because it looks like we only retried 3 times, even though we're supposed to wait 10 seconds. Timestamp information will be helpful if we hit it again.
		}

		// After the loop dbErr is the last connection error (if any).
Expand Down