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

[gopte100]

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

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]

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

[wassimbenr]

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.

[sweatybridge]

closing as there are suggested workarounds.