Bug report Describe the bug Migrations are fai

Hi <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="

Hi <a class="user-mention notranslate" data-hovercard-type="user" data-ho

Migrations failing to run about storage HOT 6 CLOSED

supabase commented on July 25, 2024

Migrations failing to run

from storage.

Comments (6)

heromiyo commented on July 25, 2024 1

Thanks, that was the issue

from storage.

inian commented on July 25, 2024 1

Hi @difelice, can you check if postgrest has storage in PGRST_DB_SCHEMA like here

from storage.

inian commented on July 25, 2024

Hi @heromiyo, this happens if you don't have the search path set correctly. Can you ensure that the .env.sample file has been copied to .env and there is a PGOPTIONS in your .env file?

from storage.

difelice commented on July 25, 2024

I'm having similar issue running a container from supabase/storage-api, migrations worked fine, and PGOPTIONS is in the final env list, but for some reason it's still requesting on the public schema:

Docker Compose logs:

storage_1  | running migrations
storage_1  | finished migrations
storage_1  | [1623760631182] INFO (8 on 66b95fdc2426): Server listening at http://0.0.0.0:5000
storage_1  | Server listening at http://0.0.0.0:5000

rest_1      | 172.22.0.9 - - [15/Jun/2021:13:10:50 +0000] "GET /buckets?select=id%2Cname%2Cpublic%2Cowner%2Ccreated_at%2Cupdated_at HTTP/1.1" 404 - "" "node-fetch/1.0 (+https://github.com/bitinn/node-fetch)
kong_1      | 172.22.0.6 - - [15/Jun/2021:13:10:50 +0000] "GET /storage/v1/bucket HTTP/1.0" 400 88 "-" "PostmanRuntime/7.28.0"
storage_1   | [1623762650441] ERROR (1 on 076642b861e0): error bucket
storage_1   |       "hint": null,
storage_1   |       "details": null,
storage_1   |       "code": "42P01",
storage_1   |       "message": "relation \"public.buckets\" does not exist"
storage_1   |     }

$ docker compose exec storage /bin/bash -c 'env | grep PGO'
PGOPTIONS=-c search_path=storage

Database looks OK:

$ PGOPTIONS="-c search_path=storage" ./psql.sh 
Null display is "💩".
psql (12.6, server 12.3 (Debian 12.3-1.pgdg100+1))
Type "help" for help.

postgres=# \d
            List of relations
 Schema  |    Name    | Type  |  Owner   
---------+------------+-------+----------
 storage | buckets    | table | postgres
 storage | migrations | table | postgres
 storage | objects    | table | postgres
(3 rows)