planka icon indicating copy to clipboard operation
planka copied to clipboard

Issue -the following files are missing: 20180721234154_create_project_membership_table.js

Open upuldi opened this issue 2 years ago • 5 comments

I am getting the following error from the latest docker (1.13).

Error: The migration directory is corrupt, the following files are missing: 20180721234154_create_project_membership_table.js

upuldi avatar May 01 '22 06:05 upuldi

same here, and sadly for me I tried to exec into the container and run cd db && wget https://raw.githubusercontent.com/plankanban/planka/d6cb1f6683774ffa52012f42b6483a8a93e704d1/server/db/migrations/20180721234154_create_project_membership_table.js -P migrations and restarted and now all of my data is gone...

Edit: this saved me: https://github.com/plankanban/planka/issues/139#issuecomment-871094096

shamoon avatar May 01 '22 07:05 shamoon

Same here as well.... container just reboots after the latest update.

image

vcantrell avatar May 01 '22 07:05 vcantrell

Edit: this saved me: #139 (comment)

Sadly, the result wasn't quite the same for me: Planka-2022-05-01_1-57-16-AM

vcantrell avatar May 01 '22 08:05 vcantrell

Edit: this saved me: #139 (comment)

The procedure worked for me without any errors.

However, when restarting the web container, it still complains about the missing migration and hence does not boot. As the container keeps running (instead of dying), I was able to download the migration again:

docker-compose exec planka sh

# Within the container:
/app $ cd db
/app/db $ wget https://raw.githubusercontent.com/plankanban/planka/d6cb1f6683774ffa52012f42b6483a8a93e704d1/server/d
b/migrations/20180721234154_create_project_membership_table.js -P migrations

Data seems to be still intact after these procedures.

phylor avatar May 01 '22 14:05 phylor

A kind reminder to make database backups 🙂

NOW=$(date +"%d%m%yT%T")
PLANKA_DB_PASSWORD="<DB Password Here>"
docker exec -i planka /bin/bash -c "PGPASSWORD=$PLANKA_DB_PASSWORD pg_dump --username planka planka" > dump_$NOW.bak

dbrennand avatar May 02 '22 10:05 dbrennand