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

Lost connection to MySQL server during query

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.6, 2.1.9
    • Fix Version/s: 2.1.12
    • Component/s: galeramon, readwritesplit
    • Environment:
      HyperV VM - Operating System: Ubuntu 16.04.3 LTS - Kernel: Linux 4.4.0-92-generic

      MariaDB Cluster: Operating System: Ubuntu 16.04.3 LTS - Kernel: Linux 4.4.0-92-generic - mysql Ver 15.1 Distrib 10.0.31-MariaDB Galera Cluster

      Description

      Hello,

      we have problems with maxscale in front of MariaDB.
      It's configured as multi master with read/write split.

      As you can see in my Log on Line 76 the Connection drop and all Sessions close.
      This results in problems on the attached systems.

      the mariadb server has no corresponding log entry or warning

      2 things we have seen that could maybe be part of the problem:
      1) line 90 - there is no log entry since 15:08:28 - the connection could be open since 14:24 max. (last error)
      2) line 88 - on this session is the second log line of the last query missing (line 56) - on other connection you can see "Route query to..."

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            ahdDGne Dirk Gnedler
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: