I get this error automatically sometimes (suddenly)
”MissingSessionTableError: Prisma session table does not exist. This could happen for a few reasons…”
This only happens in my shopify apps deployed over vercel, and using supabase pooler database url.
and no this is not migration or other type of setup issue, as it works perfectly and sometimes occurs, and then after sometimes gets auto solved!
and it happens only when there is very less activity in my app over some time. ( so might be something related to something going to sleep and not waking up)
As when i redeploy it instantly resolves it, so it confirms it might be related to some cache or sleep state.
i am not able to figure it out, so if someone else faced same issue and found a fix, it will be a great help!