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