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

SchemaRouter unable to process SHOW DATABASES for a lot of schemas

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.3
    • Fix Version/s: 2.2.4
    • Component/s: schemarouter
    • Labels:
      None
    • Environment:
      Ubuntu 16

      Description

      If a lot of schema exists (around 1100 in my test), MaxScale reports errors like the follow, and is unable to run any query:

      2018-03-10 05:56:54   error  : (42) [schemarouter] Fatal error when processing SHOW DATABASES response, closing session.
      2018-03-10 05:57:49   error  : (43) [schemarouter] Fatal error when processing SHOW DATABASES response, closing session.
      2018-03-10 05:58:10   error  : (44) [schemarouter] Fatal error when processing SHOW DATABASES response, closing session.
      2018-03-10 05:58:51   error  : (46) [schemarouter] Fatal error when processing SHOW DATABASES response, closing session.
      

      How to reproduce:
      1) create a lot of schemas:

      for i in `seq 1101 2500` ; do echo "CREATE DATABASE IF NOT EXISTS shard_$i; GRANT ALL PRIVILEGES ON shard_$i.* TO sbtest@127.0.0.1;" ; done | mysql -u root
      

      2) configure MaxScale with schemarouter routing. For simplicity, only 1 backend was configure

      3) try to connect to MaxScale and run a query:

      mysql -u sbtest -psbtest -h 127.0.0.1 -P3310 --ssl-mode=disabled -NB -e "SELECT 1" shard_1500
      mysql: [Warning] Using a password on the command line interface can be insecure.
      ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query
      

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            rcannao René Cannaò
            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.