appwrite: ๐Ÿ› Bug Report: Failed to upgrade from 0.13.x to 0.14.x

๐Ÿ‘Ÿ Reproduction steps

Some users (including me) has problems to upgrade to 0.14.x Nothing works, if i sign in the console i get a loop to return to login page, and SDK either works.

Follow the Upgrade and get the same in my vps and my local.

Appwrite logs
appwrite                        | [Static Files] Loadded 133 files
appwrite                        | Worker 1 started successfully
appwrite                        | Worker 2 started successfully
appwrite                        | Worker 3 started successfully
appwrite                        | Worker 4 started successfully
appwrite                        | Worker 5 started successfully
appwrite                        | Worker 6 started successfully
appwrite                        | Worker 7 started successfully
appwrite                        | Worker 8 started successfully
appwrite                        | Worker 9 started successfully
appwrite                        | Worker 10 started successfully
appwrite                        | Worker 11 started successfully
appwrite                        | Worker 12 started successfully
appwrite                        | Worker 13 started successfully
appwrite                        | Worker 14 started successfully
appwrite                        | Worker 15 started successfully
appwrite                        | Worker 16 started successfully
appwrite                        | Worker 18 started successfully
appwrite                        | Worker 20 started successfully
appwrite                        | Worker 19 started successfully
appwrite                        | Worker 21 started successfully
appwrite                        | Worker 22 started successfully
appwrite                        | Worker 23 started successfully
appwrite                        | Worker 17 started successfully
appwrite                        | Worker 24 started successfully
appwrite                        | [Setup] - Server database init started...
appwrite                        | [Setup] - Creating metadata table: appwrite...
appwrite                        | [Setup] - Creating collection: tokens...
appwrite                        | [Setup] - Server database init completed...
appwrite                        | Server started successfully (max payload is 6,291,456 bytes)
appwrite                        | Master pid 1, manager pid 8
appwrite                        | localhost is not a publicly accessible domain. Skipping SSL certificate generation.
appwrite                        | [Error] Timestamp: 2022-05-24T05:31:48+00:00
appwrite                        | [Error] Method: GET
appwrite                        | [Error] URL: /v1/account
appwrite                        | [Error] Type: Appwrite\Extend\Exception
appwrite                        | [Error] Message: User (role: guest) missing scope (account)
appwrite                        | [Error] File: /usr/src/code/app/controllers/general.php
appwrite                        | [Error] Line: 310
appwrite                        | [Error] Timestamp: 2022-05-24T05:31:56+00:00
appwrite                        | [Error] Method: GET
appwrite                        | [Error] URL: /v1/account
appwrite                        | [Error] Type: Appwrite\Extend\Exception
appwrite                        | [Error] Message: User (role: guest) missing scope (account)
appwrite                        | [Error] File: /usr/src/code/app/controllers/general.php
appwrite                        | [Error] Line: 310
appwrite                        | localhost is not a publicly accessible domain. Skipping SSL certificate generation.
appwrite                        | [Error] Timestamp: 2022-05-24T05:31:56+00:00
appwrite                        | [Error] Method: GET
appwrite                        | [Error] URL: /v1/projects
appwrite                        | [Error] Type: Appwrite\Extend\Exception
appwrite                        | [Error] Message: User (role: guest) missing scope (projects.read)
appwrite                        | [Error] File: /usr/src/code/app/controllers/general.php
appwrite                        | [Error] Line: 310
appwrite                        | localhost is not a publicly accessible domain. Skipping SSL certificate generation.
appwrite                        | [Error] Timestamp: 2022-05-24T05:31:56+00:00
appwrite                        | [Error] Method: GET
appwrite                        | [Error] URL: /v1/projects
appwrite                        | [Error] Type: Appwrite\Extend\Exception
appwrite                        | [Error] Message: User (role: guest) missing scope (projects.read)
appwrite                        | [Error] File: /usr/src/code/app/controllers/general.php
appwrite                        | [Error] Line: 310
appwrite                        | [Error] Timestamp: 2022-05-24T05:31:57+00:00
appwrite                        | [Error] Method: GET
appwrite                        | [Error] URL: /v1/account
appwrite                        | [Error] Type: Appwrite\Extend\Exception
appwrite                        | [Error] Message: User (role: guest) missing scope (account)
appwrite                        | [Error] File: /usr/src/code/app/controllers/general.php
appwrite                        | [Error] Line: 310

Those logs ever there.

Also attach the logs from migration Migration_output.txt

๐Ÿ‘ Expected behavior

Upgrade.

๐Ÿ‘Ž Actual Behavior

Not upgraded and the project is bug.

๐ŸŽฒ Appwrite version

Version 0.13.x

๐Ÿ’ป Operating system

Linux

๐Ÿงฑ Your Environment

Test in linux and macOS

๐Ÿ‘€ Have you spent some time to check if this issue has been raised before?

  • I checked and didnโ€™t find similar issue

๐Ÿข Have you read the Code of Conduct?

About this issue

  • Original URL
  • State: closed
  • Created 2 years ago
  • Reactions: 1
  • Comments: 16 (12 by maintainers)

Most upvoted comments

Thatโ€™s it!!! The sub query for the sessions has a limit of 64 documents!! Thatโ€™s why deleting the documents in the sessions table fixes the problem!

Thatโ€™s it!!! The sub query for the sessions has a limit of 64 documents!! Thatโ€™s why deleting the documents in the sessions table fixes the problem!

@stnguyen90 YES!!! Now works!!! I was perform delete from _console_sessions where userId = '616f23d359d2c'; and now i was successfully login in console.

After upgrading for .13.4 to .14.2 I ran into an issue where after calling (flutter) account.get() an exception of 401: User (role: guest) missing scope (account) was thrown, even though a new session was created.

I was able to resolve the issue for this specific user instance by logging into the console and initiated a โ€˜Logout from all sessionsโ€™.