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

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0.2
    • Component/s: schemarouter
    • Labels:
      None
    • Environment:
      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

            Assignee:
            markus makela markus makela
            Reporter:
            b.vanrooijen@vidaxl.com Brian
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration