Skip to content
Back
ResolvedSelf Hosted

[SOLVED] MariaDB issues when upgrading Version 1.8.1 to 2.1.0

Last activity
View on Discord

Votes

0

Replies

8

Participants

2

Messages

9

THE-EOriginal post

Rank 2: Process

I have been trying to upgrade from 1.8.1 to the latest appwrite version. My appwrite upgrade plan would be:

1.8.1 ➡️ 1.9.0 ➡️ 1.9.6 ➡️ 2.0.0 ➡️ 2.1.0

I am running the the appwrite instance on a self hosted Azure VM with Ubuntu 24.04.3 LTS. Docker version 29.8.0.

I get couple of issues:

  • The UI when upgrading seems to have issues regarding the steps (it does not follow step 1 to step 6 etc.).
  • The UI gets hung when the container should start (independent whether migration is done or not)
  • The mariadb container fails to load successfully and shows errors in the log (see error message below)
  • The .env-file format gets changed to a format where values are surrounded by " signs (key="value")
Bash
Running "docker compose up -d --remove-orphans --renew-anon-volumes"


[Error] Timestamp: 2026-09-13T20:57:26+00:00
[Error] Type: RuntimeException
[Error] Message: Failed to start containers
[Error] File: /usr/src/code/src/Appwrite/Platform/Tasks/Install.php
[Error] Line: 1138
[Error] Trace: #0 /usr/src/code/src/Appwrite/Platform/Tasks/Install.php(614): Appwrite\Platform\Tasks\Install->runDockerCompose(Array, false, false, true, NULL, true)
#1 /usr/src/code/src/Appwrite/Platform/Tasks/Install.php(327): Appwrite\Platform\Tasks\Install->performInstallation('80', '443', 'appwrite', 'appwrite', Array, false, NULL, NULL, true, Array, NULL, false)
#2 /usr/src/code/src/Appwrite/Platform/Tasks/Upgrade.php(94): Appwrite\Platform\Tasks\Install->action(80, 443, 'appwrite', 'appwrite', 'Y', false, 'mariadb')
#3 /usr/src/code/vendor/utopia-php/cli/src/CLI/CLI.php(328): Appwrite\Platform\Tasks\Upgrade->action('', '', 'appwrite', 'appwrite', 'Y', false, 'mariadb', false)
#4 /usr/src/code/vendor/utopia-php/cli/src/CLI/Adapters/Generic.php(16): Utopia\CLI\CLI->{closure:Utopia\CLI\CLI::run():318}()
#5 /usr/src/code/vendor/utopia-php/cli/src/CLI/CLI.php(318): Utopia\CLI\Adapters\Generic->start(Object(Closure))
#6 [internal function]: Utopia\CLI\CLI->run()
#7 {main}
THE-E

Rank 2: Process

The maria db container logs looks like the file in the attachment

Chirag Aggarwal

@THE-E try this -

cd /path/to/appwrite # folder with docker-compose.yml and .env docker compose stop mariadb docker run --rm -v appwrite_appwrite-mariadb:/var/lib/mysql alpine rm -f /var/lib/mysql/.my-healthcheck.cnf docker compose up -d docker logs appwrite-mariadb 2>&1 | grep -i healthcheck # expect "Creating healthcheck users"
Chirag Aggarwal

1.8.1 had no MariaDB healthcheck, but we added that later on, thus the issue arrised

THE-E

Rank 2: Process

Wow this was a really quick fix! Thanks! appwriteheart

THE-E

Rank 2: Process

I have done the commands:

Bash
2026-09-14 19:47:56 24452 [Warning] Access denied for user 'healthcheck'@'localhost' (using password: YES)
2026-09-14 19:48:06 24453 [Warning] Access denied for user 'healthcheck'@'localhost' (using password: YES)
2026-09-14 19:48:06 24454 [Warning] Access denied for user 'healthcheck'@'::1' (using password: YES)
2026-09-14 19:48:06 24455 [Warning] Access denied for user 'healthcheck'@'localhost' (using password: YES)
2026-09-14 19:48:16 24456 [Warning] Access denied for user 'healthcheck'@'localhost' (using password: YES)
2026-09-14 19:48:16 24457 [Warning] Access denied for user 'healthcheck'@'::1' (using password: YES)
2026-09-14 19:48:16 24458 [Warning] Access denied for user 'healthcheck'@'localhost' (using password: YES)
2026-09-14 19:49:05+00:00 [Note] [Entrypoint]: MariaDB healthcheck configuration file missing, assuming desirable
2026-09-14 19:49:06+00:00 [Note] [Entrypoint]: Creating healthcheck users
THE-E

Rank 2: Process

I did the migration

Bash
docker compose exec appwrite migrate

And everything seems to work correctly. Thanks a lot for your support! appwriteheart

THE-E

Rank 2: Process

[SOLVED] MariaDB issues when upgrading Version 1.8.1 to 2.1.0

Join the discussion

Reply to this thread by joining our Discord.

Reply on Discord

Need support?_

Join DiscordGet premium support