Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-23879

server hangs with threadpool,protocol compression and client pipelining

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
    • 10.2.35, 10.3.26, 10.4.16, 10.5.7
    • OTHER
    • None

    Description

      to reproduce

       
      		 
      mysql-test-run.pl compress --mysqld=--thread-handling=pool-of-threads --ps-protocol

      The C/C client uses pipelining for prepared statements, happens packs 2 protocol packets COM_STMT_RESET+COM_STMT_EXECUTE into single compressed packet.

      After executing the COM_STMT_RESET threadpool believes there is no more data from client (it does not check if any unread data is present in THD::NET), so it decides to wait for more client input, while client is waiting for the results of COM_STMT_EXECUTE.

      Attachments

        Activity

          People

            wlad Vladislav Vaintroub
            wlad Vladislav Vaintroub
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.