Timeouts when running simple queries, fixed for a little when restarting supabase project

Hey,

For some reason my supabase is getting a lot of timeouts after a while (less then an hour) and its fixed again when i restart my project.

I switched from Neon to Supabase, where this wasnt happening.

async_engine = create_async_engine(
    DATABASE_URL,
    pool_size=10,
    max_overflow=5,
    pool_timeout=30,
    pool_recycle=1800,
)

# Create a session maker
local_session = async_sessionmaker(
    bind=async_engine, class_=AsyncSession, expire_on_commit=False
)

async_engine = create_async_engine(
    DATABASE_URL,
    pool_size=10,
    max_overflow=5,
    pool_timeout=30,
    pool_recycle=1800,
)

# Create a session maker
local_session = async_sessionmaker(
    bind=async_engine, class_=AsyncSession, expire_on_commit=False
)

async_engine = create_async_engine(
    DATABASE_URL,
    pool_size=10,
    max_overflow=5,
    pool_timeout=30,
    pool_recycle=1800,
)

# Create a session maker
local_session = async_sessionmaker(
    bind=async_engine, class_=AsyncSession, expire_on_commit=False
)

async_engine = create_async_engine(
    DATABASE_URL,
    pool_size=10,
    max_overflow=5,
    pool_timeout=30,
    pool_recycle=1800,
)

# Create a session maker
local_session = async_sessionmaker(
    bind=async_engine, class_=AsyncSession, expire_on_commit=False
)

this is how i create my engine and session maker.

Does anyone know what could be causing this?

Timeouts when running simple queries, fixed for a little when restarting supabase project

Similar Threads

Similar Threads

Similar Threads