_k1ngarthur

Have you made any changes to the JWT signing keys in https://supabase.com/dashboard/project/_/settings/jwt

Judging by the docs it is available on self hosted

I believe that if you disconnect from supabase inside vercel then you lose access to any vercel managed projects. Try creating a github account with the same email as vercel then sign in to supabase, that should link identities under the same email

What i might reccomend is add the tag for self hosting and one of the other community members whose more knowledgable about the volumes/containers might be able to help.

Looks cool, is high quality here in the sense of what you would be suited to work on so it is a distilled version of normal github issues?

I'm not sure if this is exactly what you are looking for but you could use S3 or ephemeral storage to read/write files https://supabase.com/docs/guides/functions/ephemeral-storage

Make sure to had project stuck in the ticket description as that might make it more visible

You should be able to run that command from wherever psql is installed i believe. see the steps at top where it says `install Postgres and psql`

Is the UI custom built

That's pretty cool, not many apps that make use of some much of the Supabase stack

no worries

I think it should be fine, the examples i have seen of vault are used in edge functions which themselves can be called a lot

I think this is going to be something you have to file a support ticket for (if you haven't already). The only other thing that i could suggest is checking the API gateway logs and postgres logs before and after adding the data

What if you used vault to store secrets and then updated that secret using a Github Actions Workflow. At that point the only thing you might need is to update github with a new secret key if that is what was rotated?

So you used vercel with the supabase integration and it created a supabase account for you and now you want to log into that supabase account directly. Have you tried signing in with github with the same email that you used in vercel? Have you deleted or disconnected from supabase in vercel (because this will also remove your project completely)

Also explains why the without vault option where you pass it in directly works

Still investigating a bit more what is going on but what i see in https://supabase.com/dashboard/project/_/editor/16951?schema=vault is that when you create a vault secret a new `key_id` column that is being set to null. I think is the value that the wrappers expect inside of `api_key_id` and not the primary key. This is probably why on your first attempt you got the `api_key_id` not specified (as it is null) and then when you did set it to use `api_key_id` as the primary key you got that other error because it is not what it expected

What do you get when you run `explain analyze select key from xxx where id='<id>'; Swapped with = your table and any id

There was a similar issue recently from another user that they got resolved by reaching out to support, it was a case of being ddosed causing these long queries https://discord.com/channels/839993398554656828/1460158907342127259/1463142336568758272

Is it possible you have a space or anything at the start?

I am not sure what xxxx is in your situation but i was able to add this to my redirect config

That config woul explain that, i'm pretty sure that even if you toggle that to `true` , you will need to set up a custom SMTP server

Are you setting up with a custom SMTP server locally inside of your `config.toml`

Just to double check if you go into your dashboard for the edge function `create-user-profile` -> details do you see verify jwt turned off?

I suspect using `supporter(*)` returns it as a data type of any[] whereas in the latter case you actually selected the name so typescript can infer that it exists in the response

1) If you just need the user_id you might be better of using https://supabase.com/docs/reference/javascript/auth-getclaims and reading the `sub` field as that avoids making a call to the auth server. Is this client side code? Because if so you definitely should not be using the service role key. In this case though just using RLS and a regular client would also suffice i assume?

Yeah looks like it, i see there is a workaround mentioned. Not sure if that is something that will work for you but i reccomend leaving a comment on the issue since it's more likely to get attention that way.

We can add it a discord thread which is informal and someone on the actual supabase team can do the check

I've only been on pro when i emailed and they took ~1 day i think, i'm not sure what would happen in your case but if they don't come back after a few days you try dropping you ticket number in here and we can just check that it made it to the infra queue. But yeah give it a few days before doing that

Project pausing has never in the past affected organisations or deleted anything so i think it would be best to reach out to support to see what happened with your organisation

Looks cool, what parts of Supabase are you using

support@supabase.com

Has anyone else got permissions to the org recently, either a team member or even an Ai assisstant

If you created the project with Vercel have you disconnected from it recently? Is the project showing up in vercel

1) I believe all new projects will default to the latest postgres version available which is PG 17 in this case. 2) For specfic cosiderations see the section here about `Specific upgrade notes` https://supabase.com/docs/guides/platform/upgrading. Inder will probably help better for specific migration procedure

If it is in an unhealthy state, you can try restarting here https://supabase.com/dashboard/project/_/settings/general, if it paused it should give you the option to resume project if < 90 days and if more than 90 days it should allow you to download a backup which you can import to a new project

You can definitely transfer projects between organisations if you go into the transfer project settings here https://supabase.com/dashboard/project/_/settings/general but i'm not too sure what you mean by you cannot access the free one?

I'll see if anyone else has thoughts on what is causing that as i have to run off now but might try and dig into it tomorrow

Not sure if it will help but a look through a few other instances of "invalid eszip v2" issue on the discord history shows this https://discord.com/channels/839993398554656828/1377939075402563626 and https://discord.com/channels/839993398554656828/1361427301719478455/1361427301719478455. Unfortunately it doesn't seem like either of them are related to Stripe Sync engine (though there are other threads that do that are different)

was there anything of note in relation to ⁨`bucket_vectors`⁩

The database i think is quite simple and can be done with ⁨`pg_dump`⁩, see https://supabase.com/docs/guides/troubleshooting/transferring-from-cloud-to-self-host-in-supabase-2oWNvW. The storage might be a bit more complicated i think. There is this script https://colab.research.google.com/github/PLyn/supabase-storage-migrate/blob/main/Supabase_Storage_migration.ipynb#scrollTo=PuGNb3PrXRat which is used to migrate between projects, perhaps you can modify it to make it work for self hosted?

It is part of the storage schema

There is this disclaimer on the notes ⁨```If you run into any permission errors related to supabase_admin during restore, edit the schema.sql file and comment out any lines containing ALTER ... OWNER TO "supabase_admin".```⁩ . Worth checking the ⁨`schema.sql`⁩ anyway to see if anything looks strange about that table

I believe the situation with organisations is like that of projects where once they are deleted there is no way to get them back. You can try contacting support to double confirm this

This is a user forum so we can't do anything about these kind of issues unfortunately

Please file a support ticket and mention **project stuck when pausing** in the ticket

Are you/your vpn in any niche region?

That is a bit strange, if possible could you send console logs or anything that might help to see what error it gives when you try and access it with wifi

Hey there, this is a user helping user forum and so we can't do and checks like that on your project. Also this is the type of request that support might not be able to do as they cannot provide email details of a project without verifying the owner. If you have a handful of emails then i would suggest trying a password reset for these emails as that seems a lot safer

https://supabase.com/dashboard/support/new?projectRef=_