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

readwritesplit module - intensive load - SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 1.2.1, 1.3.0
    • N/A
    • N/A
    • None
    • Ubuntu 14.04 x64_64 LTS + MariaDB Galera + Maxscale

    Description

      The module readwritesplit works perfectly for small queries. An operation of reading 80,000 rows from the db and processing it and writing to the db causes maxscale to return:

      SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query

      Meanwhile if readconnroute module is used for the above purpose. It does it without any errors.

      EDIT1
      ===================
      Please find the configuration I used.
      ---------------------------------------------------------------
      #/etc/maxscale.cnf
      [maxscale]
      threads=4
      auth_connect_timeout=600
      auth_read_timeout=1200
      auth_write_timeout=1200
      maxlog=1
      log_info=1
      log_debug=1

      [Splitter Service]
      type=service
      router=readwritesplit
      servers=devdb01, devdb02
      max_slave_connections=100%
      user=XXX
      passwd=ZZZ
      enable_root_user=true
      localhost_match_wildcard_host=1
      router_options=synced

      [Splitter Listener]
      type=listener
      service=Splitter Service
      protocol=MySQLClient
      port=3306
      address=127.0.0.1

      [devdb01]
      type=server
      address=192.168.0.110
      port=3306
      protocol=MySQLBackend
      [devdb02]
      type=server
      address=192.168.0.111
      port=3306
      protocol=MySQLBackend

      [Galera Monitor]
      type=monitor
      module=galeramon
      disable_master_failback=1
      servers=devdb01, devdb02
      user=XXX
      passwd=ZZZ

      [CLI]
      type=service
      router=cli

      [CLI Listener]
      type=listener
      service=CLI
      protocol=maxscaled
      address=localhost
      port=6603

      Log
      ---------------------------------------------------------
      Please find the log in attachment.

      Attachments

        Issue Links

          Activity

            People

              tturenko Timofey Turenko
              tuxmithun Mithun
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.