mariadb 11, all works well in docker compose and mariadb container, but when I changed to galera cluster it throws errors like that
Fatal error: Uncaught Exception: Failed to connect to database: Failed to create connection: SQLSTATE[HY000] [2054] Server sent charset (0) unknown to the client. Please, report to the developers in /usr/src/code/app/http.php:85
Stack trace:
#0 [internal function]: {closure}()
}
thrown in /usr/src/code/app/http.php on line 85
[2024-04-25 13:24:46 #1.4] ERROR php_swoole_server_rshutdown() (ERRNO 503): Fatal error: Uncaught Exception: Failed to connect to database: Failed to create connection: SQLSTATE[HY000] [2054] Server sent charset (0) unknown to the client. Please, report to the developers in /usr/src/code/app/http.php:85
Stack trace:
#0 [internal function]: {closure}()
}
thrown in /usr/src/code/app/http.php on line 85
target database details regarding that error: utf8mb4,utf8mb4_general_ci
environment is docker swarm and mariadb is installed and replicated on each of 4 nodes
so I tried to create only local connections to cut down on network latency as much as possible and expose db from host.docker.internal
for all the other services I host it works perfectly well
but appwrite has problems for some reason
can someone suggest where to look for solution?
I also deployed maxscale inside the cluster and if I connect appwrite to maxscale deployment, all works as expected
despite the fact that maxscale works literally the same way, connecting to mariadb through host.docker.internal
so something in the middle is destroying the connections... but how?
Recommended threads
- How to bypass the rate limit on the back...
Once a month my app has a ton of usage and I always run into the Too many requests 429 error. I am trying to optimize the queues and jobs to manage that, but a...
- SSL certificate generation failed even t...
Hello, I have an Appwrite Site for which I added a custom domain. However, even though the domain is verified, the SSL certificate generation is failing. It is ...
- [Self-hosted] Realtime crashes with "Mis...