[SOLVED] Server Error Storage

[still juniper]

Server Error by creating a new storage bucket.

Appwrite Version: 1.3.4

Just Updated to 1.3.5... same

Here are some logs from ther appwrite server via portiner

Worker 3 started successfully
Worker 2 started successfully
Worker 1 started successfully
Worker 5 started successfully
Worker 6 started successfully
Worker 4 started successfully
Worker 7 started successfully
Worker 8 started successfully
Worker 10 started successfully
Worker 9 started successfully
Worker 11 started successfully
Worker 12 started successfully
[Setup] - Server database init started...
[Setup] - Creating database: appwrite...
[Setup] - Server database init completed...
Server started successfully (max payload is 6,291,456 bytes)
Master pid 1, manager pid 9
[Error] Timestamp: 2023-05-30T17:25:48+00:00
[Error] Type: Utopia\Exception
[Error] Message: Not Found
[Error] File: /usr/src/code/vendor/utopia-php/framework/src/App.php
[Error] Line: 792
[Error] Timestamp: 2023-05-30T17:25:59+00:00
[Error] Method: GET
[Error] URL: /v1/storage/buckets/:bucketId/files
[Error] Type: PDOException
[Error] Message: Table 'appwrite._1_' doesn't exist
[Error] File: @swoole-src/library/core/Database/PDOStatementProxy.php
[Error] Line: 64
[Error] Timestamp: 2023-05-30T17:28:09+00:00
[Error] Method: GET
[Error] URL: /v1/storage/buckets/:bucketId/files
[Error] Type: PDOException
[Error] Message: Table 'appwrite._1_' doesn't exist
[Error] File: @swoole-src/library/core/Database/PDOStatementProxy.php
[Error] Line: 64

[Error] Timestamp: 2023-05-30T17:28:09+00:00
[Error] Type: Utopia\Exception
[Error] Message: Not Found
[Error] File: /usr/src/code/vendor/utopia-php/framework/src/App.php
[Error] Line: 792
[Error] Timestamp: 2023-05-30T17:28:22+00:00
[Error] Method: GET
[Error] URL: /v1/storage/buckets/:bucketId/files
[Error] Type: PDOException
[Error] Message: Table 'appwrite._1_' doesn't exist
[Error] File: @swoole-src/library/core/Database/PDOStatementProxy.php
[Error] Line: 64
[Error] Timestamp: 2023-05-30T17:28:35+00:00
[Error] Method: GET
[Error] URL: /v1/storage/buckets/:bucketId/files
[Error] Type: PDOException
[Error] Message: Table 'appwrite._1_' doesn't exist
[Error] File: @swoole-src/library/core/Database/PDOStatementProxy.php
[Error] Line: 64
[Error] Timestamp: 2023-05-30T17:28:35+00:00
[Error] Type: Utopia\Exception
[Error] Message: Not Found
[Error] File: /usr/src/code/vendor/utopia-php/framework/src/App.php
[Error] Line: 792
[Error] Timestamp: 2023-05-30T17:28:42+00:00
[Error] Method: GET
[Error] URL: /v1/storage/buckets/:bucketId/files
[Error] Type: PDOException
[Error] Message: Table 'appwrite._1_' doesn't exist
[Error] File: @swoole-src/library/core/Database/PDOStatementProxy.php
[Error] Line: 64
[Error] Timestamp: 2023-05-30T17:28:42+00:00
[Error] Type: Utopia\Exception
[Error] Message: Not Found
[Error] File: /usr/src/code/vendor/utopia-php/framework/src/App.php
[Error] Line: 792
[Error] Timestamp: 2023-05-30T17:28:53+00:00
[Error] Method: POST
[Error] URL: /v1/storage/buckets
[Error] Type: PDOException
[Error] Message: Unknown column 'documentSecurity' in 'field list'
[Error] File: @swoole-src/library/core/Database/PDOStatementProxy.php
[Error] Line: 64
[Error] Timestamp: 2023-05-30T17:28:58+00:00
[Error] Type: Utopia\Exception
[Error] Message: Not Found
[Error] File: /usr/src/code/vendor/utopia-php/framework/src/App.php
[Error] Line: 792

[dark drum]

did you ever have an older instance of appwrite on this server?

[still juniper]

What do you man with older instance?

I started a fresh Installation with 1.3.1

[manic sparrow]

Then, and this is not the usual case with Appwrite, But you'll need to run migrate.

Do a backup. Then run

cd appwrite/
docker compose exec appwrite migrate

You can read more here:
https://appwrite.io/docs/upgrade#migration

[still juniper]

thanks, but Im using Portainer, how I can find the location of the docker-compose.yml file.

[dark drum]

ugh stupid portainer...how did you install appwrite?

[still juniper]

Installed via stack and yml file. Portainer is very usrfriendly 🙂

I Opend the appwrite console directly. So Im inside the docker. And there I start the command "migrate"

That works

In Appwrite I created now a new storage bucket. And now there is no server error, but if I try to open the other buckets, which I created before with another version. I get again server error

In this case test111 is working, i created it after migrate. the others are not working. I can also not delete it

I recive internal Error 500

[dark drum]

try opening the terminal and running docker compose ls

[dark drum]

that might be where your compose file is...either that or it's in that location in the portainer container...

[dark drum]

what's the output of docker network ls and docker volume ls

[dark drum]

now docker inspect appwrite_appwrite-mariadb

[dark drum]

where'd you get the appwrite stack config?

[still juniper]

from the appwrite page

https://appwrite.io/install/compose

[dark drum]

volume was created recently that's good...

[still juniper]

I noticed, only the previus created buckets have internal server error

[dark drum]

maybe there are some bad values in the old buckets...is it okay to recreate the buckets?

[still juniper]

There is nothing inside. I can also delete it, but if I click on the bucket I can not see any delete button. The page with 500 Internal Error occures

all this can be deleted:

[dark drum]

can you maybe delete via API or server SDK?

[still juniper]

Can try

[still juniper]

I can list all buckets, now trying to delete it

Delete via API is working..
I created again a HelloWorld bucket. Looks good

Thanks for your support @dark drum

For the other colleges, maybe it is very important to run the "migrate" command on the "appwrite" docker befor to do anything on the new upgraded version.

We can mark it as solved