[SOLVED] Internal Server 500 Error from Appwrite console

Run

And share the last lines

[Error] File: @swoole-src/library/core/Database/PDOStatementProxy.php
[Error] Line: 64
[Error] Timestamp: 2023-07-20T18:21:17+00:00
[Error] Method: GET
[Error] URL: /v1/projects/:projectId/platforms
[Error] Type: PDOException
[Error] Message: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name does not resolve
[Error] File: @swoole-src/library/core/Database/PDOPool.php
[Error] Line: 35

There's the last several lines, but there's 50+ lines of errors

It seems like Appwrite wasn't able to connect to the Database.
First try to restart your Appwrite infrastructure by running this command in the same folder as your docker-compose.yml file is

Okay did that..

I ran the docker logs command again and there is many less error messages, but still about 20 lines of errors

You still get the 500 error?

What other errros?

[Error] Timestamp: 2023-07-20T18:36:40+00:00
[Error] Method: GET
[Error] URL: /v1/functions
[Error] Type: PDOException
[Error] Message: SQLSTATE[HY000] [2002] Connection refused
[Error] File: @swoole-src/library/core/Database/PDOPool.php
[Error] Line: 35
[Error] Timestamp: 2023-07-20T18:36:49+00:00
[Error] Method: GET
[Error] URL: /v1/databases
[Error] Type: PDOException
[Error] Message: MySQL server has gone away
[Error] File: @swoole-src/library/core/Database/PDOStatementProxy.php
[Error] Line: 64
[Error] Timestamp: 2023-07-20T18:36:49+00:00
[Error] Method: GET
[Error] URL: /v1/databases
[Error] Type: PDOException
[Error] Message: SQLSTATE[HY000] [2002] Connection refused
[Error] File: @swoole-src/library/core/Database/PDOPool.php
[Error] Line: 35
[Error] Timestamp: 2023-07-20T18:36:50+00:00
[Error] Method: GET
[Error] URL: /v1/functions
[Error] Type: PDOException
[Error] Message: MySQL server has gone away
[Error] File: @swoole-src/library/core/Database/PDOStatementProxy.php
[Error] Line: 64
[Error] Timestamp: 2023-07-20T18:36:51+00:00
[Error] Method: GET
[Error] URL: /v1/functions
[Error] Type: PDOException
[Error] Message: MySQL server has gone away
[Error] File: @swoole-src/library/core/Database/PDOStatementProxy.php
[Error] Line: 64

that's the full log that was returned from the command

What is the output of docker ps -a

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
2892a52c94e7 appwrite/appwrite:1.3.7 "worker-functions" 18 minutes ago Up 18 minutes 80/tcp appwrite-worker-functions
0f6abb114c19 appwrite/appwrite:1.3.7 "executor" 18 minutes ago Up 18 minutes 80/tcp appwrite-executor
c9f1d42338a2 traefik:2.7 "/entrypoint.sh --pr…" 18 minutes ago Up 18 minutes 0.0.0.0:80->80/tcp, 0.0.0.0:443->443/tcp appwrite-traefik
4f60269aa4da appwrite/appwrite:1.3.7 "worker-certificates" 18 minutes ago Up 18 minutes 80/tcp appwrite-worker-certificates
dc7e444c3a01 appwrite/appwrite:1.3.7 "maintenance" 18 minutes ago Up 18 minutes 80/tcp appwrite-maintenance
61a56decf12a appwrite/appwrite:1.3.7 "docker-php-entrypoi…" 18 minutes ago Up 18 minutes 80/tcp appwrite
9ff9f5cd75fe appwrite/appwrite:1.3.7 "worker-builds" 18 minutes ago Up 18 minutes 80/tcp appwrite-worker-builds
ece6e3de8efd appwrite/appwrite:1.3.7 "usage" 18 minutes ago Up 18 minutes

80/tcp appwrite-usage
3743561d3433 appwrite/appwrite:1.3.7 "worker-databases" 18 minutes ago Up 18 minutes 80/tcp appwrite-worker-databases
f2bd8928a6f9 appwrite/appwrite:1.3.7 "worker-deletes" 18 minutes ago Up 18 minutes 80/tcp appwrite-worker-deletes
acd54c984197 appwrite/appwrite:1.3.7 "worker-messaging" 18 minutes ago Up 18 minutes 80/tcp appwrite-worker-messaging
4d1099b5d083 appwrite/appwrite:1.3.7 "worker-mails" 18 minutes ago Up 18 minutes 80/tcp appwrite-worker-mails
3c922b046a7b appwrite/appwrite:1.3.7 "worker-audits" 18 minutes ago Up 18 minutes 80/tcp appwrite-worker-audits
497f782c03ba appwrite/appwrite:1.3.7 "worker-webhooks" 18 minutes ago Up 18 minutes 80/tcp appwrite-worker-webhooks
bbed07daf107 appwrite/appwrite:1.3.7 "realtime" 18 minutes ago Up 18 minutes 80/tcp appwrite-realtime
46f4a18840e5 appwrite/appwrite:1.3.7 "schedule" 18 minutes ago Up 18 minutes 80/tcp appwrite-schedule
b4b09a75b214 mariadb:10.7 "docker-entrypoint.s…" 18 minutes ago Up 17 minutes

3306/tcp appwrite-mariadb
7ffa468ee450 appwrite/telegraf:1.4.0 "/entrypoint.sh tele…" 18 minutes ago Up 18 minutes 8092/udp, 8125/udp, 8094/tcp appwrite-telegraf
7a9604ead52d redis:7.0.4-alpine "docker-entrypoint.s…" 18 minutes ago Up 18 minutes 6379/tcp appwrite-redis
24854c5fbb93 appwrite/influxdb:1.5.0 "/entrypoint.sh infl…" 18 minutes ago Up 18 minutes 8086/tcp appwrite-influxdb

Try restarting just the db

still getting the 500 error on the console

Somehow Appwrite is unanble to connect to the database, maybe you had a different database before that uses that volume.

Someone had the same issue as your ysterday https://discord.com/channels/564160730845151244/1130856927748948029/1131209903210500106

The sulotion was to reinstall everything

Okay I'll take a look at that, sounds good. Thanks for your help!!

If you don't have any important data you can reset the environment

Yea no important data, no problem

So you can try to run

docker compose down -v && docker compose up -d

The -v will remove all volumes

It worked!! Thanks for your help.

[SOLVED] Internal Server 500 Error from Appwrite console