Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
2.3.6
-
FROM centos:7
ENV MAXSCALE_VERSION=2.3.6
RUN curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | bash -s -- --mariadb-maxscale-version="${MAXSCALE_VERSION}" && \
yum -y install maxscale && \
yum clean all
Description
I am getting following error even with an available slave:
error : Failed to create new routing session. Couldn't find eligible candidate server. Freeing allocated resources.
|
error : Failed to create new router session for service 'this-service'. See previous errors for more details.
|
When I query the state it shows me online:
// curl -u admin:mariadb localhost:8989/v1/servers/server1
|
...
|
"state": "Slave of External Server, Running",
|
...
|
Initially a readconnrouter was configured for a single slave only, no master declared. This didnt work so I tried many different combinations:
- passive=true + removing monitor
- include master in monitor
- setting ignore_external=true
- trying all combinations of router options: `master,slave`; `master`; 'slave'
None of them lead to "finding eligible candidate server". I cannot fully verify if this is a bug but all tested combinations didn't work on said server. If I try this configuration on an empty mysql server (docker-compose) it works flawlessly.
Some extra information about the database I point to:
- AWS RDS MySQL 5.7.16
- 3612 loaded users with many invalid subnets 255.255.252.0 (I set `skip_authentication=true`)
I also included the full config and logs.