"auth" schema differs between CLI setup and cloud, 'column "scopes" of relation "sessions" does not exist' #41110
Unanswered
stefan-girlich
asked this question in
Questions
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
I'm frequently mirroring data from my prod environment (cloud) to my local environment (CLI, v2.65.5).
Today I noticed that my mirroring script (using
supabase db dumpandpsql) failed with the following error when trying to ingest the prod data in my local database:The "scopes" column is actually missing in my local
auth.sessionstable. My workaround is to manually add the missing column:Another approach could be to exclude the table from the data dump via
supabase db dump --exclude <table_name>.Until now, the latest cloud and CLI schemas have always been in sync for me.
Would somebody know if this discrepancy is just a one-off or if I should prepare for more? Maybe somebody from the team can share what the policy is. I know that the
authschema is specifically protected, so maybe special rules apply concerning the tables.Beta Was this translation helpful? Give feedback.
All reactions