Skip to content

:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.

3.4 KB
Raw Blame
import { PostgresUse, handlePostgresError, isTransientPgError } from '~/common/utils/db/postgres'

describe('isTransientPgError', () => {
    it.each([
        ['connection to server at "pg:5432" refused'],
        ['could not translate host name "pg" to address'],
        ['server conn crashed'],
        ['no more connections allowed (max_client_conn)'],
        ['server closed the connection unexpectedly'],
        ['getaddrinfo EAI_AGAIN pg'],
        ['getaddrinfo ENOTFOUND pgbouncer-cloud-read'],
        ['Connection terminated unexpectedly'],
        ['connect ECONNREFUSED 127.0.0.1:5432'],
        ['read ECONNRESET'],
        ['connect ETIMEDOUT 10.0.0.1:5432'],
        ['query_wait_timeout'],
        ['server login has been failing, try again later (server_login_retry)'],
        ['Canceling statement due to conflict with recovery.'],
    ])('returns true for transient error "%s"', (message) => {
        expect(isTransientPgError(new Error(message))).toBe(true)
    })

    it.each([
        ['duplicate key value violates unique constraint'],
        ['relation "table" does not exist'],
        ['column "foo" of relation "cyclotron_jobs" does not exist'],
        ['syntax error at or near "SELECT"'],
        [''],
    ])('returns false for non-transient error "%s"', (message) => {
        expect(isTransientPgError(new Error(message))).toBe(false)
    })

    it('returns false when input is not an Error', () => {
        expect(isTransientPgError(undefined)).toBe(false)
        expect(isTransientPgError(null)).toBe(false)
        expect(isTransientPgError('ECONNREFUSED')).toBe(false)
    })
})

describe('handlePostgresError', () => {
    it.each([
        ['connection to server at "pg:5432" refused'],
        ['could not translate host name "pg" to address'],
        ['server conn crashed'],
        ['no more connections allowed (max_client_conn)'],
        ['server closed the connection unexpectedly'],
        ['getaddrinfo EAI_AGAIN pg'],
        ['getaddrinfo ENOTFOUND pgbouncer-cloud-read'],
        ['Connection terminated unexpectedly'],
        ['connect ECONNREFUSED 127.0.0.1:5432'],
        ['read ECONNRESET'],
        ['connect ETIMEDOUT 10.0.0.1:5432'],
        ['query_wait_timeout'],
        ['server login has been failing, try again later (server_login_retry)'],
        ['canceling statement due to conflict with recovery'],
        ['Canceling statement due to conflict with recovery.'],
    ])('throws retriable DependencyUnavailableError for "%s"', (message) => {
        expect(() => handlePostgresError(new Error(message), PostgresUse.COMMON_WRITE)).toThrow(
            expect.objectContaining({ name: 'DependencyUnavailableError', isRetriable: true })
        )
    })

    it.each([
        ['duplicate key value violates unique constraint'],
        ['relation "table" does not exist'],
        ['syntax error at or near "SELECT"'],
    ])('does not throw for non-transient error "%s"', (message) => {
        expect(() => handlePostgresError(new Error(message), PostgresUse.COMMON_WRITE)).not.toThrow()
    })

    it.each([
        ['could not serialize access due to concurrent update', '40001'],
        ['canceling statement due to statement timeout', '57014'],
    ])('does not throw for "%s", which shares SQLSTATE %s with a recovery conflict', (message, code) => {
        const error = Object.assign(new Error(message), { code })

        expect(() => handlePostgresError(error, PostgresUse.COMMON_WRITE)).not.toThrow()
    })
})