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
- Unknown attribute type: varchar / text
Since the `string` type is deprecated I tried using `varchar` and `text` in some newer tables, but when running `appwrite pull tables && appwrite types ./src/li...
- Query.search limitation
Since `string` is deprecated I used `varchar`, and now I cant use `Query.contains` , so I setup fulltext index and started using `Query.search` the issue is `Qu...
- function subdomain ssl certs
The generated subdomain isn't getting a valid ssl cert, I was wondering if appwrite automatically generates one or uses a wildcard for *.functions.domain.com? ...