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

describe table query not routed to shard that contains the schema

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 2.0.2
    • schemarouter
    • None
    • maxscale host: ubuntu 16
      database shards: mysql 5.5 and mysql 5.6

      mysql client: php 5.5 / Zend 1.18 default mysql connector

    Description

      The following message is shown

      SELECT command denied to user 'user'@'host' for table 'mysql_table'
      

      when running one of the following queries

      SHOW COLUMNS IN database.tablename IN database;
      EXPLAIN database.tablename;
      DESCRIBE database.tablename;
      

      This happens when no default database is set or when connected to a default database that is not on the same shard as the database that contains the table.

      Attachments

        Activity

          People

            markus makela markus makela
            b.vanrooijen@vidaxl.com Brian
            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.