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

Idle Client receives an error mysql has gone away after 10 minutes

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 1.2.0
    • N/A
    • Core
    • None
    • The MySQL backend is a Percona XtraDB Cluster with 3 nodes.
      Maxscale has been installed using the debian package.
      All the servers are running DEBIAN WHEEZY 7.8

    Description

      We are using a script that create an index on a large table. The script ends with an error saying "MySQL has gone away" after exactly 10 minutes.
      From what we see in the network packet capture we made, the Maxscale server is sending a TCP FIN/ACK after 10 minutes of inactivity of the client.
      The query to create the index is still running on the cluster after Maxscale has closed the connection with the client and ends correctly.
      If we change the parameters of the script ot execute the query directly on the cluster without using Maxscale, everything is working properly.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              xl Xavier Lassoie
              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.