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

Maxscale( 2.1.7) no response to query

    XMLWordPrintable

Details

    Description

      we are using the maxscale 2.1.7, but our java application execute a read-only no transaction query ocatinally hang-up to timeout until java application get the exception("SQLSTATE(08S01), Communication link failure"). the wait time is just equal to the maxscale readwritesplit serivce connection_timeout.
      I have tcpdump the network traffic. it seems the java application send the mysql query to maxscale. but maxscale do not response the query!

      Serivce Config
      type=service
      router=readwritesplit
      servers=server1,server2,server3
      user=root
      passwd=xxx
      max_slave-connections=100%
      use_sql_variables_in=master
      max_slave_replication_lag=1
      router_options=master_accept_reads=true,rwsplit_safe_interval=50
      connection_timeout=120

      Attachments

        Activity

          People

            Unassigned Unassigned
            xcheng ichabod
            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.