Problems migrating to 2.0.0

Hey,
I'm currently trying to upgrade from 1.8.0 to 2.0.0. I've already successfully made it up to 1.9.6. However, when upgrading to 2.0.0, I'm getting the error shown below.
If that worked, I’d prefer to switch to a new instance so I can migrate to PostgreSQL and use a new secret key.
So my second question is whether it’s possible to set up a second instance in parallel for the migration and then move all the data to that new instance.

Translated with DeepL.com (free version)

[Error] Timestamp: 2026-09-05T16:09:34+00:00

[Error] Type: Utopia\Database\Exception\NotFound

[Error] Message: Collection not found

[Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Database.php

[Error] Line: 8628

[Error] Trace: #0 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(9089): Utopia\Database\Database->find(Object(Utopia\Database\Document), Array, 'read')

#1 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(9043): Utopia\Database\Database->iterate('presenceLogs', Array, 'read')

#2 /usr/src/code/src/Appwrite/Migration/Migration.php(189): Utopia\Database\Database->foreach('presenceLogs', Object(Closure))

#3 /usr/src/code/src/Appwrite/Migration/Version/V25.php(25): Appwrite\Migration\Migration->forEachDocument(Object(Closure))

#4 /usr/src/code/src/Appwrite/Platform/Tasks/Migrate.php(120): Appwrite\Migration\Version\V25->execute()

#5 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(9044): Appwrite\Platform\Tasks\Migrate->{closure:Appwrite\Platform\Tasks\Migrate::action():106}(Object(Utopia\Database\Document))

#6 /usr/src/code/src/Appwrite/Platform/Tasks/Migrate.php(106): Utopia\Database\Database->foreach('projects', Object(Closure))

#7 /usr/src/code/vendor/utopia-php/cli/src/CLI/CLI.php(314): Appwrite\Platform\Tasks\Migrate->action('2.0.0', Object(Utopia\Database\Database), Object(Closure), Object(Utopia\Registry\Registry), Object(Utopia\Database\Validator\Authorization), Object(Utopia\Database\Document))

#8 /usr/src/code/vendor/utopia-php/cli/src/CLI/Adapters/Generic.php(11): Utopia\CLI\CLI->{closure:Utopia\CLI\CLI::run():304}()

#9 /usr/src/code/vendor/utopia-php/cli/src/CLI/CLI.php(304): Utopia\CLI\Adapters\Generic->start(Object(Closure))

#10 [internal function]: Utopia\CLI\CLI->run()

#11 {main} ```

hey, my first question would be, did you ran the migrate command inside the appwrite container for ALL versions since 1.8.0 ?

next regarding your Postgres question, you can indeed run 2 appwrite instances, one maria/mongo and one postgres, then migrate the data between them (via the SDK or others). I also made a script to migrate from maria to postgres directly from database to database, tho haven't runned it on production yet, only tests environments : https://discord.com/channels/564160730845151244/1545738972137914398/1545775999852089384

I've been running the migrate command all along. I've never had any problems with it.

I've already taken a look at your script. It looks really interesting, and I'd love to test it out later and then use it on the production environment 😄

The upgrade process was as follows: 1.8.0 > 1.8.1 > 1.9.0 > 1.9.6

oh you missed 1.9.5

wut

that might be why

It's a good thing I have a backup

yes indeed

All right, then I'll give it a try 😄

An hour later, and the migration ran without any errors. Now I'm getting the “general_route_not_found” error. The underlying API seems to be working, though.
I'll keep looking into it

[ERROR] Failed to start server: Error: EAFNOSUPPORT: address family not supported, listen

never seen that error before sadly

but maybe depending on how you updated the compose, if you did it manually, then maybe you didn't properly wired the traefik, usualy when you have a webpage with route not found is that your hitting the appwrite container instead of the console one

I think it's more likely due to the new web server, and that a setting related to IPv6 might be causing problems