Sessions out of sync after a Point-In-Time-Rollback - please help!
Hello - I performed a PITR on supabase, to a few hours ago, and now all of my users are unable to sign in or sign up - this is causing a major issue.
They try to sign-in and they get 'Database error granting user'
I've checked logs, seems to be a session/scopes issue (auth.sessions.scopes) - however, any SQL script I run is saying I must be the owner to change these tables.
What can I do to immediately fix this? Thank you so much!
7 Replies
What does project status on the project overview page look like?
Everything is healthy
When I disabled 'Detect and revoke potentially compromised refresh tokens' - people can login again
Where was this option?
/auth/sessions
Ahh , i would probably change that back if it was previously set by default. Is your application working now then?
Your restore might be missing this migration from last week.
https://github.com/supabase/auth/blob/master/migrations/20251111201300_add_scopes_to_sessions.up.sql
I've just tried running that - failed, due to 'Namespace'
Error: Failed to run sql query: ERROR: 42601: syntax error at or near "{" LINE 4: alter table if exists {{ index .Options "Namespace" }}.sessions ^
My application is working fine now - I'm going to keep it switched off for the timebeing, whilst trying to work a fix in the background.