KaiOriginal post
Rank 1: Thread
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)
Plain text
[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} ```Summary
User is having issues migrating to version 2.0.0 from 1.9.6, facing a "Collection not found" error. It is advised by the community to run the `migrate` command inside the appwrite container for all versions since 1.8.0. User also inquires about setting up a second instance for migration to PostgreSQL. A community script is shared for direct database-to-database migration from MariaDB to PostgreSQL. The user plans to retry the migration process starting from version 1.8.0, ensuring to include version 1.9.5. If any issues arise, there