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?
- I have read the Code of Conduct
About this issue
- Original URL
- State: closed
- Created 2 years ago
- Reactions: 1
- Comments: 16 (12 by maintainers)
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’.