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

MySQL Server has gone away with connection_keepalive enabled

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 2.4.12
    • N/A
    • readwritesplit
    • None
    • Ubuntu 18.04.5 LTS, MariaDB Galera cluster

    Description

      I have configured connection_keepalive=1 parameter under ReadWriteSplit router, out MariaDB servers are configured with wait_timeout=28800 and interactive_timeout=28800 but we are still experiencing 'MySQL Server has gone away' errors during operation of our cluster. According to documentation, MaxScale should keep connections open by sending periodic keepalive packets. I've checked our MariaDB cluster and can confirm that no nodes were failing to cause this issue, but indeed the disconnect was caused by a long open connection that wasn't sending any queries. Actually, application was sending queries like 'SELECT 1' by it looks like they were routed to slaves allowing master connection to time out.

      Attachments

        Activity

          People

            markus makela markus makela
            Lt_Flash Yury Kirsanov
            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.