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

Routing many prepares statements gives "#HY000Lost connection to backend server"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.3
    • Fix Version/s: 2.1.1
    • Component/s: mariadbbackend
    • Labels:
      None
    • Environment:
      Linux CentOS 6.8, MySQL 5.6.19, php 5.3.3
    • Sprint:
      2017-27, 2017-28, 2017-29

      Description

      We have in production one max scale, routing and connection pooling queries between one web portal and a mysql server.

      When running multiple prepare statements in parallell on the web-portal, maxscale closes the client connection with "#HY000Lost connection to backend server".
      Tcpdump-ing the connections shows that the mysql-server replies correctly, but maxscale closes the client connection with "lost connection".
      This causes the web-client session to fail.

        Attachments

        1. maxscale.cnf
          2 kB
        2. maxscale2.log.gz
          415 kB
        3. tcpstream30-31.pcap
          345 kB

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MXS-619 creating many short sessions in parallel leads to errors

          • Major - Major loss of function.
          • Closed

            Activity

              People

              Assignee:
              markus makela markus makela
              Reporter:
              sjalilund Johan Nilsson
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: