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

support COM_RESET_CONNECTION

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.2.4
    • Server
    • None
    • 10.2.3-2, 10.2.4-1, 10.2.4-5

    Description

      MySQL added the COM_RESET_CONNECTION command as a lightweight way to reset the session state. This is an extremely important feature to ensure pooled connections have a predictable state. It's also important because MySQL clients are beginning to support this command.

      https://dev.mysql.com/doc/internals/en/com-reset-connection.html
      https://dev.mysql.com/doc/refman/5.7/en/mysql-reset-connection.html

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-9030 RESET CONNECTION command

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            bpage Ben Page created issue -
            bpage Ben Page made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            Priority Critical [ 2 ] Major [ 3 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2 [ 14601 ]
            serg Sergei Golubchik made changes -
            Assignee Oleksandr Byelkin [ sanja ]
            sanja Oleksandr Byelkin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.3-2 [ 105 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            sanja Oleksandr Byelkin added a comment -

            revision-id: dabf6cac60987e88266396a28e40b341899704e6 (mariadb-10.2.2-49-gdabf6ca)
            parent(s): 8303aded294ce905bbc513e7ee42623d5f1fdb50
            committer: Oleksandr Byelkin
            timestamp: 2016-10-17 16:59:36 +0200
            message:

            MDEV-10340: support COM_RESET_CONNECTION

            draft to check with client

            —

            sanja Oleksandr Byelkin added a comment - revision-id: dabf6cac60987e88266396a28e40b341899704e6 (mariadb-10.2.2-49-gdabf6ca) parent(s): 8303aded294ce905bbc513e7ee42623d5f1fdb50 committer: Oleksandr Byelkin timestamp: 2016-10-17 16:59:36 +0200 message: MDEV-10340 : support COM_RESET_CONNECTION draft to check with client —
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Oleksandr Byelkin [ sanja ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.3-2 [ 105 ] 10.2.3-2, 10.2.4-1 [ 105, 121 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            sanja Oleksandr Byelkin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            sanja Oleksandr Byelkin added a comment -

            revision-id: e6875772b0d65a6341456a6f4aca3353bbdae3e4 (mariadb-10.2.2-131-ge687577)
            parent(s): 7ca1e2abad42a7436e6b668b4568d6fadc2ca165
            committer: Oleksandr Byelkin
            timestamp: 2016-12-12 14:41:45 +0100
            message:

            MDEV-10340: support COM_RESET_CONNECTION

            draft to check with client

            —

            sanja Oleksandr Byelkin added a comment - revision-id: e6875772b0d65a6341456a6f4aca3353bbdae3e4 (mariadb-10.2.2-131-ge687577) parent(s): 7ca1e2abad42a7436e6b668b4568d6fadc2ca165 committer: Oleksandr Byelkin timestamp: 2016-12-12 14:41:45 +0100 message: MDEV-10340 : support COM_RESET_CONNECTION draft to check with client —
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.3-2, 10.2.4-1 [ 105, 121 ] 10.2.3-2, 10.2.4-1, 10.2.4-5 [ 105, 121, 125 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            serg Sergei Golubchik added a comment -

            please add test cases. I think you can do it with simple_command from mysql_client_test.c

            serg Sergei Golubchik added a comment - please add test cases. I think you can do it with simple_command from mysql_client_test.c
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Oleksandr Byelkin [ sanja ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            sanja Oleksandr Byelkin added a comment -

            Not really (nead some cleanup on client side), but I have other patch for client and even test there (Georg was reviewing it, I'll send it)

            sanja Oleksandr Byelkin added a comment - Not really (nead some cleanup on client side), but I have other patch for client and even test there (Georg was reviewing it, I'll send it)
            sanja Oleksandr Byelkin made changes -
            Attachment client-MDEV-10340.diff [ 43102 ]
            sanja Oleksandr Byelkin added a comment -

            I attached client changes

            sanja Oleksandr Byelkin added a comment - I attached client changes
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Sergei Golubchik [ serg ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Oleksandr Byelkin [ sanja ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            sanja Oleksandr Byelkin made changes -
            Component/s Server [ 13907 ]
            Fix Version/s 10.2.4 [ 22116 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 76356 ] MariaDB v4 [ 132912 ]

            People

              sanja Oleksandr Byelkin
              bpage Ben Page
              Votes:
              1 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.