Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

An error occurs in the "user_metadata" column of the "objects" table while running npx supabase db reset command. #2637

Open
gopte100 opened this issue Aug 27, 2024 · 2 comments

Comments

@gopte100
Copy link

gopte100 commented Aug 27, 2024

Describe the bug
An error occurs in the "user_metadata" column of the "objects" table while running the npx supabase db reset --debug command.

Screenshots
image

System information

  • Ticket ID: 0540a80ea6ba44faa7f10aa3c61b7af3
  • Version of OS: macOS 14.5(23F79)
  • Version of CLI: 1.190.0
  • Version of Docker: 4.14.0 (91374)
  • Versions of services:
    SERVICE IMAGE │ LOCAL │ LINKED
    supabase/postgres │ 15.1.0.153 │ 15.1.0.153
    supabase/gotrue │ v2.148.0 │ v2.158.1
    postgrest/postgrest │ v12.0.1 │ v12.0.1
    supabase/realtime │ v2.30.23 │ -
    supabase/storage-api │ v0.48.4 │ v1.10.3
    supabase/edge-runtime │ v1.56.0 │ -
    supabase/studio │ 20240729-ce42139 │ -
    supabase/postgres-meta │ v0.83.2 │ -
    supabase/logflare │ 1.4.0 │ -
    supabase/supavisor │ 1.1.56 │ -
@tmountain
Copy link
Contributor

Not 100% sure, but I think this is because your storage-api is out of date locally.

@wassimbenr
Copy link

wassimbenr commented Sep 17, 2024

I discovered the issue: I had uploaded documents using the storage bucket, but the user who performed the upload had been deleted. The system checks the user's metadata associated with the upload.
To fix it, I deleted the file, pulled the seed data, and reset the database.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants