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

clients timeout on net_read_timeout, server thread is in sleep state

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.1.13
    • 2.3.3
    • N/A
    • None
    • MXS-SPRINT-51, MXS-SPRINT-53

    Description

      We have a situation where we the clients timeout, during the timeout the connection on the server is in the sleep state.

      It looks as the server replied to maxscale, but maxscale is not forwarding the reply to the client.

      After some debugging we noticed the following:

      • the server never replies to the sql command (traced via pcap)
      • created a new db with a new table that only has the 2 affected columns, and even with this we can reproduce it
      • the issue seems dependent on the query length
      • 2800 = pass
      • 2892 = fail
      • 8187 = fail
      • 4340 = fail

      Attachments

        1. maxscale.cnf
          1 kB
        2. table.sql
          0.3 kB

        Activity

          People

            markus makela markus makela
            Maikel Punie Maikel Punie
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.