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

schemarouter: duplicate tables found, if table differs on upper lower case only

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.2.2, 6.2.3, 6.2.4
    • Fix Version/s: 2.5.20, 6.3.1
    • Component/s: schemarouter
    • Labels:
      None

      Description

      to reproduce:

      Maxscale with configured schemarouter.

      login into a server belongs to schemarouter:

      create table cds;

      create table t1 (id int);
      create table T1 (id int);

      login with maxscale schemarouter;

      execute

      show shards;

      MariaDB [(none)]> show shards;
      ERROR 2013 (HY000): Lost connection to MySQL server during query
      

      MAxscale error log:

      2022-04-13 06:23:27   error  : (3) [schemarouter] (Scehma-Router-Service); 'cds.T1' found on servers 'server1' and 'server1' for user 'maxuser'@'::ffff:172.26.0.1'.
      2022-04-13 06:23:27   error  : (3) [schemarouter] (Scehma-Router-Service); Duplicate tables found, closing sessio
      

      If server support table case-sensitive tablenames, duplicate table check in schemarouter must also be case-sensitive.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              markus makela markus makela
              Reporter:
              Richard Richard Stracke
              Votes:
              1 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.