Drizzle Team•2mo ago

drizzle studio initial load works, then everything after fails

when I start drizzle studio, then the initial load works, but if I click on a table, then it freezes and eventually gives the error

AxiosError: Request aborted
    at R.onabort (https://local.drizzle.studio/index.js:101952:6003)
    at fU.request (https://local.drizzle.studio/index.js:101954:2098)
    at async H (https://local.drizzle.studio/index.js:101955:6389)
    at async Object.query (https://local.drizzle.studio/index.js:101950:354551)
    at async Promise.all (index 0)
    at async Hzn (https://local.drizzle.studio/index.js:1185:98)
    at async mUn (https://local.drizzle.studio/index.js:1524:15147)
    at async pull (https://local.drizzle.studio/index.js:1524:33932)

AxiosError: Request aborted
    at R.onabort (https://local.drizzle.studio/index.js:101952:6003)
    at fU.request (https://local.drizzle.studio/index.js:101954:2098)
    at async H (https://local.drizzle.studio/index.js:101955:6389)
    at async Object.query (https://local.drizzle.studio/index.js:101950:354551)
    at async Promise.all (index 0)
    at async Hzn (https://local.drizzle.studio/index.js:1185:98)
    at async mUn (https://local.drizzle.studio/index.js:1524:15147)
    at async pull (https://local.drizzle.studio/index.js:1524:33932)

if I stop drizzle studio, start it again, then refresh the page, it will load the table I selected before, but then any action after that fails again. don't see any errors in my terminal and in the console I see these, but not sure they are even relevant

16 Replies

⚡Z.E.U.S⚡•2mo ago

@Amos Are you using Supabase?

AmosOP•2mo ago

no, and this is locally using postgres.app, not sure why it's happening but it's specific to this project, since other projects I have work fine

⚡Z.E.U.S⚡•2mo ago

Maybe you could provide a short video?

AmosOP•2mo ago

@⚡Z.E.U.S⚡ ok something weird happened. I waited a long time again and instead of the error it eventually started working, but then when I stopped drizzle studio and restarted it the same thing happened again I will record a video

AmosOP•2mo ago

it's still processing but here is the video https://streamable.com/80t9oa

Streamable

Watch drizzle-studio-error | Streamable

Watch "drizzle-studio-error" on Streamable.

⚡Z.E.U.S⚡•2mo ago

Can you check the permissions for Arc? https://postgresapp.com/documentation/app-permissions.html

Postgres.app

Client App Permissions

Postgres.app is a full featured PostgreSQL installation packaged as a standard Mac app.

AmosOP•2mo ago

Arc is not in that list, but like I said, drizzle studio works fine for other projects so not sure if that would be it

⚡Z.E.U.S⚡•2mo ago

Oh, sorry - I meant the terminal where you run drizzle-kit studio. I downloaded Postgres.app, and after running drizzle-kit studio and opening the studio, Postgres.app asks for permission for my terminal/IDE. I encountered the same issue before allowing the permission.

AmosOP•2mo ago

yeah it's all set fine another weird behaviour: if I stop and start the database while drizzle studio is running, then it works fine afterwards 😕 let me show you what I mean

⚡Z.E.U.S⚡•2mo ago

Maybe try disabling the permission dialog?

AmosOP•2mo ago

tried that, but doesn't work unfortunately 😭 o wait nope in pg_hba.conf everything is also set to "trust"

⚡Z.E.U.S⚡•2mo ago

Is this your URL structure? postgres://localhost/{db_name}

AmosOP•2mo ago

DATABASE_URL=postgres://amosbastian:postgres@localhost:5432/db

DATABASE_URL=postgres://amosbastian:postgres@localhost:5432/db

⚡Z.E.U.S⚡•2mo ago

Maybe it’s related to the reindexing warning?

AmosOP•2mo ago

yay that fixed it I tried it before and it was hanging found out one of my tables (mastra_traces) was 64 GB 💀 because I've been trying https://mastra.ai/, truncated it and reindexed instantly thanks for the help 🫶

Gaming

Programming

drizzle studio initial load works, then everything after fails

Did you find this page helpful?