setup-cli icon indicating copy to clipboard operation
setup-cli copied to clipboard

gen_salt does not exist in github action

Open jongrim opened this issue 1 year ago • 0 comments

Bug report

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

Describe the bug

When using supabase/setup-cli with postgres 14, gen_salt does not exist.

To Reproduce

Sample github workflow

This workflow results in the following error:

Setting up initial schema...
Seeding globals from roles.sql...
Applying migration 20231011094125_remote_schema.sql...
Applying migration 20231011124214_add_create_new_profile_trigger.sql...
Applying migration 20231012051835_fix_db_lint.sql...
Applying migration 20231020114830_add_community_access_constraint.sql...
Applying migration 20231101212133_user_settings.sql...
Applying migration 20231206121703_update_communities_allow_pre_seat.sql...
Applying migration 20240211173256_draft_games.sql...
Applying migration 20240223203511_remote_schema.sql...
Applying migration 20240227071349_webcal.sql...
Applying migration 20240227211909_fix-json-parse-notifications.sql...
Seeding data from supabase/seed.sql...
Stopping containers...
failed to send batch: ERROR: function gen_salt(unknown) does not exist (SQLSTATE 42883)

Also noteworthy is that one of my migrations does include enabling pgcrypto: CREATE EXTENSION IF NOT EXISTS "pgcrypto" WITH SCHEMA "extensions";

Expected behavior

gen_salt should exist when starting supabase db

System information

github runner is ubuntu-latest

Additional context

I had no issues with this in the past. It was only after returning from a few months away that this was found to have stopped working. I also asked about this on discord

jongrim avatar Jan 11 '25 10:01 jongrim