Local server unable to start due to analytics bucket

[leandrocabranes]

Bug report

• I confirm this is a bug with Supabase, not with my own application.
• I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

When I try to start local development I get a 500 DatabaseError and the project fails to start.

To Reproduce

Update the supabase cli to version 2.31.4 and restart local development by:

1. executing supabase stop --no-backup on the project terminal
2. erasing docker images and volumes
3. running supabase start
4. the console outputs the following error:

Error status 500: {"statusCode":"500","code":"DatabaseError","error":"DatabaseError","message":"select * from ((select \"id\", \"name\", \"type\", \"public\", \"owner\", \"created_at\", \"updated_at\", \"file_size_limit\", \"allowed_mime_types\" from \"buckets\") union all (select \"id\", \"id\" as \"name\", \"type\", null as \"public\", null as \"owner\", \"created_at\", \"updated_at\", null as \"file_size_limit\", null as \"allowed_mime_types\" from \"buckets_analytics\")) as \"all_buckets\" - column \"type\" does not exist"}

Expected behavior

The local development server should start with no problem, but it does not.

System information

• OS: macOS 15.5
• Supabase-cli: 2.31.4
• Node.js: 24.4.0

Additional context

It looks like the issue is the new Iceberg Analytics Bucket that is not available yet to execute locally.

[danieldunderfelt]

Same here. I managed to break the local Supabase somehow and went to upgrade to try and fix the problem. Then ran into this. I hope it is fixed promptly!

[LeonSchallenberg]

Same behaviour here. no matter what i try the local supabase setup is broken. Did not change anything on my side besides upgrading the cli and now i am receiving the exact same issue as mentioned above. A complete showstopper for any local development

[clydeso]

Can also confirm that I'm running into the same issue! Guess it's time for an extended coffee!

[leandrocabranes]

I think that since the error is a 500, the error is on the server side (supabase itself), and should be fixed once they do whatever they need to do there. The other thing I think that might fix this, is getting accepted in the Iceberg Analytics Bucket beta, which could explain how this got to production without anyone in the internal team (which of course have access to the Iceberg Analytics Bucket beta program) running into this.

[sweatybridge]

Could you run supabase link again just to make sure all the local versions match your hosted project?

supabase/supabase#37180 (comment)

[schmingle]

Seeing the same error. Was able to unblock by rolling back:

npm install supabase@2.31.2 --save-dev

[danieldunderfelt]

Could you run supabase link again just to make sure all the local versions match your hosted project?

supabase/supabase#37180 (comment)

This doesn't help. I have removed the .temp folder, ran link many times, to no avail. I just started using 3.31.2 which works, any version above that is catastrophically broken @sweatybridge

[sweatybridge]

@danieldunderfelt another alternative is to rm supabase/.temp/storage-version so the storage schema is updated to latest.

Unfortunately we can't rollback storage version because it would break users who are already using the new one.

Our storage team is already working on a fix so we can roll forward.

[dev-hcg-smg]

@danieldunderfelt another alternative is to rm supabase/.temp/storage-version so the storage schema is updated to latest.

Unfortunately we can't rollback storage version because it would break users who are already using the new one.

Our storage team is already working on a fix so we can roll forward.

I encountered the same issue, and applying this fix resolved it. thank you @sweatybridge

[leandrocabranes]

@sweatybridge what you suggested fixed my local environment. Thank you.

[RoadToDev101]

Remove the temp folder in /supabase dir and run npx supabase start again and you will be good.

[jamestakeshi]

Thanks @sweatybridge. Your fix worked for me.

[eeston]

Thanks @sweatybridge 🫶