Describe the bug
I'm unable to upgrade to the latest version.
Sent crash report: 3ebceb40d9de4dfba7016ce7b2e65b0c
I've tried any combination, however it's always crashing
To Reproduce
supabase db pull
supabase db pull --schema auth,storage
supabase link
supabase stop
supabase start
Expected behavior
Upgrade and being able to start the latest version.
Screenshots
System information
Rerun the failing command with --create-ticket flag.
- Ticket ID: 3ebceb40d9de4dfba7016ce7b2e65b0c
- Version of OS: macOs
- Version of CLI: 2.22.12
- Version of Docker: [e.g. v25.0.3]
- Versions of services: [output from
supabase services command]
Additional context
supabase start --create-ticket
WARN: no SMS provider is enabled. Disabling phone login
WARNING: analytics requires mounting default docker socket: /var/run/docker.sock
supabase_auth_skillsociety container logs:
{"level":"info","msg":"Go runtime metrics collection started","time":"2025-05-18T11:22:34Z"}
{"args":[0.031647084],"component":"pop","level":"info","msg":"%.4f seconds","time":"2025-05-18T11:22:34Z"}
{"level":"fatal","msg":"running db migrations: error executing migrations/20240427152123_add_one_time_tokens_table.up.sql, sql: do $$ begin\n create type one_time_token_type as enum (\n 'confirmation_token',\n 'reauthentication_token',\n 'recovery_token',\n 'email_change_token_new',\n 'email_change_token_current',\n 'phone_change_token'\n );\nexception\n when duplicate_object then null;\nend $$;\n\n\ndo $$ begin\n create table if not exists auth.one_time_tokens (\n id uuid primary key,\n user_id uuid not null references auth.users on delete cascade,\n token_type one_time_token_type not null,\n token_hash text not null,\n relates_to text not null,\n created_at timestamp without time zone not null default now(),\n updated_at timestamp without time zone not null default now(),\n check (char_length(token_hash) \u003e 0)\n );\n\n begin\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using hash (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using hash (relates_to);\n exception when others then\n -- Fallback to btree indexes if hash creation fails\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using btree (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using btree (relates_to);\n end;\n\n create unique index if not exists one_time_tokens_user_id_token_type_key on auth.one_time_tokens (user_id, token_type);\nend $$;\n: ERROR: must be owner of table one_time_tokens (SQLSTATE 42501)","time":"2025-05-18T11:22:34Z"}
{"level":"info","msg":"Go runtime metrics collection started","time":"2025-05-18T11:22:35Z"}
{"args":[0.025333208],"component":"pop","level":"info","msg":"%.4f seconds","time":"2025-05-18T11:22:35Z"}
{"level":"fatal","msg":"running db migrations: error executing migrations/20240427152123_add_one_time_tokens_table.up.sql, sql: do $$ begin\n create type one_time_token_type as enum (\n 'confirmation_token',\n 'reauthentication_token',\n 'recovery_token',\n 'email_change_token_new',\n 'email_change_token_current',\n 'phone_change_token'\n );\nexception\n when duplicate_object then null;\nend $$;\n\n\ndo $$ begin\n create table if not exists auth.one_time_tokens (\n id uuid primary key,\n user_id uuid not null references auth.users on delete cascade,\n token_type one_time_token_type not null,\n token_hash text not null,\n relates_to text not null,\n created_at timestamp without time zone not null default now(),\n updated_at timestamp without time zone not null default now(),\n check (char_length(token_hash) \u003e 0)\n );\n\n begin\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using hash (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using hash (relates_to);\n exception when others then\n -- Fallback to btree indexes if hash creation fails\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using btree (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using btree (relates_to);\n end;\n\n create unique index if not exists one_time_tokens_user_id_token_type_key on auth.one_time_tokens (user_id, token_type);\nend $$;\n: ERROR: must be owner of table one_time_tokens (SQLSTATE 42501)","time":"2025-05-18T11:22:35Z"}
{"level":"info","msg":"Go runtime metrics collection started","time":"2025-05-18T11:22:35Z"}
{"args":[0.011087584],"component":"pop","level":"info","msg":"%.4f seconds","time":"2025-05-18T11:22:35Z"}
{"level":"fatal","msg":"running db migrations: error executing migrations/20240427152123_add_one_time_tokens_table.up.sql, sql: do $$ begin\n create type one_time_token_type as enum (\n 'confirmation_token',\n 'reauthentication_token',\n 'recovery_token',\n 'email_change_token_new',\n 'email_change_token_current',\n 'phone_change_token'\n );\nexception\n when duplicate_object then null;\nend $$;\n\n\ndo $$ begin\n create table if not exists auth.one_time_tokens (\n id uuid primary key,\n user_id uuid not null references auth.users on delete cascade,\n token_type one_time_token_type not null,\n token_hash text not null,\n relates_to text not null,\n created_at timestamp without time zone not null default now(),\n updated_at timestamp without time zone not null default now(),\n check (char_length(token_hash) \u003e 0)\n );\n\n begin\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using hash (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using hash (relates_to);\n exception when others then\n -- Fallback to btree indexes if hash creation fails\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using btree (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using btree (relates_to);\n end;\n\n create unique index if not exists one_time_tokens_user_id_token_type_key on auth.one_time_tokens (user_id, token_type);\nend $$;\n: ERROR: must be owner of table one_time_tokens (SQLSTATE 42501)","time":"2025-05-18T11:22:35Z"}
{"level":"info","msg":"Go runtime metrics collection started","time":"2025-05-18T11:22:36Z"}
{"args":[0.019492458],"component":"pop","level":"info","msg":"%.4f seconds","time":"2025-05-18T11:22:36Z"}
{"level":"fatal","msg":"running db migrations: error executing migrations/20240427152123_add_one_time_tokens_table.up.sql, sql: do $$ begin\n create type one_time_token_type as enum (\n 'confirmation_token',\n 'reauthentication_token',\n 'recovery_token',\n 'email_change_token_new',\n 'email_change_token_current',\n 'phone_change_token'\n );\nexception\n when duplicate_object then null;\nend $$;\n\n\ndo $$ begin\n create table if not exists auth.one_time_tokens (\n id uuid primary key,\n user_id uuid not null references auth.users on delete cascade,\n token_type one_time_token_type not null,\n token_hash text not null,\n relates_to text not null,\n created_at timestamp without time zone not null default now(),\n updated_at timestamp without time zone not null default now(),\n check (char_length(token_hash) \u003e 0)\n );\n\n begin\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using hash (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using hash (relates_to);\n exception when others then\n -- Fallback to btree indexes if hash creation fails\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using btree (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using btree (relates_to);\n end;\n\n create unique index if not exists one_time_tokens_user_id_token_type_key on auth.one_time_tokens (user_id, token_type);\nend $$;\n: ERROR: must be owner of table one_time_tokens (SQLSTATE 42501)","time":"2025-05-18T11:22:36Z"}
{"level":"info","msg":"Go runtime metrics collection started","time":"2025-05-18T11:22:37Z"}
{"args":[0.034640208],"component":"pop","level":"info","msg":"%.4f seconds","time":"2025-05-18T11:22:37Z"}
{"level":"fatal","msg":"running db migrations: error executing migrations/20240427152123_add_one_time_tokens_table.up.sql, sql: do $$ begin\n create type one_time_token_type as enum (\n 'confirmation_token',\n 'reauthentication_token',\n 'recovery_token',\n 'email_change_token_new',\n 'email_change_token_current',\n 'phone_change_token'\n );\nexception\n when duplicate_object then null;\nend $$;\n\n\ndo $$ begin\n create table if not exists auth.one_time_tokens (\n id uuid primary key,\n user_id uuid not null references auth.users on delete cascade,\n token_type one_time_token_type not null,\n token_hash text not null,\n relates_to text not null,\n created_at timestamp without time zone not null default now(),\n updated_at timestamp without time zone not null default now(),\n check (char_length(token_hash) \u003e 0)\n );\n\n begin\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using hash (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using hash (relates_to);\n exception when others then\n -- Fallback to btree indexes if hash creation fails\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using btree (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using btree (relates_to);\n end;\n\n create unique index if not exists one_time_tokens_user_id_token_type_key on auth.one_time_tokens (user_id, token_type);\nend $$;\n: ERROR: must be owner of table one_time_tokens (SQLSTATE 42501)","time":"2025-05-18T11:22:37Z"}
{"level":"info","msg":"Go runtime metrics collection started","time":"2025-05-18T11:22:38Z"}
{"args":[0.029016542],"component":"pop","level":"info","msg":"%.4f seconds","time":"2025-05-18T11:22:38Z"}
{"level":"fatal","msg":"running db migrations: error executing migrations/20240427152123_add_one_time_tokens_table.up.sql, sql: do $$ begin\n create type one_time_token_type as enum (\n 'confirmation_token',\n 'reauthentication_token',\n 'recovery_token',\n 'email_change_token_new',\n 'email_change_token_current',\n 'phone_change_token'\n );\nexception\n when duplicate_object then null;\nend $$;\n\n\ndo $$ begin\n create table if not exists auth.one_time_tokens (\n id uuid primary key,\n user_id uuid not null references auth.users on delete cascade,\n token_type one_time_token_type not null,\n token_hash text not null,\n relates_to text not null,\n created_at timestamp without time zone not null default now(),\n updated_at timestamp without time zone not null default now(),\n check (char_length(token_hash) \u003e 0)\n );\n\n begin\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using hash (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using hash (relates_to);\n exception when others then\n -- Fallback to btree indexes if hash creation fails\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using btree (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using btree (relates_to);\n end;\n\n create unique index if not exists one_time_tokens_user_id_token_type_key on auth.one_time_tokens (user_id, token_type);\nend $$;\n: ERROR: must be owner of table one_time_tokens (SQLSTATE 42501)","time":"2025-05-18T11:22:38Z"}
{"level":"info","msg":"Go runtime metrics collection started","time":"2025-05-18T11:22:42Z"}
{"args":[0.018789542],"component":"pop","level":"info","msg":"%.4f seconds","time":"2025-05-18T11:22:42Z"}
{"level":"fatal","msg":"running db migrations: error executing migrations/20240427152123_add_one_time_tokens_table.up.sql, sql: do $$ begin\n create type one_time_token_type as enum (\n 'confirmation_token',\n 'reauthentication_token',\n 'recovery_token',\n 'email_change_token_new',\n 'email_change_token_current',\n 'phone_change_token'\n );\nexception\n when duplicate_object then null;\nend $$;\n\n\ndo $$ begin\n create table if not exists auth.one_time_tokens (\n id uuid primary key,\n user_id uuid not null references auth.users on delete cascade,\n token_type one_time_token_type not null,\n token_hash text not null,\n relates_to text not null,\n created_at timestamp without time zone not null default now(),\n updated_at timestamp without time zone not null default now(),\n check (char_length(token_hash) \u003e 0)\n );\n\n begin\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using hash (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using hash (relates_to);\n exception when others then\n -- Fallback to btree indexes if hash creation fails\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using btree (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using btree (relates_to);\n end;\n\n create unique index if not exists one_time_tokens_user_id_token_type_key on auth.one_time_tokens (user_id, token_type);\nend $$;\n: ERROR: must be owner of table one_time_tokens (SQLSTATE 42501)","time":"2025-05-18T11:22:42Z"}
{"level":"info","msg":"Go runtime metrics collection started","time":"2025-05-18T11:22:48Z"}
{"args":[0.020389166],"component":"pop","level":"info","msg":"%.4f seconds","time":"2025-05-18T11:22:48Z"}
{"level":"fatal","msg":"running db migrations: error executing migrations/20240427152123_add_one_time_tokens_table.up.sql, sql: do $$ begin\n create type one_time_token_type as enum (\n 'confirmation_token',\n 'reauthentication_token',\n 'recovery_token',\n 'email_change_token_new',\n 'email_change_token_current',\n 'phone_change_token'\n );\nexception\n when duplicate_object then null;\nend $$;\n\n\ndo $$ begin\n create table if not exists auth.one_time_tokens (\n id uuid primary key,\n user_id uuid not null references auth.users on delete cascade,\n token_type one_time_token_type not null,\n token_hash text not null,\n relates_to text not null,\n created_at timestamp without time zone not null default now(),\n updated_at timestamp without time zone not null default now(),\n check (char_length(token_hash) \u003e 0)\n );\n\n begin\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using hash (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using hash (relates_to);\n exception when others then\n -- Fallback to btree indexes if hash creation fails\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using btree (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using btree (relates_to);\n end;\n\n create unique index if not exists one_time_tokens_user_id_token_type_key on auth.one_time_tokens (user_id, token_type);\nend $$;\n: ERROR: must be owner of table one_time_tokens (SQLSTATE 42501)","time":"2025-05-18T11:22:48Z"}
{"level":"info","msg":"Go runtime metrics collection started","time":"2025-05-18T11:23:01Z"}
{"args":[0.02427375],"component":"pop","level":"info","msg":"%.4f seconds","time":"2025-05-18T11:23:02Z"}
{"level":"fatal","msg":"running db migrations: error executing migrations/20240427152123_add_one_time_tokens_table.up.sql, sql: do $$ begin\n create type one_time_token_type as enum (\n 'confirmation_token',\n 'reauthentication_token',\n 'recovery_token',\n 'email_change_token_new',\n 'email_change_token_current',\n 'phone_change_token'\n );\nexception\n when duplicate_object then null;\nend $$;\n\n\ndo $$ begin\n create table if not exists auth.one_time_tokens (\n id uuid primary key,\n user_id uuid not null references auth.users on delete cascade,\n token_type one_time_token_type not null,\n token_hash text not null,\n relates_to text not null,\n created_at timestamp without time zone not null default now(),\n updated_at timestamp without time zone not null default now(),\n check (char_length(token_hash) \u003e 0)\n );\n\n begin\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using hash (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using hash (relates_to);\n exception when others then\n -- Fallback to btree indexes if hash creation fails\n create index if not exists one_time_tokens_token_hash_hash_idx on auth.one_time_tokens using btree (token_hash);\n create index if not exists one_time_tokens_relates_to_hash_idx on auth.one_time_tokens using btree (relates_to);\n end;\n\n create unique index if not exists one_time_tokens_user_id_token_type_key on auth.one_time_tokens (user_id, token_type);\nend $$;\n: ERROR: must be owner of table one_time_tokens (SQLSTATE 42501)","time":"2025-05-18T11:23:02Z"}
Stopping containers...
supabase_auth_skillsociety container is not ready: unhealthy
Try rerunning the command with --debug to troubleshoot the error.
Sent crash report: 3ebceb40d9de4dfba7016ce7b2e65b0c
