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

Schemarouter reports "non-existent database"

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 22.08.4
    • 23.08.0
    • schemarouter
    • None
    • debian 11/docker
      mariadb on windows
    • MXS-SPRINT-185

    Description

      I have two servers and one schemarouter service binded (+ listener and monitors).
      If I try a connection with the user "web_xxxxx" to database "www.xxxx.com", the connection fails. The target server (I turned off the second as a test) is named "f01-r55". MaxScale reports:

      .....
      info   : <f01-r55, www.xxxx.srl, workflows>
       info   : <f01-r55, www.xxxx.com, workflowtypes>
       info   : <f01-r55, information_schema, >
       info   : <f01-r55, www.xxxx.com, >
       info   : Updated shard map for user 'web_xxxxf01-r55'
       info   : Connecting to a non-existent database 'www.xxxx.com'
       error  : Routing the query failed. Session will be closed.
      

      So it performs shard map, can see that the requested DB exists, then it reports that database does not exist and refuse the connection

      The settings seems working well, but it cannot process the request. Any idea?
      thanks

      Attachments

        Activity

          People

            markus makela markus makela
            Topogigio Bruno
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.