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

Cascaded MaxScales throwing errors after 10 Minutes

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Won't Fix
    • Affects Version/s: 1.4.5
    • Fix Version/s: N/A
    • Component/s: readconnroute, schemarouter
    • Labels:
      None
    • Environment:
      Ubuntu 16.04 LTS 64 Bit
      MaxScale from MariaDB repositories
      MariaDB 10.1.22 from MariaDB repositories
      PHP 7.1 / PDO_MYSQL from Ubuntu PPA (ondrej)

      Description

      We are plannign to use a cascaded setup of MaxScales where our Application (Symfony/Doctrine) only knows one central MaxScale instance (maxscale0).

      • We have multiple Galera clusters
      • Each Galera cluster has its own MaxScale in front
      • maxscale0 has access to all other maxscale instances
      • We are using the schemarouter on maxscale0

      Application -> maxscale0 -> maxscale(1-10)
      

      Everything works very well and fast for 10 minutes. After 10 minutes doctrine is starting to throw errors.

      "exception":{"class":"Doctrine\\ORM\\Internal\\Hydration\\HydrationException","message":"The discriminator column \"type\" is missing for \"WM\\UtilsBundle\\Entity\\ConfigTrackingAccount\" using the DQL alias \"r\"."}
      

      With a message from MaxScale

      SQLSTATE[HY000]: General error: 2003 Lost connection to backend server.
      

      Even MaxScale in Debug mode does not show where the problem may come from.
      It seems like, even on long running queries, the database gets lost.

      Configurations

      maxscale0

       
      [MaxScale]
      threads = 4
      auth_connect_timeout = 5
      auth_read_timeout = 10
      auth_write_timeout = 5
      ...
       
      ...
      [ShardAllDatabases]
      type=service
      router=schemarouter
      servers=maxscale1,maxscale2,maxscale3
      user=
      passwd=
      filters=FilterCreateDatabase|FilterDropDatabase
      auth_all_servers=1
      router_options=refresh_interval=5,refresh_databases=1
      ...
       
      ...
      [maxscale1]
      type=server
      address=123.123.123.123
      port=3306
      protocol=MySQLBackend
      ...
      

      maxscaleN

      [MaxScale]
      threads = 2
      auth_connect_timeout = 5
      auth_read_timeout = 10
      auth_write_timeout = 5
      ...
       
      [MySQL]
      type=service
      router=readconnroute
      servers=mariadb1,mariadb2,mariadb3
      enable_root_user=0
      localhost_match_wildcard_host=1
      version_string='MaxScale'
      auth_all_servers=1
      log_auth_warnings=1
      router_options=synced
      user=
      passwd=
       
      [mariadb1]
      type=server
      address=111.111.111.111
      port=3306
      protocol=MySQLBackend
      ...
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            Stefan Koop Stefan Koop
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: