Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-2503

`Failed to create new routing session` with valid slaves available

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 2.3.6
    • Fix Version/s: N/A
    • Component/s: readconnroute
    • Labels:
    • Environment:

      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.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            kadir Kadir
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: