[SOLVED] Migration error

Hello everyone, I upgrade from 1.3.8 to 1.4.1, and when I tried to migrate the data this error shows.

Failed to create connection: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Try again

I tried to open the dashboard and this error appear on the web: // 20230906160747 // my url here

{ "message": "Error: Server Error", "code": 500, "version": "1.4.1" }

you need to run the migrate command before using appwrite after upgrading

try to restart things:

docker compose down
docker compose up -d --remove-orphans

I tried. But the error is the same. I checked the credentials in mariadb and it is ok

how about docker compose restart appwrite ?

Same. The website isn’t loading and docker doctor said:

👩‍⚕️ Running Appwrite Doctor for version 1.4.1 ...

[Settings] 🟢 Hostname has a public suffix () 🟢 CNAME target has a public suffix () 🟢 Using a unique secret key for encryption 🟢 App environment is set for production 🟢 Abuse protection is enabled 🟢 Console access limits are enabled 🔴 HTTPS force option is disabled 🔴 Logging adapter is disabled

[Connectivity] 🔴 Console.DB.(console)...........................disconnected 🔴 Projects.DB.(database_db_main).................disconnected 🟢 Cache(cache_redis_main)...........................connected 🟢 Queue(queue)......................................connected 🟢 PubSub(pubsub)....................................connected 🔴 SMTP...........................................disconnected

[Volumes] 🟢 Uploads Volume is readable 🟢 Uploads Volume is writeable 🟢 Cache Volume is readable 🟢 Cache Volume is writeable 🟢 Config Volume is readable 🟢 Config Volume is writeable 🟢 Certs Volume is readable 🟢 Certs Volume is writeable

[Disk Space] 🟢 Uploads Volume has 90.01GB free space (13.38% used) 🟢 Cache Volume has 90.01GB free space (13.38% used) 🟢 Config Volume has 90.01GB free space (13.38% used) 🟢 Certs Volume has 90.01GB free space (13.38% used)

Failed to check for a newer version

how did you check? did you change the default credentials?

I run the bash of the MariaDB container, check user permissions in the DB, and the password

I made a rollback in the server right now. So, I'm gonna try to upgrade from 1.3.8 to 1.4.1 again

i wonder if it's a docker network problem...

It is weird. I made the upgrade but this time I didn't anything. When the upgrade finished, I ran the docket compse down and then docker compose up -d --remove-orphans But the website has error 500

you ran the migrate command successfully?

No, only restart docker after upgrade

ya you can't use appwrite without running the migrate command

I get the same error

appwrite# docker compose exec appwrite migrate Failed to create connection: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Try again Failed to create connection: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Try again

would you please run docker network inspect appwrite and share the output

Ok, I sent the result to DM

I have this error from the appwrite log

fatal error: Uncaught Exception: Failed to connect to database: Failed to create connection: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Try again in /usr/src/code/app/http.php:82 Stack trace: #0 {main} thrown in /usr/src/code/app/http.php on line 82 [2023-09-07 00:25:34 *31.0] ERROR php_swoole_server_rshutdown() (ERRNO 503): Fatal error: Uncaught Exception: Failed to connect to database: Failed to create connection: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Try again in /usr/src/code/app/http.php:82 Stack trace: #0 {main} thrown in /usr/src/code/app/http.php on line 82 Database not ready. Retrying connection (10)... Database not ready. Retrying connection (1)... [Error] Type: Utopia\Exception [Error] Message: Error handler had an error: Failed to create connection: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Try again [Error] File: /usr/src/code/vendor/utopia-php/framework/src/App.php [Error] Line: 551 Database not ready. Retrying connection (2)... [Error] Type: Utopia\Exception [Error] Message: Error handler had an error: Failed to create connection: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Try again [Error] File: /usr/src/code/vendor/utopia-php/framework/src/App.php [Error] Line: 551 [Error] Type: Utopia\Exception [Error] Message: Error handler had an error: Failed to create connection: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Try again [Error] File: /usr/src/code/vendor/utopia-php/framework/src/App.php [Error] Line: 551 Database not ready. Retrying connection (3)...

[Solved] Migration error

[SOLVED] Migration error