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
- Fulltext index creation fails due to Inn...
I'm running a self-hosted Appwrite 1.8.1 instance and encountering an issue when creating fulltext indexes on a collection. **The Problem:** Fulltext index cre...
- Cannot Update Empty oneToMany Relationsh...
Appwrite's `updateDocument()` API cannot update an empty oneToMany relationship array. When attempting to update an empty relationship with a single-item array,...
- Function for long running task (other 60...
My function need long running other 60 seconds. But async mode return empty body. How to deal with that please ?