SelfHosted - Migration errors : 1.2.1 -> 1.3.0 - Threads

We have a live version of appwrite that was running on 1.2.1, we want to migrate to appwrite cloud but, in order to do that we have to migrate to 1.4.x. To do this, we're upgrading from 1.2.1 to 1.3.0

While doing this in step 2 of the migration as per https://appwrite.io/docs/advanced/self-hosting/update

We're getting the following error

TypeScript

Migrating Collection cache:

Fatal error: Uncaught Exception: Collection not found in /usr/src/code/vendor/utopia-php/database/src/Database/Database.php:3827
Stack trace:
#0 /usr/src/code/src/Appwrite/Migration/Migration.php(162): Utopia\Database\Database->count(Object(Utopia\Database\Document))
#1 /usr/src/code/src/Appwrite/Migration/Migration.php(126): Appwrite\Migration\Migration->documentsIterator('cache')
#2 {main}
  thrown in /usr/src/code/vendor/utopia-php/database/src/Database/Database.php on line 3827

Current appwrite version : 1.3.0, previous appwrite version 1.2.1 Running on an ubuntu 22.04 server

docker ps output seems fine, all containers are up

TL;DR

Troubleshooting migration issues from version 1.2.1 to 1.3.0 in a self-hosted environment. Attempted unsuccessfully to run migrations. Received a fatal error related to a missing collection. Proposed solution: try clearing cache tables and running migrations sequentially for each version (1.2.1, 1.3.0, etc.) while ensuring backups are in place.

Any suggestions on how we can get this migration done? We really want to move to cloud

Also, once we run the migration, ssl seems to be down, how do I do get this back up ?

What command did you use for the upgrade to 1.3.0?

docker run -it --rm --volume /var/run/docker.sock:/var/run/docker.sock --volume "$(pwd)"/appwrite:/usr/src/code/appwrite:rw --entrypoint="install" appwrite/appwrite:1.3.0

followed by

TypeScript

cd appwrite/
docker compose exec appwrite migrate

Hmm. Have you tried bringing down and up the containers then running the migration again?

I see, I tried looking into that, but, there's no data in any of the cache tables

and i continue to get this error

Do you have backups?

Yes we do

Are there any commands you recommend I run ?

You should come back to 1.2.1 and restore backups. You can't go to 1.5 directly, and instead you need to go to the corresponding paths like the latest 1.2.x version and run migrations, then 1.3.8 and run migrations, 1.4.14 and run migrations and then 1.5.3 and run migrations

i tried moving back to 1.2.1 with a backup docker compose file i had

this was after that

You can't migrate back. Did you have done a backup of just the docker compose file?

No i have one of the db as well

Let me try a new instance and get back

With the db backup + the compose file

I would suggest a new instance of 1.2.1 and then restore the DB backup

You will need to have the openSSL key you set at first to be able to login and everything

Yep I have a backup of all the default + configs I used to bring the containers up the first time

Keep the backup always for just in case

Cool, will try it out and get back. Thank you!