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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 2.3.6
    • N/A
    • readconnroute

    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

        1. stripped_console.logs
          10 kB
          Kadir
        2. stripped_maxctrl.log
          2 kB
          Kadir
        3. stripped_maxscale.config
          1 kB
          Kadir

        Activity

          People

            Unassigned Unassigned
            kadir Kadir
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.