T
Twenty3w ago
fjcero

I currently upgraded one instance from 0

I currently upgraded one instance from 0.50.0 to 0.51.0, but I run into issues when trying to migrate to 0.52.0 (or even 0.52.11 which I needed to pull remote tag for doing)
9 Replies
fjcero
fjceroOP3w ago
If anyone has some tips here, will be amazing
# Force version
git reset --hard v0.52.0

# Dependencies
yarn

# Check migrations
APP_VERSION=0.52.0 yarn database:migrate:prod

query: SELECT * FROM current_schema()
query: CREATE EXTENSION IF NOT EXISTS "uuid-ossp"
query: SELECT version();
query: SELECT * FROM "information_schema"."tables" WHERE "table_schema" = 'metadata' AND "table_name" = '_typeorm_migrations'
query: SELECT * FROM "metadata"."_typeorm_migrations" "_typeorm_migrations" ORDER BY "id" DESC
No migrations are pending
query: SELECT * FROM current_schema()
query: CREATE EXTENSION IF NOT EXISTS "uuid-ossp"
query: SELECT version();
query: SELECT * FROM "information_schema"."tables" WHERE "table_schema" = 'core' AND "table_name" = '_typeorm_migrations'
query: SELECT * FROM "core"."_typeorm_migrations" "_typeorm_migrations" ORDER BY "id" DESC
No migrations are pending

# Upgrade from 0.51.0 to 0.52.0
APP_VERSION=0.52.0 yarn command:prod upgrade
# Force version
git reset --hard v0.52.0

# Dependencies
yarn

# Check migrations
APP_VERSION=0.52.0 yarn database:migrate:prod

query: SELECT * FROM current_schema()
query: CREATE EXTENSION IF NOT EXISTS "uuid-ossp"
query: SELECT version();
query: SELECT * FROM "information_schema"."tables" WHERE "table_schema" = 'metadata' AND "table_name" = '_typeorm_migrations'
query: SELECT * FROM "metadata"."_typeorm_migrations" "_typeorm_migrations" ORDER BY "id" DESC
No migrations are pending
query: SELECT * FROM current_schema()
query: CREATE EXTENSION IF NOT EXISTS "uuid-ossp"
query: SELECT version();
query: SELECT * FROM "information_schema"."tables" WHERE "table_schema" = 'core' AND "table_name" = '_typeorm_migrations'
query: SELECT * FROM "core"."_typeorm_migrations" "_typeorm_migrations" ORDER BY "id" DESC
No migrations are pending

# Upgrade from 0.51.0 to 0.52.0
APP_VERSION=0.52.0 yarn command:prod upgrade
Version in the DB never changes to 0.52.0 But if I move to 0.52.11 I have other errors
fjcero
fjceroOP3w ago
This is what exists in Github for me
No description
Prastoin
Prastoin3w ago
Hey @fjcero would you be up for a call today something like 2pm paris TZ ? So we can migrate your workspace together We recommend always using major.minor version ( to get latest patch ) while upgrading To check existing version please rather check directly on docker hub
fjcero
fjceroOP3w ago
hey @Prastoin just connected here in CDMX 🙂 if you are available for sure will be nice to have a call, and I can show you what I'm doing
Prastoin
Prastoin3w ago
Hey @fjcero will be available in an hour and a half if this is ok for you we can plan a 30 minutes call ?
fjcero
fjceroOP3w ago
that works great 🙂 do you have a link to schedule? cal.com?
Prastoin
Prastoin3w ago
Discord will do the job if you're ok with that, lets go for 4pm Paris TZ
fjcero
fjceroOP3w ago
No description
fjcero
fjceroOP3w ago
@Prastoin automatic migrations!

Did you find this page helpful?