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
- Transaction feature is not working somet...
I am getting the below error sometimes and sometimes it is working perfectly fine. Transaction failed: AppwriteException: transaction_not_found, Transaction wi...
- Updating to 1.9.0
Docs are lacking, I've already run in to some issues: - Firstly the web UI port doesn't work... had to add ```--http-port=9999``` in to the docker run command t...
- problem with domains
I don't know if this is wrong or not but i did what it told me to do to link my domain and still says failed domain has 11 incompatible CAA records.