./run_migrations.sh: no such file or directory":

[blaaaaaaa]

Sorry, this is probably quite a noob question.

Running docker-compose -f dockerfiles/docker-compose.yml run execute ./run_migrations.sh
will lead to
Error response from daemon: OCI runtime create failed: container_linux.go:349: starting container process caused "exec: "./run_migrations.sh": stat ./run_migrations.sh: no such file or directory": unknown
and I also so see no /run_migrations.sh.
What am I missing?

[rmulhol]

Thanks for reporting - looks like the path might be off there. The file you want lives here

[blaaaaaaa]

Hi, thx for the help, unfortunately I still dont get it to work. How is the command suppose to look now?

[rmulhol]

Sorry - I was mistaken. The path is right, but the image is outdated. If you change this line to point at makerdao/vdb-execute:staging instead of makerdao/vdb-execute:latest, then the command should run successfully.

[blaaaaaaa]

Hi, looks better, but hang here. Is this maybe because I tried the command earlier and it didn't work out?

admin1@admin1-H81MGV3:~/IdeaProjects/vdb-mcd-transformers$ docker-compose -f dockerfiles/docker-compose.yml run execute ./run_migrations.sh
Starting dockerfiles_db_1 ... done
Connecting with: postgresql://vdb:vdb@db:5432/vdb?sslmode=disable
2020/06/25 06:25:18 goose run: ERROR 20200416093003_create_log_sorted_offer.sql: failed to run SQL migration: failed to execute SQL query "CREATE TABLE maker.log_sorted_offer\n(\n id SERIAL PRIMARY KEY,\n log_id BIGINT NOT NULL REFERENCES public.event_logs (id) ON DELETE CASCADE,\n header_id INTEGER NOT NULL REFERENCES public.headers (id) ON DELETE CASCADE,\n address_id INTEGER NOT NULL REFERENCES public.addresses (id) ON DELETE CASCADE,\n offer_id NUMERIC,\n UNIQUE (header_id, log_id)\n);\n": pq: schema "maker" does not exist
Could not run migrations. Are the database details correct?

[rmulhol]

The way that's failing, it looks like the DB was already migrated - probably by another container. You'll need to wipe that DB in order for the full set of migrations to run